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
How do I do bookkeeping for my Amazon FBA business?
The key is understanding that Amazon deposits aren't your revenue. They're the net result after fees, refunds, and deductions. You need integration software to break down settlements properly and careful tracking of inventory costs.
Read answerWhat bookkeeping records should a retail store keep?
Keep everything related to money coming in and going out. Sales reports, vendor invoices, inventory records, bank statements, payroll documents, and tax filings. The key is organizing them consistently and knowing how long each type needs to be retained.
Read answerWhat happens if I don't pay payroll taxes on time?
The IRS imposes escalating penalties starting at 2% for deposits 1-5 days late, up to 15% for amounts unpaid after notice. The trust fund recovery penalty makes owners personally liable for 100% of unpaid withholding taxes.
Read answerHow do I separate business and personal expenses?
Open a dedicated business bank account and credit card, then use them exclusively for business transactions. Pay yourself through owner's draws or salary rather than paying personal bills directly from the business.
Read answerHow do I track sales by department or product category?
Set up classes or product categories in your accounting software and assign them consistently to every sale. This gives you profit and loss reports broken down by department so you can see what's actually making money.
Read answerHow often should I reconcile my e-commerce accounts?
Weekly reconciliation works best for most e-commerce businesses. The transaction volume and complexity of multiple platforms, payment processors, and fee structures make monthly reconciliation too risky. Problems are much harder to track down weeks after they happen.
Read answer