Amazon Accounting Software: QuickBooks, Xero & Link My Books

In this guide
The quick answer
What accounting and bookkeeping software works with Amazon?
Amazon sellers can use QuickBooks Online or Xero for accounting, connected through Link My Books. The integration organizes Amazon payouts into sales, refunds, marketplace fees, and tax categories, then posts settlement summaries to the accounting platform. It also helps match those summaries with deposits. That means less manual entry, provided your setup and tax mappings are correct.
An Amazon deposit looks like one number in your bank account, but it represents many different transactions. Product revenue, customer refunds, referral fees, FBA charges, and taxes may all affect the final amount. Recording that entire deposit as sales can make your books misleading.
In my short video, I explain how Link My Books connects Amazon with Xero or QuickBooks Online. This guide takes that explanation further: what gets synchronized, which platform to choose, how the setup works, and what to check before enabling automation.
Affiliate disclosure: Some links in this article are affiliate links. If you subscribe through them, I may earn a commission at no additional cost to you. Read my full disclosure.
Watch by video chapter and timestamp
Why Amazon payouts make bookkeeping complicated
Amazon commonly pays sellers a net settlement rather than transferring each order's gross sale amount separately. Imagine a settlement with $2,000 in sales, $200 in refunds, and $300 in marketplace fees. If those were the only deductions, the deposit would be $1,500. These figures are illustrative, not a report from a real seller.
Entering $1,500 as revenue would conceal $500 worth of important activity. You would lose sight of the original sales, refunds, and fees. In reality, settlements may also contain advertising charges, reimbursements, reserves, and taxes. The breakdown matters for profit reporting and tax records.
This is the problem an integration solves. It reads Amazon settlement reports and groups the relevant transactions into accounting categories. You still have to review the categories and keep other business expenses up to date, but you no longer need to reconstruct each payout by hand.
Timing can make the numbers look confusing, too. An Amazon settlement period may overlap two calendar months, while the money may arrive in the bank on a different date. If you compare a single payout with a monthly sales dashboard, the amounts will not necessarily match. A reliable bookkeeping process records what belongs in each period and leaves a clear trail back to Amazon's underlying reports.
Important distinction: An Amazon bank deposit is not the same as Amazon sales revenue. Reconciliation should explain how the gross activity leads to the net amount received.
QuickBooks Online vs. Xero vs. Link My Books
These products do different jobs. QuickBooks Online and Xero are accounting platforms where you maintain records, reconcile accounts, and prepare financial statements. Link My Books is a specialized ecommerce connector that moves summarized marketplace data into either platform. It complements accounting software rather than replacing it.
| Software | Main role | Amazon workflow |
|---|---|---|
| QuickBooks Online | Accounting and reporting | Receives settlement sales journals from Link My Books |
| Xero | Accounting and reporting | Receives summarized settlement invoices from Link My Books |
| Link My Books | Ecommerce data integration | Imports, categorizes, and posts Amazon settlement summaries |
Which accounting platform should you choose? If your business or accountant already uses QuickBooks Online or Xero successfully, there is usually little reason to switch solely to connect Amazon. Check your existing chart of accounts, reporting requirements, accountant preferences, and subscription costs before deciding.
Link My Books documents the different posting formats in its Xero and QuickBooks data guide. The important outcome is the same: your accounts should explain the settlement, not just the deposit.
What Link My Books actually syncs from Amazon
The core workflow begins with an Amazon settlement. Link My Books imports that settlement, separates its components, and prepares a summary for your connected accounting software. Depending on the data and settings, categories can include sales, refunds, Amazon selling fees, FBA charges, advertising costs, reimbursements, and tax-related entries.
It then posts the summarized data to Xero or QuickBooks through their integrations. The resulting entry is designed to reconcile with the relevant Amazon payout. In straightforward, same-currency cases, the accounting platform can suggest a matching bank transaction; cross-currency payments and wallet transfers may need extra attention.
1 · Import
Collect Amazon's settlement report and identify the transactions behind the payout.
2 · Categorize
Allocate sales, refunds, fees, and taxes according to your configured accounts and rates.
3 · Reconcile
Post the summary and check it against the deposit or the appropriate clearing account.
Automatic posting is useful once the mappings have been reviewed. For a new connection, I would send and check the first settlement manually before enabling the autopilot setting. That small review helps catch an incorrectly selected tax rate or account before it affects additional periods.
Link My Books reader offer
Try automated Amazon bookkeeping before committing
VOVA20
Advertised 50% off your first 3 months on an eligible monthly plan
Free trial
Explore the integration and request complimentary onboarding support
Confirm coupon eligibility, onboarding availability, and the renewal price during signup. The discount is not a permanent 50% reduction.
How to connect Amazon to Xero or QuickBooks with Link My Books
A typical setup follows six stages. The exact screens may change, but Link My Books maintains an official connection walkthrough for the current process.
- Open your account. Start a free trial, sign in, and choose to add Amazon as a sales channel.
- Select your Amazon region. Choose the region containing your marketplace and give the connection a recognizable name. Authorize access through Amazon's sign-in flow.
- Connect Xero or QuickBooks Online. Sign in to the bookkeeping platform you already use, and approve the relevant connection.
- Review accounts and tax settings. Map sales, refunds, and fees to the appropriate chart-of-accounts categories. Confirm tax treatment with your accountant.
- Inspect the first settlement. Compare the summary against Seller Central records. Review the payout amount, transaction categories, and any currency differences.
- Enable automation when ready. Turn on automatic settlement posting if the test looks correct, then check the first bank match and review subsequent periods.
Link My Books can support multiple Amazon regions, so make sure you select the one that corresponds to the business you are reconciling. If you also sell in another region, verify how it should appear in your accounts before adding more connections.
The setup does not mean every expense is automatically covered. Supplier invoices, some overheads, payroll, and other costs may still need to be recorded elsewhere. Use the integration to handle marketplace settlement data, then maintain the rest of your bookkeeping normally.
Two complete Link My Books tutorials: choose your role
The main video introduces the software in just over two minutes. For a practical walkthrough, I recorded longer sessions with Daniel Little, co-founder of Link My Books. Choose the one closest to your day-to-day work.
For ecommerce sellers · Approximately 30 minutes
We go through the seller workflow from setup to settlements, accounting mappings, pricing, and onboarding. It is a useful next step if you are connecting your own Amazon business.
For accountants and bookkeepers · Approximately 41 minutes
This session focuses on handling ecommerce clients, account setup, reconciliation, and a more repeatable practice workflow. It is designed for professionals who oversee multiple businesses.
Does Link My Books work beyond Amazon?
Yes. As covered in the video, the software also connects supported Shopify, eBay, Etsy, Walmart, TikTok Shop, Square, and WooCommerce accounts with Xero or QuickBooks. The purpose stays similar: turn marketplace or payment-channel activity into clearer accounting entries.
Not every integration handles every platform in exactly the same way. Shopify, for example, can involve Shopify Payments alongside other payment gateways. Walmart support is also marketplace-specific; the current setup guide says Walmart Canada is not supported. Check your country and sales channel before making it part of your accounting plan.
For a multichannel seller, the advantage is consistency. Instead of collecting unrelated spreadsheets from each platform, you can establish an organized posting process for every supported channel. That also makes it easier for an accountant to compare performance without rebuilding the reports every month.
Before connecting everything, list your active marketplaces, average monthly order volume, and the number of accounting entities involved. These details help you compare subscription allowances and avoid paying for connections you do not need. I would introduce one channel at a time, verify its first posted summary, and then move to the next. A careful rollout is easier to troubleshoot than several new feeds running together.
What about VAT, GST, sales tax, and reconciliation?
Link My Books includes tax-mapping options for VAT, GST, and sales tax. That is helpful when sales and fees need different tax treatments, but the results depend on choosing the correct settings for your business and jurisdiction. Automation does not determine your legal tax obligations or replace professional advice.
Reconciliation deserves the same attention. Most sellers want the summary in Xero or QuickBooks to agree with the payout from Amazon. If a settlement is paid in another currency, or into Amazon Seller Wallet rather than directly into a bank account, the matching process can require additional accounts and steps.
If you use Seller Wallet, review Link My Books' current wallet reconciliation guidance. The objective is clear records, not simply turning on an automation switch and never checking it again.
Free trial, onboarding, and VOVA20
See how your Amazon payouts look when they are organized
Use the trial to connect a real settlement, inspect the accounting breakdown, and request free onboarding. If you continue on an eligible monthly subscription, apply VOVA20 for the advertised 50% discount for the first three months.
Explore Link My Books free trial and discountThe standard trial has been advertised as 14 days. Confirm the current trial, coupon conditions, onboarding, and full renewal cost before subscribing.
Frequently asked questions about Amazon accounting software
Can I connect Amazon directly to QuickBooks Online?
There are different ways to bring Amazon information into QuickBooks. Link My Books is one option specifically designed to summarize settlements, categorize their components, and support payout reconciliation. Compare the depth of the integration before choosing a workflow.
Does Link My Books replace Xero or QuickBooks?
No. It connects ecommerce sales channels to those accounting platforms. You still use Xero or QuickBooks for your main books, other expenses, and financial reporting.
Does it import each Amazon order individually?
Its primary workflow uses Amazon settlement reports and posts summarized accounting entries rather than filling the ledger with a separate entry for every order. Detailed reports remain available for checking the underlying figures.
Can an accountant manage several ecommerce clients?
Yes. Link My Books is intended for sellers and accounting professionals. Multiple clients and channels can be managed through supported connections, with plan allowances and permissions checked during setup.
Is the VOVA20 coupon a lifetime discount?
No. The advertised offer is 50% off for the first three months of an eligible monthly subscription, not a lifetime discount. Check that it is accepted and review the price after the promotional period.
My recommendation for Amazon sellers
Start with the accounting system you or your accountant can maintain confidently. If that is Xero or QuickBooks Online, use Link My Books to test whether settlement automation removes the repetitive work from your Amazon bookkeeping. Review a real payout, confirm the tax mapping, and see whether reconciliation becomes simpler.
The goal is not more software for its own sake. It is dependable financial information that helps you understand what you sold, what Amazon deducted, and what actually reached your account. I hope the video, tutorials, and walkthrough make that process easier.