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.
On the Finance entries search page, select the .
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.