1. Retrieve the records from the bank
A converter cannot retrieve records that the bank has not supplied. Start with secure messaging, phone support or a branch request. Specify the account, exact date range and preferred formats.
Request CSV or Excel as the first choice and PDF as the official archive copy. Some banks expose only recent CSV data online but can produce older files through an archive team.
- Confirm whether the account is still open or already closed.
- Ask about archive and per-statement fees before ordering.
- Request one file per statement period with visible account and period details.
- Keep the files exactly as provided; work from copies.
2. Build an ordered statement archive
Before extraction, put every statement into a predictable order. A useful filename is YYYY-MM_bank_account-last4.pdf. This makes missing months and accidental duplicates visible before they enter the spreadsheet.
Do not merge the original PDFs. Keep the bank files intact and create a separate consolidated spreadsheet as the working document.
3. Diagnose each PDF before conversion
Try selecting a transaction description with your cursor. Selectable text usually means a text-based PDF. If the whole page behaves like one picture, the file needs OCR. Password-protected PDFs need the correct password before either method can work.
For scans and screenshots, read the bank statement OCR guide before processing a large archive.
4. Convert in small, testable batches
Do not begin with ten years of files. Convert one representative month first. Check the dates, descriptions, debit and credit signs, and running balance. Then test a difficult month with long descriptions or a different layout.
FolioParse shows extracted rows and warnings before the full workbook export.
5. Reconcile before combining months
For each statement, compare the first and last balance in the spreadsheet with the PDF. Then confirm that credits minus debits explains the movement between those balances. Review the exact checks in how to verify a bank statement conversion.
Only combine the months after each individual statement passes. This isolates errors and prevents one broken month from contaminating the full archive.
When manual entry is still safer
Manual work may be more reliable when pages are cropped, the scan is unreadable, the statement mixes several currencies without labels, or the layout changes repeatedly inside one file. A trustworthy converter should flag these cases instead of pretending the output is complete.