=== COMPREHENSIVE RECONCILIATION ANALYSIS ===
Generated: 2026-02-03 21:13:10

TOTAL CONFIRMED PAID ORDERS: 0

=== ORDER CATEGORIZATION ===
with_revolut_id     :   0 orders, £0.00
pos_no_id           :   0 orders, £0.00
bank_transfer       :   0 orders, £0.00
cash                :   0 orders, £0.00
complimentary       :   0 orders, £0.00
split               :   0 orders, £0.00
other               :   0 orders, £0.00

=== EXACT MATCH ANALYSIS (42 matches) ===
Total matched amount: £86,600.00
Remaining unmatched DB POS: £-86,600.00

=== ORPHANED PAYMENT ANALYSIS ===
test_transactions        :  28 payments, £0.51
already_identified       :   2 payments, £51,800.00
pre_event_other          :  22 payments, £34,301.00
event_days_matched       :  42 payments, £86,600.00
event_days_unmatched     :  54 payments, £51,911.00

=== PRE-EVENT ORPHANED (needs investigation) ===
Count: 22, Total: £34,301.00

£3,000.00 - NO CARDHOLDER - 2025-12-09 (Webhook failure recovery - refund)
£3,000.00 - NO CARDHOLDER - 2025-11-14 (Global Gala Event Booking)
£2,400.00 - abdulraman alqurashi - 2025-11-14 (Global Gala Event Booking)
£2,400.00 - abdulraman alqurashi - 2025-11-14 (Global Gala Event Booking)
£2,400.00 - abdulraman alqurashi - 2025-11-14 (Global Gala Event Booking)
£2,000.00 - ahmed althani - 2025-11-14 (Global Gala Event Booking)
£1,950.00 - Abdulaziz almeshari - 2025-11-14 (Global Gala Event Booking)
£1,800.00 - NO CARDHOLDER - 2025-12-10 (Customer Requested Refund)
£1,800.00 - Meshari Alkharashi - 2025-11-13 (Global Gala Event Booking)
£1,500.00 - NO CARDHOLDER - 2025-12-27 ()
£1,500.00 - Awad Alharthi - 2025-11-14 (Global Gala Event Booking)
£1,400.00 - NO CARDHOLDER - 2025-12-15 (Customer requested refund)
£1,400.00 - Raghad Alruwaudan - 2025-11-14 (Global Gala Event Booking)
£1,200.00 - Saja Ghaleb - 2025-11-14 (Global Gala Event Booking)
£1,100.00 - NO CARDHOLDER - 2025-12-21 (Booking error - seats not available)
£1,100.00 - NO CARDHOLDER - 2025-12-21 (Booking error - seats not available)
£1,100.00 - NO CARDHOLDER - 2025-12-21 (Global Gala Event Booking)
£1,100.00 - AbdulMalik Al hadi - 2025-12-21 (Global Gala Event Booking)
£750.00 - Mohammad Alajmi - 2025-11-14 (Global Gala Event Booking)
£700.00 - NO CARDHOLDER - 2025-12-16 (Customer Request Refund)
£700.00 - Mohammd Alderei - 2025-11-14 (Global Gala Event Booking)
£1.00 - NO CARDHOLDER - 2025-12-08 (Custom product)


=== SQL FIXES (for later application) ===
-- 1. Link 42 exact matches to Revolut IDs
-- Order 713 (ahmad ahli) → Revolut 69540643-30fd-a044-a25e-652ea3fc233f
UPDATE orders SET revolut_payment_id = '69540643-30fd-a044-a25e-652ea3fc233f' WHERE id = 713;

-- Order 723 (Ahmed Alsayadi) → Revolut 6953e48a-2fe5-a7a4-a1c8-a4f1ef8a8f8a
UPDATE orders SET revolut_payment_id = '6953e48a-2fe5-a7a4-a1c8-a4f1ef8a8f8a' WHERE id = 723;

-- Order 668 (Sheikh Zayed Al Hamed) → Revolut 6952af5a-bea3-a0f0-b6ad-e678ef337b0c
UPDATE orders SET revolut_payment_id = '6952af5a-bea3-a0f0-b6ad-e678ef337b0c' WHERE id = 668;

-- Order 697 (charlie farrell) → Revolut 6952f1f5-2fff-adb0-8ecd-f83895c35d7b
UPDATE orders SET revolut_payment_id = '6952f1f5-2fff-adb0-8ecd-f83895c35d7b' WHERE id = 697;

