Overview: Bank Fees Cockpit
The Bank Fees Cockpit aggregates all fee statements into one dashboard for visibility and action. Because banks typically deliver structured fee files monthly—most customers have complete files by the end of the second week—the cockpit highlights current-month Gross Fees, Earnings Allowance, Net Fees, and Statement Count, with click-through to the underlying statements. Layout and charts are configurable, and the Workflow panel is optional.
Statement Ingestion
Users can upload bank fee statements manually or enable automated ingestion via direct bank connections. Supported formats include EDI 822, TWIST BSB, and select ISO 20022 (CAMT) files. You can load contractual price tables in two ways: (1) upload your negotiated fee schedule, or (2) establish a baseline from the first processed file and refine from there. Trovata then compares bank-reported charges against these baselines to detect overcharges automatically.
Fee Normalization & Categorization
Once ingested, Trovata TMS automatically maps each fee line item to AFP billing codes, creating a standardized view across banks. When bank AFP mappings differ for the same service, Equivalence Codes let teams force apples-to-apples comparisons across banks without changing the original AFP codes.
Alerting & Overcharge Detection
The Alerts section highlights detected overcharges or discrepancies between contracted and actual rates. Alerts surfaced in the cockpit include:
Overcharges: Variances vs. contractual/baseline rates (line-level, by AFP code).
New Services: Items billed that are not on your fee schedule.
Excess Earnings Allowance: Indicates unused credit—actionable prompt to move services to this bank or redeploy balances.
Closed Accounts: Statements arriving for accounts marked closed.
New Accounts: Statements for accounts not yet configured—often a simple lag, but can signal potential fraud.
Clicking any alert drills to the exact lines, expected vs. actual pricing, and total variance.
The “Srv. Chrg. Diff.” column identifies the variance between what was charged and what was expected.
Dispute & Workflow Processing
Workflow states for each statement or line item:
Entered → file arrived and parsed.
Under Review → flagged for internal follow-up.
Under Dispute → formal variance tracked with the bank, including notes.
When a bank agrees to a remedy, enter an Expected Correction (e.g., $2,000). On next month’s files, credits are auto-recognized and shown in the Credits table; once confirmed, flip to Paid.
Note: Export a dispute extract to email your bank team. Email generation is not yet native in this workflow.
Benchmarking & Scenario Analysis
Teams can compare fees by bank, region, or service type — and model “what-if” scenarios for switching banks or renegotiating services.
Cross-Bank What-If Savings
What-If Savings Analysis (via AtomXLS)
Using your actual volumes and contract/pricelist projections, model the savings from moving specific services (e.g., ACH, wires, EDI) from Bank A to Bank B. The workbook shows:
Current-bank actual cost vs. target-bank projected cost
Optional benchmark/target price overlay
Savings by product family and over custom time windows
Earnings Credit (ECR) Analysis
Focus: Quantifying soft vs. hard charges and identifying opportunity costs.
ECR analysis helps treasury teams measure how much value they truly earn on deposit balances.
Trovata reconciles bank-reported ECR against a system-calculated ECR using investable balances and reported rates, highlighting mismatches. We then calculate Net ECR by stripping out FDIC/assessment charges and show the spread to a benchmark (commonly 3-month T-Bill).
If Earnings Allowance > Fees, you’re leaving value unused. Options:
Shift services to this bank to consume allowance, or
Reallocate balances (e.g., to T-Bills/money market) and pay hard fees, if the net yield is higher.
Use cases:
Prove under-credited balances (variance between reported and calculated ECR).
Quantify opportunity cost: “Keeping cash here yields Net ECR of X%; 3M T-Bills would yield Y%—a Y–X% spread.”
Decide whether to reallocate balances or move services to consume excess allowance.
Excel Add-In
Focus: Self-service analytics and reporting.
The Trovata Excel Add-In allows users to pull live, numeric data from Trovata TMS — including fees, balances, debt, and ECR metrics — directly into Excel.
It’s fully formula-driven and ideal for scenario modeling, reporting, or ad-hoc analysis.
Bank Scorecards
Trovata ties all module data — accounts, fees, balances, and credits — into Bank Scorecards for unified performance tracking and relationship management.
Teams use these dashboards to benchmark wallet share, track pricing competitiveness, and prepare for quarterly reviews.