FI GL Customer Account Balances Report

Purpose

Shows the relationship between GL account balances and underlying customer account balances for an FI, along with a consolidated total for the entire FI.

Why Use This Report

Reconcile GL balances to customer-level balances to ensure that ledger totals match the sum of individual customer accounts.

When to Run

During daily or monthly reconciliation activities, and when investigating discrepancies between customer balances and GL balances.

Who Uses This Report

Accounting, reconciliation, and operations teams that monitor customer and GL alignment.

Filters

You can filter the report using:

  • As of Date

  • FI Program

  • GL Account

  • Client

Tips

  • Run in tandem with other GL reports to quickly isolate the source of reconciliation breaks.

  • Export and aggregate by client or product to analyze balance composition.