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

Datarec_ReckonLtd
Datarec_ReckonLtd Reckon Staff Posts: 1,039 Reckon Staff
edited February 2020 in Reckon Accounts (Desktop)

Exporting Financial Reports data from Reckon Accounts desktop

Launch the program 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:)
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:)
Give the report a distinctive name such as "Balance Sheet DD-MM-YYYY onwards.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:)
Give the report a distinctive name such as "Profiit and Loss DD-MM-YYYY onwards.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, send them to us.

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.