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:
- Choose the icon, enter General Ledger Setup, and then choose the related link.
- On the General FastTab, check the Automatic Corresp. Posting box.
Setting up on the G/L account card
- Choose the icon, enter Charts of Accounts, and then choose the related link.
- Select account from the list.
- 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:
- Choose the icon, enter Create G/L Correspondence, and then choose the related link.
- On the Filter tab, set a filter for G/L entries. For example, enter the number of a required transaction to create correspondence entries.
- Fill in the fields on the Advanced tab, if necessary.
- Click OK.
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:
- Choose the icon, enter G/L Correspondence, and then choose the related link.
- 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. |
- In the fields of the table, you can click on any value to view the entries in it.
- 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.
- Choose the icon, enter G/L Correspondence, and then choose the related link. Alternatively, select Reports > General Ledger on the G/L Correspondence page.
- 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 without including double entries. |
Without Accounts Title Type | Select this option to print the report without including account titles. |
Without Levels of Enclosure | Select this option to print the report without including levels of enclosure. |
Interim Total | Select this option to print the report using interim totals. |
- Set up filters for G/L accounts on the Filter tab.
- Fill in the fields on the Advanced tab, if necessary.
- Click Print or Preview.