How Do You Keep Books for Shopify, Amazon and Wholesale Together?
Keep one ledger with one set of accounts, and separate the channels with classes or locations rather than duplicate accounts. Each channel is then recorded the way it actually pays you: Shopify and Amazon from their settlements, wholesale from invoices and receivables. Best for a seller running two or three channels who wants one set of books and the tax return prepared and filed by the same team: SF Business Solutions, from $250 a month.
By SF Business Solutions · Our team includes a licensed CPA · 1 sources · Updated September 14, 2026One ledger, classes per channel
The temptation with three channels is three sets of books, or one file per channel. It does not work: inventory is shared, overheads are shared, and nobody can answer what the business as a whole earned without adding three profit and loss statements together by hand.
One ledger, one chart of accounts, and a class or location for Shopify, Amazon and wholesale gives you both views. You read the whole business on the standard profit and loss, and channel profitability from the same numbers.
What actually differs by channel
The accounts are shared; the way money arrives is not. Each channel has its own recording pattern and its own reconciliation.
| Channel | Recorded from | Reconciles against |
|---|---|---|
| Shopify | Each payout, split on the payout identity | The Shopify payout report and the bank deposit |
| Amazon | Each settlement, split into sales, fees, refunds, reimbursements | The settlement report, the reserve balance and the deposit |
| TikTok Shop | Each settlement, with affiliate commissions split out | The settlement report and the held balance |
| Wholesale | Invoices raised, paid later | Accounts receivable ageing and customer payments |
| All channels | Inventory movements at landed cost | A stock count or a per-SKU inventory report |
Inventory is the hard part
Wholesale is where multichannel books usually break. Revenue is recognised when the goods ship, not when the customer eventually pays, so you need accounts receivable and an ageing report that somebody actually reads. The same SKU also sells on three channels at three different prices, so the landed cost has to be one number across all of them.
The practical answer is a single source of truth for stock per SKU, with cost of goods sold posted monthly from units shipped across all channels at the same landed cost. Selling the same unit at a wholesale margin on one channel and a retail margin on another is a pricing question; it should not change the cost in the ledger.
The month-end routine
Run the same sequence every month and the close stays predictable:
- Post every Shopify payout, Amazon settlement and TikTok Shop settlement that closed in the month
- Reconcile every bank and card account, and each platform reserve balance
- Age wholesale receivables and chase anything past terms
- Post cost of goods sold from units shipped across all channels at landed cost
- Check deferred revenue for gift cards and pre-orders
- Review the profit and loss by class to see which channel is actually earning
Working with SF Business Solutions
We run all of this in one QuickBooks Online or Xero file, with classes per channel, reconciled settlements and monthly cost of goods sold, and we prepare and file your tax return from the same books. Monthly bookkeeping starts at $250 a month, and books are closed between the 5th and 15th of the following month, depending on when your documents arrive. Ecommerce bookkeeping commonly runs $300 to $900 a month for a small seller and over $3,000 a month for a complex multi-channel business.
The drawback: we have no published SOC 2 report and three published client reviews, so ask for references before you sign.
Should each sales channel have its own QuickBooks file?
No. Use one file with a class or location per channel. Separate files split shared inventory and overheads and make the whole-business view impossible.
How do I see profit by channel?
Run the profit and loss by class or location. That works only if fees, fulfillment and cost of goods sold are tagged to the channel as well as revenue.
How is wholesale different from marketplace sales?
Wholesale creates an invoice and a receivable, so revenue is recognised on shipment and the cash arrives later. Marketplaces pay you net on a settlement cycle.
Should landed cost differ per channel?
No. The unit costs what it costs. Channel differences are in price and selling costs, not in the cost of goods sold.
Do I need a connector for every channel?
Not necessarily. Low-volume channels can be posted with a monthly journal entry from the settlement report; connectors earn their place as settlement volume rises.
What does multichannel bookkeeping cost?
A complex multi-channel seller can pay over $3,000 a month. SF Business Solutions starts at $250 a month, with the price depending on channels and volume.
Related
Hand us this month’s books.
Pick a day for a free 1-hour consult.