Balance by Bank
The Balance by Bank dashboard for Sage XRT Advanced lists converted balances by bank and account. It includes the converted balance by bank code and account code, and the cash balance of each bank at the end of each month.
How to use the balance by bank dashboard
- Read the converted balance of each bank and account in the worksheet, grouped by bank code and account code.
- Follow the cash balance at the end of each month for each bank, next to the converted balance shown in the KPI.
Filters
Use the filtering panel at the top of the Balance by Bank dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.
Transaction Satus: multiple values
Account Interco: multiple values
Account Currency: multiple values
Visual components
| View name | Type of view | What it shows |
|---|---|---|
| Converted Balance by Bank and Account | Worksheet | Lists the converted balance by group, with the bank code and the account code. |
| Cash Balance by End of Month | Complex Sparkline | Displays the converted balance of each bank. |
| Converted Balance by Bank Code | KPI | Shows the converted balance for each bank code group. |