Mapping both chart of accounts
Mapping allows transfer of transaction values in General Ledger from our chart of accounts to chart of accounts for external reporting. This mapping is set before data collection. If new account numbers are added to chart of accouts in the working database, then the mapping must be altered to include mapping for new accounts.
Mapping is done on panel Replace/Exclude Accounts:
As seen from picture, account number in working database si 1200. We have to transfer all transactions to account 4730. Type Replace is selected and replacemet is checked as active.
The following data must be entered for each mapping:
| Column |
Description |
| Account (affilliate) |
account from working database is entered. Special characters can be used (? and _) |
| Account (ours) |
account for external reporting from chart of accounts in the new database is selected |
| Name |
displayed name of account |
| Type |
We can exclude or replace transaction from working database |
| Being Established |
if checked then replacement/exclusion is done |
Import of mapping from external Microsoft Excel File
If mapping is prepared in Microsoft Excel file, it can be imported into program by clicking button Import Chart of Accounts:
The structure of the Excel file is:
- Subject
- Account for External Reporting
- Account in working database
- Type of action (Z - replace, I - Exclude)
- Enabled (T - enabled or F - Disabled)
| Column |
Description |
|
Subject
|
Affiliated company name |
|
Account in linked database
|
Accounts in source database |
| Account in master database |
Accounts in target databae |
| Type of action |
Z - replace, I - Exclude account |
| Enabled |
Setting is enabled (T) or disabled (F) |