Exporting G/L Transactions to Excel Spreadsheet
Using the “YTD General Ledger Export” Utility
This procedure creates a comma delimited (csv) file containing information from the G/L Year to Date postings file.
To access this Special Procedure, you will need to go in General Ledger > Utilities >Export/Import >YTD General Ledger Export.
Once you select the YTD General Ledger Export utility, the following screen will appear:
Fields
Export Path/File Name
In this field you will enter in a path and file name of the csv file to be created. Include the extension in the file name. This will enable windows to automatically open this file using Excel. For example: C:/gltrx.csv
Start Fiscal Period / Start Fiscal Year and End Fiscal Period / End Fiscal Year
Enter the range of months/years for which you would like to export G/L transactions. “SY”, “01-13”, and “EY” are permitted entries in the Fiscal Period fields.
Starting Account and Ending Account
Enter in the Starting account number and Ending account number for which you would like to export G/L Transactions. If you are not sure of the account number, use the Find button to browse to the account.
When you have finished entering in the above information, you will need to hit F2 to run the procedure.
If you are ready to continue, select ‘Yes’ to continue.
This message appears to notify you that the file has been created, located in the path you specified. Click on OK.
This message appears to notify you that the Procedure is complete. Click on OK. It will return you to the main DPHS screen.
Using My Computer or Windows Explorer, browse to the path you specified for the export location of the csv file.
Once you have located the file, double click on it & it will open in Microsoft Excel.
Sample Export File
The information contained in each column is outlined below.
|
Column A |
Account Number |
|
Column B |
Batch ID |
|
Column C |
Transaction Number |
|
Column D |
Transaction Description |
|
Column E |
Subsidiary Name |
|
Column F |
Journal Code |
|
Column G |
Transaction Date |
|
Column H |
Post Month |
|
Column I |
Post Year |
|
Column J |
Reference |
|
Column K |
Reversing Entry? |
|
Column L |
Adjustment? |
|
Column M |
Purchase Order |
|
Column N |
Invoice/Check Number |
|
Column O |
Amount |
|
Column P |
Debits |
|
Column Q |
Credits |
|
Column R |
Comments |
|
Column S |
Alternate Name/ID of Account |
If you have further questions, please visit our website www.dphs.com OR contact Data Plus Support.