Talk to a CFO
Eightx Talk to a CFO
← All Insights

Long-Tail

Xero Bookkeeping for Amazon FBA 2026: Settlement Reconciliation Guide

· 18 min read

A2X is the best overall Xero integration for Amazon FBA sellers because it splits each bi-weekly settlement into gross sales, referral fees, FBA fees, storage, refunds, and advertising as properly coded journal entries, enabling penny-perfect reconciliation. Accrual accounting is effectively required, since Amazon's settlement cycle means cash deposits never align with when sales occurred. Sellers under $50,000 a month can use Link My Books as a cheaper alternative.

Key Takeaways

  • A2X is the gold standard for Amazon-to-Xero integration — it categorizes payouts, handles multi-region, and enables penny-perfect reconciliation
  • Your chart of accounts needs separate lines for FBA fees, referral fees, storage fees, and advertising — lumping them hides margin killers
  • Never treat Amazon net deposits as revenue — gross up sales and break out fees separately, or your gross margin is fiction
  • A UK health & wellness brand at £10M run rate cut month-end close from 3 weeks to 5 days after proper Xero-Amazon integration
  • Accrual accounting is non-negotiable for FBA sellers — cash-basis books distort monthly P&Ls

Amazon FBA is one of the most powerful sales channels available to product brands. It is also one of the hardest to get right from a bookkeeping perspective. The settlement reports are opaque. The fees are layered and constantly changing. And the bi-weekly payout cycle creates a timing mismatch that makes cash-basis accounting essentially useless.

I have worked with dozens of Amazon sellers across our client base at Eightx, and the same pattern repeats: a brand is doing $3M, $5M, $10M on Amazon, and their bookkeeper is recording net deposits as revenue. Which means their financial statements are wrong. Their gross margin is overstated. Their fee exposure is invisible. And every strategic decision they make is based on incomplete data.

This guide is the complete setup process for running Amazon FBA bookkeeping through Xero — from chart of accounts to integration configuration to monthly close. It is built from what we actually implement for clients, not theoretical best practices. If you'd rather hand the whole stack to a team that runs this for $5M–$150M DTC and CPG brands, see our ecommerce bookkeeping service.

Xero bookkeeping for Amazon FBA records gross sales, itemized fees, refunds, and inventory movements from Seller Central into Xero using automated integrations, producing accrual-basis financial statements that show true channel profitability.

Why Amazon FBA Bookkeeping Is Different (And Why Most Sellers Get It Wrong)

Let me tell you what I see in almost every Amazon seller’s books when they first come to us.

The bookkeeper looks at the bank feed in Xero or QuickBooks, sees a $47,000 deposit from Amazon, and records it as revenue. Done. Move on.

But that $47,000 deposit started as $68,000 in gross sales. Amazon took $8,500 in referral fees, $6,200 in FBA fulfillment fees, $1,800 in storage fees, $2,100 in advertising costs, and $2,400 in refunds and returns. What landed in the bank is the net — but recording the net as revenue hides $21,000 worth of costs that you need to see, understand, and manage.

The first thing you can do right away is break those out differently. In your gross margin, you would want to have your product costs and not include the Amazon fees, because it obscures the data for you. Your gross margin, as long as the selling price less discounts is similar between Amazon and Shopify, should be roughly the same across channels. Your contribution margin — the net you keep after all the variable stuff — is different. But your gross margin will be almost the same. And if your bookkeeping company is putting them in the same bucket, ask them to stop. Not only because it obscures the data, but because when you go to sell the business, you have to show your gross margin. And if buyers see that it looks terrible because Amazon fees are buried in COGS, it takes them time to understand.

Is Xero good for Amazon sellers? Yes — and here are the three core bookkeeping challenges that Xero, properly configured, solves:

  1. Amazon obscures everything. Settlement reports net dozens of fee types into a single deposit. Without an integration tool that disaggregates this data, you are flying blind.
  2. Cash vs. accrual timing mismatch. Amazon pays every two weeks. A sale on March 1st might not hit your bank until March 15th. Cash-basis accounting makes your March P&L fiction.
  3. FBA inventory complicates the balance sheet. Your inventory sits in Amazon’s warehouses. You need to track it as a balance sheet asset, account for COGS when it sells, and adjust for returns and Amazon’s own inventory losses.

