Skip to main content

Enhanced Reporting - Journal Lines by Currency

The Journal Lines report in any selected currency to display debit and credit values in that currency

Travis Lander avatar
Written by Travis Lander
Updated over a week ago

Description

The Journal Lines by Currency report includes the same details from the standard Journal Lines report, but in addition includes the ability to select a currency to see the transaction lines denominate the debit and credit values in that currency. This display of debit and credit values in any currency converts the existing posted currency of the journals to the selected currency using the transaction date exchange rate from the posted currency to the selected currency.

There is an optional selection on this report to select a single Ledger Account to see a Running Balance for that Ledger Account in any currency.

Caution: This report is informational, and is not used for any foreign currency processes like foreign currency remeasurement or entity consolidation of locations reporting in different currencies.

Report Configuration

Modes

This report can be displayed in two mode:

  • Standard - selection and display of journal lines in any currency

  • Running Balance - selection and display of journal lines in any currency for a specific ledger account to include a running balance in that currency

Configurations

Select the Journal Lines by Currency from the Report Type dropdown, and make subsequent selection for the Location(s) of Journal Lines to view, and the currency to display the debit and credit values in.

  1. Location: Choose the location to focus on for your report. The report will show journal lines for the selected location and its child locations.

    • Defaults to the Location Context Picker if not set

  2. Reporting Currency: Choose the currency to report in. The report will show journal lines in the selected currency

  3. Posted Debit/Credit values will be multiplied by the FX Rate for the transaction date to get the reporting currency values.

    • debit = debit * FX Rate

    • credit = credit * FX Rate

Optional Fields for Running Balance

4. Ledger Account: Select a ledger account and the report will show journal lines for the selected ledger account only, along with the running balance on each row.

5. Start Date: Choose the start date for journal lines.

6. End Date: Choose the end date for journal lines.

Note: You can not select a custom currency for the debit and credit currency display in this report.

Running Balance Details

  • This configuration works for a specific ledger account and date range and lists journal lines along with a running balance against each row.

    • Running balance is calculated by adding the debit/credit values of the current row to the running balance of the previous row.

  • Running balance of the first row includes the starting balance of the ledger account on the start date.

For more details on the fields, filtering, sorting, export, and table actions available for this report, review the standard Journal Lines report.

Did this answer your question?