-- Order 694 (hamed alghamdi) → Revolut 6952e56c-fa81-afb2-a1ae-784991e57395
UPDATE orders SET revolut_payment_id = '6952e56c-fa81-afb2-a1ae-784991e57395' WHERE id = 694;

-- Order 670 (ahmed saleh) → Revolut 6952b279-3b07-aca2-926b-5aa48c90d6db
UPDATE orders SET revolut_payment_id = '6952b279-3b07-aca2-926b-5aa48c90d6db' WHERE id = 670;

-- Order 701 (hessa) → Revolut 6952a592-f13d-a9f4-8c22-d55a02edd7ec
UPDATE orders SET revolut_payment_id = '6952a592-f13d-a9f4-8c22-d55a02edd7ec' WHERE id = 701;

-- Order 665 (hana ghodran) → Revolut 69528997-25ea-a4e4-af5f-639157aa67eb
UPDATE orders SET revolut_payment_id = '69528997-25ea-a4e4-af5f-639157aa67eb' WHERE id = 665;

-- Order 708 (areej alkhalis) → Revolut 69544586-222d-ad81-8829-93fe0fb8ec25
UPDATE orders SET revolut_payment_id = '69544586-222d-ad81-8829-93fe0fb8ec25' WHERE id = 708;

-- Order 756 (lamia alanhadi) → Revolut 6953b846-f033-a28d-913b-e568da50a8ca
UPDATE orders SET revolut_payment_id = '6953b846-f033-a28d-913b-e568da50a8ca' WHERE id = 756;

-- Order 664 (Norah Alkuait) → Revolut 69530b23-e76c-a0df-b059-c544b3f9b448
UPDATE orders SET revolut_payment_id = '69530b23-e76c-a0df-b059-c544b3f9b448' WHERE id = 664;

-- Order 669 (Salman Al Saud) → Revolut 6952d224-c120-a5ec-8f79-8ebf3be4b365
UPDATE orders SET revolut_payment_id = '6952d224-c120-a5ec-8f79-8ebf3be4b365' WHERE id = 669;

-- Order 678 (hafid alenizi) → Revolut 6952b89d-4a9f-a990-86dc-5283e1552df7
UPDATE orders SET revolut_payment_id = '6952b89d-4a9f-a990-86dc-5283e1552df7' WHERE id = 678;

-- Order 689 (Mohammed AlRayyani) → Revolut 6952a348-3627-a0b5-8eae-27e7218b5dcd
UPDATE orders SET revolut_payment_id = '6952a348-3627-a0b5-8eae-27e7218b5dcd' WHERE id = 689;

-- Order 698 (Rashid alhajri) → Revolut 69528304-7286-a768-8f68-6c751bbde9cf
UPDATE orders SET revolut_payment_id = '69528304-7286-a768-8f68-6c751bbde9cf' WHERE id = 698;

-- Order 704 (mariam omar) → Revolut 69542eae-ac79-a4bf-b144-1d1480cf4ead
UPDATE orders SET revolut_payment_id = '69542eae-ac79-a4bf-b144-1d1480cf4ead' WHERE id = 704;

-- Order 709 (ahmed sultan) → Revolut 69542be4-39e1-a717-aa70-2d61d0b1ab25
UPDATE orders SET revolut_payment_id = '69542be4-39e1-a717-aa70-2d61d0b1ab25' WHERE id = 709;

-- Order 716 (Khaled Al anzi) → Revolut 6954245e-5947-ab6d-a27f-8c7514236443
UPDATE orders SET revolut_payment_id = '6954245e-5947-ab6d-a27f-8c7514236443' WHERE id = 716;

-- Order 719 (Albeer Algamdi) → Revolut 69542435-b27a-ac3f-80eb-607cd513850d
UPDATE orders SET revolut_payment_id = '69542435-b27a-ac3f-80eb-607cd513850d' WHERE id = 719;

-- Order 720 (yasser alsalah) → Revolut 695418cf-d9ce-a4ee-9bfc-3220e413dde7
UPDATE orders SET revolut_payment_id = '695418cf-d9ce-a4ee-9bfc-3220e413dde7' WHERE id = 720;

-- Order 722 (Ibrahim Zaid) → Revolut 69540577-47c9-a48e-8f90-ff6c98732fd3
UPDATE orders SET revolut_payment_id = '69540577-47c9-a48e-8f90-ff6c98732fd3' WHERE id = 722;

