Marketplace and Gateway Payout Reconciliation After 7.7: A Singapore SME Guide

To reconcile marketplace and gateway payouts after 7.7, match every settlement deposit back to its underlying orders by exporting each platform's settlement report, netting out commissions, fees, refunds and ad costs, and tying the final figure to the deposit that actually hit your bank account. The reason this feels harder than it should is simple: the amount Shopee, Lazada or Stripe pays you is almost never the amount you invoiced. A high-volume sale period like 7.7 multiplies every discrepancy, so the goal is a repeatable process that catches gaps within days, not a heroic month-end scramble.

Why don't 7.7 payouts match what you sold?

The single biggest source of confusion for Singapore SMEs is treating gross sales as cash. A S$120 order on Shopee might land in your account as S$101.40 after a platform commission, a transaction fee, a campaign participation fee and a co-funded voucher you didn't fully absorb. During 7.7, platforms also run their own promotions on top of yours, and the cost-sharing split appears only in the settlement report — not the order confirmation.

On top of that, payouts are batched on a settlement cycle, not per order. A single deposit might cover 300 orders placed across four days, minus refunds processed for returns from your previous sale. So the deposit you see on 3 July could mix 7.7 revenue, late June revenue and June refunds in one figure. Without a reconciliation process, that number is unverifiable — and an unverifiable number is one you can't safely report for GST or year-end accounts.

What documents do you need before you start?

Gather four things per sales channel before touching a spreadsheet:

• The settlement or payout report — the platform's line-item breakdown of each deposit, showing gross, fees and net. This is the source of truth, not your storefront order list.
• Your order export — the list of orders you fulfilled, with order IDs and invoiced amounts.
• Your bank statement — the actual deposits received, so you can confirm money left the platform and arrived.
• Your refund and dispute log — any returns, cancellations or chargebacks that reduce a payout.

The order ID is your join key. If a platform export doesn't include order IDs against fees, that channel will take longer — flag it and request the detailed settlement file rather than the summary.

How do you reconcile a payout step by step?

Work one settlement deposit at a time. The discipline that keeps lean teams sane is reconciling per deposit, not per day or per platform in aggregate.

1. Anchor to the bank deposit. Pick a deposit on your bank statement and find the matching settlement report. The net total on that report must equal the deposit, to the cent.
2. Decompose the net. Inside the report, confirm gross sales minus commission, transaction fees, campaign fees, ad spend and refunds equals the net. If it doesn't, the platform has bundled an adjustment you need to identify.
3. Tie gross to your orders. Match the report's gross sales to your own order export by order ID. Missing orders usually mean a fulfilment or cancellation timing gap.
4. Park the unexplained. Anything that won't reconcile goes into an exceptions list with the order ID and the gap amount. Don't stall the whole batch for one mismatch.
5. Record fees as expenses. Commissions and ad costs are deductible business expenses — book them, don't net them silently into revenue, or your YA2026 accounts will understate both sales and costs.

Which parts should a lean team automate?

Manual reconciliation is viable for one channel and a few hundred orders. Past that, the spreadsheet becomes the bottleneck. The high-leverage automation targets are: scheduled settlement-report downloads, a rules-based fee categoriser that tags each line type, and an order-ID matcher that auto-clears anything within a S$0.50 tolerance and surfaces only the exceptions. Most Singapore SMEs don't need a full accounting overhaul — they need the 95% of clean matches to clear themselves so a human reviews only the 5% that won't.

This is where connecting your marketplace channels to Xero or your accounting system via a reconciliation tool earns its keep. The Productivity Solutions Grant (PSG) covers many pre-approved accounting and e-commerce solutions, so the setup cost is often partly defrayed. The payback is concrete: a process that took two days of a finance person's time after each major sale drops to a couple of hours of exception review.

How does this protect your GST and year-end accounts?

Clean payout reconciliation isn't just tidiness — it's the foundation of an accurate GST F5 and a defensible YA2026 return. Your GST output tax is based on gross sales, not net payouts, so reporting the deposited figure understates your tax. Reconciled records give you the gross-to-net trail an IRAS query would ask for, and they catch the refunds and chargebacks that should reduce output tax in the correct period. Do this well after 7.7 and the September quarter-end becomes a review, not a reconstruction.

Frequently asked questions

How long after 7.7 should we reconcile payouts?
Reconcile each settlement within a few days of the deposit landing, while order details are fresh and disputes can still be raised within platform windows. Waiting until month-end means investigating gaps with stale information and missing refund-claim deadlines.

Do marketplace fees affect our GST reporting?
Yes. You report GST on your gross sales, while platform commissions and fees are separate input expenses. Netting fees into revenue understates both your sales and your claimable costs, so they must be recorded separately.

Is reconciliation software worth it for a small SME?
If you sell across more than one channel or process more than a few hundred orders per sale, yes. Tools that auto-match the bulk of transactions and surface only exceptions typically pay back within one or two major sale cycles, and many qualify for PSG support.

Reconciling payouts after a sale as large as 7.7 is the difference between knowing your real margin and guessing at it. If your finance process is straining under post-sale settlements, Digital Perpetual helps lean Singapore SME teams automate the clean matches and review only what matters — so the numbers tie out before the quarter closes.