Keep the original exports and their scope
Save the order report, settlement detail, refund information and bank statement for the relevant period. Record download dates, time zones and filters. Marketplace reports can contain order-level, item-level or status-update rows; count and understand them before importing. Retain an original read-only copy and label any cleaned working file. A repeated order ID is not automatically a duplicate if one order contains several products. Conversely, importing the same settlement twice can overstate both activity and amounts waiting to be received.
Build the bridge in separate components
Start with the opening platform balance and add the activity supported by the source records. Keep gross orders, refunds, seller-funded discounts, platform-funded support, fees, holds and transfers visible rather than combining them into one net-sales number. The exact accounting classification is a professional judgement. Your operational worksheet should preserve enough detail for that judgement to be made. Finish with the closing amount shown by the platform and identify differences by reference, amount, date and explanation.
Match transfers to the bank without losing detail
One settlement may reach the bank in several transfers, or one bank credit may combine several settlements. Keep an allocation schedule so every component remains traceable. Compare the final settlement amount with the actual bank receipt and isolate conversion or bank charges. Do not match solely because two values happen to be equal. Use settlement identifiers, payment references and dates. Keep original currencies separate and document the rate used when a conversion is needed for a management comparison.
Review the awkward cases explicitly
Refunds can arrive after the original sale, claims may remain unresolved, and promotional credits may be promised before they are received. Keep those dates and statuses visible. A customer refund and a courier compensation claim are separate events; one does not prove the other will be paid. Track amounts held by the platform until released. For a cancelled order, inspect whether any fulfilment or fee event occurred rather than assuming the entire history can be deleted. Preserve source evidence for each proposed correction.
Use an exception register with owners
For each unresolved difference, state what is missing, who will investigate and what evidence would close it. Review age as well as value: many small repeated deductions can become material over time. Set an internal review threshold without using it to hide differences below that threshold. Distinguish a timing difference supported by the next statement from an unexplained imbalance. The accountant should review proposed accounting adjustments; the seller should supply commercial facts such as promotion approvals, dispatch evidence and disputed customer outcomes.
Turn the process into a repeatable close
Choose a consistent monthly cut-off, export routine and responsibility list. Reconcile the following month against the prior closing schedule so open items do not disappear when a new spreadsheet is started. Compare a sample management report with the completed reconciliation: platform receivables and bank receipts should have identifiable supporting records. If you request help, describe your platforms and backlog first. Compta Spot can collect the request, but local matching remains subject to an appropriate provider being available.
Worked example
Illustrative MYR calculation: opening platform balance 500 + order activity 4,000 − refunds 300 − documented fees 400 − transfers 3,200 = closing balance 600 before any other supported adjustments. These figures illustrate a bridge, not a platform tariff or accounting treatment.
Records to prepare
- Preserve original files and export settings.
- Separate orders, refunds, fees, promotions and holds.
- Match settlement references to bank receipts.
- Keep open differences with owners and evidence.
- Carry closing balances into the next period.
What this guide does not decide
This method does not prescribe platform-specific accounting or tax treatment. Report names and contractual terms can change; use the current files and agreements for your account.
Compta Spot publishes practical preparation guides. Calculations and scenarios are illustrative. No local professional review is claimed. Validate tax, legal and filing decisions with a qualified professional in your jurisdiction.