How the QuickBooks import works

QuickBooks Desktop

1. Convert your statement and choose QuickBooks Web Connect (.qbo).
2. Pick the account type (Checking, Savings or Credit Card), your bank, and optionally the last 4 of the account number.
3. In QuickBooks: File → Utilities → Import → Web Connect Files.
4. QuickBooks asks which account to import into — pick the one matching the account type you chose. Transactions land in the bank feed for review.

QuickBooks Online

Online accepts manual uploads of .qbo, .qfx, .ofx and CSV files — Intuit's own help suggests the .qbo format. Transactions → Bank transactions → Upload from file, choose the .qbo, pick the account. Intuit's limit is 1,000 transactions and 350 KB per upload, so upload long catch-up batches one month at a time; stable transaction IDs mean a re-upload never duplicates. Prefer to map columns yourself? Use the CSV and map Date, Description and Amount.

Quicken, Xero and everything else

The same builder writes a .qfx for Quicken (the Web Connect file Quicken looks for) and a plain .ofx with no Intuit tags for Xero, Wave, Sage, Moneydance, GnuCash and other importers. Transaction IDs and balances are identical across the three. Xero also takes the Xero bank-import CSV, in Xero's own template columns; Quicken also takes QIF.

Why our .qbo imports when others don't

• "Unable to verify the financial institution" — happens when the file's institution ID (INTU.BID) isn't in QuickBooks' Web Connect directory. We use Intuit's own directory of ~6,400 institutions, and a documented generic fallback when your bank isn't in it.
• Account-type mismatch — a credit-card file uses a different message block than a bank file. We build the block from the account type you pick and tell you to select the matching account in QuickBooks.
• Double imports — every transaction carries a FITID that's a stable hash of its content. Re-export the same statement next month and QuickBooks deduplicates instead of double-importing.
• Ledger balance — the file carries the statement's printed closing balance and end date, so the bank feed balance matches the paper.
• Balance proof first — we don't hand you a .qbo until you've seen whether opening + credits − debits equals the printed closing balance.