Preliminary remark - please read carefully

The selection of a chart of accounts has far-reaching effects on the entire ERP system beyond the actual financial accounting. We therefore recommend that you consult a financial accounting expert.

On request, however, we can offer you a system set-up service that will make all the expert settings for you.

Regardless of whether you decide in favour of an individual or a system chart of accounts, once you have chosen a template, it cannot be changed later. Set up your chart of accounts immediately after going through the setup wizard to ensure basic connections throughout the system.

1. overview of the chart of accounts

Scopevisio offers several predefined charts of accounts. The SKR03 and SKR04 charts of accounts close to DATEV are most commonly used in Germany.

If you select one of these standard charts of accounts in the setup wizard, the system automatically sets up

the G/L accounts contained in the chart of accounts,
the complete tax matrix and the advance VAT return
the financial reports (work reports) associated with the chart of accounts.

This gives you fully usable financial accounting as part of the ERP system.

2. basics: chart of accounts vs. chart of accounts

Chart of accounts (SKR)

The chart of accounts includes all theoretically available accounts, even those that do not fit your company.
Example: In SKR03 you will find accounts for balance sheet preparers, revenue-surplus calculators as well as for partnerships and corporations.
You can transfer accounts from the chart of accounts to the chart of accounts or remove them again.

Chart of accounts

The chart of accounts only contains the accounts you use.
This provides a better overview, e.g. in drop-down lists.
You can find the chart of accounts under:

Organisation > Master data > Finances > Manage accounting > Chart of accounts or
Settings > Finances > Account master > Chart of accounts.

3. when you should create your own chart of accounts

Only use an individual chart of accounts if none of the standard charts fit.
If your chart is based on SKR03 or SKR04 (also extended), you should start with a standard chart of accounts if possible.
You can customise this and:

adapt existing accounts or
add new accounts by duplicating them.

4. important to know

Once a chart of accounts has been selected, it cannot be changed later.
Set up your standard chart of accounts directly when going through the setup wizard.
The setup affects the entire system - it is intended for financial accounting experts.
On request, you can receive support from our consultants (subject to a charge).

5. how to set up your individual chart of accounts

Sequence of steps

Go through the setup wizard
Create chart of accounts
Set up tax matrix if no standard chart of accounts has been used
Set up advance VAT return if no standard chart of accounts has been used
Assign accounts to the work reports (balance sheet, P&L, BWA) if no standard chart of accounts was used
Check other settings
If a standard chart of accounts is used, check the created tax matrix and advance return for tax on sales/purchases.

Step 1: Setup wizard

Start the setup wizard and go through the steps up to the Finances tab.
Under Finances, select the "Customised" template.
Follow the system instructions.
Exit the wizard via the Banking and Settings tabs.

You cannot create a house bank without an associated G/L account.
You can add the house bank later.

Step 2: Create G/L accounts

You can import your accounts

import them from a legacy system via CSV or
create them manually (see G/L account master).

Customise the number range

By default, 4-digit G/L account numbers are provided.
If you want to use longer numbers:

Open Settings > Finance > Accounting > Number ranges
Select the number range 1 - G/L accounts.
Click on Edit and adjust the Number of digits field. A maximum of 10 digits is possible - rarely necessary in practice.

Important: Once you have increased the number of digits, you cannot reduce the number of digits again.

Step 3: Importing G/L accounts via CSV

Go to OpenScope > Import & Export > Manage imports.
Select CSV import of G/L and subledger accounts and postings.
Open the G/L accounts tab - here you will find the import screen.

Mandatory fields for G/L account import
The following columns must contain values

Account (number of the G/L account)
Account name
Account type (asset, liability, asset/liability, costs, revenue)

Preparation of the G/L account import

It is best to edit the CSV file with raw data in Excel beforehand.
Enter the indicators and columns you require there.
For fields in the format YES/NO or checkboxes, select the import value TRUE (= yes or active) or FALSE at
.
Then save again in CSV format.

The other columns of the import mask are explained in more detail in the following table.