Choosing Xero for Amazon FBA: Why It Works (And When It Does Not)

Multi-currency is native. If you sell on Amazon US, UK, Canada, and EU marketplaces, Xero handles multiple currencies natively without workarounds.

Bank feeds work well. Xero’s bank feed reconciliation is among the best in cloud accounting. When paired with A2X, Amazon settlements flow in pre-categorized, and Xero suggests matches for one-click confirmation.

It scales with the business — to a point. Xero handles a $20M+ Amazon operation well. But if you are approaching $30M+ across multiple entities and countries and need consolidated reporting, you may be approaching NetSuite territory. For most Amazon FBA sellers under $20M, Xero is the right tool.

For a detailed comparison of Xero vs QuickBooks for online sellers, see our full analysis. The short version: Xero is typically better for international sellers and brands that prioritize bank feed reconciliation. QuickBooks for eCommerce is often better for US-only sellers who need deep native inventory tracking.

The Complete Xero Chart of Accounts for Amazon FBA

This is where 90% of Amazon FBA bookkeeping problems start: a chart of accounts that does not have enough granularity. If all your Amazon fees go into one “Amazon Fees” expense account, you cannot see that storage fees tripled last quarter.

Revenue Accounts Setup

AccountTypePurpose
Amazon FBA SalesRevenueGross product sales from FBA orders
Amazon Direct SalesRevenueSales fulfilled by merchant (FBM)
Shipping IncomeRevenueShipping charges collected from customers
Amazon Other IncomeRevenueReimbursements, liquidation proceeds
Amazon Refunds & ReturnsRevenue (contra)Offset gross sales for returns

Critical rule: always record gross sales, not net deposits. Your P&L should show $68,000 in revenue with $21,000 in fees broken out below, not $47,000 in revenue.

Cost of Goods Sold

AccountTypePurpose
Product Cost (COGS)Direct CostCost of products sold, at landed cost
Inbound Freight to FBADirect CostShipping products to Amazon fulfillment centers
FBA Prep and LabelingDirect CostAmazon prep service fees or 3PL prep costs

Amazon Fee and Expense Accounts

AccountTypePurpose
Amazon Referral FeesExpenseCategory-based percentage fee (8–15%)
FBA Fulfillment FeesExpensePer-unit pick, pack, and ship fees
FBA Storage FeesExpenseMonthly and long-term storage charges
Amazon AdvertisingExpenseSponsored Products, Brands, Display
Amazon Other FeesExpenseAccount fees, subscription, misc.

Balance Sheet Accounts

AccountTypePurpose
Inventory — FBAAssetProducts held in Amazon warehouses
Inventory — In TransitAssetProducts shipped to FBA, not yet received
Amazon ReceivablesAssetEarned revenue not yet deposited

This granularity matters. When a client comes to us spending $15,000/month on FBA storage fees because they have 18 months of slow-moving inventory in Amazon’s warehouses, but all they see on their P&L is “Amazon Fees: $47,000” — they have no idea where to cut.

Total Cost of a Proper Xero-Amazon Setup

ComponentMonthly CostNotes
Xero Growing plan$42/monthUnlimited bank reconciliation
A2X (Standard)$69/monthUp to ~$200K/month Amazon revenue
Bookkeeper time$500–$2,000/monthDepends on complexity and volume
Total operating cost$611–$2,111/month
One-time setup$1,500–$3,500Chart of accounts, integration, migration

Compare this to the cost of bad books: mispriced products, invisible fee creep ($500–$2,000/month in undetected increases), and inability to make strategic decisions with confidence. The ROI on proper bookkeeping infrastructure is not close.

Essential Xero Integrations for Amazon FBA

