Amazon settlement reconciliation in QuickBooks Online for Canadian sellers

An Amazon bank deposit is the end of a settlement calculation, not a sales total. To keep Canadian Amazon books accurate, reconcile every settlement from its opening balance through orders, refunds, selling and FBA fees, reimbursements, reserves, tax lines and the final bank transfer.

Why an Amazon payout does not equal Amazon sales

Amazon collects cash from buyers, deducts or adds several kinds of activity, may hold part of the account balance in reserve, and transfers the remaining amount to the seller's bank. The deposit therefore answers a cash question: how much did Amazon disburse? It does not answer the income-statement question: how much did the business sell?

Amazon's Payments Dashboard separates Statement View, Transaction View, All Statements and disbursements. Amazon's own seller guidance describes the settlement calculation as the beginning balance plus sales, less expenses and refunds, with an amount sometimes retained in reserve. The reserve carried forward becomes part of the next settlement period.

That means a clean reconciliation must preserve both views:

The reports to save for every close

Use a closed settlement report as the control document for each disbursement. Amazon says the All Statements area provides downloadable XML, flat-file and Flat File V2 formats; Transaction View is useful for tracing a specific order, refund, charge or credit. Keep the report that actually supports the payout rather than relying only on a dashboard total that changes as new activity posts.

• Closed settlement statement: settlement ID, opening balance, transaction totals, reserve movements and net disbursement.
• Flat File V2 or equivalent detail: the order, refund, fee, adjustment and other lines behind the settlement.
• Transaction View evidence: detail for unusual reimbursements, chargebacks, service fees or seller repayments.
• Disbursement record: status, amount, initiation date and trace information when available.
• Bank statement: the independent evidence that the transfer arrived in the intended account.
• QuickBooks reports: Amazon clearing detail, mapped revenue and expense accounts, bank register and reconciliation report.

The Canada Revenue Agency requires records that support business transactions and tax filings. Save source reports, mapping decisions and month-end exception notes in a consistent folder structure so the accounting result can be reproduced later.

Set up the chart of accounts before importing Amazon data

A useful structure separates the activity that belongs on the profit and loss statement from balances that belong on the balance sheet. The exact names can differ, but a Canadian Amazon workflow commonly needs:

• Amazon clearing: a balance-sheet account representing money moving through the Amazon seller account.
• Amazon sales and shipping income: gross commercial activity, separated only as far as management and tax reporting require.
• Sales returns and discounts: mapped consistently rather than netted invisibly against deposits.
• GST/HST and other tax accounts: based on who collected the tax and who is responsible for remitting it.
• Amazon referral and selling fees: marketplace costs distinct from fulfilment and advertising.
• FBA fulfilment, storage and related fees: kept visible when they are useful for margin analysis.
• Advertising and subscription costs: mapped according to the invoices and settlement detail.
• Amazon reserve or held funds: tracked as an Amazon balance, not treated as an expense.
• Inventory and cost of goods sold: maintained through the approved inventory workflow, not inferred from the payout.

Amazon settlement reconciliation: the seven-step workflow

1. Choose a clean opening date

Start at the beginning of a closed settlement period. Document the Amazon balance, any reserve carried forward, pending disbursements and the Amazon clearing balance already in QuickBooks. Beginning mid-period without an opening entry is one of the fastest ways to create a permanent difference.

2. Confirm the underlying transactions before the bank feed

Intuit's current Amazon Connector instructions tell users to review and confirm individual transactions before working with the related bank deposit. Confirm sales, refunds, fees and adjustments in the integration transaction area first. If a line needs a customer, product or account mapping, resolve it there rather than using the bank deposit to bypass the missing detail.

3. Rebuild the settlement total

Group the settlement lines into controlled categories and prove that the arithmetic reaches the stated payout. Keep reserve movements and prior balances visible. A reconciliation that reaches the right deposit only because unrelated categories were netted together is not finished.

4. Record the payout against Amazon clearing

