MIGRATION: How to export Financial Reports data from Xero

Datarec_ReckonLtd
Datarec_ReckonLtd Reckon Staff Posts: 1,039 Reckon Staff
edited February 2020 in Reckon One
Exporting Financial Reports data from Xero

For the report dates, you would need to select the date that is one day before the period in which you want historical transactions.

Example: If you wanted the balances as at 30/06/2017 and all individual transactions from 01/07/2017 onwards, then the report date would be as at 30/06/2017.



Generate a Trial Balance
  1. Go to Reports and click All Reports.
  2. Under Accounting click Trial Balance.
  3. Select the report date, and choose to sort account code.
  4. Click Update.
  5. Export the report using the Export button within the report.

Run the Aged Payables Summary
  1. In the Reports menu, select All Reports.
  2. Under Purchases, click ... to expand the section if the report is hidden.
  3. Click Aged Payables Summary (New).
  4. Choose a time frame or select a date, then click Update to view your report.

Run the Aged Receivables Summary
  1. In the Reports menu, select All Reports.
  2. Under Sales, click ... to expand the section if the report is hidden.
  3. Click Aged Receivables Summary (New).
  4. Choose a time frame or select a date, then click Update to view your report.

Send us the exported report files.

MIGRATION: How to securely send a data file to the Reckon Migration Team

In the Short Note to Recipient field add the following:


Balances Conversion Request (Xero Reports XLS)

Company Name: _______________________

Contact Name: _________________________

 

This will let us know that the file being submitted is assigned to your case and allow the conversion team to perform the analysis.

If you do not provide this information, it will result in delays processing your case.