Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
The report on GL monthly entries presents the turnover for a specific set of GL accounts over a defined period of up to 31 days. Each line item in the report shows a particular GL account's total debits and credits (turnover), grouped by entry dimension values such as cost center, country code, product code, intra-organisational code, and currency.
To create a report on GL monthly entries:
Go to Finance > Reports > GL monthly entries.
Click Selected GL accounts to open a complete list of accounts for account-level selection adjustments.
Click the Search button to display the report preview, or click the Export as CSV button to start report generation.
Wait a moment to allow Tuum to finish the report generation.
The created GL monthly entries 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 monthly entries report includes the following data columns.
Month: The numerical representation of the month the GL entries occurred (e.g., 2 for February).
Year: The year the entries took place (e.g., 2026).
GL Account: The unique identifier for the general ledger account where the entry is recorded (e.g., 120010).
GL Account Name: The descriptive name of the general ledger account (e.g., Credit lines).
Country: The country code to which the entry is attributed (e.g., DK for Denmark).
Product: The reporting product code representing the specific product or service related to the entry (e.g., CL0002).
Cost Centre: The code for the cost center, indicating the department, project, or unit responsible for the transaction (e.g., MB410).
Intra Org: The intra-organisation code representing any internal transfers between different departments, divisions, or entities related to the transactions.
Debit Amount: The total monthly debit amount in the transaction currency.
Credit Amount: The total monthly credit amount in the transaction currency.
On the Search monthly GL entries page, select the .
The table below shows GL balances and turnovers 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.
Remove zero lines *
Yes/No
Select one of the following options:
Option Yes will include only active GL accounts in the report. Active GL accounts had non-zero balances before the reporting period or had turnover during the specified reporting period.
Option No will include all selected GL accounts in the report regardless of their balance or activity status.
Transaction currency *
List
Select currencies whose balances and turnovers you want to include in the report, or deselect the currencies whose balances and turnovers you do not wish to include.
GL account from
List
Select the first GL account, which starts the range of GL accounts whose balances and turnovers you want to include in the report.
GL account to
List
Select the last GL account, which ends the range of GL accounts whose balances and turnovers you want to include in the report.
Selected GL accounts
List
Select the GL accounts whose balances and turnovers you want to include in the report or deselect the GL accounts whose balances and turnovers you do not wish to include.
The report on GL balances and turnovers provides balances and turnovers for a predefined set of GL accounts over a certain period. You can generate one of the following reports:
A comprehensive report: this includes all accounts and transaction currencies for a specific period, such as the previous month.
A focused report: this includes accounts and transaction currencies of your interest within a custom date range.
To create a report on GL balances and turnovers:
Go to Finance > Reports > GL account balances.
Click on Selected GL accounts to open a complete list of accounts for account-level selection adjustments.
Click on the Export as CSV button to start report generation.
Wait a moment to allow Tuum to finish the report generation.
The created GL balances and turnovers 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 balances and turnovers report contains GL account number, type and name followed by:
Currency: the currency of the balances and turnovers.
Opening balance: the balance of the GL account at the beginning of the reporting period.
Debit turnover: the total debit turnover of the GL account during the reporting period.
Credit turnover: the total credit turnover of the GL account during the reporting period.
End balance: the balance of the GL account at the end of the reporting period.
On the GL account balances report page, select the .
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.
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.
The journals are designed to create datasets of financial entries regarding Tuum transactions that you can transfer to your company's accounting or ERP system. The Tuum system generates journals based on a custom schedule defined in your Tuum instance configuration, typically during the early hours of the banking day.
The outcome of that generation process results in one journal per transaction currency. Each generated journal contains financial entries for all transactions processed the previous day. The data aggregation level of the journal content depends on the GL account setup (entry or account) and journal aggregation setup.
All generated journal reports have CREATED status, indicating they have not yet been transferred to your company's accounting or ERP system. The journal status CONFIRMED means that the transfer to your company's accounting or ERP system has been successful.
To find the generated journal reports, go to Finance > Search > Journals.
Fill in the search parameter values and click the Search button to display the journals you want to export.
Click on the Identifier of the journal (e.g. ID-000000016384) to open the journal details view.
On the journal details page, you have two options for journal transfer.
You can send the journal directly to your company's ERP or accounting system when there is an interface between it and Tuum.
On the journal details page, click the Send journal to ERP button to start sending the journal directly to your company's ERP or accounting system.
Wait until the sending process ends with the Success or Failure:
In case of success, reload the journal details page to see if the journal status has changed to CONFIRMED and the Reference number of your company's ERP or accounting system assigned to the journal.
In case of failure, click the Send journal to ERP button again once the cause of the failure has been resolved.
Do not start the next journal sending process until the previous one is complete, whether it succeeds or fails.
To transfer the journal manually to your company's ERP or accounting system, follow the steps described below.
On the journal details page, click the Export CSV button.
Go to Reports > My reports to find the report you have exported.
Click on the report's name in the Files column to download the report into the downloads folder on your computer.
Fetch the journal from the downloads folder on your computer.
Upload the journal manually to your company's ERP or accounting system and store the journal's reference ID.
Go to the journal details page and click the Confirm journal button to set the journal status to CONFIRMED.
Fill in the value for the Reference number in the Confirm journal modal with the journal's reference ID you got as a result of the journal upload into your company's ERP or accounting system and click Confirm.
The journal report includes the following data columns.
Journal line ID: The unique identifier of the journal line.
Journal ID: The unique identifier of the journal.
Aggregated: A boolean value indicating the data aggregation, represented as True for aggregated data or False for not aggregated data.
External account ID: The ID of the external account related to the transaction.
GL account: The GL account number related to the transaction.
Direction code: A value indicating whether the entry is a debit or credit, represented as D for debit or C for credit.
Transaction Amount: The value of the transaction expressed in the currency used for the transaction.
Transaction currency: The currency in which the transaction has occurred.
Reporting amount: The value of the transaction expressed in the currency used for reporting.
Reporting currency: The currency in which the transaction is reported.
Description: The textual explanation of the related transaction.
Cost Centre Code: The code associated with the specific cost center related to the transaction.
Product code: The code associated with the specific product related to the transaction.
Intra org code: The code associated with the specific internal organisational unit related to the transaction.
Country code: The code associated with the specific country related to the transaction.
Financial event type code: The code associated with the specific financial event type related to the transaction.
Journal date: The journal creation date.
Tenant code: The code associated with the specific tenant related to the transaction.
On the Contra entry report page, select the .
- Send the journal directly from Tuum to your company's ERP or accounting system.
- Download the journal into the downloads folder on your computer and transfer it from there manually to your company's ERP or accounting system.
The table below shows the parameters for GL monthly entries report when 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 entries 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 entries you want to include in the report. Note: The selected date can be up to 31 days from the Entry date from.
GL account from
List
Select the first GL account, which starts the range of GL accounts whose entries you want to include in the report.
GL account to
List
Select the last GL account, which ends the range of GL accounts whose entries you want to include in the report.
Selected GL accounts
List
Select the GL accounts whose entries you want to include in the report or deselect those whose entries you do not wish to include.
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.
Finance provides the capability to search financial entries at the entry-level over the dedicated period of up to 31 days for a selected set of GL accounts. This capability lets you gather one-off entry-level reports displayed on the screen or downloaded in CSV. It is beneficial to closely examine and address discrepancies in your company's ERP or accounting system.
To search financial entries:
Go to Finance > Search > Finance entries.
Click Selected GL accounts to open a complete list of accounts for account-level selection adjustments.
Click the Search button to display search results on the screen.
Click the Export as CSV button to start the search-based report generation.
The created one-off entry-level 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 one-off entry-level report includes the following data columns.
Entry date: The date when general ledger account balance is updated, establishing the accounting period for that transaction in the general ledger.
Entry no.: The unique ID of the entry related to the transaction.
Direction: A value indicating whether the financial entry is a debit or credit, represented as D for debit or C for credit.
Account: The GL account number related to the financial entry.
Account name: The name of the GL account related to the financial entry.
Cost centre: The code associated with the specific cost center related to the financial entry.
Product: The code associated with the specific product related to the financial entry.
Country: The code associated with the specific country related to the financial entry.
Transaction Amount: The financial entry-related transaction amount valued in the transaction currency.
Transaction ccy: The currency in which the financial entry-related transaction has occurred.
Reporting amount: The transaction-related financial entry amount valued in the reporting currency.
Reporting ccy: The currency in which the transaction-related financial entry is booked in GL.
Exchange rate: The currency exchange rate applied to convert the transaction amount from transaction currency into the reporting currency.
Description: The financial entry-related textual explanation.
Exchange rate type: The identifier identifying the base rates used to convert values from the transaction to the reporting currency.
Tenant code: The code associated with the specific tenant related to the financial entry.
Intra-org code: The code associated with the specific internal organisational unit related to the financial entry.
Reversal: A boolean parameter indicating whether the financial entry-related transaction is a reversal TRUE or not FALSE.
Reconciliation type: The reconciliation business entity reference the financial entry to relates to.
Reconciliation ref: The reconciliation business entity name the financial entry to relates to.
Fin.event code: The code associated with the specific financial event type related to the financial entry.
Fin. event description: The textual explanation of the financial event type related to the financial entry.
Source: The source business module name that has caused the transaction related to financial entry.
Source ref: The source business module reference that has caused the transaction related to financial entry.
Source base ref: The base source business module reference that has caused the transaction related to financial entry.
Creditor iban: The account number of the financial entry-related creditor.
Debitor iban: The account number of the financial entry-related debtor.
Transaction id: The unique ID of the financial entry-related transaction.
Created date (UTC): The financial entry creation date per coordinated universal time.
Fin event reconciliation type: The financial event type of the financial entry-related transaction that reconciles the initial transaction.
Fin event reconciliation ref: The financial event reconciliation reference of the financial entry-related transaction that reconciles the initial transaction.
Fin. event source value date: The value date of the financial event of the financial entry-related transaction that reconciles the initial transaction.
Customer type: A value indicating the financial entry-related person type, represented as P for a private or L for a legal person.
Tuum Finance contains four reports you can create to transfer data into your company's ERP or accounting system.
On the Finance entries search page, select the .
In addition, you can at the entry-level over the dedicated period for a selected set of GL accounts to gather one-off entry-level reports, which will help you closely examine and address any discrepancies in your company's ERP or accounting system.
The table below shows the parameters for searching GL entries when requesting a one-off 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 entries 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 entries you want to include in the report. Note: The selected date can be up to 31 days from the Entry date from.
Entry number
String
Enter the Entry number for the financial entry you would like to find.
Journal ID
String
Enter the Journal number of the financial entries you would like to find.
Debit / Credit
toggle
Select to include or exclude debit or credit entries into the report.
GL account from
List
Select the first GL account, which starts the range of GL accounts whose entries you want to include in the report.
GL account to
List
Select the last GL account, which ends the range of GL accounts whose entries you want to include in the report.
Selected GL accounts
List
Select the GL accounts whose entries you want to include in the report or deselect those whose entries you do not wish to include.