How to Reconcile Amazon Seller Settlements in QuickBooks
Amazon payouts can look simple on the bank feed, but they rarely are. A single deposit may include gross sales, refunds, FBA fees, storage charges, chargebacks, and reserve holds, all packed into one net number.
That is where many books go off track. If you post only the deposit amount, your revenue gets understated, your fees disappear into the background, and your reports stop matching reality.
The fix is a repeatable reconciliation process that ties each Amazon settlement to QuickBooks Online with clean detail. Once that workflow is in place, month-end closes get faster and far less painful.
Key Takeaways
- Amazon deposits should be matched to a clearing account , not booked as income on their own.
- Record gross sales, refunds, fees, and reserves separately so your profit margins stay accurate.
- Reconcile each settlement batch back to the Amazon report, then match the net payout to the bank.
- Timing differences, prior-period adjustments, and chargebacks need their own treatment, not guesswork.
- The clearing account should return to zero when the settlement is fully posted and matched.
What an Amazon settlement really contains
An Amazon settlement report is more than a payout notice. It is a summary of the activity Amazon processed during a settlement period, along with the money it kept, refunded, or withheld before sending the final deposit.
That means the bank deposit is only the last line of the story. The real accounting work happens in the details.
| Settlement item | QuickBooks treatment | Why it matters |
|---|---|---|
| Gross product sales | Record as sales income | Keeps revenue complete |
| Customer refunds | Reduce sales or post to a returns account | Prevents overstated income |
| Amazon referral and FBA fees | Post to expense accounts | Shows true selling cost |
| Shipping income or credits | Record separately if applicable | Helps compare shipping performance |
| Reserve or holdback | Keep in a clearing or liability account | Tracks money not yet paid out |
| Chargebacks or claims | Post when reported | Keeps the period accurate |
The main idea is simple. Amazon's net deposit is not your revenue. It is your revenue after Amazon has taken its share and processed adjustments.
If you record only the deposit, the books may balance to the bank, but they won't tell you what actually happened.
A clean QuickBooks Online workflow for Amazon settlements
QuickBooks Online works well for Amazon sellers when you use a clearing account. That account acts like a waiting room. Amazon sales flow in, fees and refunds flow out, and the net deposit leaves only when the settlement is complete.
QuickBooks Desktop can follow the same logic, but the screens and bank-feed workflow feel different. The accounting idea stays the same.
Start with a dedicated clearing account named something like "Amazon Clearing" or "Amazon Settlement Clearing." Then use the settlement report to build the accounting entry.
- Download the settlement report from Amazon Seller Central.
Use the settlement period that matches the deposit. Save the report before you post anything. - Summarize the report by category.
Split gross sales, refunds, Amazon fees, shipping income, reimbursements, and reserves into separate lines. Do not combine them into one number. - Record the settlement in QuickBooks Online.
Use a journal entry, sales receipt, or import tool, depending on your process. Post gross sales to income, refunds to a contra-income account or returns account, and fees to expense accounts. - Use the clearing account for the net settlement.
The Amazon deposit should clear against the clearing account. After that, the balance should drop to zero or nearly zero once all items from the settlement are booked. - Match the bank deposit to the clearing entry.
In the bank feed, match the Amazon payout to the entry that represents the settlement. If Amazon combines multiple settlements into one deposit, match each one carefully. - Review the difference before you close the month.
Any leftover balance in the clearing account should point to a missing fee, unposted refund, reserve hold, or timing issue. Do not ignore it.
A simple example helps. Suppose Amazon reports $10,000 in gross sales, $1,200 in fees, $400 in refunds, and a $8,400 deposit. In QuickBooks, the books should show the full $10,000 of sales, the $1,200 fee expense, the $400 refund reduction, and the $8,400 bank deposit against the clearing account. That gives you the real margin picture.
The bank feed alone cannot do that for you. The settlement report does the heavy lifting.
How to handle timing differences, reserves, chargebacks, and missing transactions
Amazon rarely lines up with a calendar month in a perfect way. Sales may happen in one period, while the settlement deposit lands in another. Fees can post later. Refunds can show up after the original sale month has closed.
That is normal. The important part is to account for it consistently.
- Timing differences happen when a sale belongs to one period, but Amazon pays it in another. If you use accrual accounting, book the sale in the period it happened, then clear it when Amazon pays out. If you use cash basis reporting, keep the method consistent and understand that margin reporting will be less detailed.
- Reserve holds need special attention. Amazon may hold back a portion of funds for risk or dispute coverage. Keep the reserve in the clearing account or a separate liability account until Amazon releases it. When the reserve is paid out later, post the release against the same account so the history stays clean.
- Chargebacks and claims should hit the books when Amazon reports them. If a chargeback belongs to a prior month and your books are still open, post it to that period. If the books are closed, use a prior-period adjustment according to your accounting policy.
- Missing transactions usually mean one of three things, a sale was not included in the summary, a fee was overlooked, or a payout was split across multiple deposits. Compare the settlement report line by line to QuickBooks, then leave the balance in the clearing account until you find the mismatch.
When a settlement changes after the fact, resist the urge to force everything into the current month. A clean prior-period adjustment is better than burying an old problem inside a new deposit.
For sellers who also manage payroll, inventory, and tax filings, a reliable bookkeeping cadence matters even more. professional small business bookkeeping services can help keep the Amazon clearing account current alongside the rest of the books.
Keeping the reconciliation process under control each month
The easiest Amazon reconciliations come from routine, not heroics. If you wait three months, the settlement stack gets messy fast. Small differences turn into big detective jobs.
A monthly close works best when you treat Amazon like its own cash cycle. Download the reports at the same time each month, post the settlement entry, match the payout, then review the clearing account balance before you move on.
Also keep an eye on fee trends. Amazon referral fees, FBA fulfillment charges, storage costs, and reimbursements can shift without warning. If your fees rise and the books do not show it, your pricing decisions may be based on stale numbers.
Store each settlement report with the matching QuickBooks entry. That backup matters when you or your accountant need to trace a number months later. It also makes tax season easier, because the support is already organized.
If you work across multiple sales channels, set up the Amazon process separately from Shopify, Walmart, or direct sales. Blending channels into one lump deposit is one of the fastest ways to lose visibility.
Conclusion
Reconciling Amazon seller settlements in QuickBooks gets much easier when you stop treating the deposit as the full story. The books need to show gross sales, fees, refunds, reserves, and timing differences in separate places so the numbers stay useful.
A clearing account, a consistent monthly process, and careful handling of chargebacks and prior-period adjustments will keep the reconciliation tight. When the Amazon settlement report and the bank deposit both make sense, your profit margins and tax records do too.
