Data import
Written by Hans Gastmayr
Updated at May 14th, 2025
If data is loaded from external accounting systems, two Excel formats are available for import by default. Additional formats can be provided in the respective customer installations.
If direct connections to Business Central or other ERP or accounting systems are used, data can also be imported directly.
Excel Format 1 with Intercompany Partner and Group Account:
1.) The client abbreviation is derived from the register name. M- must be used as a prefix before the client abbreviation. Only Excel registers beginning with M- will be imported.
2.) When interpreting Excel columns, the first Excel row is interpreted as the header row. The order of the columns is irrelevant during data import. The header of each data column must match the specified name.
| headline | Description |
| Date | Date of posting in financial accounting (posting period) |
| General ledger account | Group account |
| Amount | Amount of the booking (+ = debit, - = credit) |
| IC Partner | If it is an intercompany partner, the client abbreviation of the partner company should be entered in this field. |
| Receipt no. | Internal document number |
| Ext. document no. | To reconcile intercompany postings, the intercompany document number is created from the internal document number (sales documents) and the external document number (purchase documents). This enables intercompany reconciliation per document number. |
| Subsidiary ledger type | The following subledger types are supported: customer, creditor, bank account, asset number. |
| Subsidiary ledger no. | Number within the subsidiary ledger. (e.g.: customer number, creditor number) |
| Cost center | The cost center can be entered in this field for analysis purposes. |
| Posting text | For analysis purposes, the booking text can be entered in this field. |
Excel Format 2 without intercompany partner with local financial account:
1.) The client abbreviation is derived from the register name. M- must be used as a prefix before the client abbreviation. Only Excel registers beginning with M- will be imported.
2.) When interpreting Excel columns, the first Excel row is interpreted as the header row. The order of the columns is irrelevant during data import. The header of each data column must match the specified name.
| headline | Description |
| Date | Date of posting in financial accounting (posting period) |
| Local account | The group account and the intercompany partner are determined based on the local account. |
| Amount | Amount of the booking (+ = debit, - = credit) |
| Receipt no. | Internal document number |
| Ext. document no. | To reconcile intercompany postings, the intercompany document number is created from the internal document number (sales documents) and the external document number (purchase documents). This enables intercompany reconciliation per document number. |
| Subsidiary ledger type | The following subledger types are supported: customer, creditor, bank account, asset number. |
| Subsidiary ledger no. | Number within the subsidiary ledger. (e.g.: customer number, creditor number) |
| Cost center | The cost center can be entered in this field for analysis purposes. |
| Posting text | For analysis purposes, the booking text can be entered in this field. |
After importing the data, the totals of the data can be checked in the following view:
1.) Total amount in euros. If the source client's accounting is prepared in a different currency, the conversion will be based on the import rate.
2.) The euro amount per intercompany partner and group account is displayed. All other postings are displayed in the column without intercompany partners (= third-party transactions).
3.) Total amount in local currency.