Each supported transaction becomes one row with five fields: Date, Description, Debit, Credit and Balance. Amounts are exported as numeric values, blank debit or credit cells stay blank, and the file opens as a normal UTF-8 CSV.
Use CSV when you need portable transaction rows
CSV is useful when the next step is spreadsheet cleanup, reconciliation, your own formulas, or an import workflow that accepts tabular data. BankStatementMate does not claim that one generic CSV automatically matches every accounting product. Check the destination's required headers, date format and debit/credit convention before importing.
The converter first shows the extracted rows in the browser. That preview matters: a tidy CSV can still contain an OCR or layout error, so the source statement remains the reference.
How to convert a bank statement PDF to CSV
- Choose the statement. Use a PDF, PNG or JPG up to 10 MB. PDFs are limited to five pages per file.
- Select CSV. Choose CSV in the download-format control before or after conversion.
- Convert locally. Digital PDFs use local text extraction; supported scans and images use on-device OCR.
- Review the preview. Compare transaction count, first and last rows, debit/credit direction and balances against the original.
- Download CSV. Save the reviewed rows and keep the source statement for comparison.
For PDF bank statement to CSV conversion, start with the transaction pages rather than a summary-only page. Digital text extraction and OCR can produce different recognition issues, so compare each extracted row with the actual PDF before downloading. The PDF transaction extraction walkthrough explains how to check row completeness.
A simple verification check before you use the CSV
Start with the fictional sample if you want to see a known result before using a personal document. A correct sample conversion shows three transactions and ends at a balance of 2,295.50. For your own file, check the first and last transaction on each page, confirm money out is in Debit and money in is in Credit, and investigate any running-balance warning rather than editing values until the arithmetic looks right.
CSV is a plain tabular export: it has no workbook styling, worksheets or Excel number-format settings. When opening it in another application, inspect how that application interprets dates and decimal amounts. It is not guaranteed ready for every accounting system. Preserve the original download before changing headers or mapping columns for an import.
Current support and limits
- Input: PDF, PNG and JPG; maximum 10 MB per file.
- PDFs: maximum five pages in the current browser workflow.
- Best fit: clear English transaction tables with separate Date, Description, Debit, Credit and Balance headings.
- Scans: supported through local OCR when text and columns are clear enough to recognize.
- Unsupported or ambiguous layouts may stop instead of returning a knowingly incomplete file.
- BankStatementMate currently exports Excel and CSV; it does not generate QBO or OFX files.
Need an XLSX workbook from an image instead? Follow scanned bank statement to Excel. Use the fictional output example to compare the five fields.
How to open bank statement CSV in Google Sheets
After reviewing and downloading your CSV, open Google Sheets on a computer and use File → Import → Upload. Choose the CSV, import location and comma separator, then import the data. Check all five columns, transaction counts, dates and amounts. This is a manual upload to Google, not an automatic connection from BankStatementMate. Follow the Google Sheets import guide for cell checks and the privacy boundary.
Need a JSON schema for a developer workflow? Compare bank statement PDF-to-JSON parsing tools and validation steps. These are independent third-party options; BankStatementMate currently exports Excel and CSV, not JSON.
Preparing a manual Xero import? Follow the Xero CSV date and amount format guide to resolve ambiguous dates, turn reviewed Debit/Credit values into a signed Amount column and check a fictional example. This is a separate preparation step after export; BankStatementMate does not connect to Xero.
Preparing CSV for QuickBooks Online
QuickBooks Online accepts three- or four-column CSV layouts. Review the working copy, date interpretation and money direction before importing. Our QuickBooks CSV import troubleshooting guide includes a fictional example and checks for overlapping transactions. This is a manual preparation workflow, not a direct connection or a verified import preset.