Loading tool...
Loading tool...
Generate a maximally portable Chart of Accounts CSV file with standardized columns that can be imported into virtually any accounting software. The universal starting point for any platform.
Generate Universal CSVA Chart of Accounts (COA) is the comprehensive list of every financial account your business uses to categorize transactions. It is the structural backbone of any accounting system — whether you use cloud software, desktop applications, or even a manual ledger. The Chart of Accounts organizes your financial activity into five fundamental categories: Assets, Liabilities, Equity, Revenue, and Expenses. Each account within the chart has a unique identifier (number or code) and a descriptive name that explains its purpose.
The challenge with Charts of Accounts is that every accounting software uses slightly different formats. QuickBooks® expects IIF files for Desktop and specific CSV columns for Online. Xero requires asterisk-prefixed headers and its own type codes. Sage uses different account type names. MYOB requires tab-delimited files with hyphenated account numbers. This fragmentation makes it difficult to create a single file that works everywhere.
The Universal CSV format solves this by using standardized, descriptive column headers that are widely understood: Account Number, Account Name, Type, Category, and Description. While you may need to adjust column names or type mappings for specific software, the Universal CSV provides a clean, well-structured starting point that minimizes the adaptation work. It is the ideal choice when you have not yet decided on your accounting software, need to support multiple platforms, or want a reference document that is not tied to any single vendor.
The Universal CSV format is designed for maximum portability and flexibility. Whether you are setting up a new business and have not chosen your accounting software yet, managing multiple businesses on different platforms, or migrating data between systems, the Universal CSV gives you a vendor-neutral starting point that can be adapted to any target system.
Every major accounting platform supports CSV imports in some form. By starting with a well-structured Universal CSV, you avoid vendor lock-in and maintain full ownership of your account structure data. You can import the same chart into QuickBooks® for your U.S. entity and Xero for your Australian subsidiary, adapting the type mappings for each platform while keeping the core account structure consistent across your organization.
The Universal CSV is also invaluable for accounting firms and bookkeepers who manage clients across multiple platforms. Instead of creating separate charts for each software, you can generate a single Universal CSV and adapt it for each client's specific platform. This ensures consistency in your standard chart of accounts while accommodating the technical requirements of different software vendors.
The Universal CSV can be adapted for import into all major accounting platforms. Here are notes for the most popular ones.
Rename columns to match QBO's expected headers (Account Name, Type, Detail Type)
Add asterisk-prefixed headers (*Code, *Name, *Type) and map types to Xero codes
Use the Account Name and Type columns; refer to FreshBooks category list for type mapping
Import directly — Zoho Books accepts CSV files with Account Name, Type, and Description
Map account types to Sage's categorization system and add ledger codes
Import using the Built-in Batch Create function — supports CSV with account names and types
Use the account hierarchy import feature — map account types to GnuCash categories
Import via Settings → Technical → Base Import — map to Odoo's account codes and types
Below is the standard Chart of Accounts structure used in the Universal CSV format.
Primary business bank account
Business savings and reserves
Outstanding customer invoices
Prepaid insurance, rent, etc.
Computers, machinery, and furniture
Cumulative depreciation
Bills owed to suppliers
Business credit card balances
Expenses incurred, not yet paid
Bank loans and long-term debt
Owner's investment
Accumulated prior-year profits
Primary business income
Revenue from services
Miscellaneous income
Direct costs of products sold
Marketing and promotional costs
Business insurance premiums
Stationery and office materials
Office or retail space rent
Electricity, water, phone, internet
Employee compensation
Choose from 21 industry templates and download a portable CSV file that works with any accounting software.
Generate Universal CSV Now