Booksmrt

Industry guide

E-commerce bookkeeping

E-commerce books have to connect storefront sales, processor settlements, refunds, fees, sales tax, inventory, and bank deposits without treating deposits as revenue.

Reviewed by the Booksmrt bookkeeping teamLast reviewed 2026-07-27

What the monthly close has to prove

  • Reconcile gross orders to refunds, discounts, tax, fees, and net processor deposits.
  • Use clearing accounts so settlement timing does not distort sales.
  • Separate inventory purchases, cost of goods sold, shipping, and operating expenses.
  • Review chargebacks, reserves, gift cards, and sales-tax liabilities.

Documents to collect

  • Storefront sales summary
  • Processor settlement report
  • Bank and card statements
  • Inventory or purchase records
  • Refund and chargeback detail
  • Payroll reports

Common failure points

  • Net deposits recorded as revenue
  • Processor fees omitted
  • Transfers between processors and banks duplicated
  • Inventory purchases expensed inconsistently
  • Sales tax included in revenue

Example

A $9,200 Shopify payout may represent $10,500 of orders less refunds, fees, and tax activity. The deposit alone cannot support the revenue entry.

Educational information only. Booksmrt provides bookkeeping services, not tax, legal, audit, or investment advice. Confirm material accounting and tax decisions with the appropriate professional.