Deutsch
|
English

Fill import template for G/L accounts

Property Management

IC2262
Property Management

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

  1. 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.

  • 0 | Fixed asset and capital accounts

  • 1 | Financial and personal accounts

  • 2 | Accrual accounts

  • 3 | Goods Receipt and Inventory Accounts

  • 4 | Operating expenses

  • 7 | Inventories of finished goods

  • 8 | Revenue Accounts

  • 9 | Carryover, capital, adjustment, and statistical accounts

E: Account Type

Selection of the account type for the G/L account. The available account types are predefined.

  • Expense account

  • Bank account

  • Revenue account

  • Sales tax account

  • Input tax account

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.

  • Account with automatic processing

  • Account without automatic processing

  • Create tax posting entry

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.

  • TRUE

  • FALSE

I: Outgoing invoice

G/L account can be selected when entering outgoing invoices.

  • TRUE

  • FALSE

J: Account category

Freely selectable account category for further explanation.

Rent

  1. Save the import file.

  2. You can now import the G/L accounts.

Take a look here too:

📄 Datenimport und -export über Excel IC1112

To product page
War dieser Artikel hilfreich?