eCommerce Accounting: How Every Order, Fee and Return Should Reach Your Ledger

In brief: eCommerce accounting is recording and reporting the financial side of selling online: revenue from every channel, marketplace and payment fees, returns and refunds, taxes collected or withheld, inventory and cost of goods sold, and the payouts that settle them. eCommerce bookkeeping is the day-to-day recording; accounting adds the reporting, tax and analysis built on it.

In a shop, a sale is simple: money in, goods out. Online, one sale creates a chain of events that reach the books at different times. The order is placed, shipped and invoiced. The marketplace deducts commission, shipping and payment fees, and in some countries withholds tax. The payout arrives days or weeks later, bundled with other orders. A return may reverse part of it next month.

Good eCommerce accounting turns that chain into clean entries: revenue in the right period, every fee in the right expense account, every return credited and every rupee or dollar of payout traced back to its orders.

In brief: Marketplace accounting breaks because payouts are net of fees and taxes, cover many orders across several periods, arrive on each platform's own schedule, and include returns and adjustments for earlier sales. Booking the payout as revenue, or keying data by hand from many portals, leaves revenue overstated or understated and margins impossible to trust.

• Net payouts. Marketplaces pay what is left after commission, shipping, advertising and payment fees. Recording the payout as sales hides every one of those costs.
• Mixed periods. One payout can include orders from two months and refunds for orders from a third.
• Many fee types. Commission, fixed and closing fees, fulfillment and weight charges, storage, advertising, penalties and collection fees each need their own home.
• Returns that lag. Refunds, return-to-origin orders and reversals land after the sale, often in a later settlement.
• Taxes withheld at source. In India, marketplaces withhold TCS and TDS before paying out; in the US, marketplaces collect and remit sales tax in most states.
• Too many sources. Each channel has its own reports and formats, and copying them into the ledger by hand is slow and error-prone.

In brief: Every operational event should create a predictable entry: a shipped order raises revenue and a marketplace receivable, fees and withheld taxes reduce that receivable, the payout clears it to the bank, returns reverse revenue and tax through a credit note, and stock movements update inventory and cost of goods sold.

Note: Account names vary by chart of accounts and by country, and treatment can differ by business. Confirm your setup with your accountant.

The marketplace receivable, often called a clearing account, is what makes this work. Sales, fees, taxes and payouts hit it at different times, but once a settlement cycle is complete, its balance for that cycle should be zero. Anything left over is a fee you have not recorded, a payout you have not received, or money the marketplace owes you.

The flow: Order, invoice, marketplace receivable, fees and taxes, payout, bank.

In brief: Cash basis records income and costs when money moves; accrual basis records them when they are earned or incurred. eCommerce brands of any size usually need accrual, because marketplace payouts arrive weeks after the sale and net of fees, so cash basis shows the wrong revenue in the wrong month.

Under cash basis, a sale made on 28 March but paid out on 10 April counts as April income, and the fees deducted from it may never be recorded at all. Under accrual basis, the sale is March revenue, the fees are March costs, and the payout simply clears the receivable in April. Accrual takes more discipline, but it is the only way to see real margin by month and by channel, and companies reporting under standard accounting frameworks are generally required to use it.

In brief: Give each marketplace fee type its own expense account, so you can see what each channel really costs. Record every return through a credit note against the original invoice, with the matching stock entry. Treat taxes the marketplace collects or withholds as tax balances, not costs, and reconcile them to the platform's filings.

Marketplace fees

Typical categories: commission or referral fees, fixed or closing fees, shipping and weight-based fulfillment charges, storage, advertising, payment or collection fees and penalties. Recording them separately turns the profit and loss into a channel cost report, and makes it obvious when a fee jumps.

Returns and refunds

Raise a credit note against the original invoice for every return, so revenue and output tax are reversed in the books and in tax filings. Then record what happened to the unit: restocked to inventory, or written off if damaged. Returns that are refunded but never received, or received but never credited, are among the most common gaps in eCommerce books.

Taxes and GST reconciliation

In India, sellers charge GST on marketplace sales and file it, while marketplaces withhold TCS under GST and TDS under income tax before paying out; both are credits to claim, not costs. Our guide to TCS under GST covers how. GST reconciliation then means matching your sales register to your GST returns, your purchase register to the input tax credit available, and the TCS you were credited to what each marketplace filed. In the US, marketplace facilitator laws mean the marketplace collects and remits sales tax on most marketplace sales, so that tax should pass through your books without being counted as revenue or reported again.

