Exact Globe

Product Update 414: Grouping functionality for audit files introduced (French legislation)

A new setting for grouping audit files has been introduced. This enhancement is applicable to the French legislation.

By selecting GL as the grouping option, the opening balance entries will be grouped by general ledgers (as existing) whereas by selecting GL & Account, the opening balance entries will be first grouped by the general ledgers, and then further grouped by the debtor or creditor account for debtor or creditor general ledger. This setting is enabled only when the Include: Opening balance check box has been selected.

For further explanation, refer to the following scenarios:

Note: The GLs used in these examples, GL 1000 and GL 2000, are both debtor GL.

a)       When GL is selected as the grouping option

Opening balance entries:

GL 1000

Debit = 60, Credit = 50, Balance = 10 

GL 2000:

The opening balance entry in the generated audit file is as follows: 

The opening balance entries for GL 2000 are not included in the audit file due to the balance being “0”.

b)      When GL & Account is selected as the grouping option

Opening balance entries:

GL 1000

Account B1: Debit = 50, Credit = 50, Balance = 0

Account B2: Debit = 2, Credit = 0, Balance = 2

Account B3: Debit = 8, Credit = 0, Balance = 8 

GL 2000

Account B3: Debit = 150, Credit = 150, Balance = 0

Account B4: Debit = 50, Credit = 50, Balance = 0

The opening balance entries will first be grouped by the general ledgers, as follows:

Note: The opening balance entries for the GL 2000 are not included in the audit file due to the balance being “0”.

After the entries have been grouped by the general ledgers, the entries will further be grouped by the debtor or creditor account, as follows: 

Finally, the opening balance entries will be reflected in the generated audit file as follows: 

The opening balance entries for the B1 account are not included in the audit file due to the balance being “0”.