PewterDesk

Bank statement converter

Convert bank CSV or Excel exports to QBO, QFX, OFX 1.x/2.x, QIF or a clean CSV. Dates, delimiters, columns and number formats are detected automatically, and you can check and edit every row before downloading. Everything runs on your device.

Drop your bank CSV or Excel (.xlsx) file here or click to choose a file. It is read by your browser and never uploaded.

How it works

  1. Drop your file. CSV, TSV, semicolon-separated or .xlsx. Text encoding (UTF-8 or Windows-1252), delimiter, header row, date order and decimal style are detected for you.
  2. Check the columns. Date, description and amount (or debit and credit) are mapped automatically, with optional balance, check number and memo. Change any of them in the dropdowns.
  3. Review. Edit dates, descriptions and amounts, untick rows you don't want, or flip all signs.
  4. Download the format your software imports.

Pick a format

  • QBO for QuickBooks Desktop and QuickBooks Online (Web Connect).
  • QFX for Quicken.
  • OFX for GnuCash, Xero, Moneydance and most other finance apps.
  • QIF for older software and Quicken QIF import.
  • Excel → QBO if your statement is an .xlsx workbook.

About INTU.BID and "unable to verify financial institution"

QBO and QFX files carry an Intuit bank identifier (INTU.BID, mirrored in <FID>). QuickBooks Desktop and Quicken check it against Intuit's directory of banks that support Web Connect downloads. If the ID is unknown or the bank has dropped Web Connect, the import fails with an "unable to verify the financial institution" style error.

Like other converters, we default to 3000, the Wells Fargo entry in that directory, which converters commonly use as a generic value. The only visible side effect is that the import dialog may show a Wells Fargo label; the transactions still go into whichever account you pick. If you know your own bank's Web Connect ID, enter it in the INTU.BID box instead. QuickBooks/Quicken remember the combination of bank ID and account number, so keep both the same each time you convert the same account.

FAQ

Is my bank file uploaded anywhere?

No. The page reads the file with your browser's built-in file APIs and builds the output on your device. There is no server-side code: you can open your browser's developer tools, watch the Network tab while converting, and see that no file data is sent. See the privacy page.

Is it free?

Yes for up to 10 transactions per file in every format, with full preview and editing. Pro removes the limit for $29 one-time. Try the free export in your software first. If a file you export with Pro won't import into the software you made it for, you get a full refund within 30 days of purchase. See the refund policy.

Will the file import into my QuickBooks or Quicken?

The output follows the standard Web Connect (QBO/QFX) and OFX formats and has been checked with independent OFX parsers (ofxtools and ofxparse). Import behaviour depends on your software version and account setup, so convert a statement with the free 10-transaction export and import that first. Buy Pro only once that works. If a file you export with Pro won't import into the software you made it for, you get a full refund within 30 days of purchase. See the refund policy.

Will re-importing the same statement create duplicates?

Each transaction gets a stable ID (FITID) computed from its date, amount, description and position among identical rows. Converting the same rows again gives the same IDs, and QuickBooks and Quicken use these IDs to recognise transactions they have already imported. Always review the import screen before accepting.

My dates or amounts look wrong. What do I do?

Check the "Date format in file" (US files use MM/DD, most others DD/MM), the decimal separator, and the column mapping. If money in and money out are reversed, tick "Flip sign". You can also edit or untick individual rows in the preview.

Which banks are supported?

Any bank that exports a CSV or .xlsx with a date, a description and either one amount column or separate debit/credit columns. Summary lines above the header row and total lines are skipped automatically. Old binary .xls files need to be re-saved as .xlsx or CSV first.