-- Order 728 (fahad alanazi) → Revolut 695400b2-0e03-a128-9dd6-b21e8f681e30
UPDATE orders SET revolut_payment_id = '695400b2-0e03-a128-9dd6-b21e8f681e30' WHERE id = 728;

-- Order 731 (saud al thani) → Revolut 6953fa24-195d-a715-83d7-c5cfe0fef174
UPDATE orders SET revolut_payment_id = '6953fa24-195d-a715-83d7-c5cfe0fef174' WHERE id = 731;

-- Order 732 (latifaalnaemi) → Revolut 6953f5dd-12af-a097-bd33-e56e4653886d
UPDATE orders SET revolut_payment_id = '6953f5dd-12af-a097-bd33-e56e4653886d' WHERE id = 732;

-- Order 733 (saud alqhatani) → Revolut 6953f5cc-8932-adee-9d7c-d58b919780c2
UPDATE orders SET revolut_payment_id = '6953f5cc-8932-adee-9d7c-d58b919780c2' WHERE id = 733;

-- Order 736 (Abdulqader al-ahmad) → Revolut 6953ef03-4f69-a54f-9663-b1bcf2966d7b
UPDATE orders SET revolut_payment_id = '6953ef03-4f69-a54f-9663-b1bcf2966d7b' WHERE id = 736;

-- Order 738 (Khalid Alshahrani) → Revolut 6953d26f-e708-a41f-a80d-ef3fd2b3a325
UPDATE orders SET revolut_payment_id = '6953d26f-e708-a41f-a80d-ef3fd2b3a325' WHERE id = 738;

-- Order 730 (abdulla alajmi) → Revolut 69544fb6-858d-ab9b-8832-19705406f3e1
UPDATE orders SET revolut_payment_id = '69544fb6-858d-ab9b-8832-19705406f3e1' WHERE id = 730;

-- Order 725 (nouf alsaud) → Revolut 69544866-dd90-a782-9526-8fa36d2c0d27
UPDATE orders SET revolut_payment_id = '69544866-dd90-a782-9526-8fa36d2c0d27' WHERE id = 725;

-- Order 666 (maryam alsubaie) → Revolut 695314cb-8925-a529-8c09-588759a27998
UPDATE orders SET revolut_payment_id = '695314cb-8925-a529-8c09-588759a27998' WHERE id = 666;

-- Order 667 (Noor Salem) → Revolut 6952fcff-a7bd-a7be-be4b-683ec655531c
UPDATE orders SET revolut_payment_id = '6952fcff-a7bd-a7be-be4b-683ec655531c' WHERE id = 667;

-- Order 676 (Fadwa Saad) → Revolut 6952f6eb-643e-a35f-a0c1-dfce873d86b2
UPDATE orders SET revolut_payment_id = '6952f6eb-643e-a35f-a0c1-dfce873d86b2' WHERE id = 676;

-- Order 677 (Mohamed Saber) → Revolut 6952f6d3-fd07-a60e-877a-17416d38157c
UPDATE orders SET revolut_payment_id = '6952f6d3-fd07-a60e-877a-17416d38157c' WHERE id = 677;

-- Order 693 (narmin eyyubova) → Revolut 6952e90b-3b6f-aebe-bd8f-70e97e4bd81c
UPDATE orders SET revolut_payment_id = '6952e90b-3b6f-aebe-bd8f-70e97e4bd81c' WHERE id = 693;

-- Order 703 (maryam al anazi) → Revolut 6952e6ab-c7f2-a2d1-a1b0-80add6d273bc
UPDATE orders SET revolut_payment_id = '6952e6ab-c7f2-a2d1-a1b0-80add6d273bc' WHERE id = 703;

-- Order 717 (Khaled al zani) → Revolut 69545e84-88f5-a2d3-907f-eab5de86f523
UPDATE orders SET revolut_payment_id = '69545e84-88f5-a2d3-907f-eab5de86f523' WHERE id = 717;

-- Order 734 (Munira Almutib) → Revolut 69545a04-fcba-ad96-9f8e-eedbf95e89f0
UPDATE orders SET revolut_payment_id = '69545a04-fcba-ad96-9f8e-eedbf95e89f0' WHERE id = 734;

-- Order 735 (Hussain Mohammad) → Revolut 69545811-df33-afdf-84db-6fe206b06d7f
UPDATE orders SET revolut_payment_id = '69545811-df33-afdf-84db-6fe206b06d7f' WHERE id = 735;

