Loading tool...
Loading tool...
Generate a properly formatted CSV file for QuickBooks® Online with correct Type and Detail Type mappings. Choose from 21 industry templates or build from scratch — completely free.
Generate CSV FileA Chart of Accounts (COA) is the master list of all financial accounts used by your business to categorize every transaction. In QuickBooks® Online, the Chart of Accounts serves as the backbone of your accounting system — it determines how revenue, expenses, assets, liabilities, and equity are organized and reported. Every invoice, bill, payment, and journal entry you record maps to one of these accounts.
QuickBooks® Online uses a two-level categorization system for accounts. Each account has a Type (such as "Expense" or "Bank") and a Detail Type (such as "Advertising/promotional" or "Checking"). The Type determines where the account appears on your financial reports — Profit & Loss or Balance Sheet. The Detail Type provides more granular categorization that QuickBooks® uses for tax mapping and industry comparisons.
When you create a new company in QuickBooks® Online, a default Chart of Accounts is created automatically based on your industry selection. However, these defaults are often too generic for most businesses. A custom Chart of Accounts tailored to your specific business operations will give you far more useful financial insights. Our generator creates CSV files with the exact column format QuickBooks® Online expects, including the correct Type and Detail Type mappings, so you can import your custom accounts instantly.
QuickBooks® Online (QBO) is the most popular cloud-based accounting software for small businesses worldwide, with over 7 million subscribers. Because it runs entirely in your web browser, QBO offers several advantages over desktop accounting software: you can access your books from any device with an internet connection, collaborate with your accountant in real-time, and never worry about losing your data to a hard drive failure.
QBO comes in four pricing tiers — Simple Start, Essentials, Plus, and Advanced — each adding features like bill management, project tracking, inventory, and custom reporting. All tiers include direct bank connections that automatically download transactions, smart categorization powered by machine learning, and an extensive ecosystem of over 750 integrated third-party apps for payroll, time tracking, e-commerce, and more.
One significant advantage of QuickBooks® Online is its built-in Chart of Accounts import feature. Unlike QuickBooks® Desktop which requires IIF files, QBO accepts standard CSV files — making it easy to generate, review, and import your Chart of Accounts. Our generator automatically formats the CSV with the correct headers (Account Name, Type, Detail Type, Account Number, Description) that QBO expects, eliminating formatting headaches and import errors.
Follow these five steps to import your generated CSV file into QuickBooks® Online. The process takes about one minute.
Use our generator to select an industry template or create a custom Chart of Accounts. Choose "QuickBooks® Online" as your export format, then download the .csv file.
Sign in to your QuickBooks® Online account at qbo.intuit.com. Navigate to Settings (gear icon) → Import Data.
In the Import Data page, choose "Chart of Accounts" from the available import options. Click "Browse" to locate your downloaded CSV file.
QuickBooks® Online will display a preview of your data. Verify that the column mappings are correct — Account Name, Type, Detail Type, and Account Number should all be automatically detected.
Click "Import" to finalize. QuickBooks® Online will process the file and display a summary showing how many accounts were successfully imported. Navigate to Settings → Chart of Accounts to verify.
Below is a recommended starting Chart of Accounts for QuickBooks® Online, showing the Type and Detail Type mapping for each account.
Primary business checking account
Business savings or reserve account
Outstanding customer invoices
Insurance, rent, and other prepaid costs
Computers, machinery, furniture
Bills owed to vendors
Business credit card balances
Wages, taxes, and benefits owed
Bank loans and long-term debt
Owner's investment in the business
Accumulated profits from prior years
Primary service income
Revenue from product sales
Marketing and promotional costs
Business insurance premiums
Paper, ink, small office items
Office or retail space rent
Electricity, water, phone, internet
Choose from 21 industry templates, customize your accounts, and download a ready-to-import CSV file in seconds.
Generate CSV File Now