Bank Statement Income Calculator for Non-QM Loan Officers and Brokers

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.

One-time 15 page demo, no credit card
Running balance checked on every statement
Starter $49 a month for 800 pages

PDF, JPG, PNG, BMP, HEIC, TIFF, MT940, BAI2, NACHA, camt.053, CSV

Upload your bank statement

Extract:

How bank statement income is calculated, in short

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.

Why Income Calculations Stall on the Statements

The arithmetic behind a bank statement loan is simple. Getting two years of deposits into a sheet you can defend is not.

24 PDFs per Borrower

A 24 month business program means 24 statements, often 6 to 15 pages each, and sometimes a second account on top.

Deposits Hide Among Debits

Most statements interleave credits and debits by date, so pulling only the deposits by hand means reading every line.

Exclusions Need a Paper Trail

Underwriters ask why each transfer or loan deposit was removed. A total typed on a calculator cannot answer that.

One Missed Month Changes the Average

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.

Scans and Phone Photos

Self-employed borrowers send what they have, including scanned and photographed pages that copy and paste cannot read.

Prequal Speed Wins the Deal

The broker who tells a borrower what they qualify for the same afternoon usually gets the file.

What BankXLSX Gives the Income Worksheet

Clean deposit rows per statement, in the order the bank printed them, with proof that nothing is missing.

Every Deposit as an Excel Row

Date, description, amount and running balance in separate columns, so a filter shows credits only.

Balance Check per Statement

Opening balance plus deposits minus withdrawals is tested against the printed ending balance, so a skipped page shows up before underwriting.

24 Statements in One Batch

On Plus, upload up to 50 PDFs at once, enough for two accounts across a 24 month program.

Deposits Categorized

Plus categorizes transactions and normalizes payer names, which groups transfers, loan proceeds and card processor deposits for review.

Scans and Photos Read

AI visual OCR reads scanned and photographed statements in PDF, JPG, PNG and HEIC.

Borrower Data Kept Private

256-bit encryption in transit, no bank login requested, and uploads you can delete whenever the file closes.

From Statement PDFs to Qualifying Income in 3 Steps

The routine for a prequal or a full file, whatever program guide you underwrite to.

1

Convert the Statements

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.

2

Mark the Exclusions

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.

3

Apply the Program Formula

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.

Who Runs Bank Statement Income Calculations

US mortgage and business lending teams that qualify self-employed borrowers on deposits instead of tax returns.

Non-QM Loan Officers

Give a self-employed borrower a qualifying income figure the same day the statements arrive.

Mortgage Brokers

Run the numbers before choosing which wholesale lender's program fits the file.

Processors and Underwriters

Rebuild the deposit schedule with a reason for every exclusion, ready for the credit file.

Business Lenders

Average monthly revenue for working capital and equipment requests from the same converted rows.

Transaction Types We Handle

Customer deposits
Card processor payouts
Mobile check deposits
Transfers from savings
Loan proceeds
Refunds and reversals
Returned deposits
Zelle and ACH credits

The bank statement income formula

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.

Worked example of a 12 month business account

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.

LineAmountNote
Total deposits, 12 months$214,600Sum of every credit row
Transfers from personal savingsminus $18,000Three transfers, own money moving
Equipment loan proceedsminus $25,000Borrowed funds, not revenue
Returned customer checkminus $1,200Deposited, then charged back
Supplier refundminus $400Return of an expense
Eligible deposits$170,000Basis for income
After a 50 percent expense factor$85,000Factor set by the program
Ownership 100 percent, divided by 12$7,083.33 a monthQualifying 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.

The five Excel formulas behind the worksheet

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.

  • Total deposits: =SUMIFS(C:C,C:C,">0")
  • Excluded deposits: =SUMIFS(C:C,C:C,">0",D:D,"<>")
  • Eligible deposits: total minus excluded
  • Net of expenses: eligible deposits times (1 minus the expense factor) times the ownership share
  • Qualifying monthly income: net of expenses divided by 12 or 24

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.

How BankXLSX compares with other ways to run the numbers

OptionWhat it doesPriceBest for
Online estimator calculatorsYou type totals, it applies a factorNo chargeBorrowers guessing a range, no deposit list
BankXLSX plus the worksheetConverts every statement to Excel rows with balances checked, you apply the program formulaStarter $49 a month for 800 pages, Plus $149 for 1,920 pagesBrokers and LOs who want the deposit list and keep control of the factor
DocuClipper income solutionEligible deposits and monthly average, its page says the expense factor stays with the lenderFrom $29 a month for 60 pages, Business $159 for 640 pagesTeams that want an income report and fraud scoring
Ocrolus income calculatorIncome worksheet inside a lender platformQuote based, needs an Ocrolus dashboardLenders 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.

What to check before the number goes in the file

  • Every month is present and each statement ties to its printed ending balance.
  • Transfers between the borrower's own accounts are removed on both sides when two accounts are submitted.
  • Large deposits are listed for sourcing at the threshold your program sets.
  • The 12 month and 24 month averages are compared, and a declining trend is flagged.
  • NSF and overdraft counts are noted, since many guides cap them.

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.

Why Loan Officers Use BankXLSX for Income Files

24
months of statements in one batch on Plus
$0.00
balance difference you can show per statement
800
pages a month on Starter for $49

Security & Privacy

  • No bank login requested from the borrower
  • 256-bit encryption on every upload
  • Delete uploaded statements at any time
  • Unlimited users on every paid plan

Bank Statement Income Calculator Questions

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.