Create Account Translation Scenario

This document explains how you define a user-friendly name or identity for a specific accounting string. This makes it easier to identify the accounting strings when creating an invoice accounting string.

Background

This functionality is targeted primarily to be used when there is a need for companies to translate or group accounts when creating a Standard Audit File for Tax (SAF-T) or general ledger report.

When generating a Standard Audit File for Tax (SAF-T) or general ledger report, mandatory additional information about the accounts is sometimes needed. For example, accounts may need to be grouped into certain levels or put in specific categories to cover special needs or laws that may apply in a specific country.

This functionality allows companies to be able to translate accounts when a different legal chart of accounts than that in 'Accounting Identity. Open' (CRS630) is used.

This functionality is available in these programs:
  • 'Standard Audit File. Create' (AAS300)
  • 'SAF-T Audit File. Create' (TXP360)
  • 'General Ledger. Print Balance Lists' (GLS510)
  • 'Ledger. Print' (GLS640), Report Layout 1 (General Ledger) only
  • 'Legal Trial Balance. Print' (GLS755)
  • 'Fiscal Journal. Print' (GLIT70).

Limitations

This functionality is only valid for certain output file formats, depending on the SAF-T version when generating a SAF-T report in 'Standard Audit File. Create' (AAS300).

Outcome

The account translation is selected when generating an SAF-T report in (AAS300) or (TXP360), or when generating a general ledger report in applicable programs, in order to use this functionality.

Before you start

  • The company's chart of accounts must be entered in 'Accounting Identity. Open' (CRS630).
  • Grouping IDs must be defined in 'Acc Translation Scenario Grouping. Open' (GLS032) if the account translation scenario should contain group levels. See Grouping Identities in this document.

Follow these steps

  1. Start 'Acc Translation Scenario. Open' (GLS030).
  2. On (GLS030/B) specify a scenario ID in 'Scenario' and the accounting dimension that should be translated in 'Dim'.
  3. On (GLS030/B) select option 1-'Create'.
  4. On (GLS030/E) specify a description for the account translation scenario. Click Enter/Next.
  5. On (GLS030/B) define the details for the account translation scenario. Enter a 'from' account identity in 'From account ID' and select option 1-'Create'.
  6. Specify the detailed information fields in 'Acc Translation Scenario. Open Details' (GLS031/E) as described in 'Settings description' below. Click Enter/Next.
  7. A warning message is displayed if other selections exist for a category with the same name.
    1. Click OK to update all categories with the same name with the current field setting, or
    2. Click Cancel to go back and change or rename the category.

Settings description

This table shows the required selections on (GLS031/E). When applicable, comments for the different SAF-T format are provided. The setup must be made according to the countries standard for SAF-T reporting.

Field The field indicates...
From account ID ...an account from (CRS630). This is either an account, if it is a one to one relationship between from and to account IDs, or the starting account in a range of accounts.

This is a mandatory field.

To account ID ...an account from (CRS630). This can be the same account as the 'From account ID', or the end of a range of accounts. Once an account is included in an existing range, it cannot be included in a new one.

This is a mandatory field.

Category ...the category of the range. It is primarily used to update/translate the account ID in the XML when generating an SAF-T report.

This can be left blank. In that case, all valid accounting IDs in the range use their respective account ID and description from the chart of accounts in (CRS630) to populate the SAF-T file. Other values such as category code, taxonomy code, and grouping levels are retrieved from the detailed fields defined on that range.

Category desc ...the description associated with the category. It can be used to translate the description of an accounting ID to another language.

This field is mandatory if the field 'Category' is used.

Accountng type ...the accounting type used for SAF-T reporting.
Category code ...the category associated with the accounts in the range. For example, it can be used to distribute accounts into specific categories such as assets, liabilities, and owner's equity.
Taxonomy code ...the taxonomy code that is required by the tax authorities in certain countries.
Acc grouping 1 ...the subcode for grouping the accounts in the range. The subcode is retrieved from (GLS032) and can be used as the first grouping level for the accounts.
Summary amounts ...if the grouping ID connected in 'Acc grouping 1' has 'Summary amounts' selected in (GLS032). In (GLS031) this is only a display field to make it easier to get an overview and maintain ranges.
Acc grouping 2 ...the subcode for grouping the accounts in the range. The subcode is retrieved from (GLS032) and can be used as a second grouping level, or as additional information to the accounts in the range.
Summary amounts ...if the grouping ID connected in 'Acc grouping 2' has 'Summary amounts' selected in (GLS032). In (GLS031) this is only a display field to make it easier to get an overview and maintain ranges.

