9.2 Bank Account Analysis Statements, Earnings Credit Rates (ECR) & Pricing

9.2 Bank Account Analysis Statements, Earnings Credit Rates (ECR) & Pricing

In commercial banking, corporations do not receive conventional consumer-style bank statements. Instead, banks provide a comprehensive monthly Account Analysis Statement. This document serves as both a detailed operational summary of all cash management activity and a formal invoice detailing service volumes, unit prices, account balances, and the Earnings Credit earned on deposited funds.

---

1. Bank Account Analysis Statements: Standards & Formats

To audit and manage banking expenses across dozens or hundreds of accounts, treasury teams utilize standardized electronic formats and classification codes.

+---------------------------------------------------------------------------------------------------------+
|                               ACCOUNT ANALYSIS DATA STANDARDIZATION                                     |
|                                                                                                         |
|  [ AFP SERVICE CODES ]                                                                                  |
|  • Standardized 6-digit hierarchical taxonomy created by the Association for Financial Professionals    |
|  • Maps proprietary bank charge descriptions into uniform cross-bank categories                        |
|  • Structure: Group (2 digits) + Service (2 digits) + Modifier (2 digits)                               |
|                                                                                                         |
|  [ ANSI ASC X12 822 (EDI 822) ]                                                                         |
|  • North American electronic data interchange (EDI) standard for account analysis statements            |
|  • Enables automated electronic ingestion, auditing, and variance reporting inside corporate TMS/ERPs   |
|                                                                                                         |
|  [ ISO 20022 CAMT.086 (BANK SERVICES BILLING / BSB) ]                                                  |
|  • Global XML standard for electronic bank fee billing endorsed by AFP and TWIST                       |
|  • Multi-currency, multi-entity hierarchical structure for global account portfolio analysis            |
+---------------------------------------------------------------------------------------------------------+

The AFP Service Code Taxonomy

Banks historically utilized proprietary, cryptic descriptions for fees (e.g., "Automated Dep Ref Fee" vs. "Lockbox Per Item"). The AFP Service Codes establish a uniform 6-digit structure across major categories:

• 01.xx.xx: General Account Services (Account Maintenance, Statements)
• 10.xx.xx: Depository Services (Vault Deposits, Check Processing, Remote Deposit Capture)
• 15.xx.xx: Lockbox Services (Wholesale & Retail Processing, Image Capture)
• 20.xx.xx: Disbursement Services (Controlled Disbursement, Check Clearing, Stop Payments)
• 25.xx.xx: Automated Clearing House (ACH Origination, Same-Day ACH, Returns)
• 30.xx.xx: Wire Transfer Services (Fedwire Origination, Incoming Wires, International Transfers)
• 40.xx.xx: Information & Technology Services (Portal Access, API Calls, BAI2/camt File Transmission)

---

2. Anatomy of an Account Analysis Statement

An account analysis statement calculates net billing by balancing collected funds against gross service fees across three primary sections:

+---------------------------------------------------------------------------------------------------------+
|                                 ACCOUNT ANALYSIS STATEMENT FLOW DIAGRAM                                 |
|                                                                                                         |
|    Average Daily Ledger Balance                                                                         |
|    [-] Average Daily Float / Uncollected Funds                                                          |
|    ──────────────────────────────────────────────────────                                               |
|    [=] Average Daily Collected Balance (CB)                                                             |
|    [-] Reserve Requirement / Regulatory Assessment Drag (RR x CB)                                       |
|    ──────────────────────────────────────────────────────                                               |
|    [=] Net Usable / Available Balance for Earnings Credit                                               |
|                               │                                                                         |
|                               v [Multiplied by ECR x Days / Basis]                                      |
|    [=] Total Earnings Credit Allowance (EC)                                                             |
|                               │                                                                         |
|    Total Gross Service Charges ($) ◄── (Sum of [Item Volume x Unit Price] across all AFP codes)         |
|    [-] Total Earnings Credit Allowance ($)                                                              |
|    ──────────────────────────────────────────────────────                                               |
|    [=] Net Billed Position (Net Fee Due or Excess Earnings Credit)                                      |
+---------------------------------------------------------------------------------------------------------+

Key Balance Definitions

3. Earnings Credit Rate (ECR) Mechanics & Core Formulas

An Earnings Credit Rate (ECR) is an imputed interest rate established by commercial banks applied against corporate deposit balances to generate an Earnings Credit Allowance ($EC$). This credit directly offsets qualifying monthly service charges.

1. The Earnings Credit Calculation Formula

$\mathbf{EC = CB \times (1 - RR) \times ECR \times \frac{Days}{Basis}}$

Where:

• $\mathbf{EC}$ = Total dollar Earnings Credit generated during the billing cycle.
• $\mathbf{CB}$ = Average Daily Collected Balance maintained during the billing period.
• $\mathbf{RR}$ = Reserve Requirement / Regulatory assessment deduction rate (expressed as a decimal, e.g., 10% = 0.10).
• $\mathbf{ECR}$ = Annual Earnings Credit Rate (expressed as a decimal, e.g., 3.50% = 0.0350).
• $\mathbf{Days}$ = Number of days in the billing period (e.g., 28, 30, or 31).
• $\mathbf{Basis}$ = Annual day count convention ($365$ days standard in the US, or $360$ days for certain bank conventions).

2. The Required Compensating Balance Formula

To determine the exact collected balance ($CB_{required}$) needed to completely offset a known dollar amount of monthly bank service charges:

