Amazon payouts almost never equal your Amazon "sales" number, and QuickBooks will only match the payout if the settlement is broken down correctly into gross sales, fees, taxes, and other adjustments for the same period as the bank deposit. When a mismatch appears after you have already connected Amazon or an app like the native Amazon Connector, the root cause is almost always one of a small handful of configuration or timing issues.
This document gives a practical pre-debug checklist: 7 things to review before you start deleting or re-posting data. It assumes you are posting Amazon into a clearing/control account in QuickBooks Online (recommended pattern for PayTraQer) and then matching bank deposits to settlement-based journals.
The first check is whether you are comparing the bank deposit to the correct Amazon report.
Amazon Seller Central shows multiple report types: business/performance reports, transaction reports, and settlement (payout) reports, and these rarely agree due to timing, timezone, and refund/fee treatment.
For reconciliation, you must always use the settlement report that corresponds to the payout you see in your bank feed; each settlement ID should match one bank deposit (or occasionally a pair if Amazon splits the payout by currency/bank).
Action steps:
In Amazon Seller Central, go to Payments → All statements / Reports → Payments and download the settlement report for the exact payout date range.
Confirm that the net settlement total in that report equals the gross sales minus refunds, fees, and reserves; this net should equal the deposit you see in your bank, not your Amazon "sales" dashboard.
Even if you use the correct settlement report, date-range differences can cause apparent mismatches between Amazon, the app, and QuickBooks.
Amazon settlement and transaction reports are generated in UTC, while Seller Central business reports and your accounting system may show local marketplace timezones, so a few orders on the edge of the period may appear in different months or pay cycles.
QuickBooks_Find Match screens default to the last 3 months and limited date ranges, so the correct journal may not appear even though it exists, making it look like there is no match for a payout.
Action steps:
When checking totals in Amazon vs QuickBooks, always align to settlement periods rather than calendar months; compare the settlement ID totals to the journal or clearing account activity for that same period.
In QuickBooks, expand the "Find match" date range back to the original settlement date and, if applicable, enable the "foreign currency" filter so the settlement journal appears as a match for the bank deposit.
A very common cause of mismatch is posting entries to the wrong account or letting Amazon app entries go straight into the operating bank instead of through a clearing account.
Best practice is to create an "Amazon Control" or "Amazon Clearing" bank-type account in QuickBooks and configure your connector (e.g., PayTraQer) to post summary journals or sales receipts there.
Bank deposits from Amazon should then be categorized as a transfer from this control/clearing account, so that after matching all settlements, the clearing account balance is either zero or equal to the value of the next payout or any open reserve.
Action steps:
In the Chart of Accounts, confirm that you have a dedicated Amazon clearing/control account and that the app is using this account (check the app settings → default deposit account).
Review the register for this account: it should show Amazon settlements (via journals or sales receipts) and corresponding transfers to your bank; if you see settlements going directly into the main bank account or to Undeposited Funds/Uncategorized Income, fix the mapping and re-post problem entries.
If the Amazon payout amount exists in QuickBooks but does not match the bank deposit, you may have either recorded it twice or skipped an entry.
Duplicates often occur when a payout is first added from the bank feed as a generic deposit and later also imported via App Transactions (e.g., QBO Commerce, Amazon Business app, or a connector), producing two deposits for the same payout.
Missing entries can happen if a payout was excluded or not posted from the app review screen, or if bank feeds skipped a transaction that needs to be added manually.
Action steps:
In QuickBooks Banking → App Transactions / Commerce transactions, review the payout list and ensure that each payout has been added once and only once; undo any incorrectly added payouts and re-add or exclude as needed.
In Banking → Bank transactions, scan the Reviewed and For Review tabs for Amazon deposits; delete generic manual deposits if the same payout is also represented via the app, or vice versa, to eliminate double counting.
Many users try to match the payout to Amazon "sales" and forget that the settlement includes multiple non-sales components that must be explicitly mapped in QuickBooks.
A single settlement will combine gross sales, refunds, shipping, promotions, sales tax, Amazon selling fees, FBA fees, storage, advertising, Amazon Pay processing fees, and often a reserve/withheld amount; if the integration only posts net sales, your payout will not match.
Best-practice workflows using PayTraQer allocate settlement lines into income accounts (product, shipping, tax) and expense accounts (fees) with the reserve posted to a liability/clearing account; the bank deposit is then recorded as a transfer from the clearing account, with the clearing account reconciling to zero after fees and reserves are considered.
Action steps:
Open the settlement CSV from Amazon and sum by transaction-type and fee type to verify that gross sales minus refunds, minus total-transaction-fee, minus reserve/withheld amounts equals the bank payout.
Compare this breakdown to the QuickBooks journal or sales receipt created by your connector: confirm that fees are hitting merchant fee/COGS/expense accounts and that reserves and other adjustments are posted to appropriate liability or clearing accounts, not silently netted against income.
Sometimes the mismatch starts after a change: reauthorizing the Amazon app, editing defaults, or after an app update.
In QuickBooks Amazon Business and similar apps, changing default Category or Payee mappings can suddenly send transactions to different accounts, breaking existing reconciliation patterns.
In 3rd-party tools (PayTraQer), a misconfigured default bank/clearing account or tax mapping can cause new settlements to post to a different account than earlier ones, so the bank feed cannot find the match.
Action steps:
Review the app/connector settings: check default income accounts, fee accounts, bank/clearing account, tax codes, and payment methods, and make sure they are consistent with your original design.
If there was a recent reconnect or TOS-driven reset (as has happened with Amazon Business app), audit several recent transactions to confirm they are posting to the expected ledger accounts and payee; adjust the defaults and reprocess any outliers.
Once the above are checked, the final validation is done inside the Amazon clearing/control account and the bank reconciliation screen.
A correctly configured flow will show, in the Amazon clearing account, all settlement journals (or sales receipts), fees adjustments, and bank transfers; when you reconcile that account for a period, the difference should be zero or equal only to the last-day-of-period captures that will be paid out next cycle.
Reconciliation best practices recommend comparing the register for the clearing account against the Amazon settlement report line by line, then ensuring that transfers to the bank equal the net payouts in your bank statement.
Action steps:
In QuickBooks, open the Amazon clearing/control account and start a reconciliation for the period; tick the settlement entries, fee journals, and the transfer(s) to the bank that relate to each settlement until the difference is zero.
If there is still a difference, go back to the settlement CSV to check for FX rounding, missing fees, or an unmatched reserve release, and record a small exchange gain/loss or corrective journal only after identifying the exact cause of the discrepancy.
If, after these seven checks, your Amazon clearing account still does not reconcile to zero and bank payouts still do not match, it usually indicates deeper historical issues such as incorrect opening balances, old duplicate entries, or structural mapping problems.
Undoing reconciliations and bulk reclassifying historic Amazon data can be time-consuming and risky; Intuit recommends using a QuickBooks Online Accountant user to undo reconciliations in bulk and clean up historic data.
For high-volume Amazon accounts, it is often more efficient to reset the integration logic (PayTraQer-style connector plus clearing account) going forward and then address prior-year cleanup separately with an e-commerce specialist bookkeeper.
By running through this checklist in order—source report, timing, clearing account, duplicates/missing payouts, fees and reserves, integration settings, and clearing reconciliation—you can usually isolate why a particular Amazon payout is not matching QuickBooks without breaking existing data.