Skip to content
LedgerLocal

CSV to QFX Converter — QuickBooks Desktop Import

Turn a CSV, XLS, or XLSX export from your bank or credit card into a .qfx file that QuickBooks Desktop can import through Bank Feeds — all on your own computer.

Runs in your browser — your file never leaves your computer

  1. 1Load
  2. 2Map
  3. 3Review
  4. 4Download
Load a file
Read in your browser — nothing is uploaded.

Drop a bank or credit card export

CSV, XLS, or XLSX from your bank or credit card

What this tool accepts
A spreadsheet export from your bank or credit card, turned into a Web Connect file for the Bank Feeds center.

Files

CSV, XLS, or XLSX from your bank or credit card

Columns

  • Date — required — any common date shape
  • Description — required — payee or memo
  • Amount — required — signed in/out, or use Debit + Credit columns

Output

.qfx · OFX 1.0.3 with one transaction per row and CRLF line endings.

Then import in QuickBooks Desktop: Banking → Bank Feeds → Import Web Connect (.qfx/.qbo) file

How to use this file in QuickBooks Desktop

Work on a backup. Run File → Back Up Company first; imports are easiest to undo on a copy of the company file.

  1. In QuickBooks Desktop, open the Banking menu and choose Bank Feeds → Import Web Connect (.qfx/.qbo) file.
  2. Select the .qfx file you downloaded from this tool.
  3. Choose the bank or credit card account the transactions belong to, or let QuickBooks match it, and set the account type when prompted.
  4. Review the imported transactions in the Bank Feeds window and match them against the records already in QuickBooks.
  5. Reconcile the account to confirm the ending balance agrees with your statement.

Import path: Banking → Bank Feeds → Import Web Connect (.qfx/.qbo) file

Frequently asked questions

Related tools