Selling on more than one channel is one of the fastest ways to grow an online business. For example, a Shopify store brings in direct customers, while Amazon offers greater reach. Similarly, eBay, Etsy and TikTok Shop each open opportunities to reach different audiences. However, every new channel also introduces different ways of collecting payments, deducting fees and processing payouts.
Amazon settlements can include referral fees, FBA fulfilment charges, refunds and reserves. If these transactions become difficult to reconcile, specialist Amazon FBA bookkeeping support can help correct inaccurate records.
This guide explains how to maintain one clean set of books across all your sales channels. First, it covers how to structure your accounts and manage data from each marketplace. Next, it provides a practical bookkeeping example covering four sales channels. Finally, it outlines a simple month-end routine your team can follow to keep financial records accurate and organised.
Quick answer: how do you do bookkeeping for multiple e-commerce channels?
Give every sales channel its own clearing account, record gross sales and every fee, refund and adjustment through it, and treat each payout as a transfer to your bank. Tag income and costs by channel using tracking categories or classes. Bring each channel’s data in through one route only, then reconcile every clearing account to the channel’s own report at month end.
Key takeaways
- Each channel pays you differently, so each needs its own clearing account, and one per currency where relevant.
- Record sales gross and fees separately. Recording payouts as sales understates turnover and hides costs.
- Use one data route per channel. Two routes for the same channel is the most common cause of double-counted sales.
- Tag income, fees and cost of goods sold by channel so you can see profit per channel, not just in total.
- Reconcile every clearing account at month end. A balance that keeps growing is a warning sign, not a rounding issue.
Why do multi-channel e-commerce books get so messy?
Multi-channel books get messy because every marketplace collects your money, deducts its own fees and pays you out on its own schedule and in its own report format. As a result, no two deposits necessarily represent the same type of transaction. Furthermore, recording each channel differently or relying only on bank deposits can lead to inaccurate sales, fees and tax figures across the business.
The root problem is that your bank statement only shows the final amount received. For example, a £4,312 deposit from Amazon might include £6,900 in sales, £1,950 in fees, £410 in refunds and a reserve held back from the period. Similarly, a £780 deposit from Etsy might include deductions for listing fees, advertising and currency conversion. However, both deposits appear as simple income in your bank feed, making it difficult to understand the actual sales and expenses.
How each channel pays you
The table below summarises the general pattern for each major channel. The exact timing, fee names and reserve rules vary by region and account, so always check against the channel’s own payout or settlement report.
| Channel | How you get paid | What is deducted before payout | Main report to reconcile against |
|---|---|---|---|
| Shopify (Shopify Payments) | Regular payouts of card sales, typically every few business days | Payment processing fees, refunds, chargebacks, some app or adjustment charges | Payouts report with transaction detail |
| Amazon | Settlement transfers at the end of each settlement period, typically around every two weeks | Referral fees, FBA fulfilment and storage fees, advertising (if charged to the balance), refunds, reserves | Settlement report (flat file or summary) |
| eBay | Payouts through eBay’s managed payments, on a schedule you can set | Final value fees, per-order fees, promoted listings, international fees, refunds, holds | Payouts report and transaction report |
| Etsy | Deposits from Etsy Payments on a regular schedule | Listing fees, transaction fees, payment processing fees, Etsy Ads, currency conversion | Payment account monthly statement and CSV |
| TikTok Shop | Settlements paid out once orders pass the settlement window | Commission, payment fees, affiliate commissions, campaign charges, refunds | Settlement or finance statement in Seller Center |
Three things make this hard:
- Different timing. A sale made on 30 June might be paid out on 2 July by Shopify and on 10 July by Amazon. If you only record deposits, June sales land in July.
- Different deductions. Each channel deducts a different mix of costs, often with names that change. Without a consistent structure, fees end up spread across random expense accounts, or missing entirely.
- Different currencies and regions. Sellers on Amazon UK, Amazon US and Etsy may receive payouts in pounds, dollars and euros, each with its own conversion charge.
The answer is not more spreadsheets. It is one consistent structure that treats every channel the same way, whatever its report looks like.
How should you structure one set of books for several sales channels?
Use one chart of accounts with a clearing account per channel and currency, shared income and cost accounts for sales, fees, refunds and cost of goods sold, and a tracking category or class for each channel. This keeps the chart short and readable while still giving you profit by channel at the click of a report.
Option A: separate accounts for every channel (not recommended)
Some businesses create “Amazon Sales”, “Shopify Sales”, “eBay Sales”, “Amazon Fees”, “Shopify Fees” and so on. It works for two channels. By five, the chart of accounts has dozens of near-duplicate lines, reports become unreadable and staff post to the wrong ones.
Option B: shared accounts plus channel tracking (recommended)
Keep one set of income and expense accounts, then tag every line with its channel. In Xero this is a tracking category, for example “Sales Channel” with options Shopify, Amazon UK, Amazon US, eBay, Etsy and TikTok Shop. In QuickBooks Online the equivalent is classes or locations.
| Account | Type | Purpose | Tagged by channel? |
|---|---|---|---|
| Shopify Payments Clearing (GBP) | Current asset / bank | Holds Shopify sales, fees and refunds until paid out | Not needed: the account is the channel |
| PayPal Clearing (GBP, USD) | Current asset / bank | One per currency held | Not needed |
| Amazon Clearing UK (GBP), Amazon Clearing US (USD) | Current asset / bank | One per marketplace currency | Not needed |
| eBay Clearing | Current asset / bank | eBay managed payments balance | Not needed |
| Etsy Clearing | Current asset / bank | Etsy Payments balance | Not needed |
| TikTok Shop Clearing | Current asset / bank | Unsettled TikTok Shop balance | Not needed |
| Marketplace Reserves | Current asset | Amounts held back by a channel | Optional |
| Sales | Revenue | Gross product sales | Yes |
| Shipping Income | Revenue | Shipping charged to customers | Yes |
| Refunds and Returns | Revenue (contra) | Refunded sales | Yes |
| Marketplace and Selling Fees | Cost of sales | Referral, final value, commission and transaction fees | Yes |
| Payment Processing Fees | Cost of sales | Card and payment fees | Yes |
| Fulfilment and Storage | Cost of sales | FBA, third-party logistics, storage | Yes |
| Advertising | Expense | Sponsored products, Etsy Ads, promoted listings, TikTok campaigns | Yes |
| Cost of Goods Sold | Cost of sales | Product cost of units sold | Yes |
Why clearing accounts sit at the centre
A clearing account works like a bank account you do not control. For example, each marketplace collects money for you, deducts fees and pays you the remaining balance. Meanwhile, the clearing account records all these transactions. When a payout arrives in your business bank account, you record it as a transfer from the clearing account. As a result, if all transactions are recorded correctly, the clearing balance at any date should match the amount the channel owes you. For more detailed guidance, see our guide to setting up clearing accounts for Shopify Payments, PayPal and Stripe.
A note on tax
If you are VAT-registered or collect sales tax, tax codes must follow the same channel logic. For example, marketplace facilitator rules mean Amazon, eBay, Etsy and TikTok Shop may collect and remit some sales tax or VAT on your behalf in certain countries. In contrast, Shopify stores generally remain responsible for managing their own tax collection and reporting, depending on the applicable rules. Set tax codes per channel and region, and confirm the position with your accountant for each marketplace you sell on.
How do you get sales data from each channel into your accounting software?
Choose one route per channel: a connector app that posts summarised entries per payout or settlement, a direct integration, or a manual journal from the channel’s report. Never combine two routes for the same channel. Summarised entries per payout are usually best, because they match how money actually reaches your bank.
The three main routes
- Summary connector apps. Tools such as A2X and Link My Books read each payout or settlement and post one summarised entry into the clearing account, split into sales, fees, refunds, shipping and tax. These tools work with Shopify, Amazon and several other marketplaces. In addition, they support channel tracking to help businesses organise their financial records.. Our comparison of A2X, Link My Books and Synder covers the differences.
- Direct integrations. Some platforms and apps push every order into Xero or QuickBooks as an individual invoice. This can work at low volume but quickly floods the ledger with thousands of transactions and makes reconciliation slow.
- Manual journals. For a small sales channel with only a handful of payouts each month, you can use a monthly journal based on the channel’s report. However, you must prepare the journal every month and check the figures against the actual payouts to maintain accurate records.
The one-route rule
The most common cause of overstated sales is two routes feeding the same channel. A typical example: a Shopify app creates an invoice for every order, and a summary connector also posts Shopify payouts. Every sale is now in the books twice. Another example is reconciling Amazon deposits as income directly from the bank feed while a connector posts the same settlements.
Write down, in one place, how each channel enters the books:
| Channel | Route | Posts to | Posted by | Frequency |
|---|---|---|---|---|
| Shopify | Summary connector | Shopify Payments Clearing | Connector app | Per payout |
| Amazon UK and US | Summary connector | Amazon Clearing UK / US | Connector app | Per settlement |
| eBay | Summary connector or manual journal | eBay Clearing | Bookkeeper | Per payout or monthly |
| Etsy | Manual journal from monthly statement | Etsy Clearing | Bookkeeper | Monthly |
| TikTok Shop | Manual journal from finance statement | TikTok Shop Clearing | Bookkeeper | Monthly |
This table becomes your data map once you adapt it to your business. As a result, new team members can quickly understand where each sales channel’s numbers should come from. Furthermore, if any information does not match the data map, your team can identify and investigate the differences.
Bank feed rules
With clearing accounts in place, the bank feed only needs one rule per channel. For example, payouts from each marketplace should be recorded as transfers from its clearing account. In addition, you should turn off any bank rules that record marketplace deposits directly as sales. Otherwise, these rules can lead to double-counted transactions, making them a common cause of inaccurate bookkeeping.
What does a month of multi-channel bookkeeping look like in practice?
In practice, you record each channel’s gross sales, refunds and fees in its clearing account. Next, you record each payout as a transfer from the clearing account to your business bank account. As a result, the remaining clearing balance represents the money still owed by the channel. Furthermore, tagging transactions by channel allows you to turn these entries into a profit-by-channel report.
The example below follows a fictional UK seller, Harbour & Co, through one month of trading on Shopify, Amazon UK, Etsy and TikTok Shop. Throughout this example, all figures are presented in pounds. For simplicity, VAT is excluded to keep the calculations clear. However, in real accounting records, each transaction would also need the appropriate tax code.
Step 1: record each channel’s activity gross
| Channel | Gross sales | Shipping income | Refunds | Fees and ads | Net owed by channel | Paid out in month | Clearing balance at month end |
|---|---|---|---|---|---|---|---|
| Shopify | 12,000 | 600 | (400) | (380) | 11,820 | 11,200 | 620 |
| Amazon UK | 18,500 | 0 | (900) | (7,075) | 10,525 | 9,400 | 1,125 |
| Etsy | 4,200 | 350 | 0 | (850) | 3,700 | 3,500 | 200 |
| TikTok Shop | 3,000 | 0 | (150) | (660) | 2,190 | 1,600 | 590 |
| Total | 37,700 | 950 | (1,450) | (8,965) | 28,235 | 25,700 | 2,535 |
The Amazon fees and ads line is made up of £2,775 referral fees, £3,100 FBA fulfilment and storage fees, and £1,200 advertising charged to the seller balance.
Step 2: the Amazon summary entry
A connector app or the bookkeeper posts the Amazon settlement activity like this, with every line tagged “Amazon UK”:
| Account | Debit (£) | Credit (£) |
|---|---|---|
| Amazon Clearing UK | 10,525 | |
| Refunds and Returns | 900 | |
| Marketplace and Selling Fees | 2,775 | |
| Fulfilment and Storage | 3,100 | |
| Advertising | 1,200 | |
| Sales | 18,500 | |
| Total | 18,500 | 18,500 |
When the £9,400 settlement reaches the bank, it is recorded as a transfer: debit Bank £9,400, credit Amazon Clearing UK £9,400. The £1,125 left in the clearing account is the part of the next settlement already earned in this month.
Step 3: add cost of goods sold by channel
Harbour & Co’s inventory records show the product cost of units sold through each channel: Shopify £4,800, Amazon UK £7,400, Etsy £1,300 and TikTok Shop £1,200. Each is posted to Cost of Goods Sold with its channel tag.
Step 4: read profit by channel
| Channel | Net revenue (£) | Fees and ads (£) | Cost of goods sold (£) | Channel contribution (£) | Contribution margin |
|---|---|---|---|---|---|
| Shopify | 12,200 | 380 | 4,800 | 7,020 | 57.5% |
| Etsy | 4,550 | 850 | 1,300 | 2,400 | 52.7% |
| TikTok Shop | 2,850 | 660 | 1,200 | 990 | 34.7% |
| Amazon UK | 17,600 | 7,075 | 7,400 | 3,125 | 17.8% |
| Total | 37,200 | 8,965 | 14,700 | 13,535 | 36.4% |
Net revenue is gross sales plus shipping income, less refunds. Contribution is before overheads such as staff, software and rent.
What this tells the business
Amazon UK is the biggest channel by sales. However, it has the weakest profit margin because fulfilment costs, referral fees and advertising take about 40% of its net revenue. In contrast, Shopify generates fewer sales but is more than three times as profitable per pound sold. Without proper channel tagging, the business would only see a 36.4% blended margin. As a result, it could continue spending money on advertising for its least profitable channel.
What bank-only bookkeeping would have shown
If Harbour & Co had simply recorded each deposit as sales, the business would report £25,700 in monthly income. However, actual gross sales and shipping income totalled £38,650. As a result, the business would understate its turnover by £12,950. In addition, the accounts would exclude £8,965 in fees and advertising costs. Furthermore, the financial records would not show the £2,535 that sales channels still owe the business. Our post on gross vs net accounting explains why these differences matter for tax thresholds, lenders and business valuations.
What month-end routine keeps multi-channel books accurate?
A reliable month-end routine helps you match every payout and reconcile each clearing account with the channel’s report. In addition, you should record the cost of goods sold by channel and investigate any unexplained balances. As a result, most sellers can complete their monthly bookkeeping checks in just a few hours once they establish the right structure, rather than spending weeks cleaning up records at year end.
Month-end checklist
- ☐ Every payout or settlement for every channel has been posted, with no gaps in dates.
- ☐ Every bank deposit from a channel is matched as a transfer from its clearing account.
- ☐ Each clearing account balance agrees to the channel’s own report of amounts owed at month end (unpaid settlement, pending payout or balance).
- ☐ Reserves and holds are recorded separately and agree to the channel’s figures.
- ☐ Refunds and chargebacks are recorded against the right channel.
- ☐ Advertising charged to channel balances (for example Amazon Sponsored Products or Etsy Ads) is in the advertising account, not in fees.
- ☐ Foreign currency clearing accounts are revalued or reviewed for exchange differences.
- ☐ Cost of goods sold is posted by channel from inventory records.
- ☐ The profit-by-channel report has been reviewed and any unusual margin movement explained.
Common mistakes to avoid
- Recording payouts as sales. The single most damaging mistake. It understates turnover and hides costs, and it can distort VAT or sales tax registration decisions.
- Two routes for one channel. An order-level integration and a summary connector both running for the same store double-counts sales.
- One clearing account for everything. A single “Marketplace Clearing” account cannot be reconciled, because no channel reports a combined balance.
- Ignoring small channels. Etsy or TikTok Shop may feel too small to bother with. Unrecorded channels become year-end problems, and some marketplaces report seller income to tax authorities.
- No channel tracking on costs. Tagging sales but not fees, advertising and cost of goods sold gives you revenue by channel, not profit by channel.
- Letting clearing balances drift. A clearing balance that grows month after month usually means missing payouts, missing fees or a duplicate posting. Investigate it while the data is fresh.
- Wrong tax treatment by channel. Marketplace facilitator rules vary by country and channel. Applying one tax treatment to every channel often leads to over- or under-paid tax.
When to get help
You should seek specialist help if you cannot explain your clearing account balances or have months of unreconciled payouts. Similarly, you may need support if you have not included a sales channel in your books or are approaching a tax deadline without confidence in your figures. Furthermore, an experienced specialist who understands each marketplace’s reports can complete catch-up bookkeeping much faster.
Frequently asked questions
Can I use one accounting system for Shopify, Amazon, eBay, Etsy and TikTok Shop?
Yes. Xero and QuickBooks Online can both handle all of these channels in one organisation. Give each channel its own clearing account, use shared income and cost accounts, and tag every line with the channel using tracking categories or classes.
In Xero, you can use Xero tracking categories to organise transactions by sales channel and review the financial performance of each marketplace.
Do I need a separate bank account for each sales channel?
No. Payouts from several channels can land in the same business bank account. What each channel needs is its own clearing account in your books, so each payout can be matched as a transfer and each balance reconciled.
How do I see profit by sales channel?
Tag sales, refunds, fees, advertising and cost of goods sold with the channel, then run a profit and loss report filtered or split by that tracking category or class. Tagging only sales gives revenue by channel, not profit.
Should I record each order or a summary per payout?
For most sellers, a summary per payout or settlement is better. It matches how cash reaches your bank, keeps the ledger readable and is far quicker to reconcile. Order-level detail stays in the channel and connector reports.
What is the best connector for multi-channel sellers?
It depends on your channels, volume and accounting software. A2X and Link My Books are popular for summary accounting across Shopify, Amazon and other marketplaces. Check that the tool supports every channel you sell on before committing.
How often should I reconcile marketplace accounts?
At least monthly, and weekly for high-volume channels. Reconciling each clearing account to the channel’s own report at month end catches missing payouts, fees and duplicates while the data is still easy to trace.
The bottom line
Selling on several channels does not have to mean managing several sets of messy books. Instead, you can use one chart of accounts with a separate clearing account for each channel and currency. In addition, using one data route per channel helps keep your records organised. As a result, consistent channel tagging gives you a single, trustworthy view of your business finances. Add a short monthly routine, and you will know not only what you sold, but which channel actually earned you money.
If you need specialist ecommerce accounting support, our team can help you review messy records, reconcile marketplace payouts and organise your bookkeeping.
