Balance
The Balance dashboard for Sage XRT Advanced shows financial balances across banks, currencies, and companies. It includes converted credit, debit, and balance amounts, alongside balances by bank, company, and company group.
How to use the balance dashboard
- Follow converted credit, debit, and balance in a common currency across banks and companies.
- Compare balances by bank and by company to spot where funds concentrate.
- Drill into company groups to see credit, debit, and net balances at each level of the structure.
- Break down balances by bank, company, date, and group to see the same amounts from each angle.
Filters
Use the filtering panel at the top of the Balance dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.
Date: one value
Account Interco: multiple values
Balance Status: multiple values
Transaction Currency: multiple values
Key performance indicators (KPIs)
The key performance indicators (KPIs) at the top of the dashboard show three converted amount measures, and update based on the filters you apply.
| KPI | What it measures |
|---|---|
| Converted Credit | Total credit transactions converted into a common currency. |
| Converted Debit | Sum of debit transactions after conversion into a common currency. |
| Converted Balance | Net balance after conversion into a common currency. |
Visual components
| View name | Type of view | What it shows |
|---|---|---|
| Balance by Bank | Horizontal Bar | Compares debit, credit, and balance amounts across banks and currencies. |
| Balance by Company | Horizontal Bar | Follows balance evolution over time, such as monthly trends. |
| Balance Details by Group | Worksheet | Lists detailed data by company group, including credit, debit, and net balances. |
| Grouped Hierarchy | Historical | Displays company structures and their balances, with drill down into each level. |