Best Amazon Payment Reconciliation Software | Link My Books

In this guide
The quick answer
What is the best Amazon payment reconciliation software?
Link My Books is a strong option for Amazon sellers who use Xero or QuickBooks Online. It imports Amazon settlement information, organizes sales, refunds, fees, and taxes, and sends accounting entries designed to match marketplace payouts with deposits. It also supports other ecommerce channels. A free trial, bookable onboarding, and the VOVA20 offer make it practical to test before subscribing.
An Amazon payout rarely equals the total sales shown in Seller Central. Refunds, selling fees, fulfillment charges, taxes, and other adjustments can change what reaches your bank. If you record the deposit as sales revenue, the books can become misleading.
The goal of Amazon payment reconciliation is to explain that difference, not merely make two numbers look equal. This guide covers how Link My Books works, its Amazon-to-Xero and Amazon-to-QuickBooks integrations, supported marketplaces, the free trial, and a sensible setup routine for sellers and accountants.
Affiliate disclosure
Some links in this article are affiliate links. If you subscribe through them, I may earn a commission at no extra cost to you. This helps support my free ecommerce tutorials. Read my full disclosure.
Why Amazon payouts need reconciling
Amazon collects money from customers, makes deductions or adjustments, and then disburses the remaining amount. Your accounting records need to preserve the components of that settlement. Otherwise, important expenses disappear into a single bank deposit, making revenue, margins, and tax reporting harder to understand.
Consider this simplified illustration. These figures are invented to explain the arithmetic, not taken from a real seller account.
| Settlement component | Illustrative amount | Accounting meaning |
|---|---|---|
| Customer sales | $10,000 | Gross sales before deductions |
| Refunds | -$500 | Returned customer payments |
| Amazon fees | -$1,500 | Marketplace and fulfillment charges |
| Other adjustments | -$200 | Illustrative settlement deductions |
| Bank payout | $7,800 | Amount to match against the deposit |
Here, $7,800 is the payout, not total sales or net profit. Product costs, advertising outside the settlement, overhead, and applicable tax treatment still need attention. A reconciliation system should help explain the deposit while preserving the correct accounting categories.
How does Link My Books reconcile Amazon payments?
Link My Books works from marketplace settlement data, rather than guessing revenue from an estimated sales dashboard. For Amazon, it processes settlement reports and prepares summaries that can be posted into your connected accounting system.
- Connect Amazon. Authorize the relevant Amazon selling region through the secure connection process.
- Connect your accounting platform. Choose Xero or QuickBooks Online and permit the integration.
- Map accounts and taxes. Decide where revenue, refunds, fees, and applicable taxes belong in your chart of accounts.
- Review the settlement. Inspect the breakdown and send the resulting entry manually, or enable automatic posting after verifying the setup.
- Match the bank deposit. Use the corresponding entry in Xero or QuickBooks to reconcile the money received from Amazon.
This is the practical distinction between automated bookkeeping and merely exporting a spreadsheet. The relevant transactions flow into the accounts where they belong, instead of sitting in a report that someone must rebuild every month.
For the technical details, the official data-posting guide explains the records created in each accounting platform.
Special Link My Books offer
Try the software before committing
Free trial
Explore the payout workflow, connect your accounts, and book a free one-to-one onboarding call.
VOVA20 · 50% off
For the first three months on eligible new monthly subscriptions. Confirm the code is accepted at checkout.
Use coupon VOVA20 when subscribing. The offer is for eligible new customers and cannot be combined with other promotions.
Amazon to Xero vs. Amazon to QuickBooks
The same Amazon settlement can be represented differently depending on your accounting software. With Xero, Link My Books creates a settlement invoice that can be matched with the incoming bank transaction. With QuickBooks Online, it creates a sales journal that you match against the corresponding payout.
That distinction matters when you are watching a tutorial and the screen does not look like yours. In either system, the aim is to account for the underlying transactions while making reconciliation straightforward. Multi-currency deposits, clearing accounts, and Amazon Seller Wallet may require additional configuration.
Important compatibility point: Link My Books works with QuickBooks Online, not QuickBooks Desktop or QuickBooks Self-Employed. Confirm that your Xero or QuickBooks subscription supports the currencies and accounting entries you need. Check the official plan compatibility guide.
Which ecommerce channels does Link My Books support?
Amazon may be the starting point, but the integration is designed for multichannel bookkeeping. You can connect supported channels to your Xero or QuickBooks accounting workflow, giving your team a more consistent way to handle payouts from several sources.
| Sales channel | What to check |
|---|---|
| Amazon | Amazon regions and linked marketplaces |
| eBay, Etsy, Shopify | Stores, payment gateways, and payout settings |
| Walmart | Walmart US supported; Walmart Canada not supported |
| TikTok Shop | US and UK shop support |
| WooCommerce, Square | Connection details and supported payment flows |
Availability can vary by country and payment provider. Before assuming every gateway or international store is covered, check the supported connection instructions for your exact selling setup.
How does the software handle VAT, GST, and sales tax?
Link My Books provides tax mapping features for ecommerce bookkeeping. During setup, you select the relevant tax rates and accounts in Xero or QuickBooks. The system then uses those choices when preparing settlement entries, including supported rules for transactions in different destinations.
That support is valuable if you sell across borders, but it is not a substitute for knowing your obligations. UK VAT, Australian GST, and US sales tax work differently. Marketplace-collected tax and seller liabilities can also differ. Have a qualified accountant review the mapping before relying on automatic posting for a large history of transactions.
If tax rates are missing during setup, check the accounting platform first. The official accounts and tax mapping instructions explain how to refresh the available tax rates and complete the wizard.
How to set up Link My Books for Amazon
I would test one Amazon account and one settlement first. It is easier to catch a mapping issue early than to repair months of entries after enabling full automation.
- Begin the free trial. Create your account and select whether you are an ecommerce business owner or an accountant.
- Connect Amazon and your accounting software. Choose the correct Amazon region, authorize access, and link Xero or QuickBooks Online.
- Complete the Accounts & Taxes wizard. Review the suggested categories, tax rates, and bank or clearing accounts with your accountant.
- Inspect an imported settlement. Compare its sales, refunds, fee totals, and payout with the source report in Amazon.
- Post and match one settlement. Send the entry to Xero or QuickBooks and confirm the bank-feed match.
- Enable Auto Post when ready. Pick the intended start date and keep reviewing exceptions during the first few cycles.
The usual trial provides 14 days and access to approximately 90 days of historical settlements. More historical data may be available with paid plans or separate purchases. Check the current limits before planning a large backfill.
Useful setup habit: Keep an audit note for the first settlement: source period, payout amount, accounting entry, tax mapping, and bank match. Repeat with a foreign-currency settlement if your store receives one. That gives you a reliable reference when troubleshooting later.
Is Link My Books better for sellers or accountants?
It is intended for both, although the value looks different depending on who handles the books. Sellers usually want less manual data entry and clearer financial records. Accountants and bookkeepers want consistent client files, dependable tax mappings, and more time for review instead of repetitive imports.
For Amazon sellers
Spend less time explaining mismatched deposits. Review revenue, fees, and returns with your accountant, while leaving room to focus on inventory, listings, and customers.
For accountants and bookkeepers
Standardize settlement processing across ecommerce clients, investigate exceptions, and use the time saved for accuracy checks and higher-value advisory work.
For a client-focused walkthrough, see my Link My Books tutorial for accountants and bookkeepers.
Ready to test a real Amazon payout?
Use the trial to connect Amazon, verify your first settlement, and book onboarding if you need a guided setup. When you subscribe, enter VOVA20 for 50% off the first three months of an eligible new monthly plan.
Get the Link My Books offerCoupon acceptance and final subscription cost are shown at checkout. A booked onboarding call is included; accounting and tax advice remain your accountant's responsibility.
What should you check before paying?
Compare the actual subscription offer with your order volume, connected channels, and historical-data needs. Link My Books has updated its pricing and plan structure over time, so an old screenshot or fixed price from a past tutorial may not reflect your account today.
The official coupon terms describe 50% off the first three months for eligible new customers on monthly billing. New annual subscriptions are no longer offered, although existing annual customers may keep legacy plans. If you subscribe through Shopify's own billing system, direct Link My Books coupon codes may not apply.
For the current offer rules, consult the official coupon details and pricing page.
Also check the cancellation procedure rather than assuming deleting a channel stops billing. Link My Books currently directs direct-billed customers to request cancellation from support before renewal.
Free Link My Books tutorials for sellers and bookkeepers
The short video above introduces the software. If you want to see actual setup screens, I also recorded longer walkthroughs with Daniel Little, a Link My Books co-founder. Use the seller tutorial for the settlement workflow or the accountant tutorial for client-oriented setup and bookkeeping.
Amazon seller walkthrough: from connection to reconciliation
Accountant and bookkeeper walkthrough: managing ecommerce clients
You can find additional written comparisons and tutorials in my Link My Books resource hub.
Amazon payment reconciliation: frequently asked questions
Does Link My Books replace Xero or QuickBooks?
No. It connects ecommerce settlement data to Xero or QuickBooks Online. Your accounting platform remains the place for the wider books, bank reconciliation, and financial records.
Can Link My Books reconcile Amazon FBA payments automatically?
It can automate settlement processing and posting after setup. Xero or QuickBooks may suggest the matching deposit, but review and confirmation may still be required, especially with foreign currencies or unusual payouts.
Is Link My Books only for Amazon sellers?
No. It supports several ecommerce channels, including Shopify, eBay, Etsy, Walmart US, TikTok Shop in supported countries, WooCommerce, and Square. Check the exact channel and marketplace before connecting.
Does the free trial include onboarding?
Link My Books advertises a 14-day free trial and a free bookable one-to-one onboarding call. You should schedule the session if you want guided help with connections and settings.
How do I get 50% off Link My Books?
Start with the Vova Even affiliate offer, then enter VOVA20 during checkout for an eligible new monthly plan. Verify the displayed discount before paying.
Can I use Link My Books instead of an accountant?
It can reduce repetitive bookkeeping work, but it does not determine all of your legal, tax, or reporting obligations. An accountant should review the initial setup and any complicated tax or inventory treatment.
Is Link My Books worth trying for Amazon reconciliation?
If you already use Xero or QuickBooks Online, Link My Books deserves a look. Its strongest use case is turning complex marketplace settlements into structured accounting entries that make deposits easier to explain and reconcile.
My recommendation is to trial it with one account, check a real payout from end to end, and involve your accountant before switching on automation. If the entries make sense and the deposit matches, you have a much stronger reason to subscribe than a feature list alone could provide.
For more practical Amazon and ecommerce software guides, visit my blog at VovaEven.com.
Try Link My Books with VOVA20