Report on GL contra entries

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.

Request report

To create a report on GL account contra entries:

1. Go to Finance > Reports > Contra entry.

1. On the Contra entry report page, select the report parameters.

1. Click the Export as CSV button to start report generation.

2. Wait a moment to allow Tuum to finish the report generation.

Fetch report

The created contra entry report will be available for download in CSV format.

1. Go to Reports > My reports to find the report you have created.

1. Click on the report's name in the Files column to download the report into the downloads folder on your computer.

Report content

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.

The columns Additional contra account code, Additional contra transaction amount, and Additional contra transaction currency are mostly empty. Values are present in these columns only when two related contra entries exist. For instance, when a transaction utilises both a deposit balance and an overdraft balance simultaneously, the payment transaction will result in two debit entries and one credit entry.