Summary Reports (Transactions + Balances)

At a Glance

Use a Summary Report to see your bank data end-to-end:

Opening balance → Transaction Activity → Closing balance
Build from Analysis or directly in Reports → Create Report
Break down your transaction activity by Inflows/Outflows (default), Tag, or G/L Tag
Toggle built-in checks for FX Delta and Data Completeness

We’re excited to introduce Summary Reports, designed to give you the most comprehensive and complete view of your bank data.

Summary Reports bring together your balances and transactions in one clear picture:

Comprehensive Data View
See your entire cash position: from opening to closing balances across one or more periods.
Flexible Transaction Categorization
Choose how your transaction activity is grouped:
- Inflows/Outflows (default) – debits vs. credits
- By Tag - cleanly review your tagged cashflows with built-in checks that highlight overlapping and uncategorized activity.
- By G/L Tag - cleanly review your transactions tagged by a specific set of G/L Tags.
Data Integrity & Completeness
Each report includes built-in checks to ensure accuracy:
- FX Impact – shows any gaps caused by daily FX conversion rate changes when multiple currencies are included and your report is in a cadence other than daily (can be toggled on/off).
- Data Completeness – confirms that daily net activity matches the change from opening to closing balances (can be toggled on/off).
- If reporting by Tags, we also offer checks that help you refine tagging rules and understand where data falls outside categories:
  - An ‘Other’ row includes transactions not tagged by the included tags.
  - A ‘Tag Overlap’ row captures transactions that are part of two or more tags that are included in the report.

You can build a Summary Report in two ways:

Build on the fly in Analysis, then save it to the Reports module (just like other report types today).
Or, directly from the Reports module by clicking Create Report → Summary Report.

Steps to Create a Summary Report

Open a Report Builder
- From Analysis, or
- From Reports → Create Report → Summary Report
Select Accounts
Use the account filter to include only the accounts you need. Filtering reduces noise and makes performance more responsive.
Choose Transaction Categorization
Options:
- Inflows/Outflows (default)
- By Tag
- By G/L Tag
(Optional) Format Your Report
- Reorder transaction activity rows
- Toggle data integrity rows (FX Delta, Data Completeness, Category Overlap, “Other”)
- Other Configuration Options:
  - Cadence - You can build reports by day (recommended), week, month, or quarter.
  ⚠️ Note on FX: When reporting across longer cadences with multiple currencies, FX fluctuations may create small gaps in your totals. Use the FX Impact toggle to add these adjustments.
(Optional) Select your Row Breakdown
1. Decide how you would like the rows to breakdown in your report. Options include Currency, Account, Entity, Entity Region, Entity Division, and Account Type.
Save Your Report
- Click Save in the top-right corner
- Give your report a clear name so colleagues can easily find it

Edit – Open a saved report and click Edit (top-right corner).
Export – Download data to CSV or XLSX. Click the download icon and choose your format.
Schedule Delivery – Automate recurring email delivery. Click the three dots → Schedule Email, then complete the setup form.

Connect balances and transactions into a single, intuitive flow
Get the most out of Tags and G/L Tags
Maintain strong data integrity checks
Share insights in formats familiar to Treasurers, FP&A teams, and other finance professionals

01. Why doesn’t my report tie out?

02. What if some transactions are missing categories?

03. Can I compare multiple account groups?

Yes. Use the account filter to include one or more accounts or groups in the same report. Choose how you'd like to compare each account group by making a Row Breakdown selection.

04. What does it mean if the Data Check row has a value?

The Data Check row helps verify the completeness and accuracy of your data in local currency. It does this by confirming that each account’s daily change in balance matches the net transaction activity for the same period.
Statuses:
- ✓ indicates everything ties out correctly, and no data is missing.
- Any other value - indicates there may be missing data or a mismatch between the balance change and transaction activity in local currency.

05. What is the FX Impact row?

If your report includes accounts in multiple currencies and is viewed in a cadence greater than daily (such as weekly, monthly, or quarterly), the FX Impact row shows the difference caused by exchange rate fluctuations over that period.
For example, if you hold AUD 200 throughout the month of August but your report is displayed in USD, the USD value will vary as the AUD-to-USD exchange rate updates. The FX Impact row captures this difference so you can see how currency movements affected your reported totals.
- In the extremely simple example above, if the FX Impact row is positive and there was no change in activity, it means the Australian Dollar strengthened against the U.S. Dollar. If it’s negative, the Australian Dollar weakened during that period.