E-commerce Bookkeeping: Why Your Sales Never Match Your Bank Deposits

Your storefront reports one number for monthly sales. Your bank shows a smaller one. Nothing is necessarily missing, but without the right structure in your books, you cannot prove it. E-commerce bookkeeping often fails at the same four points: payouts, inventory, refunds, and multiple sales channels. Each is fixable once you know what to look for.

Why Payouts Never Equal Sales

Payment processors and marketplaces do not deposit your total sales. They deposit a net payout after subtracting processing fees, refunds, charge backs, and sometimes reserves or advertising charges. A single deposit may cover several days of orders, and it reflects the date on the processor’s schedule rather than the order date.

If you are booking each deposit as revenue, your sales are understated and the processing fees are buried. This creates unreliable month-end totals, because orders and payouts routinely fall in different months.

Use a Clearing Account for Each Channel

Record gross sales as revenue when an order is created, by posting them to a clearing account for that sales channel. Post fees, refunds, and charge backs to their own expense or contra-revenue accounts. When the payout reaches your bank, it moves out of the clearing account.

The clearing balance should equal what the processor still owes you. If the balance drifts and you cannot explain it, a fee, refund, or payout is probably missing from the books.

Track Inventory and Cost of Goods Sold

Inventory purchases are not expenses until the product sells. Record purchases to an inventory asset account, then move the cost to the cost of goods sold as items ship. Where your accounting method calls for it, include freight-in and other costs of getting product to your warehouse.

Items returned to the shelf should be returned to inventory at their original cost. Count physical stock at least once a year and reconcile the count to the ledger. Without that step, your gross margin is an estimate.

Handle Refunds and Charge backs Correctly

Refunds reduce revenue. Record them as contra-revenue, not as an operating expense, keeping gross sales and returns separate and visible, showing you which products or channels generate the most returns.

Charge backs add a second cost: the reversed sale plus a dispute fee and any shipping fees that might have been incurred. Track each one by status, since a dispute you win returns the funds. Book refunds and charge backs in the period they occur, even when the original sale fell in an earlier month.

Reconcile Every Channel Monthly

A business selling through its own website, a marketplace, and wholesale accounts has three sets of reports. Reconcile each channel’s sales report to the ledger, and each payout to a bank deposit, before you close the month.

Sales tax collected on behalf of states is a liability, not revenue. Obligations vary by state and by sales volume, so confirm where you are required to collect and remit.