Bank statement income calculator
Lenders that approve a loan on bank statements look at deposits month by month and at their average. Choose your PDF statements and download an Excel file with all the transactions and a second sheet with the monthly totals.
Check the table. If a column is wrong, change its type in the header: the spreadsheet is made from what you see.
Statement not read correctly, or something broke? Tell us
Your statement never leaves your device
How to do it
- Download the statements you need as PDFs from online banking: usually the last 12 or 24 months.
- Choose all the files here at once and look at the check line: if the balances add up, no transaction is missing.
- Click "Download Excel".
- Open the "Income by month" sheet: deposits, number of deposits, withdrawals, net and NSF or overdraft fees for each month, then the total and the average per month.
Tips
- Months with no movements inside the period are listed with zeros, so the average is over every month, the way a lender counts it.
- Every deposit is counted, including transfers between your own accounts and refunds. Lenders usually leave those out: delete them on the first sheet and the totals are easy to redo with a SUM.
- NSF and overdraft fees are found by their wording (NSF, insufficient funds, overdraft, returned item). Check the count against your statements before you send it to anyone.
- Statements from several accounts are added together. To see one account, choose only its files.
Questions
Is this what my lender will calculate?
It is a starting point, not the lender's figure. Each lender has its own rules: some take 12 months and some 24, some count only business deposits, and some apply an expense ratio. Use the sheet to see where you stand and to prepare the documents.
Can I use it for business and personal accounts?
Yes. Run the business statements and the personal statements separately to get one income sheet for each.
Is my statement uploaded anywhere?
No. Your browser reads the PDFs and writes the Excel file on your device. Nothing is sent to a server, and there is no account to create.
Does it work with scanned statements?
No. It needs the digital PDFs you download from online banking, which have the text inside. A scan or a photo is only a picture.