A2X vs. Link My Books vs. Alternatives

FeatureA2XLink My BooksWebgilityXero Inventory Plus
ReconciliationPenny-perfect, directAutomated, payout-focusedTransaction matchingOrder-level sync
Fee categorizationFull breakout by typeSales-focusedDetailed fee mappingBasic tracking
Multi-marketplaceOne connection per regionSupportedSupportedFBA-focused
Inventory/COGSMonth-end FBA valuationNot highlightedReal-time updatesAuto COGS tracking
Best forHigh-volume, accuracyBudget-consciousMulti-channelNative Xero users
Cost$19–$299/month$9–$49/monthCustomXero add-on

Our recommendation: A2X for any seller doing more than $50K/month in Amazon revenue. The accuracy and automation save far more in accounting time than the subscription costs.

For sellers under $50K/month, Link My Books is a solid alternative. For sellers running Amazon alongside Shopify and other channels, Webgility offers the broadest multi-channel support.

A note on Xero’s built-in inventory limitations: Xero’s native inventory tracking works for sellers with under 500 SKUs. For high-SKU-count catalogs, consider dedicated inventory tools like Cin7 or DEAR that integrate with Xero and provide more robust stock management, lot tracking, and multi-warehouse support. A2X mitigates Xero’s transaction volume limitations by posting summary-level entries rather than individual orders, which keeps Xero responsive even for sellers processing 10,000+ orders per month.

How to Connect Amazon Seller Central to Xero: Step-by-Step Setup

To connect Amazon Seller Central to Xero, install a settlement-integration app (A2X, or Link My Books for smaller sellers), connect it to both your Amazon Seller Central account and Xero by OAuth, then map each settlement category (sales, referral fees, FBA fees, storage, refunds, advertising) to its Xero account. Here is the exact process we follow. For tactical A2X configuration details (screen-by-screen), A2X has excellent setup documentation.

Step 1: Create and Configure Xero Organization

  • Set financial year end and tax basis (accrual for FBA)
  • Configure base currency and enable multi-currency if selling internationally
  • Set up bank accounts and enable bank feeds

Step 2: Build the Chart of Accounts

Use the structure above. Delete or archive default accounts you will not use. A2X offers assisted setup that auto-creates and maps many accounts.

Step 3: Connect Bank Feeds

Link your business bank account to Xero. If you use a separate account for Amazon payouts (recommended), connect that specifically.

Step 4: Install and Configure A2X

  1. Create A2X account and connect Amazon Seller Central (select primary region — A2X auto-detects all marketplaces)
  2. Connect to Xero via OAuth
  3. Account mapping: Map each category (sales, referral fees, FBA fees, storage, advertising, refunds) to the corresponding Xero account
  4. Tax configuration: US sellers set to “No Tax/Tax Exempt” (Amazon collects marketplace tax). UK/EU sellers configure VAT per marketplace. Canadian sellers map GST/HST.
  5. Posting mode: Start with review-first (approve before posting) until you trust the mapping
  6. Review sample settlement: Process one historical settlement and verify every line maps correctly

Step 5: Set Up Inventory Tracking

  • Create inventory items in Xero for core SKUs or SKU groups
  • Record initial inventory balances from Amazon inventory report
  • Configure A2X to track COGS when sales are posted
  • Set up purchase invoices in Xero for new inventory buys

For Amazon FBA tax planning including multi-state nexus considerations, see our dedicated guide.

Step 6: Run First Reconciliation and Verify

  • Let A2X process one complete settlement period
  • Open Xero bank reconciliation and match entries to bank deposits
  • Verify: gross sales, fee breakouts, refunds, and net deposit should reconcile to the penny
  • If mismatch: check A2X account mapping — most common issue is an unmapped fee category

Revenue Recognition and Settlement Reconciliation

The accounting standards are clear: you recognize revenue when it is earned, not when cash arrives. For Amazon FBA, that means recording sales when orders ship, not when Amazon sends the bi-weekly settlement.

