What Makes Amazon Reconciliation Different From a Normal Bank Account?

Most bookkeepers who work with Amazon sellers for the first time make the same catastrophic error: they see a $50,000 deposit in their client's bank feed, click "Add," and categorize it as "Sales." That single click produces a P&L statement that is a work of fiction.

Here is the reality. A real Amazon FBA settlement deposit of $50,000 might actually represent:

If you record $50,000 as "Sales," you have just overstated expenses by $27,255, missed $4,150 in refunds, lost track of $620 in reimbursements, and left your client completely blind to true profitability.

What makes Amazon uniquely difficult:

• Bi-Weekly Rolling Settlements: Amazon pays sellers every 14 calendar days on a rolling cycle. This cycle rarely aligns with the calendar month, which means a settlement that starts on January 18 may close on February 1, straddling two accounting periods.

• Net Deposits: The bank receives one lump-sum ACH transfer. It is the net of everything in the table above after Amazon has taken its cut. There is no itemized breakdown visible in your bank feed.

• The DD+7 Reserve Policy (effective March 12, 2026): Amazon has updated its US seller payout model to "Delivery Date Based Reserve (DDBR)" — informally called DD+7. Funds are now held for 7 calendar days after confirmed delivery, not after shipment. Combined with the standard 14-day settlement cycle, an FBA seller can wait 14–27 days from order placement to bank deposit. FBM sellers on standard shipping can wait up to 35 days. This means the settlement creation date in Seller Central and the actual bank deposit date will often be a week apart — a critical distinction when matching in QBO.

• Marketplace Facilitator Tax: Amazon collects and remits sales tax to US state governments on your behalf in all US states. If you record the tax Amazon collected as your own Sales Tax Payable, you are double-reporting a liability you do not owe.

• Account Level Reserve: Separate from DD+7, Amazon dynamically holds a reserve based on your return rate, customer claim history, and account health. This reserve covers future refunds and A-to-Z claims and typically represents 7–14 days of recent sales. It means the settlement closing balance may NOT be $0 even if you received all expected payouts.

• No Native QBO Connection: QuickBooks does have an Amazon Marketplace Connector app, but it does not fully reconcile payouts, handle Marketplace Facilitator Tax automatically, or separate fees. Intuit's own community support confirms that reconciling Amazon transactions natively in QBO is unavailable.

Understanding Amazon Transaction Types and PayTraQer Sync Logic

Before touching PayTraQer settings, you must understand the exact types of transactions that exist inside an Amazon settlement report. Amazon's own Settlement Report documentation classifies transactions into the following types, each of which must be mapped differently in QBO:

Amazon Settlement Transaction Types

How PayTraQer Syncs These to QBO

PayTraQer operates on a Clearing Account model — a well-established bookkeeping pattern specifically designed for marketplace payouts. Here is the exact data flow:

1. PayTraQer connects to Amazon Seller Central via API and downloads the full settlement report.

2. For each settlement, PayTraQer creates entries in QBO that post all sales (credits) and all fees (debits) into a single holding account — your Amazon Bank Account (the clearing account you create in QBO).

3. When Amazon disburses the payout, PayTraQer detects it and creates a Bank Transfer in QBO — moving the exact net payout amount from the Amazon Bank Account to your real Checking Account.

4. This single Bank Transfer is what appears in your QBO bank feed and can be matched to the actual bank deposit.

Sync Modes: Which One Should Amazon Sellers Use?

PayTraQer offers two sync modes and the choice is permanent unless you fully disconnect and reconnect the integration:

Consolidated (Summary) Sync:

• Creates one summarized QBO Sales Receipt per settlement or per day.

• Best for: All Amazon sellers with more than 50 orders per settlement period.

• Why: Amazon settlements can contain thousands of line items. Itemized sync creates a QBO transaction for each one, bloating your QBO file and causing performance issues.

• Reconciliation benefit: Each summary exactly matches a payout, making bank feed matching predictable.

Itemized (Individual) Sync:

• Creates a separate QBO Sales Receipt or Invoice per customer order.

• Best for: Very low-volume sellers (under 50 orders per settlement) who need per-customer reporting in QBO.

• Caution: This is rarely the right choice for Amazon FBA because Amazon does not provide customer names or emails — QBO will create blank or "Amazon Customer" entries for every order.

