Bank statements to Excel for accountants
Turn client statement PDFs into a worksheet you can check, correct and use. Review transactions in your browser, then export Excel, CSV or a compatible accounting format.
Start with one client and one account
For monthly bookkeeping, gather the original PDF statements for the account and period you are reviewing. Keep different clients, bank accounts and currencies in separate conversion batches. You can select up to 10 PDFs at a time, but batch results are combined into one table. Try a representative statement before processing a larger set.
Get the dates and money columns right
Set the date order to match the statement and supply the year if transaction rows omit it. After extraction, compare dates, descriptions, debits, credits and balances with the PDF. The table lets you correct values and categories before downloading. Check opening and closing balances, repeated transactions, and descriptions that wrap across lines; highlighted rows are a starting point for review, not a complete accuracy check.
Choose the file your next step needs
Use Excel for a readable worksheet with numeric amounts, or CSV when another system needs a plain transaction table. Categorised Excel includes your editable categories and a category summary. Xero CSV uses signed amounts and its own column layout. QBO and QFX require the correct institution and account details, and import compatibility depends on the receiving software. Review a test import before using the output in a client ledger.
Keep source documents alongside the result
During browser conversion, the PDF, extracted transaction rows and generated exports stay on your device. Keep the original statement and checked export in your own client filing system. This workspace prepares transaction data; it does not perform your reconciliation or certify that a ledger is complete.
Working with Malaysian bank statements
Selected text-based Maybank and CIMB statement layouts have dedicated parsers, including MYR detection and handling for supported signed-amount layouts. Other layouts use generic extraction. Check day-first dates where applicable, confirm MYR in export settings and review every amount. Scanned statements use English-language OCR, so clear scans and close checking are especially useful.
Can I try a client statement before subscribing?
Yes. One anonymous conversion is available every 24 hours, and a free account includes 2 pages per day. You can also try the fictional sample without selecting a PDF. No card is needed for the free option.
Can a whole team share one workspace?
The current service is built around individual accounts. It does not provide shared client folders, team roles or an approval workflow. Contact us if your firm needs those capabilities.
Does it connect directly to my accounting system?
The browser workflow produces downloadable files. It does not connect to your bank or post transactions directly to your accounting system. Check the receiving software’s import requirements and preview the file there.
What happens if a statement layout is different?
Extraction may need correction, and a bank listed in the directory does not guarantee every layout. Compare the output with the source, edit the review table and export only when you are satisfied with it. You can contact support for help with an unfamiliar layout.