# How to Export Your Chart of Accounts from QuickBooks Desktop (.IIF, Excel & .QBB)

By TrustSwitch: UK accounting data migration specialist
Last updated 10 November 2026
Canonical URL: https://trustswitch.co.uk/switching-software/accounting/export-qbd-chart-of-accounts

To export your Chart of Accounts list from QuickBooks Desktop, switch to Single-User Mode as Administrator and navigate to File > Utilities > Export > Lists to IIF Files (or export the Account Listing report to Excel/CSV). Remember that `.IIF` and CSV list exports capture account names and types only: they do not carry reconciled historical transactions, unpaid supplier bills, or customer invoice histories.

---

## Key takeaways

- **Single-User Admin required:** QuickBooks Desktop locks list exports until all network users log out and Administrator switches via File > Switch to Single-user Mode.
- **IIF vs Excel/CSV:** Exporting the Account Listing report to Excel/CSV is cleaner for human review; `.IIF` is a legacy tab-delimited Intuit format prone to import syntax errors.
- **Turn on Account Numbers first:** Many QBD files have nominal numbers switched off in Edit > Preferences > Accounting; enable or assign 3–4 digit codes before migrating to Xero.
- **Sub-account colon hierarchy:** QBD nests accounts up to 5 levels deep (`Motor:Repairs:Tyres`); Xero uses a flat Chart of Accounts and requires clean delimiter flattening.
- **Full ledger = .QBB backup:** Instead of piecing together `.IIF` lists and manual journals, a single `.QBB` backup lets TrustSwitch migrate your CoA + full history together.

---

## How Do You Export Your Chart of Accounts From QuickBooks Desktop?

To export your Chart of Accounts structure from QuickBooks Desktop[1], switch to Single-User Mode as Administrator and use either **`Lists > Chart of Accounts > Reports > Account Listing > Excel`** (best for clean spreadsheet review and Xero mapping) or **`File > Utilities > Export > Lists to IIF Files`** (Intuit’s legacy tab-delimited list format). Keep in mind that both methods export **account names and types only**: neither exports your reconciled multi-year invoices, unpaid supplier bills, or verified opening balances.

