QuickBooks Desktop batch import cluster

Convert QBO to IIF for QuickBooks Desktop batch import

Turn a .qbo Web Connect file into a validated .iif with the exact !TRNS / !SPL / !ENDTRNS header structure QuickBooks Desktop expects — no manual retyping.

Step 1

Upload your .qbo file.

Step 2

(Optional) Map QBO categories to your QuickBooks Desktop chart of accounts.

Step 3

Download the .iif and import via File → Utilities → Import → IIF Files.

About QBOIIF

IIF gives QuickBooks Desktop batch-import power that QBO doesn't — splits, journal entries, chart-of-accounts mappings. Our converter parses the QBO, maps categories to your CoA (optional), and emits a strict IIF that QuickBooks Desktop imports without header validation errors.

Try it now — mapping wizard

Upload a small QBO sample and walk through column mapping, validation and preview before downloading — everything runs locally in your browser.

Mapping wizard
Preview, map columns, validate, then download.

All parsing runs in your browser. Nothing is uploaded.

Need a different output format?

Every QBO conversion can also be exported directly to CSV, Excel (.xlsx), QuickBooks (.qbo) or OFX from the upload screen.

Why bookkeepers pick BankToBooks

  • Every transaction validated — dates, amounts, running balance reconciled before export.
  • Zero setup: no templates, no bank IDs, no fees — upload QBO, download IIF.
  • OCR handles scanned inputs when the source is a PDF, not just structured files.
  • Free tier: 3 conversions per day, 200 transactions per file. Paid plans: unlimited.

FAQs

Will this work with QuickBooks Online?

No — IIF is QuickBooks Desktop only.

Can I include splits?

Yes — GST/VAT lines can be auto-split into multi-line !SPL records.

What if my chart of accounts changes?

Re-run the export; category mapping uses the latest snapshot.

Related conversions

Explore by country & tool

Try QBOIIF free — no signup

3 conversions/day, up to 200 transactions each.

Upload your first file