Bank Statement Mortgage Income Calculator
Reconcile business deposits across an older and recent statement segment, remove transfers and nonincome items, apply ownership and expense factors, then compare the modeled monthly income with housing and debt obligations. Every rule is user-entered because bank-statement mortgage programs are lender-specific.
→ INCOME
Create a statement reconciliation
Use the lender’s full PITIA or applicable housing figure.
The five-stage deposit reconciliation
The math is simple only after underwriting classifications are complete. The same $10,000 deposit can be business revenue, a transfer from another account, a business loan, a tax refund, a returned purchase, an owner capital contribution, or a sale of an asset. A bank feed does not identify the legal and economic character automatically. The borrower and lender need a documented reconciliation.
Worked 12-month example
The recent six-month segment shows $135,000 of gross business deposits, including $15,000 of verified transfers and nonincome items. Eligible recent deposits are $120,000, or $20,000 per month. The older six-month segment contains $125,000 gross and $5,000 excluded, also leaving $120,000 eligible and a $20,000 monthly average. The recent trend is therefore flat rather than declining.
Across all 12 months, $240,000 of eligible business deposits average $20,000 monthly. The borrower owns 100% of the business and the entered lender expense factor is 50%, producing $10,000 of modeled business income. There are no separate personal-account deposits and $1,000 of other verified monthly income, so total qualifying income is $11,000.
Proposed housing expense is $3,500 and other monthly debts are $1,000. Total obligations of $4,500 divided by $11,000 produce a 40.9% DTI. This is 2.1 percentage points below the user-entered 43% threshold. The comparison does not establish that 43% is the program limit, that every liability was included, or that the loan satisfies ability-to-repay requirements.
Deposits that need an exclusion decision
Account transfers. Money moved between the borrower’s own accounts is not new business revenue. Trace both sides so the same dollars are not counted twice. Transfers from a payment processor may be legitimate business receipts when the source detail supports sales rather than internal movement.
Borrowed funds and capital. Business loans, lines of credit, merchant cash advances, and owner contributions increase cash but are not operating income. Their repayment obligations may also affect cash flow or the lender’s analysis.
Tax refunds, insurance proceeds, and asset sales. These may be nonrecurring and can represent recovery of an expense or conversion of property rather than ongoing revenue. Underwriter treatment depends on source, recurrence, and program rules.
Personal receipts in a business account. Gifts, reimbursements, payroll from another employer, and household transfers can be excluded from business deposits yet considered separately if they meet another qualifying-income standard. Do not leave them in both categories.
Expense factor is not a free assumption
Standard factor
Some nonagency programs publish a default business-expense percentage for particular account types or industries. The factor converts eligible gross deposits into estimated net qualifying income. Use the current matrix tied to the specific lender and loan.
Third-party expense statement
A program may permit a CPA, enrolled agent, licensed tax preparer, or other qualified party to support a different expense ratio. Independence, license, scope, and document requirements vary. The calculator cannot validate a letter.
Ownership adjustment
A 50% owner generally should not receive 100% of business deposit income without a supported allocation rule. Ownership records, access to distributions, entity type, and other owners’ rights affect the result.
Personal statement program
Some programs analyze personal statements differently and may not apply the same business-expense factor. They can require proof that deposits are business-related and exclude transfers from business accounts already analyzed.
Why the calculator preserves two statement segments
A full-period average can hide decline. Twelve months of deposits could average $20,000 even when the first six months averaged $25,000 and the latest six averaged $15,000. Lenders may use the lower recent amount, require an explanation, decline unstable income, or ask for additional statements. A positive trend can also be questioned if it comes from one large nonrecurring deposit.
The calculator computes the percentage change from the older eligible monthly average to the recent average. It flags a negative trend but does not automatically reduce qualifying income because program responses differ. A zero older average makes percentage change undefined; the result labels the history as new rather than displaying an infinite growth rate.
Build a lender-ready audit trail
Keep every consecutive statement page, deposit detail, payment-processor report, transfer source, business license, entity and ownership documents, CPA or preparer letter when permitted, profit-and-loss statement, and explanation for unusual deposits. Reconcile statement totals to a spreadsheet without deleting negative days, fees, or returned items. The underwriter may request tax returns even when the program’s income calculation relies on statements.
For the loan application packet, also gather identification, asset statements, source of down payment, current housing history, credit explanations, debt statements, purchase contract, and insurance or tax estimates. Lenders may collect bank information electronically, but the borrower should review permissions and the accuracy of imported transactions.
Ability to repay is broader than one DTI result
The Consumer Financial Protection Bureau explains that most mortgage lenders must make a reasonable and good-faith ability-to-repay determination. The lender generally considers and documents income or assets, employment, credit history, and monthly expenses. A bank-statement calculation is one possible documentation path in a particular program; it does not remove the obligation to evaluate the transaction under applicable law.
The ability-to-repay rule does not create a universal 43% ceiling for every mortgage. Qualified Mortgage categories and lender overlays have changed over time, and non-QM does not mean “no rules.” The DTI threshold input is intentionally editable and the output says only whether the scenario is inside the entered value.
Common errors that inflate qualifying income
Counting transfers twice, ignoring negative deposits or chargebacks, using fewer months than required, applying a 0% expense factor without authority, failing to adjust for partial ownership, and mixing gross deposits with net profit can all overstate income. Another mistake is adding personal deposits that originated in the business account after the same business receipts were already counted.
On the debt side, borrowers often omit property taxes, homeowners insurance, association dues, mortgage insurance, business debts personally obligated, alimony, child support, student loans, leases, or payment obligations that the program includes. Use the lender’s liability worksheet, not a credit-monitoring app’s monthly total.
Tax income and mortgage income are not interchangeable
A bank-statement program may estimate business income from deposits and an expense factor, while federal taxable business income follows tax law and return reporting. Do not report the mortgage qualifying-income estimate on a tax return.
Frequently asked questions
Are all business bank deposits qualifying income?
No. Transfers, loans, refunds, owner injections, asset sales, and other nonrevenue items may need exclusion. Eligible receipts are then subject to ownership and expense treatment under the lender’s program.
Is 12 months always enough?
No. Programs may require 12 or 24 months, additional recent statements, or a longer self-employment history. The selected statement period must match the specific lender’s matrix.
What expense factor should I use?
Use only the factor allowed by the lender for the account and business, or a permitted third-party expense statement. A lower factor increases qualifying income and needs support.
Does DTI below 43% guarantee approval?
No. Forty-three percent is merely the example input. Credit, assets, reserves, property, pricing, loan-to-value, business stability, documentation, and ability-to-repay analysis all remain.
Can bank-statement income replace tax returns for every loan?
No. Conventional agency, government, portfolio, and non-QM programs have different documentation standards. A bank-statement option is product-specific and may carry different rates, fees, reserves, and down-payment requirements.
Underwriting limitation: This scenario does not approve a loan or establish legal ability to repay. The lender decides eligible accounts, deposits, exclusions, ownership, expenses, stability, liabilities, DTI, documentation, and product eligibility.