What's the best way to track Amazon seller fees in QuickBooks?
The challenge with Amazon is that they don’t deposit your gross sales. They deposit a net amount after subtracting fees, refunds, and other adjustments. A single deposit might represent hundreds of transactions, and without breaking it apart, you’re left looking at one number that tells you nothing about where your money actually went.
Amazon charges several categories of fees. Referral fees are the percentage cut on each sale. FBA fulfillment fees cover pick, pack, and ship. Storage fees hit you monthly and spike during Q4. If you run Sponsored Products campaigns, advertising costs come out of your settlements too. Then there are smaller charges for things like removals, long-term storage penalties, and returns processing. Each of these eats into your margins differently, and you can’t optimize what you can’t measure.
The manual approach involves downloading your Settlement Report from Seller Central and breaking it down yourself in QuickBooks. Create a journal entry for each settlement that debits your bank account for the deposit amount, credits Sales for the gross amount, and debits individual expense accounts for each fee category. This works but takes real time, especially if you have multiple settlements per month across different marketplaces.
A cleaner manual method uses a clearing account. Record the gross sales and each fee type against this clearing account, then record the actual bank deposit against the same account. When everything is entered correctly, the clearing account zeros out. If it doesn’t balance, something got miscoded and you know to investigate.
The automated approach uses integration tools like A2X or Link My Books. These apps connect to your Amazon account, pull settlement data, and post properly categorized journal entries directly to QuickBooks. Setup takes an hour or two, but after that it runs with minimal intervention. For e-commerce sellers with significant volume, the monthly cost of these tools usually pays for itself in time savings.
Which approach makes sense depends on your volume and complexity. A seller with one product line doing a few settlements per month can handle it manually. Someone selling hundreds of SKUs across multiple Amazon marketplaces needs automation or a dedicated bookkeeper.
The important thing is tracking these fees consistently over time. Referral fees and FBA costs are typically your largest Amazon-specific expenses. If you’re not breaking them out, your profit margins are guesses. And when tax time comes, you want clean records showing exactly what you paid so you’re not missing legitimate deductions. If this feels overwhelming, Phoenix area bookkeeping services that understand Amazon can set up the right structure and handle it monthly.
Full-Service Bookkeeping for Greater Phoenix
The Next Step:
A Quick Conversation
Tell us about your situation. We'll listen, ask a few questions, and give you a clear price to handle the work.
More Questions
Do I need separate bookkeeping for each Amazon marketplace?
No, most Amazon sellers can run all marketplaces through one set of books. The key is structuring your accounting software to track each marketplace separately using classes or locations, so you can see profitability by region.
Read answerHow do I calculate my actual profit margin on Amazon?
To calculate true Amazon profit margin, subtract all costs from revenue including product cost, Amazon fees, advertising, storage, and returns. Most sellers underestimate costs and overestimate margins.
Read answerHow do I track sales tax liability in my books?
Sales tax collected from customers is a liability, not revenue. Track it in a separate payable account that increases with each taxable sale and decreases when you remit payment to the state.
Read answerWhat's the best accounting software for small business?
QuickBooks Online is the standard for most small businesses. It integrates with banks, apps, and payment processors, and accountants know it well. But the software matters less than how it's configured for your specific needs.
Read answerHow do I handle Arizona sales tax collection?
Register for a Transaction Privilege Tax license with the Arizona Department of Revenue, then collect at the combined state, county, and city rates based on where your business is located. Arizona uses an origin-based system, so your location determines which rates apply for most in-person sales.
Read answerHow do I do bookkeeping for a retail store?
Retail bookkeeping centers on tracking sales from your point of sale system, managing inventory costs, reconciling cash, and handling sales tax. The key is connecting your daily sales activity to accurate cost of goods sold calculations.
Read answer