How to Reconcile Amazon Settlements in QuickBooks Online

Quick Answer

To reconcile Amazon settlements in QuickBooks Online under accrual accounting, record sales as Invoices and Amazon fees as Bills on their recognition dates. When Amazon later releases sale proceeds, use Receive payment to close the Invoices and deposit the payments into an Amazon Balance clearing account. When Amazon deducts the fees, use Bill payments from Amazon Balance to close the Bills. Finally, record the settlement payout as a transfer from Amazon Balance to checking.

The distinction that matters is this:

• The Invoice and Bill record the economic activity. They recognize revenue and expense through Accounts Receivable (A/R) and Accounts Payable (A/P), without pretending cash moved on the same date.
• Receive Payments and Bill Payments record Amazon’s later cash activity. DD+7 can therefore leave a sale Invoice open until Amazon releases the proceeds.
• The settlement’s Disbursement amount should normally match the bank deposit after bank processing.
• Gross sales and transaction-date activity will not match that net deposit because Amazon subtracts fees, refunds, advertising, marketplace tax withholding, and other charges while carrying deferred or reserved funds between periods.

Amazon’s payment-report overview confirms that the Disbursements view shows the amount paid for each settlement period. If that amount differs from the deposit that reaches your bank, investigate the transfer status or Trace ID before changing your books.

Accounting note: This guide describes a common operational workflow, not a universal revenue-recognition or tax rule. Your posting dates depend on whether you use cash or accrual accounting and on when your policy considers goods provided. Do not change accounting methods or assume shipment is always the recognition date without your accountant’s approval. Intuit’s guide explains the cash-versus-accrual distinction.

---

Why Gross Amazon Activity Does Not Equal the Bank Deposit

Amazon generally settles seller accounts on a 14-day cycle. The payout starts with the available balance, adds and subtracts activity, then carries unavailable amounts forward:

• The deposit is net, not gross. Amazon deducts refunds, referral fees, FBA fulfillment fees, storage fees, advertising, and other charges before paying you.
• DD+7 delays payment availability. Under delivery-date-based reserve policies, Amazon typically holds order proceeds until seven days after delivery. Under accrual accounting, the sale can already be recognized on an Invoice while the amount remains open in A/R; the later release is recorded as the Invoice payment.
• Settlement periods cross calendar months. A payout can include money released from older transactions while excluding newer sales that remain deferred.
• Marketplace facilitator tax is withheld. Amazon-collected tax can appear in gross report activity with an offsetting Amazon-obligated withholding. It should not become extra revenue or an unpaid sales-tax balance in QuickBooks.
• Other reserves can remain. Claims, chargebacks, account reviews, failed disbursements, and similar exceptions can create a balance beyond ordinary deferred transactions.

Booking the net deposit as “Amazon Sales” hides gross revenue and deductible costs. The clearing-account method preserves the detail while giving the bank feed one exact transfer to match.

---

Before You Start: Download the Two Amazon Reports

Use two reports because they answer different questions.

Report	Where to get it	What it proves
Settlement report	Seller Central → Payments → All Statements → Download	The beginning balance, released activity, reserves, and Disbursement amount for one payout
Date Range Transaction report	Seller Central → Payments → Reports Repository → Account type: All → Report type: Transaction	Transaction dates for Invoices and Bills, plus release and deduction dates for their later payments

Amazon’s April 2026 reporting update added deferred and released transactions to supported Date Range Transaction reports, indexed activity by posted date, and added Transaction Status and Transaction Release Date fields. The rollout and available dates vary by marketplace and account, so confirm your export contains those columns. See Amazon’s reporting announcement.

Also have these open:

• The bank deposit in QuickBooks Bank transactions.
• Your Amazon Balance register in QuickBooks.
• Open Invoices for your Amazon marketplace customer and open Bills for your Amazon vendor.
• The prior settlement’s ending balance, if this is not your first reconciliation.

