How to Reconcile Amazon Payouts to QuickBooks Online

Reconciling an Amazon payout to QuickBooks Online comes down to one move: stop treating the deposit as revenue. Pull the settlement report for the exact period the deposit covers, post the gross activity inside that report to a clearing account, then let the bank deposit clear the account back to zero. The deposit is a net number sitting at the end of a long subtraction. Your books need the whole subtraction, line by line, or your revenue, your fee expense, and your margin will all be wrong at the same time.

Why the deposit is never the same number as your sales

Amazon does not send you your sales. It sends you what is left after it subtracts everything it is owed and holds back whatever it has decided to hold back. A settlement covers a fixed window, commonly around two weeks, and inside that window Amazon nets product sales against refunds, referral fees, fulfillment charges, storage costs, advertising spend, and any movement in your reserve. What hits the bank is the remainder.

Book that remainder as sales and three things break at once. Revenue is understated by the entire amount of the fees. Fee expense does not appear anywhere in the profit and loss, so gross margin is fiction. Refunds vanish, which means the returns rate never shows up in the numbers you use to price and reorder.

Step 1: Pull the settlement report that matches the deposit

In Seller Central, open Payments, then the Reports Repository, and select the settlement whose date range covers the deposit. Download two versions. The summary gives you grouped totals you can eyeball. The flat file gives you every transaction line, which is what you need the first time you build the process and every time something stops tying out. Amazon publishes its own reference for settlement reports, and reading it once will save you an afternoon later, because the column names are not self explanatory.

Match on the settlement ID, not the date. Deposits usually land a day or two after a settlement closes. If you run more than one account or more than one currency, sooner or later you will pair the wrong report with the wrong deposit. The settlement ID is the only field that cannot be misread.

Step 2: Name every component inside the settlement

Component	What it is	Where it belongs
Product sales	Gross order value before anything is deducted	Revenue
Shipping credits	What buyers paid toward delivery	Revenue, usually its own account
Promotional rebates	Coupon funding and discounts you agreed to	Contra revenue
Refunds	Returned order value, plus fees credited back to you	Contra revenue
Referral fees	Amazon’s commission on each sale	Cost of sales or selling expense
FBA fulfillment fees	Pick, pack, and ship charges on FBA orders	Cost of sales
Storage and inventory fees	Monthly storage, aged inventory surcharges, removals	Operating expense
Advertising and service charges	Sponsored placements and account level services	Marketing expense
Reserve movement	Funds withheld and not paid out this cycle	Asset, a receivable from the marketplace
Prior period adjustments	Corrections Amazon applied against an earlier settlement	Back to the original account, or a review account

Fee schedules change, and which categories appear on your statement depends on the programs you are enrolled in. Read the amounts off your own report. Do not assume a rate you remember from last year.

Step 3: Open a clearing account

Create an account in QuickBooks Online called something like Amazon Clearing. Bank type works and makes matching easier, though other current asset is also defensible. Nothing from Amazon touches your operating bank account directly in the ledger. The settlement journal posts into clearing, the deposit posts out of it, and the balance left behind is real information: it is money earned and not yet received.

It is also a fast error detector. A clearing account that drifts month after month means a settlement was posted twice, a deposit went straight to sales, or a period was skipped.

Step 4: Post the settlement as one gross entry

The figures below are invented. I made them up to show the arithmetic. They are not taken from any real account, and they are not drawn from Amazon’s published fee schedule, so do not read any rate or ratio into them. Use your own report for real amounts.

A made up settlement, period ending August 14

Line	Amount
Product sales	84,000.00
Shipping credits	3,200.00
Promotional rebates	(1,900.00)
Refunds	(5,400.00)
Referral fees	(12,600.00)
FBA fulfillment fees	(9,800.00)
Storage and inventory fees	(1,450.00)
Advertising and service charges	(4,000.00)
Increase in reserved balance	(6,050.00)
Prior period adjustment	250.00
Net deposit	46,250.00

The journal entry

Account	Debit	Credit
Amazon Clearing	46,250.00
Refunds and returns	5,400.00
Promotional rebates	1,900.00
Referral fees	12,600.00
FBA fulfillment fees	9,800.00
Storage and inventory fees	1,450.00
Advertising	4,000.00
Amazon reserve receivable	6,050.00
Product sales		84,000.00
Shipping income		3,200.00
Settlement adjustments		250.00
Total	87,450.00	87,450.00

Debits and credits both total 87,450.00, and the clearing account line equals the deposit. Notice what this entry does not include: cost of goods sold. The settlement tells you nothing about what your units cost you. COGS is a separate posting driven by units shipped and your inventory valuation method, and it is the part sellers most often skip.

Step 5: Match the bank deposit

When 46,250.00 arrives in the operating account, record it as a transfer from Amazon Clearing. Do not categorize it to income. Watch for an old bank rule that routes Amazon deposits to a sales account, because it will silently undo everything you just did.

Step 6: Prove the reconciliation ties out

Three checks, in this order.

1. Clearing account nets to zero. Every settlement you have posted and received should leave no balance behind. Anything remaining should be traceable to a settlement that closed but has not yet been deposited.
2. Gross revenue agrees to the reports. Add the product sales lines across every settlement in the period and compare against the revenue account total. A difference means a missing settlement or a duplicate.
3. Fee accounts agree line for line. Referral fees in the ledger should match referral fees on the reports. If they do not, you have merged two categories somewhere.

Only after those three agree is it worth looking at margin. Doing it in the other order produces confident conclusions from broken data.

The settlement window does not respect your month end

Settlement periods run on their own cycle, so one of them will nearly always straddle the last day of the month. You have three workable options. Split the settlement using the flat file, allocating each transaction to the month its date falls in, which is the most accurate and the most work. Accrue an estimate for the open portion and reverse it in the following period. Or post each settlement entirely into the month it closes, and accept a consistent lag.

Any of the three can be defended if you apply it the same way every month and document it. The IRS discusses accounting periods and methods in Publication 538, and the general principle that matters here is consistency. If you are choosing a method for the first time, or changing one, that is a conversation for your CPA and not something to settle from a blog post. Sales tax has its own rules, which vary by state and change often, so check with your state’s department of revenue. The SBA keeps a plain language overview of managing business finances if you are building this process alone.

When the manual method stops holding up

One marketplace and two settlements a month is a spreadsheet job. Five marketplaces, a few thousand SKUs, and returns crossing period boundaries is not, and the failure mode is not arithmetic. It is that summary level entries tell you the account was profitable without telling you which products carried it. Sellers at that stage generally move to tools that break the settlement out by SKU before it reaches the ledger, so cost of goods lands against individual products rather than in one monthly lump.

The short version

• Match the report to the deposit by settlement ID.
• Post gross, never net.
• Route everything through a clearing account.
• Treat reserve movement as an asset, not a fee.
• Book COGS separately. The settlement will never give it to you.
• Pick a cutoff method and keep using it.