Below you will find examples of reports that you and your teams can create, broken out by department (Treasury, Finance, & Accounting), to bring enhanced cash visibility to your business.

Setup: This transaction report is grouped by specific Tags with a Weekly Cadence over 13 Weeks in a Stacked Bar Chart format.

Purpose: This report breaks down cash flow activity based on the categories relevant to your business. Users can better understand the directionality of their cash flow based on this historical data, and even leverage learnings to project future cash flows for any (or all) transaction categories.

Setup: This transaction report is filtered by AR - Total Tag and grouped by Tag with a Weekly Cadence over the current Quarter in a Stacked Bar Chart format and Summary (Total) Column toggled on.

Purpose: This report shows the company's AR totals on a weekly basis over the entirety of the current quarter.

Setup: This transaction report is filtered by AR - Total Tag and Region (Legacy) and grouped by Region (Legacy) with a Weekly Cadence over the current Quarter in a Line Chart format and Summary (Total) Column toggled on.

Purpose: This report shows the company's AR totals on a weekly basis over the the current quarter.

Setup: This transaction report is filtered by AP - Total Tag and grouped by Region with a Weekly Cadence over a previous Quarter in a Stacked Bar Chart format and Summary (Total) Column toggled on.

Purpose: This report shows the company's AP totals on a weekly basis over the previous quarter.

Setup: This transaction report is filtered and grouped by 5 Tags with a Monthly Cadence over 12 Months in a Stacked Bar Chart format.

Purpose: This report gives users an understanding of the volume of their AR coming from various payment methods (ACH, EFT, Remote Deposit, and Wire).

Setup: This transactions report is filtered by 5 Tags, with a Monthly Cadence over the last 6 Months in a Stacked Bar Chart format.

Purpose: This report drills into customer AR/AP by identifying the top customers or vendors for any given business. Users can speak with their AR/AP teams to identify the top customers and vendors.

Setup: These transaction reports have no filters, are toggled to display the net & gross totals respectively, and have a Monthly Cadence for 12 Periods in a Bar Chart format.

Purpose: The goal of this report is to visually represent the net & gross totals of your inflows/outflows.

Setup: This transaction report is grouped by the Payroll Tag with a Weekly Cadence in a Stacked Bar Chart format.

Purpose: The goal of this report is to highlight Payroll data over time.

Setup: This transaction report is filtered for the Payroll Tag and grouped by Entity Region in a Stacked Bar Chart format.

Purpose: The goal of this report is to drill into Payroll data by Region.

Setup: This transactions report is grouped by various Bank Fees Tags, with a Monthly Cadence over FY 2024 in a Stacked Bar Chart format.

Purpose: The goal of this report is to track monthly bank fees & charges related to each of your institutions.

Setup: This transactions report is grouped by Account, with a Daily Cadence over the last 90 days in a Scatter Plot format.

Purpose: The goal of this report is to track large dollar transactions (anomalies, identified as >$1,000,000) over the last 90 days.

Setup: This balances report uses the Composite Balance Converted balance type, is filtered for 3 Entities, and is grouped by Institution and Account with a Daily Cadence over the last 5 days (excluding weekends) in a Stacked Bar Chart format. This report has the Summary (Total Change) Column toggled on to display the day over day variance.

Purpose: This report is designed to track prior day balances across all institutions and accounts on a rolling basis in one consolidated place.

Setup: This balances report uses the Composite Balance Converted balance type, is filtered for 3 Entities, and is grouped by Entity (Legacy) and Account with a Weekly Cadence over the last week in a Stacked Bar Chart format. This report has the Summary (Total Change) Column toggled on.

Purpose: This report is designed to track the week over week balance variance across entities and accounts.

Setup: This balances report uses the Composite Balance Converted balance type and is grouped by Account with a Weekly Cadence over the last week in a Stacked Bar Chart format. This report has the Summary (Average) Column toggled on.

Purpose: This report is designed to track the average weekly balance across the entire year.

Setup: This balances report uses the Composite Balance Converted balance type and is filtered by Entity (Legacy) and is grouped by Region, Entity, and Institution with a Daily Cadence for 15 Days in a Line Chart format.

Purpose: This report can be leveraged to track account balances across a company's entity/region/division groupings.

Setup: This balances report uses the Composite Balance Converted balance type and is grouped by Currency with a Daily Cadence for 5 Days in a Pie Chart format.

Purpose: The goal of this report is to visually represent your currency portfolio across all accounts.

Setup: This balances report uses the Composite Balance Converted balance type, filtered by various banks, and is grouped by Institution with a Daily Cadence for 30 Days in a Line Chart format.

Purpose: The goal of this report is to visually represent your cash balance trends over time.

Setup: This cash position report includes the main concentration account, leveraging the ledger balance types for the opening and closing balance. Current transactions are populated through JPM's intraday feed, and assumed transactions can be included at the user's discretion. A target balance (i.e. peg) is also set.

Purpose: The goal of this cash position report is estimate the end of day net excess/deficit cash on a daily basis.

Setup: This reconciliation report uses the Account field in the Items Reconciled menu and is filtered by USD Currency and JP Morgan Institution with a Prior Day View. The Tag Breakdown feature is also used to filter by key cash flows (Receipts, Disbursements, and Book Transfers).

Purpose: The purpose of this report is multifaceted. Users can leverage this report to verify that net transaction activity is equal to the change in balance for any given account on any given (prior) business day. Additionally, users can leverage the tag breakdown to understand the breakdown of daily transaction activity (i.e. Receipts, Disbursements, Book Transfers, etc.). The "Other" line item is a catch all for any transactions that either do not yet have a tag OR do have a tag, but has not been included in the Tag Breakdown.