Setting up a chart of accounts is one of the most fundamental tasks in QuickBooks. It provides the structure for tracking every financial transaction your business makes—from revenue and expenses to assets and liabilities. But manually creating dozens or even hundreds of accounts line by line can be tedious and time-consuming .
The solution? Importing your chart of accounts from a spreadsheet. Whether you're setting up a brand new QuickBooks company, switching from another accounting software, or building a master account list for use across multiple client files, batch importing via Excel or CSV saves hours of work and reduces data entry errors . The impact of doing this correctly on business operations is significant: it ensures accurate financial reporting, streamlines payroll processing, prevents multi-user access issues, and avoids company file access problems that can arise from manual data entry errors.
This comprehensive guide provides everything you need to know about importing a chart of accounts into QuickBooks Online and Desktop, from formatting your spreadsheet correctly to troubleshooting common import errors. If you need immediate expert assistance with complex imports, call 1-855-309-1993 for 24/7 QuickBooks support.
What Is a Chart of Accounts Import?
A chart of accounts import is the process of uploading a batch of accounts from a spreadsheet (Excel, Google Sheets, or CSV file) directly into QuickBooks instead of creating each account manually . The chart of accounts is the complete list of your company's accounts and is the foundation of your bookkeeping system .
When you should import your chart of accounts:
When setting up a brand new QuickBooks company
When migrating from other accounting software (QuickBooks Desktop, Sage, Xero, etc.)
When adding a large number of accounts at once (saves time over manual entry)
When maintaining consistency across multiple company files (e.g., for accountants managing several clients)
When rebuilding or restructuring your existing chart of accounts
Common scenarios users face:
You want to upload chart of accounts to QuickBooks from an Excel template your accountant provided
You need to copy chart of accounts from one QuickBooks company to another
You're migrating from QuickBooks Desktop to QuickBooks Online and the migration didn't transfer your accounts
You want to import chart of accounts from Excel using a simple CSV file
If you're unsure about the import process or encounter persistent errors, calling 1-855-309-1993 can connect you with QuickBooks specialists who can guide you through the process.
Common Causes of Chart of Accounts Import Errors
Understanding why QuickBooks chart of accounts import fails helps you prepare a clean file and avoid frustration.
Incorrect Spreadsheet Formatting
The most common cause of import failure is incorrect spreadsheet formatting. QuickBooks requires specific columns: Account Name, Type, Detail Type, and optionally Account Number . Missing columns or incorrect header names cause the import to fail.
Blank Rows Between Headers and Data
Even a single blank row between the header row and your first account can cause QuickBooks to interpret the file as empty . The system sees the blank row and assumes there's no data to import.
Invalid Account Types or Detail Types
If you enter an account type or detail type that doesn't match QuickBooks' preset list, the import will fail. Detail type options depend on the account type you select .
Duplicate Account Names or Numbers
QuickBooks requires unique account names and account numbers. Duplicates will cause errors flagged in red during the import review stage .
Mismatched Subaccount Formatting
When creating subaccounts, the formatting must follow the exact pattern: "Main Account:Subaccount" . Any deviation (using a slash, dash, or other separator) will cause import errors.
Special Characters in Account Names
Commas, periods, or other symbols in account names must exactly match what's in QuickBooks if you're updating existing accounts . For new accounts, it's best to avoid special characters altogether.
Tax Rate or Currency Errors
If your spreadsheet includes tax rate or currency columns, you must select options from QuickBooks' preset list. Custom text entries will be rejected .
Damaged Installation Files (QuickBooks Desktop)
For QuickBooks Desktop users, import errors may stem from damaged installation files or corrupted company file data. Running the Verify and Rebuild utility can resolve these issues.
If you're encountering errors you can't resolve on your own, call 1-855-309-1993 for expert troubleshooting assistance.
How to Import QuickBooks Chart of Accounts (Step-by-Step Solutions)
Follow these solutions in order. Most import issues resolve by carefully following Solution One.
Solution One: Format Your Spreadsheet Correctly (QuickBooks Online)
Before you begin the import process, proper spreadsheet formatting is essential. The best practice is to download the sample file from QuickBooks and use it as your template .
Step One: Download the Sample File
Sign in to your QuickBooks Online account
Go to Settings ⚙️ and select Chart of accounts
Click the dropdown arrow next to New and select Import
Step Two: Add Your Accounts to the Sample File
Open the downloaded sample file (Excel or CSV format)
Keep the original headers in row 1 unchanged – do not modify, rename, or delete them
Enter your accounts starting from row 2 downward
Required Columns:
Valid Account Types:
Income
Expenses
Cost of Sales
Cash at bank and in hand
Current assets
Fixed assets
Current liabilities
Non-current liabilities
Owner's equity
Formatting Subaccounts:
Enter the parent account name followed by a colon (:) then the subaccount name
Both the header and subaccount must use the same account type
The parent account must be listed in a row above the subaccount
What NOT to do:
Don't leave blank rows between the header row and your account data
Don't change the internal formatting of the template
Solution Two: Import Your Chart of Accounts (QuickBooks Online)
Once your spreadsheet is correctly formatted, follow these steps to complete the import .
Steps:
Sign in to your QuickBooks Online account
Go to Settings ⚙️ and select Import data
Select Chart of Accounts
To upload a file:
From your computer: Select Browse, choose the file, then select Open
From Google Sheets: Select Connect to sign in to your Google account, choose the correct file, then select Select
Select Next
Solution Three: Map Your Spreadsheet Fields to QuickBooks Fields
After uploading, you need to map your spreadsheet columns to QuickBooks fields .
Steps:
For each field, use the dropdown menu to match:
Account Name
Account Number
Type
Detail Type
For Detail Type, the options available depend on the Account Type you selected
Except for Account Name, you can select No Match for fields that don't have matching columns (e.g., if you don't use account numbers)
Select Next
Solution Four: Review and Import Your Accounts
Before finalizing, review everything one last time .
Steps:
If you see a field highlighted in red, hover over it to see what needs to be fixed
Common issues include:
Uncheck any account you don't want to save
If everything looks good, select Import
After a successful import:
Enter opening balances for your accounts via journal entries
Connect your bank or credit card accounts to start downloading transactions
Solution Five: Import Chart of Accounts into QuickBooks Desktop
The process for QuickBooks Desktop differs from QuickBooks Online .
Steps:
Log in to your QuickBooks Desktop company file as Administrator
Go to the Lists menu
Select Chart of Accounts
Look for an option that says Import from Excel
Locate your pre-prepared file (must be .csv or .xls format)
QuickBooks will guide you through matching columns in your file with fields in QuickBooks
Select Import
Note: Some versions of QuickBooks Desktop require specific add-ons or configurations for import functionality.
Solution Six: Use the IIF File Format (QuickBooks Desktop Advanced Users)
For advanced QuickBooks Desktop users, the IIF (Intuit Interchange Format) file format can be used for batch importing .
Important Considerations:
IIF files offer the greatest control but require precise formatting
Using an incorrectly formatted IIF file can corrupt your company file
Always back up your company file before attempting IIF import
For most users, the Excel/CSV import method is safer and simpler
Solution Seven: Fix "File Doesn't Contain Any Data" Error
If you receive an error stating the file doesn't contain any data :
Steps:
Check for blank rows between your header row and account data – delete them
Verify the file format is Excel (.xlsx), Google Sheets, or CSV
Ensure the file actually contains data in the rows below the header
Try re-saving the file in a different format (.xlsx to .csv or vice versa)
Check that the file isn't set to "Read Only"
Solution Eight: Fix "Account Does Not Exist in QB" Error
If you're updating existing accounts or importing transactions and receive "Account does not exist in QB" :
Steps:
Verify the account name is spelled exactly as it appears in QuickBooks
If you use account numbers, turn them off temporarily during import:
For new accounts, add them to your chart of accounts before importing transactions that reference them
Solution Nine: Handle Subaccount Imports Correctly
To successfully import subaccounts :
Steps:
Use the format:
Main Account:Subaccountin the Account Name columnExample:
Travel:Airfare,Travel:Accommodation,Travel:MealsEnsure the parent account is listed in a row above the subaccount
Both accounts must use the same account type
If you get an error, check for:
Missing colon between parent and subaccount names
Spaces before or after the colon
Parent account listed after the subaccount in the file
Solution Ten: Fix Zero Balance After Migration
If you migrated from QuickBooks Desktop to Online and your chart of accounts appears blank or shows zero balances :
Understanding the Issue:
Not all features and data transfer during migration
If your chart of accounts shows zeros, it means your accounts don't have any transactions associated with them yet
Open Purchase Orders, Pending Sales, and past reconciliation reports don't transfer
Solution:
Use the import method described in Solutions One through Four to populate your chart of accounts
If the chart of accounts names loaded but balances are zero, you'll need to enter opening balances separately
This is normal for new QuickBooks Online companies with no transaction history
Solution Eleven: Run QuickBooks Tool Hub (QuickBooks Desktop)
If you're experiencing persistent import issues in QuickBooks Desktop, a damaged installation could be the cause.
Step One: Download and Install QuickBooks Tool Hub
Close QuickBooks Desktop completely
Download the latest version of the QuickBooks Tool Hub from Intuit's official website
Save the file to your Downloads folder
Open the downloaded file (
QuickBooksToolHub.exe)Follow the on-screen installation instructions
Step Two: Run Quick Fix my Program
Open QuickBooks Tool Hub
Select the Program Problems tab
Click Quick Fix my Program
Wait for the process to complete (approximately one minute)
Step Three: Run QuickBooks File Doctor (if needed)
In QuickBooks Tool Hub, select the Company File Issues tab
Click Run QuickBooks File Doctor
Select your company file from the dropdown menu
Select Check your file (middle option)
Enter your QuickBooks admin password
Wait for the scan to complete
Attempt the import again
Solution Twelve: Contact QuickBooks Support for Persistent Import Errors
If you have worked through all these solutions and still cannot import your chart of accounts, the issue may require specialized investigation.
When to contact support:
Spreadsheet formatting is correct but import still fails
Error messages are unclear or not covered in this guide
You're migrating complex data from another accounting system
The chart of accounts is partially imported but missing specific accounts
You've tried multiple file formats and all failed
To contact QuickBooks Support:
Open QuickBooks and go to Help > Contact Us
Describe your issue as "Chart of accounts import failing"
Select your preferred contact method (chat or callback)
Call 1-855-309-1993 for immediate expert assistance
Tips to Prevent Chart of Accounts Import Issues
Avoid future QuickBooks chart of accounts import problems with these proactive measures.
Always download the sample file – Use QuickBooks' sample template as your starting point
Keep the original file format – Don't change column headers or internal formatting
Remove blank rows – Ensure no empty rows exist between header and data
Use unique account names and numbers – Duplicates will trigger errors
Back up your data before importing – Always have a safety net
Test with a small batch first – Import 5-10 accounts to verify formatting before uploading hundreds
Turn off account numbers during import – Temporarily disable if you encounter matching errors
Check for special characters – Avoid commas, periods, and symbols in account names
Document your account structure – Have a clear hierarchy before building your spreadsheet
Use consistent naming conventions – Helps with future imports and exports
Keep QuickBooks updated – Install the latest releases for compatibility
Sample Chart of Accounts for QuickBooks
QuickBooks provides commonly used accounts to get you started :
Income Accounts:
Billable Expense Income
Services
Product Sales Revenue
Expense Accounts:
Accounting and bookkeeping
Advertising and marketing
Bank charges and fees
Office expenses
Payroll Expenses
Rent or lease payments
Repairs and maintenance
Subscriptions and dues
Travel expenses
Utilities
Cost of Sales Accounts:
Cost of Materials
Shipping, Freight, and Delivery
Asset Accounts:
Undeposited funds
Inventory
Office furniture and equipment at cost
Motor vehicles at cost
Liability Accounts:
GST/HST Liabilities (Canada)
Payroll liabilities
Loan
Equity Accounts:
Opening balance equity
Retained earnings
Owners drawings
Frequently Asked Questions (FAQ)
FAQ One: How do I import a chart of accounts into QuickBooks Online?
Go to Settings ⚙️ > Import data > Chart of Accounts, upload your properly formatted Excel or CSV file, map the fields correctly, and select Import. For best results, download the sample file from QuickBooks and use it as your template .
FAQ Two: Can I import a chart of accounts with subaccounts into QuickBooks?
Yes. Format subaccounts using a colon between the parent account and subaccount name, like Travel:Airfare . Ensure the parent account is listed in a row above the subaccount, and both use the same account type.
FAQ Three: Why is my chart of accounts not importing?
The most common reasons are incorrect spreadsheet formatting, blank rows between headers and data, invalid account types or detail types, or duplicate account names . Download the sample file from QuickBooks and compare your formatting to ensure it matches.
FAQ Four: What file format does QuickBooks support for chart of accounts import?
QuickBooks Online supports Excel (.xlsx), CSV, and Google Sheets file formats . QuickBooks Desktop supports .csv and .xls formats. Always keep the original headers unchanged.
FAQ Five: How do I fix the error "file doesn't contain any data"?
This error usually means there's a blank row between your header row and your first account, or the file is empty . Open your spreadsheet, delete any blank rows, ensure data starts in row 2, and re-save the file before trying again.
FAQ Six: Can I import my chart of accounts from QuickBooks Desktop to QuickBooks Online?
Yes, you can export your chart of accounts from QuickBooks Desktop (Lists > Chart of Accounts > Export) and then import the file into QuickBooks Online using the Import Data option . However, note that some data types don't transfer during full migration and may require separate import .
FAQ Seven: Do I need to include account numbers when importing?
No, account numbers are optional. If your spreadsheet includes account numbers, ensure they are unique. If you encounter matching errors, temporarily turn off account numbers in QuickBooks settings (Account and Settings > Advanced > Chart of Accounts) during import, then turn them back on after completing the import .
Final Thoughts
Importing your chart of accounts is one of the most efficient ways to set up or update your QuickBooks company. Instead of manually creating dozens or hundreds of accounts one by one, a properly formatted import saves hours of work and eliminates data entry errors.
The importance of getting your chart of accounts right cannot be overstated. Your accounts provide the structure for every financial report, from your Profit and Loss to your Balance Sheet. Errors in account types or hierarchy can ripple through your entire bookkeeping system.
Common fixes—downloading the sample file, formatting subaccounts correctly, removing blank rows, mapping fields accurately, turning off account numbers during import, testing with small batches, and running QuickBooks Tool Hub repairs—resolve most QuickBooks chart of accounts import issues within 20 minutes.
If you have worked through all the solutions and still cannot import your accounts, deeper issues may exist. Complex account structures, corrupted data, or system-specific restrictions may require professional intervention. QuickBooks Support has specialized tools to diagnose and resolve persistent import errors.
Do not let import errors delay your accounting setup. Download the sample file first, format your accounts correctly, and work through the solutions in order. If problems persist, contact QuickBooks Support through the Help menu. A properly structured chart of accounts is the foundation of accurate bookkeeping – import your accounts today.
| https://www.reddit.com/r/quickbooksonline/comments/1tk5b7p/faq_does_quickbooks_payroll_have_247_hour_support/ |
