Ecommerce accounting

Multi-channel ecommerce reconciliation: a monthly close

Reconcile Shopify, Amazon, payment processors and wholesale receivables separately, then bring the results together in a supported monthly close.

Sema Koch, CPA

Published

2026-09-30

Last updated

October 23, 2026

Author credentials and experience

Published on Beamarc: September 30, 2026.

A multi-channel close needs a separate reconciliation for each cash collection process.

Shopify Payments, Amazon, PayPal and wholesale customers can have different payment timing and deductions. Reconcile each process before consolidating the results.

It won’t tie, and you’ll park the difference in a clearing account forever.
Different errors can offset each other, leaving a matching total without accurate supporting records.

Reconcile each cash cycle independently, then consolidate the supported balances for reporting.

Step zero: separate channels by cash cycle

Multi-channel closes break when teams treat every channel like Shopify. They’re not the same. Start by sorting channels into two buckets:

Settlement channels

Shopify Payments, Amazon, Stripe, PayPal, Square, marketplaces, gateways. These pay you net via payouts/settlements or balance transfers. You reconcile using clearing accounts.

Invoice channels

Wholesale/B2B, retail partners, distributors. You invoice and collect later. You reconcile using Accounts Receivable and AR aging.

Follow the payment sequence

Use receivables for customer invoices and clearing for processor settlements. An invoice paid through a processor can use both: customer receivable, then processor clearing, then bank. Record the sale only once.

Once you’ve done that, the rest is repeatable.

The minimum chart of accounts that prevents drift

If one holding account contains several processors, separate the accounts or maintain a reliable schedule for each source.

Minimum balance sheet structure (example)

Shopify Payments Clearing. Type: Asset; Purpose: Unpaid/pending Shopify payouts and payout adjustments
Amazon Clearing (Funds with Amazon). Type: Asset; Purpose: Net settlement activity pending disbursement
PayPal Clearing (Funds with PayPal). Type: Asset; Purpose: Wallet balance and transfers in transit (if applicable)
Stripe Clearing. Type: Asset; Purpose: Unpaid/pending Stripe payouts and adjustments
Funds on Hold / Reserves Held. Type: Asset; Purpose: Rolling reserves, risk holds, documented holds not considered “normal timing”
Accounts Receivable – Wholesale. Type: Asset; Purpose: Open invoices pending collection
Sales Tax Payable (DTC, if you remit). Type: Liability; Purpose: Tax you collected that is owed to taxing authorities

Account names are examples. Track and reconcile each settlement source, customer receivables and holds. The asset labels assume supported recoverable debit balances; an amount owed to a processor may instead be a liability. Avoid counting reserves in both clearing and a separate reserve account.

The multi-channel reconciliation pattern

Every settlement channel reconciles the same way:

Channel pattern (settlement sources)

Record gross activity per your policy (don’t book net deposits as revenue)

Post fees/refunds/adjustments from payout/settlement detail to clearing

Match payout/settlement IDs to bank deposits

Clearing balance = open items only (aged and explainable)

Wholesale normally uses invoices, receivables and cash receipts. If an invoice is paid through a processor, first clear the receivable to processor clearing, then reconcile the net payout; do not record revenue again.

What’s different by channel

Same pattern, different gotchas.

Shopify (Shopify Payments + other gateways)

Provider routing matters. Not every checkout method settles the same way. Reconcile Shopify Payments separately from any other providers you use.
Refund timing is real. Refunds often reduce future payouts; depending on configuration/country, you can also see bank debits if the available balance is insufficient.
Fee rates vary. Don’t use a blended percent in workpapers. Tie fees to payout detail.

More detail: Shopify payouts vs. sales: reconciling to bank deposits.

Amazon (Seller Central / FBA)

Settlement statements are the cash truth. Orders reports are operational. Settlements explain deposits.
Reserves/holds create timing items. Track holdbacks separately so clearing doesn’t look “broken” forever.
Sales tax is often marketplace-facilitated. In many jurisdictions Amazon collects/remits certain sales tax. Don’t record marketplace-collected tax as your revenue or a tax liability you must remit unless you’re actually the remitter for that transaction type.
Reimbursements and fee reversals exist. If you don’t map them, they show up as “random credits.”

More detail: Amazon settlements vs. deposits: a reconciliation guide.

PayPal / Stripe / Square

Two-step cash is common. Some processors pay to a wallet/balance, then you transfer to the bank. That’s two reconciliation points, not one.
Holds happen. Identify reserves separately, document expected release and assess recoverability; do not leave them as unexplained timing differences.

Wholesale / B2B

Run it through AR. Invoices create AR, collections reduce AR. Reconcile with AR aging and open invoices.
Expect deductions. Returns, allowances, compliance/chargeback-style deductions may reduce cash receipts without changing the original invoice. Track and document them consistently.
Revenue recognition isn’t “when cash arrives.” Cash timing and revenue timing are different concepts.

The consolidated bridge

After each channel is reconciled independently, you can roll up to a consolidated bridge. This is what leadership cares about: what you recognized as revenue, what got deducted, what hit cash, and what’s still open.

The example below assumes no opening receivable or clearing balances and that all sales qualify for recognition in the period. Its gross activity excludes sales taxes. In a real bridge, also include opening balances, non-sales receipts, prior-period collections and cutoff adjustments.

Consolidated view (illustrative)

