Ecommerce Bookkeeping: A Beginner’s Guide

Ecommerce bookkeeping records what an online business sold, what it refunded, what platforms and processors withheld, what inventory cost, and what cash actually reached the bank. The hardest part is not entering a deposit. It is explaining every difference between customer activity, platform reports, processor settlements, inventory records, and bank deposits.

A payout is rarely the same as revenue. It may combine orders from several days and subtract processing fees, marketplace commissions, refunds, chargebacks, shipping labels, advertising, loans, reserves, or sales tax. Recording the net payout as sales understates both revenue and expenses and can leave tax and inventory balances unreliable.

The records an ecommerce business needs

Keep the order-level or summarized sales report, payout report, processor statement, refund and chargeback detail, fee report, sales-tax report, inventory movement, purchase documents, shipping records, bank statements, and supporting invoices. The IRS allows a recordkeeping system suited to the business when it clearly shows income and expenses, but electronic records must still support the entries.

• Sales by channel, date, product, discount, shipping, and tax
• Processor or marketplace clearing activity for every payout
• Refunds, returns, store credits, gift cards, and chargebacks
• Platform, payment, subscription, advertising, and fulfillment fees
• Inventory purchases, landed cost, adjustments, and cost of goods sold
• Sales-tax collected, payable, filed, refunded, and remitted
• Owner contributions, draws, loans, and transfers kept separate from sales

Use a clearing account for each material channel

A clearing account is a temporary balance-sheet account. Gross activity enters the account, deductions reduce it, and the final payout moves to the bank. When every component is recorded correctly, the account returns to the amount still held by the platform or processor.

For example, a channel reports $10,000 of product sales, $500 of shipping charged to customers, $700 of sales tax, $400 of refunds, and $350 of fees. The processor deposits $10,450. The books should preserve the components instead of calling the entire deposit revenue. The clearing account links the $10,800 customer collection after refunds to the $350 fee and $10,450 payout.

A reliable monthly workflow

1. Lock the reporting period and export each channel’s orders, adjustments, fees, taxes, and payouts.
2. Record gross sales, discounts, refunds, shipping income, gift-card activity, and sales tax using consistent mappings.
3. Record processor and marketplace fees separately so their amount and trend remain visible.
4. Match every payout to the channel clearing account and then to the bank statement.
5. Reconcile inventory quantities and values, then record supported cost of goods sold and adjustments.
6. Reconcile cash, credit cards, loans, sales tax, gift cards, and other balance-sheet accounts.
7. Review the profit and loss, balance sheet, margins, unusual transactions, and unresolved clearing balances.

Revenue, refunds, and discounts

Choose a consistent policy for presenting discounts and refunds. Product revenue should exclude sales tax collected for a taxing authority. Shipping collected from customers and shipping paid to carriers should be mapped deliberately rather than netted accidentally. A refund should reverse the appropriate revenue and tax amounts, while the returned item’s inventory and cost treatment depends on whether it can be resold.

Gift-card sales usually create a liability until redemption or another recognized event under the applicable accounting and legal rules. Store credit can have similar implications. Do not recognize every cash receipt as immediate revenue without reviewing the arrangement.

Inventory and cost of goods sold

Inventory bookkeeping connects purchases, freight, duties, receiving, assembly, transfers, sales, returns, damage, shrinkage, and ending quantities. The accounting system, ecommerce platform, warehouse, and physical count should agree after documented timing differences.

Landed cost can include more than the supplier invoice. Establish a policy for freight, duties, brokerage, packaging, and production overhead with an accountant who understands the business. Use a consistent costing method and do not overwrite historical costs merely to force an inventory report to match.

Negative quantities, old receiving transactions, duplicate SKUs, bundles, and unrecorded write-offs are common warning signs. Reconcile high-value and fast-moving items more frequently than the annual count.

Sales tax is not sales

Amounts collected from customers for sales tax are generally tracked as a liability until remitted. Marketplace facilitator rules may cause a marketplace to collect and remit certain tax, but the seller still needs records that explain gross transactions, facilitated tax, direct-channel obligations, filed returns, payments, and notices.

Taxability, nexus, registration, filing frequency, and local rules vary. A bookkeeping system can organize evidence, but it does not determine legal obligations by itself. Reconcile each filed return to the sales reports and liability ledger before recording the payment.

Multi-currency and timing differences

International channels can create foreign-currency sales, processor conversion fees, exchange gains or losses, duties, and different settlement dates. Preserve the transaction currency, functional-currency amount, exchange rate source, and settlement evidence. Do not plug the difference to revenue when it may be a fee or currency effect.

Month-end payouts often include orders from one period and settle in the next. A clearing account separates earned activity from cash timing. Document the cutoff used for sales, returns, goods in transit, and inventory receipts.

Choose software by workflow, not by logo

The best ecommerce bookkeeping software is the configuration that captures all material channels, retains usable source detail, posts controlled summaries, handles inventory complexity, and can be reconciled. More automation is helpful only when mappings are reviewed and exceptions are visible.

Reports that help manage the business

Monthly reports should show gross and net sales by channel, refund and chargeback rate, processing and marketplace fees, gross margin by meaningful category, inventory turnover, aged inventory, advertising spend, contribution margin, sales-tax liabilities, cash, and unresolved reconciliation items.

Compare results with the prior month, prior year, and operating plan. A rise in deposits can coexist with falling margin if discounts, ad spend, fulfillment, returns, or product cost increased. Keep the accounting definitions stable so trends reflect the business rather than mapping changes.

Internal controls for a small ecommerce team

Restrict administrative access, require multifactor authentication, review new bank and payout details, separate refund approval from recordkeeping where practical, and monitor changes to integrations. The owner should review bank reconciliations, large refunds, chargebacks, unusual vendors, negative inventory, and clearing balances.

Document who can create products, change prices, issue credits, edit payout accounts, approve bills, release payments, and change accounting mappings. Even a two-person business can use alerts, approval thresholds, independent statements, and a monthly owner review.

Year-end readiness

Before year end, confirm that every channel and processor is reconciled through the cutoff, inventory counts are documented, gift-card and sales-tax liabilities are supported, fixed-asset purchases are identified, and loan or advance balances agree with providers. Export annual sales, fee, refund, payout, and inventory reports before platform retention windows expire.

Compare platform information returns and processor statements with the books, but do not replace transaction records with a tax form total. Investigate timing, duplicate reporting, refunds, and entity differences with the tax professional. Preserve the reconciliation that explains the final reported revenue.

Continue with the ecommerce chart of accounts, compare a broader bookkeeping system, and review virtual bookkeeping services.