Hiring guide
Multichannel sales reconciliation: connect orders, settlements and bank receipts
By CFO Index · Published
An ecommerce business can have three reasonable numbers for the same period: orders placed, payments collected and cash deposited. The task is to explain their relationship, not force them to match. Ask your fractional CFO for a reconciliation by channel, payment provider and currency before combining the results.
Separate the commercial event from the money movement
Keep order placement, payment capture, refund, settlement and bank receipt as separate events. Shopify's finance documentation distinguishes orders from payments and notes that they can fall in different reporting periods. It also separates Shopify Payments balance activity from sales reporting. These are product-specific definitions, not a universal revenue-recognition policy. Have the accounting owner determine how the underlying transactions enter the accounts; a platform's total-sales label is not sufficient evidence.
Give each order one identity across systems
Record the originating channel, its order ID and any corresponding store or accounting-system ID. An imported marketplace order may appear in the store dashboard as well as the marketplace export. If both are included, use the mapping to count the commercial order once. Do not deduplicate solely by customer, amount and date: two legitimate purchases can share those fields. Keep refunds and partial fulfilments linked to the original order without deleting the separate payment events.
Reconcile one settlement account at a time
Start from the platform balance carried into the period. Add captured payments and other supported credits, then subtract refunds, fees, adjustments and payouts. Reconcile the closing platform balance to its statement, including any pending or reserved funds within the chosen scope. Separately match each payout to the bank using its reference and currency. A payout initiated before month-end but received afterwards is a timing item to investigate, not automatically missing revenue.
A two-channel settlement bridge
Hypothetical monthly example in euros: both channels start with zero platform balance. The table uses customer payments, not accounting revenue, and assumes no foreign-exchange movements or other adjustments. The bank has received all listed payouts by the cutoff. Each closing platform balance is supported by its platform statement. Real businesses must add the actual tax, reserve, dispute and currency details where they affect settlement.
| Movement | Direct-store processor | Marketplace | Combined |
|---|---|---|---|
| Opening platform balance | 0 | 0 | 0 |
| Captured customer payments | +20,000 | +30,000 | +50,000 |
| Refunds | −1,000 | −2,000 | −3,000 |
| Fees deducted | −600 | −4,000 | −4,600 |
| Payouts to bank | −17,400 | −21,000 | −38,400 |
| Closing platform balance | 1,000 | 3,000 | 4,000 |
Explain the gap instead of booking it as a loss
In the example, €50,000 of captured payments becomes €38,400 in bank receipts, €3,000 in refunds, €4,600 in deducted fees and €4,000 still held in platform balances. Those four uses reconcile to the original €50,000. The €11,600 difference between captured payments and bank receipts is therefore not all a fee, a loss or an overdue customer debt. Nor does the €38,400 bank receipt establish profit: product costs and other operating expenses remain outside this settlement example.
Keep the settlement export's detail
Amazon's Flat File V2 settlement report includes settlement and order identifiers, dates, currency, amount type, amount description and amount. Preserve those fields when classifying movements; its documentation also notes local number formats. Validate decimal parsing and signs before aggregating. Map known charge types explicitly and put unfamiliar ones in an exception queue. A new fee description should not silently become sales simply because an import rule has no matching category.
Set an acceptance test for the CFO's work
Select one normal order, one refund and one payout spanning a period end. Trace each through the relevant records and demonstrate that it appears once in the correct part of the bridge. Request a closing-balance reconciliation for each platform and an exception list with amounts, owners and next actions. Keep this separate from channel profitability: once the cash trail is reliable, the team can combine it with product, fulfilment and marketing costs to answer a different question.