Books with Adil

E-COMMERCE

Bookkeeping for online sellers

QUICK ANSWER

A payout is not the whole sale. Separate sales, fees, refunds, tax, and adjustments, then reconcile what reaches the bank.

Illustrative bookkeeping cover for E-commerce
Illustration. The worked figures and steps are explained below.
Jump to a section

An online seller's bank deposit often represents several things at once: customer sales, refunds, processing fees, sales tax, and settlement adjustments. Good bookkeeping separates those components and explains how they become a payout.

Start with the platform reports and a consistent accounting method. The bank deposit alone rarely tells the full story.

Separate sales from the payout

Use each platform's transaction and settlement reports to identify sales, returns, fees, tax, reserves, and other adjustments. A payout is the transfer of the amount settled by the platform; it is not automatically a new sale.

For example, assume a fictional settlement contains $12,000 of product sales, $700 of selling and processing fees, and a $60 platform subscription deduction. Assume there are no refunds, sales taxes, reserves, shipping adjustments, or timing differences. The net payout is $11,240.

ComponentAmount
Product sales$12,000
Selling and processing fees($700)
Platform subscription($60)
Net payout$11,240

Recording only $11,240 as sales hides both revenue and fees. The example separates them so the reports show what selling costs.

Use a clearing account to explain settlements

A platform clearing account records amounts awaiting settlement. It connects the sales activity to the eventual bank transfer.

In the simplified example, recording $12,000 of sales increases the clearing balance by $12,000. Recording $760 of fee and subscription deductions reduces it to $11,240. Transferring the $11,240 payout from clearing to the bank clears that settlement without recording the revenue again.

Real settlements often cross month ends or include reserves and adjustments. A remaining clearing balance may be valid if it agrees with what the platform still owes. Reconcile it instead of forcing every month to zero.

The timing of revenue depends on the accounting method and the underlying transaction. Do not assume every business should recognize income on the sale date or bank-deposit date. Agree the method and any integration settings with your accountant.

Give fees and refunds clear treatment

Track fees in categories that support useful reporting. Separate subscription costs if that helps your analysis, and compare the totals with platform reports.

Customer refunds generally reverse or reduce the original sale, with any inventory and tax effects handled consistently. A return of goods may also require restoring saleable stock and reversing the associated cost of goods sold. A chargeback needs review: an unresolved dispute, a final reversal, a recoverable amount, and a processor fee are not necessarily the same accounting event.

Document the treatment your bookkeeper and accountant agree on. Avoid a universal rule that every chargeback immediately reduces revenue regardless of its status.

Reconcile tax collected by you and by marketplaces

Separate seller-collected tax from amounts a marketplace collects and remits under its facilitator rules. Use the platform reports to identify who collected the tax, who remitted it, and which amounts belong in your own payable account.

Tax you collect and owe is generally tracked as a liability rather than sales revenue. Do not automatically create a liability for tax the marketplace is responsible for remitting.

Keep sales reports by jurisdiction and records of registrations, returns, and remittances. Selling through a marketplace does not answer every registration or filing question. Those obligations depend on the jurisdiction and business facts; your tax professional should determine them. Sales-tax record support helps organize the records and agreed workflows.

Track inventory and product costs consistently

For management reporting under a conventional inventory method, products held for sale are tracked as an asset, and their cost moves to cost of goods sold as they are sold. That helps relate product costs to the revenue they generate.

With a periodic method, a simplified calculation is beginning inventory plus purchases minus ending inventory. If beginning inventory is $8,000, purchases are $4,000, and ending inventory is $6,500, the illustrated cost of goods sold is $5,500. Additional landed costs, returns, damage, and adjustments may affect the actual calculation.

A perpetual system updates quantities and costs as activity occurs. It still needs physical counts and checks for integration errors. Neither method makes the records reliable without complete purchases, sales, and inventory adjustments.

Tax inventory treatment can differ, including available small-business methods. Do not change your method based only on a general article; discuss it with your tax professional.

Understand what a Form 1099 K can and cannot tell you

Use Form 1099-K alongside transaction records, not as a replacement for them. Gross reportable payments may differ from bank payouts and from the revenue ultimately reported after the appropriate reconciliation.

Fees, refunds, tax amounts, timing, and other adjustments can require explanation. Keep a documented bridge between the platform reports, tax forms, and books. Ask your preparer how the information should be used for your return rather than forcing the P&L to equal a single form.

Follow a monthly settlement routine

Our bookkeeping checklist provides the broader close routine. If deposits are unexplained or the integrations have created duplicates, begin with a cleanup assessment.

Book a free consultation to discuss your sales channels, settlement records, and reporting needs.

Three things to remember

  • Explain sales, fees, refunds, and adjustments behind each payout.
  • Reconcile the clearing account to amounts the platform still owes.
  • Keep inventory and tax records consistent with your agreed accounting method and responsibilities.

Sources and further reading

WhatsApp