ColumnryCharges and payments
On a card statement a plain amount is usually a charge, and payments or refunds are shown with a minus sign or CR. Columnry follows that rule automatically, and you can flip the signs with one setting if your issuer does it the other way.
Dates without a year
Many card statements print only the day and month, such as “Mar 05” or “05/03”. Columnry takes the year from the statement date and handles statements that cross New Year.
Pending and foreign-currency lines
Lines such as exchange-rate notes are kept with the transaction they belong to, so the description stays complete.
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
Can I import the result into a budgeting app?
Many budgeting and accounting apps import CSV, OFX or QIF. Check which format your app accepts.
What about several cards on one statement?
All transaction rows are read. Use the review grid to untick the lines you don't want.
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.