The settlement report is the only document that tells you what Amazon actually did with your money. Most sellers never open it. The ones who do reconcile in minutes instead of arguing with their accountant for hours.
Your Seller Central sales dashboard is a marketing surface. It shows orders and a rolled-up sales figure. It does not show the fees, the refunds, the reserve, or the timing that turns "sales" into a bank deposit. The settlement report does. It is the ledger Amazon uses to calculate exactly what it pays you each cycle, and it is the only Amazon document that reconciles, to the penny, against the money that lands in your account.
If you book from the dashboard or from the deposit, you are guessing. If you book from the settlement report, you are reconciling. The search term "amazon seller central to quickbooks" gets around 260 searches a month and most of the traffic lands on tutorials that skip the settlement layer entirely. That is the layer that makes the numbers tie out.
In Seller Central, go to Payments, then the Reports Repository, and download the settlement report (sometimes labeled the "All Statements" view or the flat-file settlement report). Each report covers one disbursement cycle, typically every 14 days, ending when Amazon disburses available funds. The cycle rarely matches your calendar month, which is the first thing that breaks naive bookkeeping.
The report groups activity by transaction type. Here is what the common lines mean and where each one belongs on your books.
| SETTLEMENT LINE | WHAT IT REPRESENTS | BOOKS TREATMENT |
| Order / Product charges | Gross sales from orders | Revenue |
| Refund | Money returned to a buyer | Contra-revenue (reduces sales) |
| FBA fees | Pick, pack, weight handling | Operating expense (fulfillment) |
| Referral fee | Amazon's commission per sale | Operating expense (selling) |
| Storage fee | Monthly and long-term FBA storage | Operating expense |
| Advertising | Sponsored Products and related ad spend | Marketing expense |
| Reimbursement | Amazon repaying you for lost or damaged inventory | Other income or contra-COGS |
| Reserve / account-level reserve | Funds withheld this cycle | Balance-sheet asset, not P\&L |
| Transfer / disbursement | The payout to your bank | Moves Amazon balance to cash |
Read the report as two halves. The top half is everything that increased or decreased your Amazon balance during the cycle: sales up, fees and refunds and ads down. The bottom half is the reconciliation: beginning balance, plus the cycle's net activity, minus any reserve held, equals the amount transferred to your bank. When your books reproduce both halves, you are done.
Run the same five steps every cycle:
If the transfer line equals your bank deposit and your Amazon clearing account equals the live Seller Central balance, the cycle is reconciled. Every number has a home and nothing is double-counted.
Because the cycle straddles month-end, half of one settlement belongs to the closing month and half to the next. On accrual books you have to allocate sales and costs to the period in which they occurred, not the period in which Amazon paid. Done by hand, this means splitting a settlement report down the middle and re-totaling each half. It is tedious and error-prone, and it is the reason monthly Amazon P&Ls so often disagree with the tax return.
Transaction-level sync removes the split entirely. ConnectBooks pulls the settlement report line by line into QuickBooks Online, QuickBooks Desktop, or Xero, dates each transaction to when it actually happened, applies FIFO COGS per unit, and keeps the reserve on the balance sheet. The result is a settlement that reconciles automatically and a P&L that is already split to the correct month. See /integrations/amazon-accounting for the mapping.
| NEXT STEPReading settlement reports by hand does not scale past a few SKUs. ConnectBooks reconciles every cycle line by line, starting at $149/mo. See /pricing. |
It is the detailed statement Amazon issues each disbursement cycle, usually every 14 days, listing every transaction that changed your seller balance: sales, refunds, fees, advertising, reimbursements, and the reserve. It is the only Amazon document that reconciles exactly to the deposit that hits your bank, which makes it the source of truth for bookkeeping.
You can map each transaction type to a QuickBooks account and enter the totals manually, but this breaks down past a handful of SKUs and ignores the month-end split. A purpose-built integration syncs the report line by line, dates each transaction correctly, and posts it to the right accounts automatically, which is what ConnectBooks does for QuickBooks Online and Desktop.
The dashboard shows gross orders. The settlement report nets out fees, refunds, advertising, and the reserve, and it covers a payout cycle rather than a calendar period. The two will almost never match. Reconcile from the settlement report, not the dashboard.
Carry it as a balance-sheet asset. The reserve is money Amazon is withholding temporarily, still yours, scheduled to release in a later cycle. It is not revenue and not an expense, so it never touches your P&L. When it releases, it simply increases the amount Amazon transfers to your bank.
Every cycle, which means roughly every two weeks. Letting them pile up until year-end turns a quick reconciliation into a forensic project and leaves your monthly margins unreliable in the meantime. Automated sync reconciles each cycle as it posts, so there is nothing to catch up on.
Clean, accurate books make this manageable. Start a free trial of ConnectBooks to get settlement-level accuracy and real margin visibility for your ecommerce business. No credit card required.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