Recommendation: For almost every Amazon seller, use Consolidated Sync. You can always pull order-level detail from Amazon Seller Central or Seller Central reports when needed. QBO is for financial reporting, not order management.

Step 1 — Prerequisites and QBO Chart of Accounts Setup

Complete these steps in QBO before opening PayTraQer. Getting the chart of accounts right from the start means every subsequent step works automatically.

Create the Amazon Clearing Account

1. In QBO, go to Accounting → Chart of Accounts → New.

2. Account Type: Bank

3. Detail Type: Checking (selecting Bank type is critical — this is what enables the Reconcile function)

4. Name: Amazon Bank Account

5. Click Save and Close.
   Why Bank type, not Other Current Asset? Amazon CPAs and bookkeepers specifically recommend Bank type because it allows you to use QBO's Reconcile function against the clearing account directly, and it allows the Banking feed to create Transfers that appear in the register. Using Other Current Asset loses both of those capabilities.

Create Your Amazon Fee Expense Accounts

Set these up in QBO Chart of Accounts before mapping them in PayTraQer. Use these exact names or adapt to your firm's naming convention:

• FBA Fulfillment Fees (Expense)

• FBA Storage Fees (Expense)

• Amazon Referral Fees (Expense)

• Amazon Advertising / Sponsored Ads (Expense)

• Amazon Selling Plan Fee (Expense)

• Amazon A-to-Z Claims (Expense)

• Amazon Reimbursements (Other Income — separate from product sales)

• Marketplace-Facilitated Tax (Other Current Liability — this will zero out)

Download Your Source of Truth

From Amazon Seller Central: go to Reports → Payments → All Statements. Find the settlement period you are reconciling. Download both:

• Statement View (summary totals, gives you the reconciliation closing balance)

• Transaction View CSV (detailed line items, used for verifying each fee category)

The Statement View closing balance is what you will enter when reconciling the Amazon Bank Account in QBO.

Step 2 — Product Mapping and Income Classification in PayTraQer

This is the step most users skip, and it is why their P&L gets ruined after the first auto-sync. If PayTraQer doesn't know where to classify income, it will either auto-create thousands of Amazon ASINs as QBO Products, or it will dump everything into an "Uncategorized Income" bucket.

Auto-Create vs. Common Item — Which Should You Choose?

Use a Common Item (Strongly Recommended for Amazon FBA):

Amazon has hundreds to thousands of ASINs per seller. Auto-creating QBO Products for each ASIN creates "SKU bloat" — a QBO item list with thousands of entries, most of which are never used for invoicing or reporting. This slows QBO down and makes your item list unmanageable.

Instead: In PayTraQer's Products & Services Settings, turn OFF Auto-Create and turn ON Common Product/Service. Create a single QBO item called Amazon General Sales (Service type).

PayTraQer will ignore individual ASINs from each Amazon order and map all product revenue to this one item.

Use Auto-Create only if:

• You sell fewer than 20 distinct SKUs on Amazon AND you want item-level profitability reporting in QBO — though most CPAs recommend handling item-level profitability in a dedicated inventory tool like Linnworks or SkuVault rather than QBO.

Mapping the Income Account

Whether you use a Common Item or Auto-Create, you must assign the correct QBO Income Account to your Amazon sales item. In PayTraQer Products & Services Settings:

• Income Account: Amazon Product Sales (create this as an Income account in QBO first)

• Shipping Income Account: Amazon Shipping Income

• Gift Wrap Income Account: Amazon Gift Wrap Income

Once this is configured, every auto-sync will hit the correct P&L line without any manual intervention. This is the setting that enables fully automated, hands-off bookkeeping for your Amazon channel.

Step 3 — Configuring PayTraQer Settings for Amazon

In PayTraQer, navigate to the Gear Icon (Settings) → Select Amazon connector. Work through each settings block in order.

Sales Settings

• Bank Account to Deposit: Select Amazon Bank Account (your clearing account).

• Payment Method: Amazon Marketplace.

• Customer: Set to "Common Customer" (e.g., Amazon Marketplace) in Consolidated mode, since individual customer names are not available from Amazon.

Tax Settings

• Marketplace Facilitator Tax: Map Amazon's collected tax to Marketplace-Facilitated Tax (your zero-net liability account). This ensures the tax Amazon collected on your behalf flows through your books correctly without inflating your Sales Tax Payable.

• Do NOT map it to your regular Sales Tax Payable account. You do not owe this tax — Amazon already remitted it.

