How loan officers turn bank statements into underwriting spreadsheets

A sortable list of deposits and withdrawals per account, with dates, payees, and amounts. Running balances help, but the transaction list is the product.

Large deposits need to be explainable. Credits and debits should be signed consistently so net cash flow is a SUM, not a manual calculation.

Collect every PDF for the borrower's accounts for the requested period — checking, savings, business, and any large credit cards if the lender wants them.

Convert each PDF to Excel. Prefer one workbook per borrower: a summary tab plus one sheet per statement, so the file is reviewable without folder diving.

Name files clearly (Borrower-Acct7821-Jan.pdf) before upload so sheet names stay organized.

Confirm opening and closing balances match the PDF summary for each month. A single missing page will show up as a balance gap.

Flag any scanned statements early — they need OCR or a re-download, and that is the usual cause of a 'failed conversion'.

Upload the PDFs, get rows. Free is fine for a single statement or a quick check. Pro is built for the real package: unlimited conversions and combine-into-one-workbook.

Files are not stored after conversion. If your compliance policy requires a specific handling note, that is the sentence to paste into your file notes.