CSV to QBO file requirements
A bank CSV is only a table, while a QBO file needs dates, signed transaction values, and an account-oriented structure. Prepare a clean source, review every row, and treat the generated QBO as a local beta candidate—not a guaranteed import.
Updated July 25, 2026 · Examples use fictional data.
| Item | Current BankFileKit behavior |
|---|---|
| Accepted source files | CSV, TXT, and XLSX. XLSX uses the first worksheet. |
| Source limits | One file at a time, up to 20 MB and 50,000 source rows. |
| Generated result | A candidate .qbo Web Connect file for US English and USD testing. |
| Not accepted here | PDF statements, QIF, IIF, QBW, QBX, images, bank logins, and complete company backups. |
| Field | What to provide | What the tool does |
|---|---|---|
| Date | A date consistent with the selected MM/DD/YYYY, DD/MM/YYYY, or YYYY-MM-DD convention. | Blocks an invalid row; a numeric date that could mean two conventions requires explicit confirmation before export. |
| Amount | One signed Amount column, or separate Credit and Debit columns. | Blocks a missing/invalid amount or a row with both Credit and Debit populated. |
| Description | Readable transaction text such as a merchant, payee, or memo. | Shows a warning when empty; review it before creating the QBO candidate. |
Common headers such as Posted Date, Transaction Date, Details, Memo, Deposit, and Withdrawal can mean the same fields. Confirm the meaning before export—do not rely on a column position or a bank-specific label alone.
Posting Date,Details,Deposit,Withdrawal 07/14/2026,Fictional Office Supply,,48.20 07/15/2026,Fictional Client Payment,425.00,
QuickBooks Online can use a formatted bank CSV, while a .qbo file is a Web Connect format commonly used in QuickBooks Desktop workflows. BankFileKit has a local CSV formatter for the former and an unverified CSV-to-QBO beta for the latter. Choose the target workflow before converting.
Download does not establish compatibility. Keep a backup, test only in a blank QuickBooks Desktop company, then compare dates, transaction count, amounts, and descriptions. If the target rejects the file, record only a generic error category and use a fictional reproduction.
The selected source is read, mapped, previewed, and exported in browser memory. BankFileKit does not upload the source file, the generated QBO, filenames, account details, or transaction data to its application server, analytics, or AI services.