-- Order 742 (Nasser Ahmed) → Revolut 6954450f-c51a-a127-8734-df3f5d6f7ca2
UPDATE orders SET revolut_payment_id = '6954450f-c51a-a127-8734-df3f5d6f7ca2' WHERE id = 742;

-- Order 761 (abdullah alenezi) → Revolut 69543666-7d2c-ad48-92ae-eaa326f3a11e
UPDATE orders SET revolut_payment_id = '69543666-7d2c-ad48-92ae-eaa326f3a11e' WHERE id = 761;

-- Order 762 (Mohammad salman) → Revolut 6954346d-21e1-a07b-b714-aeb9c622cb62
UPDATE orders SET revolut_payment_id = '6954346d-21e1-a07b-b714-aeb9c622cb62' WHERE id = 762;

-- Order 763 (sarah ali) → Revolut 695429cf-1f89-ac16-be98-83c1c3a4b1ae
UPDATE orders SET revolut_payment_id = '695429cf-1f89-ac16-be98-83c1c3a4b1ae' WHERE id = 763;

<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1">

        <title>Server Error</title>

        <style>
            /*! normalize.css v8.0.1 | MIT License | github.com/necolas/normalize.css */html{line-height:1.15;-webkit-text-size-adjust:100%}body{margin:0}a{background-color:transparent}code{font-family:monospace,monospace;font-size:1em}[hidden]{display:none}html{font-family:system-ui,-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Helvetica Neue,Arial,Noto Sans,sans-serif,Apple Color Emoji,Segoe UI Emoji,Segoe UI Symbol,Noto Color Emoji;line-height:1.5}*,:after,:before{box-sizing:border-box;border:0 solid #e2e8f0}a{color:inherit;text-decoration:inherit}code{font-family:Menlo,Monaco,Consolas,Liberation Mono,Courier New,monospace}svg,video{display:block;vertical-align:middle}video{max-width:100%;height:auto}.bg-white{--bg-opacity:1;background-color:#fff;background-color:rgba(255,255,255,var(--bg-opacity))}.bg-gray-100{--bg-opacity:1;background-color:#f7fafc;background-color:rgba(247,250,252,var(--bg-opacity))}.border-gray-200{--border-opacity:1;border-color:#edf2f7;border-color:rgba(237,242,247,var(--border-opacity))}.border-gray-400{--border-opacity:1;border-color:#cbd5e0;border-color:rgba(203,213,224,var(--border-opacity))}.border-t{border-top-width:1px}.border-r{border-right-width:1px}.flex{display:flex}.grid{display:grid}.hidden{display:none}.items-center{align-items:center}.justify-center{justify-content:center}.font-semibold{font-weight:600}.h-5{height:1.25rem}.h-8{height:2rem}.h-16{height:4rem}.text-sm{font-size:.875rem}.text-lg{font-size:1.125rem}.leading-7{line-height:1.75rem}.mx-auto{margin-left:auto;margin-right:auto}.ml-1{margin-left:.25rem}.mt-2{margin-top:.5rem}.mr-2{margin-right:.5rem}.ml-2{margin-left:.5rem}.mt-4{margin-top:1rem}.ml-4{margin-left:1rem}.mt-8{margin-top:2rem}.ml-12{margin-left:3rem}.-mt-px{margin-top:-1px}.max-w-xl{max-width:36rem}.max-w-6xl{max-width:72rem}.min-h-screen{min-height:100vh}.overflow-hidden{overflow:hidden}.p-6{padding:1.5rem}.py-4{padding-top:1rem;padding-bottom:1rem}.px-4{padding-left:1rem;padding-right:1rem}.px-6{padding-left:1.5rem;padding-right:1.5rem}.pt-8{padding-top:2rem}.fixed{position:fixed}.relative{position:relative}.top-0{top:0}.right-0{right:0}.shadow{box-shadow:0 1px 3px 0 rgba(0,0,0,.1),0 1px 2px 0 rgba(0,0,0,.06)}.text-center{text-align:center}.text-gray-200{--text-opacity:1;color:#edf2f7;color:rgba(237,242,247,var(--text-opacity))}.text-gray-300{--text-opacity:1;color:#e2e8f0;color:rgba(226,232,240,var(--text-opacity))}.text-gray-400{--text-opacity:1;color:#cbd5e0;color:rgba(203,213,224,var(--text-opacity))}.text-gray-500{--text-opacity:1;color:#a0aec0;color:rgba(160,174,192,var(--text-opacity))}.text-gray-600{--text-opacity:1;color:#718096;color:rgba(113,128,150,var(--text-opacity))}.text-gray-700{--text-opacity:1;color:#4a5568;color:rgba(74,85,104,var(--text-opacity))}.text-gray-900{--text-opacity:1;color:#1a202c;color:rgba(26,32,44,var(--text-opacity))}.uppercase{text-transform:uppercase}.underline{text-decoration:underline}.antialiased{-webkit-font-smoothing:antialiased;-moz-osx-font-smoothing:grayscale}.tracking-wider{letter-spacing:.05em}.w-5{width:1.25rem}.w-8{width:2rem}.w-auto{width:auto}.grid-cols-1{grid-template-columns:repeat(1,minmax(0,1fr))}@-webkit-keyframes spin{0%{transform:rotate(0deg)}to{transform:rotate(1turn)}}@keyframes spin{0%{transform:rotate(0deg)}to{transform:rotate(1turn)}}@-webkit-keyframes ping{0%{transform:scale(1);opacity:1}75%,to{transform:scale(2);opacity:0}}@keyframes ping{0%{transform:scale(1);opacity:1}75%,to{transform:scale(2);opacity:0}}@-webkit-keyframes pulse{0%,to{opacity:1}50%{opacity:.5}}@keyframes pulse{0%,to{opacity:1}50%{opacity:.5}}@-webkit-keyframes bounce{0%,to{transform:translateY(-25%);-webkit-animation-timing-function:cubic-bezier(.8,0,1,1);animation-timing-function:cubic-bezier(.8,0,1,1)}50%{transform:translateY(0);-webkit-animation-timing-function:cubic-bezier(0,0,.2,1);animation-timing-function:cubic-bezier(0,0,.2,1)}}@keyframes bounce{0%,to{transform:translateY(-25%);-webkit-animation-timing-function:cubic-bezier(.8,0,1,1);animation-timing-function:cubic-bezier(.8,0,1,1)}50%{transform:translateY(0);-webkit-animation-timing-function:cubic-bezier(0,0,.2,1);animation-timing-function:cubic-bezier(0,0,.2,1)}}@media (min-width:640px){.sm\:rounded-lg{border-radius:.5rem}.sm\:block{display:block}.sm\:items-center{align-items:center}.sm\:justify-start{justify-content:flex-start}.sm\:justify-between{justify-content:space-between}.sm\:h-20{height:5rem}.sm\:ml-0{margin-left:0}.sm\:px-6{padding-left:1.5rem;padding-right:1.5rem}.sm\:pt-0{padding-top:0}.sm\:text-left{text-align:left}.sm\:text-right{text-align:right}}@media (min-width:768px){.md\:border-t-0{border-top-width:0}.md\:border-l{border-left-width:1px}.md\:grid-cols-2{grid-template-columns:repeat(2,minmax(0,1fr))}}@media (min-width:1024px){.lg\:px-8{padding-left:2rem;padding-right:2rem}}@media (prefers-color-scheme:dark){.dark\:bg-gray-800{--bg-opacity:1;background-color:#2d3748;background-color:rgba(45,55,72,var(--bg-opacity))}.dark\:bg-gray-900{--bg-opacity:1;background-color:#1a202c;background-color:rgba(26,32,44,var(--bg-opacity))}.dark\:border-gray-700{--border-opacity:1;border-color:#4a5568;border-color:rgba(74,85,104,var(--border-opacity))}.dark\:text-white{--text-opacity:1;color:#fff;color:rgba(255,255,255,var(--text-opacity))}.dark\:text-gray-400{--text-opacity:1;color:#cbd5e0;color:rgba(203,213,224,var(--text-opacity))}}
        </style>

        <style>
            body {
                font-family: ui-sans-serif, system-ui, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, "Noto Sans", sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji";
            }
        </style>
    </head>
    <body class="antialiased">
        <div class="relative flex items-top justify-center min-h-screen bg-gray-100 dark:bg-gray-900 sm:items-center sm:pt-0">
            <div class="max-w-xl mx-auto sm:px-6 lg:px-8">
                <div class="flex items-center pt-8 sm:justify-start sm:pt-0">
                    <div class="px-4 text-lg text-gray-500 border-r border-gray-400 tracking-wider">
                        500                    </div>

                    <div class="ml-4 text-lg text-gray-500 uppercase tracking-wider">
                        Server Error                    </div>
                </div>
            </div>
        </div>
    </body>
</html>