A2X solves this by reading the settlement report, disaggregating it into gross sales, individual fee types, refunds, and adjustments, and posting journal entries dated to the settlement period. Your March P&L shows March activity, regardless of when cash arrived.

Handling reserves: Amazon sometimes holds reserves. A2X records these as an Amazon Receivables asset on your balance sheet, cleared when released. If your bookkeeper records withheld funds as expenses, your P&L is wrong.

Advertising costs: The accounting standards are pretty clear that you have to recognize the expense when you spend it. You cannot inventory ad spend and apply it when the revenue arrives. Expense ads when incurred, regardless of payout timing.

Inventory Accounting in Xero for FBA Sellers

COGS tracking with weighted average costing: Xero uses weighted average for inventory valuation. Here is how it works:

Example: You purchase 1,000 units at $5.00 in January (total: $5,000). In March, you purchase 1,500 units at $5.50 (total: $8,250). Weighted average cost is now ($5,000 + $8,250) / 2,500 = $5.30 per unit. When you sell 500 units in April, Xero records COGS at $5.30 × 500 = $2,650. Remaining inventory: 2,000 units at $5.30 = $10,600 on your balance sheet.

The key: ensure purchase invoices capture full landed cost — not just supplier invoice, but inbound freight, duties, and prep costs allocated per unit.

FBA inventory as balance sheet asset: Every unit in Amazon’s warehouse is an asset. Track it in your Inventory — FBA account. Reconcile monthly against Amazon’s inventory report.

Multi-warehouse tracking: If you use Amazon Warehousing & Distribution (AWD) alongside standard FBA, track separately. AWD products have not entered the fulfillment network yet.

Inventory adjustments: Returns, damaged goods, and Amazon inventory losses all need journal entries. Track Amazon losses and claim reimbursements.

The way I approach financial reporting for product brands: your P&L gross margin uses proper unit costs. Then in the cash flow statement, I track inventory purchases separately. Some clients have a P&L gross margin of 70%, but they are buying $500K in inventory in April, $500K in August, and $300K in December. The P&L shows smooth margins; the cash statement shows the real lumpiness.

Common FBA Bookkeeping Mistakes (And How to Fix Them in Xero)

  1. Recording net deposits as revenue. Fix: Use A2X to post gross sales and break out all fees. This is the single highest-impact change you can make.
  2. Lumping all Amazon fees into one account. Fix: Separate accounts for referral fees, FBA fulfillment fees, storage fees, and advertising.
  3. Not reconciling monthly. Fix: Reconcile within 5 business days of each settlement using Xero bank reconciliation. With A2X, takes 15–30 minutes.
  4. Using cash-basis accounting. Fix: Switch to accrual. Your bookkeeping service should produce accrual-basis financials.
  5. Ignoring inventory on the balance sheet. Fix: Record as current asset. Track purchases, COGS, returns, and adjustments monthly.
  6. Not tracking COGS at product level. Fix: Track by category at minimum, by SKU for top movers.

Case Study: UK Health & Wellness Brand Transforms Their Amazon Bookkeeping

A UK health and wellness brand at £10M run rate came to us with a bookkeeping problem that was actually a strategy problem.

The situation: Their in-house bookkeeper was recording Amazon deposits as lump-sum revenue. Month-end close took three weeks. Their P&L showed a 60% gross margin — which the founder used to justify aggressive Amazon ad spend.

What we found: After setting up Xero integration with A2X and rebuilding the chart of accounts, true gross margin was 52% — 8 points lower. CM2 on Amazon after all fees was 28%, while DTC showed CM2 of 41%.

The strategic shift: The founder had been allocating 70% of marketing budget to Amazon. The channel-level P&L showed DTC was significantly more profitable. They redirected £8K/month in Amazon ad spend to DTC, generating an additional £14K/month in contribution margin within 90 days. Strategy shifted: maintain Amazon volume at breakeven ad spend, redirect growth investment to DTC.

