Free chart of accounts template and guide

A chart of accounts (COA) gives your business a clear, consistent structure for recording financial activity, which leads to cleaner reporting and smoother audits. It categorizes every transaction across assets, liabilities, equity, revenue, and expenses so your books stay organized as you grow.

What is a chart of accounts?

A chart of accounts is the complete list of every account in your general ledger, organized by category. It serves as the backbone of your accounting system. Every transaction flows through it and feeds directly into your balance sheet and income statement.

Each account in your COA has four components:

• Account number: A unique identifier for each account (e.g., 1000)
• Account name: A descriptive label that tells you what the account tracks (e.g., "Checking Account")
• Account type: The category it belongs to—asset, liability, equity, revenue, or expense
• Description: A brief explanation of what the account records

This structure keeps your data consistent and ensures your reports are accurate and easy to interpret.

Why use a chart of accounts template

Building a COA from scratch takes time and leaves room for error. A pre-built template gives you a proven structure so you can skip the guesswork and focus on customizing it for your business.

• Faster setup: Start with industry-tested account categories instead of creating every account manually
• Fewer errors: A pre-formatted structure reduces the risk of misclassifying transaction
• Software compatibility: Templates import directly into QuickBooks, Xero, and other platforms via CSV or XLS.
• Scalability: Built-in numbering gaps let you add accounts as your business grows without restructuring

Whether you're launching a new company or cleaning up a messy ledger, a template gets you to a working COA faster.

5 core account types in a chart of accounts

Five main sections make up a typical chart of accounts. These categories standardize how transactions are classified and make your financial reports easier to read and compare over time. Accounts are ordered by liquidity—balance sheet accounts first, then income statement accounts.

Assets: What you own

Assets represent what your business owns or controls, ordered from most to least liquid. They include the resources you use to operate, from cash in the bank to equipment in the field.

Common asset accounts include:

• Cash and cash equivalents
• Accounts receivable
• Inventory
• Prepaid expenses
• Equipment and vehicles

Most COAs number asset subaccounts starting with 1, such as 1000 for cash or 1200 for accounts receivable.

Liabilities: What you owe

Liabilities are what your business owes to others. These accounts track obligations such as unpaid vendor bills, loans, and other debts so you can manage upcoming payments.

Examples include:

• Accounts payable
• Credit card balances
• Payroll liabilities
• Bank loans
• Sales tax payable

Short-term liabilities are due within a year, and long-term liabilities extend beyond that. Many businesses number liability subaccounts in the 2000 range.

Equity: What your business is worth

Equity represents the owners' or shareholders' stake in the business after subtracting liabilities from assets. It reflects invested capital and accumulated profits. Over time, equity shows your company's book value.

Typical equity subaccounts include owner's capital, retained earnings, and dividends or distributions. Corporations also include common stock and additional paid-in capital in this section.

Revenue: What you earn

Revenue accounts track the money your business earns from its primary activities. Clear revenue categorization helps you see which income streams perform best and where you may need to adjust pricing or strategy.

Depending on your business model, revenue subaccounts may include product sales, service fees, or interest income. These accounts typically fall in the 4000 range.

Expenses: What your business spends

Expense accounts capture the costs required to operate your business. These categories help you monitor spending, manage budgets, and identify opportunities to reduce costs.

Common expenses include salaries, rent, software subscriptions, utilities, marketing, and cost of goods sold (COGS). Some companies also group expenses by department, such as sales or operations, to improve reporting clarity.

How chart of accounts numbering works

A consistent numbering system makes your COA easier to navigate and keeps your reporting clean. Most COAs use a three-digit system for small businesses or a four-digit system for mid-market and enterprise companies. The first digit always indicates the account type, so you can identify any account's category at a glance.

Standard account number ranges

The standard convention assigns number ranges to each of the five core categories:

• 1000–1999: Assets
• 2000–2999: Liabilities
• 3000–3999: Equity
• 4000–4999: Revenue
• 5000–6999: Expenses

Within each range, subaccounts group related items together. For example, you might use 1000–1099 for cash accounts, 1100–1199 for receivables, and 1200–1299 for inventory.

