🏗️ Setting Up a New Bank Billing Set
A Bank Billing Set is the master configuration record that ties a bank's fee schedule to your system. It consists of two layers:
The Header — the billing set itself (one per bank relationship)
The Detail Lines — individual fee/service codes with rates
---
📌 Part 1: Create the Billing Set Header
Navigate to Cash Management → Bank Fee Setup → Bank Billing Sets and click New.
Fill in the following fields:
Field | Description | Options / Notes |
Bank Billing Set Code | Unique identifier (e.g., | Short, meaningful code |
Description | Full name of the billing set | e.g., "JPMorgan Chase 2025 Fee Schedule" |
Currency | Base currency for fees | e.g., |
Region | Geographic region for this bank relationship | e.g., |
Import Method | How fee statements are received |
|
Communication | Communication method with bank | Per your bank setup |
Accrual Type | Day count convention for accruals |
|
Invoice Method | How invoices are calculated |
|
Auto Accept Price/Rate Change | Auto-approve rate changes on import |
|
Flip Sign | Reverse debit/credit signs on import |
|
Contractual ECR Rate | Your negotiated Earnings Credit Rate | e.g., |
Hard Service Charges Code | Links to hard charge billing code | Per your billing code setup |
Excess/Deficit Earnings Code | Links to excess/deficit earnings code | Per your billing code setup |
Expiration Date | When this fee schedule expires | Leave blank if open-ended |
---
📋 Part 2: Add Billing Set Detail Lines
Once the header is saved, add the individual service fee lines. Each line represents one type of bank service charge.
For each service, enter:
Field | Description | Options |
Billing Code | Your internal billing code (from the Billing Code library) | Must exist in the system |
Bank Proprietary Code | The bank's own code for this service | From your bank's fee statement |
Equivalence Code | Standardized AFP code | For cross-bank benchmarking |
As Of Date | Effective date for this rate | Supports rate history over time |
Fee Type | How the fee is calculated |
|
Unit Price / Rate | The actual price or rate | e.g., |
Balance/Outright | Fee basis |
|
Min Fee | Floor amount | Optional |
Max Fee | Ceiling amount | Optional |
Billing Type | Classification for analysis |
|
Pay / Receive | Direction of the fee |
|
GL Company (Prefix) | GL company code | For accounting |
GL Ref 1–5 | General Ledger reference codes | Map to your chart of accounts |
BFA Group Code | Bank Fee Analysis grouping | For reporting/analysis |
Status | Active/Inactive |
|
Notes | Free-text notes | Optional |
---
🔄 Part 3: Link the Billing Set to a Bank Account
After creating the billing set, link it to the applicable bank account(s):
Go to Bank Account Setup
Find the relevant account
Set the
Bank Billing Set Codefield to your newly created setThis tells the system which fee schedule to use when importing statements for that account
---
💡 Best Practice Tips
> One Billing Set Per Bank — Create a separate billing set for each banking partner (JPMorgan, Citi, BofA, etc.) since each bank uses different proprietary service codes.
> Date-Version Your Rates — Use the As Of Date on detail lines to maintain rate history. When rates change, add a new line with the new effective date rather than overwriting the old one.
> Map Every Bank Code — The Bank Proprietary Code is critical for automated matching during statement import. Make sure every code on your bank's fee statement has a corresponding detail line.
> Set Your ECR — Enter your negotiated Contractual ECR Rate accurately — this drives the earnings credit offset calculation that determines your net fee position.
> Use Auto Accept Wisely — Set Auto Accept Price/Rate Change = No if you want to manually review and approve any rate changes detected during statement import.