How do I reconcile Amazon FBA settlement reports with what shows in my bank account?
The deposit Amazon sends to your bank account is not your revenue. It is the net result of everything that happened during that settlement period: gross product sales, FBA fees, referral fees, refunds, reimbursements, advertising charges, storage fees, and sometimes a reserve holdback. Amazon bundles all of that together and sends you a single number. That number will almost never match what you see in your Seller Central sales dashboard.
This is where most Amazon sellers get confused. They see $8,000 in sales for the period but only $5,200 hits the bank. The difference is all the line items Amazon netted out before paying you. If you record $5,200 as revenue, you are understating your sales and missing thousands of dollars in deductible business expenses like FBA fulfillment fees, referral commissions, and storage costs. If you record $8,000 as revenue but don’t account for the fees separately, your profit and loss statement won’t reflect reality either.
The right approach is to break each settlement into its components. Download the settlement report from Seller Central and you will see every transaction that made up the deposit. Gross sales go to revenue. Each fee category goes to its own expense account. Refunds reduce revenue. Reimbursements for lost or damaged inventory get recorded separately. The net of all those entries should equal the bank deposit exactly.
Doing this manually works when you have a handful of settlements per month. Once you scale past a few hundred orders, manual reconciliation becomes painfully slow and error-prone. A single miscategorized line can throw off your entire reconciliation. Tools like A2X or Webgility connect to your Amazon account and your accounting software, then automatically parse each settlement report into a summary journal entry with the correct accounts mapped. The journal entry debits your bank account for the net deposit and breaks out gross revenue, fees, refunds, and other components into their proper accounts.
If you use QuickBooks Online, A2X integrates directly and posts these entries for you. You still need to review them, but the heavy lifting of parsing hundreds of individual transactions into clean categories is handled. The settlement total in QuickBooks will match your bank deposit, and your income statement will show real gross revenue alongside real fee expenses.
One thing to watch for is reserve holds. Amazon sometimes withholds a portion of your settlement as a reserve, especially for newer accounts or during high-return periods. That money hasn’t left Amazon yet, so it shouldn’t show as a deposit. It needs to sit in a receivable or clearing account until Amazon actually releases it. Missing this creates a reconciliation gap that is hard to track down later.
Getting this right from the start saves you from a painful catch-up bookkeeping project down the road. Many Amazon sellers run for a year or two recording just the net deposits as income and then discover at tax time that their books are essentially useless for understanding profitability or filing accurate returns.
If you sell on Amazon and want your books to reflect what is actually happening in your business, proper settlement reconciliation is not optional. Our bilingual bookkeeping services help e-commerce sellers in Central Florida and beyond set up the right processes so every settlement period closes clean and your numbers tell you the truth about your margins.
Central Florida's Trusted Bookkeeping Firm
Start Here:
A 30-Minute Consultation
Tell us about your business and what's going on with your books. We'll figure out exactly what you need, and give you a straightforward quote.
More Questions
What changes in my bookkeeping when my salon switches from employee stylists to booth renters?
Your revenue reclassifies from service income to rental income, payroll obligations go away entirely, and your expense structure shifts. You'll issue 1099-NEC forms instead of W-2s and need to update your chart of accounts to reflect the new business model.
Read answerHow do I stop QuickBooks bank feeds from creating duplicate transactions?
Duplicates happen when you manually enter a transaction and then add the same one again from the bank feed instead of matching it. The fix is picking one workflow and sticking to it.
Read answerWhat's the best way to record monthly inventory adjustments in QuickBooks Online?
Use the Adjust Quantity feature under Products & Services in QBO. Enter your physical count, and QuickBooks calculates the variance automatically and posts it to an expense account like Inventory Shrinkage.
Read answerHow do I account for tips as a liability until they're paid out to employees?
Create a Tips Payable liability account and credit it every time tips are collected. When tips are disbursed through payroll, debit Tips Payable to clear the balance. Florida allows passing credit card processing fees on tips to employees, but this requires careful tracking.
Read answerWhat bookkeeping does a medical practice need that other small businesses don't?
The biggest difference is how revenue works. Medical practices don't get paid at the point of service. They bill insurance, wait for reimbursement, track contractual adjustments, and manage patient balances, all of which require specialized accounts receivable tracking that most small businesses never deal with.
Read answerHow do I record franchise territory rights as an asset and amortize them over time?
Record the initial franchise fee as an intangible asset called Franchise Rights. Then amortize it using straight-line amortization over the life of your franchise agreement, which is typically 10 to 20 years.
Read answer

