Connecting sales channels to your ledger

A business selling through more than one channel has a specific accounting problem: the money arrives separately from the sale, in a different amount, on a different day, net of things nobody itemised at the time.

An order is placed on a marketplace on the 3rd. It ships on the 5th. The customer's payment goes to the platform. On the 20th, a settlement arrives in your bank covering several days of orders, less commission, less transaction fees, less a shipping subsidy, less an adjustment for a return processed on the 12th.

Multiply by four channels, each with different rules, and the question "what did we actually make" becomes genuinely difficult.

What has to connect, and in what order

Orders, as they occur. Not at settlement. Revenue is earned when the sale happens, and waiting for the money to arrive means the ledger is permanently behind and cut-off is wrong at every period end.

Fees, itemised. Not as a single net deduction. Commission, transaction fee, shipping subsidy, promotional cost and adjustment are different things with different accounting treatment and different negotiability. Collapsing them into "platform costs" destroys the analysis and makes disputes impossible.

Returns and adjustments, linked to the original order. Otherwise you have a deduction with no counterpart, and the per-order profitability is fiction.

Settlements, reconciled to the orders they cover. The check that ties it together — see where omnichannel money actually lands.

Payouts, matched to the bank. The final link, closing the chain from order to cash.

Miss any link and the chain breaks somewhere that is hard to see later.

The three timing problems

Revenue and cash are in different periods. An order on the 28th settles on the 15th of the following month. The revenue belongs where the sale happened; the cash arrives later. This is ordinary accruals accounting and it breaks when people post revenue on settlement, which is a common shortcut.

Fees are deducted after the fact. Commission on a sale may be adjusted later — a return, a promotion applied retrospectively, a correction. So the cost of a sale is not final at the point of sale, which is uncomfortable and is simply how these platforms work.

Reserves and holds. Some platforms hold a portion of funds. That is cash you have earned and cannot yet access, and it needs to be visible as a receivable rather than absent from the picture.

The reconciliation that has to hold

For each settlement:

Gross sales, less every itemised deduction, equals the amount that reached your bank.

Every line accounted for. Not "close enough", and specifically not with a residual figure absorbing whatever did not reconcile. If a deduction cannot be explained, it should surface as an exception rather than disappear into a cost line — that is what full traceability means here, and it is separate from the question of how much matched automatically.

The unexplained deductions are frequently recoverable. They are also invisible the moment anyone allows a balancing figure.

What the point of sale contributes

For businesses with physical outlets, the till is another channel with its own characteristics: sales are immediate, payment is mixed — cash, card, e-wallet — and card settlements arrive net of merchant fees on their own timetable.

The integration required is that the till's sales land in the same ledger, with the same product and customer identity as online sales, so that a product's total margin is knowable across every channel it sells through.

The point-of-sale system continues doing what it does. Nobody should be replacing a working till to solve an accounting problem, and the accounting integration is a different thing from the checkout.

The identity problem

The hardest part is not money — it is that the same product and the same customer have different identifiers in every system.

A product is one SKU in your inventory, another in the marketplace listing, a third at the till. A customer is an email address in one, an anonymous order in another, a loyalty number in a third.

Without resolving identity, you can reconcile the money and still not answer the questions that matter: which product is actually profitable across all channels, whether a customer buys in more than one place. Getting the money right is necessary; getting identity right is what makes the numbers useful.

That is a data mapping exercise done once, and it is worth doing properly at the point of integration rather than retrofitting.

What to sequence

1. One channel, end to end. Orders, fees itemised, settlement reconciled, payout matched to bank.
2. Confirm it reconciles for a full period with nothing unexplained.
3. Then the second channel.
4. Then identity mapping across channels, once each is reconciling independently.

Connecting all channels simultaneously produces a reconciliation that does not balance with no way to tell which channel is responsible.

The sequence matters as much as the connections, because each stage depends on the one before it and reporting built on unreconciled data loses credibility permanently — see automating a Shopify store in the right order.

Common questions

What has to connect for multi-channel sales accounting to work?

Orders captured as they occur rather than at settlement, fees itemised individually rather than as a single net deduction, returns and adjustments linked to their original orders, settlements reconciled to the orders they cover, and payouts matched to the bank. Missing any link breaks the chain somewhere that becomes hard to locate later.

Why should revenue be recorded at the order rather than at settlement?

Because revenue is earned when the sale happens, and settlement can be weeks later. Posting revenue on settlement leaves the ledger permanently behind and produces incorrect cut-off at every period end, since orders placed near the period boundary land in the wrong period entirely.

Why do fees need to be itemised separately?

Because commission, transaction fees, shipping subsidies, promotional costs and adjustments are different things with different accounting treatments and different degrees of negotiability. Collapsing them into a single platform cost destroys the analysis and makes it impossible to identify or dispute a deduction that should not have been applied.

Should sales channels be connected all at once?

No. Connect one channel end to end, confirm it reconciles for a full period with nothing unexplained, then add the next. Connecting several simultaneously produces a reconciliation that does not balance with no way to determine which channel is responsible.

Related: where omnichannel money actually lands · one source of truth for multichannel sellers · integrating AI accounting with your bank