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
How do I set up financial reporting that my investors or lenders can actually trust and use?
Trustworthy financial reports start with clean, consistent bookkeeping done on a monthly schedule using accrual basis accounting. Your P&L, Balance Sheet, and Cash Flow Statement all need to tie together and follow the same structure every month.
Read answerWhat's the best way for a landscaping company to track materials and labor per job?
Code every material purchase and labor hour to a specific job so you can compare actual costs to your estimate. Without job-level tracking, you're guessing at which jobs make money and which ones quietly lose it.
Read answerHow do I track daily cash sales and deposits when my restaurant handles a lot of cash?
Use a daily cash reconciliation sheet that calculates expected cash on hand from your POS report, then compare it to your actual count. Record any over/short amount, deposit daily, and match your deposits to the reconciliation.
Read answerWhat are the most common QuickBooks mistakes that create cash flow blind spots?
The biggest blind spots come from not reconciling bank accounts monthly, letting QuickBooks auto-categorize without review, and recording owner draws as expenses. These mistakes make your reports unreliable and hide your true cash position.
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 answerWhat's the best way to connect Shopify to QuickBooks Online without double-counting sales?
Skip the native Shopify-QBO sync. Use a summarization tool like A2X or Klayena that posts daily sales summaries as clean journal entries, breaking out gross sales, discounts, refunds, shipping, taxes, and fees properly.
Read answer