Numbering best practices

• Leave gaps between numbers: Use intervals such as 1000, 1010, 1020 so you can insert new accounts without renumbering your entire chart.
• Match complexity to company size: Three-digit systems work for small businesses; four or more digits suit growing companies with multiple departments or locations.
• Stay consistent: Once you pick a format, stick with it across all accounts. Review your general ledger periodically to ensure accounts remain current.
• Group related subaccounts together: Keep logical ranges like 11xx for receivables or 52xx for marketing expenses.
• Document your numbering rules: Make sure everyone on your team applies the same conventions.

Sample chart of accounts

Here's what a typical COA looks like in table format:

This is a starting point—adapt it based on your industry, business model, and reporting needs.

How to set up a chart of accounts

When you're ready to record transactions with a chart of accounts, these four steps will help you set up a COA efficiently and keep your financial data organized from day one.

Step 1: Identify your business structure

Your business type shapes your COA. A sole proprietor may only need a few equity accounts, while a corporation requires shareholder-specific accounts. Whether your organization is a partnership, LLC, or corporation, outline how capital, contributions, and distributions work early on so you avoid cleanup later.

Your industry also determines which expense and revenue accounts are relevant. A retail business needs inventory and COGS accounts, while a consulting firm focuses on service revenue and contractor expenses.

Step 2: Choose a numbering system

Most COAs use a standard numbering convention to record transactions and group accounts by category. Decide between a three-digit system for simpler businesses or a four-digit system if you need more room to scale. Start with simple blocks—1000 for assets, 2000 for liabilities—and leave space between numbers so you can add new accounts without renumbering.

Step 3: Create your account list

Identify the accounts your business actually needs today. You don't need dozens of subaccounts on day one. Start lean and build only when necessary. Focus on capturing major financial activities, including how you earn money, what you spend, and what you own or owe.

Step 4: Import into your accounting software

Most accounting software tools, including QuickBooks, Xero, and NetSuite, accept CSV or XLS uploads. Start by editing or removing default accounts you don't need. Map your account types to the software's built-in categories during import. Organize accounts with clear names, logical numbers, and consistent formatting so the structure stays clean as your business grows.

How to create a chart of accounts template in Excel

If you'd rather build your own template, a spreadsheet is the easiest place to start. You can create a COA template in Excel (or Google Sheets) with just a few columns.

Set up your spreadsheet with these essential columns:

• Account number: The unique numeric identifier (e.g., 1010)
• Account name: A clear, descriptive label (e.g., Petty Cash)
• Account type: The category from the five core types (Asset, Liability, Equity, Revenue, Expense)
• Description: A one-line explanation of what the account tracks.
• Parent account (optional): Use this column to create sub-accounts under a main account for more granular reporting.

Start by entering your five core categories, then add specific accounts within each range. Leave gaps in your numbering so you can insert new accounts later. Save the file as CSV or XLSX so it's ready to import into QuickBooks, Xero, or any other accounting platform.

This same template can work in Google Sheets—just upload the file directly to Google Drive.

Chart of accounts templates by industry

Different industries need different levels of detail. Use these examples to tailor your COA to the way your business operates.

SaaS and technology companies

SaaS companies need to track recurring revenue separately from one-time income. Your COA should include accounts for deferred revenue, subscription revenue, and hosting or infrastructure costs. You'll also want to distinguish between monthly recurring revenue (MRR) and professional services income.

Professional services

Service businesses rely less on inventory and more on labor. Their COAs typically emphasize revenue streams, contractor expenses, and software tools rather than inventory accounts, freight charges, or manufacturing costs. You may also want job-based or project-based income accounts.

Retail and e-commerce

Retail companies often have inventory-heavy COAs. Expect accounts for merchandise purchases, shrinkage, freight-in, and COGS. You'll also see multiple inventory categories, such as finished goods, in-store inventory, or returned goods.

Manufacturing

Manufacturers need detailed tracking for production costs. This includes raw materials, work-in-process (WIP), finished goods, and manufacturing overhead. A strong manufacturing COA also includes COGS subaccounts for direct labor and factory supplies.

