You pull up your bank account and see a deposit from Amazon for $14,327.52. Your sales dashboard says you sold $19,840 worth of product that pay period. The gap between those two numbers is not a mistake, it is the whole story of your business, and if you cannot explain it, your books are wrong. Amazon settlement report reconciliation is the process of matching every dollar Amazon deposits into your bank account back to the underlying sales, refunds, fees, and advertising charges that produced it, and it is one of the most misunderstood bookkeeping tasks among FBA sellers.
We work with e-commerce clients from our Coral Gables headquarters and across Miami-Dade County, and the single most common bookkeeping error we find in new client files is a single "Amazon deposit" line item booked straight to revenue. That shortcut understates your expenses, overstates your margins, and can cause real problems if the IRS or a lender ever asks you to substantiate your numbers. This guide walks through exactly how to reconcile your Amazon settlement report to your bank deposit, how to record FBA fees in QuickBooks correctly, and what South Florida sellers specifically need to watch for with Florida sales tax.
What Is Amazon Settlement Report Reconciliation?
Amazon settlement report reconciliation means breaking a single bank deposit into its component parts, product sales, refunds, FBA fulfillment fees, referral fees, storage fees, advertising spend, and reserve adjustments, then posting each component to the correct account in your accounting system. Amazon does not deposit your gross sales. It nets everything together every two weeks (or more often for high-volume sellers) and sends you the remainder.
Get our starter pack of tax guides, free.
One welcome email with our most-used guides, then a few genuinely useful ones a month. Unsubscribe anytime.
Without reconciliation, you are essentially doing cash-basis accounting on a single lump sum, which tells you almost nothing about which products are profitable, how much you are really spending on ads, or whether your FBA fees are creeping up as a percentage of sales. It also creates a mismatch between what your books show and what Amazon's own Seller Central reports show, which becomes a real liability during a tax audit or a business valuation.
Why the Gross Deposit Number Lies to You
Say your settlement period shows $42,000 in product sales. The deposit that hits your bank is $29,150. If you book $29,150 as revenue, you have understated your top line by nearly $13,000 and you have zero expense detail to deduct against it. That $13,000 gap typically breaks down into categories like referral fees, FBA pick and pack fees, storage fees, PPC advertising, and refunds, every one of which is a legitimate, deductible business expense that disappears from your books if you only record the net deposit.
The Core Components of an Amazon Settlement Report
Every settlement report, whether you are on Seller Central or Vendor Central, contains a predictable set of line items. Understanding each one is the foundation of correct reconciliation.
| Settlement Line Item | What It Represents | Typical Posting in QuickBooks |
|---|---|---|
| Product sales | Gross revenue from items sold | Sales revenue account |
| Shipping credits | Amount customer paid for shipping | Shipping revenue account |
| Refunds | Returned or refunded orders | Contra revenue (sales returns) |
| Selling fees (referral) | Amazon's commission, typically 8% to 15% | Amazon referral fee expense |
| FBA fulfillment fees | Pick, pack, and ship costs | FBA fulfillment fee expense |
| FBA storage fees | Monthly or long-term storage charges | FBA storage fee expense |
| Advertising (PPC) | Sponsored Products and Sponsored Brands spend | Advertising expense |
| Promotions | Coupons, Lightning Deals, deal fees | Marketing expense |
| Reserve, held, or released | Funds Amazon holds back temporarily | Other current asset (Amazon reserve) |
If you are managing this manually in a spreadsheet, it is easy to see how a single missed category, especially long term storage fees or reserve movements, throws off your entire reconciliation.
Step by Step: Reconciling Your Settlement Report to the Deposit
Follow this process every settlement period, not just at month end, so errors do not compound.
- Download the settlement report from Seller Central under Reports, Payments, then Date Range Reports. Export the transaction level detail, not just the summary.
- Identify the deposit date and amount on your bank statement that matches the settlement period end date.
- Total each category (product sales, refunds, fees, advertising, reserve changes) using the settlement report's built-in summary or a pivot table.
- Confirm the math: product sales minus refunds minus all fees minus advertising, plus or minus reserve changes, should equal the deposit amount to the penny.
- Create a journal entry in QuickBooks that debits and credits each category rather than a single net deposit entry.
- Match the journal entry to the bank feed so the net amount ties to the actual deposit transaction.
- File the settlement report PDF or CSV in your accounting software or a dedicated cloud folder, labeled with the settlement period dates, for audit support.
A Real Example With Numbers
A Miami-area kitchenware seller we work with had a settlement period with $38,600 in product sales and $1,200 in shipping charged to customers. Refunds for that period totaled $2,450. Amazon's referral fees came to $5,790 (15% of net sales), FBA fulfillment fees were $6,120, storage fees were $890, and PPC advertising spend was $4,340. Amazon also released $1,100 from a previous reserve hold.
Running the math: $38,600 + $1,200 minus $2,450 minus $5,790 minus $6,120 minus $890 minus $4,340 plus $1,100 equals $21,310, which matched the bank deposit exactly. Had this client booked only the $21,310 as revenue, they would have missed $17,290 in legitimate deductible expenses and understated gross sales by nearly $18,000 on their books, a serious problem if they were ever applying for an SBA loan or selling the business.
Recording FBA Fees in QuickBooks Correctly
Getting FBA fees in QuickBooks set up properly the first time saves hours of cleanup later. We recommend a chart of accounts structure specifically built for Amazon sellers rather than the generic QuickBooks default accounts.
| QuickBooks Account | Account Type | Purpose |
|---|---|---|
| Amazon Sales | Income | Gross product and shipping revenue |
| Amazon Refunds | Income (contra) | Returns and refunded orders |
| Amazon Referral Fees | Expense | Amazon's percentage commission |
| Amazon FBA Fulfillment Fees | Expense | Per unit pick, pack, ship costs |
| Amazon Storage Fees | Expense | Monthly and long term storage |
| Amazon Advertising | Expense | PPC and sponsored ad spend |
| Amazon Reserve Account | Other current asset | Funds held, released over time |
Once this structure exists, you have two practical options for getting the data in: manual journal entries from the settlement report (fine for sellers under roughly $500,000 in annual revenue), or an automated connector app like A2X or Link My Books that pulls settlement data directly into QuickBooks with the breakdown already categorized. For most of our clients doing six figures or more in Amazon sales, the automated connector pays for itself within the first month in saved bookkeeping time alone.
Florida Sales Tax and Amazon Marketplace Facilitator Rules
South Florida sellers get one piece of good news here: since Amazon qualifies as a marketplace facilitator under Florida law, Amazon collects and remits Florida sales tax on your behalf for sales shipped to Florida addresses. That means you generally do not need to separately remit that tax to the Florida Department of Revenue for Amazon sales, but you still need to report gross marketplace sales correctly if you hold a Florida sales tax registration for other sales channels like Shopify or your own website.
This marketplace facilitator distinction trips up a lot of Miami-Dade County sellers who assume Amazon handles all their sales tax obligations everywhere. Amazon only handles tax in states where marketplace facilitator laws apply and where you have nexus through Amazon's fulfillment network, which can include states where Amazon stores your inventory in a warehouse, even if you have never set foot there. If your products are stored in FBA warehouses in multiple states, you may have sales tax nexus and filing obligations you are not currently meeting.
Common Reconciliation Mistakes We See in Florida E-commerce Businesses
A few patterns show up again and again when we onboard new e-commerce clients from Coral Gables to Fort Lauderdale.
- Booking the net deposit as revenue. This is the single most common error and the one that causes the biggest tax and valuation headaches.
- Ignoring reserve account movements. Reserves held and released create timing differences that, left unreconciled, make your bank account never quite match your books.
- Missing long term storage fees. These post separately from regular FBA fees and are easy to overlook in a manual process.
- Conflating Amazon's "order date" with the settlement "deposit date." Revenue should generally be recognized when the sale occurs, not when the cash lands, which matters more as your business grows and you move toward accrual accounting.
- Not reconciling at all until tax season. Trying to reconcile twelve months of settlement reports in March is painful and expensive. Monthly or biweekly reconciliation is dramatically easier and cheaper.
If any of these sound familiar, it is worth having a professional review your Amazon bookkeeping setup before you file your 2026 tax year return, since cleanup done in January is far cheaper than cleanup done after a tax notice arrives.
Why Accurate Reconciliation Matters for Your Tax Strategy
Clean, reconciled books are not just a bookkeeping nicety, they are the foundation of any real business tax strategy. You cannot make smart decisions about entity structure, retirement plan contributions, Section 199A deductions, or quarterly estimated tax payments if your underlying revenue and expense numbers are wrong. We routinely see e-commerce sellers overpay their quarterly estimates because unreconciled books make their income look higher than it actually is, or underpay because they missed deductible FBA and advertising expenses entirely.
For growing Amazon businesses, this is exactly where a combination of our small business bookkeeping services and business tax strategy work together: accurate monthly reconciliation feeds directly into smarter quarterly tax planning, better entity decisions, and fewer surprises every April. Our managed accounting clients get Amazon settlement reconciliation built directly into their monthly close process, so by the time tax season arrives, the numbers are already clean and defensible.
Frequently Asked Questions
Q: How often should I reconcile my Amazon settlement reports? A: Ideally every settlement period, which for most sellers is every two weeks, or at minimum monthly. Waiting until year end means reconciling dozens of settlement reports at once, which increases the chance of errors and makes it much harder to catch problems like missing refunds or fee category changes while they are still fixable.
Q: Can I just use the Amazon deposit amount as my revenue for tax purposes? A: No. The IRS expects gross revenue and expenses reported separately, not a single net figure, and booking only the net deposit understates both your sales and your deductible expenses like FBA fees and advertising. This can distort your tax liability and create problems if you are ever audited or need financial statements for a loan application.
Q: Does Amazon handle my Florida sales tax automatically? A: For sales shipped to Florida addresses, yes, Amazon collects and remits sales tax as a marketplace facilitator under Florida law. However, if you sell through other channels or have inventory stored in FBA warehouses in other states, you may still have separate sales tax registration and filing obligations in those states.
Q: What is the easiest way to get FBA fees into QuickBooks without manual data entry? A: Automated connector apps like A2X or Link My Books pull your Amazon settlement data directly into QuickBooks and break it into the correct revenue and expense categories automatically. For sellers doing significant volume, this is almost always worth the monthly subscription cost compared to the hours spent on manual journal entries.
Q: My settlement report doesn't match my bank deposit exactly. What am I missing? A: The most common culprits are reserve account holds or releases, long term storage fees posted separately from regular FBA fees, or a settlement period that spans two different bank deposit dates. Pull the full transaction detail report rather than just the summary and check each category line by line against the deposit total.
Q: Should I hire a bookkeeper who specializes in e-commerce, or can any accountant handle this? A: Amazon reconciliation has enough unique mechanics, reserves, referral fee tiers, multi-state nexus from FBA warehouses, that it genuinely helps to work with someone who handles e-commerce clients regularly. A general bookkeeper without this experience often books the net deposit shortcut, which is exactly the problem you are trying to avoid.
Getting Your Amazon Books Audit Ready
Reconciling your Amazon settlement report to your bank deposit is not glamorous work, but it is the difference between knowing your real margins and guessing at them. South Florida business owners selling on Amazon deserve bookkeeping that holds up to IRS scrutiny, bank underwriting, and their own decision making, not a shortcut that papers over a five figure gap every pay period.
If your Amazon books have never been properly reconciled, or you are not confident your FBA fees in QuickBooks are categorized correctly, our team at WAYG's Coral Gables office works with e-commerce sellers across Miami-Dade County and nationwide to clean up settlement reconciliation and build it into an ongoing monthly process. We offer a free strategy session to review your current setup and show you exactly where the gaps are. Schedule a consultation today and let's get your Amazon books reconciled before the next tax season catches you off guard.