Counter account analysis

Use this function to identify journals that do not have counter accounts. This analysis is carried out on the GACCENTRY and GACCENTRYD tables. From the search results grid, you can drill-down to the accounting entry and enter the missing counter account: a G/L account or a BP account.
The DATEV data model for accounting entries expects debit and credit accounts of a business transaction in a single journal line. Therefore, you need to provide the information on counter accounts for each accounting entry line. Accounting entries (resp. accounting entry lines) that are generated by upstream modules usually include the information on counter accounts. However, when an accounting journal is entered manually in the Journal entry function (GESGAS), you are not required to enter a counter account.
When exporting accounting entry lines via the DATEV export interfaces, missing counter accounts are replaced by the so-called DATEV intermediate account. By means of the intermediate account, the accounting journal is restructured and exported as a DATEV compliant accounting journal. However, this may lead to different balances in your journal and in DATEV and is therefore not desired.

Prerequisites

Refer to documentation Implementation

Screen management

Selection criteria

Company (field CPY)

Enter the company for which data will be transferred to the tax advisor.

Site (field FCY)

Enter the site for which accounting data will be transferred.

Ledger type (field LEDTYP)

Select the ledger type to search for accounting entry lines linked to that ledger.

Entry type from (field TYP)

Enter a range of entry types to search for accounting entry lines linked to a specific entry type or types within the range.

Entry type to (field TYP2)
Document number from (field NUM)

Enter a range of document numbers to filter for accounting entry lines linked to documents within that range.

Document number to (field NUM2)
Start date (field DATDEB)

Enter a date range to select records within that range.

End date (field DATFIN)

Tab number 1

The results in the grid only include Actual accounting journal entries because only this status is included in the DATEV export. Any other journal entry status, such as Active simulation, Off-balance sheet, and Template are not included in the results below.

Grid

Company (field CPY)

This field displays the company for the original accounting journal.

Site (field FCYLIN)

This field displays the site for the original accounting journal.

Entry type (field TYP)

This field displays the entry type used for the original accounting journal.

Document no. (field NUM)

This field displays the document number used for the original accounting journal.

Line number (field LIN)

This field displays the line number of the accounting line for the original accounting journal.

General accounts (field ACC)

This field displays the G/L account used in the accounting line.

Counterpart account (field OFFACC)

This field is empty when an account line appears in the search result. It indicates that a counter account is missing in the accounting line.

Sign (field SNS)

This field displays the accounting sign for the line.

Entry amount (field AMTCUR)

This field displays the net amount in the accounting line currency.

Entry currency (field CUR)

This field displays the amount in the account journal currency.

BP (field BPR)

This field displays the BP used in the accounting line if applicable.

Accounting document

Click Accounting document to view details for the document on the line in the Journal entry function (GESGAS) and to assign a counter account.
G/L accounts

Click G/L accounts to view the account linked to this line in the Accounts function (GESGAC).

Error messages

The only error messages are the generic ones.

Tables used

Refer to documentation Implementation