# CRITICAL: Door Sales Without Orders

**Event:** Mohamed Abdo NYE 2025
**Issue Identified:** 5 January 2026

---

## THE PROBLEM

**54 Revolut POS payments totaling £51,911 have NO corresponding order in the database.**

These are confirmed card charges via Revolut Reader at the venue that:
- ✅ Money was collected (in Revolut)
- ❌ NO order created in system
- ❌ NO tickets issued
- ❌ NO seat allocation
- ❌ NO customer details captured

---

## BREAKDOWN BY DATE

| Date | Payments | Amount | % of Problem |
|------|----------|--------|--------------|
| Dec 28 | 4 | £7,361 | 14% |
| Dec 29 | 14 | £14,350 | 28% |
| **Dec 30** | **32** | **£29,200** | **56%** |
| Dec 31 | 4 | £1,000 | 2% |
| **TOTAL** | **54** | **£51,911** | 100% |

Dec 30 (event night) was the worst - 32 payments with no orders.

---

## BREAKDOWN BY AMOUNT

| Amount | Count | Total | Likely |
|--------|-------|-------|--------|
| £1,000 | 15 | £15,000 | Premium tickets |
| £500 | 11 | £5,500 | Standard tickets |
| £2,100 | 3 | £6,300 | 2-3 tickets per txn |
| £700 | 5 | £3,500 | Single tickets |
| £1,400 | 2 | £2,800 | 2 tickets |
| £600 | 2 | £1,200 | Single tickets |
| Other | 16 | £17,611 | Various |

The amounts align with ticket pricing, confirming these were ticket sales.

---

## WHAT HAPPENED

**Likely scenario:**
1. Door staff used Revolut Reader to take card payment
2. Either:
   - Used "Custom Amount" on Reader (bypasses system)
   - Or forgot to create order in ticketing system
   - Or system was slow/down so they skipped it
3. Customer paid and entered venue
4. No ticket/order record created

**Evidence:**
- All orphaned payments show:
  - Description: "Custom product" or "MANUAL"
  - Payment method: "CARD_PRESENT"
  - No metadata (no order ID, no customer info)
  - No hold_token (not linked to booking system)

---

## IMPLICATIONS

### 1. Revenue Tracking
- £51,911 IS in Revolut (money received) ✅
- But system shows nothing for it ❌
- Reports would under-count by £51,911

### 2. Ticket Inventory
- Were tickets even issued to these 54 customers?
- If not, customers paid but have no proof of purchase
- If yes (paper tickets?), no digital record exists

### 3. Seat Allocation
- Without orders, we don't know which seats were sold
- Could cause overbooking issues
- Can't verify attendance for these sales

### 4. Customer Service
- No customer contact info captured
- Can't send confirmations, updates, or follow-ups
- Can't verify complaints ("I paid but...")

---

## TWO-WAY MISMATCH SUMMARY

| Issue | Count | Amount | Status |
|-------|-------|--------|--------|
| **Revolut charges WITHOUT DB orders** | 54 | £51,911 | ⚠️ CRITICAL |
| DB orders WITHOUT Revolut charges | 34 | £102,950 | ⚠️ Investigate |

The £102,950 in DB orders without Revolut charges could be:
- Split payments (card portion via different method)
- Manual entries never actually charged
- Orders marked paid incorrectly

---

## RECOMMENDATIONS

### Immediate
1. **Review the 54 orphaned payments** - Can any be matched by time to specific customers?
2. **Check physical ticket stubs** - Were paper tickets issued for these sales?
3. **Staff interviews** - Who was at door on Dec 29-30? What process did they use?

### Process Improvements
1. **Disable Custom Amount** on Revolut Reader (force system integration)
2. **Require order number** before payment can be processed
3. **Real-time reconciliation alerts** when payments don't match orders
4. **Training** for door staff on proper POS procedure

### For This Event
1. Accept that £51,911 is "untracked revenue"
2. Include in financials but note as "door sales - no order record"
3. Add to lessons learned for next event

---

## ORPHANED PAYMENT DETAILS

Full list of 54 payments (event days only, excluding matched):

```
Dec 28: 4 payments
  £2,950 - 18:37
  £2,900 - 18:49
  £1,450 - 18:56
  £60 - 15:40

Dec 29: 14 payments
  £2,100 x 2 - evening
  £1,700 - 23:30
  £1,000 x 3
  £700 x 2
  £500 x 4
  £400, £310, £300

Dec 30: 32 payments
  £4,200 - 17:27
  £1,400 x 2 - 17:26
  £1,200 - 23:08
  £1,000 x 11
  £950, £700 x 3, £600 x 2
  £500 x 6
  £25 x 2 (likely test)

Dec 31: 4 payments
  £500 x 2
  £450
  £25 x 2 (test)
```

---

*Report generated from Revolut API forensic analysis*