The import template for general ledger accounts must be filled out according to specific guidelines. The columns highlighted in yellow are required fields and must be filled out. The fields "Account Class," "Account Type," and "Financial Accounting Export Posting Record" are dropdown fields and must be selected from the provided options. The fields "Incoming Invoices" and "Outgoing Invoices" are checkboxes that can be checked or unchecked.
Prerequisite
The Excel import template was downloaded from the General Ledger Accounts table
Procedure in the FM Portal
Fill out the Excel table according to the following guidelines:
Column | Description | Example values |
|---|---|---|
A: G/L Account | Freely selectable general ledger account number. The first digit should represent the account class. | 2315 (for account class "2 | Accrual accounts") |
B: Description | Freely selectable short and unique description of the G/L account. | Input tax, reduced rate (7.0%) |
C: Description | Freely selectable purpose of the G/L account for further explanation. | Expense |
D: Account class | Selection of the account class for the general ledger account. The available account classes are predefined. |
|
E: Account Type | Selection of the account type for the G/L account. The available account types are predefined. |
|
F: Financial Accounting Export Posting Record | Type of Financial Accounting export posting record that defines how posting records assigned to the G/L account are exported. |
|
G: Different Financial Accounting G/L Account | Here, a different financial accounting G/L account can be specified for the G/L account. | 61410 |
H: Incoming invoice | G/L account can be selected when entering incoming invoices. |
|
I: Outgoing invoice | G/L account can be selected when entering outgoing invoices. |
|
J: Account category | Freely selectable account category for further explanation. | Rent |
Save the import file.
You can now import the G/L accounts.