💲 Updating Bank Fee Pricing in Trovata TMS
Pricing for bank fees lives in the Bank Billing Set Detail records. There are three ways pricing can be updated — manually, automatically on import, or via rate schedules.
---
🔧 Method 1: Manual Price Update (Most Common)
Navigate to Cash Management → Bank Fee Setup → Bank Billing Sets, open your billing set, and go to the Detail Lines tab.
The key principle is: never overwrite old rates — add a new line with a new As Of Date. This preserves your rate history.
Steps:
Open the relevant Bank Billing Set (e.g.,
JPMC-2025)Find the service line you need to update (by Billing Code or Bank Proprietary Code)
Add a new detail line with the updated rate — set the fields:
Field | What to Do |
As Of Date | Set to the effective date of the new rate |
Fee Type | Keep the same ( |
Unit Price / Rate | Enter the new price or rate |
Min Fee / Max Fee | Update floor/ceiling if negotiated limits changed |
Notes | Document why the rate changed (e.g., "Annual repricing per contract dated 01/01/2025") |
Status | Set to |
Inactivate the old line by setting its
StatustoInactive(do not delete it — you need the history)Save the record
> ⚠️ Important: The As Of Date is the key that drives which rate applies to a given billing period. Always set it accurately to the first day the new rate takes effect.
---
⚙️ Method 2: Auto-Accept on Statement Import
If your billing set has Auto Accept Price/Rate Change = Yes, Trovata TMS will automatically update pricing when it detects a rate change in an imported fee statement.
How it works:
When a bank fee statement (822, CSV, or XML) is imported, the system compares the imported unit price against the current rate in the billing set detail
If a difference is detected and
Auto Accept = Yes, the new rate is automatically applied with the statement date as the effectiveAs Of DateIf
Auto Accept = No, the system will flag the discrepancy for your manual review and approval
Recommendation:
Setting | When to Use |
| Small, frequent rate adjustments; high-volume banks where manual review isn't practical |
| Best practice — gives you control to review and approve every rate change before it affects fee calculations |
---
📅 Method 3: Pre-Schedule Future Rate Changes
You can enter future-dated rates in advance by adding detail lines with a future As Of Date. The system will automatically apply the correct rate based on the billing period date.
Example — Scheduling a rate change:
Billing Code | As Of Date | Unit Price | Status | Notes |
WIRE-OUT | 01/01/2024 | $5.00 | Inactive | Original rate |
WIRE-OUT | 01/01/2025 | $5.50 | Active | Annual repricing |
WIRE-OUT | 07/01/2025 | $6.00 | Active | Mid-year increase per amendment |
The system will use $5.50 for statements dated Jan–Jun 2025 and $6.00 for statements from July 2025 onward.
---
🏦 Updating the ECR (Earnings Credit Rate)
The Contractual ECR Rate lives on the Billing Set Header (not the detail lines) and drives your earnings credit offset calculation:
Open the Billing Set Header
Update the Contractual ECR Rate field (e.g., change from
0.045to0.052for a 5.2% ECR)Optionally set an Expiration Date on the old billing set and create a new billing set for the new ECR period
---
🔍 Auditing Price Changes
To review historical rate changes for a billing set, query the detail lines filtered by Bank Billing Set Code — all historical rates are preserved with their As Of Date, Created On, and Updated On timestamps. This gives you a full audit trail of every rate that was ever in effect.