Bookkeeping, payroll, and controller services for small businesses in Scottsdale and Greater Phoenix.

Call or Text: (623) 439-9961

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

What bookkeeping tasks should be done weekly vs monthly?

Weekly tasks focus on keeping transactions current and catching issues early. Monthly tasks involve full reconciliations, financial statement review, and closing out the period properly.

Read answer

How do I account for Amazon advertising costs in my books?

Record Amazon advertising costs as a marketing expense, separate from your cost of goods and Amazon seller fees. The tricky part is extracting clean data since Amazon deducts ad spend from your settlements before depositing to your bank.

Read answer

How do I fix duplicate transactions in QuickBooks?

Duplicates happen when the same transaction enters QuickBooks twice, usually from manual entry combined with bank feeds. Find them in the Banking section or account registers, then delete the duplicate or use the Match function to link records correctly.

Read answer

Should my retail store use cash or accrual accounting?

Most small retail stores can use cash accounting for simplicity, but accrual gives you a clearer picture of profitability when you carry significant inventory. The right choice depends on your size, inventory levels, and growth plans.

Read answer

How do I value inventory for my online retail business?

Most e-commerce businesses use FIFO (First In, First Out) to value inventory. This method assumes you sell your oldest inventory first, which typically matches how online retail works and simplifies compliance.

Read answer

Do Arizona businesses have special bookkeeping requirements?

Arizona's Transaction Privilege Tax creates unique bookkeeping needs because rates vary by city. Tracking TPT by jurisdiction and filing on the correct schedule are the main Arizona-specific requirements.

Read answer

Scottsdale bookkeeping firm serving small businesses across Greater Phoenix. Full-service bookkeeping, payroll, and outsourced controller services backed by over a decade of hands-on accounting experience.

Client Reviews

5-Star Rated Firm

Social

© 2026 LedgeTrakr Bookkeeping