Selling on four marketplaces does not mean four sets of books. It means one set of books with four sources of transaction data, each arriving on its own schedule, in its own format, with its own definition of what a fee is. Most of the questions below come from sellers who discovered that distinction the hard way, usually in the second week of a month-end close.
Do I need separate accounting for each marketplace?
No. You need one general ledger with channel-level segmentation inside it. Separate ledgers per marketplace make consolidated financial statements impossible and give you no way to see total gross margin, which is the number that determines whether the business works.
Use classes, locations or tracking categories in QuickBooks or Xero to tag each channel, then report by tag. You get per-channel visibility and a single consolidated set of statements from the same data.
Why does my revenue never match my marketplace dashboard?
Because the dashboard reports gross sales and your accounting file should report something closer to net, and because the two systems recognize revenue on different dates. A dashboard showing $180,000 for the month and a bank deposit of $142,000 are both correct.
The gap is referral fees, fulfillment fees, refunds, promotional discounts you funded, withheld sales tax, and reserve balances the marketplace is holding. It is also timing: a settlement period that runs from the 28th to the 11th puts part of your March sales in a February settlement.
Should I book gross sales or net deposits?
Gross, with fees recorded separately as expenses. Booking only the net deposit understates both revenue and expenses, hides your true fee load, and makes gross margin analysis impossible.
The exception is withheld sales tax under marketplace facilitator rules. Money the marketplace collected and remits itself never becomes your revenue, so it should net to zero rather than appearing as sales.
What is a marketplace facilitator and why does it matter to my books?
A marketplace facilitator is a business that controls a marketplace, facilitates sales for third-party sellers, and collects payment from the purchaser. Under laws now in force across most states, the facilitator collects and remits sales tax on the sales it facilitates. The Illinois Department of Revenue’s Informational Bulletin FY 2026-12 is a representative example, applying the same threshold test to remote retailers and marketplace facilitators alike.
For your books this means marketplace-facilitated sales tax is a pass-through, not a liability you owe. It also means your own direct channel, if you have one, is on a different footing entirely. Talk to a sales tax professional or your state’s department of revenue about your specific obligations, because the rules differ by state and by channel.
How do I handle a settlement that crosses a month end?
Split it by settlement start and end dates, not by the date the deposit arrived. Post the portion belonging to the closing month as an accrual, and the remainder in the following period.
Booking the full settlement in the month the cash landed is the most common shortcut in ecommerce bookkeeping and it moves revenue between periods every single month. It also compounds: your opening balance is wrong, so every subsequent month inherits the error.
Do I have to use accrual accounting?
If you carry inventory, generally yes for purchases and sales. IRS Publication 538 on accounting periods and methods states that a taxpayer who keeps inventories generally uses an accrual method for purchases and sales, and describes the small business taxpayer exceptions and the gross receipts test that governs them.
Read the publication and then ask your CPA how it applies to your entity. This is a tax question with facts specific to your business, not a software setting.
How should COGS work across four channels?
Cost of goods should attach to the unit, not to the channel. The same SKU costs the same to buy regardless of whether it sold on Amazon or Walmart, so COGS should post at the SKU level and channel differences should show up in fees and fulfillment, not in cost of goods.
Where channels genuinely differ is landed cost by fulfillment path. A unit fulfilled by FBA carries inbound freight to an Amazon warehouse; the same unit shipped from your own warehouse does not. Track that as a fulfillment cost rather than folding it into COGS, or you will have two different cost bases for one product.
Which inventory valuation method should I use?
Most ecommerce sellers use FIFO, and most ecommerce accounting tools assume it. IRS Publication 538 describes FIFO, LIFO, specific identification and lower of cost or market as available methods, with conditions attached to each.
The practical argument for FIFO in ecommerce is that unit costs move constantly with freight and duty, and FIFO produces a balance sheet inventory value closer to replacement cost. The decision has tax consequences, so make it with your accountant and then do not change it casually.
How do I reconcile inventory when units sit in three places?
Count what you own, not what is in a warehouse. Units in an FBA fulfillment center, units in your own warehouse and units on the water are all your inventory and all belong on your balance sheet.
Reconcile monthly against three sources: the marketplace’s inventory report, your warehouse count, and open purchase orders with shipping documents. Products that track valuation across multiple warehouses and FBA together, such as ConnectBooks, exist because doing this by spreadsheet across channels is where most sellers give up.
What do I do about returns and refunds?
Record three things, not one. The revenue reversal, the fee treatment, and the inventory movement.
The refund reduces revenue. Some marketplace fees are returned to you on a refund and some are not, so read your settlement detail rather than assuming. And the unit either comes back to sellable stock, comes back unsellable, or never comes back at all, and each of those is a different entry.
How long should I keep marketplace source data?
Download and store your own settlement reports monthly, in the raw format, in storage you control. Marketplaces limit historical access, and accounting tools vary in how far back they will pull.
Raw settlement files are the only records from which your books can be rebuilt if a vendor relationship ends. Storing them costs almost nothing and is the cheapest insurance in ecommerce bookkeeping.
When is manual multi-channel bookkeeping no longer viable?
There is no clean threshold, but two signals show up consistently. The first is when the close takes longer than a week, because at that point the numbers are stale before anyone acts on them. The second is when you cannot answer what a specific SKU earned last month without building a spreadsheet.
Either signal means the data volume has outgrown the process. That is a workflow problem before it is a software problem, and buying a tool without fixing the chart of accounts underneath it just automates the mess faster.
What should I fix first?
The chart of accounts. Separate accounts for each fee category, each channel tagged consistently, COGS separated from fulfillment, and sales tax mapped as a pass-through where the marketplace collects it.
Everything else in multi-marketplace accounting is downstream of that structure. Get it right on a quiet week and every subsequent month is easier.