The $14,000 Reconciliation Gap
How an unreconciled delivery platform ledger in a Charlotte fast-casual restaurant chain exposed $14,218.40 in double-counted revenue and $4,850 in unbooked merchant commissions.
Initial Problem & Operational Context
In August 2026, a regional four-location fast-casual restaurant operator headquartered in Charlotte approached Stonemill's Accounting Practicum team for assistance with a persistent ledger discrepancy. The company's general ledger reflected an ending cash balance of $55,418.40, while the primary operating bank account held only $41,200.00βa variance of $14,218.40 accumulated across four months.
The company's in-house bookkeeper had been recording POS transaction totals as gross cash receipts on the date of order entry. However, when weekly ACH disbursements from DoorDash and UberEats arrived in the bank account, they were again booked as cash sales, double-counting the revenue and completely omitting the 20% platform service fees deducted prior to bank transfer.
Maya Lin's Diagnostic Breakthrough
"The moment we mapped the POS batch IDs against the bank ACH deposit descriptions, the pattern was unmistakable. Every DoorDash payout was being entered twice: once as an expected sale at $1,240.50, and again when the net deposit of $992.40 cleared. The difference wasn't missing cashβit was double-counted revenue and $248.10 in unexpensed delivery platform fees."
Three-Point Corrective Action Framework
To eliminate the variance and prevent recurrence, Maya Lin implemented a standardized three-point accounting protocol:
1. Delivery Clearing Sub-Ledger
Created dedicated GL Account 1050 (Delivery Clearing). POS orders post as Debits to 1050 and Credits to Food Sales, isolating receivables from cash.
2. Automatic Commission Expense
When bank deposits arrive, the net cash debits Operating Cash, the 20% service fee debits Account 6240 (Delivery Commissions), and Account 1050 credits to zero.
3. Daily 3-Way Reconciliation
Instituted a daily verification checklist comparing POS orders, platform merchant portal statements, and bank ACH credit records.
Comparative Audit Results (Illustrative 10-Batch Data)
| Batch ID | Channel | Gross POS Order | Platform Commission (20%) | Net Bank Deposit | Initial Booked Cash | Corrected GL Status |
|---|---|---|---|---|---|---|
| TX-8801 | DoorDash | $1,240.50 | $248.10 | $992.40 | $1,240.50 | Reconciled to Clearing |
| TX-8802 | UberEats | $1,580.00 | $316.00 | $1,264.00 | $1,580.00 | Reconciled to Clearing |
| TX-8803 | In-Store POS | $2,140.20 | $0.00 | $2,140.20 | $2,140.20 | Matched (100%) |
| TX-8804 | DoorDash | $980.40 | $196.08 | $784.32 | $980.40 | Reconciled to Clearing |
| TX-8805 | UberEats | $1,820.00 | $364.00 | $1,456.00 | $1,820.00 | Reconciled to Clearing |
Download Full Case Materials & Raw Dataset
Inspect the comprehensive case study briefing (TXT) and complete 10-batch transaction table (CSV).