Shopify Payments. Gross activity: $84,230; Deductions: ($5,623); Net amount receivable: $78,607; Deposited: $76,892; Open balance: $1,715
Amazon. Gross activity: $127,445; Deductions: ($36,383); Net amount receivable: $91,062; Deposited: $85,340; Open balance: $5,722
PayPal/Stripe. Gross activity: $12,890; Deductions: ($1,057); Net amount receivable: $11,833; Deposited: $11,833; Open balance: $0
Wholesale (AR). Gross activity: $45,000; Deductions: ($1,200); Net amount receivable: $43,800; Deposited: $38,500; Open balance: $5,300
Total. Gross activity: $269,565; Deductions: ($44,263); Net amount receivable: $225,302; Deposited: $212,565; Open balance: $12,737

Use each channel’s actual fees, refunds and settlement dates.

That open balance should be supported by:

Pending payouts (per processor dashboards / payout lists)
Documented holds/reserves (tracked and aged)
Wholesale AR (open invoices, net of credits/deductions)

Investigate and document any portion of the total that cannot be supported by the underlying channel schedules.

Cash reconciliation is one part of the close. To trace stock quantities and cost into the income statement, work through Beamarc’s sample inventory-to-COGS reconciliation. The two examples use different assumptions and are not one company’s financial statements.

The month-end close checklist

This is a practical sequence, not a fantasy timeline. Adjust it to your volume.

Multi-Channel Close Checklist

Step 1 Pull source reports. Payouts/settlements per processor + bank statements for the same window. One folder per month.
Step 2 Match deposits to payout/settlement IDs. If you can’t match, you don’t reconcile yet.
Step 3 Reconcile each settlement channel. Clearing ties to pending payouts + documented holds. Fees/refunds/disputes mapped to consistent GL accounts.
Step 4 Reconcile wholesale AR. AR aging ties to open invoices; cash receipts applied; deductions documented.
Step 5 Build the consolidated bridge. Roll-up view from reconciled channels, not from dashboards.
Step 6 Investigate variances above your threshold. Set a real threshold (amount or %) and enforce it.
Step 7 File workpapers. Save exports, tie-outs, and notes so someone else can follow the trail.

What to save so this is defensible

If your workpapers are “a screenshot somewhere,” this will drift. Save the same pack every month.

Minimum workpaper pack (per month)

Bank support: bank statements (or transaction export) for the close window
Per settlement channel: payout/settlement exports + payout/settlement detail + deposit match list
Per settlement channel: clearing reconciliation (ending balance = pending + holds) + open items aging
Wholesale: AR aging + open invoice list + cash application support + deductions/credits support
Roll-up: consolidated bridge + variance notes (what changed and why)

The standard is simple: another competent person should be able to follow the trail without asking you to “explain what you meant.”

Common multi-channel mistakes

One unsupported clearing account

Use separate accounts or consistent processor-level schedules, and review the remaining balances each month.

2) Net deposits booked as revenue

Net deposits are cash. For a merchant acting as principal, revenue is recognized for the goods transferred, with appropriate discounts and returns, before separately accounted-for processor fees. An agent may recognize only its fee or commission. If you book deposits as revenue, you’ve thrown away the information needed to reconcile.

3) “Blended fee %” workpapers

Stop using a guessed percent. Fee structures vary by method, plan, country, and transaction mix. Tie to the payout/settlement detail.

4) Holds treated like normal timing

Holds/reserves are not “it’ll clear next week” items. Track them separately, age them, and follow up.

Historical differences may require reconstruction of settlements, deposits, reserves and receivables before a recurring process can be relied upon.

Completion checks

Independent

Each channel reconciled to its own support before consolidation

Explainable

Every deposit matched to a payout/settlement or AR receipt, with notes for exceptions

Aged

Clearing/holds/AR have aging with owners and follow-up

Consistent

Fees/refunds/disputes mapped consistently across channels

FAQ

Why can’t I just reconcile everything to one bank account total?

Because each channel has different settlement timing, deductions, and reporting. Reconcile each channel to its own payout/settlement (or AR) support first. Consolidate only after the channel-level tie-outs are done.

How many clearing accounts do I need for multi-channel?

Use separate clearing accounts or reliable sub-schedules for each settlement source. Wholesale invoices remain in receivables until settled; processor payments may then pass through clearing.

What’s the biggest mistake in multi-channel reconciliation?

Booking net deposits as revenue. It removes the detail needed to map fees, refunds, disputes, and timing differences, and makes reconciliation much harder.

How do I handle wholesale alongside ecommerce channels?

Use AR with an AR aging tied to open invoices. Document deductions/credits that affect collections. Wholesale cash timing and revenue timing are different concepts.

How often should multi-channel businesses reconcile?

Monthly at minimum. If volume is high, review clearing weekly so issues surface while they’re still traceable.

Use a complete balance rollforward

For each channel, begin with its supported opening receivable or clearing balance, add current activity, subtract cash received and other supported reductions, and arrive at the ending balance. The example omits opening balances for simplicity. Cash received in the month can relate to prior-period sales, while current revenue can remain unpaid.

How Beamarc can help

Beamarc provides bookkeeping, monthly close, financial reporting and accounting advisory. We can discuss the records available, the questions you need answered and the support that fits your business. Scope, responsibilities, timing and fees are agreed before work begins.

Request a consultation.