Upload a borrower's 12 or 24 months of personal or business bank statements and download one Excel file with every deposit in its own row, ready for the five-line income worksheet on this page. Built for loan officers, processors and brokers who price non-QM bank statement loans every week and cannot spend a morning keying deposits per file.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940, BAI2, NACHA, camt.053, CSV
Uploading...
Add up 12 or 24 months of deposits, remove the ones that are not income (transfers between the borrower's own accounts, loan proceeds, refunds, returned items), apply the program's expense factor to business accounts, then divide by the number of months. BankXLSX does the slow part: it converts every statement PDF into Excel rows with the balance checked, so the worksheet totals in minutes instead of an afternoon of typing.
The arithmetic behind a bank statement loan is simple. Getting two years of deposits into a sheet you can defend is not.
A 24 month business program means 24 statements, often 6 to 15 pages each, and sometimes a second account on top.
Most statements interleave credits and debits by date, so pulling only the deposits by hand means reading every line.
Underwriters ask why each transfer or loan deposit was removed. A total typed on a calculator cannot answer that.
Drop a single $14,000 month from a 12 month file and the qualifying income moves by more than $580 a month at a 50 percent factor.
Self-employed borrowers send what they have, including scanned and photographed pages that copy and paste cannot read.
The broker who tells a borrower what they qualify for the same afternoon usually gets the file.
Clean deposit rows per statement, in the order the bank printed them, with proof that nothing is missing.
Date, description, amount and running balance in separate columns, so a filter shows credits only.
Opening balance plus deposits minus withdrawals is tested against the printed ending balance, so a skipped page shows up before underwriting.
On Plus, upload up to 50 PDFs at once, enough for two accounts across a 24 month program.
Plus categorizes transactions and normalizes payer names, which groups transfers, loan proceeds and card processor deposits for review.
AI visual OCR reads scanned and photographed statements in PDF, JPG, PNG and HEIC.
256-bit encryption in transit, no bank login requested, and uploads you can delete whenever the file closes.
The routine for a prequal or a full file, whatever program guide you underwrite to.
Upload all 12 or 24 PDFs and download one Excel workbook. Each statement keeps its period and balance check.
Tip: Check that the months run without a gap before you total anything.
Filter to deposits and tag transfers, loan proceeds, refunds, returned items and any large deposit your program wants sourced.
Tip: Keep an Exclude column with a reason, not deleted rows.
Sum eligible deposits, apply the expense factor and ownership percentage, and divide by the months. The five formulas are below.
Tip: The lender's program guide sets the factor, not the calculator.
US mortgage and business lending teams that qualify self-employed borrowers on deposits instead of tax returns.
Give a self-employed borrower a qualifying income figure the same day the statements arrive.
Run the numbers before choosing which wholesale lender's program fits the file.
Rebuild the deposit schedule with a reason for every exclusion, ready for the credit file.
Average monthly revenue for working capital and equipment requests from the same converted rows.
Every non-QM bank statement program follows the same skeleton, even though the details live in each lender's guide. Start with total deposits for the statement period. Remove deposits that are not income. For a business account, multiply what is left by one minus the expense factor, then by the borrower's ownership share. Divide by 12 or 24. For a personal account used for business income, most programs skip the expense factor and use the eligible deposits as they are. The federal ability-to-repay rule allows income to be verified with records from a financial institution (Regulation Z, 12 CFR 1026.43(c)(4)), which is why these programs exist at all. The specific factor, the large deposit threshold and the treatment of declining trends come from the lender.
A self-employed electrician sends 12 monthly statements from a business checking account, 5 to 9 pages each, 81 pages in total. Converted to Excel, the deposit rows add up as follows.
| Line | Amount | Note |
|---|---|---|
| Total deposits, 12 months | $214,600 | Sum of every credit row |
| Transfers from personal savings | minus $18,000 | Three transfers, own money moving |
| Equipment loan proceeds | minus $25,000 | Borrowed funds, not revenue |
| Returned customer check | minus $1,200 | Deposited, then charged back |
| Supplier refund | minus $400 | Return of an expense |
| Eligible deposits | $170,000 | Basis for income |
| After a 50 percent expense factor | $85,000 | Factor set by the program |
| Ownership 100 percent, divided by 12 | $7,083.33 a month | Qualifying monthly income |
If the same borrower owned 60 percent of the business, the monthly figure would be $4,250. If a CPA letter supported a 30 percent expense ratio and the lender accepted it, the 100 percent owner would qualify at $9,916.67 a month. Small inputs move the answer a lot, which is why the deposit list has to be complete before anyone argues about the factor.
Once the statements are converted, put the transactions in one sheet with columns for Date, Description, Amount (deposits positive) and an Exclude column where you type a reason for anything that is not income. Then use these cells.
=SUMIFS(C:C,C:C,">0")=SUMIFS(C:C,C:C,">0",D:D,"<>")A pivot of eligible deposits by month next to it shows the trend, which most program guides ask you to look at before accepting a 24 month average. The bank deposit analysis page covers that month by month view in more depth.
| Option | What it does | Price | Best for |
|---|---|---|---|
| Online estimator calculators | You type totals, it applies a factor | No charge | Borrowers guessing a range, no deposit list |
| BankXLSX plus the worksheet | Converts every statement to Excel rows with balances checked, you apply the program formula | Starter $49 a month for 800 pages, Plus $149 for 1,920 pages | Brokers and LOs who want the deposit list and keep control of the factor |
| DocuClipper income solution | Eligible deposits and monthly average, its page says the expense factor stays with the lender | From $29 a month for 60 pages, Business $159 for 640 pages | Teams that want an income report and fraud scoring |
| Ocrolus income calculator | Income worksheet inside a lender platform | Quote based, needs an Ocrolus dashboard | Lenders running high volume through one platform |
Prices were checked on the vendors' public pages in November 2026. If your shop is weighing the platforms, the Ocrolus alternative and DocuClipper alternative pages go through them line by line, and the roundup of bank statement extraction software for lenders covers the wider market.
For the borrower side of the same process, see bank statement loan requirements for self-employed borrowers and what underwriters look for in bank statements. Lending teams converting statements every day usually start from the bank statement converter for lenders.
Total the deposits for 12 or 24 months, subtract transfers, loan proceeds, refunds and returned items, apply the program's expense factor and ownership share for business accounts, then divide by the number of months. The result is the qualifying monthly income, subject to the lender's guide.
It depends on the lender and the business. Many non-QM programs default to a fixed factor such as 50 percent on business accounts, and some accept a lower figure supported by a CPA letter or a profit and loss statement. Always take the factor from the program guide you submit to.
Usually not. When a borrower runs business income through a personal account, most programs count eligible deposits without an expense factor, but they still remove transfers and other non-income credits. Some lenders apply their own rules to commingled accounts, so read the guide.
Transfers between the borrower's own accounts, loan and credit line proceeds, refunds, reversals and returned deposits are the usual exclusions. Large deposits outside the normal pattern often need a source document or get removed. Keep each excluded row with a reason so the underwriter can follow it.
No. BankXLSX converts the statements into Excel rows with balances checked, and on Plus categorizes the transactions. The expense factor and exclusions follow your lender's program, so you apply them with the five formulas on this page, which takes a few minutes once the rows exist.
Yes. Scanned and photographed statements are read with AI visual OCR and come out in the same Excel layout as digital PDFs. Check each statement's balance line before using the totals, as you would with any file a borrower supplies.
A 24 month file of 8 page statements is about 192 pages. Starter covers 800 pages a month for $49, roughly four such files, and Plus covers 1,920 pages for $149 with batch upload of up to 50 PDFs. A one-time 15 page demo lets you test first.
Deposits by month, tagged and totaled.
Convert 24 statements in one go.
Cancel anytime from your account settings · refund policy
Get started converting bank statements to spreadsheets.
USD
per month
per month
$288 charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | 800 pages |
| Pro AI Best accuracy | 80 pages |
Scale statement conversion across your team with automation.
USD
per month
per month
$888 charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | 1,920 pages |
| Pro AI Best accuracy | 192 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
per month
$ charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
Try it once, free: sign up and convert up to 15 pages (5 per statement) with no credit card. The demo does not renew.