All Collections
Link My Books for Amazon
Help articles relating to our Amazon integration
Split Sales, Refunds, Sales Tax and Seller Fees by Fulfilment TypeUseful if you want to split Sales, Refunds, Sales Tax and Seller Fees by FBA, MFN and Other fulfilment types.
Getting Started: Amazon to Xero
How to get started with our Amazon to Xero integration
How to connect Amazon & Xero to Link My BooksFull instructions for connecting Amazon and Xero accounts to Link My Books
How to complete the Accounts & Taxes setup wizard for Amazon & Xero3 simple steps to getting your Amazon to Xero connection setup correctly
Review and send your first Amazon settlement summary to XeroHow to view and send Amazon settlements to Xero
How to reconcile Amazon settlement invoices with bank deposits in XeroWhat to do once you send your settlements to Xero to match them with the incoming bank deposits via your bank feed
Getting Started: Amazon to QuickBooks
How to get started with our Amazon to QuickBooks integration
How to complete the Accounts & Taxes setup wizard for Amazon & QuickBooks4 simple steps to getting your Amazon to QuickBooks connection setup correctly
How to reconcile Amazon settlement journals with bank deposits in QuickBooksWhat to do once you send your settlements to QuickBooks to match them with the incoming bank deposits via your bank feed
Review and send your first Amazon settlement summary to QuickBooksHow to view and send Amazon settlements to QuickBooks
How to connect Amazon & QuickBooks to Link My BooksFull instructions for connecting Amazon and QuickBooks accounts to Link My Books
Account & Tax Mapping (UK Businesses)
Configuration tips for our Amazon integration tailored to the location of your business
Amazon account and tax rate mappings for UK VAT registered businessesAn explanation of our default account & tax mappings for UK businesses selling on Amazon
Amazon account and tax rate mappings for UK Non-VAT registered businessesAn explanation of our default account & tax mappings for non-VAT registered UK businesses selling on Amazon
Troubleshooting Errors
How to resolve common issues with our Amazon to Xero integration
Identifying and Correcting Discrepancies in your Reserved Balance AccountWhat to do if your reserved balances account isn't reconciling
Some of my products are missing namesWhy some SKUs show the SKU as the product name
Why are some of my settlements showing Awaiting VAT?Why am I unable to send Awaiting VAT settlements?
What to do when an Amazon payout failedIf you have a settlement to reconcile but no payment into the bank
Small negative settlement balances rolled over by AmazonWhy some negative settlements of less than £/$/€20 get rolled over
I am getting the error unknown marketplace countryWhy some of your Amazon settlements might be showing with an exclamation mark with select marketplace
How to reconcile SEK & PLN settlements in XeroWhat to do when you receive SEK or PLN settlements in Euros when your home currency is GBP
Some of my settlements are missingHow to get missing Amazon settlements to appear in your Link My Books account
FAQ's
Answers to other frequently asked questions about our Amazon to Xero integration
How to match your 1099K figures up with Xero or QuickBooksMatching the Amazon 1099K figures with Link My Books figures
Why don't the business reports in seller central match my Link My Books data?Reconciling Link My Books figures with Amazon figures
What data do you import from Amazon?
UK VAT Return For Amazon Sellers Post-BrexitHow to accurately account for your Amazon sales and fees and choose the right tax rates to ensure your UK VAT return if filed correctly.
Amazon Shipping Labels purchased and how Link My Books deals with themShipping Labels purchased on Amazon and their Vat treatment
Making VAT Adjustments In Xero For Amazon FeesFor if there was a gap between the date you became VAT registered and the date you entered your VAT number on Amazon Seller Central
How Link My Books Calculates VAT on European Amazon Seller AccountsHow we calculate VAT on European settlements and which Amazon reports we use to do so
How to deal with EU VAT in Xero or QuickBooks with Link My BooksAccounting for VAT in multiple countries with Link My Books
Import VAT and Custom duties.Steps to take when part of one of your Amazon settlements include Import VAT and Custom Duties
Recording non UK VAT expenses incurred in PAN EU countriesAccounting for non UK VAT expenses in Xero or QuickBooks
Understanding how Link My Books automatically groups products based on their VAT rateFor Amazon and Shopify accounts added after May 2023
How to download Amazon Date Range Summary ReportIf you'd like to compare your Amazon data to Link My Books summaries
Amazon Deferred TransactionsDetails on Amazon's new payments based on delivery date policy