Bank Fee Analysis and Service Codes

1. Why This Topic Matters
Banks are a treasury department's most important external partners, and the fees paid for cash management services are one of the largest controllable costs in treasury. The CTP exam places bank fee analysis inside the Internal and External Relationships domain because managing bank compensation is fundamentally about managing the bank relationship: knowing what you are paying, verifying that it matches what was negotiated, and deciding how to compensate the bank (fees, balances, or a mix). Companies that do not analyze bank fees routinely overpay through pricing errors, unused services, duplicate accounts, and outdated contracts. Studies cited by AFP suggest that a meaningful percentage of account analysis statements contain billing errors, so disciplined review has a direct and measurable payoff. On the exam, expect both conceptual questions (purpose of account analysis, benefits of standardized codes, fee vs. balance compensation) and calculation questions (earnings credit, required collected balances).

2. What It Is: Key Definitions
Account analysis statement – A monthly statement from a bank that itemizes every service used (e.g., account maintenance, wires, ACH items, lockbox items, information reporting), the volume of each service, the unit price, the total charge, the balances maintained, the earnings credit earned on those balances, and the net amount owed (or excess credit). It is essentially the invoice for treasury services.
Earnings Credit Rate (ECR) – The rate a bank applies to a company's average positive collected balances to generate an earnings credit (also called an earnings allowance) that offsets service charges. ECR is a soft-dollar credit: it can only be used to pay bank fees and is never paid out in cash. Because it is not interest income, it is not taxable to the company, and historically it allowed corporations to earn implicit value on demand deposits.
Collected balance vs. ledger balance – Ledger balance is the book balance including deposited items not yet collected. Collected balance excludes float (uncollected funds). Earnings credit is calculated on collected balances; negative collected balances (uncollected funds usage) are charged to the customer, often at a rate tied to prime.
Reserve requirement – Historically, banks deducted a Federal Reserve reserve requirement (commonly 10% in exam problems) from collected balances before applying the ECR, because reserved funds could not be lent out. The Fed set reserve requirements to zero in March 2020, but many exam questions still supply a reserve requirement; if one is given, use it.
Deposit assessment / FDIC-type fee – A balance-based charge some banks pass through to recover insurance assessment costs; it appears on the analysis as a fee tied to average ledger balances rather than to transaction volume.
AFP Service Codes – A standardized coding system maintained by the Association for Financial Professionals that assigns a unique code to each type of bank service. In the U.S. the codes are commonly six digits (the first two digits identify the product family, such as general account services, lockbox, depository, paper disbursement, ACH, wire transfer, or information services), with an optional two-character suffix banks may use for variations. The AFP Global Service Codes extend the concept internationally. Standardized codes let a company compare like with like across banks regardless of each bank's proprietary product names.
Electronic account analysis formats – In the U.S., the ANSI X12 822 transaction set delivers account analysis data electronically. Internationally, the TWIST Bank Services Billing (BSB) standard evolved into the ISO 20022 camt.086 message. Electronic delivery enables automated loading into fee analysis software and systematic exception review.

3. How It Works
Step 1 – Receive and load the statement. Statements are typically available within the first two weeks after month-end, in paper, PDF, or electronic (822 / camt.086) form. Larger companies load data into treasury management or specialized bank fee analysis systems that map each bank's line items to AFP Service Codes.
Step 2 – Verify prices. Each unit price is compared to the negotiated price in the bank's pro forma, contract, or RFP response. Common errors include prices reverting to standard (rack) rates after a promotional period, unapproved price increases, and services billed that were supposed to be waived.
Step 3 – Verify volumes. Volumes are compared with internal records (number of wires sent, checks issued, lockbox items processed). Volume discrepancies may indicate bank processing errors, fraud, or internal control gaps.
Step 4 – Identify unnecessary or unused services and accounts. Fee analysis frequently reveals dormant accounts still incurring maintenance charges, duplicate reporting services, or services nobody uses, which supports account rationalization.
Step 5 – Evaluate compensation. The company decides whether to pay fees in hard dollars, maintain compensating balances to earn credit, or use a hybrid. The key comparison is the ECR versus the after-tax return the company could earn by investing the balances elsewhere (or the cost of debt it could pay down). Because ECR is not taxable, the comparison is often ECR vs. after-tax investment yield.
Step 6 – Benchmark and negotiate. Standardized codes allow fees to be benchmarked across banks and against industry data, supporting negotiations, RFPs, and relationship reviews or bank scorecards.
Step 7 – Settle. Deficits (fees exceeding earnings credit) are charged to the account; some banks allow excess credit or deficits to be carried forward within a settlement period (e.g., quarterly or annually) while others settle monthly with no carryforward of excess credit.

