Execu/Tech Systems, Inc.
Knowledgebase
Search:
850-747-0581 Email Website
Contents
 
:
IndexBookmarkPrint This Article

Home > Back Office > 3rd Party Accounting Interfaces > GL Export

This application will export GL data, generated at Night Audit in a file named GAGLTRAN.FIL, into a common format that can be easily imported into your own GL software. This application allows you to create a translation table between the PMS GL codes and your own GL software, ensuring that the exported file contains the most easily importable data. 

The application is ETGLExport.exe and it's located in the PMS software hotel folder on the server.  Locate and open the folder and then double-click ETGLExport.exe to run it.  If you wish, Execu/Tech will add this to your Manager or Night Audit menu or provide instructions upon request.

Settings

Although Settings is the second tab in the application, it's the first thing you need to know, so it's first in the instructions. Without properly configured settings, the export will fail. 

This is where you set up a translation table to link the PMS GL account with the accounting system accounts.

The Menu
    This will reload the settings file if someone else had modified it while the application is open. 
    This saves the settings. 
    This allows you to specify what type of file to generate.
You can choose between comma separated and tab separated. 
    This check box allows you to add a header to the export file. 
  In the Status Bar at the bottom left of the application window, you'll see the "Export File Save Location" which tells you where the export file is saved. This folder will be selected the first time you save an export file and will become the default folder for all manual and automatic export file creations. This folder can be changed at any time by performing a manual export and selecting a different save location.
           
Each account that needs to be imported, whether on the Execu/Tech side or the 3rd party accounting side needs to be listed on a separate line.

Each of the 3 columns must be filled out for each account.




Importing Account Numbers from Excel 

If you have a lot of account numbers in your accounting software or in the PMS software, you can create a worksheet in Excel to speed up this process.

This is how it works:
  • This overwrites the current account settings.

  • You'll need 3 columns, no header. All columns are required or the account won't work.
    1. The account in the PMS software
    2. The account in the accounting software
    3. A description

  • Save the file as a tab delimited format named ETGLExport.table.ini.

  • Copy this file to the PMS software folder.

  • Run the export application and you should see these accounts in the settings tab.

Review / Export

The Review / Export tab is where you can review the data to be exported, print a report of this data, and catch any potential errors before the import is completed.

The Menu 
    This loads the GL detail file created by the PMS.
This must be done before you can export. 
    This saves the new, formatted export file. 
    This prints an export report, showing you what will be exported and identifying any errors like out of balance credits and debits or any transactions without a matching  "Export Account".
    This lets you view a text representation of the file that will be exported. 



Exporting

The Export File

The export file will be placed in folder selected when you save. The Status Bar, at the lower left, will show you the default location.


The file name
Comma Delimited    GL-YYYYMMddhhmm.csv 
Tab Delimited    GL-YYYYMMddhhmm.tsv
YYYY=Year, MM=Month, dd=Day, hh=Hour, mm=Minute

A Comma Delimited export file saved on January 2, 2014 at 3:15am will be named:
GL-201401020315.csv


Manual Export
  1. Click the blue "Load" button to load the GL details from the PMS

  2. Review the displayed report to identify any errors and fix them if possible. 
    If there are missing "Export Accounts", you'll need to add them, save the settings, then reload the GL detail file.
    If you don't see a report appear with details, your exported file will be blank. Try again, you missed a step or there is no GL data to import.



  3. Print a copy of the GL Export Report if desired

  4. Click the green "Save" button and the export file will be saved.
After saving the export for the first time, the folder will be saved. This folder will be used when running in 'auto' mode.


Auto Export

An automatic export will run unattended with no report. It just creates the export file. You can create a scheduled task that runs:
ETGLExport.exe /auto

Or, it can be run automatically during Night Audit.

Sample Export File

This is a sample of the export file with a header in CSV format.

Company,Account,Journal,Description,Date,Amount,Comment
01,222-22222-222,SJ,"CASH",12/01/2010,2159.40,"101201    "
01,7777777777,SJ,"TV",12/01/2010,-2054.00,"101201    "
01,111-11111-111,SJ,"GUEST LEDGER",12/01/2010,100.00,"101201    "
01,333-33333-333,SJ,"DEPOSITS",12/01/2010,-164.32,"101201    "
01,444-44444-444,SJ,"CLEANING",12/01/2010,-41.08,"101201    "
01,111-11111-111,MJ,"GUEST LEDGER",12/01/2010,1834.00,"101201    "
01,4030.01,MJ,"",12/01/2010,-1834.00,"ROOMS=0019"
01,666-66666-666,AV,"LAUNDRY",12/01/2010,0.00,"ROOMS=0111"
01,222-22222-222,CA,"CASH",12/01/2010,-114.00,"101201    "
01,555-55555-555,CA,"MEALS",12/01/2010,114.00,"101201    " 





Article ID
 gl_export
Views
 3763
Last Modified
 4/1/2015 10:51 AM