MIGRATION: How to export Financial Reports data from Xero

  • 1
  • Article
  • Updated 9 months ago
  • (Edited)
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.

 Send exported Excel report files

 Click on the + Add your files button.

Add our email address reckonmigration@reckon.com

 

 Add your email address (ensure it is correct as any notifications will be sent there).

 In the Message field, place the following info:


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.
Photo of Data Rec

Data Rec, Employee

  • 4,394 Points 4k badge 2x thumb

Posted 9 months ago

  • 1

Be the first to post a reply!