How to Bulk Convert Bank Statements

Converting many bank statements at once, keeping the audit trail intact, and verifying a batch without checking every file by hand.

Converting one statement is a task. Converting sixty — a year of statements across five clients — is a process, and it needs different handling.

The batch verification problem

With one file you read the verification result. With sixty, nobody reads sixty verification results, which means the check silently stops happening.

The answer is to invert it: instead of confirming each file passed, list only the files that failed. A batch of sixty where three need attention is a manageable piece of work; a batch of sixty where you have to check sixty is not.

Keeping the audit trail

Organise by entity and period before converting One folder per client per year. This makes a missing month visible before you start.
Keep filenames meaningful client-account-YYYY-MM is enough. Renaming after conversion loses the link to the source.
Keep the source PDFs The export is derived data. For anything auditable, the PDF is the record.
Convert per statement, not per merged file Merging PDFs first loses per-statement verification.
Check period continuity per account Closing balance of one period equals opening balance of the next.

The continuity check finds missing statements

This is the check that matters most on a batch, and it is not about conversion accuracy at all. If February's closing balance does not equal March's opening balance, a statement is missing from your set.

No per-file check will ever find that, because every file you have is fine. It is the gap between them that is the problem.

A folder structure that works

The organisation matters more than it sounds, because it is what makes gaps visible before they become problems.

client / account / YYYY / client-account-YYYY-MM.pdf

With that structure, a missing month is visible as a gap in a directory listing. With everything in one folder named by download date, it is invisible until a reconciliation fails months later.

Keeping conversions alongside sources

Save each export next to its source PDF with a matching name. When a figure is queried six months later, the question is always "which statement did this come from", and a matching filename answers it in a second.

Frequently asked questions

How many files can I convert at once?

Up to 50 statements in one batch on a paid plan. Every page of every file counts against your monthly page allowance.

How should I organise converted statements?

Client, then account, then year, with matching filenames for the PDF and its export. It makes missing periods visible and answers provenance questions instantly.

Do the exports have consistent columns?

A batch does: every file comes back as Date (written YYYY-MM-DD), Description, Reference, Debit, Credit and Balance, with any column a statement leaves empty dropped and any extra one it prints added after them. A single conversion is different — it keeps each bank's own columns, exactly as printed.

Convert a statement now

Bank Statement PDF to Excel, or see every format. More in the guides.