Reconcile FBA Fees in QuickBooks or Xero With One Clearing Account
To reconcile FBA fees, use the Amazon settlement report to record gross sales in a clearing account, post each fee line to its own expense account, then match the net deposit to clear the holding account. Watch for posting lags and reimbursements, and let automation handle the repetitive matching while you verify the totals.
TL;DR:
- Pull the settlement, transaction, and orders reports, then sort by transaction type and verify group subtotals equal the net payout before posting entries.
- Amazon says FBA fees will rise by an average of $0.08 per unit in 2026, but actual changes depend on product mix.
- Choose posting date for settlement consistency or order date for accrual accounting, then apply it consistently; fees can post months after sales.
- Post gross sales to a clearing account, itemize fees, keep reimbursements separate, and match the net deposit until the balance returns to zero.
- Automate repetitive matching only after testing one settlement manually, then verify connector mappings, payout detail, residual balances, and unusual adjustments after every sync.
Table of Contents
- Which Amazon reports and columns should you pull first?
- Which FBA fee categories show up on a settlement?
- What does the step-by-step reconciliation workflow look like?
- Why do dates and timing break reconciliations?
- How do you post this in QuickBooks or Xero?
- What can automation do, and what must you still check?
- Why does accurate fee reconciliation matter for taxes and margins?
- An editorial take on reconciling FBA fees
- How we help with FBA reconciliation and recovery
- FAQ
- Sources
Which Amazon reports and columns should you pull first?
Reconciliation starts with the right data. Pull everything from Seller Central before you open your accounting software, because trying to reconcile from a bank deposit alone leaves you guessing what sits inside it. The settlement report works as a financial roadmap: it shows sales, refunds, fees, reimbursements and adjustments, and it should tie back to the deposit that landed in your bank.
Download these for each period:
- The settlement report, which is the payout-level and transaction-level breakdown of each deposit.
- The transaction and orders reports, which let you trace a fee back to a specific order.
- Any fee invoices Amazon provides, saved as PDFs next to the matching settlement.
- Our guide to the four Amazon reports every seller must pull if you want a fuller checklist.
Once you have the file, focus on a handful of columns: payout date, posting date, transaction type, order ID, SKU, description and amount. The transaction type and description tell you which bucket a line belongs to. The posting date tells you when Amazon booked it, which often differs from when the customer ordered.
Amazon groups lines in each payout into sales, refunds, fees, reimbursements and adjustments. Sort or filter by transaction type first and subtotal each group. If those subtotals add up to the net payout, your data is complete and you can move on. If they do not, you are missing a report or a date range, and it is far cheaper to find that now than after you have posted entries.
Which FBA fee categories show up on a settlement?
Every fee on the settlement needs a home in your chart of accounts, so learn to recognize each one by its description. Amazon says it gives 90 days of notice for major fee changes and recommends Profit Analytics dashboards or API-integrated tools to watch unit economics, which is a good reminder that these lines move over time.
- Referral fees: a percentage of each sale, shown as a fee line tied to the order. These are your most predictable charge.
- Fulfillment fees: per-unit pick and pack charges that depend on size and weight. They cut straight into gross margin.
- Storage fees: monthly and long-term storage charges. They post on a schedule rather than per sale, so they look like orphan lines with no order ID.
- Advertising fees: PPC and promotion costs. Depending on how you pay, they may be deducted from the settlement or billed separately, so check both.
- Reimbursements and adjustments: credits for lost or damaged inventory, plus removal and refund adjustments. These are money coming back to you and need their own treatment.
Amazon’s own forum post on the update says that in 2026 FBA fees will rise by an average of $0.08 per unit sold, with no new FBA fee types and at least 90 days’ notice for changes.
[That $0.08 average per unit is an average, so your own SKUs may move more or less. Run your top sellers through our free FBA fee and profit calculator to see your real exposure.](https://sellercentral.amazon.com/seller-forums/discussions/t/f3fa3211-820b-4e2e-a023-158a9cf55f99)
What does the step-by-step reconciliation workflow look like?
The workflow rests on one idea: never let Amazon’s net deposit be the first thing you record. QuickBooks guidance says to use a clearing account such as Undeposited Funds or an Amazon Holding account for gross sales and itemized expenses, then match the net deposit against it. Here is the sequence.
- Create an Amazon clearing account if you do not have one.
- Pull the settlement report and subtotal each transaction type.
- Record gross product sales into the clearing account, split by SKU or as an aggregated product sales line.
- Post each fee line to its own expense or contra-COGS account.
- Record reimbursements and credits separately.
- Match the bank deposit to the clearing account so the balance returns to zero.
- Reconcile the bank account as usual.
Take an illustrative settlement. Suppose gross sales, fees, storage charges and reimbursements are recorded. The net deposit is the gross sales amount minus the fees and storage charges, plus reimbursements.
The journal entry looks like this:
- Debit Amazon Clearing and credit Product Sales for the gross sales amount.
- Debit each fee expense account and credit Amazon Clearing for the total fees.
- Debit Amazon Clearing and credit Reimbursements for the reimbursement amount.
- Debit Bank and credit Amazon Clearing for the net deposit.
After these entries, the clearing account should be cleared. That confirms the entries balance.
To verify any settlement, run this checklist:
- Do gross sales on the report equal the sales credited?
- Does each fee subtotal match the entry posted?
- Do reimbursements appear on their own line?
- Does the net of all entries equal the bank deposit to the cent?
- Is the clearing account back at zero?
Pro Tip: Post reimbursements to a dedicated account rather than netting them against fees, so you can see later how much Amazon actually returned to you.
For a walkthrough of matching payouts to deposits, see our post on settlement-first reconciliation.
Why do dates and timing break reconciliations?
Most failed reconciliations are timing problems, not math problems. Amazon can post fees or adjustments well after the sale they relate to, so a sale in one month can carry a fee that lands in the next. A sale in one month can therefore carry a fee that lands in the next.
Decide on a policy and apply it consistently. You can follow posting date, which mirrors what Amazon booked and keeps each settlement self-contained, or you can follow order date, which is closer to true accrual but needs adjusting entries. Neither is wrong. Switching between them mid-year is the real mistake.
A few other items distort individual settlements:
- Reserves hold back funds and release them later, so a deposit can look short without any fee being wrong.
- Negative adjustments and chargebacks reduce a future payout rather than the one you are reviewing.
- Settlements can overlap a month boundary, so a single payout may belong partly to each month.
Practical habits keep this manageable:
- Keep a rolling reconciliation window instead of closing each period permanently on day one.
- Track late adjustments in a simple control schedule.
- Never invent an offsetting entry to force month-end numbers to tie. A plug hides the exact problem you are trying to find.
For more on bookkeeping treatment, our Amazon fees accounting guide covers mapping and tax steps.
How do you post this in QuickBooks or Xero?
The rule that matters most is simple: do not push raw net Amazon deposits through your bank feed. Import or post gross sales to the clearing account and let the net deposit match against it, exactly as the QuickBooks guidance describes. If you enter transactions by hand, a sales receipt or journal entry both work, and the QuickBooks community thread suggests confirming categorization with an accountant.
If you use a connector, check what it does after each sync. Connectors typically import summarized sales data based on settlement payouts and sort it into sales, shipping income, discounts, reimbursements, selling fees, fulfillment and warehousing, subscription fees and advertising. Verify the filters and the payout view each time.
A workable mapping looks like this:
- Product sales, shipping income and discounts go to income accounts.
- Referral and selling fees go to a selling fees expense account.
- Fulfillment and storage go to fulfillment and warehousing expense.
- Advertising goes to advertising expense.
- Reimbursements go to a reimbursement account, not buried in fees.
After each sync, confirm three things: the mapping rules match the list above, the payouts are summarized or transaction-level as you expect, and the clearing account ends at zero.
Tax coding deserves attention too. Even where Amazon collects and remits sales tax, sellers remain responsible for correct product-level tax coding, so keep seller data tightly aligned with your accounting software.
At month end, reconcile the clearing account, then investigate any residual before you close. If you work in QuickBooks Online, our guide to reconciling QuickBooks Online for Amazon sellers walks through it.
Pro Tip: Run a clearing account report by date range before closing. A small leftover balance is almost always a timing item or a missed reimbursement.
What can automation do, and what must you still check?
Automation shortens the repetitive work. A good tool posts on consistent rules, flags mismatches and surfaces reimbursements you would otherwise miss. A partner guide on accounting automation gives useful background on the cash flow benefits of automating bookkeeping.
When you evaluate any connector, look for:
- Summarized settlement posting with transaction-level detail available.
- A rules engine you can customize for mapping.
- Direct QuickBooks or Xero integration.
- A reimbursement claim workflow.
Some things still need a human: inbound-loss claims, unusual manual invoices and complex adjustments. Judge any tool on data fidelity, a clear audit trail, posting customization and how quickly support answers.
Why does accurate fee reconciliation matter for taxes and margins?
Clean fee records protect you in three places. First, tax: recording gross sales and itemized fees keeps your filings and 1099-K reconciliation accurate. Second, margins: when each fee sits in its own account, your unit economics stay trustworthy for pricing decisions. Third, valuation: a buyer or lender will look at your books, and tidy, itemized records hold up under scrutiny.
Fees also change. Watching Amazon’s updates and using Profit Analytics or a unit-level dashboard shows you the impact before it hits your margin.
An editorial take on reconciling FBA fees
Most advice treats reconciliation as a month-end chore, and that is exactly why it goes wrong. The books are only as good as the habit of tying every settlement to zero as it arrives, not weeks later when the details are cold.
I would also push back on the instinct to buy a tool first. A connector will faithfully post whatever you mapped, including your mistakes. Learn the clearing-account logic by hand on a single settlement, then automate it. You will spot a bad mapping in seconds instead of discovering it at tax time.
What is overrated is chasing a perfect match on every line. What matters is a clearing account that returns to zero, fees that sit in separate accounts, and reimbursements that are visible. Start there, keep one date policy, and add automation once the structure is sound.
, Tim
How we help with FBA reconciliation and recovery
We watch your FBA ledger events and inbound shipments to find reimbursements Amazon owes you, and we post summarized settlements to QuickBooks and Xero so your clearing account ties out. That cuts the manual matching and the missed credits. Start with our free FBA reimbursement audit, or compare plans on our pricing page.
FAQ
How do I reconcile Amazon payments?
Download the settlement report, record gross sales into a clearing account, and post each fee line to its own expense account. Then match the net bank deposit to the clearing account until it returns to zero.
How much will Amazon FBA fees increase in 2026?
Amazon stated that FBA fees will rise by an average of $0.08 per unit sold, with no new FBA fee types. Your own increase depends on your product mix.
Why is my FBA fee so high?
Fulfillment fees depend on a product’s size and weight, so oversized or heavy items cost more. Storage fees and other surcharges can also stack on top. Check each fee line on the settlement to see which one is driving the total.
How do I know if Amazon owes me a reimbursement?
Compare inbound shipments and ledger events against what Amazon credited. Lost or damaged inventory should appear as reimbursement lines, and a missing one is worth a claim. Our FBA reconciliation report guide shows how to spot them.
Sources
- 2026 Amazon Referral & FBA Fee Updates | Amazon Selling Partners - Amazon Selling Partners
- Connect Amazon Seller Central to QuickBooks