Once you have sent a settlement to Xero you will be able to reconcile the settlement against the disbursement Amazon, eBay, Shopify or Etsy will have paid out to your bank account.

If you need guidance on how to send your settlements to Xero from Link My books read this help article.

The good thing about settlement based accounting is that when you do so the amount shown on the invoice in Xero and the amount you receive into your bank from the sales channel will be exactly the same. This makes it really easy for you (or your accountant) to reconcile your bank account.

All you need to do is locate the deposit on your bank statement reconciliation in Xero and click on the OK button, as shown below:

This will work for settlements in your home currency, so if the invoice is in GBP and your bank account is in GBP too.

IMPORTANT – If the currency of the invoice is different to that of the bank account, then follow the instructions in this article on How to reconcile foreign currency settlements.

Why are some of my settlements being sent as bills instead of invoices to Xero?

When Link My Books sends your Amazon settlements to Xero we do so in the form of an invoice (almost always). 

You may have noticed that we sometimes send your settlement (or part of it) as a bill instead of an invoice and wondered why we do that…

Since Xero does not allow negative total invoices, if you have a settlement which is for a negative amount then we have no choice but to send it as a bill instead.

Why would I have a negative invoice for a settlement?

There are two main reasons as to why you may have seen this happen in your Link My Books account.

1. You have a negative settlement. This can occur if your Amazon fees and advertising costs are larger than your sales amount. In this case Amazon will actually charge your card on file with the settlement amount and produce a negative total settlement report.
2. If you have a settlement that spans two months and you also have a large reserved balance by Amazon. In this case we split the settlement by month so we create two invoices but because the reserved balance will always fall in one or the other invoice it will end up meaning that one of your invoices will be for a negative total.

I hope you found this article helpful. Many Amazon sellers recently started trading stocks and crypto currencies, hoping to diversify their income, which is a very good idea with all the uncertainty which comes with the platform. For this reason, we launched a new Facebook group, Crypto Arbitrage Income (Bitcoin, Crypto, Altcoins, Blockchain, Trading) – feel free to join us and forget about the troubles of selling on Amazon for a moment!

Regarding Amazon Seller Performance, you can always participate in our Amazon Seller Performance – Friendly Advice – Worldwide group, where you will be very welcome.

If you are an Amazon Seller who needs help with any Amazon-related issues such as suspensions, listing blocks or is looking for professional assistance, please don’t hesitate to subscribe to my new OnlyFans page at: www.onlyfans.com/kikaangelic

Additionally, here you can watch my YouTube video, where I am presenting you several secret tips about appealing Amazon Seller Account suspensions (don’t be confused by the opening of the video, where I am enjoying a vacation – it’s a part of the story):

Reconciling foreign currency settlements against their local currency amounts in Xero differs depending on whether you use Amazon currency conversion tool or not.

If you have entered your GBP bank account as the deposit account for all your Amazon funds, including those in EUR, USD and CAD, then Amazon will use their Amazon Currency Conversion platform to convert your EU, USD or CAD payments into GBP before they pay them out to you.

If you have added local bank accounts for each of the different currencies that Amazon uses then they will pay you out in those currencies without first converting them to GBP.

If you are using the Amazon Currency Conversion platform then when your settlements are sent to Xero we will add their converted amounts to the invoice references like this:

“(€5.79) LMB-FR-1012345678-1 (converted to GBP 4.88)”

This makes it easier to find and match the foreign currency settlements with their GBP bank lines.

To do so if you take the amount you received in GBP and simply search for that value in the reference search box and untick the show GBP items only box, then Xero will show the invoices which have that figure in the reference which should make it much easier to identify them.

The steps are:

1. Click the “Match” tab
2. Un-tick the “Show GBP items only” checkbox
3. Copy the amount you received in GBP and paste it into the “Search by name or reference” box
4. Click “Go”
5. Tick the invoice and hit reconcile.

I hope you found this article helpful. Many Amazon sellers recently started trading stocks and crypto currencies, hoping to diversify their income, which is a very good idea with all the uncertainty which comes with the platform. For this reason, we launched a new Facebook group, Crypto Arbitrage Income (Bitcoin, Crypto, Altcoins, Blockchain, Trading) – feel free to join us and forget about the troubles of selling on Amazon for a moment!

Regarding Amazon Seller Performance, you can always participate in our Amazon Seller Performance – Friendly Advice – Worldwide group, where you will be very welcome.

If you are an Amazon Seller who needs help with any Amazon-related issues such as suspensions, listing blocks or is looking for professional assistance, please don’t hesitate to subscribe to my new OnlyFans page at: www.onlyfans.com/kikaangelic

Additionally, here you can watch my YouTube video, where I am presenting you several secret tips about appealing Amazon Seller Account suspensions (don’t be confused by the opening of the video, where I am enjoying a vacation – it’s a part of the story):

Many Amazon Sellers are contacting me through my OnlyFans page daily, seriously worried about their Seller Accounts being labelled as ”At Risk” of deactivation. But does this orange warning status actually mean anything bad? Learn more in this article!

Amazon has their minimum performance targets for Order Defect Rate, Cancellation Rate, Late Shipment Rate and many other metrics. Whenever a Seller Account exceeds the maximum permissible defect rate, a warning will appear.

Typically, the affected seller will also receive the following e-mail from Amazon Seller Performance:

In regards to Order Defect Rate, Late Shipment Rate or Cancellation Rate, if you are a small seller, your metrics will typically greatly exceed the targets following a single defective order. Seeing this on your Account Health Dashboard can be quite alarming.

However, please note that no Seller Account will get suspended over 1-2 or 3 defects. Amazon can see, that you are a small seller. Even if you have a 50% Order Defect Rate with 1 defective order out of two, you are not worse off than someone with an 1.02% ODR!

Many Amazon Sellers wrongly believe, that the best approach is to try to get into touch with the buyer at all costs and make them withdraw the A-Z claim or negative feedback. They are trying to achieve this by offering free items, full refunds or even extra credits issued on the top of a full refund.

Doing this is a terrible idea, as it can be picked up by Amazon’s automated bots as a serious violation of their Seller Code of Conduct. My advice is to never contact buyers who left a negative feedback or opened a valid A-Z claim in an attempt to have the defect removed. The best thing you can do is avoid getting additional defects and complaints by learning from your mistakes and implementing preventative measures.

If you are an Amazon Seller who needs help with any Amazon-related issues such as suspensions, listing blocks or is looking for professional assistance, please don’t hesitate to subscribe to my new OnlyFans page at: www.onlyfans.com/kikaangelic

Additionally, here you can watch my YouTube video, where I am presenting you several secret tips about appealing Amazon Seller Account suspensions (don’t be confused by the opening of the video, where I am enjoying a vacation – it’s a part of the story):

I hope you found this article helpful. Many Amazon sellers recently started trading stocks and crypto currencies, hoping to diversify their income, which is a very good idea with all the uncertainty which comes with the platform. For this reason, we launched a new Facebook group, Crypto Arbitrage Income (Bitcoin, Crypto, Altcoins, Blockchain, Trading) – feel free to join us and forget about the troubles of selling on Amazon for a moment!

Regarding Amazon Seller Performance, you can always participate in our Amazon Seller Performance – Friendly Advice – Worldwide group, where you will be very welcome.