Xero Posting Errors

Xero Posting Errors

This article is for customers who use Xero Accounting and post your GL to Xero when you confirm a pay. The transfer of information between iPayroll and Xero can take a few minutes. A message will display on the confirm screen when it is successfully completed.
If there is an error in the process, a message will display on the confirm screen and a system generated email will be sent to paymasters.  You can fix the error and repost the entries before your payroll is Closed.
Alert
If the pay is Closed you can try and repost to Xero  
Info
For more information here Repost Historical Information to Xero

"Account code 'Missing' is not valid for this document."

There is a cost centre missing for someone being paid in iPayroll. The Employee is missing a cost centre on either their Personal Details or on a transaction. Check the General Ledger Postings report where you can select the 'missing' transaction to see who you need to correct. 
  1. Log on to iPayroll
  2. Go to Reports > Financial > General Ledger Postings
  3. Select > transaction highlighted as 'Missing'
  4. Go to Step 4. Unconfirm > Unconfirm the payroll (Check your confirm times before)
  5. Go to Employee(s) that do not have a cost centre
  6. Update Personal Details or Timesheet Entry
  7. Go to Reports > Financial > General Ledger Postings > review until no further 'Missing' entries
  8. Go to Step 4. Confirm > Confirm payroll
For more information here Xero Accounting

"Account code 'code' is not valid for this document".

One of the cost centre transactions from iPayroll does not have a corresponding Chart of Account code set up in Xero. 
  1. Log on to iPayroll
  2. Go to Reports > Financial > General Ledger Postings > review codes
  3. Go to Step 4. and Unconfirm > Unconfirm the payroll (Check your confirm times before)
  4. Update Personal Details or Timesheet Entry with the correct code OR
  5. Log on to Xero
  6. Update Xero with the code you are trying to post to 
  7. Go to Reports > Financial > General Ledger Postings > review 
  8. Go to Step 4. Confirm > Confirm payroll
For more information here Xero Accounting

"Account code 'code' has been archived, or has been deleted". 

The Account Code iPayroll is trying to post to has been archived or deleted.
  1. Log on to iPayroll
  2. Go to Reports > Financial > General Ledger Postings > review code in error message
  3. Go to Step 4. Unconfirm > Unconfirm the payroll (Check your confirm times before)
  4. Update Personal Details or Timesheet Entry with the correct code OR
  5. Log on to Xero
  6. Update Xero with the code you are trying to post to 
  7. Go to Reports > Financial > General Ledger Postings > review 
  8. Go to Step 4. Confirm > Confirm payroll
Info
For more information here Xero Accounting

"Duplicate key null (attempted merging values NONE and NONE)". 

  1. Log on to iPayroll
  2. Go to Reports > Financial > General Ledger Postings > review code in error message
  3. Go to Step 4. Unconfirm > Unconfirm the payroll (Check your confirm times before)
  4. Update Personal Details or Timesheet Entry with the correct code OR
  5. Log on to Xero
  6. Update Xero with the code you are trying to post to 
  7. Go to Reports > Financial > General Ledger Postings > review 
  8. Go to Step 4. Confirm > Confirm payroll
Info
For more information here Xero Accounting

"The TaxType code 'taxType' cannot be used with account code 'code". 

  1. Log on to iPayroll
  2. Go to Reports > Financial > General Ledger Postings > review code in error message
  3. Go to Step 4. Unconfirm > Unconfirm the payroll (Check your confirm times before)
  4. Update Personal Details or Timesheet Entry with the correct code OR
  5. Log on to Xero
  6. Correct the tax type for the code you are trying to post to 
  7. Go to Reports > Financial > General Ledger Postings > review 
  8. Go to Step 4. Confirm > Confirm payroll
Info
For more information here Xero Accounting

"Invoice not of valid state for modification" 

The bill in Xero can no longer be updated. Reason could be that the bill has been voided or there is a payment associated with one of the bills.

