General Ledger Correspondence

Correspondence of accounts is a method of accounting, according to which each accounting operation is reflected in the same amount simultaneously in the debit of one account and the credit of another, as a result of which a double (correspondent) account appears between them. The general ledger correspondence functionality enables to:

• Create correspondence entries when posting general ledger entries.
• Create correspondence entries using a periodic job.
• Analyze reports on correspondence of general ledger accounts.

System Settings

Automatic creation of correspondence entries

To create general ledger correspondence entries automatically when posting a document:

1. Click the icon, enter General Ledger Setup, follow the link.
2. On the General FastTab, check the Automatic Corresp. Posting box.

Settings on the G/L account card

1. Select the icon, enter Charts of Accounts, follow the link.
2. Select an account from the list.
3. On the Reporting FastTab, enter information in the fields listed in the following table.

Field	Description
Unused in Correspondence	Select this option so that correspondence entries for this account are not created.
Correspondence Entry with VAT	Select this option to create correspondence entries for amounts including VAT for this account.
Corresponding GL Account Filter	Select the general ledger account to create correspondence entries according to the principle of double entry.

Creation of Correspondence Entries

General Ledger correspondence entry can be created automatically while posting documents or with a periodic job for posted documents.

To create a correspondence entry with a periodic job:

1. Select the icon, enter Create G/L Correspondence, follow the link.
2. In the Transaction Block Size field, specify the number of General Ledger transactions to be processed, which will allow splitting the operation into separate sets and process accumulated significant volumes of historical data.
3. On the Filter tab, set a filter for G/L entries. For example, enter the number of a required transaction to create correspondence entries.
4. Click OK.

To configure the execution of this recurring task, you can use Job Queue Entries. This will allow you to automatically trigger the creation of correspondence operations at the configured intervals.

To configure a job queue entry, follow these steps:

1. Click the button to open the Search function, enter Job Queue Entries, follow the link.
2. On the Job Queue Entries page, select and open the card for the operation responsible for the Create G/L Correspondence task.
3. On the Recurrency tab, configure the task's execution interval.
4. Click Process > Set Status to "Ready".

Analysis of correspondence entries

The General Ledger Correspondence page shows turnovers in the chosen period in correspondence. To analyze correspondence entries of G/L accounts:

1. Select the icon, enter G/L Correspondence, follow the link.
2. On the Filters tab, enter information in the fields listed in the following table.

Field	Description
Date Filter	Specifies the dates for which the information will be displayed.
View by	Specifies the period for which the information will be displayed. For example, day, week, month, quarter, year, accounting period.
G/L Account Filter	Specifies the filter for a G/L account.
Business Unit Filter	Specifies the filter for a business unit.
Global Dimension 1	Specifies the value of a Global Dimension 1 set on the General Ledger Setup page.
Global Dimension 2	Specifies the value of a Global Dimension 2 set on the General Ledger Setup page.
Show Debit/Credit Balance	Specifies if the debit/credit starting and ending balance of the G/L accounts will be displayed.

3. In the fields of the table, you can click on any value to view the entries in it.
4. Select Expand/Collapse row on the G/L Account No. field to collapse / expand the value in the context of the G/L sub-accounts.

G/L Correspondence report

The G/L Correspondence report shows the correspondence entries for each account. The report can be used to get an overview of general ledger account entries with correspondence and totals.

1. Select the icon, enter G/L Correspondence, follow the link. Alternatively, select Reports > General Ledger on the G/L Correspondence page.
2. On the Options tab, fill out the fields listed in the table below.

Field	Description
Period Beginning	Enter the start date of the period for the entries that you want to add to the report.
Ending of Period	Enter the end date of the period for the entries that you want to add to the report.
Without Double Entries	Select this option to print the report not including double entries.
Without Accounts Title Type	Select this option to print the report not including account titles.
Without Levels of Enclosure	Select this option to print the report not including levels of enclosure.
Interim Total	Select this option to print the report using interim totals.

3. Set up filters for G/L accounts on the Filter tab.
4. Fill in the fields on the Advanced tab, if necessary.
5. Click Print or Preview.