Fees Settings

This is the most important configuration block for Amazon. Map each fee type individually:

Critical Setting: For every fee type, the Bank Account must be set to your Amazon Bank Account (the clearing account) — the same account used in Sales Settings. If fees go to a different account, your clearing account will never zero out and every reconciliation will fail.

Payout Settings

• Enable "Process the Payout": Toggle this to ON. This is the single most important toggle in PayTraQer. When ON, PayTraQer creates a Bank Transfer from Amazon Bank Account to your Checking Account whenever it detects an Amazon disbursement.

• Transfer To Account: Your real-world Business Checking Account.

• Negative Balance Account: Select your Business Checking Account here as well. This handles periods where Amazon's deductions exceed gross sales (the payout goes to zero or negative, meaning Amazon takes money back from your next settlement).

Step 4 — Syncing Transactions and Verifying in QBO

Initial Sync

After configuring all settings, run your first sync:

1. In PayTraQer, go to the Transactions Dashboard.

2. Set the date range to your target period (e.g., January 1 – January 31).

3. Click Download Transactions. PayTraQer pulls the settlement data from Amazon.

4. Review the transactions in the Review Tab before syncing:

   • Check that customer names show Amazon Marketplace

   • Check that fee amounts appear as separate lines with correct expense accounts

   • Check that the Tax column shows the Marketplace-Facilitated Tax mapping

5. Click Sync to QuickBooks.

Enable Auto-Sync

After verifying the initial sync is correct, enable Auto-Sync in PayTraQer's Automation Settings. From this point forward, PayTraQer will automatically pull new Amazon settlements every few hours and post them to QBO without any manual intervention.

Verify in QBO

Open QBO and go to Accounting → Chart of Accounts → Amazon Bank Account → View Register. You should see:

• Sales Receipt (or Journal Entry in Summary mode) for gross sales

• Expense entries for each fee type

• A Bank Transfer for the payout amount to your Checking Account

The running balance in the register should approach $0 after each payout Transfer is recorded (accounting for any reserves held by Amazon).

Step 5 — The QBO Bank Feed Matching Process

This is where the physical bank deposit gets reconciled to PayTraQer's transfer entry. This step must be done before you run the formal reconciliation.

How to Match Amazon Deposits in the QBO Bank Feed

1. Go to QBO Banking → Banking (left side panel).

2. Select your Business Checking Account from the account list.

3. Click the For Review tab.

4. Locate the Amazon ACH deposit (it will appear as "Amazon" or "AMAZON PAYMENTS" in the payee column).

5. QBO will automatically suggest a match in green — it will show you the Bank Transfer that PayTraQer created.

6. Click Match.
   
   Do NOT click "Add." This is the single most important instruction in the entire article. Clicking "Add" on an Amazon deposit creates a new income entry in QBO, recording the full $50,000 (or whatever the net deposit is) directly as revenue. Your gross sales, fees, refunds, and reimbursements that PayTraQer already posted to the clearing account are now doubled. Your P&L is now completely wrong and will require hours of cleanup.

What If QBO Doesn't Suggest a Match Automatically?

If the bank deposit sits in "For Review" without a suggested match, it means PayTraQer's Bank Transfer and the bank deposit have a discrepancy. Check these:

• Date mismatch: PayTraQer posted the Transfer on the settlement close date; the bank deposit arrived 7+ days later (DD+7 policy). In the Match window, expand the date range to look further back.

• Amount mismatch: A Reserve adjustment or Carryover is included in the settlement but was not synced by PayTraQer yet. Check the Amazon Statement View for any Reserve or Carryover amounts that altered the final disbursement.

• Payout processing disabled: If PayTraQer's "Process Payout" toggle was OFF, no Bank Transfer was created. See the troubleshooting section below.

Step 6 — Reconciling the Accounts in QBO

Reconcile the Amazon Bank Account (Clearing Account)

This is the second reconciliation that most bookkeepers forget — and the most important one for verifying accuracy.

1. Go to QBO Accounting → Reconcile.

2. Click Start Reconciling.

3. Select account: Amazon Bank Account.

4. Enter the Ending Balance from the Amazon Settlement Report Statement View.

5. Enter the Ending Date — use the settlement close date, not the bank deposit date.

6. Click Start Reconciling.

