Daily Balances (tfgld2531m000)

Use this session to analyze the daily balances of ledger accounts for which you selected the Daily Balance check box in the Chart of Accounts (tfgld0508m000) session.

The session lists all finalized transactions of which the document date is within the selected date range that were posted to the selected ledger account.

The session shows:

  • The effect of each transaction on the ledger account balance
  • The opening balance of the ledger account on the first date of the date range
  • The closing balance of the ledger account on the last date of the date range
  • The total sums for the credit side and debit side for the given date range

LN calculates all the displayed amounts based on the transaction document dates. For example, if the selected date range is February 1 to February 29, a transaction with a document date in February that was posted to January, is not included in the opening balance for February 1.

To analyze the transactions of one single document date, enter the same date in the Document Date and the Document Date To fields.

You can define filters for the displayed data. For example, if you filter on a specific dimension, LN lists only the transactions that have a dimension within the dimension range set and the daily totals and the closing balance are only calculated for the filtered transactions. However, the opening balance does not change and include all the transactions up to the first date of the date range.

In this way, you can analyze the transactions for a specific dimension for the selected ledger account, and see how these transactions affect the balance.

Field Information

Company

The financial company for which you generate the report.

Ledger Account

The ledger account for which you generate the report.

You can only select ledger accounts for which you selected the Daily Balance check box in the Chart of Accounts (tfgld0508m000) session.

Document Date

The From and To fields define a range of: document dates of the transactions included in the report.

Home Currency

The home currency.

From the Tools menu, choose Rotate Currency to switch home currencies.

Opening Balance

The opening balance of the ledger account.

Debit Amount

The total debit amount of the listed transactions.

Credit Amount

The total credit amount of the listed transactions.

Closing Balance

The closing balance of the ledger account.