Submit a ticket

General Ledger Setup

Updated on Follow
1 out of 1 found this helpful

Application Support Series: 
General Ledger
This article is part of series that describes the process of setting up (mapping) and using a GL feed in Avionté. This specific article is italicized and bold in the series table of contents below. 

 

General Ledger Setup

General Ledger Feed

 

Overview

This article is designed for setup of the 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). For GL mapping export instructions visit the GL Mapping and Export article. 

 

 

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 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.



    1. 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. 

    2. Place a check mark next to a GroupOption to indicate the level at which the option will be applied.

    3. Click the Generate Account Mapping button after the levels have been indicated. 

    4. 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.







      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.

 

 

  1. Click Export to Excel.

  2. Save the spreadsheet to your PC.

  3. In the spreadsheet, edit the data as you would in the application grid (shown above in step 15).

  4. Save the updated spreadsheet to your PC.

  5. On the main Avionté menu, open the Import Export section.

  6. Click New Batch.

  7. Enter a description into the Description field.

  8. Select "GL Account Number Import" from the Mapping Group drop-down menu.

  9. Select a Processing Method.

  10. Click Browse in the file field.

  11. Search for the recently saved spreadsheet on your PC.

  12. Click Open on the windows screen to open the file in Avionté. 

  13. Click Finish on the Avionté Import Export Batch window.

  14. Click Process Import Export Batch. A confirmation message informs the user that the data has been pulled into Avionté.

 

 

 

View Imported Data

  1. Select Weekly Process from the Main Menu.

  2. Click the GL button.

  3. Click the GL Account Mapping tab.

  4. 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)

  1. Select Weekly Process from the Main Menu.

  2. Click the GL button.

  3. Click Generate GL Feed. A .CSV file will be generated.
  4. Save the .CSV file to your PC.

  5. 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.

 

 


Have more questions? Submit a request

0 Comments


This space is for article feedback only. To make a request of the Avionté Support Team, please submit a ticket to https://support.avionte.com.