Skip to main content

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. Choose the Search icon, enter General Ledger Setup, and then choose the related link.
  2. On the General FastTab, check the Automatic Corresp. Posting box.

Setting up on the G/L account card

  1. Choose the Search icon, enter Charts of Accounts, and then choose the related link.
  2. Select account from the list.
  3. On the Reporting FastTab, enter information in the fields listed in the following table.
FieldDescription
Unused in CorrespondenceSelect this option so that correspondence entries for this account are not created.
Correspondence Entry with VATSelect this option to create correspondence entries for amounts including VAT for this account.
Corresponding GL Account FilterSelect 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. Choose the Search icon, enter Create G/L Correspondence, and then choose the related link.
  2. On the Filter tab, set a filter for G/L entries. For example, enter the number of a required transaction to create correspondence entries.
  3. Fill in the fields on the Advanced tab, if necessary.
  4. 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:

  1. Choose the Search icon, enter G/L Correspondence, and then choose the related link.
  2. On the Filters tab, enter information in the fields listed in the following table.
FieldDescription
Date FilterSpecifies the dates for which the information will be displayed.
View bySpecifies the period for which the information will be displayed. For example, day, week, month, quarter, year, accounting period.
G/L Account FilterSpecifies the filter for a G/L account.
Business Unit FilterSpecifies the filter for a business unit.
Global Dimension 1Specifies the value of a Global Dimension 1 set on the General Ledger Setup page.
Global Dimension 2Specifies the value of a Global Dimension 2 set on the General Ledger Setup page.
Show Debit/Credit BalanceSpecifies if the debit/credit starting and ending balance of the G/L accounts will be displayed.
  1. In the fields of the table, you can click on any value to view the entries in it.
  2. 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. Choose the Search icon, enter G/L Correspondence, and then choose the related 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.
FieldDescription
Period BeginningEnter the start date of the period for the entries that you want to add to the report.
Ending of PeriodEnter the end date of the period for the entries that you want to add to the report.
Without Double EntriesSelect this option to print the report without including double entries.
Without Accounts Title TypeSelect this option to print the report without including account titles.
Without Levels of EnclosureSelect this option to print the report without including levels of enclosure.
Interim TotalSelect this option to print the report using interim totals.
  1. Set up filters for G/L accounts on the Filter tab.
  2. Fill in the fields on the Advanced tab, if necessary.
  3. Click Print or Preview.
© 2008 - 2023 SMART business