7. In the reconciliation screen, you will see:

   • Sales Receipts/Journals on the Credits side (gross sales, shipping, reimbursements)

   • Expenses on the Debits side (all fees)

   • The Bank Transfer on the Debits side (the payout to checking)

8. Check off all items. The Difference should show $0.00.

9. Click Finish Now and save the reconciliation report as a PDF for your records.
   If the Difference is not $0: The most common causes are: a fee type not mapped in PayTraQer (un-synced expense), a Carryover from the prior settlement not yet posted, or an Amazon Reserve that has not yet been released. Cross-reference the Transaction View CSV to find the line item causing the discrepancy.

Reconcile the Main Bank Account

After clearing the Amazon Bank Account, proceed with your normal checking account month-end reconciliation. The matched Amazon Bank Transfers will already appear as cleared items, so the checking account reconciliation should balance cleanly.

Troubleshooting: Manual Deposits vs. PayTraQer Single Transfers

This is the #1 source of broken reconciliations that accountants ask about in forums. When a bookkeeper mixes manual QBO entries with PayTraQer's automated Transfer system, the result is duplicated income and an unreconcilable bank feed.

The Problem Scenario

A user has PayTraQer installed but initially had "Process Payout" turned OFF. They manually used QBO's Banking → Bank Deposit screen to group individual Amazon sales receipts together and create a deposit that matches the bank amount.

Later, they turn "Process Payout" ON in PayTraQer. Now PayTraQer creates a Bank Transfer for the same settlement period. The QBO bank feed shows the Amazon bank deposit but sees both:

• A manually created Bank Deposit (from the bookkeeper's manual work)

• A PayTraQer Bank Transfer (from the automation)

Both have the same amount. QBO cannot safely match one to a bank deposit and doesn't know which is correct. The result: the bank deposit sits unmatched, or worse, the bookkeeper clicks "Add" and records it a third time.

The Fix (Step by Step)

1. Go to QBO Banking → Categorized tab. Find any Amazon deposits that were matched to manually created entries. Click Undo to return them to "For Review."

2. Find and delete the manual Bank Deposits. Go to QBO + New → Bank Deposit history or search the register of your Checking Account for manually created Deposit entries from Amazon. Open each one and delete it. The individual Sales Receipts that were grouped inside those deposits will safely return to the Amazon Bank Account clearing account — they are not deleted.

3. Confirm PayTraQer's Payout is ON. In PayTraQer Settings → Payout Settings → ensure "Enable Process the Payout" is toggled ON and the Transfer Account is set to your Checking Account.

4. Re-sync the affected period. In PayTraQer Transactions Dashboard, set the date range for the affected settlements and click "Download and Sync." PayTraQer will create clean Bank Transfers for each settlement payout.

5. Go back to QBO Banking → For Review. Find the Amazon deposit. QBO will now suggest the PayTraQer Transfer as a Match (highlighted in green). Click Match.

6. Reconcile. Proceed with clearing account reconciliation as described in Step 6.

Bookkeeper tip from Reddit: When you journal the Amazon settlement manually (the old-school method), attach a copy of the Amazon Settlement Report PDF directly to the journal entry in QBO. If any auditor or client asks about the deposit later, the breakdown is right there inside the transaction.

Final Month-End Checklist for Amazon + QBO Reconciliation

Run through this checklist before closing any Amazon client's books:

• Amazon Settlement Report (Statement View + Transaction CSV) downloaded from Seller Central for the period

• All settlements confirmed as "Synced" in PayTraQer Transactions Dashboard — no red errors

• Each Amazon fee type (FBA, storage, referral, advertising, subscription) mapped to its own QBO expense account in PayTraQer Fees Settings

• Marketplace-Facilitated Tax mapped to pass-through account — NOT Sales Tax Payable

• No manually created Bank Deposits from Amazon in QBO that conflict with PayTraQer Transfers

• Each Amazon bank deposit Matched (not Added) in QBO Banking For Review tab

• Amazon Bank Account (clearing) reconciled to Statement View closing balance — Difference shows $0.00

• P&L reviewed: Gross Amazon Sales, FBA Fees, Storage, Referral, and Advertising all on correct lines

• Reimbursements in Amazon Reimbursements (Other Income) — not mixed with Product Sales

• DD+7 reserves: any unmatched balance in Amazon Bank Account documented as an in-transit reserve for the next cycle

• Reconciliation Report PDF saved to client folder.