Why FBA Accounting is Complex
Amazon FBA involves multiple revenue streams (sales, refunds, adjustments), numerous fees (referral, FBA, payment processing), and inventory complications (in-transit, reserved, defective). Without a proper workflow, reconciliation becomes a nightmare.
Most sellers either overpay in accounting fees trying to figure it out, or use inaccurate methods that lead to wrong profit calculations and tax surprises.
The Complete FBA Accounting Workflow
Daily: Monitor Seller Central
Check for orders, refunds, account holds, reserve releases. Note any unusual activity that might need manual recording.
Every 14 Days: Download Payout Reports
Amazon deposits every 14 days (standard). Download Settlement Report showing all sales, fees, and net payout. Verify amount matches bank deposit.
Every 14 Days: Reconcile to QB/Xero
Use Connector app or manual entry. Match Settlement Report totals to accounting software. Investigate discrepancies immediately.
Monthly: Inventory Reconciliation
Count inventory in FBA. Compare to QB/Xero balance. Record differences (damaged, shrink, discrepancies) as adjustments.
Monthly: Review P&L
Generate P&L report. Compare to previous months. Analyze profit by product category if multi-channel.
Quarterly: Deep Analysis
Review profitability by ASIN. Identify products losing money. Analyze trends for pricing and ad spend adjustments.
Key FBA Terms & Amounts to Track
Settlement Report Line Items
| Item | Description | Accounting Treatment |
|---|---|---|
| Gross Revenue | Total sales at list price | Debit Cash, Credit Revenue |
| Referral Fee | Amazon's % cut (8-45% by category) | Debit Expense, Credit Due to Amazon |
| FBA Fee | Fulfillment & storage cost | Debit Expense, Credit Due to Amazon |
| Refunds | Customer returns/cancellations | Debit Returns, Credit Cash |
| Chargebacks | Disputed transactions | Debit Expense, Credit Cash |
| Storage Overages | Extra inventory beyond allotment | Debit Expense, Credit Due to Amazon |
| Net Payout | Final amount deposited to account | Debit Cash, Credit Payable settled |
Account Holds & Reserves
Amazon holds 14-30 days of sales in reserve for potential chargebacks/returns. This money is yours but not yet in your account. Treat as:
- Asset on balance sheet: "Amazon A/R - Reserve Hold"
- Released when payment made (typically after 90 days of account activity)
- Don't double-count in revenue
Real FBA Reconciliation Example
Settlement Report for Period: Nov 1-14, 2025
| Component | Amount | QB/Xero Entry |
|---|---|---|
| GROSS REVENUE | $15,000 | Debit Bank (when deposited), Credit Revenue |
| - Referral Fee (8%) | -$1,200 | Debit FBA Referral Fee Expense |
| - FBA Fulfillment Fee | -$2,100 | Debit FBA Fulfillment Fee Expense |
| - Payment Processing (3%) | -$450 | Debit Payment Processing Fee Expense |
| - Refunds to Customers | -$800 | Debit Sales Returns, Credit Cash Held |
| NET PAYOUT | $10,450 | Verify deposited to bank account |
Reconciliation Steps
- Download Settlement Report from Seller Central
- Verify amount in QB/Xero matches line-by-line
- Confirm bank deposit of $10,450 posted
- If discrepancies exist: check for Seller Performance holds, chargebacks, or partial deposits
- Mark settlement as "Reconciled" in notes
FBA Inventory Accounting
Tracking Inventory in QB/Xero
- Create Inventory Items: One per SKU with COGS at landed cost
- Link to Sales: When FBA order ships, COGS deduction automatic
- Track Quantity: On-hand in FBA warehouse vs QB quantity
- Record Adjustments: Damage, shrinkage, long-term storage fees
Inventory Discrepancies
FBA inventory rarely matches QB exactly. Common reasons:
- In-Transit: Shipments sent to Amazon but not yet received (40-60 days)
- Defective: Items damaged in Amazon warehouse (removable, not sellable)
- Lost/Damaged: Amazon pays for reimbursement (record as offset to COGS)
- Shrink: Regular theft/damage (record as write-down)
Tip: Use QB/Xero's physical count feature monthly. Record actual vs. system quantity. Adjust COGS for differences.
Common FBA Accounting Mistakes
- Not recording FBA fees separately: Lumping all into COGS instead of expense accounts
- Double-counting reserve holds: Including both reserve + deposit as revenue
- Ignoring chargebacks: Recording sales but not reversals when disputed
- Wrong COGS method: Using supplier invoice instead of landed cost
- Not reconciling: Relying on bank deposits without checking Seller Central reports
- Inventory overvaluation: Counting in-transit as available inventory
- Not tracking by ASIN: Can't see which products are profitable
FBA vs FBM Accounting Differences
| Aspect | FBA (Fulfilled by Amazon) | FBM (Fulfilled by Merchant) |
|---|---|---|
| Fulfillment Fee | Amazon charges ($0.40-$1.45+/unit) | You pay for shipping |
| Referral Fee | Amazon takes 8-45% per category | Amazon takes 8-45% per category |
| Inventory Ownership | Amazon holds; you track separately | You own and store inventory |
| Accounting Complexity | High (multiple fee streams) | Lower (direct shipments) |
| Profit Impact | Typically 13-20% of revenue in fees | Typically 5-10% of revenue in fees |
Summary: FBA Accounting Workflow
Daily: Monitor Seller Central for issues
Every 14 Days: Download payout report, reconcile to QB/Xero, verify bank deposit
Monthly: Reconcile inventory, record adjustments, review P&L
Quarterly: Analyze profitability by ASIN, identify underperformers