How do you reconcile Amazon payouts in QuickBooks?

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.

Resist the urge to lump everything into one "Amazon Fees" bucket. Referral fees scale with revenue, fulfillment fees scale with units shipped, and storage fees scale with how long inventory sits. If they're merged into one line, you can't see which lever is squeezing your margin, and you can't compare a fee increase against Amazon's published schedule when something looks off. Separate accounts cost you nothing to maintain once the pattern is set.

A question that comes up while you're building this: in QuickBooks Online, expense vs bill. They're different transaction types for different timing. A Bill records something you owe and will pay later, which is right for a supplier invoice with net-30 terms. An Expense records money that already left. Amazon fees are neither, because they never move as a separate payment; Amazon deducts them before paying you. That's exactly why they belong inside the settlement journal entry rather than being entered as bills or expenses, and why sellers who try to record fees as expenses end up double-counting them against the deposit.

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.

Here's what a mismatch looks like in practice. Say your settlement journal put $7,300 into clearing but the bank deposit was $7,100. The $200 gap is your search target, and it's almost always one of three things: a reserve Amazon held back (check the settlement's reserve line), a fee category you didn't map (search the report for line types missing from your journal), or a prior-period adjustment Amazon folded into this payout. Chase the exact dollar amount through the settlement file before touching the journal; guessing at a plug entry just moves the error somewhere quieter.

Handle the edge cases that break clean reconciliations

Account-level reserves are the most common surprise. Amazon sometimes holds back part of a payout (for new sellers, disputed orders, or unshipped merchant orders) and releases it in a later settlement. The reserve appears as its own line on the settlement report. Book it to the clearing account like everything else; the held cash simply sits in clearing until Amazon releases it, and the account still zeros out over the two settlements combined.

Refunds deserve their own account rather than being netted against sales. When a customer returns an item, Amazon claws back the sale and part of the referral fee in the same settlement. If you bury refunds inside gross sales, your revenue trend looks noisier than it is and your return rate becomes invisible in the P&L. Keep gross sales gross, and let Refunds & Returns show the real cost of returns.

FBA reimbursements are recovered losses, not new income in the ordinary sense. When Amazon pays you for a unit it lost or damaged, that payment offsets inventory you already owned. Booking reimbursements to their own account lets you compare what Amazon paid against what it should have paid, which is the starting point for filing claims on the gap. Sellers who blend reimbursements into sales never notice when Amazon under-reimburses.

Foreign marketplaces add a currency layer. If you sell on Amazon Canada or Europe, each marketplace settles in its own currency and converts on transfer. Post the settlement in the marketplace currency where your QuickBooks setup supports it, or book the converted amount and record the exchange difference explicitly. Either way, don't let conversion spread silently absorb into a rounding line.

Common mistakes that make Amazon books unreconcilable

Booking the deposit as income is mistake number one, and it compounds. Do it for a year and your revenue is understated by your entire fee load, your gross margin looks artificially fat, and your QuickBooks sales will disagree with the 1099-K by tens of thousands of dollars. Unwinding twelve months of netted deposits takes far longer than doing it right from the start.

Mistake two is posting settlements on the deposit date instead of the settlement date. The two rarely match, and at month-end the mismatch shifts revenue between periods. Post the journal as of the settlement period's close and let the clearing account carry the timing gap.

Mistake three is skipping months when volume is low. Reconciliation works because it's continuous; a skipped month means the next clearing balance is a blend of two periods and every discrepancy after that is ambiguous. Four settlements a month take minutes each once the pattern is set. Skipping doesn't save meaningful time, it just deletes your audit trail.

Mistake four is trusting the bank feed's auto-categorization. QuickBooks will happily suggest "Sales" for every Amazon deposit forever. Turn that suggestion off for Amazon transactions, or every reconciliation starts with undoing the bank feed's guess.

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.

Then 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. If you've followed the clearing-account pattern all year, this check takes an afternoon instead of a forensic week.

Doing this end-to-end by hand is doable but slow, and it's the first thing sellers automate. A purpose-built amazon quickbooks integration turns each settlement into a balanced summarized journal automatically, so you connect Amazon to QuickBooks once and every payout posts itself. This is exactly the work BeanHawk automates through its Amazon + QuickBooks integration: settlements become balanced journals, the clearing account zeros out, and your books reconcile without manual entry. A2X QuickBooks and Link My Books follow the same settlement-to-journal pattern, so whichever tool you pick, evaluate it on how it splits fee types and whether its journals balance to the penny.

Two practical notes on choosing from the app ecosystem. Start with Intuit-approved QuickBooks Online apps, since a listed app has at least passed a security and functionality review and won't break on the next API change. Then be clear which job each app does, because sellers routinely buy the wrong category: a settlement connector reconciles marketplace payouts, QuickBooks Online inventory apps value stock and track COGS, an invoice app that syncs with QuickBooks handles wholesale customers who pay on terms, and a Bill.com integration with QuickBooks Online handles supplier payables. Those are four different problems. One tool rarely does all four well, and the Bill.com QuickBooks integration in particular solves nothing about your Amazon payouts.

The same pattern extends to your other channels. A Shopify and QuickBooks Online integration should post payout summaries the same way, splitting gross sales, processing fees, and refunds instead of dumping orders, and a QuickBooks Etsy integration should do likewise. Hold every channel to the clearing-account test: post the settlement, match the deposit, watch the clearing account return to zero. Once all channels reconcile that way, reports that were previously fiction start working, including budget vs actual in QuickBooks Online, since your fee and ad lines finally carry real numbers to compare a budget against.