How to Reconcile Shopify and Amazon in Your Books
To reconcile Shopify and Amazon, stop matching bank deposits and start matching transactions. Each channel pays you a net amount after fees, refunds and adjustments. Your books need the gross sales, each fee and each credit behind that deposit, recorded per channel and tied back to the payout. This guide gives you a month-end process you can run in QuickBooks or Xero. It also covers the Amazon-specific leaks, such as lost FBA inventory, that a deposit match will never show you.
The same method works if your second channel is eBay instead of Shopify, or if you sell on all three.
TL;DR
- Deposits are net cash. Reconcile at the transaction level (sales, refunds, fees, adjustments) and then prove the total equals the payout.
- Keep one clearing account per channel, so Shopify and Amazon never blend into a single lump of revenue.
- Amazon hides fees, reserves and FBA adjustments in its transaction detail. A settlement summary alone will not show them.
- Do not reconcile to your 1099-K. It reports gross payments and is not your revenue or profit.
- Check FBA ledger events for lost and damaged units each month. Amazon often owes you money you have not claimed.
Table of Contents
- Why the two channels never match your bank
- Get the basics right before you reconcile
- The monthly process, step by step
- What typically breaks the match
- Why 1099-K figures are the wrong target
- The leak reconciliation exposes: FBA reimbursements
- Perspective: what we see in sellers’ books
- Connect reconciliation to profit reporting
- Doing this in QuickBooks or Xero
- Where BeanHawk fits
- FAQ
- Sources
Why the two channels never match your bank
Shopify and Amazon both sit between your customer and your bank account. Neither passes the sale straight through.
On Shopify, a payout is the sum of captured orders minus processing fees, refunds and any chargebacks. Shopify Payments fees vary by card type and store location, and stores that use a third-party gateway also pay a transaction fee on the gross value. Fees are charged when the payment is captured, so a payout that lands this week can contain fees from last week’s orders.
On Amazon, the payout is a settlement: a bundle of orders, refunds, referral fees, FBA fees, storage fees, advertising charges, reserves and adjustments over a settlement period. The summary shows net numbers. The detail that explains them lives in Seller Central’s transaction views.
So a single month can produce a Shopify deposit, two or more Amazon deposits, a few refunds issued after the cutoff and an ad bill that Amazon deducts from your balance. None of those add up to “sales” on their own. That is the whole problem.
Get the basics right before you reconcile
Three setup decisions make every later step easier.
One clearing account per channel
Create an “Amazon clearing” and a “Shopify clearing” account (an asset or current-liability account, depending on how your accountant sets it up). Post the gross sales, fees and refunds of each channel into its own clearing account. When the payout hits your bank, it moves from clearing to cash. If the clearing account does not return to roughly zero after each payout period, something is missing, and you know which channel it is in.
Accrual-style entries, not cash-style
Book gross sales, refunds and fees as they happen on the marketplace ledger. Do not book only the net deposit. Amazon’s own transaction documentation describes the transactions page as a view of charges and credits since the last settlement, which is exactly the level of detail your entries need. Booking only deposits understates revenue and buries fees in a single line you cannot analyze.
Separate expense categories for fees
Split marketplace fees into at least these lines: referral or commission fees, FBA fulfillment fees, storage fees, advertising, payment processing (Shopify Payments or gateway fees) and refunds. If you want the Amazon side in detail, our guide to Amazon fees accounting walks through the categories.
The monthly process, step by step
1. Pull the Shopify side
Export the Shopify payout report and the transactions behind it for the month. For each payout, you want gross sales, discounts, shipping collected, taxes collected, refunds, fees and net. Check one identity per payout: gross sales minus fees minus refunds equals the deposit. When it does not tie, look first at timing (orders captured in one period, paid out in the next) and then at disputes.
Watch two Shopify-specific items:
- Sales tax collected. It is a liability, not revenue. Keep it out of sales.
- Currency conversion. Capturing payment in a non-domestic currency through Shopify Payments carries a 1.5% conversion fee in the United States. If you sell internationally, that fee needs its own line.
2. Pull the Amazon side
Download the settlement reports covering the same dates, then use the transaction detail to look behind the summary. Amazon’s guidance points to the Transaction Details page and its Associated Transactions to find refunds, adjustments and storage fees that a summarized settlement does not make obvious.
For each settlement, confirm the same identity: product sales and credits, minus fees, refunds and adjustments, equals the deposit. Amazon settlements often straddle month-end. Decide on a policy and stick with it: either split the settlement by transaction date at the month boundary, or post each settlement entirely in the month it closes. Splitting is more accurate for monthly financials. Our walkthrough on reconciling Amazon settlements covers the split in detail.
3. Match payouts to the bank
Only now do you open the bank feed. Each Shopify payout and each Amazon settlement should match one deposit, and each should clear its channel’s clearing account. Anything left over in a clearing account is your to-do list.
4. Reconcile inventory and COGS across both channels
If you hold stock in Amazon’s warehouses and also ship Shopify orders from your own space (or from Amazon via Multi-Channel Fulfillment), your inventory exists in several places. Record cost of goods sold when units sell, per channel, using the same cost basis. Track landed cost (freight, duties, prep) in the unit cost, not as a monthly expense, or your margins will swing for no real reason. The FBA inventory reconciliation guide shows how to compare your records with Amazon’s inventory reports.
5. Investigate and close
List every variance over a threshold you choose (for example $25) and label it: timing, fee, refund, reserve, lost inventory or unknown. Close the month only when the unknown list is empty or explained.
What typically breaks the match
| Symptom | Likely cause | Where to look |
|---|---|---|
| Deposit lower than expected | Refunds, ad charges or reserves deducted from the balance | Amazon transaction detail, Shopify payout details |
| Deposit higher than expected | Prior-period orders paid out this period, or reimbursements | Transaction dates, reimbursement entries |
| Shopify order appears twice | Duplicate order creation from a fulfillment setup | Fulfillment service locations, connector settings |
| Inventory count differs from Amazon | Lost, damaged or found units, removals, adjustments | FBA ledger events |
| Revenue differs from 1099-K | Gross reporting before fees and refunds | Your sales ledger, 1099-K workpaper |
Duplicate orders from connected channels
If you use Shopify’s Marketplace Connect app (formerly Codisto), you can manage inventory, orders and listings centrally, and the app supports Amazon, Target Plus, Walmart and eBay. That makes it a common way to reconcile eBay and Amazon activity alongside Shopify. The catch is fulfillment. Shopify’s help center says orders can be fulfilled in the admin or by a third-party app, and that Amazon fulfillment options differ depending on how you set up the connection. If inventory is still set to standard FBA when it should be MCF or Marketplace Connect, Shopify may try to fulfill orders Amazon already handles. Shopify’s guidance on Multi-Channel Fulfillment by Amazon explains the setup. Fix it at the source, because duplicate orders inflate revenue and COGS in your books.
A connector keeps listings, stock levels and orders aligned. It does not give you ledger-level FBA reimbursements or a clean accounting posting. Treat it as an operations tool and keep a separate reconciliation process.
Reserves, holds and negative balances
Amazon can hold part of a balance in reserve or carry a negative balance into the next period. Record a reserve as a receivable from Amazon rather than as an expense. Otherwise your clearing account will look permanently off.
Why 1099-K figures are the wrong target
Many sellers try to force their books to equal the 1099-K and give up when they cannot. They do not match, and they are not meant to.
The IRS describes Form 1099-K as a report of payments received for goods or services through payment cards and third-party settlement organizations. It is an information return. The amount is gross, before fees, refunds and shipping costs, so it is not your net revenue or your profit. For the current federal threshold, the IRS page says third-party settlement organizations file when gross payments exceed $20,000 and transactions exceed 200. The same page notes that income is reportable whether or not you receive a form.
The right use of the 1099-K is as a control total. Add up gross payments from each platform in your own ledger and explain the difference to the form: timing, refunds, fees netted by the platform, sales tax and, if any, personal transactions. If you see two forms, one from Amazon and one from Shopify’s payment processor, each is reconciled to its own channel. Our one-page 1099-K workpaper lays out that comparison. For your actual filing, ask a CPA or enrolled agent who handles e-commerce clients.
The leak reconciliation exposes: FBA reimbursements
Reconciling Shopify to Amazon often reveals something else: your inventory count does not match because Amazon lost or damaged units and never reimbursed you. A settlement summary will not flag that. The evidence is in FBA ledger events and inbound shipment receipts.
So put a reimbursement check in the monthly close:
- Compare units you sent in each inbound shipment with units Amazon received.
- Review ledger events for lost, damaged and disposed units.
- Check whether each loss was reimbursed, and whether the amount reflects the value of the item.
- File claims for the gaps within Amazon’s claim windows.
The FBA inventory adjustments explainer and the glossary entry on FBA reimbursement cover the event types and how to read them. Recovered funds also need correct accounting treatment: a reimbursement is not a sale, and it should offset the inventory loss rather than inflate revenue.
Perspective: what we see in sellers’ books
We see the same pattern repeatedly. A seller adds Amazon to a Shopify store, or Shopify to an Amazon business, and the bookkeeping quietly degrades. Revenue is recorded from payouts, fees sit in one catch-all account and inventory is a guess. The books “balance” because the bank feed is matched, yet the numbers cannot answer the questions that matter: which channel is profitable, what a unit truly costs and what Amazon owes.
Our view is that reconciliation should work in the opposite direction. Start from the ledger, post summarized settlements for every channel to your accounting system, and let the bank match confirm the result. Cash matching is the last check, not the first. We also believe the money Amazon owes you should be recovered without a commission on it, because the tooling to find it is a monitoring problem, not a negotiation. That is why BeanHawk is priced flat by order volume.
, Tim
Connect reconciliation to profit reporting
Once both channels reconcile, put the numbers to work. Margin by channel and by SKU should include marketplace fees, FBA fees, ad spend, payment processing and landed cost. Many stores connect Shopify to other platforms and dashboards for this, and the build quality of that plumbing decides whether the reports hold up. For an example of how a dual-platform store is put together, see this Shopify and WooCommerce case study. The principle carries over to Amazon: one source of truth per number, and a documented path from the sale to the report.
Doing this in QuickBooks or Xero
The manual process works at low volume. At a few hundred orders a month across two channels, it starts to cost hours at every close. Typical pain points:
- Hundreds of Amazon transaction lines that must be summarized into journal entries.
- Settlements that cross month-end.
- Shopify and Amazon each needing the right fee and refund categories every time.
- COGS that need recalculating when unit costs change.
Automation helps most with the repetitive posting and with the monitoring no one has time for. If you want a process overview, our guides to automating Amazon settlement accounting and Amazon FBA bookkeeping go deeper. Bookkeepers who manage several seller clients can look at our accountant and bookkeeper program.
Where BeanHawk fits
BeanHawk watches inbound shipments and FBA ledger events, flags lost, damaged and under-reimbursed inventory, and posts summarized settlements to QuickBooks and Xero for each channel. It also tracks purchase orders, landed cost and COGS, and sends reorder alerts. There is no commission on recovered funds.
Plans are tiered by order volume: Free at $0 per month, Starter at $19 per month, Growth at $49 per month and Scale at $99 per month. You can see what each includes on the pricing page. If you want to know what Amazon owes you before you commit, run the free FBA reimbursement audit.
FAQ
Can I reconcile Shopify and Amazon in one account?
You can, but you will lose visibility. Use a separate clearing account for each channel so every payout ties to its own sales, fees and refunds. You can still roll the channels up into a single revenue total on your reports.
Should I reconcile Amazon by settlement or by order?
Start with settlements, because each one ties to a deposit. Use transaction detail to break the settlement into sales, refunds and fee categories. Posting by order gives more detail but multiplies the work unless automated.
How do I reconcile eBay and Amazon at the same time?
Use the same method for each: one clearing account per channel, gross sales and fees booked at the transaction level, then payouts matched to the bank. If you list through Shopify’s Marketplace Connect app, orders from both marketplaces flow into Shopify, but you still need each marketplace’s own payout and fee data for accurate books.
Does the 1099-K tell me my sales?
Not net sales. The form reports gross payments before fees and refunds, so use it as a control total only. Your own ledger, built from transaction data, is the record of revenue and expenses. Ask a tax professional how to handle any differences on your return.
Sources
- IRS: Understanding your Form 1099-K
- Shopify Help Center: Fees and costs
- Amazon Seller Central: View transactions page
- Shopify Help Center: Marketplace Connect
- Shopify Help Center: Fulfill your Marketplace Connect orders
- Shopify Help Center: Multi-Channel Fulfillment by Amazon