← All demos

Reconciliation · Sample output

The number, and what it could not prove

Every order exported from two marketplaces, checked against a bank statement. The platforms report order value their own way and settle on their own schedule, so the three never agree — and nothing tells a seller which side is wrong. This produces one number, then states plainly everything it could not place.

Dapur Senja 2026-09-28 to 2026-10-18 · illustrative figures
Net earned Rp 49.655.774 after Rp 2.872.226 of platform fees
Paid out Rp 52.337.774 across 79 bank credits
Variance Rp -2.682.000 equals the unexplained credits, exactly
Products identified 95% 62 orders across two channels

How the number is built

Line Amount
Gross salesRp 52.805.000
Platform fees, nine componentsRp -2.872.226
Your own discountsRp -277.000
Platform-funded vouchersRp -683.000
Net earnedRp 49.655.774

Platform-funded vouchers are shown but not deducted from income. The platform bears them, and counting them as money that never arrived is the most common way a seller overstates their own cost.

Where it came from

Channel Net
shoptopediaRp 26.274.375
shopeeRp 23.381.399

By product, across both channels

Canonical product Net
TER-1Rp 33.459.200
ABM-12Rp 6.693.300
RD-500Rp 2.674.720
NKF-1Rp 2.536.800
KLC-200Rp 1.511.045
SKL-250Rp 1.263.400

Each marketplace uses its own seller-authored SKU strings, and nothing requires them to agree. Without a mapping every cross-channel figure is wrong in a way that is invisible, because each channel's own total still looks correct.

Money that arrived unexplained

Received Bank memo Amount
2026-10-15TRANSFER MASUK LAIN-LAINRp 1.500.000

Each of these is a real answer you did not have: money that arrived with no order behind it, a period boundary, or an adjustment someone made quietly. The variance above is exactly these amounts.

Arrived next statement

19 credit(s) totalling 7446872 arrived after 2026-10-18 and settle orders from this period: SHOPEE COD 12, SHOPEE COD 14, SHOPEE COD BALANCE 22 and 16 more. Next period's cash, not a missing payment.

What could not be established

  • A product exists on only one channel BRAND-BARU-2026 on shopee (Kopi Susu Gula Aren Kemasan 1 L) is not in the catalogue across 3 orders, so Rp 287.909 of net cannot be attributed. Closest known product KLC-200 at 46%. · Rp 287.909
  • Re-exported rows removed 1 duplicate order rows removed from the export
  • Money arrived that no order explains TRANSFER MASUK LAIN-LAIN for 1500000 arrived 2026-10-15 and matches no order in this period · Rp 1.500.000
  • A return credited back after the order was paid RETUR TKT-0003 for 1182000 arrived 2026-10-17 against an already-settled order · Rp 1.182.000

How it got there

Dapur Senja is a fictional business and these are illustrative figures, built from a synthetic export that reproduces what real ones do: a cancelled order, a duplicated row from re-exporting, grouped settlements, a credit with no order behind it, and a SKU that exists on only one channel. Every amount above is computed from those files, not written by hand, and rebuilding the same files produces the same number.

Every figure above is computed from a synthetic export — a cancelled order, a duplicated row, split COD settlements, a credit with no order behind it, a SKU on one channel only. Rebuilding the same files reproduces the same number exactly.

Reconcile my shop