EU web shop, Stripe payouts
A made-up company, September 2026. Every discrepancy was planted on purpose and found by SQL; differences reconcile each level to the next, to the cent.
The books are a ledger export, usually from Xero, QuickBooks or NetSuite; the demo uses one common layout for every company.
18discrepancies
€684.51short
€535.30over
€3,347.78in transit
Bridge: ledger → platform → payouts → bank
| Step | Level | Amount |
|---|---|---|
| ledger | €115,824.69 | |
| amount mismatch | operation | −€72.00 |
| duplicate in the ledger | operation | −€358.11 |
| fee not booked | operation | −€11.92 |
| currency rate | operation | −€4.17 |
| missing in the ledger | operation | €189.45 |
| partial refund | operation | €345.85 |
| charge not booked | operation | −€238.31 |
| platform | €115,675.48 | |
| payouts | €115,675.48 | |
| in transit | bank | −€3,347.78 |
| bank | €112,327.70 |
Discrepancies
| Level | Cause | Key | Kind | Difference | Effect | Explanation |
|---|---|---|---|---|---|---|
| bank | in transit | po_x27gpb7ZRNtvZT1aM2xg7hbA | payout | −€3,347.78 | timing | September payout booked by the bank in October. |
| operation | amount mismatch | EU-10222 | sale | −€63.00 | short | Amounts differ; no other cause found. Digits transposed: likely a manual edit. |
| operation | amount mismatch | EU-10227 | sale | −€9.00 | short | Amounts differ; no other cause found. Digits transposed: likely a manual edit. |
| operation | duplicate in the ledger | EU-10058 | sale | −€122.71 | short | Booked twice in the ledger; the platform has it once. |
| operation | duplicate in the ledger | EU-10172 | sale | −€128.87 | short | Booked twice in the ledger; the platform has it once. |
| operation | duplicate in the ledger | EU-10338 | sale | −€106.53 | short | Booked twice in the ledger; the platform has it once. |
| operation | fee not booked | EU-10027 | fee | −€2.04 | short | Platform fee not booked in the ledger. |
| operation | fee not booked | EU-10116 | fee | −€3.88 | short | Platform fee not booked in the ledger. |
| operation | fee not booked | EU-10286 | fee | −€6.00 | short | Platform fee not booked in the ledger. |
| operation | currency rate | EU-10002 | sale | −€1.26 | short | Customer paid in another currency; the books likely used another rate. |
| operation | currency rate | EU-10011 | sale | −€2.91 | short | Customer paid in another currency; the books likely used another rate. |
| operation | missing in the ledger | EU-10301 | sale | €102.27 | over | On the platform, not in the ledger. |
| operation | missing in the ledger | EU-10342 | sale | €37.67 | over | On the platform, not in the ledger. |
| operation | missing in the ledger | EU-10481 | sale | €49.51 | over | On the platform, not in the ledger. |
| operation | partial refund | EU-10404 | refund | €210.62 | over | Platform refunded less than the ledger booked. |
| operation | partial refund | EU-10503 | refund | €135.23 | over | Platform refunded less than the ledger booked. |
| operation | charge not booked | du_3y5OAl4YzraD5W | charge | −€45.85 | short | Platform charge not booked in the ledger. |
| operation | charge not booked | du_4dBe9eVTUVwaeO | charge | −€192.46 | short | Platform charge not booked in the ledger. |