Multi-channel e-commerce accounting software

Selling on several platforms multiplies settlement reports, fee structures and VAT rules; the accounting set-up has to treat each channel the same way so the business sees one true picture.

A seller with a Shopify store, an Amazon account, eBay listings and an Etsy shop has four sources of sales, four fee structures, four payout schedules and four sets of VAT reports. Without a consistent set-up, month-end turns into rebuilding spreadsheets, and nobody knows which channel actually makes money.

What the accounts need

Requirement Why
A clearing account per channel each payout can be matched to its own report and the balance explained
Sales accounts or tracking by channel gross margin by channel, not just in total
Fee accounts by type referral, transaction, processing, advertising, fulfilment
One VAT code set for all channels the same product taxed the same way everywhere
Stock valued once, centrally inventory does not depend on which platform sells it

Accounting software for multi-channel selling should import each platform’s settlement or transaction data into that structure, rather than posting net payouts.

Channel-specific quirks

Marketplaces also act as the deemed supplier for some sales and collect the VAT themselves. The seller’s records must show which sales those are, so the VAT is not declared twice.

Stock across channels

When the same stock is listed on several platforms, an inventory or listing tool usually keeps quantities in sync. For the accounts, three things matter at month end:

  1. One stock figure: the stock count or the inventory system’s valuation is the figure for the balance sheet, whatever each platform reports.
  2. Stock at fulfilment centres: goods held in Amazon’s warehouses are still the seller’s stock; include them, valued at cost.
  3. Cost of sales by channel: if the inventory system records the cost of each item sold, cost of sales can be split by channel; otherwise allocate it using sales mix and note the method.

Returns, damaged goods reimbursed by a marketplace and stock written off should be posted every month, not left for the year-end count.

A monthly close for multi-channel sellers

  1. Import sales, refunds and fees for every channel.
  2. Match each payout to the bank and explain each clearing balance.
  3. Agree the VAT on sales to each platform’s tax report.
  4. Update stock and cost of sales.
  5. Review margin by channel after fees and advertising.

For the inventory accounts themselves, see inventory accounts in the chart of accounts; for e-commerce more broadly, e-commerce accounting.

Nexbal is launching in the UK · beta open

Join the Nexbal beta

Early access, 30 days free, and your feedback shapes the product.