Skip to content
Enjoy complimentary data migration when switching from your existing bookkeeper or CPA to Institution.

Bookkeeping & finance

Ecommerce bookkeeping: reconcile sales before trusting the payout

Reconcile online orders with refunds, taxes, processor fees, payouts, and inventory so sales, margins, and cash can be explained.

By Institution2 minute readUpdated View sources
In this guide

Follow an order all the way to the bank

An online store can sell $10,000 of goods without receiving a $10,000 deposit. The payment platform may deduct fees, hold a reserve, issue refunds, process disputes, or pay out on a different day. Posting only the bank deposit as sales hides what the store earned and what it spent to collect the money.

Start with the store's order report and the payment processor's settlement report for the same period. Reconcile gross sales, discounts, returns, sales tax collected, processor fees, disputes, and net payouts. Differences often come from timing rather than missing money, but they need an explanation.

Keep inventory separate from operating expenses

Goods bought for resale generally need different treatment from office supplies or marketing costs. Track stock purchases, units sold, returns, damaged goods, and the method used to value inventory. Your accountant should determine the appropriate accounting and tax treatment for your business.

If you sell through more than one channel, agree on which system holds the inventory quantities and which reports are authoritative. A marketplace return processed after month-end should not disappear simply because the sale happened last month.

Build a monthly channel reconciliation

Reconcile each significant marketplace or storefront separately, then tie the total to the accounting records. Check whether fees are recorded as expenses rather than netted into sales, whether refunds are assigned to the right period, and whether payout balances still in transit are recognized.

Keep a schedule for processor clearing accounts. An unexplained balance that grows every month often signals missing payouts, duplicated imports, or fees posted to the wrong account.

  • Orders and refunds agree to platform reports.
  • Platform fees, advertising deductions, and disputes have separate explanations.
  • Payouts reconcile to bank deposits, including amounts still in transit.
  • Inventory movements and cost of goods sold use a consistent method.
  • Sales tax collected is kept distinct from the store's revenue.

Use the result to understand margin

Once the reconciliations are reliable, compare gross margin by product group or sales channel. A channel with attractive sales may have high fulfillment, payment, return, or advertising costs. Keep those costs visible enough to see the difference.

Do not start with a complicated dashboard. Start with one closed month that agrees from order to payout. Repeat the routine, then add more useful detail as the business grows.

Records worth keeping

Preserve sales exports, payout reports, inventory counts, purchase invoices, refund and dispute evidence, and the adjustments used to close each month. They support tax reporting and make it much easier to change accounting providers without reconstructing years of sales.

Sources

Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.

Related reading

Need help with this work?

General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.