The table below shows GL contra entry report parameters for requesting a report. The required (mandatory) parameters are marked with a red asterisk (*).
Entry date from *
Date
Select the start date of the period for which you want to include balances and turnovers in the report. Note: The earliest date can be 3 months from today.
Entry date to *
Date
Select the period's end date for the balances and turnovers you want to include in the report. Note: The selected date can be up to 31 days from the Entry date from.
GL account *
List
Select the GL account whose contra entries you want to include in the report.
Source name
Text
Enter the source business module name that has caused the transaction related to financial entries (e.g., ACCOUNT_TRANSACTION).
Source ref
Text
Enter the source business module reference that has caused the transaction related to financial entries (e.g., ID-710441).
Reconciliation reference type
Text
Enter the reconciliation business entity name the financial entries to relate to (e.g., PAYMENT).
Reconciliation reference name
Text
Enter the reconciliation business entity reference the financial entries to relate to (e.g., PAYM-86479).
Amount from
Number
Enter the entry amount, which starts the range of amounts whose contra entries you want to include in the report.
Amount to
Number
Enter the entry amount, which ends the range of amounts whose contra entries you want to include in the report.
Transaction currency
List
Select the transaction currency which contra entries you want to include in the report.
Note: If no currency is selected, the report includes transactions in all currencies.
The contra entry report presents entries and contra entries (their opposites) on a particular account over a defined period of up to 31 days. Each line item in the report shows a specific entry and a single or two contra entries with their source and reconciliation references. For example, for the entry on the GL account 120010 for EUR -448.84, the contra entry is on the GL account 120013 for EUR 448.84.
To create a report on GL account contra entries:
Go to Finance > Reports > Contra entry.
On the Contra entry report page, select the report parameters.
Click the Export as CSV button to start report generation.
Wait a moment to allow Tuum to finish the report generation.
The created contra entry report will be available for download in CSV format.
Go to Reports > My reports to find the report you have created.
Click on the report's name in the Files column to download the report into the downloads folder on your computer.
The GL contra entry report includes the following data columns.
Fin event id: The unique identifier of the main transaction's finance event.
Entry Date: The date the primary transaction was recorded in the GL.
Main account code: The unique identifier for the general ledger account where the entry is recorded.
Main transaction amount: The main transaction amount.
Main transaction currency: The main transaction currency.
Contra account code: The unique identifier for the general ledger account where the contra entry is recorded.
Contra transaction amount: The contra transaction amount.
Contra transaction currency: The contra transaction currency.
Additional contra account code: The unique identifier for the general ledger account where the additional contra entry is recorded.
Additional contra transaction amount: The additional contra transaction amount.
Additional contra transaction currency: The additional contra transaction currency.
Source name: The source business module name that has caused the transaction related to financial entries.
Source reference: The source business module reference that has caused the transaction related to financial entries.
Reconciliation reference type: The reconciliation business entity name the financial entries to relate to.
Reconciliation reference: The reconciliation business entity reference the financial entries to relate to.
