Help Center / QuickBooks Import

QuickBooks Desktop Import

Import your complete QuickBooks history - chart of accounts, customers, vendors, invoices, bills, and payments.

⚠️ Important fix in v1.1.122 (May 2026) - re-import recommended:

QuickBooks Online's Excel "Journal" report writes dollar amounts with thousands-separator commas (6,718.82, 12,500.00, 1,234,567.89). Earlier BizBooks Pro builds were using JavaScript's built-in number conversion to read those cells, which stops at the first comma. The result: any amount of $1,000 or higher was being silently truncated to its leading digits - 6,718.82 imported as $6, 12,500.00 imported as $12. Smaller amounts (no commas) imported correctly. If you ran a QuickBooks import before v1.1.122, account balances are likely significantly off. Update to v1.1.122, delete the affected company, and re-import the same files. The corrected parser sanitizes commas, dollar signs, and accounting-style negative parentheses across every import path before parsing.

Recent improvements (v1.1.122, May 2026):
  • Real-time progress indicator on Phase 3 imports. Long QuickBooks histories (tens of thousands of journal entries) previously gave no feedback during import. The new overlay displays a percentage bar, transactions processed/remaining, and a stage label, refreshing every 25 transactions or 250 milliseconds via the persistent socket connection.
  • Create a new chart account directly inside Resolve Import Suspense. Previously the resolution dropdown only listed your existing accounts; if a suspense entry had no obvious destination you had to leave for Chart of Accounts and come back. The dropdown now includes a + Create new account... option that spawns an inline form (Number, Name, Type) right inside the row. Defaults are inferred from the suspense original name - leading account numbers detected and split out, account type heuristically guessed from keywords (Income for sales/revenue, Bank for checking/savings, etc.).
  • Empty-chart option for new companies. Choose "None - I'll import my own accounts" at company creation to skip default-chart generation - ideal when migrating an existing QuickBooks chart in via Phase 1.
  • Skip Phase 2 default migration date corrected. The default has been changed from today's date to 1900-01-01, so a full-history Phase 3 import now imports every historical row without manually adjusting the cutoff.
Earlier improvements (v1.1.115):
  • "Resolve Import Suspense" cleanup tool repoints every parked entry to a real account in one pass. See Troubleshooting below for the walkthrough.
  • Smarter account-name matching during transaction import - strips parenthetical category suffixes, normalizes whitespace, falls back to leading account number before creating a suspense account.
  • Imported check reference numbers preserved so they appear correctly in the bank register and edit views.
  • Per-company wizard isolation - switching companies now fully clears the import wizard.

Overview

BizBooks Pro's QuickBooks import goes beyond basic data migration. Most accounting software can import a simple chart of accounts - BizBooks Pro imports your complete transaction history, including customer invoices, invoice payments, vendor bills, and bill payments with proper matching.

This means you don't lose your A/R and A/P history. Your aging reports work from day one. Customer balances are accurate. No need to manually recreate years of invoices.

Pro Tip: Before importing, we recommend doing a trial import first. Create a test company, import your data, verify everything looks correct, then delete the test company and import into your real company.

What Gets Imported

Data Type What's Included
Chart of Accounts Account numbers, names, types, parent/child relationships, descriptions
Customers Names, contact info (created automatically from invoice data)
Vendors Names, contact info (created automatically from bill data)
Customer Invoices Invoice numbers, dates, line items with income account allocations, totals
Customer Payments Payment dates, amounts, deposit accounts, matched to invoices
Vendor Bills Bill numbers, dates, line items with expense account allocations, totals
Bill Payments Payment dates, amounts, payment accounts, matched to bills
Items List (new) Every QuickBooks item type — service, inventory, non-inventory, group, discount percentage, and inventory assembly — lands as a BizBooks Pro product record. Descriptions, sales prices, costs, taxable flags, reorder points, and income account references all transfer.
Class List (new) The full Class List from QuickBooks Desktop, including any parent/sub-class hierarchy, lands on BizBooks Pro's built-in Class tracking dimension. Active and inactive status preserved.
Class tags on journal lines (new) Add the Class column to your Phase 3 Transaction Detail report inside QuickBooks and BizBooks Pro will tag every imported journal line with its matching class. P&L by Class, Class register filters — all work on imported data with no manual editing.
Item references on bill / invoice lines (new) Add the Item column to your Transaction List by Customer and by Vendor reports, and BizBooks Pro resolves each line's item name to the matching imported product — so invoice and bill lines become true Item references, not orphaned text descriptions.

Importing your QuickBooks Items and Classes (new in May 2026)

BizBooks Pro's Phase 1 wizard accepts two extra QuickBooks Desktop list exports beyond the original three (Accounts, Customers, Vendors): your Item List and your Class List. Both tiles are optional — leave them empty if you don't use items or class tracking inside QuickBooks. But uploading them switches on two capabilities no other QuickBooks alternative offers in a single free in-product workflow:

  1. Phase 3 tags every transaction line with the right class. No more re-classifying years of imported transactions by hand.
  2. Detailed Bill / Invoice imports link each line to the right Item. Item-based reports, inventory movement, and product profitability all keep working on imported data.

