Xero v2 Integration - Export Data

Overview

The Reports > Integrations > Xero Integration screen is where you can view and export Invoices, Payroll and Credit Notes. 

Generate Export Data

By default, the Period in the Report Summary will be set to ‘All outstanding up to today’ and each subheading will include data that is ready for export to Xero.

To set a specified date range, click Report Settings > select ‘Select Date Range’ from the Show drop-down field > enter the ‘From’ and ‘To’ dates > Go.

If there are multiple entities in your portal, you can also manage which entity is set from Report Settings > Billing Entity before you export.

If you process lots of pay runs and invoices, please use the date range filter as much as possible. 

Validation of Data

Each time the Xero Integration screen is loaded, the data that is ready for export will be validated by the system. Any errors that need fixing in Astute will be listed underneath the Report Summary and will need to be resolved before you can proceed with an export. 

If an export is attempted and there are issues validated by Xero, these will be displayed as banner messages above the Report Summary. 

Some common validation errors include:

• a GL code missing in Astute
• a GL code set in Astute which does not have a matching GL code in Xero
• an incorrect tax code for a GL account in Xero (ie the tax code in Xero does not match what is set in Astute)
• an invoice that has already had a payment applied to it in Xero

For Payroll, the system will also confirm that the journal entry balances to $0.00 (ie the total debit amount matches the total credit amount).

 
You can view errors in the API Log if required.