Reconciling online payment platforms

A payment platform settlement often combines several transactions. Reconcile gross sales, refunds, fees, chargebacks and retained balances to the amount reaching the bank. Recording only the net deposit as sales can misstate both revenue and costs and leave platform balances unexplained.

Use reports for the same period and currency, checking settlement timing around month end. Identify reserves or funds still held by the provider. Keep order and invoice references so customer disputes and refunds can be traced without reconstructing the entire payout.

Understand the platform's transaction cycle

Identify each platform account, currency and settlement arrangement. Obtain transaction, fee, refund, dispute and payout reports for the period. A bank receipt may combine many sales and deductions, while some customer money remains with the provider. Do not post every net payout as gross sales without reconciling the underlying activity and checking the company's accounting and VAT position.

Create a clear bridge from opening platform balance through transactions to closing balance and payouts. GOV.UK's company record guidance provides the wider need to explain income, expenditure and balances. ^[1] The platform reports should support that evidence alongside the bank and sales system. A matched payout proves receipt of cash, not necessarily completeness or correct classification of the transactions behind it.

Separate sales, fees and customer adjustments

Link gross transactions to invoices or orders using stable references. Identify fees, refunds, chargebacks and currency conversions separately. Check whether the platform reports amounts inclusive or exclusive of relevant tax and whether the business acts as principal or agent in the actual arrangement. Do not assume every marketplace report uses the same definitions or that a familiar column heading matches the ledger's meaning.

Review partial refunds and disputes that span reporting periods. A chargeback can reverse cash while the underlying sales or debt position needs separate assessment. Keep case evidence and the final outcome. Avoid deleting the original sale simply because the payout is lower, or recording the refund twice through both the platform import and a manually issued credit.

Reconcile timing and reserves

Record settlement delays, rolling reserves and amounts withheld by the provider. Distinguish available funds from balances not currently withdrawable. At the reporting date, reconcile money in transit between the platform and bank using evidence from both sides. A payout initiated near midnight may appear on different dates in reports, especially where time zones differ.

Investigate old unmatched amounts rather than carrying them forward as permanent timing differences. A failed payout, closed bank account or unresolved verification request may need operational action. Use Reconciling a business bank account for the bank reconciliation and Cash flow forecasting for small companies for cash forecasting so the company does not assume all platform balances can fund imminent obligations.

Control imports and multi-currency records

Check whether the sales platform and payment provider both create ledger entries for the same transaction. Define which system is the source for sales and which supplies settlement information. A successful integration can still duplicate income if both routes are enabled without a clear design. Test a sale, refund, fee and payout from beginning to end using representative records.

For foreign currency, preserve original amounts and the exchange evidence used. Separate conversion fees from exchange movements where appropriate. Ask the accountant to review the treatment rather than allowing unexplained differences to accumulate in a suspense account. Keep the configuration and mappings documented so an integration update does not silently change the way transactions are classified.

For Limited company bookkeeping, provide the platform reports, bank statements and ledger mappings for one complete cycle. Ask for a reconciliation showing gross activity, deductions, payouts and closing funds. Agree how exceptions and provider changes are reviewed each month. Keep report exports accessible because online dashboards can change or restrict history, and the company still needs evidence explaining its transactions after a platform account is closed.

Check a settlement that includes several periods

A platform payout can combine recent sales, older refunds, fees and a release from a previous reserve. Obtain the settlement detail and reconcile each component to the appropriate underlying record. Posting the entire net payout as current sales can misstate revenue and hide costs or timing differences.

Keep the settlement identifier in the bookkeeping record so another person can reproduce the reconciliation. If the platform changes its export format, test whether the import still maps fees, taxes and adjustments correctly. Compare a sample manually before relying on automation for a full period. This is especially useful when several storefronts share one payout account, because a correct bank total does not establish that each shop's sales and deductions have been recorded accurately.

Illustrative scenario

A platform collects £1,000 from customers, deducts £30 in fees and pays £970 to the company. The bookkeeper records the underlying sales and fee treatment appropriately rather than treating £970 as the complete sales figure. Refunds, tax treatment and any held funds are reviewed separately against the platform report.

Preparation checklist

• Obtain gross transaction and settlement reports.
• Separate fees, refunds, chargebacks and reserves.
• Match each payout to the bank and remaining platform balance.
• Check currency and period-end timing differences.