How to Record Amazon Sales in QuickBooks Online (2026)

In this guide
The quick answer
How do you record Amazon sales in QuickBooks Online?
You can record Amazon sales manually from settlement reports, use QuickBooks Online's Amazon connector, or automate settlement bookkeeping with Link My Books. Whichever method you choose, separate gross sales, refunds, fees, and taxes, then match the net payout to your bank deposit. Never count the deposit as a second sale.
An Amazon payout rarely tells the whole story of what your store earned. Amazon collects money from customers, deducts fees and other adjustments, and transfers the balance to you. If you enter only that deposit as income, your QuickBooks reports can miss both sales and expenses.
I made the short video below to answer a common seller question: how can you get Amazon sales into QuickBooks Online without spending hours copying numbers? My suggestion is to understand one settlement first, then choose the method that fits your order volume and accounting needs.
Affiliate disclosure
Some links in this guide are affiliate links. If you subscribe through them, I may earn a commission at no extra cost to you. Read my affiliate disclosure.
Why an Amazon deposit is not the same as Amazon sales
Imagine customers purchase $10,000 worth of products, but only $7,500 arrives in your bank. That difference does not automatically mean $2,500 in missing sales. It may reflect refunds, referral fees, FBA fulfillment fees, advertising charges, or other adjustments Amazon applies before paying you.
Good bookkeeping preserves the separate pieces. Gross sales explain what customers bought. Refunds reverse relevant sales. Marketplace fees show what selling through Amazon costs. Tax amounts need treatment appropriate to the seller's jurisdiction and whether Amazon collects or remits them. Net settlement is the amount to reconcile with cash received.
Gross sales
The amount sold before refunds and seller costs.
Deductions
Fees, refunds, and adjustments in the settlement.
Bank payout
Cash transferred after the included deductions.
One more distinction matters: cash received is not necessarily profit. Product costs, freight, software, payroll, and expenses outside the Amazon settlement may still need recording.
How to record Amazon sales manually in QuickBooks Online
Manual bookkeeping can work if you have a manageable number of settlements and are comfortable with accounting entries. The key is to use the Amazon settlement report rather than guessing the sales amount from your bank feed.
- Download the settlement report. In Amazon Seller Central, find the relevant payment or settlement report and note its period, marketplace, currency, and payout identifier.
- Review every category. Identify sales, refunds, shipping income if applicable, referral and fulfillment fees, taxes, reserves, reimbursements, and other adjustments. Don't treat every line as revenue.
- Choose the correct QuickBooks accounts. Work with your bookkeeper to map sales, expenses, taxes, clearing or bank accounts, and any amounts Amazon still holds.
- Record the balanced settlement. Enter an appropriate summary transaction or journal entry for your bookkeeping method. Check that its debits and credits balance and the payout component agrees with Amazon.
- Match the actual deposit. When the bank feed imports Amazon's payment, match it to the previously recorded settlement; don't create another income transaction.
Manual entries take extra care when a settlement spans two months, includes several marketplaces, or uses more than one currency. If those situations are common, an automated workflow may be worth testing.
Free trial and reader discount
Try Link My Books before committing
Free trial
Explore the Amazon-to-QuickBooks workflow before choosing a subscription.
VOVA20
50% off the first three months of an eligible monthly subscription.
Start my Link My Books free trial
Enter VOVA20 when subscribing. The advertised 50% offer is for eligible new customers on monthly plans, not annual plans, and cannot be combined with other promotions. Confirm the discount at checkout.
How to connect Amazon and QuickBooks through Link My Books
Link My Books sits between Seller Central and QuickBooks Online. It imports Amazon settlement data, categorizes the activity, and posts accounting summaries to QuickBooks. Unlike an individual-order import, its QuickBooks output is a sales journal for each settlement, with an audit report linked for review.
Daniel Little, the co-founder of Link My Books, walks through the platform with me in the longer tutorial further down. Here is the practical setup sequence based on the official connection guide.
- Create an account and choose Amazon. Start with the free trial and select Amazon as your sales channel.
- Select the Amazon region. Give the connection a recognizable name, choose the correct region, and follow the prompts to authorize Link My Books in Seller Central. One region may cover multiple Amazon marketplaces.
- Connect QuickBooks Online. Choose QuickBooks as your accounting platform, sign in, select the correct company, and approve the requested connection.
- Complete Accounts & Taxes. Check the suggested account mappings, the bank accounts used for Amazon payments, any applicable VAT registration information, and the tax rates. Don't accept defaults without reviewing whether they fit your business.
- Inspect the first settlement. Check the sales, refunds, fees, taxes, dates, and bank payout before selecting Send to QuickBooks. Review the linked journal in QuickBooks.
- Automate only after checking. Once you are satisfied with the first entries, you can enable Auto Post Settlements in Settlement Settings for new ready-to-post settlements.
Important setup check: Link My Books offers suggestions for account and tax mapping, but the right treatment depends on your location, registrations, and accounting policies. Ask your accountant to verify the mapping before automatically posting historical data.
For screenshots of the tax configuration, use the Amazon and QuickBooks Accounts & Taxes wizard.
Amazon settlement example: from gross revenue to bank deposit
Let's make the numbers concrete. The amounts below are a fictional USD settlement for a single marketplace. To keep the example simple, assume the advertising charge was deducted in this same settlement and there were no tax, reserve, or currency-conversion adjustments.
| Settlement component | Illustrative amount |
|---|---|
| Gross product sales | $10,000 |
| Customer refunds | -$400 |
| Referral and fulfillment fees | -$1,500 |
| Advertising deducted by Amazon | -$600 |
| Net bank payout | $7,500 |
That $7,500 is what should match the incoming Amazon payment. It does not replace the $10,000 sales figure. If product costs for those sold units were $2,500, the example would leave $5,000 after the displayed deductions and product costs, but before other operating expenses and taxes. That is not necessarily final net profit.
Real settlements may also include withholding, reserves, reimbursements, shipping, gift wrapping, VAT or sales tax, and exchange-rate differences. Always use the actual report rather than copying the categories from this illustration.
How to reconcile Amazon payouts in QuickBooks correctly
Reconciliation is where your settlement bookkeeping meets the real bank transaction. After Link My Books posts the sales journal, the corresponding Amazon bank payment should be available to match in the QuickBooks bank feed.
Open Bank transactions in QuickBooks, locate the Amazon deposit, and inspect the suggested match. Compare the amount, date, currency, and settlement reference before selecting Match. If there is no suggestion, review the journal, bank account mapping, and currency settings. For foreign-currency payouts, you may need the additional matching steps in the official reconciliation guide.
Match, don't add again. If the settlement entry already represents the payout, adding the bank feed deposit as new sales income duplicates revenue.
Also check whether Amazon advertising was deducted from the settlement or charged separately to a card. Recording the same advertising cost in both places is another way to overstate expenses.
Manual entry, the QuickBooks connector, or Link My Books?
The original video focuses on manual bookkeeping and Link My Books. There is also a current third option: Intuit's Amazon Marketplace Connector for QuickBooks Online. Its workflow imports individual sales, refunds, fees, and payouts for review and reconciliation. Availability and behavior can vary by account and region.
| Method | How it records activity | Worth considering when |
|---|---|---|
| Manual | You build entries from Amazon reports. | You have low volume and an established bookkeeping process. |
| QuickBooks connector | Imports transaction-level activity and payouts. | You want to use the integration available in your QuickBooks account. |
| Link My Books | Creates categorized settlement sales journals. | You prefer payout summaries and multi-channel bookkeeping workflows. |
Do not run two Amazon import methods over the same dates without a clear migration plan. Both could record the same activity. Choose one primary process, review historical entries, and agree on a cutoff date before switching.
Watch the full Link My Books tutorial with Daniel Little
For a more complete look at the platform, I recorded a longer walkthrough with Daniel Little, Link My Books' co-founder. It covers the dashboard, connecting sales channels, and setting up bookkeeping workflows. The demonstration includes examples from Xero, so use the QuickBooks-specific steps and help links above for the exact QuickBooks journal and bank-matching process.
For a related comparison of subscription options, see my Link My Books pricing guide. The amount you actually pay depends on your current plan, order volume, and the discount confirmed at checkout.
Monthly checks that keep Amazon bookkeeping accurate
Automation saves repetitive work, but I would still review the finished books. Compare Amazon's settlement totals to the entries in QuickBooks, investigate unmatched deposits, and make sure refunds and marketplace fees land in the accounts you expect.
- Check unsettled balances. Money held in Amazon reserves or pending payouts may require separate treatment.
- Review product costs. Link My Books offers COGS tracking, but accurate results depend on correct SKU costs and settings.
- Watch period cutoffs. A payout spanning two months may need allocation to the appropriate accounting periods.
- Verify tax mapping. A tool can categorize transactions; it cannot determine your obligations without the right business information.
- Investigate duplicates. Check manual journals, connector imports, and bank-feed additions if income seems unusually high.
A repeatable review is especially useful when you add another marketplace or ask a bookkeeper to take over the process. The goal is a trail that explains each payout, not just a dashboard with attractive numbers.
Ready to test the workflow?
Link My Books free trial + VOVA20
Connect a real Amazon settlement, inspect the QuickBooks journal, and see whether the workflow fits your business. If you choose an eligible monthly plan, use VOVA20 for 50% off your first three months.
Offer terms and eligibility are determined at checkout. The discount is advertised for new monthly subscribers and does not apply to annual billing.
Frequently asked questions about Amazon sales in QuickBooks
Can QuickBooks Online import Amazon sales automatically?
Yes. QuickBooks offers an Amazon connector for supported accounts, and third-party tools such as Link My Books can also automate imports. Their recording methods differ, so choose one workflow and review account mapping before enabling automatic posting.
Should I record gross Amazon sales or only the payout?
Record the underlying sales, refunds, applicable taxes, fees, and adjustments in the appropriate accounts. The payout is a cash movement to reconcile, not a replacement for the sales breakdown.
Does Link My Books replace QuickBooks Online?
No. Link My Books is an integration and bookkeeping automation service. QuickBooks remains your accounting platform, where the posted entries and bank reconciliations are recorded.
Does Link My Books calculate Amazon profit automatically?
It can support COGS tracking and reporting when configured, but profit accuracy still depends on correct product costs, taxes, fees, and any overhead recorded outside Amazon.
How do I use the VOVA20 discount?
Start from the Link My Books free trial offer, choose an eligible monthly subscription, and enter VOVA20 in the coupon field. Confirm that the advertised 50% discount appears for the first three months before subscribing.
My final suggestion: start with one settlement that you can verify from beginning to end. When the gross sales, deductions, QuickBooks entry, and bank payment all agree, you have the foundation for a reliable Amazon bookkeeping routine. Whether you stay manual or automate with Link My Books, that confidence is what makes the numbers useful.