English | English
General ledger accounting
Here you can enable and set up system capabilities to maintain financial accounting in the chart of accounts.
Before you set them up, specify all the operational and financial settings. At least, enable:
- Basic enterprise operation settings
- Basic warehouse operations.
- Transactions with fixed assets
- Accounts payable and accounts receivable management
- Basic management accounting capabilities
Activate General ledger
Here you can enable core capabilities of the General ledger subsystem in the chart of accounts. You can use this chart of accounts to prepare financial statements in accordance with generally accepted standards or principles, including IFRS.
Paths
| Path | Master data and settings → Master data and sections → General ledger |
|---|---|
| In-app link EN code | e1cib/data/DataProcessor.AdministrationPanelERP.Form.InternationalFinancialAccounting |
| In-app link RU code | e1cib/data/Обработка.ПанельАдминистрированияУП.Форма.МеждународныйФинансовыйУчет |
What you can do after activation
Now you can access the main General ledger subsystem objects, including:
- Chart of accounts catalog
- Transaction (financial accounting) document
- Financial statements catalog
Activate Entries by operational accounting data
Here you can enable automatic creation of chart of accounts entries based on operational financial register data.
Paths
| Path | Master data and settings → Master data and sections → General ledger |
|---|---|
| In-app link EN code | e1cib/data/DataProcessor.AdministrationPanelERP.Form.InternationalFinancialAccounting |
| In-app link RU code | e1cib/data/Обработка.ПанельАдминистрированияУП.Форма.МеждународныйФинансовыйУчет |
What you can do after activation
You'll get access to system objects and settings for automatic creation of chart of accounts entries based on financial operational data, including:
- Configure accounting object entries catalog
- Configure postings for business transactions catalog
- General ledger posting workplace
By default, the Set up by accounting objects and their correspondence option is selected.
Note
All the settings below are for the Set up by accounting objects and their correspondence option.
You can also select Set up by business transactions. This option is considered outdated as it's a more complex approach to setting up generation of chart of accounts entries. We do not recommend that you use this option.
Extra dimension types of financial accounting catalog
Here you can create a list of dimensions that will be used as additional accounting dimensions for financial accounting accounts.
The application already has a preconfigured list of standard extra dimension types. Add only the missing dimensions to this list.
Create the list of dimensions required for accounting by chart of accounts within the project of standardization of the chart of accounts. For more information on how to use the chart of accounts, see below.
Paths
| Path | General ledger → Settings and catalogs → General ledger → Extra dimension types of financial accounting |
|---|---|
| In-app link EN code | e1cib/list/ChartOfCharacteristicTypes.FinancialExtraDimensionTypes |
| In-app link RU code | e1cib/list/ПланВидовХарактеристик.ВидыСубконтоМеждународные |
How to create an extra dimension type of financial accounting
1. Open the catalog and click Create.
2. Specify the Description.
3. Select Value type.
Activate Multiple charts of accounts
The application allows you to get automatic entries by various charts of accounts for the company and prepare multiple reporting options. These reporting options might comply with different accounting standards or concepts.
Here you can enable accounting by multiple charts of accounts with different structures and details. You can do it if at least one company of the enterprise group makes reporting by two or more different accounting standards or concepts. Otherwise, you can skip this step.
Paths
| Path | Master data and settings → Master data and sections → General ledger |
|---|---|
| In-app link EN code | e1cib/data/DataProcessor.AdministrationPanelERP.Form.InternationalFinancialAccounting |
| In-app link RU code | e1cib/data/Обработка.ПанельАдминистрированияУП.Форма.МеждународныйФинансовыйУчет |
What you can do after activation
You get access to the Chart of accounts catalog.
Chart of accounts catalog
Here you can create a list of ledger accounts that correspond to a specific system of accounting standards and concepts. It means that you need to create accounts for each chart of accounts.
Before you do that, standardize the current chart of accounts in accordance with the new system capabilities and do the following:
- Minimize the number of control accounts. Use only standard ledger accounts recommended by the applied accounting standards. Such accounts already contain the minimum classification by branches of accounting.
- Replace additional accounts and subaccounts with the dimension for a ledger account (extra dimension).
- If a ledger account is assigned only to generate management information (no standard requirements), change the information source. You can get the same information from management reports that use operational registers.
Do not add more than 3 extra dimensions for one account. It will lead to additional load on the server resources, so it will take significantly longer to create entries and run the month-end closing procedure. It will also reduce the speed of response to the actions of system users.
With standardization of the chart of accounts, the company can:
- Significantly simplify the setup of how business transactions are recorded in the chart of accounts. If there are fewer records of Financial accounting groups, there are fewer settings to generate entries.
- Reduce labor costs to support such settings in the system.
Paths
| Path | General ledger → Settings and catalogs → General ledger → Chart of accounts |
|---|---|
| In-app link EN code | e1cib/list/ChartOfAccounts.International |
| In-app link RU code | e1cib/list/Справочник.ПланыСчетовМеждународногоУчета |
How to create a ledger account group
1. Open the catalog, specify Account code, Order, and select the account it is subordinate to.
2. Specify description in the Main field and International name, if applicable.
3. Select Account kind.
Note
Assets. In the Trial balance report, the system automatically calculates the ledger account balance and allocates it to debit no matter whether the amount is positive or negative.
Liabilities. In the Trial balance report, the system automatically calculates the ledger account balance and allocates it to credit no matter whether the amount is positive or negative.
Assets/Liabilities. In the Trial balance report, the system automatically calculates the ledger account balance and allocates it to debit or credit depending on whether the amount is positive or negative.
4. Select the Account is a group and not used in entries check box.
How to create a ledger account
1. Open the catalog, specify Account code, Order, and select the account it is subordinate to.
2. Specify description in the Main and International namefields, and Details.
3. Select Account kind.
4. Select the Accounting by business units check box for the system to fill the Business unit dimension automatically in chart of accounts entries based on business transaction data.
5. Select the Accounting by lines of business check box for the system to fill the Lines of business dimension automatically in chart of accounts entries based on business transaction data.
6. Select the Quantitative check box for the system to automatically fill Quantity in chart of accounts entries based on business transaction data.
7. Select the Currency check box for the system to automatically fill Amount in currency in chart of accounts entries based on business transaction data. Select the Exclude from exchange difference calculation in the functional currency check box if you do not need to calculate exchange differences for this currency account.
8. Add Extra dimension types used for this account to the table, and select the Turnovers only check box if you do not need to identify this dimension for the account balance. Select the Currency check box for the system to identify this dimension for Amount in currency values. Select the Quantitative check box for the system to identify this dimension for Quantity values.
Activate Groups of financial accounting settings
Here you can activate special catalogs that link operational accounting objects to financial accounting objects in the chart of accounts.
Setting catalogs are divided by the following financial accounting sections:
- Cash and cash equivalent management
- Inventory accounting (by items)
- Accounts payable and accounts receivable management
- Income and expense management
- Fixed and intangible assets
Paths
| Path | Master data and settings → Master data and sections → Profitability & cost |
|---|---|
| In-app link EN code | e1cib/data/DataProcessor.AdministrationPanelERP.Form.InternationalFinancialAccounting |
| In-app link RU code | e1cib/data/Обработка.ПанельАдминистрированияУП.Форма.МеждународныйФинансовыйУчет |
What you can do after activation
Now you can access the catalogs:
- Fixed/Intangible assets accounting groups
- Cash accounting groups
- Income/expense accounting groups
- AR/AP accounting groups
- Inventory accounting groups
Fixed/Intangible assets accounting groups catalog
Here you can create financial accounting catalog records in the chart of accounts to specify them in the fixed/intangible asset management subsystem documents.
To create a list of cash accounting groups:
- Create records for each record of control ledger accounts related to this accounting section.
- If there are multiple charts of accounts, repeat the previous step for each of them.
- Merge identical records of different charts of accounts to standardize the catalog.
A group is assigned to fixed asset objects in the documents where fixed assets are recognized as assets but not in the Fixed assets catalog. You can find the field in the Fixed asset / intangible asset recognition document as well.
Paths
| Path | Assets management → Settings and catalogs → Fixed and intangible assets → Fixed/Intangible assets accounting groups |
|---|---|
| In-app link EN code | e1cib/list/Catalog.NonCurrentAssetsAccountingGroups |
| In-app link RU code | e1cib/list/Справочник.ГруппыФинансовогоУчетаВнеоборотныхАктивов |
How to keep the catalog structure
1. Open the catalog and click Create group.
2. Fill the Description field.
3. Select a parent catalog item.
How to create a record of the Fixed/Intangible assets accounting group
1. Open the catalog, select a Group, and click Create.
2. Specify the Description and Details.
3. Select Asset type: Fixed assets, Investment property, Intangible assets, or R&D expenses depending on the corresponding ledger account purpose.
AR/AP accounting groups catalog
Here you can create financial accounting catalog items in the chart of accounts to specify them afterwards in the AR/AP management subsystem documents.
To create a list of financial accounting group records:
- Create records for each record of control ledger accounts related to this accounting section.
- If there are multiple charts of accounts, repeat the previous step for each of them.
- Merge identical records of different charts of accounts to standardize the catalog.
To automatically specify a ledger account, select the AR/AP accounting groups catalog item in purchase or sales documents (in invoices). You can also set the AR/AP accounting groups values as the default ones in catalogs Contracts, Intercompany contracts, Special terms of sales, Special terms of purchase, and other. This way, the system will automatically fill the purchase and sales documents with the values of the selected contracts and agreements.
Paths
| Path | General ledger → Settings and catalogs → Financial accounting groups → AR/AP accounting groups |
|---|---|
| In-app link EN code | e1cib/list/Catalog.FinancialAccountingGroupsOfARAP |
| In-app link RU code | e1cib/list/Справочник.ГруппыФинансовогоУчетаРасчетов |
How to keep the catalog structure
1. Open the catalog and click Create group.
2. Fill the Description field.
3. Select a parent catalog item.
How to create an AR/AP accounting group
1. Open the catalog, select a group, and click Create.
2. Specify the Description and Details.
3. In the Used for AR/AP objects with: field, select customers, vendors, by agents or consignees, by sales consignors, by debtors by deposits or loans, by creditors by credits or loans, lessors, subcontractors, or carriers by booking depending on the corresponding ledger account purpose.
Note
This AR/AP accounting classification is universal and usually used in various accounting practices.
We recommend that you use this classification not only for the list of AR/AP accounting groups, but also for control ledger accounts.
4. Select the AR/AP in foreign currency is maintained check box if the Currency check box is selected for the corresponding ledger account.
Cash accounting groups catalog
Here you can create cash accounting groups to specify them in the Treasury subsystem documents.
To create a list of cash accounting groups:
- Create records for each record of control ledger accounts related to this accounting section.
- If there are multiple charts of accounts, repeat the previous step for each of them.
- Merge identical records of different charts of accounts to standardize the catalog.
Cash accounting groups are later used in the Bank accounts and Cash accounts catalogs.
Paths
| Path | General ledger → Settings and catalogs → Financial accounting groups → Cash accounting groups |
|---|---|
| In-app link EN code | e1cib/list/Catalog.GroupsOfFinancialAccountingOfCash |
| In-app link RU code | e1cib/list/Справочник.ГруппыФинансовогоУчетаДенежныхСредств |
How to keep the catalog structure
1. Open the catalog and click Create group.
2. Fill the Description field.
3. Select a parent catalog item.
How to create a cash accounting group
1. Open the catalog, select a group, and click Create.
2. Specify the Description and Details.
3. Select Cash.
Bank accounts catalog: Cash accounting groups
Here you can specify a Cash accounting group for all the Bank accounts catalog items.
Paths
| Path | Master data and settings → Master data → Bank accounts |
|---|---|
| In-app link EN code | e1cib/list/Catalog.CompaniesBankAccounts |
| In-app link RU code | e1cib/list/Справочник.БанковскиеСчетаОрганизаций |
How to set up a cash accounting group for a bank account
1. Open the catalog and open the previously created record.
2. On the Accounting information tab, select Financial accounting group.
Cash accounts catalog: Cash accounting groups
Here you can specify a Cash accounting group for all the Cash accounts catalog items.
Paths
| Path | Master data and settings → Master data → Cash accounts |
|---|---|
| In-app link EN code | e1cib/list/Catalog.CashAccounts |
| In-app link RU code | e1cib/list/Справочник.Кассы |
How to set up a cash accounting group for a company cash account
1. Open the catalog and open a previously created record. Click More actions → Allow attribute editing → Allow editing.
2. Select Financial accounting group.
Income/expenses accounting groups catalog
Here you can create income/expenses accounting groups to specify them in the Profitability & cost subsystem documents.
To create a list of income/expenses accounting groups:
- Create records for each record of control ledger accounts related to this accounting section.
- If there are multiple charts of accounts, repeat the previous step for each of them.
- Merge identical records of different charts of accounts to standardize the catalog.
Income/expenses accounting groups are later used in the Income items and Expense items catalogs.
Paths
| Path | General ledger → Settings and catalogs → Financial accounting groups → Income/Expenses accounting groups |
|---|---|
| In-app link EN code | e1cib/list/Catalog.IncomeExpensesAccountingGroups |
| In-app link RU code | e1cib/list/Справочник.ГруппыФинансовогоУчетаДоходовРасходов |
How to keep the catalog structure
1. Open the catalog and click Create group.
2. Fill the Description field.
3. Select a parent catalog item.
How to create an income/expenses accounting group
1. Open the catalog and click Create.
2. Specify the Description and Details.
3. In the Used to account for: field, select Expenses or Income depending on the economic purpose of the corresponding ledger account.
Expense items catalog: Income/Expenses accounting group
Here you can specify an Income/Expenses accounting group for all the Expense items catalog items.
Paths
| Path | Profitability & cost → Settings and catalogs → Income and expenses → Expense items |
|---|---|
| In-app link EN code | e1cib/list/ChartOfCharacteristicTypes.ExpenseItems |
| In-app link RU code | e1cib/list/ПланВидовХарактеристик.СтатьиРасходов |
How to set up a cash accounting group for an expense item
1. Open the catalog and open the previously created record.
2. On the Accounting and taxes tab, select Expense accounting group.
Income items catalog
Here you can specify an Income/Expenses accounting group for all the Income items catalog items.
Paths
| Path | Profitability & cost → Settings and catalogs → Income and expenses → Income items |
|---|---|
| In-app link EN code | e1cib/list/ChartOfCharacteristicTypes.IncomeItems |
| In-app link RU code | e1cib/list/ПланВидовХарактеристик.СтатьиДоходов |
How to set up a financial accounting group for an income item
1. Open the catalog and open the previously created record.
2. Select Income accounting group.
Inventory accounting groups catalog
Here you can create inventory accounting groups to specify them in the inventory accounting documents.
To create a list of inventory accounting groups:
- Create records for each record of control ledger accounts related to this accounting section.
- If there are multiple charts of accounts, repeat the previous step for each of them.
- Merge identical records of different charts of accounts to standardize the catalog.
Inventory accounting groups are later used in the Items catalog. You can also specify them as default values for the Item kinds catalog items. The system will automatically copy inventory accounting group values for new items of this Item kind.
Paths
| Path | General ledger → Settings and catalogs → Financial accounting groups → Inventory accounting groups |
|---|---|
| In-app link EN code | e1cib/list/Catalog.InventoryAccountingGroups |
| In-app link RU code | e1cib/list/Справочник.ГруппыФинансовогоУчетаНоменклатуры |
How to keep the catalog structure
1. Open the catalog and click Create group.
2. Fill the Description field.
3. Select a parent catalog item.
How to create an inventory accounting group record
1. Open the catalog and click Create.
2. Specify the Description and Details.
Item kinds catalog: financial accounting groups
Here you can specify a Cash accounting group for all the Item kinds catalog items.
Paths
| Path | Master data and settings → Master data → Item related catalogs → Items → Item kinds |
|---|---|
| In-app link EN code | e1cib/data/Catalog.ItemKinds |
| In-app link RU code | e1cib/list/Справочник.ВидыНоменклатуры |
How to specify a financial accounting group for a default item kind
1. Open the Item kinds catalog and open the record.
2. Click Default values and select the Financial accounting settings group.
Asset and liability items catalog: Ledger accounts
Here you can specify a default ledger account for each item of the Asset and liability items catalog.
Paths
| Path | Profitability & cost → Balance sheet statement → Asset and liability items |
|---|---|
| In-app link EN code | e1cib/list/ChartOfCharacteristicTypes.AssetLiabilityItems |
| In-app link RU code | e1cib/list/ПланВидовХарактеристик.СтатьиАктивовПассивов |
How to set up a ledger account for assets and liabilities item
1. Open the catalog and open the previously created record.
2. Click Item ledger accounts settings in default documents and specify the Ledger account for each chart of accounts. Fill additional dimensions depending on extra dimension settings for the chart of accounts.
Posting schema catalog
Specify principal settings to automatically generate entries in the chart of accounts.
The settings include the following sections:
- Accounting settings that are common for a specific chart of accounts.
- Period-end closing account settings.
- Exchange difference accounting settings.
- Settings of entries by accounting objects.
This instruction covers only setup by accounting objects. Setup by business transactions is not covered as it's outdated.
Accounting objects are a fixed list of accounting entities that include a set of residual financial registers for operational accounting and their individual resources (indicators). Accounting by accounting objects is based on the double-entry method. Accounting objects are grouped by financial accounting sections.
Paths
| Path | General ledger → Settings and catalogs → General ledger → Posting schema |
|---|---|
| In-app link EN code | e1cib/list/Catalog.FinancialAccountingPostingGenerationSetting |
| In-app link RU code | e1cib/list/Справочник.НастройкиФормированияПроводокМеждународногоУчета |
How to create a posting schema
1. Open the catalog and click Create.
2. Select Chart of accounts, specify Description and Details.
How to set up general accounting for a chart of accounts
1. Open the catalog and open the previously created record.
2. Select one of the Record decreasing adjustments options.
Note
You can select from the following options:
- Storno entries. In the corrective storno entry, debit and credit accounts match accounts of the entry being adjusted. The amount is negative.
- By reversal entries. In the corrective reversal entry, the amount sign matches the sign of the entry being adjusted. Debit and credit accounts are reversed.
3. Select the Classify into short-term and long-term assets and liabilities check box.
4. Select the Revenue entries VAT exclusive check box if necessary.
How to set up accounting object entries
1. Open the catalog and open the previously created record.
2. Click Configure accounting object entries.
3. In the Set up financial accounts workplace, under Accounting item, click the catalog and select the subordinate item. Under Ledger accounts of... on the right, click Financial accounting group of the corresponding accounting section and select Ledger account.
Note
You can also bulk fill ledger accounts:
- Select several Financial accounting groups.
- Click Fill in ledger account.
- Select Ledger account for bulk filling.
4. Repeat the setup for all other Accounting objects and Financial accounting groups.
How to set up period-end closing accounts
1. Open the catalog and open the previously created record.
2. Click Configure period-end closing accounts to open the workplace.
3. Under Continuing operation income closing, click Add and select all ledger accounts, on which enterprise income entries are registered.
4. Select Ledger account of income. The system will create entries for closing income ledger accounts in correspondence with it.
5. Under Continuing operation expense closing, click Add and select all ledger accounts, on which enterprise expense entries are registered.
6. Select Ledger account of expenses. The system will create entries for closing expense ledger accounts in correspondence with it.
7. Under Retained profit (loss) closing, click Add and select all ledger accounts, to which the system will transfer the aggregated company's income and expense amounts.
8. Select Ledger account of retained profit (loss). The system will create entries to allocate aggregated income and expenses to the company's retained profit in correspondence with it.
How to set up exchange difference accounting
1. Open the catalog and open the previously created record.
2. Click Configure exchange differences to open the workplace.
3. Under Exchange rate differences from revaluation of the amount in functional currency, select Profit account, Income item, Loss account and Expense item to register profit (loss) from revaluating an exchange difference. Add accounts excluded from revaluation.
4. Under Exchange rate differences from revaluation of the amount in presentation currency, select Profit account, Income item, Loss account and Expense item to register profit (loss) from revaluating exchange difference. Add accounts excluded from revaluation.
How to apply a posting schema for a company
1. Open the catalog and open the previously created record.
2. Click Use in companies at the top and then click Create.
3. In the Apply setting form, select a Company.
4. Specify the start date to apply the setting.
Import the Financial accounting model file
Here you can bulk import the data from an .xml file that has information for the following financial accounting catalogs:
- Chart of accounts
- Posting templates (if you use settings to record entries by business transactions)
- Financial statements
- Financial accounting groups
- Cash flow items
- Income items
- Expense items
- Asset and liability items
You can use this tool when all catalogs are created and standardized in another infobase and you need to migrate this data to the system.
Paths
| Path | Master data and settings → Master data and sections → General ledger |
|---|---|
| In-app link EN code | e1cib/data/DataProcessor.AdministrationPanelERP.Form.InternationalFinancialAccounting |
| In-app link RU code | e1cib/data/Обработка.ПанельАдминистрированияУП.Форма.МеждународныйФинансовыйУчет |
How to import an external file with financial model
1. Open the workplace, select an .xml file imported from another infobase, and click Next>.