---

Step 1: Create an Amazon Balance Clearing Account in QuickBooks

Intuit recommends using a Bank-type account for a general clearing account. In QuickBooks Online:

1. Open All apps → Accounting → Chart of accounts.
2. Select New account.
3. Choose Bank as the account type.
4. Name it Amazon Balance.
5. Leave the opening balance blank and save.

See Intuit’s current clearing-account setup instructions.

Use a separate clearing account for each Amazon marketplace or currency when payouts settle independently. For example, Amazon US and Amazon Canada should not share a balance if they pay different bank accounts or currencies.

Use a dedicated Amazon marketplace customer for sales and an Amazon vendor for fees. The flow is:

1. Sales post to Invoices and remain in A/R until Amazon releases the proceeds.
2. Fees post to Bills and remain in A/P until Amazon deducts them.
3. Receive Payments increase Amazon Balance, and Bill Payments decrease it.
4. The settlement payout transfers the remaining Amazon Balance to checking.

Under this model, ordinary DD+7 deferred sales are explained by open Invoices in A/R—not by pretending the money is already in Amazon Balance.

---

Step 2: Decide the Posting Date and Level of Detail

Choose the accounting treatment before entering transactions:

• Accrual basis: recognize revenue when your accounting policy says the goods were provided and the right to payment is established. That may be shipment or delivery depending on the facts and your policy; DD+7 only controls when Amazon releases cash.
• Cash basis: income is generally reported when payment is received or made available. Ask your accountant how Amazon’s restricted and released balances should be treated, and apply the method consistently.

Intuit summarizes revenue timing in its guide to when revenue is considered earned. Businesses that maintain inventory or need tax-basis reporting should also confirm their method with a tax professional.

Then choose the posting level:

• Individual orders: useful at low or moderate volume when order-level drill-down is worth the extra QuickBooks transactions.
• Daily summaries: usually better at scale. Group sales into daily Invoices by date and SKU, and group fees into daily Bills while keeping refunds, tax, and marketplace dimensions identifiable.
• Settlement summaries: compact and reconciliation-friendly, but less useful for daily reporting, A/R and A/P aging, and inventory detail.

Native QuickBooks forms are preferable when item, customer, inventory, or COGS detail matters. A carefully designed summary or journal-entry workflow can still be valid when an accountant approves it; “native transactions only” is a product and reporting choice, not a universal accounting rule.

For this DD+7 workflow, however, the payment timing determines the form. Intuit’s guidance says to use an Invoice when the customer pays later and then record a Receive payment against it. Intuit likewise says to use a Bill when an expense will be paid later and to use Pay bills to close it. A Sales Receipt, Check, or Expense records an immediate-payment event and therefore collapses the accrual and payment dates into one transaction. See Intuit’s instructions for recording Invoice payments and its explanation of Bills versus Checks and Expenses.

---

Step 3: Map Amazon Activity to QuickBooks

Create a consistent mapping before posting the report.

Amazon activity	Form on the transaction/recognition date	Form when Amazon releases or deducts the amount	Amazon Balance effect at payment
Product, shipping, and gift-wrap sales	Invoice to the Amazon marketplace customer	Receive payment, deposited to Amazon Balance	Increase
Referral, FBA, storage, and advertising fees	Bill from the Amazon vendor	Bill Payment from Amazon Balance	Decrease
Customer refund	Credit Memo against an open Invoice, or Refund Receipt when cash from a paid sale is returned	Record the Amazon cash deduction from Amazon Balance when processed	Usually decrease
Refunded Amazon fee	Vendor Credit against the related open Bill, or a credit against a previously paid fee	Apply the credit to the Bill Payment or record the returned cash in Amazon Balance	Usually increase or reduces a later decrease
Inventory reimbursement or adjustment	Invoice or accountant-approved adjustment	Receive payment into Amazon Balance when released	Usually increase
Marketplace facilitator tax	Tax line on the Invoice plus an approved withholding Bill or offset	Bill Payment or approved cash offset from Amazon Balance when withheld	Net zero across the configured tax mapping
Settlement payout	No new income or expense form	Transfer from Amazon Balance to business checking	Decrease

