Stop keying 24 months of deposits into a lender worksheet. Upload the borrower's personal or business statements and get month-by-month deposits, large items, NSFs and transfers laid out for the income calculation. From $99 a month.
Upload a document to extract
Drop files here or click to upload
Up to 50 files
Uploading...
Upload a bank statement and watch the analysis run live, free, no signup required.
Every wholesale non-QM lender hands brokers a bank statement income calculator, and almost all of them are the same spreadsheet. Arch Mortgage Funding's current version (a 2026 Excel workbook) has one row per month with four inputs: statement date, total deposits, number of NSF items and excluded deposits. The math underneath is one line. On personal statements it is eligible deposits divided by 12 or 24. On business statements it is eligible deposits times the borrower's ownership percentage, times the expense factor, divided by the number of months.
Nobody loses an afternoon on that formula. They lose it on the 24 PDFs behind it. Somebody has to open each statement, add up the credits, find every transfer from the borrower's own savings account, pull out the tax refund and the loan proceeds, count the NSF and overdraft items, and type the result into the right row. On a busy business account that is thousands of lines, and one missed transfer overstates income by the full amount of that transfer.
LenderAnalyzer does the part the worksheet cannot. Upload the statements you already collected, personal or business, and it extracts every transaction, totals deposits by month, lists the largest deposits for sourcing, counts NSF and overdraft items, and exports the whole ledger to Excel. Your underwriter drops the monthly totals into your investor's calculator, applies the program's expense factor and ownership percentage, and signs off on a number that traces back to the statement page it came from.
We are a tool for the loan officer, processor or underwriter doing the calculation, not a loan program. We do not set your eligibility rules, and the investor's guideline always wins.
Program rules differ by investor, so treat the figures below as the common pattern, not your guideline. We quote Arch Mortgage Funding's published calculator instructions and a wholesale lender's program matrix because both are public, specific and current enough to check.
On personal accounts the usual method is eligible self-employment deposits over the most recent 12 or 24 consecutive months, divided by 12 or 24. Arch's instruction sheet puts it as eligible deposits divided by 12 or 24 months equals monthly qualifying income. No expense factor applies on most personal-statement programs, which is why the transfer question matters so much: money that moved from the borrower's own business or savings account into the personal account is not new income, and counting it inflates the result dollar for dollar.
On business accounts the formula adds two multipliers. Arch writes it as (eligible deposits times ownership percentage) times 50 percent, divided by 12 or 24 months. Its business worksheet requires a minimum 25 percent ownership stake. The 50 percent is the standard expense factor, a stand-in for what the business spends to earn its revenue. Arch also notes that the standard 50 percent option cannot be used if third-party documentation shows an expense ratio above 50 percent, so a P&L you collected for another reason can change the answer.
Most programs let a CPA or licensed tax preparer attest to a lower expense ratio for an efficient business. Arch sets the floor at 10 percent and requires the statement to show the expense percentage of gross annual revenue, confirm the preparer filed the borrower's most recent return, include license verification, and carry signatures from both the preparer and the borrower. A 2022 wholesale matrix from theLender offered the same three routes: a uniform 50 percent ratio, a CPA-prepared P&L (with business deposits supporting at least 75 percent of the P&L's gross receipts), or a CPA letter. Moving a business from 50 to 30 percent raises qualifying income by 40 percent, so the letter is often the whole loan.
This is the step that trips people. Arch's instructions say that on a 12-month file the underwriter must also calculate the most recent 6 months, and on a 24-month file the most recent 12 months, and the lower of the two calculations must be used. Take a hypothetical business borrower with 50 percent ownership and a 50 percent expense factor. $1,440,000 of eligible deposits over 24 months gives $15,000 a month. If the most recent 12 months hold only $660,000, that period gives $13,750 a month, and $13,750 is the number that qualifies. You only see it if the deposits are broken out by month.
The same instructions separate three patterns. Stable or rising income is averaged over the documentation period. Declining but stable income cannot be averaged against the earlier, higher level; the lower level is used. A decline of more than 20 percent from the prior level triggers a full review, a letter of explanation from the borrower and written justification from the underwriter before the income can be used at all. A month-by-month deposit table makes that trend visible in seconds. A single total at the bottom of a spreadsheet hides it.
Worksheets give you a column for excluded deposits and leave the judgment to you. The common exclusions are transfers between the borrower's own accounts, loan and credit line proceeds, credit card cash advances, tax refunds, refunds and chargebacks, insurance proceeds, one-time asset sales, and gifts. theLender's matrix put it plainly: transfers between personal accounts are not income, and commingled accounts are treated as business accounts. Large deposits that are unusual for the business have to be sourced. LenderAnalyzer lists every credit with its date and description and pulls the largest deposits to the top, so the exclusions are a review, not a hunt.
Programs cap overdrafts and returned items. theLender's 2022 matrix counted NSFs on an instance basis and allowed a maximum of 3 instances on 12 months of statements and 6 on 24 months. Arch's worksheet has an NSF column on every monthly row and refers tolerances to its program manual. Counting them by hand across 24 statements is where they get missed. LenderAnalyzer flags NSF, overdraft and returned-item lines across the whole period and totals the fees, so you know whether the file is eligible before you spend time on the income.
We are honest about scope. LenderAnalyzer reads the statements, extracts and totals the transactions, surfaces large deposits, recurring deposit streams, existing loan payments and NSF activity, and exports it all to Excel. It does not decide which deposits your investor treats as eligible, it does not pick your expense factor, and it does not replace the investor's own calculator or your underwriter's sign-off. What it removes is the keying: the hours between a stack of PDFs and a filled-in worksheet.
What each approach actually does with the statements. Vendor details come from each vendor's own pages, checked in September 2026. Where a vendor publishes no price, we say so.
Swipe sideways to see the full comparison
| Option | How the monthly deposit totals get in | Published price | Shows the recent-period test | Best for |
|---|---|---|---|---|
| LenderAnalyzer This page | Read from the uploaded PDFs: every transaction extracted, deposits totaled by month, exported to Excel | Yes: from $99/mo (2,500 pages), $199/mo (10,000 pages, bulk upload of 50 files), volume tiers above | Yes, deposits are broken out by month so the 6 or 12 month figure is one sum | Brokers, processors and non-QM underwriters who want the worksheet filled from the statements |
| Investor Excel calculator (for example Arch Mortgage Funding) | Typed by hand, one row per month: total deposits, NSF items, excluded deposits | No charge; provided by the wholesaler for training and informational purposes | Only if you type both periods correctly | Low-volume brokers who already know the program and have time to key |
| LoanBeam NQM Income Calculator (LoanLogics) | AI extraction with human-in-the-loop validation and investor-specific calculation logic | None published; request a demo | Built around investor rules | Mid-size and larger mortgage lenders buying an enterprise income platform |
| Ocrolus Bank Statement Income Calculator | Document extraction plus analytics such as NSFs, large deposits and monthly balances | None published; sales quote | Monthly analytics available | Retail and non-QM lenders already on the Ocrolus platform |
| Manual spreadsheet you build yourself | Copied line by line from each statement | Staff time only | Depends entirely on the person building it | One-off files, never volume |
Comparison compiled by LenderAnalyzer from public vendor materials; see the date noted above each table. Competitor names are trademarks of their respective owners; figures may change, so verify current details with each vendor.
Computed deterministically from every extracted transaction, every figure traceable to its source line.
Computed across the full statement period, carried forward day by day.
Deposits vs withdrawals and net flow, broken down month by month.
Every insufficient-funds and overdraft incident counted, with fees totaled.
Recurring deposits grouped into income streams with estimated monthly amounts.
Debits to other lenders and funders detected and totaled per month.
Days below zero across the period, a direct stress signal.
The biggest credits with dates and sources, concentration flagged.
Automatic red and yellow flags your analysts can review in seconds.
Drop in PDFs, scans or photos, one statement or a multi-month package, from any bank.
Every transaction is extracted, then cash flow, balances, income streams, NSF activity and debt payments are computed.
Read the underwriting snapshot, download the Excel report, or pull structured JSON into your LOS via API.
28 lending document types extracted out of the box, build the complete picture of an applicant's financial situation.
Common questions from lending and credit teams.
Add up the eligible deposits for 12 or 24 consecutive months, remove transfers between the borrower's own accounts and other non-income credits, and divide by the number of months. On business statements, multiply by the borrower's ownership percentage and apply the program's expense factor, usually 50 percent, before dividing. Then run the same math on the most recent 6 or 12 months and use the lower figure if your investor requires it.
Personal-statement programs average eligible deposits over 12 or 24 months. Business-statement programs take eligible deposits times ownership percentage times the expense factor, then divide by the months provided. Arch Mortgage Funding's published instructions, for example, write it as (eligible deposits x ownership %) x 50% / 12 or 24 months. Your investor's guideline controls the exact rules, so always check it.
It is the share of business deposits assumed to go to operating costs, applied only to business-account programs. The standard is 50 percent. Many investors accept a lower custom factor documented by a CPA or licensed tax preparer; Arch Mortgage Funding sets the minimum at 10 percent. Some programs use a CPA-prepared P&L instead and qualify on its net income when the deposits support it.
Both exist. Most non-QM investors offer 12-month and 24-month programs, and the 24-month version often carries better pricing or leverage because it shows a longer income history. Under Arch's instructions a 12-month file is also tested on the latest 6 months and a 24-month file on the latest 12 months, with the lower result used, so a recent slowdown reduces income either way.
Common exclusions are transfers between the borrower's own accounts, loan or credit line proceeds, credit card cash advances, tax refunds, refunds and chargebacks, insurance payouts, one-time asset sales and gifts. Large deposits that are unusual for the business usually need a source document. The investor's guideline is the final word, and commingled accounts are often treated as business accounts.
It depends on the investor. One wholesale matrix we reviewed allowed a maximum of 3 NSF instances on 12 months of statements and 6 on 24 months, counted per instance rather than per fee. Others are stricter. Because a count over the limit can make the file ineligible, it is worth counting NSF and overdraft items before you run the income calculation.
Some programs allow it, but the two are calculated differently: personal deposits usually count without an expense factor, business deposits get the factor and the ownership percentage. The risk is double counting, where an owner draw from the business account shows up again as a personal deposit. Reading both account types side by side and marking the transfer on each is the safe way to combine them.
Yes. Most wholesale non-QM lenders publish an Excel worksheet, and Arch Mortgage Funding's is a typical example with personal and business tabs. The worksheet handles the arithmetic but not the data entry. LenderAnalyzer exports every transaction and the monthly deposit totals to Excel, so the numbers you paste into the investor's calculator come straight from the statements instead of being retyped.
By hand, a 24-month business file with hundreds of deposits a month can take an hour or more, most of it spent totaling months and hunting for transfers. With the statements extracted and totaled by month, the remaining work is the underwriting judgment: marking exclusions, sourcing large deposits and applying the program factor, which usually takes minutes rather than an hour.
LenderAnalyzer starts at $99 a month for 2,500 pages, with a $199 plan for 10,000 pages that adds bulk upload of 50 files at a time, and volume tiers above that. LoanBeam NQM and Ocrolus do not publish prices and quote through sales. Investor Excel calculators cost nothing but leave the data entry to your team.
How credit teams run these calculations by hand, so you can see exactly what the software automates.
Qualifying income from 12 or 24 months of statements, with an audit trail.
Bank statement, P&L and asset programs underwritten from documents.
Eligible deposits, transfers to exclude and the expense factor, step by step.
Income calculation tools for lenders compared on price and rollout time.
Document platforms compared for non-QM and small business lenders.
Pay stubs, W-2s, returns and statements checked against each other.
Altered PDFs and edited balances caught before the income is counted.
What a connected asset report costs, and when statements are the better route.
Analyze your first statements free, plans from $99/month, 50% off billed annually.
