Docs · File formats
Bank Fee Review CSV format
Header names are matched automatically, in any order and any case. Extra columns are ignored.
| Column | Required | Also accepted as | Example |
|---|---|---|---|
| Statement month | Yes | statement month, analysis month, month, statement date, statement period, analysis period | 2026-08 |
| Bank | Yes | bank, bank name, financial institution, institution, provider | First Harbor Bank |
| Account | Yes | account number, account, account no, account #, acct, acct no | 4410-221 |
| AFP service code | afp code, afp service code, afp, afp #, afp cd | 250101 | |
| Bank service code | bank service code, service code, bank code, charge code, fee code, product code | 2241 | |
| Service description | service description, description, service, service name, fee description, service code description | ACH Originated Credit | |
| Volume | volume, vol, quantity, qty, units, item count | 4200 | |
| Unit price charged | unit price, unit price charged, price, unit charge, per item, price per unit | 0.12 | |
| Total charged | Yes | total charge, total charged, total, service charge, service charges, charge for service | 504.00 |
| Agreed unit price | agreed price, agreed unit price, contract price, negotiated price, fee schedule price, schedule price | 0.10 | |
| Earnings credit rate % | earnings credit rate, ecr, ecr %, earnings credit, earnings rate, earnings credit rate % | 1.50 | |
| Average collected balance | average collected balance, avg collected balance, average positive collected balance, collected balance, investable balance, average ledger balance | 2450000.00 | |
| Balance waiver threshold | waiver threshold, balance threshold, balance required, minimum balance, min balance, waive above | 1000000.00 | |
| Waived | waived, waive, waived flag, fee waived, waiver | N | |
| Negotiated price | negotiated, negotiated flag, exception pricing, special pricing | Y | |
| Paperless | paperless, paperless flag, e statement, estatement, electronic statements | Y | |
| Escalation cap % | escalation cap, price cap, increase cap, max increase, cap %, escalator cap | 5 | |
| ECR change notified | ecr notice, rate notice, notice given, rate change notice, notified | N |