E-commerce bookkeeping that reconciles every channel — Shopify, Amazon, and beyond
E-commerce accounting breaks when merchant fees, returns, and sales-tax nexus aren’t booked right. Mispar reconciles every sales channel and payment processor, values your inventory correctly, and tracks COGS, shipping, and ad spend so margin per channel is real — not a guess.
Best for: DTC brands, Amazon/FBA sellers, and multi-channel e-commerce businesses with inventory and paid acquisition.
Watch: the economics behind the ecommerce industry
Orders come in and the sales number goes up, but that number is not what you earned. See payment and marketplace fees, landed product cost, shipping, returns, ad spend and inventory cash flow, and what is actually left for you.
Watch on YouTubeSubscribe on YouTubePer channel
Contribution margin
Booked at ship
COGS
% of revenue
Ad spend
FIFO / Wtd. avg
Inventory valuation
Where ecommerce books usually go wrong
- Payouts booked as revenue: Shopify, Amazon, Etsy and Walmart pay net of fees, so the books understate sales and hide 10-20% of costs.
- Marketplace tax assumed to cover everything: facilitator laws cover marketplace sales only. Your own Shopify store sales are still your responsibility in every state where you have nexus.
- FBA inventory ignored for nexus: stock sitting in an Amazon warehouse can create a physical presence in that state before any sales threshold is reached.
- Revenue double-counted: the same order appearing in the Shopify deposit, the PayPal deposit and the Amazon settlement, booked two or three times.
- COGS booked at purchase: a container paid in March becomes March's expense, so every restock month looks like a loss.
- Returns and chargebacks netted silently: gross sales look fine while a return rate problem grows underneath.
How we book e-commerce
Industry-specific accounts and categorization, with the reporting scope agreed before work starts.
Multi-channel sales reconciliation
Shopify, Amazon, Walmart, and Etsy reconciled to deposits, with marketplace facilitator tax and merchant fees netted correctly.
COGS & inventory valuation
Perpetual inventory using FIFO or weighted-average; COGS booked when product ships, not when you buy it.
Returns, refunds & chargebacks
Netted against sales and tracked separately so net revenue reflects reality and dispute losses are visible.
Merchant & platform fees
Shopify Payments, Stripe, PayPal, Amazon FBA fees, and ad platform spend categorized to the right cost lines.
Sales tax & nexus tracking
Collected tax tracked as a liability until remitted; marketplace-facilitator sales separated from direct sales for nexus compliance.
Shipping & fulfillment
Carrier costs, fulfillment fees, and dimensional charges separated so landed cost and shipping margin are clear.
1099-K tie-out
Gross payment volume from every processor tracked monthly so the year-end 1099-K forms reconcile to the books without a scramble.
Ecommerce deadlines your books need to be ready for
- State sales tax returns - every state where you are registered, on its own monthly, quarterly or annual calendar.
- Economic nexus monitoring - most states set the threshold at $100,000 in sales; New York is $500,000 plus 100 transactions. Crossing one starts a registration obligation, and the books should see it coming.
- 1099-K reconciliation - after year-end, the gross on your 1099-K forms has to tie back to recorded sales, or the mismatch invites questions.
- Quarterly estimated taxes - April 15, June 15, September 15, January 15.
- Inventory count and valuation at year-end - your CPA's COGS number is only as good as the count behind it.
Reports that show what each channel earns
- Profit and loss per channel: Amazon, Shopify, Etsy, Walmart and wholesale shown separately, with platform fees per channel.
- Contribution margin after COGS, fulfillment, fees and ad spend.
- True COGS percentage with inventory valued by FIFO or weighted average.
- Nexus exposure summary: sales by state against each state's threshold, so registrations happen before the state writes to you.
- Year-end package for your CPA with 1099-K reconciliation and inventory valuation.
A simple, predictable process
From kickoff to your first clean close, here is exactly what happens.
Connect every channel
Shopify, Amazon, payment processors, ad platforms, and inventory tools (A2X, Linnworks) wired in.
Map SKUs & COGS
We map your SKUs to a COGS structure and set the inventory valuation method (FIFO or weighted-average).
Monthly reconcile
Each channel and processor reconciled to the penny; returns, fees, and tax netted correctly.
Margin reporting
Per-channel contribution margin, COGS %, and ad spend as % of revenue delivered each month.
Illustrative example
A skincare brand sells $40,000 in a month across Amazon and its own Shopify store. The bank shows $31,900 in deposits. Booked on deposits, the month shows thin margins. Reconciled properly, the gap is $5,200 of Amazon referral and FBA fees, $1,400 of Shopify Payments and app fees and $1,500 of refunds. The books now show which channel carries the profit and that the return rate doubled since spring. This is an illustration of the method, not a customer case or a guarantee.
E-commerce bookkeeping — your questions
How do you handle sales tax across states?
We track tax collected per state as a liability until remitted, and separate marketplace-facilitator tax (Amazon, Walmart) from your direct sales so nexus reporting is clean. We partner with your tax compliance tool (Avalara, TaxJar) or CPA.
Do you value inventory at FIFO or weighted-average?
Either. We help you pick the method that fits your products and keep it applied consistently, with period-end adjustments for shrinkage and obsolescence.
Can you reconcile Amazon FBA settlements?
Yes. We break down Amazon settlements into sales, fees, refunds, inventory reimbursements, and reserves so your true Amazon margin is clear.
How do you treat advertising spend?
Platform ad spend (Meta, Google, TikTok) is categorized as an operating expense and reported as a percentage of revenue and per-channel contribution margin so ROAS connects to the P&L.
Does Amazon collect sales tax for me on everything?
Only on sales made through the Amazon marketplace, under marketplace facilitator laws. Sales through your own website are your responsibility in every state where you have nexus. We separate the two so you can see exactly where your own obligation sits.
What is economic nexus and when does it start?
Economic nexus is a sales-tax obligation created by your sales volume into a state, no physical presence needed. Most states use a $100,000 annual sales threshold; New York requires $500,000 plus 100 transactions. Inventory in an FBA warehouse can also create physical nexus on its own. We track sales by state monthly so registration happens on time.
Can you work with A2X or Link My Books?
Yes. Tools like A2X, Link My Books and Webgility post settlement-level detail into QuickBooks or Xero. We set up or maintain the mapping and reconcile the results, so the automation stays accurate as channels and fees change.
Why does my 1099-K not match my sales?
The 1099-K reports gross payment volume, including refunds and sometimes shipping and tax collected, and it follows the processor's calendar. We reconcile each processor monthly so the year-end forms tie out and differences are documented instead of surprising.
Related reading
E-commerce
Ecommerce Bookkeeping for Amazon and Shopify Sellers: What to Track and Why Payouts Never Match
Ecommerce bookkeeping for Amazon and Shopify sellers: why payouts do not match sales, how to track fees, inventory and COGS, and sales tax basics.
Read the guideSmall Business Tips
How to Improve Cash Flow in Your Small Business
Profitable businesses fail from cash flow problems all the time. Here’s how to read your numbers and make practical moves that keep real cash in the business.
Read the guideExplore other industries
Amazon FBA Sellers
Settlement reports, FBA and storage fees, refunds, ad spend and inventory costs reconciled so payout totals become real profit numbers.
Learn more →Retail
POS reconciliation, COGS, shrinkage, vendor payables, and sales-tax remittance — clean end to end.
Learn more →Wholesale Distributors
Inventory buys, net-terms receivables and freight costs kept straight, so margin per line is known instead of estimated.
Learn more →Customers slow to pay?
Our in-house collections team calls and emails customers who owe your company money, so you can stay focused on the work.