You can export sections of the GL transaction table to a csv file, which can then be imported into Excel if needed.
This is done in 2 parts:
Export the GL transactions to a ‘csv’ (comma separated value) file
Import that file into Excel
| Info |
|---|
The resulting file will be very large, Excel has a limit on the number of rows that can be imported, you may well exceed that and the import will fail. If that’s the case, break down the file into, say, 1 month chunks. |
Export Transactions as a ‘csv’ file
Transaction Reports are available via the Reports Module.
Main Menu
Reports
Transactions / Transactions
General Ledger Trans → Y
Select the correct Period range, the remaining defaults are fine.
Print (this could take some time if you have a large number of records)
The Report will be created, but this isn’t what we want, we need to export this data.
Select Export
Export
Select a Save File location & filename (use dot.csv)
File will now be exported as a ‘csv’ file.
Exit
Import into Excel
Open Excel first, don’t try and open the file directly, Excel has a bug & will screw up if you try this.
Most servers do not have Excel loaded, you may need to copy your ‘csv’ file onto a local desktop.
Open a ‘Blank’ workbook
Main Menu
Data
From Text / CSV
Select your file for Import.
Click on ‘Load’
Your file has now been Imported.
Save as an XLSX
At this stage the file is still a ‘csv’, you need to save it into an Excel format.
Change the name as appropriate.
Procedure complete