Do not silently net all fees against revenue. Mapping referral fees, fulfillment, storage, advertising, reimbursements, and refund administration fees separately makes the profit and loss statement usable.

Do not substitute Sales Receipts for the sales Invoices or Checks/Expenses for the fee Bills merely to make the settlement tie. Those cash-style forms would mark the activity as paid too early and remove the A/R and A/P trail needed to explain DD+7 timing.

For a fee-specific account map, see how to handle Amazon FBA fees when reconciling in QuickBooks.

---

Step 4: Post Accrual Documents, Then Their Payments

Using the posting dates and detail level approved for your books:

On the Transaction or Recognition Date

1. Create Invoices for gross sales. The Invoices recognize revenue and remain open in A/R; they do not deposit money into Amazon Balance.
2. Create Bills for Amazon fees. The Bills recognize expense and remain open in A/P; they do not withdraw money from Amazon Balance.
3. Create Credit Memos, Refund Receipts, Vendor Credits, and other adjustments according to whether the original Invoice or Bill is still open or has already been paid.
4. Record reimbursements, chargebacks, advertising, tax withholding, and other adjustments separately under the approved mapping.
5. Confirm that every transaction-date report row is represented once and only once.

When Amazon Releases or Deducts the Amount

1. For released sale proceeds, create a Receive Payment against the related Invoice and set Deposit to to Amazon Balance.
2. For fees deducted by Amazon, use Pay bills, select Amazon Balance as the payment account, and apply the Bill Payment to the related Bills.
3. Record the cash side of refunds, fee credits, reimbursements, and withholding only when Amazon processes those amounts.
4. Use partial payments when Amazon releases or deducts only part of a summary document.
5. Confirm that each release or deduction closes the intended A/R or A/P balance without creating a second sale or expense.

For supported post-April-2026 reports, treat Deferred and Released as lifecycle states, not as two separate sales. Create the Invoice once on the recognition date. While the transaction is Deferred, leave the Invoice open; when it becomes Released, record the Receive Payment against that same Invoice.

Sales vs. Cash Events

The clearing account separates the economic event from the cash event:

• An Invoice changes revenue, inventory, and A/R; a Bill changes expense and A/P.
• A Receive Payment or Bill Payment moves the released or deducted amount into or out of Amazon Balance and closes the corresponding receivable or payable.
• A payout moves money from Amazon Balance to checking.
• Releasing a deferred transaction creates the Invoice payment, not a second Invoice or sale.

Assume your accrual policy recognizes a $100 sale on July 1. Create a $100 Invoice: revenue increases and A/R holds the unpaid amount. Create a $15 referral-fee Bill and a $5 FBA-fee Bill: fee expense increases and A/P holds the $20 owed. While Amazon keeps the sale Deferred under DD+7, Amazon Balance remains unchanged; the $100 is an open Invoice and the $20 is in open Bills.

When Amazon releases the $100, record a $100 Receive Payment to Amazon Balance. When Amazon deducts the $20 of fees, record $20 of Bill Payments from Amazon Balance. Amazon Balance now contains the $80 net cash position. When Amazon disburses that $80, transfer it to checking. Revenue and fee expense were recognized on their original dates, while each cash event was recorded later exactly once.

Handle Settlement Boundary Days

Amazon can close a settlement partway through a calendar day. If one Receive Payment or Bill Payment combines rows from the closing and opening statements, the closed statement will not tie exactly. Split payment batches by Settlement ID or payout boundary; if necessary, also split the related daily Invoice or Bill summary so the payments can be applied cleanly.

---

Step 5: Record the Payout as a Transfer and Match the Bank Feed

