Search and fetch financial entries
Last updated
Was this helpful?
Last updated
Was this helpful?
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 .