4. The Core Calculations
Earnings credit:
Earnings Credit = Average Collected Balance × (1 − Reserve Requirement) × ECR × (Days in Month ÷ 365)
Required (compensating) collected balance to cover fees:
Required Balance = Monthly Service Charges ÷ [ (1 − Reserve Requirement) × ECR × (Days in Month ÷ 365) ]
Worked example: Monthly fees are $5,000, ECR is 1.5%, the month has 30 days, and the reserve requirement is 10%.
Denominator = 0.90 × 0.015 × (30 ÷ 365) = 0.90 × 0.015 × 0.08219 = 0.0011096
Required balance = $5,000 ÷ 0.0011096 ≈ $4,506,000.
If the question states there is no reserve requirement (or gives none), the denominator is 0.015 × 0.08219 = 0.0012329, and the required balance ≈ $4,055,000. Notice how much balance is tied up to offset a relatively small fee when the ECR is low, which is why companies tend to shift toward paying fees when rates are low and toward balances when ECRs are high.
Fee vs. balance decision example: If the bank offers a 1.5% ECR and the company can earn 3.0% (after-tax 2.3%) in a money market fund, the company is better off paying fees in hard dollars and investing the cash, since 2.3% exceeds 1.5%. If the ECR were 2.5%, holding balances would be preferable. Also consider that some banks price services lower for fee-paying customers or charge balance-based assessment fees that reduce the effective ECR.

5. Benefits of Standardized Service Codes
• Apples-to-apples comparison across banks with different product names.
• Faster, more accurate monthly review through automation and exception reporting.
• Easier detection of billing errors and unauthorized price changes.
• Better support for RFPs, benchmarking, and relationship negotiations.
• Global consistency when combined with camt.086 / BSB, supporting multinational treasury centralization.

6. Common Pitfalls Found in Fee Analysis
• Billing at standard rates instead of negotiated rates.
• New or renamed services appearing without notification.
• Volume errors (e.g., counted twice, or wrong account).
• Maintenance fees on dormant or redundant accounts.
• Earnings credit calculated on ledger rather than collected balances, or wrong ECR applied.
• Failure to apply excess earnings credit or incorrect settlement period treatment.

7. Exam Tips: Answering Questions on Bank Fee Analysis and Service Codes
Tip 1 – Know the purpose questions cold. If asked why a company reviews account analysis statements, the best answers are: to verify prices and volumes against the agreement, to detect errors, to identify unused services, and to manage bank compensation. If asked the primary purpose of AFP Service Codes, the answer is standardization that enables comparison of services and fees across banks.
Tip 2 – Remember ECR is soft dollars. Earnings credit offsets fees only; it cannot be paid in cash, cannot be swept to another use, and is not taxable interest income. Any answer choice treating earnings credit as cash income is wrong.
Tip 3 – Use the reserve requirement only if given. If the problem states a reserve requirement (often 10%), multiply balances by (1 − RR). If no reserve requirement is mentioned, do not invent one. Read the stem twice.
Tip 4 – Convert the annual ECR to the period. The ECR is an annual rate. Multiply by days in the month ÷ 365 (use 360 only if the question says so). A frequent trap is applying the full annual rate to one month, which overstates the credit twelvefold.
Tip 5 – Collected, not ledger. Earnings credit is based on average positive collected balances. If the question gives both ledger and collected balances, use collected. Negative collected balances generate a charge, not a credit.
Tip 6 – Rearrange the formula confidently. Questions may ask for the earnings credit (solve forward), the required balance (divide fees by the rate factor), or the ECR needed to cover fees (fees ÷ [balance × (1 − RR) × days/365]). Write the formula, plug in, and check that the magnitude is sensible: required balances are typically in the millions for fees in the thousands.
Tip 7 – Fee vs. balance logic. Pay fees and invest when the after-tax investment yield (or cost of debt) exceeds the ECR; hold balances when the ECR is higher. Watch for distractors that compare ECR to pre-tax yields without noting the tax point, and for mentions of balance-based assessment fees that lower the effective ECR.
Tip 8 – Match formats to geography. ANSI X12 822 = U.S. electronic account analysis; TWIST BSB / ISO 20022 camt.086 = international bank services billing. AFP Service Codes (U.S.) and AFP Global Service Codes (international) are the coding standards used within these files.
Tip 9 – Timing and frequency. Account analysis is monthly; statements usually arrive within the first half of the following month. Settlement of deficits may be monthly, quarterly, or annual depending on the bank agreement. Treat 'reviewing account analysis annually' as a wrong answer when the question asks for best practice.
Tip 10 – Connect to relationship management. Fee analysis outputs feed bank scorecards, relationship reviews, RFP decisions, and account rationalization. When a question asks what action follows the discovery of persistent billing errors, the best answer involves documenting the discrepancies, requesting correction and credits from the bank, and incorporating the findings into the relationship review, rather than immediately terminating the bank.
Tip 11 – Eliminate extreme or absolute answer choices. Options claiming that standardized codes guarantee identical pricing, that ECR always beats investing, or that balances are always preferable to fees are generally incorrect. The CTP exam rewards balanced, situation-dependent reasoning.

8. Quick Review Summary
• Account analysis statement = monthly itemized bill for bank services plus balance and earnings credit information.
• ECR × (1 − RR) × days/365 × collected balance = earnings credit (soft dollar, non-taxable, fee offset only).
• Required balance = fees ÷ [(1 − RR) × ECR × days/365].
• AFP Service Codes standardize service descriptions to enable cross-bank comparison and automated review; delivered via ANSI X12 822 (U.S.) or ISO 20022 camt.086 (global).
• Fee analysis detects pricing and volume errors, eliminates unused services, supports fee-vs-balance decisions, and strengthens bank negotiations and relationship management.