Nonprofit organizations

Nonprofits have unique requirements because restrictions govern how funds are tracked and used. Restricted funds must be used for a specific purpose, while unrestricted funds cover operating costs such as staff salaries or technology. You'll also need subaccounts for program-specific income, grant tracking, fundraising, and donations tied to donor intent.

How to import a chart of accounts into QuickBooks

If you're using QuickBooks Online, you can import your COA template in just a few steps. This saves you from manually entering every account.

1. Prepare your file: Save your template as a CSV with columns for Account Name, Account Type, and Detail Type. QuickBooks requires these three fields at minimum.
2. Access import settings: In QuickBooks Online, go to Settings > Chart of Accounts > Import
3. Map your columns: Match your spreadsheet columns to QuickBooks fields. Make sure each account type aligns with QuickBooks' built-in categories (e.g., "Asset" maps to "Bank" or "Other Current Asset").
4. Review and confirm: QuickBooks will flag any errors or duplicates before finalizing the import. Review the preview carefully, then confirm.

For QuickBooks Desktop, the process is similar but uses the "Add/Edit Multiple List Entries" feature or an IIF file import. Check QuickBooks' documentation for version-specific steps.

Best practices for maintaining your chart of accounts

A clean and consistent chart of accounts makes your financial reporting easier to manage as your business grows. Use these practices to keep your COA organized and reliable:

• Review quarterly: Archive inactive accounts and add new ones as your business operations change. Quarterly reviews catch issues before they compound.
• Avoid duplicates: Before adding a new account, check whether an existing one will work. Merge similar accounts that track the same transactions to keep your COA lean.
• Keep descriptions updated: Clear labels and descriptions prevent miscategorization and make onboarding faster for new team members.
• Limit who can edit: Restrict COA changes to accounting team leads. Too many people making edits leads to inconsistencies and duplicate accounts.
• Use consistent naming conventions: Apply the same style to all account names so your financial reports stay aligned over time.
• Document changes: Maintain a log of when and why accounts were added, removed, or renamed so your team stays on the same page.

Common chart of accounts mistakes to avoid

Even a well-designed COA can break down without the right guardrails. Watch out for these common pitfalls:

• Too many accounts: An overly granular COA creates confusion and makes reporting harder. If you're tracking every minor expense in its own account, consolidate.
• Too few accounts: A COA that's too lean lacks the detail you need for accurate financial analysis and tax reporting.
• Inconsistent naming: Mixing naming styles (e.g., "Office Supplies" vs. "Supplies - Office") makes it difficult to find the right account when recording transactions.
• No numbering gaps: If you number accounts sequentially with no gaps, you'll have to renumber everything when you need to insert a new account.
• Ignoring industry standards: Using a generic COA when your industry has specific requirements makes benchmarking and audits more difficult.

Build a chart of accounts that scales with your business

Setting up a chart of accounts from scratch is time-consuming, and maintaining it as your business grows can feel like a never-ending chore. You need a structure that's detailed enough for accurate reporting but flexible enough to adapt as new departments, products, and expense categories emerge.

Ramp's AI-powered accounting software maintains your chart of accounts structure automatically, so you get the granularity you need without the manual upkeep. Here's how it works:

• Auto-generate account codes: Ramp creates department, location, class, and custom dimension codes based on your existing structure, so every transaction maps to the right account without manual entry.
• Sync with your ERP automatically: Ramp syncs transactions to your accounting system in real time so your chart of accounts stays current across platforms without duplicate data entry.
• Map vendors and merchants automatically: Ramp learns which GL accounts correspond to specific vendors and applies those mappings across all future transactions, reducing coding errors and speeding up categorization.
• Enforce coding rules at the source: Set required fields for specific accounts so employees select the right dimensions when submitting expenses, ensuring data accuracy before transactions even hit your books.
• Scale without restructuring: Add new departments, locations, or projects in Ramp and watch the system propagate those changes across your chart of accounts automatically.

With Ramp, your chart of accounts evolves with your business, so you spend less time on maintenance and more time on analysis. Try a demo to see how Ramp automates chart of accounts management from day one.