General Ledger Interface

General Ledger Interface

 

 

 

OVERVIEW

 

The General Ledger interface function allows the user to set up the application to integrate with accounting software such as Quick Books™. The following is an outline of the tasks that need to be performed in order to export general ledger data into a separate accounting system. For detailed instructions on how to perform each task listed in the outline, see the referenced documentation topic.

 

General Steps:

 

  1. Setup Chart of Accounts (See Chart of Accounts Setup documentation for detailed instructions.)

    1. Account names defined in the Chart of Accounts must exactly match the existing account names in your bookkeeping system.

    2. Although the chart of accounts on your accounting system will contain many entries, you will only need to duplicate the chart of accounts entries to which you will be exporting data to.

    3. The account name is an alphanumeric field that can be defined by any combination of letters or numbers.

    4. Each account defined will hold debit and credit values.

 

  1. Setup General Ledger (See General Ledger Setup documentation for detailed instructions.)

    1. Set General parameters

    2. Assign transaction line type values to accounts

    3. Set Invoice Register parameters to export the General Ledger Invoice Register category

 

  1. Create General Ledger Export Job (See General Ledger Export Job documentation for detailed instructions.)

    1. General Ledger categories of data available to be exported:

images/ebx_-564170074.gif

 

images/ebx_-1819847642.gif

 

 

images/ebx_-1329652635.gif

 

 

 

The standard ‘Sales By Category’ report below shows the number of units, sales, cost, profit dollars and profit percent for each category defined for the inventory records sold. In our example, the inventory categories being used are Brakes, Electrical, Filters, and Tires. All inventory records without an assigned category will be classified in the Default category.

 

 

images/img00021.gif

 

 

 

images/ebx_1628621297.gif

 

The Data Field value descriptions reflect the data available from the column and row headings in the sample ‘Sales Recap’ report below.

 

 

images/img00022.gif

 

 

 

images/ebx_1452156399.gif

 

 

    1. Start Date and End Date parameters

    2. Export parameters

    3. Save/Update parameters - A file of data that meets the selected criteria will be created.

 

  1. Running General Ledger Export Job (See Running a Saved GL Export Job documentation for detailed instructions)

    1. Converts the data file created in the previous step to a new file in the format dictated by the importing program.

 

 

SETUP PROCESS

 

Chart of Accounts Setup

Setup General Ledger

Create a General Ledger Export Job

Running a Saved GL Export Job