CSVQBO / Practical guide

Convert CSV to a QBO Web Connect file

Normalize bank transactions, enter real account identifiers and review the QBO before a Desktop import.

Identify the bank and account

Obtain your bank ID, account ID, financial institution FID, organization and authorized Intuit BID. These are different identifiers; an ABA routing number is not automatically an Intuit BID. Do not borrow another bank’s BID. Enter the currency and checking, savings or credit-card type.

Normalize the transaction table

Upload CSV or a one-sheet XLSX. Automatic headers cover Date, Posted Date, Description, Details, Amount, Debit/Credit and Paid out/in. Enter an exact header override when your export uses another name. Signed amounts are preserved; split columns use credit minus debit. Select reverse signs only after checking your original statement.

Read the preview and validation report

A synthetic three-row source contains a 2500.00 deposit, a -125.50 payment and an identical payment row. With exact-row deduplication selected, two transactions remain. This may be correct for a repeated export row; it would be wrong for two genuine identical payments. Keep repeated rows when they represent real activity.

Export and import carefully

Enter the actual closing ledger balance at the last exported date. A trial of a longer file also needs the balance at the latest included trial date. Download QBO and use your Desktop product’s Web Connect import for the target account, after backing up. Structurally generated OFX is not Intuit certification; an unsupported bank, expired software or regional restriction may reject it.

Try a real free conversion See one-time packs

Written by Zijian Xiao. Examples are synthetic. Review all extracted results against your original source file.