All Collections
Apps, Integrations & Web Connectors
Xero
Xero Invoice Creation and Reconciliation Errors
Xero Invoice Creation and Reconciliation Errors

We have documented the most common reasons an invoice may fail to be created or reconcile in Xero

Nick Dainty avatar
Written by Nick Dainty
Updated over a week ago

If your invoice has failed to generate in your Xero ledger or failed to reconcile after payment is disbursed to you, there may be an error reported by Xero to explain why.

Currently, you can review any Xero errors on the 'History' tab of a Proposal. For the most common errors, we have documented below why they occur and what you can do to rectify them.

After taking the appropriate actions, try to re-send the invoice if it is un-deployed (if it is an invoice deployment error) - or contact our support team to re-run invoice reconciliation on your account (if it is an invoice reconciliation error).


The TaxType code 'YYY' cannot be used with account code 'xxx'

An invoice cannot be created as the tax type code is not able to be published to this type of account in Xero.

This often happens if you are using a revenue account with an expenses code or vice versa.

Solution:

You can either:

  1. Go into Xero and allow that code type to be used with that account, or

  2. Change the account on that service in

  3. Ignition to one that accommodates that tax type (please note, it will need to be a revenue account)

Once this is completed, try to re-send the invoice to Xero using the cog next to the invoice on the proposal.


Account code 'xxx' is not a valid code for this document

An invoice cannot be created as the account not compatible with this.

This can happen if you are using a revenue account with an expenses code or vice versa.

This can also happen if you are trying to publish into an incompatible Xero account - e.g., a Bank or Direct Cost account.

Solution:

  1. Check your account type can publish accounts receivables invoices - usually a revenue account, 

If yes, it is a revenue account

  1. Go to Xero and allow that tax code type to be used on that account;

If no, you are using an incompatible account

  1. Change the account on that service in Ignition to one that accommodates that tax type

Once this is completed, try to re-send the invoice to Xero using the cog next to the invoice on the proposal.


The TaxType field is mandatory Account code 'xxx' is not a valid code for this document.

An invoice cannot be created as the account is not compatible with this.

This can happen if you are using a revenue account with an expenses code or vice versa.

This can also happen if you are trying to publish into an incompatible account - e.g., a Bank or Direct Cost account.

Solution:

  1. Check your account type can publish accounts receivables invoices - usually a revenue account, 

If yes, it is a revenue account:

  1. Go to Xero and allow that tax code type to be used on that account;

If no, you are using an incompatible account:

  1. Change the account on that service in Ignition to one that accommodates that tax type

Once this is completed, try to re-send the invoice to Xero using the cog next to the invoice on the proposal.


The document date cannot be before the period lock date

An invoice cannot be created as it is dated before the "lock date" (an end-of-period date set in your Xero account).

Xero sees this period as closed, so it won't "accept" any invoices that are dated prior.

Solution:

Change the lock date in Xero a refer to Xero's information on working with lock dates here.

Once this is completed, try to re-send the invoice to Xero using the cog next to the invoice on the proposal.


The document date cannot be before the end of year lock date

An invoice cannot be created as it is dated before the "lock date" (an end-of-period date set in your Xero account).

Xero sees this period as closed, so it won't "accept" any invoices that are dated prior.

Solution:

Change the lock date in Xero a refer to Xero's information on working with lock dates here.

Once this is completed, try to re-send the invoice to Xero using the cog next to the invoice on the proposal.


You have reached the limit of invoices you can approve

An invoice cannot be created as you are on the trial version of Xero, or on their "Starter" plan and have exceeded your limit.

Both of these will impose a limit on the number of approved invoices that you can have in Xero. Read more on their website.

Solution:

Move off trial or upgrade your plan. 

Once this is completed, try to re-send the invoice to Xero using the cog next to the invoice on the proposal.


The Total for this document must be greater than or equal to zero

An invoice cannot be created as Xero does not support sending invoices with less than zero value (negative value).

Solution:

All invoices on a proposal will need to have a positive value. 

If you need to issue a credit to a client, add a credit note in Xero.


The contact name xxx is already assigned to another contact. The contact name must be unique across all active contacts.

An invoice cannot be created as there is a contact in Xero with the same name as on the invoice attempting to be created.

This can happen if clients have been incorrectly mapped in Ignition.

Solution:

  1. Go to the client in Ignition and click 'Edit'

Once this is completed, try to re-send the invoice to Xero using the cog next to the invoice on the proposal.


Failed to create invoice in Xero: Another contact in Xero already exists with this name; {client name}.

