Create Account Translation Scenario

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

Start 'Acc Translation Scenario. Open' (GLS030).
On (GLS030/B) specify a scenario ID in 'Scenario' and the accounting dimension that must be translated in 'Dim'.
On (GLS030/B) select option 1-'Create'.
On (GLS030/E) specify a description for the account translation scenario and the 'Transl det mtd' to be used when defining the translation scenario details in (GLS031).
These are the alternatives for 'Transl det mtd':
- 0-'Shared details': All accounting identity ranges in the same category use the same translation details. Updates to the current record’s translation settings apply to all records in the same category.
- 1-'Unique details': Each accounting identity range in the same category can have its own translation details. Updates affect only the current record, not other records in the category.
Click Enter/Next.
On (GLS031/B) define the details for the account translation scenario. Specify a from account identity in 'From account ID' and select option 1-'Create'.
Specify the detailed information fields on 'Acc Translation Scenario. Open Details' (GLS031/E) as described in Settings description section.
Click Enter/Next.
If the 'Transl det mtd' on (GLS030/E) is set to 0-'Shared details', a warning message is displayed if other selections exist for a category with the same name.
Click OK to update all categories with the same name with the current field setting. Optionally, 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	Description
From account ID	The field indicates 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	The field indicates an account from (CRS630). This ID 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 field is required.
Category	The field indicates the category of the range. It is primarily used to update/translate the account ID in the XML when generating an SAF-T report. You can leave this field 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 field indicates the description associated with the category. You can use this field to translate the description of an accounting ID to another language. This field is require if the field 'Category' is used.
Accountng type	The field indicates the accounting type used for SAF-T reporting.
Category code	The field indicates 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 field indicates the taxonomy code that is required by the tax authorities in certain countries.
Acc grouping 1	The field indicates 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	The field indicates 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 field indicates 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	The field indicates 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	Description
Acc grouping 3	The field indicates 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	The field indicates if the grouping ID 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 field indicates 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	The field indicates if the grouping ID 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 field indicates 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	The field indicates if the grouping ID 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 field indicates 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	The field indicates if the grouping ID connected 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 field indicates 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	The field indicates if the grouping ID 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 field indicates 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	The field indicates if the grouping ID 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 field indicates 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	The field indicates if the grouping ID 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

Grouping identities are used to maintain subcodes for grouping of accounts. The subcodes are necessary in cases where accounts must 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

Start (GLS032).
On (GLS032/B1) specify an identity for the group in 'Grouping ID'.
On (GLS032/B1) select option 1 - 'Create'.
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.
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.
Click Enter/Next.