Bank statement analysis is the work of turning a borrower's statements into figures a lender can underwrite: monthly deposit totals, a qualifying average, recurring income sources, cash flow trends and a list of flags. It describes what happened in the account. It does not decide whether to lend.
What does bank statement analysis produce for a lender?
A bank statement analysis produces a short set of numbers and notes that replace a stack of PDFs: deposit totals for each month, a total average, a qualifying average, the income that repeats, and the events that need an explanation. Each item answers a question the underwriter would otherwise answer by scrolling.
Monthly totals and two averages
The base of the analysis is a table with one row per statement month. Each row shows total deposits, the deposits removed from the count, and the qualifying deposits that remain. Two averages come out of it. The total average divides all deposits by the number of months. The qualifying average divides only the eligible deposits. The gap between the two shows how much of the account activity was not income.
Recurring income
Recurring income is money that arrives from the same source on a regular schedule, such as a weekly payroll deposit or a monthly retainer from one client. The analysis groups these deposits, states how often they arrive and states the average amount. A lender cares because a source that appears in all six months supports a higher level of confidence than a source that appears once.
Trends and flags
Trends show whether deposits, balances and expenses are rising or falling across the period. Flags mark individual events: a large or out-of-pattern deposit, an NSF fee (a charge for a payment returned for insufficient funds) or an overdraft. A flag is not a verdict. It is a pointer to a statement line that someone has to read and, usually, ask about.
A one-page sample output
The table below is an example of the page an underwriter might receive for a fictional borrower with six months of statements. Every value is made up for illustration.
| Month | Total deposits | Excluded | Qualifying deposits |
|---|---|---|---|
| January | $41,200 | $3,000 | $38,200 |
| February | $38,600 | $2,500 | $36,100 |
| March | $44,900 | $4,400 | $40,500 |
| April | $36,300 | $0 | $36,300 |
| May | $42,100 | $5,000 | $37,100 |
| June | $39,700 | $1,600 | $38,100 |
| Six-month total | $242,800 | $16,500 | $226,300 |
- Total average: $242,800 divided by 6 is $40,467 a month.
- Qualifying average: $226,300 divided by 6 is $37,717 a month.
- Recurring income (examples): a biweekly deposit from a catering client averaging $4,250, and a monthly $3,800 retainer from a dental office, both present in all six months.
- NSF count: 2 (one in February, one in April).
- Flagged deposit: a single $5,000 deposit in May labelled as an equipment sale, excluded from the qualifying figures until the borrower documents it.
The page is short on purpose. Its job is to show the lender the result and to point at the lines behind it.
Deposits, recurring income and flags in bank statement analysis
Deposits, recurring income and flags are the three outputs an underwriter reads first, and each one rests on a decision about what counts. A deposit is not income just because it landed in the account. The analysis has to sort deposits before it averages them.
Which deposits count
Most analysis starts by tagging each credit. Typical tags are payroll, client payment, transfer from the borrower's own account, loan proceeds, refund and one-time sale. Payroll and client payments usually count. Transfers between the borrower's own accounts usually do not, because the money was already counted where it came from. Which transfers come out of average monthly deposits is covered in its own post, and the rules there decide the excluded column in the table above.
What makes income recurring
Two things make a source recurring: it appears from the same payer, and it follows a pattern. A deposit that arrives on the 1st of every month from the same company fits. Five unrelated deposits of similar size do not. The analysis should show the pattern, not just assert it, with the dates and amounts beside the source name.
A lender then reads recurrence as a stability signal. Income from three recurring sources is easier to defend than the same total from one deposit. The analysis does not rank that stability for the lender. It lays out the facts and lets the reviewer weigh them.
What a flag should say
A good flag names the date, the amount, the statement line and the reason it was raised. "Large deposit" alone makes the underwriter hunt for it. "May 14, $5,000, described as an equipment sale, more than twice the typical deposit" lets them go straight to the line and decide whether to ask for a source document.
The metrics that sit on top of these outputs, such as deposit coverage and balance trends, are described in the cash flow metrics lenders take from bank statements.
Manual spreadsheets versus software for bank statement analysis
A lender can do bank statement analysis in a spreadsheet or in software, and the outputs are the same kind of figures. What differs is the effort per file, the chance of a typing error and how easily a second person can check the work. Neither approach is wrong. Volume decides.
How the manual route works
In a spreadsheet, an analyst types or pastes every transaction, tags each credit, sums the months and builds the averages. The process is flexible. The analyst can handle any layout and can note anything unusual. The cost is time: a six-month file with two accounts can mean hundreds of lines. The step-by-step manual analysis is written up separately for lenders who want to see the full procedure.
Where manual work breaks
Manual analysis fails in predictable ways. A digit is transposed. A formula range stops one row short. Two analysts tag the same deposit differently, so two files from the same office use different rules. When a reviewer questions a total months later, the analyst has to rebuild the reasoning from memory.
What software changes
Software reads the statements, sorts the transactions, groups recurring deposits and recalculates the averages when a deposit is included or excluded. TrueBankFlow works this way: it lines up months of statements per account, calculates total and qualifying deposit averages, and links every total back to the statement lines behind it. The reviewer still checks the work, but the checking starts from a finished table instead of a blank sheet.
A simple way to choose
Count your files. A desk that sees a handful of files a month can run a good spreadsheet with a fixed template and a second-person check. A desk that sees dozens will spend more time on data entry than on judgment. Cash flow analysis software for lenders, compared lays out the tool types side by side, and what to look for in a bank statement analyzer covers the buying checklist.
Where does bank statement analysis stop and the credit decision start?
Bank statement analysis stops at the facts about the account: what came in, how often, what left and what looks unusual. The credit decision starts when someone weighs those facts against the loan's guidelines, the borrower's other documents and the lender's risk appetite. Analysis informs the decision and never makes it.
What the analysis can say
The analysis can say that qualifying deposits averaged $37,717 over six months in the example, that two NSF events occurred and that one deposit needs a source. Those are observations, each checkable against a statement line.
What only an underwriter can decide
Whether $37,717 is enough, whether two NSF fees in six months are acceptable and whether the equipment sale is a real one-time event are judgments. They depend on the loan program, the requested amount, the borrower's explanation and the rest of the file. A tool cannot know that the borrower's catering client is closing next quarter. A person can learn it from a phone call.
Why the line matters for compliance
Keeping the line clear protects the lender. The analysis is a working document that supports a reviewer. TrueBankFlow states the same boundary on its own site: it organizes and summarizes what is in the statements so an underwriter can review it faster, and it is not a credit decision, a consumer report or lending advice. A lender that treats any analysis output as the decision has skipped the step that carries the responsibility.
A short test
Ask of any line in the output: could two careful people looking at the same statements disagree about it? If not, it is analysis. If so, it is judgment, and the report should record who made the call and why.
Bank statement analysis that misses the second account
A bank statement analysis misses the second account when the file includes only one set of statements while the borrower actually moves money through several. The numbers then look cleaner or weaker than reality, and the error is hard to see because every figure still adds up.
How it happens
A self-employed borrower often has a business checking account, a personal checking account and a savings account. Customer payments land in one, owner draws move to another and bills are paid from a third. If the file carries only the personal account, deposits are mostly the owner's draws. If it carries only the business account, expenses and draws look like losses.
Two ways the numbers go wrong
- Missing income. Payments deposited into an account that was not submitted never reach the average. The qualifying figure comes out too low.
- Double counting. When both accounts are submitted but nobody matches the transfers, the same dollar is counted as a deposit twice: once when it arrives in the business account and again when it moves to the personal one. The qualifying figure comes out too high.
What a careful analysis does
A careful analysis lines up every account for the same months and matches amounts that leave one account and arrive in another. In TrueBankFlow, matching amounts that move between uploaded accounts are labeled as transfers, and the user chooses whether they count toward qualifying deposits. The report records that choice, so the next reader sees how the number was built.
Questions to ask the borrower
When a statement shows payments to or from an account that is not in the file, ask for it. Common clues are a recurring transfer with a masked account number, a credit card payment from an account you have not seen and owner draws that do not match any deposit. A quick question at intake costs less than a condition at the end of the file.
If you want to see how a finished analysis reads on your own files, request a spot with TrueBankFlow. The software is onboarding lending teams in small groups.