How to Post Amazon FBA Fees to QuickBooks Online (Step-by-Step 2026)
February 20, 2026
·
MerchantLedger Team
·
10 min read
Key Takeaways
- Amazon settlement reports contain dozens of fee types that need individual accounts in QuickBooks — recording the net deposit as revenue is the most common (and costly) mistake.
- Set up separate expense accounts for FBA fulfillment fees, referral fees, storage fees, and advertising so you can analyze where your money is going.
- Every settlement journal entry must balance: debits equal credits. The debit to Settlements Receivable matches the bank deposit you receive from Amazon.
- Always record COGS alongside revenue. Without it, your profit margins are overstated and your tax filings may be inaccurate.
- MerchantLedger automates the entire process — pulling settlements, mapping fees, and posting balanced journal entries directly to QuickBooks Online.
The Challenge: Amazon Fees in QuickBooks
If you sell on Amazon FBA, you already know that Amazon FBA fees eat into your margins from every direction. A single settlement period can include FBA fulfillment fees, referral fees, monthly storage fees, long-term storage surcharges, advertising costs, refund clawbacks, and a dozen other line items most sellers have never heard of.
Getting all of these into QuickBooks Online correctly is not optional — it's essential. Without accurate fee tracking, your profit and loss statement lies to you. Your tax return either overstates or understates deductible expenses. And the business decisions you make based on those numbers — which products to reorder, which to discontinue, how much to spend on ads — are built on bad data.
The root of the problem is Amazon's settlement report. Every two weeks, Amazon deposits a net amount into your bank account and provides a report breaking down how they calculated it. That report is your single source of truth for Amazon accounting. The challenge is translating it into proper QuickBooks journal entries with the right accounts, debits, and credits.
This guide walks you through the entire process from scratch.
What You Need Before Starting
Before you create a single account or journal entry, make sure you have:
- QuickBooks Online account — Simple Start, Essentials, or Plus all work. Plus gives you the most flexibility for reporting.
- Amazon Seller Central access — you need to be able to download settlement reports from the Payments section.
- At least one completed settlement report — Amazon generates these every 14 days. You need a completed (not open) period to work with.
- About 15 minutes for initial setup — creating the chart of accounts is a one-time task. After that, each settlement takes 5–10 minutes to post manually.
Setting Up Your Chart of Accounts
Your chart of accounts is the foundation. Get this right once and every future settlement entry will be straightforward. Here is the full recommended structure.
Revenue Accounts
| Account Name | Account Type | What It Captures |
|---|---|---|
| Amazon Product Sales | Income | Gross product revenue from all Amazon orders |
| Amazon Shipping Income | Income | Shipping charges collected from customers |
| Amazon Refunds | Income (contra) | Customer refunds — recorded as negative income |
Amazon Refunds is an income contra account because refunds reduce your top-line revenue, not increase your expenses. This keeps your gross-to-net revenue calculation clean on the P&L.
Expense Accounts
| Account Name | Account Type | What It Captures |
|---|---|---|
| Amazon FBA Fulfillment Fees | Expense | Per-unit pick, pack, and ship costs |
| Amazon Referral Fees | Expense | Amazon's sales commission (typically 8–15%) |
| Amazon Storage Fees | Expense | Monthly and long-term warehouse storage |
| Amazon Advertising | Expense | Sponsored Products, Brands, and Display spend |
| Amazon Other Fees | Expense | Subscription fees, label services, misc. charges |
Keeping these separate is critical. You need to know whether your storage costs are rising faster than your referral fees. One catch-all "Amazon Fees" account tells you nothing.
Balance Sheet Accounts
| Account Name | Account Type | What It Captures |
|---|---|---|
| Amazon Settlements Receivable | Other Current Asset | Money Amazon owes you before the bank deposit clears |
| Amazon Reimbursements | Other Income | Credits for lost or damaged FBA inventory |
Settlements Receivable acts as a clearing account. You debit it when posting the settlement and credit it when the bank deposit arrives. Reimbursements are not sales revenue — they are compensation for inventory Amazon lost or damaged.
COGS Accounts (If Using Cost Tracking)
| Account Name | Account Type | What It Captures |
|---|---|---|
| Cost of Goods Sold – Amazon | Cost of Goods Sold | Product cost for units sold during the period |
| Inventory Asset | Other Current Asset | Value of inventory currently held |
If you track product costs, you need a COGS entry for every settlement. Without it, your gross margin is overstated because revenue shows up but the cost of the goods you sold does not. MerchantLedger calculates COGS automatically using the Average Cost method, which is the most practical approach for Amazon sellers who restock at varying prices over time.
Understanding Debits and Credits for Amazon Sellers
If you're not an accountant, debits and credits can feel backward. Here is the only mental model you need:
- Debits go in the left column. Credits go in the right column.
- Every journal entry must balance. Total debits must equal total credits.
- Expenses increase with debits. When you record an Amazon fee, you debit the expense account.
- Revenue increases with credits. When you record Amazon sales income, you credit the income account.
- Assets increase with debits. When Amazon owes you money (Settlements Receivable), you debit the asset.
That's it. You do not need to understand T-accounts or double-entry theory beyond this. If debits equal credits and the accounts are correct, the entry is correct.
The Journal Entry Format
For each settlement period, you create one journal entry that captures everything — gross revenue, all fees, refunds, and the net amount owed to you. Here is a realistic example.
Settlement Period: Feb 1–14, 2026
| Account | Debit | Credit |
|---|---|---|
| Amazon Settlements Receivable | $5,247.83 | |
| Amazon FBA Fulfillment Fees | $892.41 | |
| Amazon Referral Fees | $1,156.22 | |
| Amazon Storage Fees | $78.50 | |
| Amazon Advertising | $340.00 | |
| Amazon Refunds | $215.60 | |
| Amazon Product Sales | $7,612.06 | |
| Amazon Shipping Income | $318.50 |
Total debits: $7,930.56 — Total credits: $7,930.56 — the entry balances.
The $5,247.83 debit to Settlements Receivable represents the net deposit Amazon will send to your bank. It equals gross revenue ($7,612.06 + $318.50) minus all fees and refunds ($892.41 + $1,156.22 + $78.50 + $340.00 + $215.60).
When the deposit actually hits your bank account a few days later, you record a second entry to clear the receivable:
Bank Deposit Clearing Entry
| Account | Debit | Credit |
|---|---|---|
| Checking Account | $5,247.83 | |
| Amazon Settlements Receivable | $5,247.83 |
After this entry, the Settlements Receivable balance returns to zero and your bank balance reflects the deposit. If you use QuickBooks bank feeds, you can match the downloaded transaction directly to this entry.
Common Mistakes to Avoid
Mistake 1: Booking the Net Deposit as Revenue
This is the most common mistake Amazon sellers make. You see $5,247.83 hit your bank account and record it as "Amazon Sales." But your actual gross revenue for that period was $7,930.56. You just hid over $2,600 in fees and refunds. Your revenue is understated, your expenses are understated, and your P&L is useless for decision-making.
Always post the full settlement breakdown — gross revenue in, every fee and refund itemized.
Mistake 2: Mixing Fee Categories
Combining FBA fulfillment fees, referral fees, storage fees, and advertising into a single "Amazon Fees" expense account is tempting because it is faster. But it makes analysis impossible. You cannot tell whether your storage costs doubled because you overstocked or your referral fees spiked because you shifted to a higher-commission category. Keep them separate.
Mistake 3: Ignoring Reimbursements
Amazon occasionally reimburses sellers for inventory it lost, damaged, or failed to return after a customer refund. These are not revenue — they are compensation for lost goods. Record reimbursements as Other Income so they do not inflate your sales numbers or distort your unit economics.
Mistake 4: Forgetting to Record COGS
If you record $7,612.06 in product sales but never record what those products cost you, your gross profit is wildly overstated. This creates problems at tax time and gives you a false sense of profitability. Every settlement entry should have a corresponding COGS entry based on the units sold and their average cost.
How to Verify Your Entries
After posting a settlement to QuickBooks, run these four checks:
- Run a Profit & Loss report filtered to your Amazon accounts. Gross revenue minus fees should equal your net settlement amount.
- Compare gross revenue to Seller Central. The "Product Sales" total in your P&L should match the gross sales figure in Amazon's settlement report.
- Compare the deposit to your bank statement. The Settlements Receivable clearing entry should match the actual deposit amount to the penny.
- Confirm debits equal credits. If QuickBooks accepted the journal entry, it balanced — but double-check the line items to make sure no account was accidentally swapped.
If all four checks pass, your books are accurate for that period.
Automating with MerchantLedger
Manually creating these journal entries every two weeks is tedious and error-prone. One wrong number, one fee in the wrong account, and your reports are off until you find the mistake. MerchantLedger eliminates this entirely.
- Maps every fee type automatically. MerchantLedger reads your settlement report and assigns each line item to the correct QuickBooks account — fulfillment fees, referral fees, storage, advertising, and everything else.
- Creates balanced journal entries. Every entry is built programmatically, so debits always equal credits. No manual math.
- Posts directly to QuickBooks via API. Journal entries appear in your QuickBooks Online account without any copy-paste or CSV import.
- Handles edge cases. Multi-currency settlements, prior-period adjustments, reimbursements, and promotional rebates are all accounted for automatically.
The account mapping is fully customizable. If your chart of accounts uses different names or you want to consolidate certain fee types, you can remap any category in the MerchantLedger dashboard.
No spreadsheets. No manual data entry. No miscategorized fees.
Other Accounting Software
While this guide focuses on QuickBooks Online, the same concepts apply to other platforms. MerchantLedger also supports Xero and Wave. The chart of accounts structure, journal entry logic, and fee categorization are identical — only the posting format differs based on each platform's API.
If you use Xero or Wave, you can follow the same account setup described above and let MerchantLedger handle the platform-specific formatting.
Frequently Asked Questions
How often should I post Amazon settlements to QuickBooks?
Post every settlement period — typically every 14 days. Waiting until month-end or quarter-end makes reconciliation much harder because you are trying to match multiple deposits against a pile of unsorted transactions. Posting per settlement keeps your books current and makes bank reconciliation straightforward.
Can I use QuickBooks Simple Start for Amazon accounting?
Yes, Simple Start supports journal entries and custom accounts, which is all you need for settlement posting. However, QuickBooks Plus gives you class and location tracking, which is useful if you sell on multiple Amazon marketplaces or want to segment profitability by product line.
What if I've been booking net deposits as revenue — how do I fix it?
Create a correcting journal entry for each prior period. Debit the individual fee and refund accounts for the amounts that were hidden in your net deposit, and credit the revenue account to reduce it from the net amount back down to the correct gross-minus-fees breakdown. This can be tedious for many periods — MerchantLedger can backfill historical settlements to automate the correction.
Does MerchantLedger overwrite existing QuickBooks data?
No. MerchantLedger creates new journal entries — it never modifies or deletes existing transactions in your QuickBooks account. Each posted settlement is a new entry with a unique reference number tied to the Amazon settlement ID, so there is no risk of duplicate or overwritten data.
Getting Started
- Create your Amazon fee accounts in QuickBooks using the chart of accounts tables above.
- Download one settlement report from Seller Central to use as a reference.
- Post your first journal entry manually following the format in this guide — this helps you understand the structure.
- Sign up for MerchantLedger and connect both your Amazon Seller Central and QuickBooks Online accounts.
- Pull and post your next settlement automatically — review the journal entry MerchantLedger creates, confirm it matches what you expect, and you are done.
Start your free MerchantLedger account — connect Amazon and QuickBooks in under 5 minutes.