Log on to Xero and review the bill. 

"Unable to connect to Xero. Check your Xero interface is setup correctly".

  1. Log on to iPayroll go to Setup > Interfaces
  2. Select > Xero > Disable
  3. Select > Xero > Enable
  4. You will be directed to your Xero account
  5. Log on with your Xero credentials.
  6. Allow iPayroll Access or Choose the appropriate Xero organisation if you have more than one.
  7. Invoice Settings > Select > Post to Xero at Confirm time
  8. Save
  9. If successful the Enable button with display DISABLE
Alert
If you are still not able to post - you may need to disconnect iPayroll in Xero Accounting
Info
For more information here Disconnect iPayroll in Xero Accounting
For more information here Connecting to Xero

"Unexpected error when posting invoices to Xero".

  1. Log on to iPayroll go to Setup > Interfaces
  2. Select > Xero > Disable
  3. Select > Xero > Enable
  4. You will be directed to your Xero account
  5. Log on with your Xero credentials.
  6. Allow iPayroll Access or Choose the appropriate Xero organisation if you have more than one.
  7. Invoice Settings > Select > Post to Xero at Confirm time
  8. Save
  9. If successful the Enable button with display DISABLE
Alert
If you are still not able to post - you may need to disconnect iPayroll in Xero Accounting

"You have reached the limit of invoices you can approve".

The plan you are using in Xero is for a limited a amount of invoices only. 

You can now post one combined invoice to Xero (instead of three) from iPayroll. Depending on the number of bank statement lines you receive in Xero, you may need to use Find & Match functionality in Xero to reconcile the bank statement line / s and bills in Xero. 
InfoFor more information here Post one combined bill to Xero

We have a journal upload that is available to you to transfer your information into Xero.
InfoFor more information here Xero Journal 

"Error connecting to Xero. Unable to connect, Xero did not return requested data. Please try again" 

  1. You must be a Xero user in the company you want to connect to iPayroll.
  2. Check in Xero if you are connected to iPayroll
  3. Go to Xero in Organisation > Settings > Connected Apps
  4. Select three dots next to iPayroll > Disconnect 
  5. Log out of Xero - if you have multiple browser tabs and/or devices with Xero open, please log out and close them all completely
  6. Login into iPayroll
  7. Go to Setup > Interfaces
  8. Select Enable button (next to Xero)
  9. You will be redirected to your Xero account
  10. Log on with your Xero credentials
  11. Allow iPayroll Access or Choose the appropriate Xero organisation if you have more than one.
  12. Invoice Settings > Select > Post to Xero at Confirm time
  13. Save
  14. If successful the Enable button with display DISABLE



    • Related Articles

    • My iPayroll postings are not in Xero?

      Xero Posting Errors Xero no longer supports interface connections for Cashbook and Ledger plans and you will receive an error each time you try to connect. Check your plan - In Xero, click on your organisation name > Select My Xero and under ...
    • Xero Accounting

      This article is for customers who use the Interface between iPayroll and Xero Accounting and want to automatically post your GL to Xero when you confirm a pay. The GL accounts will also need to be set up in iPayroll. Customers that do not want to use ...
    • Xero Journal Upload File

      Xero Journal Upload This article is for customers who use Xero Accounting and want to post GL items to Xero using an upload file generated by iPayroll instead of the direct transfer (Xero Interface). You must connect to Xero to complete the Costing ...
    • Connect iPayroll to Xero Accounting

      Connect your iPayroll to Xero interface Log on to iPayroll go to Setup > Interfaces Select Xero > Enable You will be directed to your Xero account Log on with your Xero credentials. Allow iPayroll Access or Choose the appropriate Xero organisation if ...
    • How do I repost to Xero?

      Repost Historical Information to Xero This article is for customers who use Xero Accounting and post your GL to Xero when you confirm a pay. If there is an error in the process, a message will display on the confirm screen and a system generated ...