This table shows the required selections on (GLS031/F). The (GLS031/F) panel is only available if country version 'PT' is set in (MNS100).

Note: This setup is made for Portugal SAFT reporting only.
Field The field indicates
Acc grouping 3 ...the subcode for grouping the accounts in the range. The subcode is retrieved from (GLS032). You can also use this subcode as the third grouping level for the accounts.
Summary amounts ...if the grouping ID that is connected in 'Acc grouping 3' has 'Summary amounts' selected in (GLS032). In (GLS031), this field is only a display field to make it easier to get an overview and maintain ranges.
Acc grouping 4

...the subcode for grouping the accounts in the range. The subcode is retrieved from (GLS032). You can also use this subcode as the fourth grouping level for the accounts.

Summary amounts ...if the grouping ID that is connected in 'Acc grouping 4' has 'Summary amounts' selected in (GLS032). In (GLS031), this field is only a display field to make it easier to get an overview and maintain ranges.
Acc grouping 5

...the subcode for grouping the accounts in the range. The subcode is retrieved from (GLS032). You can also use this subcode as the fifth grouping level for the accounts.

Summary amounts ...if the grouping ID that is connected in 'Acc grouping 5' has 'Summary amounts' selected in (GLS032). In (GLS031), this field is only a display field to make it easier to get an overview and maintain ranges.
Acc grouping 6 ...the subcode for grouping the accounts in the range. The subcode is retrieved from (GLS032). You can also use this subcode as the sixth grouping level for the accounts.
Summary amounts ...if the grouping ID that isconnected in 'Acc grouping 6' has 'Summary amounts' selected in (GLS032). In (GLS031), this field is only a display field to make it easier to get an overview and maintain ranges.
Acc grouping 7

...the subcode for grouping the accounts in the range. The subcode is retrieved from (GLS032). You can use this subcode as the seventh grouping level for the accounts.

Summary amounts

...if the grouping ID that is connected in 'Acc grouping 7' has 'Summary amounts' selected in (GLS032). In (GLS031), this field is only a display field to make it easier to get an overview and maintain ranges.

Acc grouping 8 ...the subcode for grouping the accounts in the range. The subcode is retrieved from (GLS032). You can use this subcode as the eighth grouping level for the accounts.
Summary amounts ...if the grouping ID that is connected in 'Acc grouping 8' has 'Summary amounts' selected in (GLS032). In (GLS031), this field is only a display field to make it easier to get an overview and maintain ranges.
Acc grouping 9 ...the subcode for grouping the accounts in the range. The subcode is retrieved from (GLS032). You can use this subcode as the ninth grouping level for the accounts.
Summary amounts ...if the grouping ID that is connected in 'Acc grouping 9' has 'Summary amounts' selected in (GLS032). In (GLS031), this field is only a display field to make it easier to get an overview and maintain ranges.

Grouping identities

This is used to maintain subcodes for grouping of accounts. The subcodes are necessary in cases where accounts need to be grouped in different levels when creating an SAF-T.

The 'Grouping ID' can be created by selecting 'Summary amounts'. When this is done, and the group is connected to an account translation scenario that is selected when creating the SAF-T report, the grouping ID is printed as an account ID in the SAF-T report with summarized amounts from the related accounts.

The grouping ID that is created in (GLS032) can later be defined in fields 'Acc grouping 1' and 'Acc grouping 9' in (GLS031).

Follow these steps

  1. Start (GLS032).
  2. On (GLS032/B1) specify an identity for the group in 'Grouping ID'.
  3. On (GLS032/B1) select option 1 - Create.
  4. On (GLS032/E) specify a description and name for the account translation scenario. If you create a grouping ID with a description but leave the name blank, the first 15 characters of the description are automatically used as the name.
  5. Select the check box if the grouping ID should be printed as an account ID in SAF-T reporting, and to summarize the amounts from the related accounts.
  6. Click Enter/Next.