Where to find the Item List export inside QuickBooks Desktop

  1. Open QuickBooks Desktop and choose File > Utilities > Export > Lists to IIF Files.
  2. Check the box for Item List.
  3. Save the file. Items.iif is a sensible name.
  4. Drag the file into the 📦 Items tile in BizBooks Pro's Phase 1 import wizard.

Where to find the Class List export inside QuickBooks Desktop

  1. Same menu: File > Utilities > Export > Lists to IIF Files.
  2. Check the box for Class List.
  3. Save as Classes.iif.
  4. Drop it into the 🏷️ Classes tile in Phase 1.

Turning on Class and Item columns in your Transaction reports

QuickBooks doesn't include Class or Item columns in its default Transaction Detail or Transaction List exports — they're available via Customize Report. To get the new tagging and Item-linking features to fire, add the columns before re-exporting:

  1. Open the relevant report inside QuickBooks Desktop (Transaction Detail for Phase 3; Transaction List by Customer / Vendor for Detailed Bill/Invoice import).
  2. Click Customize Report.
  3. Switch to the Display tab.
  4. Tick Class and (for the customer/vendor lists) Item in the column list.
  5. Re-run the report, export to CSV / Excel, and upload to BizBooks Pro.
Order matters: always run Phase 1 (Items + Classes) before Phase 3. BizBooks Pro tags transaction lines as they import, so the classes and items have to already exist in the company. Forgot the order? No problem — re-import Items / Classes in Phase 1 and re-run Phase 3 to tag the rest.

Exporting from QuickBooks Desktop

Chart of Accounts

  1. In QuickBooks, go to Lists > Chart of Accounts
  2. Press Ctrl+A to select all accounts
  3. Click Excel dropdown > Export All Accounts
  4. Save as CSV file

Customer Transactions (Invoices & Payments)

  1. Go to Reports > Customers & Receivables > Transaction List by Customer
  2. Set date range to All (or your desired range)
  3. Click Excel > Create New Worksheet
  4. In Excel, save as CSV file

Vendor Transactions (Bills & Payments)

  1. Go to Reports > Vendors & Payables > Transaction List by Vendor
  2. Set date range to All
  3. Click Excel > Create New Worksheet
  4. In Excel, save as CSV file
Important: Use the exact report names listed above. Other reports may not contain the detailed transaction data needed for proper import.

Import Steps in BizBooks Pro

  1. Navigate to Settings > Data Import (or use the Accountant Tools import wizard)
  2. Select QuickBooks Desktop Import
  3. Upload your exported CSV files:
    • Chart of Accounts CSV
    • Transaction List by Customer CSV
    • Transaction List by Vendor CSV
  4. Review the Auto-Mapping Preview - BizBooks Pro automatically matches QuickBooks account types to BizBooks account categories
  5. Adjust any mappings if needed (most accounts map correctly automatically)
  6. Click Preview Import to see what will be imported
  7. Click Import to complete the process

Advanced Transaction Import

What makes BizBooks Pro's import special is the transaction-level import. Here's what happens behind the scenes:

Invoice Import Process

Payment Matching

Bill & Vendor Payment Import

Troubleshooting

Import shows mismatched totals

This usually happens when invoices have discounts or credits applied. BizBooks Pro will show a warning but still imports the data. Review these invoices after import to verify they're correct.

Some accounts didn't map

If an account type wasn't recognized, it will be listed in "Unmapped Accounts." You can manually select the correct account type before importing.

Checking shows an inflated balance and I see "(IMPORT SUSPENSE)" accounts after import

This happens when a transaction in your QuickBooks file references an account whose name doesn't match any account in BizBooks Pro. Rather than rejecting the row, the importer creates a placeholder named {Original Account} (IMPORT SUSPENSE) and routes the offsetting side of the entry there. So for a check written for rent, the debit posts correctly to Checking, but the credit that should have hit Rent Expense instead lands in Rent Expense (IMPORT SUSPENSE). Multiply that across many transactions and your bank account balance ends up higher than reality - the offsets are all parked in suspense accounts, not lost.

How to fix it (BizBooks Pro v1.1.115+):

  1. Go to QuickBooks Data Import.
  2. Scroll to the bottom of the phase-selection page and click 🩹 Resolve Import Suspense.
  3. The tool lists every (IMPORT SUSPENSE) account along with its entry count, total debits, total credits, and a suggested correct account when a name match is found.
  4. For each row, accept the suggestion or pick the right account from the grouped dropdown of your real chart of accounts.
  5. Keep the Delete after merge checkbox checked to clean up the empty suspense account at the end.
  6. Click Resolve Selected. All transaction entries are reassigned in one operation, account balances are recalculated, and the suspense accounts are removed.

After running the tool, your bank balance should drop back to its real value and your income statement and balance sheet should reconcile. If you aren't sure where a particular suspense account belongs, leave its dropdown blank to skip it - you can re-open the tool and finish later.

Duplicate customers/vendors

If a customer or vendor name has slight variations in QuickBooks (e.g., "ABC Corp" and "ABC Corp."), they may import as separate entries. You can merge them after import using Customers > Merge or Vendors > Merge.

Date format issues

Ensure your QuickBooks is set to export dates in a standard format (MM/DD/YYYY). If dates appear incorrect, check your Windows regional settings.

Need Help? Contact our support team at support@bizbooks.pro. Include your CSV files (with sensitive data redacted) and we'll help troubleshoot.