When the settlement closes:

1. Confirm the settlement report’s Disbursement amount.
2. In QuickBooks, select + Create → Transfer.
3. Set Transfer funds from to Amazon Balance.
4. Set Transfer funds to to the checking account that received the ACH deposit.
5. Enter the Disbursement amount and the transfer date, then save.
6. Open Bank transactions, find the Amazon deposit, and choose Match to the transfer.

Do not add or categorize the bank-feed deposit as Amazon income after creating the transfer. Doing both duplicates the cash and revenue.

If the bank deposit does not equal Amazon’s Disbursement amount, first check whether the payment is still processing. Amazon says a completed payout can take up to five business days to appear. Use the Trace ID or contact the bank before forcing the difference into a QuickBooks account.

---

Step 6: Tie Out A/R, A/P, and Amazon Balance

Reconcile three linked balances: Amazon A/R, Amazon A/P, and Amazon Balance.

First prove the open accrual documents:

Subledger roll-forward	Formula
Ending Amazon A/R	Beginning A/R + Invoices − Credit Memos − Receive Payments
Ending Amazon A/P	Beginning A/P + Bills − Vendor Credits − Bill Payments

Open Amazon A/R should be supported primarily by DD+7 deferred sales and other released-but-unpaid exceptions. Open Amazon A/P should be supported by fees incurred but not yet deducted, plus documented credits or timing items.

Then use this cash roll-forward for the clearing account:

Amazon Balance roll-forward	Amount
Beginning Amazon Balance	A
Plus Receive Payments and other cash credits posted to Amazon Balance	+ B
Less Bill Payments, processed refunds, tax withholding, and other cash charges	− C
Less payout transfers to checking	− D
Expected ending Amazon Balance	A + B − C − D

The expected ending balance should be explainable by:

• Released Invoice payments scheduled for a later disbursement.
• Account-level reserves applied after payment release.
• Cash activity posted after the statement closed.
• Failed transfers, claims, chargebacks, or other documented exceptions.

Ordinary DD+7 deferred proceeds should normally remain in open A/R until the Receive Payment is recorded; they should not already be sitting in Amazon Balance. The clearing account does not always end at zero, but it should end at a known, supportable cash balance.

Reconciliation Checklist

Check	Expected result
Settlement Disbursement amount vs. bank deposit	Exact match after bank processing
Settlement payout vs. QuickBooks transfer	Exact match
Date Range Transaction report vs. Invoices, Bills, and credits	Every transaction-date row represented once
Deferred sales vs. open Amazon Invoices	Open A/R supported by unreleased or unpaid proceeds
Deducted fees vs. Bills and Bill Payments	Expense recorded once and the correct Bills closed
Released proceeds vs. Receive Payments	Payment applied once to the correct Invoices
Amazon Balance ending balance vs. released cash and reserves	Fully explained cash difference
Bank-feed treatment	Deposit matched to transfer, not added as income
Marketplace tax	Collected and withheld amounts offset under the approved mapping

---

Troubleshooting Differences

Difference pattern	Likely cause	What to check
Difference equals the full payout	Missing transfer or bank deposit added as income	Transfer register and Bank transactions match
Difference equals one order or refund	Missing or duplicated Invoice, credit, or Receive Payment	Order ID, refund ID, release date, and linked QuickBooks forms
Difference equals Amazon-collected tax	Tax withholding omitted or posted to revenue	Marketplace facilitator tax mapping
Difference equals a recognizable fee	Missing Bill, Bill Payment, or Vendor Credit	Fee row, deduction date, vendor activity, and A/P detail
Difference remains in A/R and moves to the next period	DD+7 release or payment timing	Open Invoice, Transaction Status, Release Date, and Settlement ID
Difference appears only on one calendar day	Payment batch crossed a settlement close	Split Receive Payments and Bill Payments by statement boundary
Released sale still appears in A/R	Receive Payment missing or not applied to the Invoice	Customer payment and linked Invoice
Bank deposit differs from Disbursement amount	Transfer still processing or bank/payment exception	Payout status, Trace ID, and bank activity

