The Payout Problem: Why Your E-Commerce Books Are Probably Wrong

Ask anyone who does e-commerce bookkeeping for a living what causes the most errors and the answer is consistent: payouts. Not sales tax, not inventory — payouts. Here is the problem in one example. Amazon sends you a $14,000 bi-weekly deposit. Your bank feed imports it, and a generic bookkeeping setup books $14,000 of revenue. But the deposit is a net figure. What actually happened during that settlement period was something like: $17,800 in gross sales, minus referral fees, FBA fees, refunds you issued, a reserve Amazon is holding, advertising charges deducted from the payout, and a handful of adjustments. Book the net number as revenue and your gross sales are understated, your fees are invisible, your refund rate is untracked, and your margin by channel is unknowable. Multiply that across Shopify payouts, marketplace settlements, and a POS system, each with its own schedule and fee structure, and you get the situation we see constantly: a profitable-looking business whose owner cannot say what any single channel actually earns. Three ways to fix it, in increasing order of involvement: Connector tools. A2X and Link My Books pull settlement-level detail from the platforms and post properly split journal entries to QuickBooks or Xero. Typical cost runs $50–300 per month per channel. They are accurate and well-tested, though the output still needs human review for categorisation edge cases, and the subscriptions stack up when you sell on several channels. A correctly built chart of accounts plus a monthly process. A bookkeeper fluent in e-commerce can structure the ledger so every payout splits into gross sales, fees, refunds, and reserves consistently, without extra software. It costs less in tools and more in monthly discipline — and it only works if the person doing it genuinely understands marketplace settlement mechanics. Handing the whole function to a finance operations team. This is what our clients typically do once they are selling on three or more channels: the reconciliation, the close, and a plain-language variance summary arrive monthly, and their accountant receives clean files at year-end. A quick test of whether you have this problem: ask whoever does your books what your gross sales, total marketplace fees, and refund total were last month, per channel. If the answer requires an hour of digging, your books are recording deposits, not business activity — and every decision you make from those numbers inherits the error.