/
Export GL Transactions to Excel

Export GL Transactions to Excel

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

 

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

image-20240401-222932.png
  • 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)

 

image-20240401-223126.png

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


Related content

General Ledger
More like this
GLTR Transaction Codes
GLTR Transaction Codes
More like this
Display Outstanding Sales Orders
Display Outstanding Sales Orders
More like this
Sales Commissions Based on Receipts
Sales Commissions Based on Receipts
More like this
Debtor - Factoring Open Item report
Debtor - Factoring Open Item report
More like this
TSplus - Download an Excel Spreadsheet from Minder using Web Browser.
TSplus - Download an Excel Spreadsheet from Minder using Web Browser.
More like this

Copyright Programmed Network Management PL 2023