How to Read a Bank Account Analysis Statement (and Find the Fees You Should Not Be Paying)

An account analysis statement is not a bank statement. It is the bill for your banking relationship, produced monthly, and most companies never open it. That is expensive, because it is the only document that shows what every treasury service actually cost, how much of that cost was offset by the balances you left on deposit, and where the bank quietly repriced something.

If you have a commercial checking account of any size, your bank produces one. Here is how to read it.

What is a bank account analysis statement?

An account analysis statement is a monthly billing document a commercial bank produces for a business account, showing the volume of each treasury service used, the unit price charged, the total service charge, and the earnings credit applied against it from your deposit balances. It is separate from the transaction statement you reconcile. Its purpose is to explain and justify the fees, either charged directly to the account or offset by balances.

Larger companies receive it electronically. In the United States the standard is the ANSI X12 EDI 822 transaction set, an e-billing file used only in this market, and several hundred mid sized and large corporations receive their analysis statements that way. Everyone else gets a PDF.

The three sections that matter

Almost every analysis statement, whatever the bank calls its sections, is built the same way.

The balance section. This shows average ledger balance, average float, and average collected balance. Ledger balance is what the account showed on the books. Float is deposited items not yet collected. Collected balance is ledger minus float, and it is the number the bank actually pays you for. Historically banks then deducted a reserve requirement to reach an investable balance, but the Federal Reserve set reserve requirement ratios to zero in March 2020, so many banks no longer take that deduction. If yours still does, that is a line worth asking about.

The service charge section. A list of every service used, with volume, unit price, and total. This is the longest part of the statement and the part nobody reads. A mid sized company will typically see between forty and two hundred line items covering account maintenance, ACH origination and receipt, wire transfers in and out, lockbox items, deposited items, returned items, positive pay, information reporting, and controlled disbursement.

The settlement section. This reconciles the total service charge against the earnings credit and shows what you actually pay. If the earnings credit exceeds the charges you may carry the excess forward, depending on the bank and the agreement, and if it falls short the difference is debited from the account.

How does the earnings credit rate work?

The earnings credit rate, or ECR, is a soft dollar rate the bank applies to your average collected balance to produce an earnings allowance that offsets service charges. It is not interest and you cannot withdraw it. If your collected balance is one million dollars and the ECR is 1.50 percent, the monthly earnings allowance is roughly 1,250 dollars, which offsets up to that much in fees. Anything left over is usually forfeited or carried forward for a limited period.

Two things about the ECR are worth knowing. It is negotiable, and it is one of the least negotiated numbers in corporate finance. And it usually lags the market in both directions, rising slowly when rates rise and falling quickly when they fall. If your ECR has not been reviewed since your last rate cycle, it is almost certainly stale.

What are AFP service codes?

AFP service codes are six digit codes maintained by the Association for Financial Professionals that identify individual cash management services on a bank fee statement. Every major US bank maps its own internal product names to these codes, which is what makes it possible to compare the price of the same service across two different banks. Without them, one bank's "ACH debit received" and another's "ACH consumer debit receipt item" are unmatched strings.

They exist because of the EDI 822 file. When electronic analysis statements were created, corporations needed a standard billing code so the data could be reported automatically, and the AFP code became that dictionary. If you are running an RFP or benchmarking fees, the AFP code is the join key. Ask your bank to include it on the statement if it does not already appear.

Where overbilling actually hides

Bank fee errors are rarely dramatic. They are small, recurring, and almost always in one of these places.

• Services you no longer use. A lockbox, a positive pay module, or an information reporting subscription for an account closed two years ago, still billing monthly.
• Volume tiers not applied. You negotiated a lower per item price above a threshold, you crossed the threshold, and the billing still uses the standard rate.
• Unit prices that drifted. A per item price that was 0.12 dollars at contract and is 0.18 dollars now, with no notice you can find.
• Duplicate maintenance charges. The same account maintenance fee billed under two slightly different service descriptions.
• Volumes that do not match reality. The statement says 4,200 ACH items originated, your own system says 3,600. Somebody is counting something twice.

None of these are visible in a single month. They are visible when you line up twelve months side by side and look at unit price and volume per service over time. That is the whole reason this work needs a spreadsheet rather than a stack of PDFs.

How do I analyze bank fees in Excel?

Get twelve months of analysis statements into one sheet with a consistent set of columns: period, account, service description, AFP code if you have it, volume, unit price, and total charge. Then run four checks. Pivot total charge by service and by month to find anything that appeared, disappeared, or stepped up. Divide total charge by volume per service per month and look for a unit price that moved. Compare stated volumes against your own transaction counts for the two or three highest volume services. And total the earnings credit for the year against the total service charge to see whether you are systematically leaving balances that earn nothing.

The obstacle is that the statements arrive as PDFs. If you receive EDI 822 files you already have structured data and can skip ahead. Otherwise the twelve documents have to become rows first, which is what a PDF to CSV converter is for. The same approach applies to the underlying account activity: once the transactions are in columns you can tie fee charges on the analysis statement back to the actual debits on the account. Other billing documents that arrive as PDFs in the same review, vendor invoices and merchant processing statements among them, can be handled with document data extraction so the whole spend picture sits in one place.

How often should this be reviewed?

Read the statement monthly, at least the settlement summary and any new line item. Do the full twelve month analysis annually, and always before a banking RFP or a relationship review. Converting the statements into a bank fee analysis spreadsheet is what makes the twelve month view practical, and the column layout and tests are worth setting up once. Companies that do this consistently tend to find recoverable amounts in the low tens of thousands on a mid sized relationship, mostly from services billed for accounts that no longer exist and tiers that were never applied. Banks will generally correct billing errors when you present the evidence, though most limit how far back they will go, so finding an error in month two is worth considerably more than finding it in month thirty.

Questions worth asking your relationship manager

Bring these to the annual review, with the twelve month sheet in hand. What is our current ECR and when was it last changed? Which services on this statement are contractually priced and which are at standard rates? Do you still deduct a reserve requirement from collected balances, and if so why? Can you provide the AFP service code for every billed line? And can we receive the analysis statement as an EDI 822 file rather than a PDF? The last one alone removes most of the manual work from every future review.

If you also need to prove where the money went rather than what it cost, the transaction level view matters. Converting the underlying statements and then categorizing the transactions gives you fees, transfers, and operating spend in the same sheet, which is how most treasury teams build the annual picture without re keying anything.