Shopee reconciliation checklist for beginners — your first month

If you have never reconciled your Shopee sales and the idea feels vague and heavy, this is for you. Reconciliation is not complicated once someone hands you the list — it just has an order to it, and doing the steps out of order is what makes it feel like a mess.

So here is the list. Work through it once, in order, for your first month. By the end you will have proved your Shopee payouts against your orders, found your true margin, and — just as importantly — understood the numbers well enough to know when to stop doing this by hand.

Before you start: gather three things

Reconciliation is matching, and matching needs both sides plus the destination. Open these before anything else:

• Your Shopee settlement detail report — the itemised one that lists each order and each deduction, not the payout summary.
• Your own sales records — however you know what you sold, whether an order export or your books.
• Your bank statement — to confirm the payouts actually landed.

If you have only ever looked at the payout total and your bank balance, gathering the detail report is the single change that makes everything else possible. It is the bridge between what you sold and what you were paid.

Step 1: Confirm what you sold

Start on solid ground: your own record of the month's orders. What did you actually sell, and for how much? This is your baseline — the truth you will hold everything else against.

Do not skip this because it feels obvious. Half of reconciliation is catching things that appear in a payout but not in your sales, or vice versa, and you cannot do that without a clean list of what you sold in the first place. Get this right and the rest has something to lean on.

Step 2: Match settled orders to your sales

Now open the settlement detail and, order by order, find each settled order in your own records. You are confirming two simple things: it is a real order you shipped, and its value matches what you meant to sell it for.

Most will match and you move on quickly. Mark the exceptions:

• Orders in the payout you have no record of.
• Order values that differ from your price.
• Sold orders that have not appeared in any payout yet.

That last group is not a problem — it is timing, covered in step 4. The first two deserve a closer look. This is the slow part by hand, and it is exactly the part that automation handles for you later.

Step 3: Account for every deduction

For each matched order, walk down its deductions and give each one a name you understand — commission, transaction fee, service fee, campaign or voucher co-funding, ads, shipping contribution. The rates change often and vary by category and programme, so do not memorise numbers; check your Shopee Seller Centre and confirm each deduction is the type you expect.

The rule for beginners is simple: no deduction should be a mystery. If you can name every line, that order is reconciled. If a fee appears you cannot explain, note it — it is either something you did not know you were paying or an error, and both are worth learning. Add up all these deductions and you have your real cost of selling, which sets your true margin. The Shopee profit calculator does this maths for you if you want a quick picture first.

Step 4: Track what you are still owed

Here is the step beginners most often miss, and it is why the totals never seemed to match before. Your sales and payouts run on different clocks — an order sold today may be paid next week or the week after.

So make a simple list: which of the month's sold orders have appeared in a payout, and which are still waiting. The waiting ones are money owed to you, not money lost. Keeping this list turns the confusing timing gap into a number you understand, and stops you from panicking that a recent order "did not get paid" when it simply has not settled yet. We explain the clocks in gross sales vs net payout.

Step 5: Tie the payout to your bank

The satisfying step. Take each payout's net total from the detail report and match it to the actual deposit on your bank statement. Same amount, roughly the same date.

Usually it matches and you can breathe. If it does not, or a payout landed in a different statement period than you expected, note it so you do not double-count next month. When the orders explain the payout and the payout matches the bank, you have a clean chain end to end — which is the whole goal.

Step 6: Write down two numbers

Finish by recording the two numbers this whole exercise exists to produce:

1. Your true margin — gross sales, minus every Shopee deduction, minus your cost of goods. This is what you actually keep, and most sellers cannot state it. Now you can.
2. Your anomaly list — the handful of things that did not fit: an unexplained fee, a double refund, a value mismatch, a payout that did not tie. Decide which are worth chasing and let the rest go.

That is a complete reconciliation. Not a treasure hunt — just certainty, plus the first accurate margin figure your store has ever had.

What the six steps turned up on 180 orders

A new seller works the list for their first month. Step one: 180 orders sold. Step two: all match except two with a value off by a few ringgit — forgotten manual discounts. Step three: every deduction named, except one odd service fee to query. Step four: RM2,100 of recent orders still awaiting settlement, all normal. Step five: three payouts, all tying to the bank. Step six: true margin written down for the first time, plus a three-item anomaly list.

Elapsed time: an afternoon, because it is the first time. Result: a seller who now knows their real margin and has two small things to query — and who understands the process well enough to see that doing this every month by hand is not the goal.

Common questions

How long will my first reconciliation take?

Longer than later ones, because everything is new — plan for an afternoon for a small store's first month, and less each time as the routine settles. The first pass is slow partly because you are learning where the reports are and what the deductions mean, not just doing the matching. That learning is worth it: it is how you come to understand your own numbers well enough to trust them and to spot when something is off. Once the understanding is in place, the mechanical matching is repetitive and speeds up, which is also the point at which most sellers realise it is a task better handed to software than repeated by hand every month.

What if I find something I can't explain?

Good — that is the checklist working, not failing. An unexplained deduction, a value that does not match, a refund that appears twice: note it on your anomaly list rather than trying to resolve everything on the spot. Then decide case by case. Some are worth querying with Shopee support; some are your own forgotten discounts or overrides; some are too small to chase but worth watching in case they recur. The goal of a first reconciliation is not to resolve every mystery — it is to surface them, because a mystery you have named is one you can act on, and most sellers never get even that far. Over a few months the recurring ones reveal themselves and become easy to handle.

When should I stop doing this by hand?

The moment it stops teaching you something and starts merely costing you time — usually after a few monthly rounds, or sooner if your volume or number of channels makes a manual pass genuinely painful. The first few reconciliations are valuable to do yourself because they build understanding of your numbers. But the work itself is repetitive, rule-based matching that scales badly for a person, and the busiest month is the one you will skip. That is the natural handover point to software: keep the understanding you have built, and let an automated system do the thousands of routine matches, aiming for 98% auto-reconciliation and deliberately not 100%, so you only ever look at the few real exceptions.

Start simple, then let it run itself

Reconciliation is not hard — it is a list, done in order, once a month. Work this checklist for your first month and you will have proved your payouts, found your true margin, and understood your store better than most sellers ever do.

Then, once the understanding is yours, hand the repetition to software. SmartB Studio runs this whole checklist automatically for Shopee sellers, aiming for 98% auto-matched, so your first reconciliation is also close to the last one you do by hand. See how it works, or start with the Shopee profit calculator.

Related: how to reconcile Shopee orders to your bank and what is Shopee reconciliation.