How to reconcile Shopee orders to your bank statement, step by step

Most guides tell you that you should reconcile your Shopee sales. Very few show you how, step by step, with the actual reports and the actual order of operations. This one does.

By the end you will be able to take a Shopee payout, trace it back to the orders it contains, explain every deduction, and confirm the right money reached your bank — or find out exactly where it did not. It is not hard. It is just fiddly, and doing it in the right order is what keeps it from becoming a mess.

Before you start: the three sources you need

Reconciliation is matching, and you cannot match with only one side. Get these three open first:

• Your Shopee settlement or payout detail report — the itemised one, not the summary. This lists each settled order and the deductions taken against it.
• Your own record of sales — whatever you use to know what you sold: your order export, an inventory system, or your books.
• Your bank statement — so you can confirm the payout actually arrived.

If you only ever look at the payout summary and your bank balance, you are comparing two totals that were never built to match. The detail report is the bridge between them, and it is the single most important habit change most sellers can make.

Step 1: Pull the settlement detail, not the summary

The payout summary tells you one thing: a lump sum arrived. Useful for your bank, useless for checking. The settlement detail breaks that lump into orders and deductions — commission here, service fee there, this refund netted off — which is the only view where errors are visible.

So the first move, every time, is to download the detailed report for the payout period. Everything else is built on it. If you take one habit from this article, take this one: reconcile from the detail, never from the summary.

Step 2: Match each order to your own sales record

Now line the two sides up. For each settled order in the detail report, find the same order in your own records and confirm two things: it is a real order you actually shipped, and its value matches what you expected to sell it for.

Most orders will match cleanly and you can move on quickly. What you are hunting for is the handful that do not:

• An order in the payout you have no record of selling.
• An order value that differs from your price.
• A sale in your records that has not appeared in any payout yet.

That last one is not an error — it is timing, which we handle in step 4 — but the first two are worth a second look. This is the slow part by hand, because it is one-by-one matching across a lot of rows, which is exactly why it is such a natural fit for automation.

Step 3: Explain every deduction

For each matched order, walk down its deductions and make sure each one has a name you understand. The categories will be some mix of commission, transaction fee, service fee, campaign or voucher co-funding, ads and shipping contribution. The exact rates change often and vary by category and programme, so do not try to memorise numbers — check your Shopee Seller Centre for your current rates and confirm each deduction is the type you expect.

The goal is simple: no deduction should be a mystery. If you can explain every line, that order is reconciled. If a deduction appears that you cannot account for — a fee you have never seen, a campaign cost on an order that was not in a campaign — you have found either a fee you did not know about or an error. Both are worth knowing, and neither is visible from the payout total. Your true cost across all these deductions is your real margin, which you can sketch quickly with the Shopee profit calculator.

Step 4: Track the timing gap

Here is the step almost everyone skips, and it is why reconciliation feels impossible when you try to compare totals.

Your sales and your payouts run on different clocks. An order sold today may settle next week, or the week after, once it clears delivery and the buyer-protection hold. So at any moment you have orders that are sold but not yet paid — money genuinely owed to you that has not arrived.

If you do not track that pool, you cannot tell the difference between "not paid yet" (fine, coming) and "not paid at all" (a problem). So keep a simple running list of settled-versus-outstanding: which sold orders have appeared in a payout, and which are still waiting. That list turns the timing mismatch from a source of confusion into a number you control. We explain the underlying clocks in gross sales vs net payout.

Step 5: Confirm the payout hit your bank

Now the easy part. Take the net payout total from the detail report and match it to the actual deposit on your bank statement. Same amount, same date-ish.

Usually it matches and you are done. Occasionally the amount differs, or a payout lands in a different statement period than you expected — a genuine timing quirk worth noting so you do not double-count it next month. This final tie-out is what lets you say the whole chain is clean: orders explain the payout, and the payout explains the bank.

Step 6: Flag the anomalies and move on

You will not resolve everything, and you should not try. The point of reconciliation is not perfection — it is to surface the small number of things that do not fit so you can decide whether to chase them:

• A deduction out of pattern.
• A refund that appears twice.
• A commission rate that changed.
• A payout that does not match the bank.

Note them, chase the ones worth chasing, and let the rest go. Most will be legitimate. The few that are not are the entire reason this exercise pays for itself.

Walking an RM8,300 payout back to its orders

You download the detail report for a RM8,300 payout. You match its orders to your records — all present, one order value off by RM5 (a manual price override you forgot). You walk the deductions — all explainable except one small "service fee" on an order that should not have carried it. You check your outstanding list — RM1,900 of sold orders not yet settled, all recent, all fine. Finally you tie the RM8,300 to your bank — matched.

Total time, once you are practised: under an hour for a modest store. Total findings: one price note and one questionable fee to query. That is a successful reconciliation — not a treasure hunt, just certainty.

Common questions

How often should I do this?

For most stores, monthly is the sensible rhythm — frequent enough to catch a forgotten campaign or a fee change before it runs for long, but not so frequent that it takes over your week. Busy stores running lots of campaigns, or sellers on several marketplaces at once, often benefit from a lighter weekly check on outstanding payouts plus a full monthly tie-out. The trap is doing it once a year at tax time, by which point a small recurring error has had twelve months to run. Whatever cadence you pick, the value comes from consistency: a reconciliation you actually do every month beats a perfect one you do once and abandon. We go deeper in how often should you reconcile your Shopee sales.

What if I sell on Shopee, Lazada and TikTok Shop?

Then you have three of everything — three settlement formats, three fee structures, three clocks, three order-numbering conventions — and the same physical product wears three identities. Reconciling one channel by hand is a chore; reconciling three is where most sellers quietly give up and run the business on faith. The steps are the same for each platform, but the volume and the format differences are what make it impractical manually. This is the clearest case for consolidating the matching in software, so all three channels land in one place with one true margin per channel. We cover the multi-channel side in multi-channel stock sync for Malaysian retailers.

Can I automate all of this?

Most of it, yes — and this is exactly the kind of work that automates well. Reconciliation is high-volume, rule-based matching: the same steps applied to thousands of orders, with a small number of genuine exceptions that need a human eye. Software can pull the detail, match orders to sales, check each deduction against expected fee types, track the outstanding pool and flag the anomalies, leaving you only the handful of real questions to judge. That is the design goal behind SmartB Studio's aim of 98% automated reconciliation: let the machine do the thousands of easy matches so you spend your time only on the few that actually need you.

Do it once, then stop doing it by hand

Reconciling by hand is worth learning, because it teaches you what the numbers mean. But it is not worth doing forever — it is repetitive, it scales badly, and the month you are busiest is the month you will skip it, which is the month an error will slip through.

So learn the steps, run them once to see your real margin, then hand the repetition to software. SmartB Studio reconciles your Shopee orders, fees and payouts automatically — aiming for 98% auto-matched rather than an unrealistic 100% — so the certainty is continuous and your time goes back to selling. See it for Shopee sellers.

Related: what is Shopee reconciliation and why your Shopee payout never matches.

Also worth reading: a beginner checklist.