The operational improvement: Month-end close went from three weeks to five business days:

  1. Days 1–2: A2X auto-posts final settlement, bookkeeper verifies mapping
  2. Day 3: Xero bank reconciliation for all Amazon deposits, DTC processors, and operating expenses
  3. Day 4: Inventory reconciliation against Amazon and 3PL reports, COGS adjustments
  4. Day 5: P&L review, channel-level reporting, variance analysis against budget

For the first time, the leadership team had accurate, actionable financial statements by channel, product, and marketplace.

A Canadian frozen food CPG brand went through a similar transformation — international expansion to Amazon US created multi-currency complexity their process could not handle. Proper Xero setup with multi-currency configuration turned a monthly headache into a streamlined process.

When to Upgrade from DIY Bookkeeping to Professional Support

  • $500K–$1M Amazon revenue: Link My Books + basic Xero. 2–3 hours/month reconciliation.
  • $1M–$3M: A2X essential. Bookkeeper who understands ecommerce. Close within one week.
  • $3M+: Professional ecommerce bookkeeping plus a fractional CFO for Amazon FBA who interprets data as strategy.
  • $10M+ multi-channel: Evaluate whether NetSuite is warranted.

The signal to upgrade is when your Amazon business reaches complexity your current setup cannot keep pace with. When your Amazon Seller Central accounting consumes more than a day per month, automate and professionalize it.

Related accounting guides

See the full ecommerce accounting hub — software, settlement reconciliation, sales tax, and FP&A.

Frequently Asked Questions

What is the best Xero integration for Amazon FBA sellers?

A2X is the best overall integration for Amazon FBA sellers using Xero. It categorizes Amazon settlement data into individual components — gross sales, referral fees, FBA fees, storage fees, refunds, and advertising — and posts them as properly coded journal entries. This enables penny-perfect reconciliation with one-click bank matching. For sellers under $50K/month, Link My Books is a cost-effective alternative.

Should Amazon FBA sellers use accrual or cash accounting in Xero?

Accrual accounting is strongly recommended and effectively required for Amazon FBA sellers. Amazon’s bi-weekly settlement cycle means cash deposits do not align with when sales were made. Cash-basis creates artificially volatile monthly revenue. Accrual accounting, facilitated by A2X, ensures your monthly P&L reflects actual business activity. This is especially important for fundraising, exit, or bank financing where accrual financials are expected.

How do I track FBA fees in Xero?

Create separate expense accounts for each major fee type in Xero. Set up Amazon Referral Fees, FBA Fulfillment Fees, FBA Storage Fees, and Amazon Advertising as individual accounts. A2X automatically maps these during setup, reading your Amazon settlement report and posting each fee type to its designated Xero account. This lets you spot fee increases, track storage trends, and calculate accurate contribution margins.

Can Xero handle multi-currency Amazon FBA sales?

Yes, Xero natively supports multi-currency accounting. Each marketplace’s transactions flow into Xero in local currency and convert at the prevailing exchange rate. A2X supports multi-region configurations where one connection per Amazon region covers all marketplaces. This allows a single Xero organization to track revenue, fees, and profitability across all marketplaces in their respective currencies.

How often should I reconcile my Amazon accounts in Xero?

Reconcile within five business days of each Amazon settlement (every two weeks). With A2X, Xero bank reconciliation takes 15–30 minutes per settlement with pre-categorized data and one-click green matches. Monthly, also reconcile your Xero inventory balance against Amazon’s inventory report. The goal is a complete month-end close within five business days of period end.


About the Author

Matt Putra, Managing Partner

Matt Putra is the Managing Partner of Eightx and a fractional CFO for eCommerce and CPG brands. A former PE investor with $500M+ deployed, Matt has served as fractional CFO for 35+ brands with $650M+ in combined revenue. He specialises in structural financial redesign for $5M–$50M DTC and CPG brands — unit economics, cash flow architecture, and the sequencing decisions that determine whether growth is durable or fragile.

Want results like these?

Get Your Free
Profit Audit

30-minute call. We’ll find at least one profit leak in your business—no strings attached.

Talk to a CFO