Amazon sellers often run into the same QuickBooks problem: the amount deposited into the bank does not match the sales shown in Amazon.
That mismatch is normal. Amazon does not deposit gross sales into your bank account. Before the payout reaches your bank, Amazon may deduct referral fees, FBA fees, storage fees, refunds, promotions, chargebacks, reserves, and other adjustments. Some sellers may also see advertising or service-related charges depending on their Amazon setup.
So, if you simply add the Amazon bank deposit as income in QuickBooks, your books can quickly become inaccurate.
The right workflow is to record Amazon sales, fees, refunds, taxes, and adjustments separately, use a clearing account to track Amazon transaction activity, and then match the final Amazon payout to the actual bank deposit in QuickBooks.
This is where PayTraQer helps. Instead of treating the Amazon deposit as one income entry, PayTraQer helps sync Amazon transaction activity into QuickBooks based on connector settings and mapped accounts, so sellers and bookkeepers can review, match, and reconcile payouts properly.
This guide focuses on Amazon payout matching and reconciliation in QuickBooks Online. It does not cover detailed inventory valuation or COGS workflows.
An Amazon settlement is a summary of your seller account activity for a specific payout period. It shows what Amazon owes you after adding sales and credits, then deducting fees, refunds, reserves, and other charges.
An Amazon settlement may include:
Product sales
Shipping credits
Gift wrap credits
Promotional discounts
Referral fees
FBA fees
Storage fees
Refunds and return-related charges
Reimbursements
Marketplace facilitator tax
Account-level reserves
Previous balance carryovers
Final payout amount
Not every settlement includes every line type. The exact details depend on the seller’s activity, marketplace, fulfillment method, tax setup, account reserve status, and Amazon fee structure.
The final Amazon payout is the net amount Amazon sends to your bank. That payout is not the same as your gross sales.
For example, you may have $25,000 in Amazon sales for a settlement period, but only receive $18,400 in your bank account after Amazon deducts fees, refunds, reserves, and other adjustments.
That is why the Amazon deposit should not be treated as sales income by itself.
The Amazon payout is a net deposit. QuickBooks, however, needs the full accounting picture.
If you only record the bank deposit, QuickBooks may show lower sales and missing expenses. If you sync all sales separately and then add the deposit again from the bank feed, QuickBooks may show duplicate income.
The mismatch usually happens because the payout includes several moving parts.
Amazon Settlement Component | What It Means | QuickBooks Impact |
Gross product sales | Total sales before deductions | Should be recorded as income |
Amazon fees | Referral, FBA, storage, and other selling fees | Should be recorded as expenses |
Refunds | Amount returned to customers | Should reduce revenue or be tracked separately |
Promotions and discounts | Discounts given to buyers | Should reduce revenue or be mapped separately |
Sales tax | Tax collected through Amazon | Should be mapped based on whether the seller or Amazon is responsible for remittance |
Reimbursements | Amounts Amazon pays back to the seller | May be other income or adjustment income |
Reserves | Money temporarily held by Amazon | May remain in clearing until released |
Final payout | Net amount deposited to the bank | Should match the bank deposit |
The key point is this: gross sales, fees, refunds, tax, and payout are different accounting events. They should not all be collapsed into one bank deposit entry.
Amazon bookkeeping mistakes usually begin in the bank feed.
A seller sees an Amazon deposit in QuickBooks Banking and clicks “Add.” QuickBooks then records that deposit as income. But if Amazon sales were already synced separately, this creates duplicate revenue.
Other common problems include:
Amazon fees are missing from the Profit and Loss report.
Refunds are not recorded properly.
Sales tax is overstated or mapped to the wrong liability account.
Bank deposits are added instead of matched.
Amazon payouts do not reconcile with settlement reports.
The clearing account keeps an unexplained balance.
Reimbursements and reserves are ignored.
Month-end reconciliation takes longer than expected.
These issues can make the business look more profitable or less profitable than it really is.
For bookkeepers, the goal is not just to get Amazon data into QuickBooks. The goal is to make sure the settlement, payout, bank deposit, Profit and Loss, Balance Sheet, and clearing account all make sense together.
The cleanest way to handle Amazon settlements is to separate the sales activity from the cash deposit.
Here is the basic accounting logic:
Record Amazon gross sales as income.
Record Amazon fees as expenses.
Record refunds, discounts, and returns in accounts that reduce or explain revenue correctly.
Map tax carefully based on whether Amazon collected and remitted it or whether the seller still has a tax liability.
Use an Amazon clearing account to hold Amazon transaction activity.
Record the Amazon payout as a transfer from the clearing account to the real bank account.
Match the actual bank deposit in QuickBooks to that payout transfer.
Reconcile both the clearing account and the bank account.
This workflow prevents the Amazon deposit from being counted as new sales income.
An Amazon clearing account is a temporary account used to track money moving between Amazon and your real bank account.
Think of it as a holding account.
When Amazon sales happen, the clearing account increases. When Amazon fees, refunds, chargebacks, and adjustments are recorded, the clearing account decreases. When Amazon sends the payout to your bank, the clearing account is reduced again through a transfer to checking.
A healthy Amazon clearing account should usually return to zero, or to a balance that can be explained by reserves, timing differences, pending payouts, or carryovers.
If the balance cannot be explained, the bookkeeper should investigate it.
The remaining balance may represent:
Amazon reserves
Pending payout amounts
Timing differences
Carryover balances
Unmapped fees
Missing refunds
Duplicate entries
A payout that has not been matched yet
For many Amazon workflows in QuickBooks Online, bookkeepers use a bank-type clearing account because it supports transfers and reconciliation more cleanly. Sellers with multiple currencies should avoid mixing all Amazon activity into one clearing account. A separate clearing account per currency is usually cleaner.
PayTraQer connects Amazon with QuickBooks Online and helps sync Amazon transaction activity into QuickBooks based on the user’s configuration.
The important part is the setup.
Before syncing, users should review PayTraQer settings for sales, products and services, tax, fees, and payouts. These settings decide how Amazon activity flows into QuickBooks.
PayTraQer can support a more organized Amazon bookkeeping workflow by helping sellers and bookkeepers:
Sync Amazon transaction activity into QuickBooks
Record sales based on mapped settings
Map fees and expenses to the right accounts
Track refunds and adjustments
Review sales tax and withheld tax mapping
Use a clearing account for Amazon activity
Support payout transfer workflows where payout processing is available and enabled
Reduce manual spreadsheet work
Avoid duplicate entries through sync controls
Review synced data before reconciliation
PayTraQer does not remove the need for bookkeeping review. The seller or bookkeeper still needs to check mappings, review tax treatment, confirm payout matching, and reconcile the books.
Amazon sellers usually have two broad ways to bring data into QuickBooks: summary-level sync or itemized/order-level sync.
Sync Mode | Best For | Main Benefit | Watch Out For |
Summary sync | Higher-volume sellers, bookkeepers, month-end close workflows | Keeps QuickBooks cleaner and easier to reconcile | Less order-level detail inside QuickBooks |
Itemized sync | Sellers who need order-level or product-level detail in QuickBooks | More detailed reporting inside QuickBooks | Can create too many transactions, customers, items, or SKUs |
For many higher-volume Amazon sellers, summary sync is usually cleaner for QuickBooks reconciliation. It keeps QuickBooks from becoming crowded with too many order-level entries while still allowing the seller to track sales, fees, refunds, taxes, and payouts.
This is a bookkeeping recommendation, not a fixed rule. Itemized sync may still be better when the seller or accountant needs order-level, product-level, or customer-level reporting inside QuickBooks.
Before choosing a sync mode, confirm the current Amazon sync options available in your PayTraQer account, because connector settings and summary-sync availability can change.
If Amazon, Seller Central, or another system already handles operational reporting, summary sync may be enough for the accounting file.
Here is the recommended workflow.
Start with the Amazon settlement report or statement view for the payout period.
Check:
Settlement start date
Settlement end date
Deposit or payout date
Gross sales
Refunds
Amazon fees
Service-related charges, if any
Tax collected
Reimbursements
Reserves or holdbacks
Previous balance carryovers
Final payout amount
The final payout amount is the number that should eventually match the bank deposit.
Connect the Amazon account inside PayTraQer and authorize access based on the available integration flow.
Once connected, PayTraQer can read Amazon transaction activity and prepare it for sync into QuickBooks based on the selected settings.
Before syncing historical data, test with a small date range first. This makes it easier to catch mapping mistakes before a large batch of Amazon transactions reaches QuickBooks.
Connect PayTraQer to QuickBooks Online.
Make sure you are connecting the correct QuickBooks company file. This is especially important for bookkeepers handling multiple Amazon sellers or multiple business entities.
Review how Amazon sales should be recorded in QuickBooks.
In the sales settings, confirm the QuickBooks bank or clearing account that should receive Amazon sales activity. For a clearing-account workflow, this is usually the Amazon clearing account, not the real checking account.
This matters because Amazon sales do not go straight into your bank. They first sit inside Amazon’s settlement process. The clearing account helps QuickBooks reflect that gap between sales activity and the final payout.
Next, review the Product & Services settings.
This is where you decide how Amazon products or items should be handled in QuickBooks.
Depending on your workflow, you may want to:
Match Amazon products to existing QuickBooks products or services
Use common items for summary-level posting
Avoid creating unnecessary SKUs in QuickBooks
Map income accounts correctly
Decide whether product-level detail is truly needed inside QuickBooks
For summary sync, many bookkeepers prefer a simpler item structure so QuickBooks stays clean. For itemized sync, product and service mapping becomes more important because more detail flows into QuickBooks.
Map Amazon fees to expense accounts.
Common accounts may include:
Amazon Fee Type | Example QuickBooks Account | Account Type |
Referral fees | Amazon Referral Fees | Expense |
FBA fees | Amazon FBA Fees | Expense |
Storage fees | Amazon Storage Fees | Expense |
Refund processing fees | Amazon Refund Processing Fees | Expense |
Chargebacks | Amazon Chargebacks | Expense |
Service-related charges, if applicable | Amazon Service Fees | Expense |
This step matters because Amazon fees reduce the payout before money reaches the bank. If they are not recorded separately, the Profit and Loss report will not show the true cost of selling on Amazon.
Amazon tax treatment needs careful review.
In PayTraQer, review the mapping for sales tax and withheld tax. Do not assume all tax amounts should go to the same QuickBooks account.
In many cases, Amazon may collect and remit marketplace facilitator tax. Tax collected and remitted by Amazon should not automatically be treated the same as sales tax the seller still owes directly.
Before syncing, review whether tax should be mapped to:
A sales tax liability account
A marketplace facilitator tax clearing account
A withheld tax account
A pass-through liability account
Another accountant-approved account
Sales tax rules vary by location, marketplace, and seller responsibility. This is one area where sellers should confirm the setup with an accountant before syncing large date ranges.
Map Amazon transaction activity to an Amazon clearing account.
A simple setup may look like this:
Account | Type | Purpose |
Amazon Clearing | Bank | Holds Amazon activity before payout |
Checking Account | Bank | Receives the actual Amazon deposit |
Amazon Sales | Income | Records gross Amazon sales |
Amazon Fees | Expense | Records Amazon selling fees |
Amazon Refunds | Contra-income or expense | Tracks refunds and returns |
Marketplace Facilitator Tax / Withheld Tax | Liability or clearing | Tracks Amazon-collected or withheld tax separately |
Sales, fees, refunds, adjustments, and payouts should be mapped in a way that allows the clearing account to explain the difference between gross sales and the final payout.
If sales and fees are mapped to different clearing accounts without a clear reason, the clearing balance may not reconcile properly.
PayTraQer payout settings are important for bank matching.
Where payout processing is available and enabled for the connector, PayTraQer can create or support a payout transfer from the connector clearing account to the selected settlement bank account. This gives QuickBooks a transaction that the bank feed deposit can match against.
Without proper payout handling, QuickBooks may only see the bank deposit and suggest adding it as income. That is where duplication can happen.
Before turning on broader sync, confirm:
The correct clearing account is selected
The correct checking account is selected
Payout processing is available and enabled where needed
The payout date and amount can be matched in QuickBooks
Existing bank rules will not auto-add Amazon deposits as income
Do not start with months of Amazon history unless the mapping has already been verified.
Sync one small date range or payout period first.
Then check QuickBooks for:
Sales entries
Fee entries
Refund entries
Tax mapping
Clearing account activity
Payout transfer, where payout processing is available and enabled
Bank account impact
If the test sync looks right, continue with the remaining date range.
Open the Amazon clearing account register in QuickBooks.
Check whether the activity makes sense:
Sales should increase the clearing account.
Fees should reduce the clearing account.
Refunds should reduce the clearing account.
Reimbursements should increase it.
Reserves may leave a remaining balance.
The payout transfer should move money from Amazon clearing to checking.
The clearing account should tell the story of the settlement.
If the balance does not make sense, stop and review the mapping before syncing more data.
Once the real Amazon deposit appears in the QuickBooks bank feed, go to the bank transactions screen.
Find the Amazon deposit.
QuickBooks may suggest a match if the amount and date are close. If it does not, search for the existing payout transfer and widen the date range.
A difference in date does not always mean the sync is wrong. Amazon settlement dates and bank deposit dates may differ because of payout timing, reserves, processing delays, or bank posting dates.
This is the most important step.
If PayTraQer has already synced the Amazon payout or created the transfer to checking, the bank feed deposit should be matched to that existing transaction.
Do not click Add and categorize the deposit as income.
Use Match.
Adding the deposit as new income can duplicate Amazon revenue and leave the clearing account unreconciled.
After matching the bank deposit, reconcile the Amazon clearing account against the Amazon settlement statement.
Check whether the ending balance makes sense.
A remaining balance may be fine if it represents reserves, timing differences, or carryovers. But if the balance cannot be explained, review the settlement report and clearing register again.
Look for:
Missing fees
Missing refunds
Incorrect tax mapping
Duplicate sales
Missing payout transfer
Manual entries posted to the clearing account
Bank feed deposits added as income
Currency-related differences
Finally, reconcile the checking account in QuickBooks against the bank statement.
The Amazon deposit in the bank should match the payout transfer created through the workflow.
This confirms that both sides are correct:
Amazon activity is recorded.
The real bank deposit is matched.
The clearing account is explainable.
The bank reconciliation is clean.
Area | Manual Workflow | PayTraQer-Assisted Workflow |
Data entry | Download reports and enter sales, fees, refunds, and payouts manually | Sync Amazon transaction activity into QuickBooks based on settings |
Fee tracking | Requires spreadsheet formulas or manual journal entries | Fees can be mapped to QuickBooks expense accounts |
Refund tracking | Easy to miss or combine with sales | Refunds can be synced and reviewed separately |
Payout matching | Often handled manually from the bank feed | Payout entries or transfers can be matched where payout processing is configured |
Clearing account | Must be built and maintained manually | Can be used as part of the sync and payout workflow |
Risk of duplicate income | Higher if bank deposits are added as income | Lower when payouts are matched properly |
Review required | High | Still required, but with less manual entry |
Best fit | Very small sellers or one-off cleanup | Sellers and bookkeepers managing recurring Amazon payouts |
PayTraQer helps reduce manual work, but it does not replace reconciliation. A bookkeeper still needs to review mappings, match deposits, check clearing balances, and confirm that tax and reserves are handled correctly.
Problem | Likely Cause | Where to Check | How to Fix | Prevention Tip |
Amazon deposit does not match sales | Comparing net payout to gross sales | Amazon settlement report and QuickBooks sales entries | Compare payout to settlement total, not gross sales | Always separate gross sales from payout |
Deposit does not auto-match in QuickBooks | Payout transfer missing, date differs, or amount differs | QuickBooks bank feed and clearing register | Search for the payout transfer and adjust the date range | Enable and review payout settings before syncing |
Amazon income is doubled | Deposit was added as income after sales were synced | Profit and Loss, bank feed, sales entries | Undo the added deposit and match it correctly | Do not use Add when payout already exists |
Fees are missing | Fee mapping was not configured or not active during sync | PayTraQer fee settings, sync history, and P&L | Review sync history, check mapping, undo incorrect entries if needed, then re-sync carefully | Test one payout period first |
Refunds are missing | Refund sync or mapping issue | Amazon report, PayTraQer sync history, QuickBooks | Review refund settings and map properly | Review refund activity every month |
Sales tax is overstated | Marketplace facilitator tax or withheld tax mapped incorrectly | Tax liability account, withheld tax account, and tax reports | Move tax to the correct account after accountant review | Confirm tax setup before full sync |
Clearing account has old balance | Missing payout, reserve, carryover, duplicate entry, or unmapped adjustment | Amazon clearing register | Compare settlement report to clearing activity line by line | Reconcile clearing account monthly |
Product list has too many SKUs | Itemized sync or auto-create setting created products | Products and services list | Use summary sync or common item where suitable | Decide reporting needs before syncing |
Multi-currency payouts are confusing | Multiple currencies mapped to one account | Clearing accounts and bank accounts | Create separate clearing accounts by currency | Set currency-specific accounts upfront |
Bank rules create wrong entries | QuickBooks rule auto-adds Amazon deposits | Banking rules and bank feed | Disable or edit the rule | Do not auto-post Amazon deposits as income |
Amazon Settlement Component | Example QuickBooks Account | Account Type | Why It Matters |
Gross product sales | Amazon Product Sales | Income | Shows sales before Amazon deductions |
Shipping credits | Amazon Shipping Income | Income | Separates shipping income from product sales |
Gift wrap credits | Amazon Gift Wrap Income | Income | Keeps non-product income visible |
Promotions and discounts | Amazon Discounts | Contra-income | Reduces revenue instead of hiding discounts in net payout |
Referral fees | Amazon Referral Fees | Expense | Shows the cost of selling on Amazon |
FBA fees | Amazon FBA Fees | Expense | Tracks fulfillment cost separately |
Storage fees | Amazon Storage Fees | Expense | Helps monitor inventory-related platform cost |
Refunds and returns | Amazon Refunds and Returns | Contra-income or expense | Prevents revenue from being overstated |
Reimbursements | Amazon Reimbursements | Other income or income | Keeps reimbursements separate from product sales |
Marketplace facilitator tax | Marketplace Facilitator Tax / Withheld Tax | Liability or clearing | Prevents tax collected/remitted by Amazon from overstating seller tax payable |
Reserves or holdbacks | Amazon Reserve Receivable | Other current asset or clearing | Explains money Amazon has not paid out yet |
Final payout | Transfer from Amazon Clearing to Checking | Bank transfer | Creates the entry that can be matched to the bank deposit |
The exact chart of accounts should be reviewed with an accountant, especially for tax, reserves, reimbursements, and multi-currency activity.
Reserve and holdback accounts should also be reviewed with an accountant. Use them when Amazon timing, carryovers, or reserves create an explainable balance that should not be forced to zero.
After matching Amazon settlements to bank deposits, review the main QuickBooks reports to confirm the workflow is clean.
QuickBooks Report or View | What to Check |
Bank register | Confirm the Amazon deposit is matched, not duplicated |
Bank reconciliation report | Confirm the real bank account reconciles |
Amazon clearing account register | Review sales, fees, refunds, payouts, and remaining balance |
Profit and Loss | Check that sales and Amazon fees are separated |
Balance Sheet | Review clearing account, reserve, and tax balances |
Transaction Detail by Account | Investigate differences by account |
Sales Tax Liability or tax detail report | Review tax mapping and withheld tax treatment |
Sales by Product/Service | Useful only if itemized sync is used |
Undeposited Funds | Confirm Amazon payouts are not sitting in the wrong account |
The most useful review is the clearing account. If that account has a balance, the balance should be explainable. If it is not, the issue usually comes from missing fees, wrong tax mapping, duplicate deposits, unmapped adjustments, or payout timing.
This workflow is useful for Amazon sellers who:
Use QuickBooks Online
Receive regular Amazon payouts
Want Amazon fees separated from sales
Need clean bank reconciliation
Work with a bookkeeper or accountant
Sell across multiple Amazon marketplaces
Deal with refunds, reserves, reimbursements, or tax complexity
Want better month-end closing controls
Very small sellers may start with a manual process, but as transaction volume increases, manual Amazon reconciliation becomes harder to maintain.
A PayTraQer-assisted workflow makes the process more structured because it helps bring Amazon transaction activity into QuickBooks with mapped accounts and payout matching support where configured.
Amazon deposits rarely match gross sales because Amazon payouts are already reduced by fees, refunds, reserves, and other adjustments. That is normal.
The accounting mistake is treating the net deposit as the whole story.
For cleaner books, Amazon sellers should record gross sales separately, track fees and refunds properly, review tax mapping carefully, use an Amazon clearing account, and match the final payout to the actual bank deposit in QuickBooks.
PayTraQer helps by syncing Amazon transaction activity into QuickBooks based on mapped settings and, where payout processing is available and enabled, supporting a payout transfer workflow that can be matched in the bank feed.
But the final review still matters. Bookkeepers should check the clearing account, confirm tax treatment, review reports, and reconcile both the Amazon settlement activity and the real bank account.
When this workflow is set up correctly, Amazon payouts stop looking like random bank deposits and start becoming traceable, explainable activity inside QuickBooks.
Because Amazon deposits the net payout, not gross sales. The payout may already include deductions for fees, refunds, promotions, reserves, tax-related items, and other adjustments.
An Amazon settlement is a payout-period report that shows sales, fees, refunds, tax, reimbursements, reserves, carryovers, and the final amount Amazon sends to your bank.
Not if Amazon sales are already recorded separately. The payout should usually be matched to the existing payout or transfer entry, not added again as income.
It is a temporary account used to track Amazon transaction activity before the final payout reaches your bank account.
For many QuickBooks Online payout workflows, bookkeepers use a bank-type clearing account because it supports transfers and reconciliation more cleanly.
They use clearing accounts to separate gross sales, fees, refunds, reserves, and final payouts instead of forcing everything into one bank deposit entry.
Depending on the connector settings, PayTraQer can sync Amazon transaction activity into QuickBooks, including sales-related entries, fees, refunds, tax mappings, and related records shown in the review and sync flow. Payout transfers depend on payout processing being available, enabled, and mapped correctly.
PayTraQer provides fee and expense configuration options so Amazon fees can be mapped to proper QuickBooks expense accounts.
PayTraQer helps organize Amazon transaction activity and payout entries so the final Amazon bank deposit can usually be matched in QuickBooks when the payout transfer, amount, date, and bank account align.
Many higher-volume sellers use summary sync for cleaner books and easier reconciliation. Itemized sync is better when order-level or product-level detail is required inside QuickBooks.
This can happen if marketplace facilitator tax or withheld tax is mapped as tax the seller still owes. Review tax mapping with an accountant.
Duplicate income usually happens when Amazon sales are synced separately and the bank feed deposit is also added as income instead of being matched.
QuickBooks may not find a match if the payout transfer is missing, the date is outside the search range, the bank account is wrong, or the amount differs because of reserves or adjustments.
Check the Amazon clearing account, confirm the payout entry exists, widen the date range in QuickBooks, and compare the amount to the Amazon settlement report.
Reserves can cause part of the seller’s balance to remain with Amazon instead of being paid out immediately. This may leave a balance in the clearing account.
It is usually cleaner to use separate clearing accounts for each currency. Mixing currencies can make settlement reconciliation harder.
Review the bank register, bank reconciliation report, Amazon clearing account register, Profit and Loss, Balance Sheet, Transaction Detail by Account, and tax-related reports.
It may represent reserves, timing differences, carryovers, missing fees, duplicate entries, or an unmatched payout. The balance should always be explainable.
No. PayTraQer can reduce manual entry and organize Amazon data, but a bookkeeper should still review mappings, tax treatment, reports, and reconciliation.
Generally, no if Amazon sales are already synced or manually recorded elsewhere. Use Add only when you intentionally want QuickBooks to create a new transaction and you are sure it will not duplicate income.