An invoice in Xero cannot be created when these steps occur in sequence

  1. Sync client names to Xero is ON (in Apps → Xero → Invoices)

  2. Client name is updated in Ignition

  3. A different contact name already exits in Xero with that name

  4. Mapped client name can’t be updated and invoice creation therefore fails

Solution:

Please check your client's Xero Contact mapping in Ignition by navigating to the specific client → Edit client → Apps tab → App client mappings.


Branding Theme with ID xxx doesn't exist

An invoice branding theme is selected that no longer exists in Xero.

Solution:

Select a new branding theme under Apps>Xero>Settings in Ignition.


Token XXX does not match an expected ACCESS token

An invoice cannot be created as the Xero Authentication access token has expired and you need to re-authenticate with Xero.

Solution:

Re-authenticate your Xero credentials in Ignition by going to Apps>Xero.


The access token has expired 

An invoice cannot be created as the Xero Authentication access token has expired and you need to re-authenticate with Xero.

Solution:

Re-authenticate your Xero credentials in Ignition by going to Apps>Xero.


Invoice # must be unique

An invoice cannot be created as the invoice number already in use.

This may occur if an invoice was voided and recreated before Xero was able to release the number or if you have changed your Xero invoice numbering scheme.

Solution:

If you have not edited your Xero numbering scheme, wait for a short time and attempt to re-create the invoice.

If you have changed the invoice numbering scheme, check to ensure it will generate unique invoice numbers. Refer to Xero's help article here.


Clearing account must not be archived

An invoice can't be reconciled as the clearing account used by Ignition to clear funds has been archived. 

Solution:

Un-archive the Xero clearing account associated with Ignition. This will usually be called Ignition Clearing Account or IgnitionPayments.

After completing this, contact our support team to re-run invoice reconciliation on your account.


Cannot create Xero payment: invalid invoice status (DELETED)

An invoice can't be reconciled as the invoice has been deleted.

Solution:

Re-create the invoice in Ignition from the cog next to the invoice. If the invoice is not automatically reconciled, contact our support team to re-run invoice reconciliation on your account.


Cannot create Xero payment: invalid invoice status (VOIDED)

An invoice can't be reconciled as the invoice has been voided.

Solution:

Re-create the invoice in Ignition from the cog next to the invoice. If the invoice is not automatically reconciled, contact our support team to re-run invoice reconciliation on your account.


Invoice not found in Xero

An invoice can't be reconciled as it is not found in the ledger.

This may occur if you have changed the connected ledger since the invoice was raised or if the invoice is in a state that a payment cannot be raised against it.

Solution:

First check that you have the correct Xero ledger connected under Apps> Xero.

If so, Re-create the invoice in Ignition from the cog next to the invoice. If the invoice is not automatically reconciled, contact our support team to re-run invoice reconciliation on your account.


Clearing account must not be type bank account

An invoice can't be reconciled as the clearing account is of an incompatible account type.

When Ignition creates a clearing account, the account type will be set as "Current Asset". 

Solution:

Change the Ignition Clearing Account to account type "Current Asset".

After completing this, contact our support team to re-run invoice reconciliation on your account.


Payment amount mismatch

An invoice can't be reconciled as the payment amount differs to the invoiced amount.

This may occur if a partial payment or credit has been added to the invoice. It may also occur if the tax settings are different on the invoice than the payment.

Solution:

Check that the invoice does not have a partial payment or credit applied.

If it does, you can either manually reconcile the invoice or remove this and contact our support team to re-run invoice reconciliation on your account.


You have reached the limit of invoices you can approve

There could be two possible reasons for this:

  • If you are on a trial of Xero, there is a limit of 10 accounts receivable and 10 accounts payable invoices that can be set to approve

  • If you have the Small business edition of Xero, there are also limits to the number of invoices you can approve. Refer to their pricing page here for more information.

Solution:

Check your current Xero subscription, if you have a starter account, you'll need to either void some of the invoices to continue testing. If you have a trial account, you'll need to activate your Xero account to continue.

Once this is completed, try to re-send the invoice to Xero using the cog next to the invoice on the proposal.


Payment amount exceeds the amount outstanding on this document

This error occurs when a payment cannot sync to Xero because the payment amount is greater than the open balance of the bill or invoice in Xero.

Please note that the payment amounts need to be less or equal to the open balance of invoice for it to sync successfully to Xero.

Solution:

Remove any duplicate manually applied for payment from the bill or invoice in Xeo.

Once this is completed, try to re-send the invoice to Xero using the cog next to the invoice on the proposal.

Did this answer your question?