How do I combine several months of bank statement PDFs into one spreadsheet?
Convert each monthly statement PDF with the free Bills AI converter, one file at a time and with no signup. Keep the header row only on the first file, paste the CSVs into one sheet in date order, then check that every month's closing balance matches the next month's opening balance before you use the totals.
Last reviewed:
Steps
- Download all the monthly statements as the bank's own PDFs, so the text in them can be selected.
- Convert the oldest statement first and download the CSV with the header row included.
- Convert each later statement with "Include header row" turned off and append its rows below the previous file, in date order.
- Sort or filter by date and look for rows that appear twice at the boundary between two statements.
- Check that each closing balance equals the next opening balance, and compare a few rows of every month with the PDF.
When this will not work
- The converter handles one PDF at a time and does not merge files for you.
- If the bank changed its layout between months, the columns may not line up, so check the headings of each CSV before you append it.
- Dates are copied as printed. Statements that print dates without a year need the year added by you.
- Scanned statements are not supported because the free converter has no OCR.
Related
Frequently asked questions
Is there a limit on how many statements I can convert?
The free converter allows 10 conversions a minute and 40 a day per visitor, with files up to 10 MB each, so a year of monthly statements fits in a day.
Will it add up my transactions?
No. It copies the transaction table as printed. Totals, balances and any summing are done in your spreadsheet, and the converter does not check them against the statement.
Do I need an account?
No. The converter needs no signup. An account is only needed for the Bills AI statement analysis.
More answers
- How do I convert a bank statement PDF to CSV without giving anyone my bank login?
- Why won't my bank statement PDF convert to CSV?
- How do I get bank statement transactions from a PDF into Excel or Google Sheets?
- How can I find recurring subscriptions on my bank or credit card statement?
- Is it safe to upload a bank statement PDF to an online converter?
- How do I let an AI assistant like Claude or ChatGPT read my bank statements through MCP?
- How can an AI assistant convert a bank statement PDF to CSV for me through MCP?
- How do I convert a credit card statement with two date columns, or separate debit and credit columns, to CSV?
- What can't Bills AI do with bank statements?
- How do I get older bank transactions into Excel when my bank only gives me PDFs?