StatementReady vs Excel lender worksheets for bank statement income
Compared on October 31, 2026. StatementReady features and prices are from statementready.net on that date.
If you build bank statement income in Excel, in a worksheet a lender publishes or a template you made, here's what changes when you upload the statements to StatementReady instead, and where a spreadsheet still fits.
What an Excel lender worksheet is
Some lenders publish their own bank statement income calculator as a downloadable Excel (.xlsx) file. You type each month's deposit totals from the statements into its input cells, along with the inputs that lender asks for, and its formulas produce the figure. You can also build your own template in an Excel worksheet and set it up for any method a lender asks for.
What StatementReady does instead
Upload 12 or 24 months of a self-employed borrower's business or personal bank statements. StatementReady checks whether each statement's transactions add up to its printed balances, flags NSFs, overdrafts and, on purchase files, large deposits, applies the expense factor and ownership percentage you enter, and gives you a worksheet you can review before the file goes to underwriting. StatementReady prepares a worksheet for your review; the lender's guidelines and underwriter make the final call.
Side by side
| Excel lender worksheet | StatementReady | |
|---|---|---|
| Getting the numbers in | You type or paste each month's totals from the statement PDFs. | You can upload separate PDFs or one combined PDF, and StatementReady splits it into individual statements and detects the account and period for each. The limit is 20 MB per PDF. |
| Layout and method | A lender's own worksheet follows that lender's layout and inputs. A template you build follows whatever method you set up. | It exports a generic 12/24-month worksheet. |
| Balance checks | Whatever checks the worksheet's author built in. Check the worksheet you're using. | Every statement is checked to the cent: opening balance plus credits minus debits must equal the closing balance. It also checks that each closing balance matches the next opening balance and flags missing months. Statements that don't reconcile, or can't be checked, are marked Unverified, and exports carry that warning. You review flags and can edit rows. |
| Missing months | Depends on the worksheet. | In StatementReady, a month with no statement in the 12- or 24-month window is flagged as missing and counts as zero in the worksheet until you add it. |
| Deposits left out of income | You decide which deposits to leave out and enter them where the worksheet asks. | StatementReady excludes matched internal transfers, refunds, tax refunds and returned items automatically, and you can override any item. Deposits that look like wages or payroll, Social Security, SSI, pension, rent or child support aren't counted by default either, and you can count any of them back in the Review queue. |
| Expense factor and ownership | Entered where the worksheet asks for them. | You enter the factor from your lender's program on the loan file. In StatementReady you enter the ownership %, and a blank field counts as 100%. |
| NSFs and overdrafts | Counted by you and entered where the worksheet asks. | It counts NSF and overdraft occurrences by month and account, and warns you when a count is over the limit you set on the loan file. If you leave the limits blank, it uses 3 in 12 months or 6 in 24 months. Set them to match the program you're submitting to. |
| Large deposits | You work out the threshold and review deposits against it. | On Purchase, it flags deposits over 50% of the monthly income you enter on the loan file (threshold = that income ÷ 2; if the income field is blank, StatementReady uses 50% of the calculated monthly income and labels it that way, and if there is no calculated income either, the check doesn't run and says so). On Refinance, StatementReady produces no large-deposit flags at all. |
| Running the file for another lender | Each lender's worksheet is filled in separately. | (Solo) Re-run a completed file under a saved profile without re-uploading or re-extracting the statements — only the calculation runs again. Configured by you from your saved settings — not a lender determination. Confirm the current guideline with the lender before you rely on it. |
| What you get | The workbook itself. | You get an .xlsx with the income summary and month rows, the letter-of-explanation list and average daily balances. CSV and PDF exports are also available. |
| Cost | Depends on the software you use. You need software that opens .xlsx files. | Your first 2 loan files are free, no card required. Then pay as you go at $15 per loan file, paid in advance, or Solo at $49/month with 6 loan files a month ($490/year with 72). Extra loan files on Solo are $8 each. |
| Who decides | The worksheet calculates what you enter. You and your lender make the decisions. | It doesn't make a credit decision. You review the flags, and you and your lender stay responsible for checking the results against program guidelines. |
Excel worksheets vary. Check the worksheet you're using.
StatementReady assists your review. It doesn't make underwriting or credit decisions, and it doesn't replace your judgment or your lender's guidelines.
Where an Excel worksheet fits
If the lender you're submitting to publishes its own worksheet and wants it filled in, that worksheet is what it asked for. A spreadsheet also lets you follow any layout or method a lender asks for, and it costs nothing extra if you already have the software.
Where StatementReady fits
Reconciled means the transactions add up to the printed balances. It doesn't confirm that each deposit is eligible income.
How uploaded statements are processed, including AI reading of scanned pages, and when they're deleted is described in our Privacy Policy (Sections 4 and 6).
See what StatementReady produces from 12 months of statements before you sign up: the sample worksheet uses made-up data, and every download is marked SAMPLE.
FAQ
Is there a bank statement income calculator for brokers?
StatementReady builds an income worksheet from the uploaded statements using the months, ownership % and expense factor you enter. It's a tool to check against your lender's guidelines, not a lending decision. You and your lender make the final call on what counts as income.
How is income calculated on a bank statement loan?
A common method: add up the deposits your lender will count over the look-back period, divide by the number of months, then apply the borrower's ownership share and the program's expense factor. Requirements vary by lender and program. StatementReady's worksheet does exactly that: average counted deposits × ownership % × (1 − expense factor).
How does StatementReady check that the numbers are right?
Every statement is checked to the cent: opening balance plus credits minus debits must equal the closing balance. It also checks that each closing balance matches the next opening balance and flags missing months. Statements that don't reconcile, or can't be checked, are marked Unverified, and exports carry that warning. You review flags and can edit rows.
Can I export StatementReady's worksheet to Excel?
Upload the PDFs to a loan file in StatementReady, then use the Excel worksheet export. You get an .xlsx with the income summary and month rows, the letter-of-explanation list and average daily balances. CSV and PDF exports are also available.
Does StatementReady make the lending or income decision?
No. It doesn't make a credit decision. You review the flags, and you and your lender stay responsible for checking the results against program guidelines.
How much does StatementReady cost?
Your first 2 loan files are free, with no card required. Then pay as you go at $15 per loan file, paid in advance, or Solo at $49/month with 6 loan files a month ($490/year with 72). Extra loan files on Solo are $8 each.
StatementReady assists your review. It doesn't make underwriting or credit decisions, and it doesn't replace your judgment or your lender's guidelines.
Try it on your next loan file.
Your first 2 loan files are free, no card required.
Then pay as you go at $15 per loan file, paid in advance, or Solo at $49/month with 6 loan files a month ($490/year with 72). Extra loan files on Solo are $8 each.
Spot something out of date? Email support@statementready.net.
Microsoft and Excel are trademarks of the Microsoft group of companies. StatementReady isn't affiliated with or endorsed by Microsoft.