If the difference changes when you rerun the Date Range Transaction report, compare report pulls. A row that was Deferred at month-end can appear as Released later. That change should close the existing Invoice through a Receive Payment; it should not create a second Invoice or sale.

---

Automating Amazon Settlement Reconciliation

Manual reconciliation is workable at low volume, but it becomes fragile when thousands of report rows, marketplace tax, deferred balances, and split settlement days must be handled repeatedly.

Entriwise connects Amazon Seller Central to QuickBooks Online and:

• Imports transaction and settlement activity automatically.
• Posts native Invoices and Bills on the transaction date, then links later Receive Payments and Bill Payments.
• Posts Credit Memos, Refund Receipts, Vendor Credits, and inventory-aware daily summaries as required by the underlying activity.
• Maps Amazon fees through QuickBooks Products and Services to accounts you control.
• Splits summaries at settlement boundaries.
• Maintains the Amazon A/R, A/P, and Amazon Balance roll-forwards so the payout can be matched as a transfer.

See the Amazon Seller Central QuickBooks Online integration for the automated workflow, or use the Amazon to QuickBooks Online setup guide for account mapping, inventory, COGS, and first-import preparation.

If you also sell through Shopify, Walmart, eBay, or TikTok Shop, use a separate clearing account per independently settled channel. The same gross-activity-plus-payout architecture applies without mixing channel balances.

---

Conclusion: Reconcile Activity to the Settlement, Then Match the Payout

The settlement’s Disbursement amount should match the bank deposit. The reconciliation work is proving how transaction-date Invoices and Bills became later Receive Payments and Bill Payments, how those cash events produced the net payout, and why any amount remains in A/R, A/P, or Amazon Balance afterward.

Set up the customer, vendor, and clearing account once; post each report row consistently; match payouts as transfers; and require every ending difference to have evidence. That turns “Amazon deposits never match my sales” into a repeatable close procedure without recording revenue or expense as though it were paid immediately.

---

Frequently Asked Questions

How do I reconcile Amazon settlements in QuickBooks Online?

Post Amazon sales as Invoices and fees as Bills on their accrual dates. When Amazon releases proceeds, record Receive Payments into Amazon Balance; when it deducts fees, record Bill Payments from Amazon Balance. Transfer the settlement’s Disbursement amount to checking, match the bank deposit, and reconcile open A/R, open A/P, and the remaining clearing balance.

Should an Amazon settlement match the bank deposit?

The settlement’s Disbursement amount should normally match the bank deposit after processing. Gross sales or date-range transaction totals will not match the deposit because the payout is net of refunds, fees, withholding, reserves, and carried balances.

What date should I use for Amazon sales in QuickBooks?

Use the date required by your accounting method and documented revenue-recognition policy. Under accrual accounting, that is when the goods are considered provided and the right to payment is established; it is not automatically the payout date or universally the ship date. Cash-basis treatment differs, so confirm it with your accountant.

How does Amazon DD+7 affect reconciliation?

DD+7 delays when order proceeds become available for payout. Under transaction-date accrual accounting, post the sale once as an Invoice while it is Deferred and leave it open in A/R. When Amazon releases the proceeds, record a Receive Payment against that Invoice and deposit it to Amazon Balance. The release is a payment event, not a second sale.

What is the best way to auto-import Amazon settlement data into QuickBooks?

Use an integration that imports transaction-date and settlement activity, preserves fee and item mappings, handles DD+7 through open Invoices and later Receive Payments, handles fees through Bills and later Bill Payments, and matches each payout through a clearing account. Entriwise posts native QuickBooks transactions and daily SKU-level summaries while keeping A/R, A/P, and the settlement roll-forward reconcilable.