XLS to QFX conversion turns an Excel sheet of transactions into a Quicken Web Connect file. You trim the sheet to one header row and a date, payee and signed amount per line, run it through a converter, and supply the bank and account details the spreadsheet never held. Then test the QFX in a spare Quicken account.
Can Quicken read an XLS spreadsheet without a QFX conversion?
Quicken's bank import is built around downloaded statement files, not workbooks, so an XLS sheet usually needs a QFX conversion first. If your edition of Quicken offers its own spreadsheet import, try that before converting. Otherwise, a QFX file is the format Quicken treats like a download from your bank.
People end up with transactions in Excel for ordinary reasons. A bank only offers a spreadsheet export. An accountant sent a cleaned-up list. Someone typed a year of cash spending into a workbook. In each case the data is fine, but it is in the wrong container.
A QFX file is a text file in the OFX family with Intuit's own additions. It describes one account, names the institution it came from and lists transactions inside tags. Quicken reads it through Web Connect, the same route a bank download takes. That is why a converted file has to look like a bank download in every way that Quicken checks.
What the conversion cannot add
A spreadsheet has no history of what Quicken has already seen. The converter writes transaction IDs, but they will not match IDs from earlier bank downloads. Keep the converted dates clear of any period the account has already downloaded, or you will clean up duplicates afterwards.
Laying out the Excel sheet for an XLS to QFX conversion
Lay out the Excel sheet as one header row followed by one row per transaction, with columns for date, payee or description, and a single signed amount. Remove totals, blank rows, merged cells and notes. Most converters read the first sheet only, so put the data there and nothing else.
The example below shows a sheet that is ready to convert. The values are made up.
| Date | Payee | Memo | Amount | Check number |
|---|---|---|---|---|
| 2026-02-03 | Harbor Paint Supply | Primer, 2 gallons | -64.18 | |
| 2026-02-05 | Client deposit | Invoice 118 | 1,250.00 | |
| 2026-02-09 | R. Delgado | Fence repair | -400.00 | 3071 |
| 2026-02-12 | Monthly service fee | -12.00 |
A few rules make the converter's job easy:
- One amount column. If the bank gave you separate withdrawal and deposit columns, add a new column that subtracts one from the other, then paste it as values. Money out should be negative.
- Real dates. The date column should hold Excel dates, not text that looks like a date. Select the column and check the format box. If it says General or Text, fix it first.
- Short payees. Long descriptions are fine, but the payee field in a QFX file has a length limit in many readers. Put long detail in a memo column.
- No running balance. A balance column does not hurt, but most converters ignore it. Remove it if the converter asks you to map every column.
The step list, from workbook to imported file
- Copy the transactions to a new workbook, so the original stays untouched.
- Delete everything above the header row and below the last transaction.
- Make one signed amount column, and format dates as dates.
- Save as .xlsx, or as CSV if the converter only reads text files.
- Open the converter, load the file and map each column to a QFX field.
- Enter the account details from the next section.
- Convert, then open the QFX in a text editor and check three transactions.
- Import into a spare Quicken account, compare totals, and only then import for real.
Account details the QFX file needs from outside the spreadsheet
A QFX file needs an institution block, an account number, an account type, a currency and a date range, and none of these live in the spreadsheet rows. The converter either asks you for them or fills in defaults. Quicken checks the institution values before it reads a single transaction.
Here are the details, with example values:
| QFX detail | What it is | Example value |
|---|---|---|
| ORG and FID | The institution's name and numeric ID | Example Bank, 12345 |
| INTU.BID | Intuit's bank ID for the institution | 12345 |
| BANKID | The routing number for a bank account | 000000000 |
| ACCTID | The account number | 9876543210 |
| ACCTTYPE | The kind of account | CHECKING |
| CURDEF | The currency | USD |
| DTSTART and DTEND | The first and last date covered | 20260201 and 20260228 |
The institution values are where most home-made files fail. Quicken looks at them to decide which bank the file came from. A value it does not recognize can lead to a refusal or to a prompt that asks which account to use.
The surest source is a real QFX download from the same bank, even for a few days. Open it in a text editor and copy the institution lines across. If the bank no longer offers QFX, choose a converter that lets you type these values, and test the result in a spare account.
The account number deserves care too. Quicken uses it, along with the institution, to link the file to one account. If you later download a real file from the bank for the same account, matching numbers keep both files pointed at the same register.
Which Excel cell formats break the QFX output?
Excel cell formats break the QFX output when dates are stored as text, amounts carry currency symbols or brackets, or numbers use a thousands separator the converter reads as a decimal point. The QFX file then gets wrong dates, missing lines or amounts off by a factor of a thousand.
Check these formats before you convert:
- Text dates. A date typed as
02/09/26with a leading apostrophe is text. The converter has to guess its order. Convert the column to real dates with Excel's Text to Columns tool, choosing the order your data uses. - Day-first dates. A sheet from a non-US source may be day first. 03/02/2026 then means 3 February, not March 2. Find a date with a day above 12 to settle it.
- Brackets for negatives. An accounting format shows
(64.18)for a withdrawal. Some converters read the brackets, others drop the line. Change the format to a plain number with a minus sign. - Currency symbols. A
$in the cell value, as opposed to in the display format, makes the cell text. Remove it. - Thousands separators.
1,250.00is fine in US settings. A sheet using a comma for the decimal point, as in1.250,00, needs to be converted to the US style first. - Formulas. A formula that refers to another sheet may show an error once the data is copied. Paste the whole table as values before you save.
After converting, open the QFX file in a text editor and find the DTPOSTED and TRNAMT lines for three transactions you know. A date of 20260209 and an amount of -400.00 for the fence repair above would confirm the format survived.
Importing the new QFX into a spare Quicken account first
Import the new QFX into a spare Quicken account first, so a mistake costs nothing. Create a test account, import, and compare the number of transactions and the total with the spreadsheet. If both match, delete the test account and import the same file into the real one.
Some Quicken versions let you choose an existing account during a Web Connect import, and others link the file by its account number. If Quicken offers to link to your real account during the test, choose to create a new account or cancel and use a copy of your data file instead.
What to compare after the test import:
- The number of new transactions equals the number of rows in the sheet.
- The sum of imported amounts equals the sum of the amount column.
- Three spot-checked lines have the right date, payee and sign.
- Check numbers appear on the rows that had one.
If the count is short, look for blank or text cells in the date or amount column. If every sign is reversed, the converter has a setting for which direction is money out. Fix the sheet or the setting and convert again rather than editing the imported register by hand.
Excel sheets that should become OFX or QBO instead of QFX
An Excel sheet should become OFX or QBO instead of QFX when the destination is not Quicken. QFX is Quicken's flavor. A budgeting app usually wants plain OFX, and QuickBooks Desktop wants a QBO file. Choosing the right target first saves a second conversion later.
Here is how to pick:
- A budgeting or personal finance app. Use OFX. The steps are the same, minus the Intuit-specific lines. The Excel to OFX converter guide walks through them.
- QuickBooks Desktop. Use QBO. If you already made a QFX, it is close to a QBO file, and converting QFX to QBO explains the small change needed.
- QuickBooks Online. A CSV upload is often simplest, because the online upload accepts it. A QBO file also works.
- A business bank file. If your Excel sheet was itself made from a bank's MT940 statement file, converting the MT940 directly can be cleaner. See what an MT940 file is and how to convert it to OFX.
Loan schedules are another case where QFX is the wrong target. A spreadsheet of loan payments split into principal and interest does not fit a bank statement format, which holds one amount per line. If the loan belongs in QuickBooks, connecting a loan account to QuickBooks Online shows the account setup instead.
If your Excel sheet started life as a PDF statement that you retyped, the retyping may be the step to drop. SimpleBankConvert, now in early access, is being built to turn PDF bank statements into CSV or QBO files for QuickBooks. It does not make QFX files for Quicken. The SimpleBankConvert homepage lists what it does.