Use-case page

Bank statement PDF workflows

Prepare bank statement PDFs for lenders, landlords, and accountants: pull tables into Excel, trim pages, shrink uploads, and add a password.

Bank statements get requested in a lot of places: a mortgage broker wants the last few months, a landlord wants proof of income, an accountant needs a year of transactions to reconcile. Each of those people wants something slightly different, so the same downloaded statement often needs two or three versions.

Who asks for statements, and in what form

  • Lenders and brokers usually want complete, unedited statements covering a specific period, uploaded through a portal or sent by email.
  • Landlords and letting agents often only need a recent month or two that shows your name, address, and regular income.
  • Bookkeepers and accountants care less about the PDF itself and more about the transaction table, which they want in a spreadsheet.

Read the request carefully before you start. If it says “complete statements”, do not remove pages; if it asks for a date range, send only that range.

Steps for a lender or landlord submission

  1. Download each monthly statement from online banking as a PDF. A statement exported directly from the bank has a real text layer, which matters for the later steps.
  2. If the recipient wants one file, combine the months in date order with Merge PDF. Set Sort files to Keep uploaded order and upload oldest first, or use Sort by file name if your files are named like 2026-07-statement.pdf.
  3. If only certain pages are needed (for example, the summary page of each month), use Extract Pages and enter the pages in Pages to extract, such as 1,5,9.
  4. Check the size. Merged statements with logos and charts can grow quickly. Run Compress PDF at the default Compression level of Level 5, or type the portal’s stated maximum into Target size.
  5. Before emailing, add an Open password with Protect PDF, keep Encryption strength at 256-bit, and send the password by text message or phone call rather than in the same email.

Getting transactions into a spreadsheet

PDF to Excel reads table content and writes it into an XLSX workbook. Use the Pages field to skip the cover page and marketing inserts, for example 2-6. After converting, compare the opening and closing balances in the sheet to the PDF; if a row was split across a page break, you will see it in the totals.

If the statement is a photo or a scan from a paper copy, there is no text for the converter to read, so the spreadsheet will come out empty or incomplete. The reliable fix is to download the digital statement from your bank instead.

A worked illustration

Say a landlord asks for three months of statements as a single PDF. You download July, August, and September, upload them to Merge PDF in that order, and download one combined file. You open it, confirm the account number and dates are visible on each month, and compress it at Level 5. Then you protect it with an open password and text the password to the agent. The original three downloads stay untouched in a folder in case the agent later asks for the originals.

Things to avoid

  • Do not use Edit PDF to change figures, names, or dates on a statement. Recipients may check with the bank, and an altered statement is a serious problem. Editing is for your own notes on a working copy only.
  • Do not set Disable copying text and content on a copy meant for an accountant; they will need to select and copy figures.
  • Do not over-compress. If account numbers or small print become hard to read, go back to a lower level.

For background on what passwords do and do not stop, see PDF passwords vs. permissions. Compress and Protect are instant tools; the result comes back in the same request and the site does not save a copy to storage, as described on the file retention page.

Trust center

Trust pages

How We Want PDF handles your files: privacy, security, and how long uploads are kept.

privacy

Privacy

How We Want PDF handles the files you upload, what is needed to use the tools, and which tools send content to an AI provider.

Read page
security

Security

How We Want PDF checks uploads, delivers results, limits abuse, and removes queued job files.

Read page
retention

File retention

How long We Want PDF keeps uploaded files and results, and when they are removed.

Read page