Your Ecommerce Payout Doesn't Match—Here's Where to Look

Your Payout Doesn't Match. Now What? A Practical Guide to Ecommerce Payout Reconciliation

Your Amazon or Shopify sales report says one number. The marketplace sends another. Your bank shows something else entirely.

That doesn't automatically mean money is missing. But it does mean you need a reliable way to identify what created the difference.

Effective ecommerce payout reconciliation starts by looking beyond the bank deposit. A deposit is a single number, while the transactions behind it can include sales, fees, refunds, credits, disputes, adjustments, reserves, and other activity. A clearing account gives you a place to see those components and determine whether everything has been accounted for.

A useful starting point is to compare three numbers: gross sales from the channel's order or sales report, the net payout from the settlement or payout report, and the actual bank deposit. From there, payout discrepancies generally fall into two categories: how transactions are recorded and when money moves.

One common problem is recording net deposits as sales. If fees are deducted before a payout reaches the bank, treating the deposit as revenue can hide the actual cost structure of the business. Instead, the session recommends recording gross sales and breaking deductions into the appropriate lines based on how you want to read your P&L.

Refunds and fee credits introduce another challenge because their timing may not align with the original order. Trying to force every refund back to its order date can make reconciliation unnecessarily difficult. Looking at the relevant settlement periods can provide a clearer path to the discrepancy.

Chargebacks and disputes can be even less obvious. A variance may appear and then partially reverse later. Prior-period adjustments can also surface without an obvious matching order, including certain reimbursements, corrections, platform charges, promotional credits, or other adjustment activity. These transactions should be identified and categorized rather than forced into sales or fees simply to make the books balance.

Gift cards, tips, and store credit require their own treatment because cash and revenue do not necessarily move together. Selling a gift card, for example, brings in cash before the related revenue is recognized when the card is redeemed. Keeping these transactions separated helps prevent distorted sales and payout comparisons.

Timing creates a different kind of mismatch. Multiple payment gateways can mean that only part of a day's orders appears in a particular payout. Reserves and deferred funds can leave balances outstanding even when the underlying transactions are accounted for. Month-end can also divide settlement activity across accounting periods.

The practical response is segmentation. Use clearing accounts for channels, gateways, and currencies, and separate other transaction categories where useful. Review those balances regularly rather than waiting until month-end.

Webgility can support this process by bringing ecommerce order and settlement information into the accounting workflow and mapping transaction data to the appropriate accounts. The goal isn't simply to make a mismatch disappear. It's to understand why it exists and maintain financial records that make the next discrepancy easier to diagnose.