Learn · Accounting & bookkeeping
How do you reconcile Amazon payouts in QuickBooks?
Short answer
Reconcile Amazon payouts in QuickBooks by posting each settlement as a summarized journal entry to a clearing account, splitting it into gross sales, fees, refunds, and tax, then matching the actual bank deposit against that clearing balance. When the clearing account nets to zero, the payout is fully reconciled.
By Marcus Brandt · Head of Seller Accounting
Updated June 26, 2026
Reconciling Amazon in QuickBooks trips up sellers because the deposit hitting your bank is never the same as your sales. Amazon settles a biweekly batch of orders and pays you the net amount after referral fees, FBA fees, advertising, refunds, and sometimes sales tax. If you just categorize that deposit as 'Amazon income,' QuickBooks will balance, but your revenue is wrong, your fees are invisible, and you'll never tie your books to Amazon's 1099-K.
Proper reconciliation does two jobs at once: it records what Amazon actually earned and charged you (the settlement), and it confirms the cash arrived (the bank deposit). The bridge between those two is a clearing account. Get this pattern right once and every future payout reconciles the same way, in minutes.
Set up the accounts you'll need first
Before you reconcile anything, build the structure in your QuickBooks chart of accounts. The reconciliation only works if each piece of a settlement has somewhere to go. You'll create one clearing account and a set of income and expense accounts that mirror the lines on an Amazon settlement report.
Create these accounts (names are conventional, adjust to your preference):
- •Amazon Clearing — a Bank or Other Current Asset account that holds settlements until the deposit lands
- •Gross Product Sales — an Income account
- •Referral Fees, FBA Fulfillment Fees, Storage Fees, Advertising — Expense accounts
- •Refunds & Returns — a contra-income or expense account
- •FBA Reimbursements — an Income or other-income account
- •Sales Tax Payable — a Current Liability account, if Amazon passes collected tax to you
Post each settlement as a summarized journal entry
Pull the settlement report from Seller Central for the period and total each category: gross sales, each fee type, refunds, reimbursements, and sales tax. Then in QuickBooks create one journal entry per settlement that books those totals and routes the net to your Amazon Clearing account. Do not import thousands of individual orders — a summarized entry per settlement is cleaner, faster, and how scalable ecommerce books are kept.
An illustrative settlement journal for a payout (made-up numbers, shown only to demonstrate the structure) might be:
- •Credit: Gross Product Sales $10,000
- •Debit: Referral Fees $1,500
- •Debit: FBA Fulfillment Fees $900
- •Debit: Advertising $400
- •Debit: Refunds & Returns $300
- •Credit: Sales Tax Payable $200
- •Debit: Amazon Clearing $7,300 (the net that should arrive as a deposit)
Match the bank deposit against the clearing account
When Amazon's deposit appears in your QuickBooks bank feed, you don't categorize it as income — you transfer it out of the Amazon Clearing account. In the bank feed, record the deposit as a transfer from Amazon Clearing (or match it to the journal you posted). This moves the cash from clearing into your real bank balance and leaves the clearing account net of that payout.
The reconciliation check is simple: after you've posted the settlement journal and matched the deposit, your Amazon Clearing account should return to zero for that payout. If it doesn't, something is off — usually the settlement period spans the deposit date, a fee category is missing, or sales tax was handled differently than expected. A non-zero clearing balance is your early-warning signal that the books don't tie.
One discipline pays off here: post the settlement journal from the totals on Amazon's settlement report, and require that the report's own lines sum to the reported total before you book anything. If the settlement doesn't add up, the deposit won't either, and reconciling backwards from a netted bank line is far slower than catching the discrepancy at the source. Treat the settlement report — not the bank feed — as the source of truth for what you earned.
Run the bank reconciliation and verify against the 1099-K
With settlements journaled and deposits matched, run QuickBooks' standard monthly bank reconciliation under the Reconcile tool: enter the bank statement's ending balance and date, then tick off the transactions — including your Amazon deposits — until the difference is $0.00. Because each Amazon deposit was matched to a settlement journal, the bank side ties out cleanly with no mystery income.
Finally, sanity-check across the year. Your total Gross Product Sales in QuickBooks should reconcile to the gross figure on Amazon's 1099-K, allowing for documented differences like sales tax and payout timing at year-end. Doing this end-to-end by hand is doable but slow; this is exactly the work BeanHawk automates — it turns each settlement into a balanced summarized journal and pushes it through the Amazon + QuickBooks integration, so your clearing account zeros out and your books reconcile without manual journals.
Frequently asked questions
- Why is my Amazon deposit different from my Amazon sales?
- Because Amazon pays you the net of a settlement: gross sales minus referral fees, FBA fulfillment and storage fees, advertising, and refunds, sometimes plus or minus collected sales tax. The deposit is the bottom line of dozens of deductions, which is why you split each settlement into its components rather than booking the deposit as income.
- Do I need a clearing account to reconcile Amazon in QuickBooks?
- It's strongly recommended. A clearing account lets you record the settlement when Amazon reports it and reconcile the cash separately when the deposit lands, since the two dates rarely match. When the clearing account nets to zero after both steps, you know the payout is fully and correctly recorded.
- Should I import every Amazon order into QuickBooks?
- No. Importing thousands of individual orders bloats your file and slows everything down. The standard practice is one summarized journal entry per settlement, with SKU- and order-level detail kept in a subledger or your Seller Central reports. This is how scalable ecommerce bookkeeping is done.
- How do I reconcile if a settlement period crosses two months?
- Post the settlement journal to the clearing account on the settlement date and match the bank deposit when it arrives, even if that's in the next month. The clearing account absorbs the timing gap. At month-end, a small non-zero clearing balance simply represents settlements reported but not yet deposited, which is expected and resolves the following period.
- How do I make my QuickBooks sales match the Amazon 1099-K?
- Reconcile your total Gross Product Sales for the year to the gross amount on the 1099-K, then account for documented differences: sales tax the marketplace collected, refunds reported in gross, and late-December payouts that settle in the next period. Because you booked gross sales separately in each settlement journal, the bridge from your books to the 1099-K is traceable rather than mysterious.
Keep learning
See what Amazon owes you — free
Connect your seller account and get a free reimbursement audit. No credit card, keep 100% of what you recover.