Data import

For each company, you can also import the general ledger and the subsidiary accounts data from an Excel file.
The Data import tab appears on the document type created for Consolidated Financials statements.
Here is a description of this tab:

Import General Ledger Data
|
By clicking on this button, you can manually import the general ledger entries for each company.
 |
HINT
The structure of the general ledger import (Import GK):
- document number of the consolidated report
- entity
- account
- department
- cost carrier
- opening balance debit
- opening balance credit
- debit turnover
- credit turnover
- debit turnover for the period after date 2
- credit turnover for the period after date 2
|
|
Import Subsidiary Accounts
|
By clicking on this button, you can manually import the balance account.
 |
HINT
The structure of the import of the subsidiary accounts (Import SK):
- Consolidated statement document number
- Entity
- account
- Department
- cost carrier
- debit
- credit
- uncollected debit
- undue credit
- open item entity
- currency
- exchange rate
|
|