Blog · Finance metrics and formulas · Banking
Bank financial statements connect interest income, funding costs, credit losses and cash movements. Work through a reconciled example and the spreadsheet checks that tie earnings to equity and closing cash.
Bank financial statements connect the income earned during a period with the assets, funding and cash held at its end. Read them together: rising earnings can coincide with cash growth funded mainly by deposits, while a credit-loss provision changes income before it produces a cash payment.
Bring the income statement, beginning and ending balance sheets, cash flow statement, allowance rollforward and supporting ledger schedules. Keep one institution, consolidation scope, reporting currency and period throughout. A holding-company income statement and a subsidiary bank balance sheet will not reconcile without the consolidation adjustments.
The FDIC's description of bank financial reports explains that institutions file quarterly Consolidated Reports of Condition and Income, commonly called Call Reports. These are useful regulatory comparison sources. Establish whether your operating workbook uses those definitions or financial-statement definitions before mapping its accounts.
For an interim review, confirm whether the income columns are quarter-only or year-to-date. Subtract the prior cumulative period when necessary; never compare a cumulative income column with a single quarter's cash flows. Keep units explicit because a statement labeled in thousands cannot be combined directly with a dollar-level export.
The bank balance sheet guide owns the detailed asset, funding and equity mix. Here the job is to prove the connections between statements.
Consider an illustrative US community bank for July 1 through September 30, 2026. All figures below are USD, with no rounding in the dollar calculations. On a worksheet named Income, put labels in column A and amounts in column B, starting on row 2.
| Worksheet row | Income line | Amount (USD) | Entry or formula |
|---|---|---|---|
| 2 | Interest income | 1,800,000 | Input |
| 3 | Interest expense | 600,000 | Input |
| 4 | Net interest income | 1,200,000 | =B2-B3 |
| 5 | Noninterest income | 400,000 | Input |
| 6 | Credit-loss provision | 150,000 | Input |
| 7 | Noninterest expense | 950,000 | Input |
| 8 | Pretax income | 500,000 | =B4+B5-B6-B7 |
| 9 | Income tax expense | 100,000 | Input |
| 10 | Net income | 400,000 | =B8-B9 |
Interest expense is part of the bank's funding economics. Keep it visible beside interest income instead of treating the resulting spread as ordinary product gross profit. Trace interest to the loan, securities and funding schedules, and separate fee income from interest.
The calculation is 1,800,000 minus 600,000 plus 400,000 minus 150,000 minus 950,000 minus 100,000, giving $400,000. The net interest margin guide explains the separate comparison with average earning assets; do not divide a quarter's income by a year-end balance and label the result comparable.
Use the following opening and closing balances from the same illustrative reporting package. The allowance is displayed as a positive deduction from gross loans.
| Balance | June 30 (USD) | September 30 (USD) |
|---|---|---|
| Cash and cash equivalents | 12,000,000 | 13,200,000 |
| Gross loans | 70,000,000 | 73,000,000 |
| Less: loan allowance | 1,000,000 | 1,100,000 |
| Securities | 15,000,000 | 13,000,000 |
| Other assets | 4,000,000 | 4,500,000 |
| Total assets | 100,000,000 | 102,600,000 |
| Deposits | 86,000,000 | 89,000,000 |
| Borrowings | 4,000,000 | 3,000,000 |
| Other liabilities | 1,000,000 | 1,400,000 |
| Equity | 9,000,000 | 9,200,000 |
| Total liabilities and equity | 100,000,000 | 102,600,000 |
Loans plus securities, treated as earning assets in this simplified example, rise from $85,000,000 to $86,000,000. That movement supplies context for interest income; a proper yield review would use the detailed average-balance schedule.
Assume dividends of $200,000 and no other equity movements. Beginning equity plus net income minus dividends is 9,000,000 + 400,000 - 200,000 = $9,200,000. Include other comprehensive income, capital transactions or other adjustments when they exist.
The allowance schedule reports charge-offs of $50,000 and no recoveries. Its check is 1,000,000 + 150,000 - 50,000 = $1,100,000. Charge-offs use the allowance; they are not another deduction from the net income already shown. This example contains only a loan allowance, with no other credit-loss allowances.
The SEC's financial statements guide distinguishes earnings from cash and explains operating, investing and financing cash flows. Use the classifications in the supplied statement and its notes rather than inferring every cash flow from net balance changes.
On a Cash worksheet, enter the following signed movements. Rows 2 through 6 reconcile net income to operating cash; the provision and depreciation are noncash adjustments.
| Row | Movement | Cash effect (USD) |
|---|---|---|
| 2 | Net income | 400,000 |
| 3 | Add back credit-loss provision | 150,000 |
| 4 | Add back depreciation | 100,000 |
| 5 | Increase in other operating assets | -600,000 |
| 6 | Increase in other operating liabilities | 400,000 |
| 7 | Operating cash flow | 450,000 |
| 8 | Net cash advanced on loans | -3,050,000 |
| 9 | Net securities proceeds | 2,000,000 |
| 10 | Investing cash flow | -1,050,000 |
| 11 | Net deposit inflows | 3,000,000 |
| 12 | Borrowing repayments | -1,000,000 |
| 13 | Dividends paid | -200,000 |
| 14 | Financing cash flow | 1,800,000 |
| 15 | Change in cash | 1,200,000 |
Enter these formulas in B7, B10, B14 and B15, respectively:
=SUM(B2:B6)
=SUM(B8:B9)
=SUM(B11:B13)
=B7+B10+B14
Closing cash is 12,000,000 + 450,000 - 1,050,000 + 1,800,000 = $13,200,000. Cash rose by $1,200,000 while net income was $400,000. Deposit funding explains why the two measures tell different stories.
Two supporting checks close the remaining movements. Gross loans reconcile as 70,000,000 + 3,050,000 - 50,000 = $73,000,000. Other assets reconcile as 4,000,000 + 600,000 - 100,000 = $4,500,000. The example assumes no loan purchases, securities valuation changes or other adjustments; real schedules must identify them separately.
Finance owns the statement mapping and closing checks. Treasury explains deposit and borrowing movements; credit finance explains provisions and allowance changes. Ask whether earnings changed because of earning-asset volume, pricing, funding expense or credit costs, then request the schedule that isolates each driver.
Use bank financial ratios after the statements tie. The FDIC Quarterly Banking Profile provides industry information on earnings, loans, deposits and asset quality, but a peer comparison still needs matching definitions and periods.
Bring a statement workbook and supporting balance and cash schedules: Covirage maps the columns, and its tools compute the movements and check the reconciliations. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; creating the account takes about a minute.
See Covirage for commercial banking for the supporting business context.
A customer's bank statement lists transactions in an account. A bank's financial statements describe the institution itself: its income, assets, liabilities, equity and cash flows. For a company finance review, identify which document you received before comparing balances or calculating measures.
Deposits are funding owed to customers. Receiving a deposit increases cash and a deposit liability; it does not itself earn interest or fee revenue. Review deposit movements in the funding and cash schedules separately from the income statement.
Call Reports provide regulatory condition and income information, but they are not a substitute for every statement and disclosure in a bank's financial reporting package. Use the cash flow statement and supporting schedules for the cash reconciliation, and document differences in reporting scope.