E-commerce
Ecommerce Bookkeeping for Amazon and Shopify Sellers: What to Track and Why Payouts Never Match

Quick answer
Ecommerce payouts never match sales because they are net of fees, shipping, ads, refunds and reserves. Record gross sales, post fees to their own accounts, track COGS when product ships, and reconcile every payout to the bank.
Why the numbers rarely add up
If you sell on Amazon or Shopify, you have probably looked at a bank deposit and wondered how it relates to your sales. It almost never matches. That gap is the core problem of ecommerce bookkeeping.
This guide explains why the numbers differ, what you need to track, and how to keep your books clean enough to know your real profit.
Why payouts do not match sales
A marketplace or payment processor does not deposit your sales. It deposits sales minus a list of things:
- Marketplace or processing fees
- Fulfillment and shipping charges
- Advertising costs charged against your balance
- Refunds and returns
- Reserves or holds
- Sales tax collected (in some cases)
Deposit timing is different too. A sale in one month can be paid out in the next. If you book the deposit as revenue, your income is wrong, your fees disappear, and your profit looks bigger than it is.
The right way: record gross sales, then the fees
Each payout should be broken back into its parts:
- 1Gross sales go to revenue.
- 2Fees, shipping and ad costs go to their own expense accounts.
- 3Refunds reduce revenue.
- 4The net deposit is what is left, and it should match your bank.
Marketplaces provide settlement or payout reports for this purpose. A bookkeeper reconciles each report to the bank deposit, so every dollar is accounted for.
Track each sales channel separately
If you sell on Amazon, Shopify and maybe Walmart or Etsy, keep revenue by channel. Fees, return rates and margins differ a lot between them. Combined numbers hide which channel is working. Our ecommerce bookkeeping service reconciles every channel into one set of books.
Inventory and cost of goods sold (COGS)
For product sellers, inventory is usually your biggest asset, and COGS is usually your biggest cost. Two things to get right:
- Buying inventory is not an expense yet. It is an asset until it sells.
- Cost hits your books when the product ships. That is COGS. It should match what you sold, not what you ordered.
Your inventory method matters. Many sellers use FIFO (first in, first out), which assumes the oldest stock sells first. Include freight-in and other landed costs in your product cost, or your margins will look better than they are. Ask your CPA which method fits your tax situation. The cost of goods sold glossary entry walks through the definition with a worked example.
Sales tax: do not guess
Sales tax rules for online sellers are complicated and vary by state. In most states, marketplaces like Amazon collect and remit sales tax on marketplace sales. Sales on your own Shopify store are different: you may be responsible for collecting and filing. Keep sales tax collected out of revenue, track it by state, and confirm your obligations with a tax professional. Our sales tax nexus glossary entry explains when a state can require you to collect at all, and the tax deadlines checklist helps you plan filing dates.
Other things that trip up sellers
- Amazon reserves and holds: money that is yours but not in your bank yet.
- Returns and chargebacks: they arrive later, sometimes in a different month.
- Ad spend: often charged separately from payouts. Track it as marketing, by channel.
- Mixed accounts: use one bank account and card for the business.
- Sample and damaged inventory: write it off properly.
- Foreign currency: if you sell abroad, conversion differences need a home in your books.
The monthly numbers worth watching
- Revenue by channel
- Gross margin after COGS
- Total fees as a percent of sales
- Ad spend against revenue
- Inventory on hand vs. what you expect
- Cash vs. profit (they are not the same thing in ecommerce)
If you only look at one report, make it the profit and loss with COGS broken out. For more on cash, read how to improve cash flow.
Software: QuickBooks Online or Xero
Most ecommerce sellers do best with QuickBooks Online or Xero, plus a connector that pulls marketplace data in as summaries. Pushing every single order into your books creates thousands of lines nobody reviews. Summaries by payout, reconciled to the bank, are easier to audit. If you are weighing options, see QuickBooks Online vs. Desktop.
When to hire a bookkeeper
- Your deposits do not tie to your sales and you stopped trying.
- You are not sure what your margin is on each product or channel.
- You sell in several states or on multiple platforms.
- You are behind on months of reconciliation. Catch-up work can rebuild them.
A payout reconciliation, walked through
The most useful habit in ecommerce bookkeeping is reconciling each payout, not each month. Here is the routine in plain steps.
- 1Download the settlement report from the marketplace or processor for the payout period. It lists sales, fees, refunds and adjustments that make up the deposit.
- 2Match the total to the bank deposit. The settlement net should equal the deposit. If it does not, find the difference before moving on. Common causes are reserves, a split payout or a timing cut-off.
- 3Record the pieces. Gross sales to revenue, each fee type to its own expense account, refunds against revenue, and the net to the bank.
- 4Check the period edges. Sales near month end may be paid next month. Make sure they land in the month they were sold.
- 5Clear the clearing account. If you use a clearing account for the marketplace, it should be at or near zero after each payout. A growing balance means something was missed.
Fees worth separating
One line called "fees" is not enough. Splitting them shows where your margin goes and which channel is worth the work:
- Referral or commission fees charged on each sale
- Payment processing fees from Shopify Payments, Stripe or PayPal
- Fulfillment, storage and shipping charges
- Advertising spend, kept separate from other marketing
- Subscription fees for apps, platforms and software
- Chargebacks and disputed payments
Returns, refunds and damaged goods
A refund is not just a lower sale. The customer may get money back while the product comes back to you, goes to a liquidator, or is thrown away. Each outcome changes your books. Returned stock that can be resold goes back into inventory. Stock that cannot be sold is a loss and should be written off in the period it happens. If you never record this, inventory on your balance sheet drifts away from what is on your shelf.
Inventory counts and the balance sheet
A cost of goods sold figure is only as good as your inventory number. Count stock at least once a year, and more often if you carry a lot of it. Compare the count to what your books say. A gap is either shrinkage, receiving errors or items that were never recorded when they came in. Inventory held at a fulfillment center still belongs to you, so it belongs on your balance sheet too.
Owner draws, personal cards and mixed money
Many small sellers started by running the business through a personal card. If that is still happening, your expenses are scattered and some will be missed at tax time. Open a business bank account and card, route every payout there, and pay yourself through a transfer that is recorded as an owner draw or distribution. Clean separation makes the books faster to do and easier to defend.
What to hand your bookkeeper each month
- Settlement reports for every channel
- Statements for bank, card and processor accounts
- Inventory purchase invoices and any supplier statements
- Notes on returns, write-offs, and anything unusual
- Sales tax filings or notices received
A note on timing and cut-offs
Marketplaces close their payout periods on their own schedule, and that schedule rarely lines up with the calendar month. A settlement that spans the 28th to the 12th puts two weeks of sales in one month and two weeks in the next. Ask your bookkeeper to record sales by the date of sale, not the date of payout, so that each month stands on its own. It is also the only way to compare this October with last October fairly.
Seasonal sellers feel this most. A strong holiday season can leave a large payout arriving in January, and a bank balance that looks healthy for a month while inventory orders and ad bills are already due. A simple view of what has been sold but not yet paid out keeps you from spending money that has not arrived.
Our bookkeeping for ecommerce page covers how Mispar handles this inside your own QuickBooks Online or Xero.
What an ecommerce bookkeeper does for Amazon and Shopify sellers
A good ecommerce bookkeeper does more than categorize deposits. For an Amazon seller, that means breaking each settlement report into sales, refunds, FBA and referral fees, storage charges and ad spend, then matching the net amount to the bank deposit. For a Shopify seller, it means reconciling Shopify Payments, PayPal and other processor payouts against orders, so fees and refunds do not hide inside a deposit.
- Reconciles every sales channel and payment processor to the bank each month.
- Books marketplace fees, shipping costs, refunds and ad spend as separate lines, so you can see each one.
- Tracks inventory and records cost of goods sold when product ships, using a method that fits your business.
- Keeps sales tax collected, and sales tax owed, visible by state.
- Produces a monthly profit and loss that your tax preparer can use without rework.
How to choose a bookkeeper for your online store
Ask whether they work inside your own QuickBooks Online or Xero file, whether they handle marketplace settlement reports and not only bank feeds, and who you talk to when something looks off. Ask how they treat inventory, since this is where many ecommerce books drift. And ask what happens if you are several months behind: a clear catch-up scope is a better sign than a promise to fix everything fast.
At Mispar every client gets a dedicated bookkeeper and works in their own QuickBooks Online or Xero file. See our ecommerce bookkeeping services and bookkeeping for Amazon FBA sellers pages for what is covered, or pricing for plans.
Ecommerce bookkeeper or do it yourself?
Many sellers start with spreadsheets and move to a bookkeeper when payouts stop matching sales, when inventory gets hard to value, or when sales tax across several states becomes more than a side task. If you spend more time fixing the books than selling, that is usually the signal. You can also hand off only the monthly reconciliation and keep day-to-day ordering and invoicing yourself.
Next steps
Know your real profit by channel, not just your deposits.
Frequently asked questions
Why does my Amazon payout not match my sales?
Payouts are net of fees, fulfillment charges, ad costs, refunds and reserves, and they are paid on a different schedule than the sales.
How do I record Shopify sales in QuickBooks?
Record gross sales to revenue, fees to expense accounts, and reconcile the net payout to your bank deposit. Summaries by payout work better than one line per order.
What is COGS for an ecommerce business?
The cost of the products you sold in the period, including freight-in and landed costs. It is recorded when the product ships, not when you buy it.
Do I have to collect sales tax on Amazon sales?
In most states Amazon collects and remits it for marketplace sales. Sales on your own store can be different, so confirm your obligations with a tax professional.
Should I track each channel separately?
Yes. Fees and margins vary by channel, and combined numbers hide that.
What accounting software works best for sellers?
QuickBooks Online and Xero are both common. Mispar works in either.
How much does ecommerce bookkeeping cost?
Mispar's flat plans are Startup $229/month, Grow $429/month, Premium $629/month and Enterprise $1,250/month. The pricing page has what each plan covers.
What does an ecommerce bookkeeper do?
An ecommerce bookkeeper reconciles your sales channels and payment processors to the bank, books fees, refunds and ad spend as separate lines, tracks inventory and cost of goods sold, keeps sales tax visible, and delivers a monthly profit and loss.
Should I hire a bookkeeper for my Amazon store?
It helps if your payouts do not match your sales, your inventory costs are a guess, or you are unsure how much of each deposit is fees and refunds. Mispar books Amazon settlement reports, FBA fees, ad spend and inventory costs each month. See our Amazon FBA seller bookkeeping page for details.
Keep reading

Small 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.

QuickBooks & Tools
QuickBooks Online vs. QuickBooks Desktop: Which Is Right for You?
Both are legitimate; they’re not the same product. Here’s an honest comparison to help you choose the QuickBooks that actually fits your business.

Bookkeeping Basics
Sales Tax and Your Books: What Small Businesses Should Track
Sales tax you collect belongs to the state, not to your business. Your books should show it as a liability and tie to every return you file.
Written by
Moshe
Senior Account Manager, Mispar
Moshe is a Senior Account Manager at Mispar who works directly with small business owners and freelancers to keep their books clean, reconciled, and tax-ready every month.
More about Mispar