The payout moves value from Amazon clearing to the bank account. If the underlying orders are already recorded, this transfer has no new revenue. Intuit says the Amazon connector creates a deposit from the confirmed payout activity and links the included orders, refunds and fees together.

5. Match the downloaded bank deposit

In the QuickBooks bank feed, use Match against the payout deposit created by the connector or approved manual workflow. Intuit explicitly warns not to manually add the Amazon deposit after the app transactions have been recorded. Adding it instead of matching can duplicate income or leave Amazon clearing overstated.

6. Reconcile the Amazon clearing balance

After the bank match, compare the ending Amazon clearing balance with the seller account's unsettled activity and held funds. A non-zero balance can be valid when it is explained by reserves, deferred transactions or a payout in transit. An old unexplained balance is an exception to investigate, not an amount to write off automatically.

7. Reconcile the bank account separately

Amazon settlement reconciliation proves how the platform activity became a disbursement. Bank reconciliation then proves that the disbursement and every other bank transaction agree with the statement. QuickBooks' own reconciliation guidance says the final difference should be CA $0.00.

Worked example: from Amazon activity to the bank

Assume a closed Amazon settlement contains the following simplified CAD activity. The tax line is intentionally shown separately because its accounting treatment must be confirmed from the seller's actual tax responsibilities.

• Beginning reserve released: $1,000
• Product sales: $20,000
• Shipping income: $500
• Tax-related credits: $1,300
• Customer refunds: ($1,200)
• Referral and selling fees: ($3,000)
• FBA and fulfilment fees: ($2,000)
• Reimbursement or adjustment: $200
• Current reserve held: ($1,500)

The income statement still shows the approved gross sales, returns and expense categories. The balance sheet shows any reserve or unsettled Amazon funds. The tax-related credit is mapped only after confirming whether it represents tax the seller collected, tax Amazon collected as a platform operator, or another tax adjustment. Inventory and cost of goods sold are supported independently.

How to handle common Amazon settlement lines

Reserves and deferred transactions

A reserve is money still held within the Amazon account. It changes how much cash is available for payout, but it is not automatically an expense. When a prior reserve is released, that release is not new revenue either; it is a movement of an existing balance. Tie current and previous reserve amounts across consecutive settlements.

Refunds and refund-related fees

Record the customer refund in the period supported by the business's accounting policy, then map any retained or returned Amazon fee separately. A refund can appear in a later settlement than the original sale, so a settlement-period report and a sales-period report can legitimately differ.

Reimbursements and adjustments

Do not map every Amazon credit to sales. A reimbursement may relate to lost or damaged inventory, an earlier fee, shipping or another adjustment. Review the transaction description and supporting report, then use the account that reflects the economic event. Keep material unresolved items on an exception list.

Advertising, subscriptions and service charges

Some Amazon costs can be deducted directly from the seller balance while others are invoiced or charged elsewhere. Confirm that a cost appears once and only once. If an advertising invoice is paid outside the settlement, it should not also be booked from a summary estimate.

Seller repayments and negative settlements

When fees, refunds or charges exceed available sales proceeds, the seller can owe Amazon. Treat the payment from the bank as settlement of the Amazon clearing balance, not as a generic expense. The underlying fee and refund lines determine the income-statement categories.

GST/HST: do not infer the liability from the deposit

Canadian marketplace tax rules depend on the seller, customer, goods, location, registration status and the role of the platform. CRA guidance says digital-economy rules can impose collection obligations on distribution platform operators for certain supplies. That does not mean every Amazon tax line has the same treatment, or that a Canadian seller can ignore its own GST/HST registration and reporting obligations.

For each Amazon marketplace and transaction type, document:

• Who is legally making the supply.
• Who collected the GST/HST from the customer.
• Whether Amazon remitted the amount as a platform operator or credited it to the seller.
• Which report and tax code support the QuickBooks entry.
• How refunds and marketplace tax adjustments reverse the original treatment.

Do not calculate GST/HST as a percentage of the net Amazon deposit. Fees, reserves, refunds and timing make the deposit an unreliable tax base. Have a qualified accountant approve the mapping for the business's actual registrations and marketplaces.