$\mathbf{CB_{required} = \frac{\text{Monthly Gross Service Charges}}{(1 - RR) \times ECR \times \left( \frac{Days}{Basis} \right)}}$

---

4. Step-by-Step Worked Numerical Scenario

Corporate Scenario Parameters

Apex Global Logistics receives its monthly analysis statement for a 30-day month. Treasury management reviews the following baseline data:

• Gross Monthly Service Charges: $15,000.00
• Quoted Earnings Credit Rate ($ECR$): 3.50% per annum (0.0350)
• Bank Regulatory Assessment / Reserve Drag ($RR$): 10.0% (0.10)
• Day Count Basis: 30 / 365

Step-by-Step Calculation of Required Collected Balance

Step 1: Compute the Net Usable Balance Multiplier
        Net Multiplier = 1 - RR = 1 - 0.10 = 0.90 (90% usable funds)

Step 2: Compute the Net Annual ECR Yield
        Net Annual ECR = (1 - RR) * ECR
                       = 0.90 * 0.0350 = 0.0315 (3.15% per annum)

Step 3: Compute the Monthly Earnings Credit Factor
        Monthly Factor = Net Annual ECR * (Days / Basis)
                       = 0.0315 * (30 / 365)
                       = 0.0315 * 0.08219178082
                       = 0.002589041096

Step 4: Calculate the Required Compensating Collected Balance
        CB_required    = Monthly Service Charges / Monthly Factor
                       = $15,000 / 0.002589041096
                       = $5,793,650.79

Verification of Earnings Credit

To verify that an average collected balance of $5,793,650.79 generates exactly $15,000.00 in earnings credit:

$EC = 5793650.79 \times (1 - 0.10) \times 0.0350 \times \left( \frac{30}{365} \right)$ $EC = 5793650.79 \times 0.90 \times 0.0350 \times 0.08219178 = 15000.00$

Comparative Sensitivity Matrix

The required compensating balance fluctuates directly with changes in the ECR rate and the number of days in the statement cycle:

5. Fee Payment vs. Balance Compensation Decision Framework

Corporate treasurers must continually decide whether to leave compensating balances on deposit to earn ECR or to minimize bank balances and pay service charges directly in cash (direct fee payment). This decision depends on tax treatment, market yields, and the corporation's overall liquidity position.

+---------------------------------------------------------------------------------------------------------+
|                                FEE PAYMENT VS. BALANCE COMPENSATION                                     |
|                                                                                                         |
|  BALANCES / ECR COMPENSATION                       DIRECT FEE PAYMENT                                   |
|  • Balances generate non-taxable Earnings Credits  • Cash paid directly via DDA debit or invoice        |
|  • Offsets fees dollar-for-dollar (100% tax shield) • Fee expense is tax-deductible for corporate tax   |
|  • "Use-it-or-lose-it" (excess ECR expires)         • Idle cash freed to invest in market instruments    |
|  • Optimal when ECR >= After-Tax Market Yield      • Optimal when After-Tax Market Yield > Net ECR      |
+---------------------------------------------------------------------------------------------------------+

1. The Tax Shield Effect of ECR

The most critical financial distinction between ECR and cash investment income is taxability:

• Earnings Credit Allowance: Under US tax law, Earnings Credits are treated as a price reduction or fee discount. They are not taxable income. An earnings credit reduces bank service expenses dollar-for-dollar.
• Market Investment Income: Interest earned on commercial paper, Treasury bills, or interest-bearing deposit accounts is taxable ordinary corporate income subject to the marginal corporate tax rate ($t_{corp}$).

2. The Net Effective After-Tax Breakeven Formula

To compare an investment yield ($r_{invest}$) against a bank's quoted ECR, the treasurer calculates the After-Tax Investment Yield:

$\mathbf{r_{after\text{-}tax} = r_{invest} \times (1 - t_{corp})}$

$\mathbf{\text{Net Usable ECR} = ECR \times (1 - RR)}$

Decision Rule:

• If $\mathbf{ECR \times (1 - RR) > r_{invest} \times (1 - t_{corp})}$: Compensate via Balances. Leaving funds on deposit delivers a higher net economic return than investing in taxable short-term instruments.
• If $\mathbf{r_{invest} \times (1 - t_{corp}) > ECR \times (1 - RR)}$: Pay Fees in Direct Cash. Sweep cash into money market securities or commercial paper, and pay monthly bank invoices directly.

Numerical Example of Decision Rule

Suppose a corporation has a 25% marginal corporate tax rate ($t_{corp} = 0.25$).

• Bank Quoted ECR: 4.00% with 10% reserve drag $\rightarrow \text{Net ECR} = 4.00% \times (1 - 0.10) = 3.60%$.
• Alternative Short-Term Investment (T-Bills): Yielding 4.60% gross.
• After-Tax Investment Yield: $4.60% \times (1 - 0.25) = 3.45%$.
• Conclusion: Because the Net ECR (3.60%) exceeds the after-tax investment yield (3.45%), the company generates superior after-tax financial value by maintaining compensating balances rather than investing in T-bills.

3. Operational Constraints & "Use-It-or-Lose-It"

• No Cash Rebates: Under US banking regulations, banks cannot pay out unused Earnings Credits in cash. If a company maintains an average collected balance of $10M that generates $25,000 in ECR against only $15,000 in fees, the remaining $10,000 in excess credit is typically lost ("use it or lose it") or, at best, carried forward for a limited rolling window.
• Target Balance Management: Treasurers use automated balance target sweeps in their Treasury Management System to maintain just enough collected funds to cover expected monthly fees without generating stranded excess credits.