11.11 Revenue Reconciliation: Why Your Bank Shows Less Than Your Dashboard
Your bank shows less than your 11.11 dashboard because the dashboard reports gross orders while the bank receives net payouts, released in tranches days or weeks after the sale, after commission, transaction fees, seller-funded vouchers, shipping programme charges and affiliate payouts have been taken out. Nothing is necessarily wrong. But you cannot tell whether something is wrong until you rebuild the arithmetic order by order. Start that today, on 12 November, while every export is still complete and your team still remembers the manual adjustments they made during the sale.
Why does the bank show less than your 11.11 sales dashboard?
Three separate effects stack up, and most SME owners only notice the first one.
Deductions. Each marketplace order arrives with a set of charges applied at order level: base commission, a payment or transaction fee, any free-shipping or campaign programme fee, affiliate or live-stream commission, and the portion of every voucher that you funded rather than the platform. On a heavily discounted 11.11 order, these stack in a way they never do in a quiet week.
Timing. Payout release is usually tied to delivery plus a buyer protection window, not to the order date. So a single sale day fragments into payout batches landing across the rest of November and into December. Comparing one day of sales to one week of bank credits will always look alarming and prove nothing.
Clawback. Refunds and returns processed after a payout has been released are recovered from later payouts. This is the one that catches people out: November looks acceptable, then mid-December cash comes in thin and nobody can say why. If you are tracking the refund surge separately, tie the two together now.
What should you reconcile on 12 November, while the data is still complete?
Export availability narrows over time and order detail gets harder to retrieve, so treat the next three days as your only clean window. Pull and save, per sales channel:
- The full order export for 10 to 12 November, with order ID, order date, gross value, buyer-paid amount, discount split between platform-funded and seller-funded, and current order status.
- The fee or transaction statement covering those orders.
- The voucher and campaign report, so you can see which promotions you paid for.
- The affiliate or creator commission report.
- The logistics report with parcel weight and dimensions, which is where courier rebilling shows up.
- Your own stock movement for the same window, to catch adjustments made manually under pressure.
Save them as files with the date in the filename, in one folder, outside the platform. Reconciliation done from a live dashboard three weeks later is reconciliation done against figures that have quietly changed.
Which deductions quietly eat the margin?
In our experience with Singapore sellers, the vanished margin almost always sits in five places:
- Stacked vouchers. A seller-funded voucher applied on top of a platform-funded one, on a product already discounted at the listing level. Three discounts, two of them yours.
- Shipping programme fees charged on the wrong base. Check whether yours is calculated on the item price or on the total including shipping. The difference is small per order and material across a peak day.
- Affiliate and live commission layered on base commission. Perfectly reasonable, frequently forgotten when the pricing was set weeks earlier.
- Courier rebilling. Parcels declared at one weight and billed at another, or volumetric charges on bulky low-value items. This arrives late, often as a lump adjustment with no order reference.
- Payment and currency charges on cross-border orders. Small percentages on your highest-value baskets.
Then there is the non-fee one. Look at discount depth by SKU, not in aggregate. Most sellers discover that the deepest cuts went to products that were already selling, funded entirely by themselves, while the slow stock the sale was supposed to clear came through at single-digit volume.
How do you tell a wrong payout from a normal one?
Set thresholds before you look, so the number decides and not your mood. Three checks are enough:
Batch variance. For each payout, compute expected net from your own order data and compare to the credited amount. Investigate any variance above 1 per cent of the batch or SGD 200, whichever is lower. Smaller gaps are usually rounding and timing and will cost more to chase than they return.
Order count. Compare the number of orders included in the payout batch against the orders you believe are completed and payable. A fee you did not expect is annoying; an order that never appears in any payout batch is lost money, and it is the fault nobody looks for because the totals look plausible.
Effective rate drift. Calculate total deductions as a percentage of gross, per channel, per week. If that rate moves more than about two percentage points with no campaign to explain it, you are looking at a rate card change, a setting someone switched on for the sale, or a programme you were enrolled into. That is worth a query. A feeling is not.
One discipline: do not raise a dispute until you can reproduce the platform's own calculation and point at the specific order and line. Queries without order IDs get closed.
What should this become before Black Friday?
Black Friday and Cyber Monday fall on 27 to 30 November, and 12.12 follows two weeks later. You have one reconciliation cycle between now and then, so build the thing you will reuse rather than a one-off spreadsheet.
What that looks like in practice: one row per order, with gross, each deduction as its own column, expected net, actual payout reference, variance and a reason code. Fee rates held as parameters you can change in one place when a rate card changes. Scheduled exports rather than someone remembering to download. The output you want is net contribution per channel, per campaign, which is a number almost no Singapore SME can state for 11.11 and every one of them can state for gross revenue.
That number drives a real decision. If a channel's net contribution after all deductions is close to zero or negative, running it again at 12.12 is a choice to buy revenue with margin. Sometimes that is correct, for stock clearance or a new product launch. It should be deliberate, and it should be visible before the campaign, not discovered in January.
Frequently asked questions
How long should we wait for 11.11 payouts before raising a query?
Work from the release terms in your seller agreement, which usually run from delivery confirmation plus the buyer protection window, then allow three working days for banking. Only after that full cycle has passed for a specific order does a query make sense, and it should name the order IDs and the amount you expected.
Should we record revenue at gross or net?
Standard practice is to record revenue at the gross amount the buyer paid and treat platform commission, transaction fees and shipping charges as expenses, because that keeps your margin visible instead of burying it. The GST treatment of fees charged by overseas platforms depends on your registration status and the supplier, so confirm the specific treatment with your accountant rather than copying another seller's setup.
Can a small team automate this without a developer?
Yes, in stages. Begin with scheduled exports landing in one shared sheet and a single variance column with a threshold rule, which a finance admin can run in under an hour a week. Automate the matching only once the manual version has survived two peaks, because the rules you discover in those two cycles are the rules the automation needs to encode.
Ready to Transform Your Business?
Let Digital Perpetual help you automate, streamline, and grow.
Get Started with Digital Perpetual →