Skip to main content

How to Reconcile Amazon Settlements in Xero

Learn how to find and reconcile your Amazon settlements in Xero. This guide covers single settlements, split-month settlements with Carried Forward Balances, and multi-currency payouts.

Written by Iona
Updated today

A2X posts your Amazon settlements to Xero as draft invoices. Learn how to locate these invoices, approve them, and reconcile them against your bank deposits for single, split-month, and multi-currency settlements.

Before You Start

  • You need an active Xero account connected to A2X

  • If you are reconciling multi-currency settlements, you must have a Premium Xero account with multi-currency features enabled

Reconcile a single settlement

Single settlements cover a date range entirely within one calendar month. A2X generates one corresponding invoice for this period.

  1. Send your settlement from A2X to Xero

2. Log in to Xero and navigate to Sales > Invoices

3. Click the Draft tab to locate your newly posted invoice

4. Review the invoice details to ensure the total matches your A2X settlement

5. Click Approve to move the invoice to your Awaiting Payment queue

6. Navigate to your Xero dashboard and click Reconcile on your bank account

7. Locate the bank deposit from Amazon on the left side of the screen

8. Review the auto-suggested match from Xero on the right side and click OK to reconcile the transaction

Reconcile a split-month settlement

When an Amazon settlement spans across two calendar months, A2X splits the data into two separate invoices to ensure your revenue and fees are recorded in the correct accounting period.

  1. Send both parts of the split settlement from A2X to Xero

  2. Navigate to Sales > Invoices and click the Draft tab

  3. Select and approve both invoices

Note: A2X uses a Carried Forward Balance to bridge the gap between split months. Often, the first invoice will total $0.00, and the second invoice will contain the total payout amount that matches your bank deposit.

See this example:

The second invoice will then include the Carried Forward Balance line that will credit the Carried Forward Balance account. The total of the second invoice will match the amount you've been paid, allowing you to reconcile the deposit from Amazon to this single invoice.

If the two invoices are sent to Xero at the same time, the debit and credit of the Carried Forward Balance will happen simultaneously, so the balance of the Carried Forward Balance account should remain at $0.00. This can be done using the Single Settlement Reconciliation method explained above.

4. Navigate to your bank reconciliation screen.

5. Locate the Amazon deposit, click Match, and select both approved invoices to balance the total deposit amount.

6. Click Reconcile to finish.

Reconcile a multi-currency settlement

Amazon often converts foreign currency settlements into your home currency right before they pay it out to you. Xero handles this exchange automatically when you match the transactions.

  1. Approve your foreign currency invoice in Xero following the standard steps

  2. Navigate to your bank reconciliation screen and locate the deposit in your home currency

  3. Click Match and then click Find and Match

  4. Uncheck the Show [Home Currency] items only box to reveal invoices in other currencies

5. Select your foreign currency invoice

6. Review the exchange rate that Xero automatically calculates to ensure it is acceptable

7. Click Reconcile to confirm the match and record any exchange rate gains or losses

Troubleshooting

  • I cannot find my invoice in Xero
    Make sure you clicked Send in A2X. If you have auto-posting enabled, check your A2X Settings to confirm it is turned on. In Xero, check both the Draft and Awaiting Payment tabs.

  • My bank deposit does not match my invoice
    Check if the settlement spanned two months. If it did, you need to approve both invoices in Xero and select them both during the matching process.

  • I cannot see my foreign currency invoices
    You need to have a Premium Xero account to use multi-currency features. If you are on a lower tier, Xero will restrict your ability to match foreign currency invoices.

FAQs

Why did A2X split my settlement into two invoices?

A2X splits settlements that cross over a month-end boundary. This ensures your sales, taxes, and fees are accounted for in the exact month they occurred, which keeps your financial reporting accurate.

What is a Carried Forward Balance?

A Carried Forward Balance acts as a temporary holding account. Because A2X splits your cross-month settlements into two invoices, the Carried Forward Balance carries the pending funds from the first invoice over to the second invoice so the final total matches your single bank deposit.

Related Articles

Did this answer your question?