Marketplace Payout Reconciliation: Matching Shopee, Lazada and TikTok Shop Settlements Before Year-End Close

If you sell through Shopee, Lazada, TikTok Shop or Amazon SG, reconcile at order level against the settlement report, not at bank-deposit level — and do it weekly, not once in January. The amount a marketplace deposits into your account is your gross sales minus commission, transaction fees, shipping subsidies, seller-funded vouchers, advertising spend, and any refunds or chargebacks that cleared in that cycle. If you book the deposit as revenue, your turnover is understated, your GST is wrong, your gross margin is fiction, and your 31 December close will take three weeks instead of three days. The fix is not complicated, but it has to be built before 11.11, not after.

What actually arrives in your bank account when a marketplace pays you?

A single Shopee or Lazada payout covering a few hundred orders is a net figure assembled from at least eight moving parts. Typically: gross order value, commission or marketplace fee, payment or transaction fee, service fees on programmes you opted into, seller-funded discount participation, shipping fee shortfalls where the actual courier charge exceeded what the buyer paid, advertising and boost spend deducted at source, and adjustments for returns processed after the original payout released.

Each of those is a separate accounting event. Commission is an expense, not a reduction in sales. A seller-funded voucher is a discount against revenue. Advertising is marketing cost that belongs in your P&L where you can see it, not buried invisibly inside a net deposit line. When all eight are collapsed into one bank credit and posted as "Shopee sales", you lose the ability to answer the only question that matters: which channel is actually making money after fees?

We have seen SMEs discover, at year-end, that a channel they believed was running at 28% gross margin was delivering 9% once commission, ad spend and shipping shortfalls were separated out — and that they had been scaling the loss-making one all year because the bank balance kept going up.

Why does peak season break a reconciliation process that works in July?

In July you might do 400 orders a month and eyeball the settlement report. From 11 November through Black Friday on 27 November, into Christmas despatch and then the run-up to Chinese New Year on 17 February 2027, volume can be four to eight times baseline — and the composition changes too. Voucher participation rises. Ad spend spikes. Free-shipping thresholds get more aggressive. Return rates climb because gifting drives impulse buying, and those returns land in December and January, after the original sale was already reported.

The structural problem is timing. A sale made on 11 November may settle in late November, be partially refunded on 8 December, and see the marketplace claw the refund back from a January payout. That single transaction touches three months and potentially two financial years. If your process is "reconcile the bank statement", you will never untangle it. If your process is "reconcile every order to its settlement line and carry unsettled orders as a receivable", it untangles itself.

The second failure is human. Your one admin person who understands the spreadsheet takes leave in December. Peak is exactly when the manual process has no slack left in it.

What does IRAS expect you to report — gross or net?

For a GST-registered Singapore seller making local supplies through a marketplace, your output tax is generally computed on the gross value the customer paid, not the net payout you received. The marketplace's commission is a separate supply to you, and where that service comes from an overseas entity, reverse charge considerations may apply depending on your input tax recovery position. Cross-border and low-value-goods scenarios can shift who accounts for the GST, so confirm your specific arrangement with IRAS guidance or your tax agent rather than assuming the marketplace has handled it.

The practical consequence is blunt. If you have been declaring net payouts in your GST F5, your output tax has been understated every quarter, and the correction is cumulative. Finding that in October, with the December quarter still open, is a manageable voluntary disclosure. Finding it during an IRAS query in 2028 is not.

Record keeping matters just as much as the number. You need to be able to reproduce, for any given order, the gross value, the fees deducted, and the settlement that paid it. Marketplace portals do not keep settlement reports forever — several purge or limit historical downloads well inside the five-year retention period Singapore requires. Download and archive them monthly.

How do you build a reconciliation that survives 11.11 to Chinese New Year?

Four steps, and none of them require an enterprise system.

1. Automate the download. Pull each marketplace's order export and settlement report on a fixed weekly schedule into one folder, named consistently by channel and date. Most platforms offer either a scheduled export or an API. This is the single highest-return automation in the whole chain because it removes the step people skip when they are busy.
2. Match on order ID, not on amount. Build one working table with order ID as the key, gross value, each fee category as its own column, the settlement reference, and the settlement date. Amount-matching fails the moment two orders share a value; order ID never does.
3. Post to your accounts in categories, not in one lump. Revenue at gross, discounts as contra-revenue, commission and payment fees as cost of sales, advertising as marketing. Orders shipped but not yet settled sit as a marketplace receivable, which is also what proves your December cut-off is honest.
4. Reconcile the receivable, then the bank. Every deposit should clear a named set of settlement references. Anything that does not clear goes on an exceptions list with an owner and a date.

Done weekly, this is roughly twenty minutes per channel. Done annually in a panic, it is a fortnight of someone's life and the answer is still approximate.

What should you fix before 31 December?

Between now and the end of October, while peak has not yet fully landed: confirm whether you have been reporting gross or net for GST, and quantify the gap if it is wrong. Download and archive every settlement report you can still access from January 2026 onward. Set up the weekly export, even if it is a calendar reminder and a manual download to start with. Write a one-page instruction for it so December leave does not stop the process.

Then set your cut-off rule in writing before December: an order is revenue when despatched, unsettled orders sit as a receivable, and returns received after 31 December against pre-year-end sales are provided for. Agree it now, apply it consistently, and your year-end close becomes a reconciliation you can defend rather than a reconstruction you have to argue for.

Frequently asked questions

Do I declare GST on the gross order value or the net payout?

As a general rule for a GST-registered Singapore seller supplying locally through a marketplace, output tax is accounted for on the gross value paid by the customer, with the marketplace's commission treated as a separate supply to you. Cross-border supplies and low-value goods have their own rules that can shift the obligation. Verify your specific position against current IRAS guidance before your next F5.

How often should I reconcile marketplace payouts?

Weekly during peak trading and at minimum monthly the rest of the year. Weekly keeps exception volumes small enough that someone can actually investigate them; monthly is the outer limit if you want month-end close to take days rather than weeks.

What if a payout does not match and I cannot find the difference?

Log it on an exceptions list with the settlement reference, the variance and a date, and move on — do not hold up the whole reconciliation. Most unexplained variances resolve within one or two cycles as delayed refunds or adjustments appear. Anything still unexplained after 60 days should be raised with the marketplace's seller support in writing, because the evidence window closes.