Skip to main content
All CollectionsUser GuideFinancial Reporting
Enhanced Reporting - Account Balance by Currency
Enhanced Reporting - Account Balance by Currency

Select one or more Ledger Accounts to display the Ending balance for the Account(s) in any currency (regardless of reporting currency).

T
Written by Travis Lander
Updated over 3 months ago

Description

Display one or more Balance Sheet (Asset, Equity, Liability) Type Ledger Accounts in any fiat currency available under the Settings>Currency section. This report can be particularly helpful for reviewing bank accounts that are denominated in a foreign currency to the reporting currency of the SoftLedger Location.

Important Considerations

  1. All Journal Lines posted before and including the date selected in the report are used in calculating the balance displayed.

  2. The currency balances are calculated using the Forex Rates associated with the Journal Lines as of the Transaction Date for each Journal Line.

  3. This report is only available on an unconsolidated basis.

  4. Custom currencies aren't supported in this report.

Report Configurations

Configuration

  1. Location

    • Uses Location context if not set.

    • Only the Journal Lines from the selected location will be used.

  2. Date

    • Uses Date context if not set.

    • Journal Lines posted at or before this date will be used.

  3. Select Accounts By - Select one or more Ledger Accounts, grouped by:

    • Ledger Accounts - Allows for selecting one or more ledger accounts.

    • Subtypes - Allows for selecting one or more subtypes.

    • Report Groups - Allows for selecting one or more report groups.

  4. Accounts Selector - Once you determine the Ledger Account grouping, select one or more option.

  5. Currency

    • All Journal Lines that match the criteria will be converted to the selected currency using the Forex Rates from the Posted Currency of the Journal Line to the selected Currency based on the Transaction Date from the Journal Line.

  6. Journal Status - Allows filtering data based on Journal Status.

    • All - All journals are included

    • Draft - Only the journals not posted are included

    • Posted - Only posted journals are included

Export

Export this report to Excel is xlsx format, like the sample below:

Export

Did this answer your question?