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:
- Click the
icon, enter General Ledger Setup, follow the link. - On the General FastTab, check the Automatic Corresp. Posting box.
Settings on the G/L account card
- Select the
icon, enter Charts of Accounts, follow the link. - Select an 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. |
| Move Amount to Income Statement Accounts in Correspondence | Specifies that the amount of revenues and expenses will be transferred to the account specified in the correspondence filter or to the last line with the corresponding sign. |
Note The Move Amount to Income Statement Accounts in Correspondence field is responsible for the correct creation of correspondence when posting sales with a discount. That is, for all general ledger accounts for which discount accounting is performed, this field must be active, and accordingly, the general ledger account responsible for settlements with customers must be specified in the Corresponding GL Account Filter field.
To correctly create correspondence with the ACY for sales with a discount, you need to additionally configure the G/L account to which the profit will be recorded based on exchange rate differences when adjusting between the local and additional reporting currencies. To do this:
- Open the card of the corresponding G/L account;
- Go to Related > Account > Correspondence Amount Movements, fill in the following fields: G/L Account — automatically filled, corresponds to the account from which the table was opened; Document type — select Credit Memo from the list.
Note Also, make sure that in the card of the relevant G/L account, which accounts for the profit from exchange rate differences during the correction between the local currency and ACY, the field Move Amount to Income Statement Accounts in Correspondence is enabled, and the field Corresponding GL Account Filter is not filled.
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:
- Select the
icon, enter Create G/L Correspondence, follow the link. - 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.
- On the Filter tab, set a filter for G/L entries. For example, enter the number of a required transaction to create correspondence entries.
- 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:
- Click the
button to open the Search function, enter Job Queue Entries, follow the link. - On the Job Queue Entries page, select and open the card for the operation responsible for the Create G/L Correspondence task.
- On the Recurrency tab, configure the task's execution interval.
- Click Process > Set Status to "Ready".
Note For transactions in which the G/L account for debit and credit are the same, the amounts are not zero, equal in modulus and with the opposite sign (for example, when adjusting by the Red Storno method, if one of the accounts is not used in the correspondence), it is necessary to enable the function that will create a correspondence with a zero amount. To do this, open the SMART Feature Flags page and enable the function #84127 Reset Correspondence to zero if debit/credit corresponds with debit/credit other sign.
Generating correspondence entries with zero amounts
To generate correspondence for G/L entries with zero amounts, you must manually specify the account side in the Zero Correspondence Account Type field on the General Ledger Entries page. Zero correspondence entries are not created if this field is blank. Set the value for each G/L entry.
| Value | Purpose |
|---|---|
| Debit | The G/L account of the entry is used as the debit account in the zero correspondence entry. |
| Credit | The G/L account of the entry is used as the credit account in the zero correspondence entry. |
| Blank | The account side is not specified. If at least one entry included in processing has a blank value, zero correspondence entries are not created for the entire group. |
Zero correspondence entries are generated under the following conditions:
- The Amount and Additional-Currency Amount fields are zero in every entry in the group processed together by the system. If either amount is nonzero in at least one entry, the system applies the general correspondence creation logic.
- The Zero Correspondence Account Type field is filled in for every included entry.
- The included entries contain at least one entry with Debit and at least one with Credit. If all entries have the same account side, zero correspondence entries are not created.
Entries for accounts with Unused in Correspondence enabled are excluded from processing. The conditions are checked for the entries remaining after this exclusion.
To generate correspondence for already posted entries with zero amounts:
- Use Search to open the General Ledger Entries page and find the required entries.
- Set Zero Correspondence Account Type to Debit or Credit for every entry included in correspondence creation.
- Open Create G/L Correspondence. In the Transaction No. filter, explicitly specify the required transaction or range of transactions and run the task.
- Review the generated correspondence entries: their amounts in the local and additional reporting currencies are zero, and the debit and credit accounts match the specified account sides. The link to the G/L entry, dimensions, and source details are retained for each side.
Note An explicit Transaction No. filter regenerates correspondence: existing correspondence entries for the selected transactions are deleted and created again. Without this filter, the task processes transactions after the last transaction for which correspondence has already been created, so older entries with zero amounts may be excluded from processing.
For example, consider two G/L entries in the same transaction:
| G/L Account No. | Amount | Additional-Currency Amount | Zero Correspondence Account Type |
|---|---|---|---|
| 361000 | 0.00 | 0.00 | Debit |
| 701000 | 0.00 | 0.00 | Credit |
The system creates one correspondence entry: debit 361000, credit 701000, Amount of 0.00, and Amount (ACY) of 0.00.
If there are multiple debit or credit entries, the system pairs them sequentially in processing order. If one side has fewer entries, its last entry is reused for the remaining entries on the other side. For example, two debit entries and one credit entry produce two correspondence entries linked to the same credit G/L entry.
Note Generating zero correspondence entries for the relevant transactions is required for the correct generation of the SMART SAF-T for Ukraine report.
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:
- Select the
icon, enter G/L Correspondence, follow the 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. 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.
- Select the
icon, enter G/L Correspondence, follow the 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 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.
G/L Account Card report
For each selected G/L account, the G/L Account Card report shows the starting and ending balance, debit and credit turnover, and entries for the specified period. You can also include the correspondence accounts in the report.
- Select the
icon, enter G/L Corresp. General Ledger, and open the corresponding page. In the page lines, select a G/L account, and then select Print > G/L Account Card. - In Options, fill in the fields listed in the following table.
| Field | Description |
|---|---|
| Source Type Filter | Select one source type by which to filter the entries. After you select the type, Source No. Filter becomes available. |
| Source No. Filter | Specify the source number. When you open the lookup, the system shows the list that corresponds to the selected source type. To specify multiple numbers, use the standard OR filter operator, for example, 10000|20000. |
| Show Correspondence | Select this option to show correspondence accounts for the entries in the report. |
| New Page for GL Acc | Select this option to print the data for each G/L account on a separate page. |
| Including Closing Period Entries | Select this option to include closing period entries in the report. |
- Set the required filters in Filter: G/L Account. The No. field is automatically set to the G/L account from the selected line. If necessary, change it and set filters by date, business unit, or dimensions. Use Filter... to add other filters.
- Select Print or Preview.
The source type and source number filters are applied to the entries, starting and ending balance, and turnover for the period. If the same filter is set both in Options and manually in the totals filter section, the value from Options is applied. After you change the source type, select the source number again.