You can easily add G/L Accounts in Avanti from your Financial System. Once imported, these can be used throughout Avanti.
Import File Overview
You can import a CSV or Excel file with an extension XLS or XLSX. Only the first sheet will import if you’re importing an Excel file.
If there are header rows in the file which shouldn’t be imported, you can enter the number of rows to skip during the import.
A sample Excel file is attached at the bottom of this article.
The column order in the import file must match the format outlined below. If you’re not importing information for a column, leave the column blank.
Column | Description | Contents and Format |
A | Account Number | The account number which must match the segment format. |
B | Description | The account description which can be up to 128 characters. |
C | Short Name | Optional. A shorter name for the account, which can be up to 10 characters. |
D | Type | Optional: A 1-character value representing the account type. There are different options available if you’re importing a Major Account. Available types for major accounts
|
For additional information about creating the file, go to the How To Create the Import File section at the bottom of this article.
How to Import G/L Accounts
Once you’ve updated the file, you can import the accounts.
Additional Information
We recommend importing into a test company before importing to your production company.
Step 1: Chart of Accounts in the Avanti Desktop Application.
By default, this can be found in Financial Systems.
Step 2: Select the segment you’re importing accounts.
Step 3: Select File in the upper-left corner, then click Import.
Step 4: Select the arrow beside Import File, and locate the file you’re importing.
Step 5: Enter the number of lines you’ve used for your header in the import file in Rows to Skip.
Step 6: Ensure Remove Existing Account is deselected unless you want to delete the existing G/Ls.
Additional Information
If this is checked, the system will delete all the existing G/L Accounts and will import the ones in the Import File.
Step 7: Select OK to import the file.
Important Information
The import begins as soon as you select OK.
Congrats! You’ve imported your G/L Accounts. If you need to import accounts for other segments, Repeat Steps 2 to 7.
How to Create the Import File
To create the import file, you can copy each column into a new Excel file. The columns of the file must be in the order below. If you’re not importing information in a column, leave the column blank.
Account Number - Required
The account number, which must match the segment format. You can find the format in G/L Account Format.
Description - Required
The account description, which can be up to 128 characters. We recommend keeping the description the same as it is in your accounting system.
Short Name - Optional
An abbreviated descriptive name for the account, which can be up to 10 characters.
Type - Optional
The 1-character value representing the account type.
Available types for major accounts:
A is for Current Asset Accounts, which are expected to be sold or otherwise used up in the near future. The time frame is usually within one year or one operating cycle, whichever is longer.
B is for Long Term Asset Accounts, which are expected to be useable for more than one year.
C is for Current Liability Accounts, which will be settled within the fiscal year or the operating cycle, whichever period is longer.
D is for Long Term Liability Accounts, which are to be settled in more than one year.
E is for Capital Account used to track the value of capital assets owned by an organization.
F is for Income Accounts used for revenue or income.
G is for Expense Accounts used for cost or expenditure.
H is for Statistical Accounts used to track non-financial information.