The biggest mistake multi-channel sellers make is recording the deposit that hits the bank as sales revenue. That number is net of fees, refunds, sales tax collected, advertising charges, and any reserve the platform is holding. If you book $18,400 as sales when gross sales were actually $24,200, your revenue is understated, your fees aren’t tracked, and your tax return will look strange compared to the 1099-K the platform files.

Each channel needs its own reconciliation using its own reports. Amazon, Walmart, and Shopify all structure payouts differently and you can’t apply the same workflow to all three. Pull the payout report or settlement report from each platform for the period, then break out the components into your books.

For Amazon, the settlement report shows gross product sales, FBA fees, referral fees, advertising charges, refunds, reimbursements, and any reserve adjustments. Amazon also holds a rolling reserve for newer sellers or higher-risk categories, which means the deposit and the sales activity won’t match in the same period. The reserve gets recorded as a receivable so your books reflect money the platform owes you but hasn’t released yet.

Walmart works similarly with its own fee structure. Walmart Fulfillment Services charges, referral fees, and shipping fees come out before payout. The settlement report breaks these down. Refunds and chargebacks show as deductions against gross sales. Walmart payouts often run on a different schedule than Amazon, so you can’t assume the periods align.

Shopify is more straightforward because you control the storefront, but the payment processor adds another layer. Shopify Payments, PayPal, and any other processors each have their own fee structures and payout timing. Sales tax collected through Shopify needs to be tracked as a liability, not revenue. If you sell on Shopify and also use it as your inventory hub for other channels, the channel attribution in your reports has to be accurate or your margin analysis won’t make sense.

The work is essentially the same pattern repeated for each channel. Pull the report, separate gross sales from fees and refunds, account for sales tax as a liability, post any reserve to a receivable, and match the final net to the bank deposit. That’s why ecommerce payment matching is priced with an additional $75 per sales channel. Each one is its own monthly reconciliation with its own quirks.

Reconcile monthly at minimum. Letting six months of Amazon settlements pile up means you’re trying to untangle hundreds of fee categories and dozens of refunds with no memory of what happened. Monthly reconciliation also catches problems while you can still do something about them, like a refund spike that signals a product issue or advertising spend that outran its return.

If you’re running multiple channels and trying to handle this yourself in QuickBooks without a proper system, the numbers are almost certainly wrong. Small business accounting, bookkeeping and tax services in Jacksonville, NC for ecommerce sellers should include channel-by-channel reconciliation that ties gross sales, fees, refunds, and reserves back to what the platforms actually report. That’s the only way to know what each channel is truly contributing to the business.