General Ledger Setup

Updated August 07, 2024 18:42

This article is part of series that describes the process of setting up (mapping) and using a GL feed in Avionté.

This article is designed for the setup of General Ledger in Avionte. Once the GL has been set up, the GL data produced by Avionté can be mapped and exported to a third-party accounting system (e.g. QuickBooks).

CHAPTERS

General Ledger Interactive Training Course
GL Setup Demo Video
GL Setup
Manage GL data in MS Excel
View Imported Data
Pull Data into 3rd Party Application

General Ledger Interactive Training Course

Click the image to access an interactive training course walking through the configuration and weekly process of the General Ledger feed.

GL Setup Demo Video

This video demonstrates the basic steps of the General Ledger setup.

GL Setup

Navigate to Main Menu > Back Office > Weekly Process
Click GL (General Ledger) on the Shortcuts menu. The GL Feed Form window displays. Setup tabs are displayed along the top of the window.
Click the GL Account Setup tab. The setup will occur right to left (with one exception) along the tabs.
Click the ‘+’ to the left of Actions. The “Initialize GL” drop-down menu becomes available.

Caution: Initializing the GL Account Setup will reset the existing GL configuration. If any of this process is already completed, up to and including mapping of accounts, do not Initialize.
In the GL Category drop-down menu, select a Category.
In the Account grid below, check the “IsVisible” box next to items to be shown in the GL Journal Entry.
After all applicable items have been selected from each available Category, click the GL Account Option tab.
In the GL Category drop-down menu, select a Category.

In the Select Column grid, click on a column name to display that column name's group options in the Select Group Option grid to the right.
Place a checkmark next to a GroupOption to indicate the level at which the option will be applied.
Click the Generate Account Mapping button after the levels have been indicated.

Note - A Create Mapping warning will appear after clicking Generate Account Mapping that says "Creating mappings from this tab will result in mappings for every possible grouping combination and may fail to process. Do you wish to continue? Ok/Cancel". Click "OK" to proceed.
Repeat this process for each GL Category in the drop-down menu until all categories have been addressed.

Click the GL Account Mapping tab. The GL Account Mapping tab displays the breakout level options selected in the previous tab.
Click the Refresh button if expected breakout levels fail to display. Refresh reloads the data and reflects any changes to the account descriptions or numbers.

Pagination is used in this tab. The Rows Per Page control determines how many records are displayed in a page.
The Search fields at the top of the tab can be used to find and filter the records that are shown.
- The grid updates when you tab off or click off the fields.
The navigation arrows at the bottom of the tab load the expected page.
The fields for Category and Display Name show all options available for the respective setup that is currently active.
- Text fields can be typed or have partial entries.
- The text fields auto-complete to suggestions from the list, but can be avoided if necessary.
Export to Excel shows a dialog regarding what to export:
- Exports with all selected data based on the subset/search items. Either the currently visible grid or the whole set will be exported
- Otherwise, the whole table will be exported
Selecting the System Mapping tab shows the respective row's mapping values
Exclude Unmapped: This is an option to exclude unmapped accounts in the search

Notes BEFORE continuing	Ignore the Avionté Category name. Use the Description and DisplayName to inform mapping.
	Do not map the GL accounts until after verification of the journal entry break-down (next step).
	Verify the journal entry break-down after you have completed and closed at least one accounting period. Data can be test or live.
	It is always best practice to close the accounting period before GL is generated.

Click the GL Action Tab. The window displays the date range of the current accounting period.
For testing purposes, move the Start Date and End Date back one week to capture the data of the recently closed accounting period.
Click Generate Journal Entry.

Depending on the amount of data, this process may take a few minutes.
A "Complete!" confirmation displays when the process is complete.
Click the Journal Entry tab.

If the week was correctly closed, the Debit and Credit columns should balance.
Click the GL Account Mapping tab to proceed with mapping.
In the Account Number column, replace the ‘x-x-x-x’ with the respective account number from your accounting package.
The Export to Excel option can be used to leverage Excel's filtering options to assist with mapping.
- With this option, the mapping is actually exported out to a Microsoft Excel spreadsheet where it may be easier to filter and sort data.
The General Ledger has now been setup.

Manage GL data in MS Excel

To manage GL data in MS Excel the Avionté data will have to be exported to a spreadsheet, edited, then imported back into the Avionté system.

Click Export to Excel.
Save the spreadsheet to your PC.
In the spreadsheet, edit the data as you would in the application grid (shown above in step 15).
Save the updated spreadsheet to your PC.
On the main Avionté menu, open the Import Export section.
Click New Batch.
Enter a description into the Description field.
Select "GL Account Number Import" from the Mapping Group drop-down menu.
Select a Processing Method.
Click Browse in the file field.
Search for the recently saved spreadsheet on your PC.
Click Open on the windows screen to open the file in Avionté.
Click Finish on the Avionté Import Export Batch window.
Click Process Import Export Batch. A confirmation message informs the user that the data has been pulled into Avionté.

View Imported Data

Select Weekly Process from the Main Menu.
Click the GL button.
Click the GL Account Mapping tab.
View the updated mapping in the grid.

Pull Data into 3rd Party Application

To pull the data from Avionté into a 3rd party accounting platform (i.e. Quickbooks)

Select Weekly Process from the Main Menu.
Click the GL button.
Click Generate GL Feed. A .CSV file will be generated.
Save the .CSV file to your PC.
From the 3rd party platform, import the .CSV file from your PC.

If new mapping is ever needed (i.e. a new branch is added, or new transaction types), click the GL Account Option tab and Generate Account Mapping again to create the new options.
If a specific break-out is not required, an account does not need to be provided. The feed will ignore all items without an account.