Bank statement analysis software reads a client's statements and summarizes what the money did: monthly inflows and outflows, transfers between the client's own accounts, recurring payments and deposits from unfamiliar sources. Reconciliation asks whether the books agree with the bank. Analysis asks what the bank activity says, and it is only as complete as the statements behind it.
Bank statement analysis versus reconciliation
Bank statement analysis and reconciliation use the same statements for different questions. Reconciliation matches each statement line to a ledger entry and proves the balances agree. Analysis groups and totals the lines to describe patterns: how much came in each month, who was paid regularly, which deposits stand out. One proves agreement; the other describes behavior.
The difference shows up in what each needs. Reconciliation needs a ledger to compare against. Analysis needs only the statements, which makes it useful for tax clients who keep no books at all. A sole proprietor who sends twelve PDFs in February can still get a month-by-month picture of receipts and spending.
The two also fail differently. A reconciliation that does not tie announces the problem: there is a difference to explain. An analysis built on incomplete statements produces tidy totals that are simply wrong, with nothing on the page to say so. That is why the completeness check in reconciliation software matters here too; the buying criteria are laid out in does the reconciliation software prove the statement run is complete?
What a firm typically wants from analysis:
- Monthly totals of money in and money out, with transfers separated.
- Recurring payments, grouped by payee, with frequency and typical amount.
- Unusual deposits, such as a payer that appears once or amounts far above the usual range.
- A list of months covered, so a missing statement is visible next to the totals.
None of these replace the preparer's judgment. They give the preparer a short list of questions for the client, built from evidence instead of memory.
What can bank statement analysis show about cash flow?
Bank statement analysis can show monthly cash inflows, outflows and net change, with transfers between the client's own accounts removed so they are not counted as income or spending. Across a year it shows seasonal swings, months with unusual outflows and the trend in the closing balance. It describes the bank account, not the business's profit.
The most useful output is a simple monthly table. Each row is a month, with total deposits, total withdrawals, transfers removed from each side and the net figures that remain. Adding a column for the closing balance shows whether the account is growing, shrinking or flat.
A sample monthly analysis for one client
The table below is an example for a fictional client, Marisol Vega, an independent consultant, using her fictional checking account ending XXXX-4821 for January to June 2026. All figures are examples.
| Month | Deposits | Transfers in (excluded) | Net inflows | Withdrawals | Transfers out (excluded) | Net outflows | Note |
|---|---|---|---|---|---|---|---|
| January | 9,800.00 | 1,500.00 | 8,300.00 | 7,450.00 | 0.00 | 7,450.00 | |
| February | 8,650.00 | 0.00 | 8,650.00 | 7,920.00 | 2,000.00 | 5,920.00 | |
| March | 11,200.00 | 3,000.00 | 8,200.00 | 8,105.00 | 0.00 | 8,105.00 | |
| April | Statement missing, not received | ||||||
| May | 9,150.00 | 0.00 | 9,150.00 | 6,880.00 | 1,000.00 | 5,880.00 | |
| June | 10,400.00 | 2,500.00 | 7,900.00 | 7,640.00 | 0.00 | 7,640.00 | |
| Five months shown | 42,200.00 | 34,995.00 | April not included |
Recurring payees found in the same example:
| Payee | Frequency | Typical amount | Months seen |
|---|---|---|---|
| Example Coworking LLC | Monthly | 450.00 | Jan, Feb, Mar, May, Jun |
| Northgate Software | Monthly | 89.00 | Jan, Feb, Mar, May, Jun |
| Example Auto Finance | Monthly | 512.00 | Jan, Feb, Mar, May, Jun |
| Example Mutual Insurance | Quarterly | 1,230.00 | Jan |
The April row is the most important line in the table. Without it, the six-month totals understate both sides by roughly a month, and any annual figure built from these totals is wrong.
Building these totals in a spreadsheet takes one function. SUMIFS in Microsoft Excel support "adds all of its arguments that meet multiple criteria," so one formula can total deposits for a given month that are not tagged as transfers.
Spotting recurring payments and unrecorded income in statements
Recurring payments and unrecorded income are the two patterns in statements most worth flagging for a tax client. Recurring payments show subscriptions, loans, insurance and rent the client may have forgotten to mention. Deposits from unfamiliar payers, or amounts that do not match any form the firm has received, are questions to ask the client before the return is prepared.
Recurring payments are found by grouping withdrawals by payee and looking for a steady interval and similar amounts. A monthly charge of $450.00 to a coworking space, or a quarterly insurance premium, appears as a cluster. Whether any of these matter for the return is the preparer's call; the analysis just makes sure nobody has to remember them.
Deposits are worth comparing against the documents already in the folder. In the example above, suppose March's deposits include a $2,400.00 credit from a payer called Harbor Payments, and the firm holds no form from that payer. The analysis cannot say what the deposit was. It can put the line in front of the preparer with a date and an amount, which turns a vague question into a specific one.
IRS Publication 583 lists deposit slips among the supporting documents for gross receipts and says account statements may prove that a payment was made. It also cautions that "Proof of payment of an amount, by itself, does not establish you are entitled to a tax deduction." Analysis software produces the same kind of evidence: what moved, when and to whom. What it means for the return is decided separately.
Patterns worth a flag, as questions rather than conclusions:
- A payer that appears for the first time this year.
- Deposits in round amounts with no clear source.
- A recurring payment that stops partway through the year, which may mean a loan was paid off or an account moved.
- Transfers to an account the firm has no statements for.
Turning flags into client questions
A flag is only useful if it reaches the client as a question they can answer. "Please explain your deposits" gets a shrug. "What was the $2,400.00 deposit from Harbor Payments on March 14?" gets an answer, often with a document attached. Each flag should carry the account, the date, the amount and the payee exactly as the statement prints it.
Group the questions by type before sending them. Deposits come first, because they tend to need a form or an explanation. Recurring payments come next, as a short list for the client to confirm or correct. Transfers to unknown accounts come last, paired with a request for those accounts' statements.
Keep the client's answers with the analysis. Next year's analysis will flag the same recurring payees and the same payers, and a note from this year saves asking twice.
Does a bank statement analysis app handle scanned statements?
A bank statement analysis app handles scanned statements only as well as it reads them. Clean digital PDFs from a bank's website carry text the software can extract directly. Scans and phone photos need character recognition first, and skewed pages, shadows or folded corners can turn an amount into the wrong number without any warning.
When evaluating an analysis tool, check how it treats a page it struggles with. The safe behavior is to flag low-confidence lines for review. The risky behavior is to produce totals that look complete when some lines were misread or skipped. One quick test: compare the tool's monthly totals with the deposit and withdrawal totals printed on each statement's summary box. They should agree. If they do not, the tool should already be telling you.
Clients send what they have. A client who visits a branch for paper statements and photographs them at home is not unusual, and an analysis tool that only accepts bank-generated PDFs pushes the firm back to typing. Schema CPA takes phone photos, email attachments and portal downloads through one upload link per client, reads bank statements among them, and exports the lines to Excel or CSV for whatever analysis the firm runs next; the document categories it reads are listed on the homepage.
Multi-account statements add another wrinkle. A single PDF that holds checking and savings needs to be split before analysis, or transfers between the two will look like income in one account with no matching outflow.
Bank statement analysis limits: when the numbers mislead
Bank statement analysis misleads when transfers are counted as income or spending, when months or accounts are missing, or when the period covered does not match the period being asked about. The totals look precise either way. The table only tells the truth when every account is present, every month is present and every transfer is paired.
Transfers
A transfer from savings to checking is a deposit on one statement and a withdrawal on another. Counted on both sides, it inflates inflows and outflows equally. Counted on one side only, because the savings statements are missing, it looks like new money. Pairing transfers requires statements for both accounts, which is one more reason to collect every account's statements.
Missing months and accounts
A missing month removes about a twelfth of the year from every total. A missing account removes everything that went through it. Neither shows up as an error. Finding the gaps before analysis is the subject of missing bank statements: find gaps in a run, and asking the client for the missing pieces is covered in how to request missing bank statements from a client.
Period mismatch
Statement periods rarely align with calendar months. A statement that runs from December 18 to January 17 puts December activity in a "January" statement. For a calendar-year client, that matters at both ends of the year. Allocate by transaction date, not statement date, when building annual totals.
Cash and other accounts
A bank statement shows what went through the bank. Cash receipts never deposited, payments from a personal card or a payment app balance never moved to the bank do not appear. An analysis is a picture of one or more accounts, not of the client's whole financial year.
For the methods of turning statements into rows before analysis, the guides in bank statements to Excel cover conversion, formats and checking the output.