Staging preview — not indexed. Highlighted items are unverified claims awaiting firm confirmation.
Draft — pending CPA review (draft). This page is excluded from the production build until a named, credentialed reviewer approves it.

Ecommerce Bookkeeping

Multichannel Ecommerce Bookkeeping Without Double-Counting

How to keep books for Amazon, Shopify, Walmart and other channels: clearing accounts, avoiding double-counted revenue, shared inventory, and channel P&Ls.

Multichannel ecommerce bookkeeping works when each channel’s revenue is recorded once, from that channel’s order-level data, and every payout or transfer is treated as cash moving through a clearing account rather than as income. Give each channel its own revenue, fee and clearing accounts so you can see channel profit. Keep one inventory record and cost basis for shared stock.

Adding a second or third channel rarely breaks the books because of volume. It breaks them because the same dollar gets recorded twice, once by a connector and once from the bank feed, or because shared inventory is relieved at different costs on different platforms. This guide shows the structure that prevents both, with a worked example of the double-counting trap.

The core rule: sales are not deposits

A payout (Shopify Payments, PayPal, Walmart, Amazon disbursements) is the platform sending you what’s left after fees, refunds, reserves and sometimes taxes. It is a cash movement, not revenue. Revenue is the gross value of what customers bought, which you get from order-level data.

The tool that keeps them apart is the clearing account, a balance sheet account for each payment source:

  1. The channel’s sales, fees, refunds and taxes are posted to the clearing account (usually by a connector or a summary journal entry).
  2. The payout to your bank is matched to the clearing account, never to income.
  3. When everything is recorded, the clearing account balance equals money the platform still holds, and it should be explainable at any month-end.
Term Meaning
Clearing account Balance sheet account that collects one platform’s activity until it is paid out
Connector Software such as A2X or a platform integration that posts summarized channel activity to your accounting system
Payment gateway Processor that collects customer payments (Shopify Payments, PayPal, Stripe)
Channel P&L Profit and loss by sales channel: revenue less that channel’s COGS, fees, fulfillment and advertising
Transfer Money moving between accounts you own (PayPal to bank, Shopify Balance to bank). Never income

Worked example: how one month gets double-counted

Illustrative example. The figures are invented for teaching and do not describe a real client.

A seller sells on Amazon, Shopify and Walmart. One month’s true gross sales:

Channel Gross sales
Amazon $120,000
Shopify (Shopify Payments $36,000 + PayPal $6,000) $42,000
Walmart $18,000
Total $180,000

The seller uses a connector for Amazon, Shopify’s own accounting app for Shopify, and a monthly journal entry for Walmart. A part-time bookkeeper also categorizes bank feed transactions. Here’s what the books showed:

Source of entry Recorded as revenue Should it be revenue?
Amazon connector: gross sales $120,000 Yes
Walmart monthly entry: gross sales $18,000 Yes
Shopify app: gross sales (all gateways) $42,000 Yes
Bank feed: Shopify Payments payouts, categorized as “Sales” $34,800 No. These are the same orders, net of $1,200 fees
Bank feed: PayPal transfers to bank, categorized as “Sales” $5,790 No. Same Shopify orders, net of $210 fees; a transfer between your own accounts
Total revenue in the books $220,590 Correct: $180,000

Revenue is overstated by $40,590 (22.6%). Profit is overstated by the same amount because nothing offsets it. At year-end the seller may pay tax on income that doesn’t exist, or a CPA finds it and the cleanup costs more than the bookkeeping did.

The fix

Account Debit Credit
Sales: Shopify (reverse bank-feed categorization) 34,800.00
Shopify Payments clearing 34,800.00
Sales: Shopify (reverse bank-feed categorization) 5,790.00
PayPal clearing 5,790.00

Then, going forward, set a bank rule: Shopify Payments, PayPal, Amazon and Walmart deposits are always matched to their clearing accounts. Once the Shopify app has posted $36,000 of Shopify Payments sales and $1,200 of fees to the clearing account, the $34,800 payout clears it to zero. That’s the proof it worked.

Other places multichannel books double-count

  • PayPal used on several channels. If PayPal also receives eBay or wholesale payments, the PayPal clearing account needs each source mapped. Otherwise one channel’s sales get booked as another’s.
  • Marketplace-collected sales tax. Amazon and Walmart typically collect and remit tax in marketplace facilitator states. If the tax is posted to revenue, it inflates sales.
  • Refunds booked twice. Once by the connector (as a refund) and again by the bookkeeper (as an expense when the payout is smaller).
  • Multiple 1099-Ks. Shopify Payments, PayPal and Amazon may each issue a Form 1099-K. If PayPal processes Shopify orders, both forms may describe the same sales from different angles. Reconcile each form to its own clearing account; don’t add them together. See Amazon 1099-K reconciliation.

A chart of accounts that keeps channel detail

You don’t need a separate set of books per channel. You need enough accounts (or classes or tags) to answer “what did each channel earn?”

Section Accounts (one per channel where relevant)
Revenue Sales: Amazon / Shopify / Walmart; Shipping income by channel; Refunds and returns by channel (contra-revenue)
Cost of goods sold COGS (one cost basis, tagged by channel); Inventory loss and shrinkage; Inbound freight
Channel costs Marketplace referral and commission fees by channel; Fulfillment fees (FBA, MCF, WFS, 3PL) by channel; Payment processing fees; Advertising by channel
Balance sheet Clearing account per payout source; Inventory by location; Sales tax payable (for channels where you collect and remit)
Operating expenses Shared: software, salaries, rent, professional fees (not allocated in the channel P&L)

