The Amazon Reconciliation Headache: Beyond the Net Deposit
If you sell on Amazon, you know the bi-weekly routine: Amazon deposits a lump sum into your bank account. That deposit represents your net payout—what is left after Amazon aggregates your sales, deducts refunds, and collects a wide array of fees.
If you are trying to figure out how to handle Amazon FBA fees when reconciling in QuickBooks, the temptation is to simply record this net deposit as a single line item called “Amazon Sales.”
While this is quick, it is a significant accounting mistake. Under-reporting your Gross Revenue and ignoring the underlying expense breakdown leads to serious problems:
- Tax Compliance Issues: The IRS expects you to report Gross Sales and then deduct expenses. Booking net deposits under-reports gross sales and hides deductible business expenses.
- Business Valuation Pitfalls: If you ever plan to sell your business, aggregators or investors will require clean, accrual-based financial statements with accurate Gross Sales, Cost of Goods Sold (COGS), and clear fee breakdowns.
- Operational Blindness: If all fees are lumped together, you cannot see whether your storage costs, ad spend, or refund rates are eroding your margins.
To build an investor-ready business, you must record gross revenue, break down Amazon fees into specific expense accounts, and reconcile your payouts systematically.
1. Demystifying Amazon FBA Fees
Amazon charges dozens of different fees. Lumping them into a single general “Amazon Fees” account makes optimization impossible. You should map the major Amazon fee categories to specific expense accounts in QuickBooks:
Referral Fees
This is Amazon’s commission for bringing you the customer, usually around 15% of the sales price. Map this to an expense account named Selling Fees or Amazon Referral Fees to track the direct cost of using the channel.
FBA Fulfillment Fees (Pick and Pack)
The variable cost for Amazon to pick, pack, and ship your product. It varies by product weight and size. Map this to Fulfillment Costs or FBA Shipping Expenses to keep it separate from your regular shipping income or outbound freight.
FBA Storage Fees
Amazon charges you to store items in their fulfillment centers. You should track these under Storage/Warehousing Expenses:
- Monthly Storage Fees: Charged mid-month for the preceding month’s space.
- Aged Inventory Surcharges (Long-Term Storage): Charged for inventory held for over 181 days.
Advertising (PPC) Costs
Amazon Pay-Per-Click ad spend is often deducted directly from your settlement balance. You must “gross up” this spend by recording it as a Marketing or Advertising expense so you can monitor your true advertising return on investment (ROI).
Refund Administration Fees
When you refund a customer, Amazon retains a small administration fee (typically $5.00 or 20% of the referral fee, whichever is less). Map these small charges to Refund Admin Fees or Merchant Account Fees.
Marketplace Facilitator Tax
Amazon collects and remits sales tax automatically in most states. Because this tax is deducted from your payout, it must be excluded from gross revenue. Treating it as a “wash” transaction ensures your top-line revenue is not artificially inflated.
2. The Solution: The Amazon Balance Holding Account
How do you record daily sales and fees in QuickBooks without creating timing mismatches and reconciliation chaos?
You use a holding account (also known as a clearing or balance account). In QuickBooks Online, this is set up as a Bank or Other Current Asset account, typically named Amazon Balance.
Instead of posting transactions directly to your business checking account, you route everything through this holding account:
graph TD
Sales[Daily Sales] -->|Post Debit| Clearing[Amazon Balance Account]
Fees[Daily Fees & Refunds] -->|Post Credit| Clearing
Deposit[Net Deposit from Amazon] -->|Transfer Out| Clearing
Clearing -->|Nets to Zero| Reconciled[Checking Account]Step-by-Step Clearing Account Workflow
- Post Revenue and Fees: As sales and refunds occur, record the gross transactions and associate fees in the Amazon Balance account.
- Clear the Balance on Payout: When Amazon deposits your bi-weekly payout into your business checking account, record the deposit as a transfer from the Amazon Balance account to your Checking account.
- Reconcile: The transfer should match the remaining balance of the settlement period, bringing the holding account’s balance back to zero (or your rolling reserve balance).
3. Resolving the Mismatch: Calendar vs. Statement Dates
Amazon operates on a bi-weekly (14-day) payout cycle, which rarely aligns with calendar months. If a settlement cycle runs from January 14th to January 28th and the money hits your bank on February 1st, a cash-basis seller will record all of that revenue in February.
This distorts your P&L, making January look artificially low and February look artificially high.
True Accrual vs. Simulated Accrual
To get accurate monthly reporting, you need accrual accounting:
- Statement-Based Summaries (Simulated Accrual): Some accounting tools only import data once every 14 days when a settlement closes. If the statement straddles two months, they split the journal entries or rely on deferred income month-end adjustments. While this is a common workaround, it leaves your books stale for up to two weeks.
- Daily Accrual Summaries (True Accrual): A superior method is posting consolidated daily summaries. By pulling sales, refunds, and order fees daily, your revenue is recognized on the exact day of shipment. The Amazon Balance account holds these records, and the bi-weekly settlement deposit clears them out.
The “Split Day” Problem
When a settlement closes in the middle of a day, daily summaries must be split. A robust integration automatically creates two separate daily summaries for that day—one marked for the closing statement and one for the opening statement. This ensures the closed statement reconciles to the penny.
4. Automating the Process: How Entriwise Eliminates the Manual Work
Manually mapping every fee, posting daily summaries, and splitting transactions on statement days is incredibly labor-intensive.
This is where accounting automation software like Entriwise becomes essential.
Entriwise integrates your Amazon Seller Central QuickBooks Online integration to handle the complexity automatically:
- Automated Fee Mapping: During setup, Entriwise automatically creates the necessary Service Items and Expense Accounts in QuickBooks Online, mapping each Amazon fee to its correct location.
- Daily Consolidated Summaries: To prevent database bloat, Entriwise groups sales by SKU into daily Sales Receipts. It records order-related fees as daily summaries, keeping QuickBooks fast and performant.
- Native Transactions, Not Abstract Journals: While basic connectors create summarized journal entries, Entriwise creates native accounting transactions (like Sales Receipts and Bills). This keeps customer workflows intact and provides an audit-friendly trail.
- Integrated COGS and Inventory: Entriwise links Amazon SKUs to QuickBooks inventory items, automatically deducting stock and calculating Cost of Goods Sold (COGS) using QuickBooks’ native FIFO costing method.
By combining automated fee categorization, clearing account reconciliation, and daily accrual summaries, Entriwise ensures your books are always current, tax-compliant, and audit-ready.
Conclusion: Build on a Solid Financial Foundation
Reconciling Amazon FBA fees doesn’t have to be a source of monthly stress. By shifting away from booking net deposits, setting up an Amazon Balance clearing account, and mapping fees to specific expense categories, you gain total clarity over your margins.
If you are ready to automate your Amazon accounting, explore how the Entriwise Amazon Seller Central integration can streamline your workflow, keep your books clean, and unlock SKU-level profitability.
Ready to simplify your ecommerce bookkeeping? View Entriwise pricing or sign up for a free trial.
Frequently Asked Questions
How do I handle Amazon FBA fees when reconciling in QuickBooks?
The best way to handle Amazon FBA fees when reconciling in QuickBooks is to map each fee type (referral fees, FBA fulfillment, storage, and ad spend) to a separate QuickBooks expense account. Do not book them to a single lump-sum account or net them against sales. Instead, record the daily gross sales and gross fees using a holding/clearing account (like an Amazon Balance account) and clear that account when the bi-weekly settlement payout deposits to your bank.
Should I import individual Amazon orders to QuickBooks?
No. High transaction volumes will slow down QuickBooks performance and make manual bank reconciliation virtually impossible. Instead, use consolidated daily summaries that record sales and fees at the SKU level. This keeps your books clean, performant, and accurate.
Why does my Amazon settlement not match my bank deposit?
This timing mismatch happens because Amazon’s 14-day settlement cycles rarely align with calendar months or bank deposit dates. By using an accrual-based clearing account (e.g., an Amazon Balance account), you can record sales and fees on the days they actually occur and transfer the net payout when it hits your bank account, resolving the mismatch automatically.