If you are planning a full cloud transition, review our [QuickBooks Desktop to QuickBooks Online](https://trustswitch.co.uk/migrations/qbd-to-qbo) and [QuickBooks Desktop to Xero](https://trustswitch.co.uk/migrations/qbd-to-xero) routes before spending days formatting spreadsheets manually.

## Step-by-Step: Exporting Your Account Structure Safely

1. **Check Whether Nominal Account Numbers Are Switched On:** Open `Edit > Preferences > Accounting > Company Preferences`. Many UK QuickBooks Desktop files grew for years with "Use account numbers" unticked. Switching account numbers on (or letting your specialist assign standard 3- or 4-digit codes during mapping) prevents duplicate-name collisions in Xero.
2. **Log In as Administrator in Single-User Mode:** Ask all colleagues on your network or RDS server to close QuickBooks. Click `File > Switch to Single-user Mode`.
3. **Method A (Recommended for Review): Export Account Listing to Excel/CSV:** Press `Ctrl+A` to open your Chart of Accounts, click the **Reports** button at the bottom of the window, select **Account Listing**, and click **Excel > Create New Worksheet**, saving as `.csv`.
4. **Method B (Legacy Intuit Format): Export Lists to `.IIF`:** Navigate to `File > Utilities > Export > Lists to IIF Files`, tick **Chart of Accounts** only, and save `Company_CoA_2026.IIF` to an encrypted local folder.
5. **Save a Full `.QBB` Golden Copy Backup:** Navigate to `File > Back Up Company > Create Local Backup` (selecting *Complete Verification* under Options) so you hold an untouched [Golden Copy backup](https://trustswitch.co.uk/data-security-compliance/data-migration/golden-copy-backup) containing both your lists and every underlying transaction.

## `.IIF` vs Excel CSV vs `.QBB` Backup: Which File Does What?

| Export Format | What It Contains | What It Leaves Behind | Best Use Case |
| :--- | :--- | :--- | :--- |
| **Account Listing (`.CSV` / `.XLSX`)** | Account code, name, type, tax code, current balance snapshot | All historical transactions, open AR/AP invoices, and sub-ledger detail | Accountant scoping & [Chart of Accounts Mapping](https://trustswitch.co.uk/switching-software/accounting/accounting-chart-of-accounts-migration) |
| **Intuit Interchange (`.IIF`)** | Raw tab-delimited `!ACCNT` header definitions | Historical ledger lines; rejected natively by Xero and modern QBO importers | Archival reference between legacy QBD installs |
| **QuickBooks Backup (`.QBB`)** | 100% of lists, sub-accounts, Classes, UK VAT entries, invoices, bills & reconciliations | Local `Attach` folder PDFs (archive folder separately) | Complete **£0.00 variance** migration to Xero or QBO |

## Three Structural Traps When Importing Exported Lists Into Cloud Software

### 1. Colon-Delimited Sub-Accounts (`Parent:Child:Grandchild`)
QuickBooks Desktop allows up to five nested account levels (for example, `Overhead:Motor Expenses:Van 1:Fuel`). Xero uses a flat Chart of Accounts without nested sub-accounts[2]. Uploading raw colon-separated strings creates messy account names unless flattened deliberately and paired with Xero Tracking Categories (see [QuickBooks Classes vs Xero Tracking Categories](https://trustswitch.co.uk/switching-software/accounting/qbd-vs-xero-reporting-2026)).

### 2. System Control Account Restrictions
In both Xero and QuickBooks Online, **Accounts Receivable (Debtors)**, **Accounts Payable (Creditors)**, **Retained Earnings**, and **VAT Control** are protected system accounts[2]. You cannot populate opening debtor or creditor balances properly by typing numbers into a CoA spreadsheet: open customer invoices and unpaid supplier bills must be imported individually so future bank receipts match cleanly.

### 3. Missing Historical Detail Above 350,000 Targets
If you exported your Chart of Accounts because Intuit’s built-in QBO converter failed with a target-count error, read [Fixing QuickBooks Desktop to Online Conversion Errors](https://trustswitch.co.uk/switching-software/accounting/qbd-to-qbo-conversion-failed) and [What Data Does NOT Migrate from QBD to QBO](https://trustswitch.co.uk/switching-software/accounting/qbd-to-qbo-missing-data). Rather than abandoning years of trading history, upload your `.QBB` backup to [TrustSwitch](https://trustswitch.co.uk/onboarding?path=qbd-to-qbo) for a flat-fee £245 to £595 + VAT conversion verified to **£0.00 Trial Balance discrepancy**.

---

## Frequently Asked Questions

**Q: Can I import a QuickBooks `.IIF` file directly into Xero?**

No. Xero does not accept Intuit’s proprietary `.IIF` format directly; Xero requires a structured CSV matching Xero’s exact Account Type and UK Tax Rate labels, or an automated migration directly from your `.QBB` backup.

**Q: Why do opening balances go wrong if I import my Chart of Accounts CSV manually?**

Because system control accounts (Accounts Receivable, Accounts Payable, Retained Earnings, VAT Control, and Bank accounts) must tie out to individual unpaid customer invoices, supplier bills, and cleared bank lines rather than static spreadsheet numbers.

**Q: Should I delete old inactive accounts in QuickBooks Desktop before migrating?**

Never delete an account that holds historical transactions in your 6-year statutory window, as doing so alters prior-year comparatives. Simply mark unused zero-balance accounts as Inactive.

**Q: Does TrustSwitch map QuickBooks Desktop accounts without nominal numbers?**

Yes. If your QuickBooks Desktop file never used numeric nominal codes, our UK ledger specialist assigns logical UK standard 3- or 4-digit nominal codes mapped cleanly to your P&L and Balance Sheet groups.

---

## References

1. Intuit QuickBooks UK Support: *QuickBooks UK Help & Desktop-to-Online transition guidance*. https://quickbooks.intuit.com/learn-support/en-uk Accessed 10 November 2026.
2. Xero Central: *Enter conversion balances and historical opening adjustments in Xero*. https://central.xero.com/s/article/Enter-conversion-balances Accessed 10 November 2026.
