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
All Journal Lines posted before and including the date selected in the report are used in calculating the balance displayed.
The currency balances are calculated using the Forex Rates associated with the Journal Lines as of the Transaction Date for each Journal Line.
This report is only available on an unconsolidated basis.
Custom currencies aren't supported in this report.
Report Configurations
Location
Uses Location context if not set.
Only the Journal Lines from the selected location will be used.
Date
Uses Date context if not set.
Journal Lines posted at or before this date will be used.
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.
Accounts Selector - Once you determine the Ledger Account grouping, select one or more option.
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.
Journal Status - Allows filtering data based on Journal Status.
All
- All journals are includedDraft
- Only the journals not posted are includedPosted
- Only posted journals are included
Export
Export this report to Excel is xlsx format, like the sample below: