This report lists and graphs balances for each account in the system.
Report Details
Daily Account Balances Reports will generate as an excel file named as follows:
- BAL_[Engagement Name]_[Date and Time Report Generated]
The sheets for the report are:
- Transactions
- The same output as the Bank Transactions (SUM) Report. This is the data used to create the other two sheets.
- Balances
- This lists for every account a date and ending balance. The date range for each account starts from the first day of the first account period for that account, to the last day of the last account period for that account. Each day (that is part of an account period) will include a balance record.
- Balance Trending
-
This graphs over time the account balances for all accounts.
-
Daily Ending Balance Logic
For days without transaction data – the ending balance is calculated as follows:
- If the date with no transactions is within an account period, we will have the balance from a previous day. That balance is carried forward, as there is no activity.
- If the date with no transactions is not included within an account period, no known balance exists. The ending balance will show as blank.