Bank statements into Excel for a mortgage or loan application
Lenders ask for three to six months of statements as PDFs. How to get them into a spreadsheet you can check, and the mistakes that cause a resubmission.
Mortgage and loan applications ask for three to six months of statements. The lender wants the bank's own PDFs; you often want the same data in a spreadsheet, to total your income, see what a lender will treat as a commitment, or answer a broker without reading sixty pages.
Send the PDFs, keep the spreadsheet
Lenders will not accept a spreadsheet in place of a statement. It carries no bank branding, no balances they can trust, and it is trivially editable. Always send the original PDFs the bank issued.
The spreadsheet is for you and your broker: totalling salary credits, spotting recurring commitments, and confirming the months you were asked for are the months you sent.
Convert one month at a time
It is tempting to merge six months into one file. Do not - and not for tidiness. Each statement's arithmetic closes only inside its own period: an opening balance at the start, a closing balance at the end, and those two figures are what prove nothing went missing. Merge the periods and you throw away the only check available.
Convert each month separately, confirm each reconciles, then combine the verified sheets if you want one view.
Never edit a statement
An amended PDF is fraud, and lenders check. Statements are verified with the bank directly or through open banking on most applications. If a figure looks wrong, ask the bank for a corrected statement.
Converting a PDF into a spreadsheet for your own analysis is a different thing entirely - you are reading the document, not changing it.
Check the months line up
The most common cause of a resubmission is a gap: five consecutive months plus one from last year, or a period starting a week after the previous one ended. Sort by date in the combined sheet and a gap is obvious in seconds.