MIGRATION: How to export Financial Reports data from Reckon Accounts Hosted
Exporting Financial Reports data from Reckon Accounts Hosted
Launch the Hosted application and open the specific company data file you want to work with.
1) Generate a Trial Balance report.
Click on the Reports menu
then select Accountant
then select Trial BalanceYou will need to change the date so that it is for a specific period.
If you want historical transactions from the current financial year, then you would set the Dates period to be for the previous financial year.
Example:
If you want balances as at 30/06/2017 and individual transactions from 01/07/2017 onwards,
- set the Dates to be "Last Financial Year" which sets it to be From 01/07/2016 To 30/06/2017
Once the report has generated, click on the Export button
You can choose to export to a CSV file or to a new Excel workbook, then click the Export button
Set the destination location that the report export will be saved to (Save in:) Q: drive
Give the report a distinctive name such as "Trial Balance 01-07-2017 onwards.csv"
then click the Save button
If you wanted a different period, then you would need to choose the appropriate option.
If you are unsure what to select, let us know what period you want transactions to begin and end so we can make a recommendation.
2) Repeat this process to generate a Balance Sheet report.
Click on the Reports menu
then select Company & Financial
then select Balance SheetYou will need to change the date so that it matches the date period of the Trial Balance report
Once the report has generated, click on the Export button
You can choose to export to a CSV file or to a new Excel workbook, then click the Export button
Set the destination location that the report export will be saved to (Save in:) Q: drive
Give the report a distinctive name such as "Balance Sheet at DD-MM-YYYY.csv"
then click the Save button
3) Repeat this process to generate a Profit and Loss report.
Click on the Reports menu
then select Company & Financial
then select Profit & Loss StandardYou will need to change the date so that it matches the date period of the Trial Balance report
Once the report has generated, click on the Export button
You can choose to export to a CSV file or to a new Excel workbook, then click the Export button
Set the destination location that the report export will be saved to (Save in:) Q: drive
Give the report a distinctive name such as "Profit and Loss at DD-MM-YYYY.csv"
then click the Save button
4) Repeat this process to generate a Customer Balance Summary report.
Click on the Reports menu
then select Customers & Receivables
then select Customer Balance SummaryYou will need to change the date so that it matches the date period of the Trial Balance report
Once the report has generated, click on the Export button
You can choose to export to a CSV file or to a new Excel workbook, then click the Export button
Set the destination location that the report export will be saved to (Save in:) Q: drive
Give the report a distinctive name such as "Customer Balance Summary at DD-MM-YYYY.csv"
then click the Save button
5) Repeat this process to generate a Supplier Balance Summary report.
Click on the Reports menu
then select Suppliers & Payables
then select Supplier Balance SummaryYou will need to change the date so that it matches the date period of the Trial Balance report
Once the report has generated, click on the Export button
You can choose to export to a CSV file or to a new Excel workbook, then click the Export button
Set the destination location that the report export will be saved to (Save in:) Q: drive
Give the report a distinctive name such as "Supplier Balance Summary at DD-MM-YYYY.csv"
then click the Save button
6) Once all the reports have been generated and saved to your Q: drive, you would need to download it to your local computer (such as to your Windows Deskop) before you can send it to us.
You can watch the video for Uploading and Downloading Company Files to the new Reckon Accounts Hosted for more details.
7) Once you have downloaded the reports to your computer, send us the report exports.
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:
Custom Conversion Request (Financial Report Exports)
Company Name: _______________________
Contact Name: _________________________
This will let us know that the file being submitted is assigned to your case.
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
Categories
- All Categories
- 6.7K Accounts Hosted
- 16 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 7 📢 Reckon Accounts Desktop - Announcements
- 1.4K Reckon Payroll
- 34 📢 Reckon Payroll - Announcements
- 15 Reckon Payroll Help Videos 🎥
- 25 Reckon Mate App
- 2.6K Reckon One
- 10 📢 Reckon One - Announcements
- 12 Reckon Invoices App
- 15 Reckon Insights
- 99 Reckon API
- 308 Point of Sale
- 1.9K Personal Plus and Home & Business
- 74 About Reckon Community