Marketplace to Accounting: Automating the Bookkeeping

Here is the single most common bookkeeping error among Malaysian marketplace sellers, and it is made in good faith: the payout that lands in your bank is recorded as revenue. It is not. A marketplace payout is your sales, minus commission, minus transaction fees, minus service fees, minus shipping subsidy adjustments, minus returns, plus or minus whatever else the platform settled that cycle. Recording the net figure as revenue understates your turnover, makes your true fee cost invisible, and — if you are SST-registered or approaching a threshold — can misstate your tax position. The fix is a specific treatment, and once you know it, most of it can be automated.

What actually has to be recorded

For a single marketplace order, the accounting entries are:

The payout is not any of these. The payout is the settlement of all of them, and it should reconcile to them rather than replace them.

Why this matters beyond tidiness:

• Your revenue figure is wrong if you book net, which affects any threshold you are measured against — including the SST registration threshold and e-Invoice phase tiers.
• Your fee cost is invisible, so you cannot tell whether a channel is profitable. Marketplace fees stack — commission, service fee, transaction fee, campaign fees — and sellers who book net have literally never seen the total.
• Your margin analysis is wrong, because cost of sales is being compared against a revenue figure that already had costs deducted from it. Our profit margin calculator needs the gross figure to be meaningful, and the marketplace fee calculator will show you what the deductions actually add up to per order.

The flow to automate

1. Orders flow from each marketplace into one system with the gross sale value, per order.
2. Fees are captured per order or per settlement, split by type rather than lumped as "marketplace fees" — you want to be able to see commission separately from campaign costs.
3. Payout arrives in the bank as a single amount per settlement cycle.
4. Reconciliation matches the payout against the sum of gross sales minus fees minus refunds for that cycle.
5. Everything posts to your accounting software with the correct account codes.

Step 4 is the one that must always exist, automated or not. A payout that does not reconcile means either a fee you have not accounted for or an order you have not recorded, and both are worth finding while the settlement report is current.

Doing it without buying anything

Automation is not required to be correct. A monthly routine that works:

1. Download the settlement report from each marketplace. They all provide one.
2. Record one summary journal per marketplace per month: gross sales as revenue, each fee type as its own expense line, refunds as a reduction of revenue.
3. Check the total equals the payouts received in the same period. If it does not, find out why before posting.
4. Keep the settlement reports. They are your supporting documents if anyone asks, and Malaysian record-keeping obligations for tax purposes run for years.

That is perhaps an hour a month for a small seller, and it produces books that are actually correct. Our accounting fundamentals guide covers the categorisation.

When automation pays for itself

Move from the manual routine to a connected flow when any of these is true:

• More than one marketplace, because the manual work multiplies per channel.
• Enough monthly orders that per-order detail matters for margin analysis rather than just totals.
• You need per-SKU profitability, which a monthly summary journal cannot give you.
• Your accountant is billing you to unpick settlement reports — at that point automation is usually cheaper than the bill.

What to insist on when choosing a tool: gross revenue and fees posted separately (not net), per-order or at least per-settlement detail, a reconciliation report you can actually read, and support for your accounting software. Any tool that books the payout as revenue is automating the error rather than fixing it.

Three things to get right regardless

• SST. If you are registered, the treatment of your sales and of marketplace fees needs to be right. See SST and accounting basics and the SST calculator, and confirm anything unusual with your tax agent.
• e-Invoice. Marketplace sales have their own handling depending on each platform's arrangements — do not assume it matches your own store. See payments and e-Invoice.
• Returns timing. A refund in a later period than the sale is normal and must be recorded when it happens, not backdated. Doing this consistently is what makes month-on-month comparison meaningful.

Frequently asked questions

Can I just record the payout and be done?
It is simpler and it is wrong. Your revenue will be understated by the entire fee load, which affects thresholds, margin analysis and any conversation with a bank or an investor. It also means you never find out what a channel actually costs you.

How do I handle the shipping subsidy adjustments?
Treat them as what they are on the settlement report — usually an adjustment to shipping cost or a fee. The rule that matters is consistency: pick a treatment, apply it every month, and note it so the same decision is made next year.

My accountant just wants the bank statement. Is that enough?
It is enough to produce a set of accounts, but not enough to produce correct ones for a marketplace seller — the bank statement only shows net payouts. Give them the settlement reports too. Most accountants would much rather have them.

What if the payout does not reconcile?
Do not force it. Common causes are a fee type you have not mapped, a refund settled in a different cycle from the sale, or a campaign cost you did not know about. Find it — an unexplained difference this month becomes an unexplained pattern by year end.

Does this apply to my own webstore too?
Yes, in the same shape: the gateway settles net of fees, so gross revenue and payment fees are recorded separately. It is simpler than a marketplace because there are fewer fee types, but the principle is identical.

Sources: this guide describes bookkeeping treatment in general terms and is not accounting or tax advice — your accountant should confirm account mapping and SST treatment for your specific circumstances. SST scope and rates per RMCD, as covered in our SST guide; e-Invoice obligations per LHDN, as covered in our e-Invoice guide. Marketplace fee structures, settlement cycles and report formats differ by platform and change frequently — work from each platform's current settlement report rather than from any published description.