ColumnryMulti-page statements
The column layout is found on the whole statement, repeated page headers and footers are skipped, and descriptions that run over two or three lines are joined into one row.
Debit, credit and balance
Statements with separate money-out and money-in columns and statements with one signed amount column are both handled. Columnry reads the running balance and checks that every row adds up; rows that don't are marked in red.
What the Excel file contains
The Transactions sheet has date, value date, description, reference, amount, money out, money in and balance. A second sheet keeps the table as it appears in the PDF, and a third has totals and the balance check.
How it works
- Download the statement from your online banking as a PDF.
- Open it in Columnry. The PDF is read on your device and is not uploaded.
- Check the columns and rows, fix anything that is off, and export to Excel, CSV, OFX or QIF.
What you get
Stays on your device
There is no server behind the converter, and the page's security policy blocks every network connection. You can turn off Wi-Fi after it opens.
Finds the columns
Date, description, money out, money in and balance are detected from the layout and the headers, across all pages of the statement.
Balance check
When the statement has a running balance or totals, Columnry checks every row against it and marks the rows that don't add up.
Review before export
Change what each column means, move the column lines on the page, untick rows that are not transactions, and correct any cell.
Dates and numbers from many countries
1,234.56 and 1.234,56, 31/12 and 12/31, month names in many languages, minus signs, brackets, CR/DR and Arabic-Indic digits.
Remembers your bank
Save the column setup once, and the next statement with the same layout is read the same way.
Good to know
- Columnry reads PDFs that contain real text, which is what online banking usually produces. Scanned or photographed statements (images) are not supported: there is no OCR. The app tells you when a PDF has no text.
- Statement layouts differ a lot. Always check the result, especially the balance check, before you rely on it.
- Password-protected PDFs work if you know the password. Columnry cannot remove protection you don't have the password for.
Questions
Why does the balance check matter?
It is a quick way to see that no transaction was missed or misread. If the check fails, look at the marked rows and the column lines.
Can I fix a wrong column?
Yes. Choose the meaning of each column from a menu, or drag the column lines on the page view, and the table updates immediately.
Is my statement uploaded?
No. Columnry runs in your browser. The converter page is not allowed to send data anywhere, and it keeps working offline.
What does it cost?
Previewing the whole statement is free, and you can export the first page (up to 20 rows). A 30-day pass costs $9 and a lifetime key costs $29, paid once.
Does it work with my bank?
It works with most text-based PDF statements, whatever the bank, because it reads the layout rather than using a fixed list of banks. Try your file with the free preview first.