How does local PDF parsing and running-balance verification work?
The converter reads embedded text lines directly from your PDF with pdf.js, detects transaction dates at the start of each line (YYYY-MM-DD, DD/MM/YYYY, MM/DD/YYYY, or month-name formats), and aligns money-out, money-in, and balance columns from headers or coordinate geometry. Every row’s running balance is then checked mathematically against the printed balance on the statement.
If your bank PDF is encrypted with an owner or user password, you can remove a PDF password before batch conversion or enter the password when prompted during loading.
Detecting date prefixes, column alignment, and currency formats
Positioned text lines are parsed in a Web Worker using src/lib/business/bank-statement.ts. The money parser recognizes leading or trailing minus signs, parentheses for debits ((45.00)), and both period and comma decimal separators (1,234.56 or 1.234,56).
Exported spreadsheets conform to IETF RFC 4180 CSV Format Specification quoting rules so merchant descriptions containing commas never shift columns.
Reading scanned statements with on-device OCR and unlocking PDFs
When a PDF page has no selectable text layer, the loader switches automatically to local OCR (piecesOrOcr) and marks affected pages in the status banner. If no text can be extracted even after OCR, the tool prompts you to try a clearer scan or download the native PDF from online banking.
Comparing Excel, CSV, QuickBooks, Xero, and OFX export formats
Selecting the right Save as radio option depends on your workflow: auditing expenses in a spreadsheet or importing a bank feed into accounting software. Each option formats dates, signs, and headers for its target destination as described in the Xero Central Bank Statement Import Specification.
When your goal is specifically QuickBooks Desktop Web Connect (.qbo), you can also start directly in the dedicated QBO Web Connect converter with INTU.BID preselected.
| Save as format | File extension | Signed vs split amounts | Best target workflow | Key constraint |
|---|---|---|---|---|
| Excel | .xlsx |
Separate Money out and Money in | Financial audits and pivot tables | Built locally via xlsx worker |
| CSV | .csv |
Separate Money out and Money in | Universal spreadsheet import | UTF-8 comma-delimited |
| CSV for QuickBooks | .csv |
Accounting-ready columns | QuickBooks Online manual upload | Strip currency symbols |
| CSV for Xero | .csv |
Signed amount layout | Xero Import a Statement | Consistent date order |
| OFX | .ofx |
Signed <TRNAMT> tags |
Xero, QBO, Quicken, Sage | ASCII charset 1252 |
| QBO | .qbo |
Signed <TRNAMT> + INTU.BID |
QuickBooks Desktop Web Connect | Requires Intuit bank ID |
Fixing date ambiguity, credit card signs, and column mismatches
Banks across the US, UK, Canada, Australia, and Europe print numeric dates differently, and credit card PDFs often invert debit and credit signs. Checking the Summary panel and highlighted preview rows catches these layout quirks before importing into your ledger.
Resolving DD/MM vs MM/DD date order across international banks
By default, Dates in the statement is set to Work it out, which inspects all numeric dates across the PDF to infer whether day or month comes first. If every date in a short statement is 12 or below (such as 03/04/2026), switch manually between Day first (25/03) and Month first (03/25).
Swapping money in and out for credit card statements
Credit card statements frequently list purchases as positive numbers and repayments as credits. Ticking Swap money in and out flips those columns live across the preview table and recalculates Money in and Money out totals immediately.
When exporting to OFX or QBO under the Open Financial Exchange 1.0.2 Technical Specification, you can also switch Account to Credit card (CREDITCARD) and select from 10 supported currencies (USD, GBP, EUR, CAD, AUD, NZD, CHF, SEK, NOK, DKK). If you already have a bank CSV file, use turn cleaned bank CSV downloads into OFX files to skip PDF parsing.
Multi-month batches, record retention, and client-side privacy
Bookkeepers preparing quarterly or annual tax filings often need to combine twelve monthly PDFs into a single ledger file. Dropping multiple PDFs or bank CSVs (up to 15 MB each) merges every transaction sequentially into one download.
Combining multiple statement PDFs and 15 MB bank CSVs
The preview table renders up to 300 rows on screen so your browser stays responsive on large batches, while Convert <N> transactions writes the full dataset to disk. Transactions without a readable date are excluded from OFX/QBO exports and reported in the status note.
For European corporate accounts using structured bank files instead of PDFs, try MT940 to CSV & Excel to extract SWIFT :61: and :86: narratives directly.
Tip: Drop twelve monthly PDFs together in one batch to verify opening and closing totals across the year before exporting a single
.xlsxworkbook for your accountant.
Zero-upload browser processing and accounting retention scope
Because parsing, OCR, and workbook generation run inside your browser tab, account numbers and balances never touch an external server. Store your original PDFs and reconciled exports according to statutory timelines such as the IRS Business Record Retention Guidelines (3 to 7 years depending on filing type).
This converter prepares transaction data for operational bookkeeping convenience and does not replace certified accounting review or audit verification. Always reconcile ending balances against your bank’s official statement before filing tax returns.