Common failure modes

• Booking the deposit as sales. This hides fees and can duplicate revenue.
• Importing the bank feed first. The deposit is added before the Amazon detail creates the transaction it should match.
• Netting all fees together. Referral, FBA, storage, advertising and other costs become impossible to review.
• Expensing the reserve. Held cash is mistaken for a cost instead of an Amazon balance.
• Treating every credit as revenue. Reimbursements and reversals are posted without tracing their source.
• Using the payout to calculate GST/HST. Net cash is confused with taxable consideration.
• Assuming the connector manages inventory. Settlement reconciliation is treated as an inventory subledger.
• Forcing clearing to zero. Valid unsettled activity is removed, or an unexplained difference is buried in an expense account.

Month-end checklist for Amazon sellers

1. Download every closed settlement statement for the month and identify payouts in transit.
2. Confirm all connector transactions and resolve unmapped lines before reviewing the bank feed.
3. Prove each payout from opening balance through sales, refunds, fees, adjustments and reserves.
4. Match every Amazon bank deposit or repayment to the existing QuickBooks transaction.
5. Tie Amazon clearing to unsettled activity, deferred transactions and held reserves.
6. Review reimbursements, chargebacks, advertising and unusual fees individually.
7. Verify GST/HST mappings against the seller's approved tax treatment.
8. Reconcile the bank statement to CA $0.00 and save the reconciliation report.
9. Reconcile inventory quantities and cost of goods sold through the separate inventory process.
10. Archive the settlement files, exception list, mapping changes and reviewer sign-off.

This process fits inside the broader e-commerce month-end close checklist. For the mechanics of proving the final cash account, see bank reconciliation explained. If you also sell through Shopify, compare the Shopify and QuickBooks reconciliation workflow before sharing clearing accounts or connector rules across platforms.

What should be automated

A stable system can import Amazon transactions, preserve settlement IDs, apply approved mappings, build payout deposits, match exact bank amounts and route unusual lines to review. It should also flag duplicate imports, missing settlements, old clearing balances and reserve movements that do not carry forward.

Automation should not decide a new tax treatment, guess what an ambiguous reimbursement means, create inventory costs from a payout or write off a difference merely to reach zero. Validate one complete settlement and one month-end close before enabling automatic confirmation.

If you want that workflow mapped and tested, see LZ Financial's e-commerce bookkeeping automation service or request a free assessment.

Official references

• Amazon: How Amazon seller payments work
• Amazon Seller Central: How to download payment reports
• Amazon Seller University: Payments Dashboard and payment reports
• QuickBooks Canada: Connect Amazon Seller Central to QuickBooks
• QuickBooks Canada: New e-commerce connectors and payout reconciliation
• QuickBooks Canada: Reconcile an account in QuickBooks Online
• Canada Revenue Agency: GST/HST for digital-economy businesses
• Canada Revenue Agency: Keeping records

Reviewed September 21, 2026. This guide provides general educational information, not accounting, legal or tax advice. Amazon and QuickBooks features can change. Confirm current platform behaviour and have a qualified professional approve account mappings, inventory treatment and GST/HST filings for your business.

Frequently asked questions

How do I reconcile an Amazon payout in QuickBooks Online?

Review and confirm the Amazon sales, refunds, fees and adjustments first; confirm the payout so QuickBooks creates the deposit; then match the downloaded bank transaction to that deposit. Do not add the bank deposit as new sales.

Why is my Amazon payout lower than my sales?

The payout can include refunds, referral and fulfilment fees, advertising or service charges, reserve movements, reimbursements, adjustments and prior balances. It is net cash from a settlement period, not gross sales for the same dates.

Should the Amazon clearing account be zero?

Not always. It can legitimately equal reserves, deferred transactions, unsettled activity or a payout still in transit. It should be fully explained and supported, not forced to zero.

Does Amazon settlement reconciliation also reconcile inventory?

No. It reconciles the payments account and bank transfer. Inventory quantities, landed cost and cost of goods sold need a separate inventory control and month-end review.