The same structure sits underneath the Amazon seller chart of accounts. Multichannel sellers repeat the channel-level lines for each platform.

Shared inventory: one record, one cost

When the same SKU sells on several channels, stock moves between Amazon FBA, a 3PL, Walmart Fulfillment Services and perhaps your own warehouse. The rules:

  • One cost basis per SKU. The landed cost doesn’t change because a unit sold on Walmart instead of Amazon. If Shopify’s app relieves inventory at $8.00 and A2X uses $8.40 for the same SKU, one of them is wrong and COGS won’t tie to inventory.
  • Inventory by location on the balance sheet. FBA, 3PL and in-transit stock in separate sub-accounts make counts and reconciliations easier, and they are needed for sales tax nexus analysis.
  • Transfers between locations aren’t COGS. Moving units from a 3PL to FBA changes location, not cost, although the freight to move them may be capitalized.
  • Reconcile the units, not just the dollars. Each month, units per Amazon’s Inventory Ledger, the 3PL report and your own system should agree with units on the books.

For the cost side in detail, see how to calculate COGS for Amazon sellers.

Building a channel P&L

Allocate the costs that a channel directly causes. Leave shared overhead unallocated so that each channel’s contribution is clear.

Illustrative example, continuing the month above, with the double count fixed:

Amazon Shopify Walmart Total
Gross sales $120,000 $42,000 $18,000 $180,000
Refunds ($4,800) ($1,260) ($540) ($6,600)
COGS (same landed cost per unit) ($36,000) ($12,600) ($5,400) ($54,000)
Marketplace / referral fees ($18,000) $0 ($2,700) ($20,700)
Fulfillment fees (FBA, MCF, WFS) ($24,000) ($4,200) ($3,600) ($31,800)
Payment processing $0 ($1,410) $0 ($1,410)
Advertising ($13,230) ($16,510) ($3,145) ($32,885)
Channel contribution $23,970 $6,020 $2,615 $32,605
Contribution as % of gross sales 20.0% 14.3% 14.5% 18.1%

Two points the channel view exposes:

  • The Shopify fulfillment line includes $4,200 of Amazon MCF fees. In the Amazon settlement these looked like Amazon costs. Re-tagged to Shopify, they show the true cost of the DTC channel, and Amazon’s contribution improves by the same amount.
  • Shopify has no marketplace fee but carries most of its own advertising. Comparing channels on gross margin alone would make Shopify look like the best channel. It isn’t.

From there, the per-unit version of this analysis is covered in contribution margin for Amazon sellers.

Sales tax across channels

Multichannel sellers face different sales tax mechanics on each channel:

  • Marketplaces (Amazon, Walmart, eBay, Etsy and similar) generally collect and remit sales tax as marketplace facilitators in states with those laws. In your books the tax should net to zero in the clearing account, not hit revenue.
  • Your own store usually doesn’t remit for you. Shopify’s help center states that Shopify doesn’t remit sales tax for merchants unless their US sales tax is managed by Shopify. If you have nexus in a state, collecting and filing on Shopify sales is your job.
  • Thresholds combine channels. In many states, marketplace sales count toward your economic nexus threshold even though the marketplace collects the tax on them, so Shopify sales can push you over sooner than you expect. See economic nexus for online sellers and marketplace facilitator sales tax.

The multichannel monthly close

  1. Post each channel’s activity from order-level data (connector or summary entry) to its clearing account.
  2. Match every payout to its clearing account. No deposit is categorized as income.
  3. Explain each clearing account balance at month-end (amounts in transit, reserves, unpaid settlements).
  4. Reconcile inventory units by location and confirm one cost basis per SKU across channels.
  5. Re-tag cross-channel costs (MCF fees, shared ad accounts) to the channel that made the sale.
  6. Review sales tax payable for channels where you collect, and compare it to the returns you filed.
  7. Produce the channel P&L and investigate any channel whose contribution moved by more than a few points.

The bookkeeping health check is a quick way to see which of these steps your current process skips.

Where to get help

Most multichannel cleanups we see begin with revenue overstated by a double-counted gateway or a transfer booked as sales. If you sell on more than one platform and your books have never been reconciled channel by channel, our multichannel ecommerce accounting service sets up the clearing accounts, connectors and channel P&L, and runs the close every month.

Questions sellers ask

Should each sales channel have its own bank account?

It isn't necessary. Clearing accounts do the separating. One operating account can receive payouts from every channel as long as each payout is matched to its channel's clearing account. Some sellers do add a separate account for a channel with heavy refunds or reserves, for cash visibility.

How do I handle a Shopify order fulfilled by Amazon MCF?

Record the sale as Shopify revenue from Shopify's order data. The MCF fulfillment fee shows up in your Amazon settlement. Book it to a fulfillment expense account tagged to the Shopify channel, not to Amazon, so your channel margins are accurate. The inventory leaves your FBA stock, so relieve it at the same landed cost as any other unit.

Do I need a connector for every channel?

Not necessarily, but you need order-level summaries for each one. For high-volume channels a connector that posts summarized sales, fees, refunds and taxes per payout saves time and reduces errors. For a small channel, a monthly journal entry from the platform's own report can be enough.

Sources

  1. Shopify Help Center: Shopify Payments payouts
  2. Shopify Help Center: US taxes
  3. IRS Instructions for Form 1099-K
  4. IRS Publication 334, Tax Guide for Small Business

Talk to an ecommerce CPA about your numbers

A free 15-minute discovery call. We’ll look at where your books stand, what’s holding your margins back, and what to fix first — no obligation.

Call nowBook a call