MIGRATION: How to export Financial Reports data from Xero

Data RecData Rec Reckon Staff Posts: 816 ✭✭
edited February 17 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.

Regards,

Reckon Data Recovery Team

You can request assistance via the case request web form below.

https://www.reckon.com/au/data-services-request/

Sign In or Register to comment.