Bank files · Runs in your browser
Convert a bank CSV to QBO without uploading it.
Turn the CSV your bank gave you into a QBO (Web Connect) file for QuickBooks. You choose the columns, the date order and the institution fields. The statement is read on this device and never uploaded.
How to convert your CSV
- Choose the CSV your bank gave you, or paste its text. A header block above the real column names, which many banks add, is detected and skipped.
- Check the column choices. They are filled in from the header names, and you can change any of them. Use “Separate Debit and Credit columns” when the file has both; use one Amount column when negative numbers mean money out.
- Pick the date order. If your file has a date with a first or second number above 12, the page works the order out and tells you so. If every date is ambiguous, it refuses to continue until you choose.
- Enter the institution name, FID, bank ID (routing or transit number) and account number. Press Convert to QBO, look at the preview, and download the file.
What is inside a QBO file: a worked example
A QBO file is an Open Financial Exchange file written in the older SGML dialect, version 1.x, with a few Intuit additions. It starts with a plain-text header (OFXHEADER:100, DATA:OFXSGML, VERSION:102 and some related lines), then an <OFX> element holding a sign-on section and one statement. Each transaction has a type, a posting date, a signed amount, a unique ID (FITID), a name and an optional memo. In SGML, a value element has no closing tag, which is why a QBO opened in a spreadsheet looks like nonsense. Here is an excerpt of what this page writes for a three-row sample (the account number, bank ID and institution are made up):
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<DTSERVER>20240229120000[0:GMT]
<LANGUAGE>ENG
<FI>
<ORG>Example Credit Union
<FID>12345
</FI>
<INTU.BID>12345
...
<BANKTRANLIST>
<DTSTART>20240304120000
<DTEND>20240305120000
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20240304120000
<TRNAMT>-4.50
<FITID>20240304M450HYU3X8Z52EV
<NAME>Corner Cafe
</STMTTRN>
<STMTTRN>
<TRNTYPE>CREDIT
<DTPOSTED>20240305120000
<TRNAMT>2500.00
...
The CSV behind that sample was:
Date,Description,Debit,Credit
03/04/2024,Corner Cafe,4.50,
03/05/2024,ACME Payroll,,2500.00
03/05/2024,Corner Cafe,4.50,
The part you have to supply: ORG and FID
Intuit’s products use the institution block to decide which bank a file belongs to. This tool cannot know your bank’s identifiers, and it does not invent them. If you can download any QBO or QFX file from your bank, open it in a text editor and copy the <ORG> and <FID> values. Be clear about the risk: converter vendors report that QuickBooks Desktop validates the FID and rejects files from institutions that are not in Intuit’s list, and we found no Intuit document that says otherwise. If QuickBooks refuses the file, the options are to use a CSV upload in QuickBooks Online, to use your bank’s own QBO export, or to use a vendor that is on Intuit’s list. This page does not claim bank or Intuit certification and cannot get around that check.
FITIDs: stable, unique, and why it matters
The FITID is how an importer avoids creating duplicates when you load an overlapping date range. This tool builds each one from the posting date, the signed amount, the description, the memo, the check number and your account number, passed through a small hash. The same row always produces the same FITID, so converting the file again, or an overlapping month, lets the importer recognise what it has already seen. When two rows are identical in every one of those fields, the second gets an “N2” marker so it is not mistaken for a duplicate and discarded. If your CSV has its own transaction ID column, map it and that value is used instead; if it repeats, the later copies get a numeric suffix and you are warned.
Common mistakes
- Wrong sign. Some credit cards list purchases as positive. Pick the matching amount layout, then check the net figure in the status line against your statement.
- Day and month swapped. The most dangerous one, because the file still looks valid. Compare the first and last dates in the status line with your statement period.
- Totals row left in. A “Totals” line has no date and is listed as an error. Tick the skip option to drop such rows.
- Payee names over 32 characters. OFX limits NAME to 32 characters. Longer descriptions are cut in NAME and the full text goes to MEMO.
- No closing balance. The OFX definition requires a ledger balance, so without one the file carries 0.00 and the page warns you. Enter the balance if you want the file to carry it.
What this tool does not do
- It does not log in to a bank or fetch anything, and it cannot verify that your FID is valid.
- It does not convert PDF statements. It needs a CSV.
- It writes bank and credit card statements only, not investment accounts.
- Non-Latin characters cannot be stored in an OFX 1.x file, which uses Windows-1252. They become a question mark and you are told how many.
What happens to your statement
The conversion is done by JavaScript running inside this page’s tool frame. The frame is sandboxed and its content security policy forbids network requests, so even a bug in the code could not send your file anywhere. The page that holds the advertising is a separate document and cannot read the frame. The file is read with the browser’s own file reader, the result is built in memory, and the download link points at a temporary address that exists only in your tab. Close the tab and it is gone. You can confirm it yourself: open your browser’s network panel, convert a file, and watch for requests. There are none.
Related: see the CSV to OFX converter for non-QuickBooks software, the OFX and QBO validator to check the result, and the bank statement CSV cleaner if QuickBooks Online will take a CSV directly.
Frequently asked questions
How do I convert a CSV to QBO?
Load the CSV, confirm which column is the date, description and amount (or debit and credit), choose the date order, enter your institution name, FID, bank ID and account number, then press Convert to QBO. The page writes an OFX 1.x file with Intuit’s institution block and offers it as a .qbo download. All of it happens in your browser.
Will QuickBooks accept the file?
We cannot promise it. A QBO file carries an institution block (ORG and FID), and converter vendors report that QuickBooks Desktop checks the FID and refuses files from institutions it does not recognise. We found no Intuit page that documents that check, so treat it as reported behaviour. This page is not certified or endorsed by Intuit or any bank.
Where do I get the FID and ORG?
The dependable source is a real QBO or QFX file downloaded from your own bank: open it in a text editor and copy the ORG and FID lines from the FI block. If your bank offers no such file, QuickBooks Online lets you upload a CSV directly, which avoids the institution fields altogether.
Can QuickBooks Online import my CSV without converting it?
Often yes. Intuit documents a 3-column layout (Date, Description, Amount) and a 4-column layout (Date, Description, Credit, Debit). The bank statement CSV cleaner on this site reshapes a bank export into either layout. Convert to QBO when the CSV is rejected or when you use QuickBooks Desktop.
What is a FITID and why does this page generate one?
FITID is the financial institution transaction ID. Importers use it to skip transactions they already hold. This page builds it from the date, amount, description and your account number, so the same transaction always gets the same ID. Two identical purchases on one day get different IDs, so neither is dropped as a duplicate.
Why did the date come out wrong?
A date such as 03/04/2024 is 4 March in the United States and 3 April in most other countries. The page will not guess: if every date in the file is ambiguous it asks you to choose the order. If you choose the wrong one, rows that cannot exist (month 13) are listed as errors, but valid-looking dates will silently be read the wrong way.
Does the file contain my account number?
Yes. A QBO file has to name the account, so the number you type is written into it, along with every transaction. The file is created on your device and is never sent to us. Treat the downloaded file like the statement it came from.
Does it handle credit card CSVs?
Yes. Choose Credit card as the account type, and if your card issuer shows purchases as positive numbers, pick “positive = money out” for the amount layout. The page then writes a credit card statement (CCSTMTRS) without a bank ID or account kind.
Sources
Checked
- Intuit: Format CSV files in Excel to get bank transactions into QuickBooks — the 3-column and 4-column CSV layouts, one date format, no zeroes, and the advice to try a QFX, QBO or OFX file if a CSV will not import (retrieved 2026-10)
- Intuit Community: trouble importing bank statements in QuickBooks Online — an Intuit reply that CSV imports are sensitive to extra rows and non-transaction text, and the Upload from file path (retrieved 2026-10)
- MoneyThumb: QIF2QBO help, FID and importing .qbo files (a converter vendor, not Intuit) — reports that QuickBooks validates the FID over the internet when reading a .qbo file, and that a bank missing from its list is unsupported (retrieved 2026-10)
- Dancing Numbers: QuickBooks is unable to verify the financial institution (a vendor, not Intuit) — the ORG, FID and INTU.BID tags a QBO needs, and that payee names must stay under 32 characters (retrieved 2026-10)
- Open Financial Exchange (Wikipedia) — OFX 1.0 dates from 1997; versions 1.0 to 1.6 are SGML, later versions XML; QFX is Intuit’s variant for Quicken (retrieved 2026-10)
- ofxtools statement model (open-source OFX library) — transaction types, account types and field lengths (NAME 32, MEMO 255, FITID 255, ACCTID 22, BANKID 9, CHECKNUM 12) as implemented from the OFX specification sections 11.3 and 11.4 (retrieved 2026-10)
- ofxtools sign-on model (open-source OFX library) — the FI block: ORG up to 32 characters, FID up to 32 (retrieved 2026-10)
- RFC 4180, Common Format and MIME Type for CSV Files — quoted fields, doubled quotes and line breaks inside fields, which the CSV reader here follows (retrieved 2026-10)
Runs entirely in your browser. Nothing you load or type is sent or stored. This page is not affiliated with Intuit, Quicken, any bank or the OFX standards body.
Common mix-ups
-
Often assumedA FITID is unique across all banks, so a QBO file can reuse any number.
What the source saysThe OFX 2.2 specification says FITIDs must be unique within the scope of an account, need not be sequential, and are not unique across financial institutions. A client that mixes institutions needs the institution, account ID and FITID together. [1]
Checked against these sources on .