In brief: Payouts lag sales and bundle many orders, so the ledger needs every settlement matched to its orders, fees, returns and taxes before the period closes. The marketplace receivable shows what is still open. Matching settlements line by line is reconciliation, and it is the step that proves the books are complete.

Accounting records what should have happened; reconciliation proves what did. Each settlement has to be broken into its orders, fees, refunds and taxes and matched against your own records, so the marketplace receivable clears and any underpayment becomes a claim. Our guide to eCommerce payment reconciliation covers that process in depth, and the order-to-cash process shows where it sits between the order and the bank.

In brief: The right accounting software depends on size and country: Tally is common in India, QuickBooks and Xero with smaller and mid-size businesses globally, and SAP or NetSuite in enterprises. What matters most is the integration: invoices, credit notes, purchases, stock and settlement breakdowns should post automatically from your operations platform.

The accounting system is the ledger. It was not built to pull orders from five marketplaces, track returns through a warehouse or split a settlement into twenty fee lines. So the real choice is how your operations data reaches it:

• Order-level or summarized postings. Order-level entries give full audit trails; daily or per-settlement summaries keep large ledgers manageable. Many businesses post invoices individually and settlements in summary.
• Chart of accounts mapping. Decide once which account each fee type, tax and channel maps to, and keep it consistent.
• Tax codes. Invoices should arrive with the right tax treatment already applied, by state, country and product.
• Credit notes linked to invoices, so returns reverse the right sale.
• Inventory and cost of goods sold posted from the warehouse, so the books and the shelves agree.

EasyEcom integrates with the ledgers brands already use. In Tally, marketplace and storefront sales post as vouchers with GST detail intact, receipts against purchase orders raise purchase entries, and returns post as credit notes against the original invoice. In SAP, sales orders, inventory movements, invoices and credit notes post in near real time, and marketplace settlements are matched to ledger entries. QuickBooks receives two-way postings of invoices with tax and credit notes for returns, while Xero receives invoices with tax codes applied and payouts broken into revenue, commission, shipping and fees, so the bank feed matches.

In brief: Close the month by confirming every order is invoiced and every return credited, importing and matching all settlements, classifying fees, recording withheld taxes and reconciling tax reports, reconciling inventory and cost of goods sold, accruing what has not settled, reconciling the bank, reviewing margin by channel and locking the period.

1. Invoices and credit notes. Confirm every shipped order has an invoice and every processed return has a credit note.
2. Settlements. Import every marketplace and payment gateway settlement for the month.
3. Match. Match settlement lines to orders, fees, refunds and taxes; clear the marketplace receivable for completed cycles.
4. Fees. Classify every fee into its expense account and flag unusual ones for claims.
5. Taxes. Record taxes withheld or collected by marketplaces, and reconcile your sales and tax reports to each other and to platform filings.
6. Inventory. Reconcile stock to the ledger, record count variances and write-offs, and confirm cost of goods sold.
7. Accruals. Accrue sales and fees for orders shipped but not yet settled.
8. Bank. Reconcile bank and gateway accounts.
9. Review. Check revenue, fees and margin by channel against last month and investigate anything that moved sharply.
10. Lock. Close the period so later changes go through adjustments, not edits.

In brief: EasyEcom runs the operations side, orders, returns, stock and settlements, and posts it to your ledger automatically, so finance works from verified entries instead of exports. EasyReco reconciles every payout, return and fee across marketplaces, and the integrations post invoices, credit notes and settlement breakdowns to Tally, SAP, QuickBooks or Xero.

Most eCommerce accounting pain is a data problem: the ledger is fine, but getting clean, complete operations data into it is not. EasyEcom handles orders, returns and stock across every channel, EasyReco reconciles every marketplace payout, return and fee, and the results post to the accounting system you already run.

The difference shows up in the finance team. Borosil eliminated 100% of manual data entry into SAP and cut its accounting workforce cost by 75%. Swiss Military reconciles 85% faster on EasyEcom at up to 99.99% accuracy, with invoices and credit notes syncing straight to Tally.

Closing the books from a dozen portal exports? Book a demo and we will walk through your order-to-ledger flow with you.