MIGRATION: How to export Financial Reports data from Xero
Datarec_ReckonLtd
Reckon Staff Posts: 1,039
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
Run the Aged Payables Summary
Run the Aged Receivables Summary
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
- Go to Reports and click All Reports.
- Under Accounting click Trial Balance.
- Select the report date, and choose to sort account code.
- Click Update.
- Export the report using the Export button within the report.
Run the Aged Payables Summary
- In the Reports menu, select All Reports.
- Under Purchases, click ... to expand the section if the report is hidden.
- Click Aged Payables Summary (New).
- Choose a time frame or select a date, then click Update to view your report.
Run the Aged Receivables Summary
- In the Reports menu, select All Reports.
- Under Sales, click ... to expand the section if the report is hidden.
- Click Aged Receivables Summary (New).
- 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
How to ask good questions on the Reckon Community
Data Services Tip - Try this first before requesting a data service
0
Categories
- All Categories
- 6.8K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 18 📢 Reckon Payroll - Announcements
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 73 About Reckon Community