MIGRATION: How to export Financial Reports data from Reckon Accounts Hosted

Datarec
Datarec Reckon Staff Posts: 1,195 Reckon Staff
edited October 11 in 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 Balance

You 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 Sheet

You 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 Standard

You 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 Summary

You 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 Summary

You 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.
This discussion has been closed.