Nonprofit Chart of Accounts: Free Excel Template + Setup Guide

‍

Table of contents

• What is a nonprofit chart of accounts?

• Why your nonprofit needs a well-structured COA

• Free nonprofit chart of accounts template (Excel + Google Sheets)

• The 5 core account categories for nonprofits

• Standard account numbering convention

• Sample nonprofit chart of accounts

• How to set up your chart of accounts, step by step

• 3 types of nonprofit chart of accounts

• How your COA aligns with Form 990

• 6 best practices for maintaining your COA

• Common chart of accounts mistakes to avoid

• Nonprofit accounting software that works with your COA

‍

If you run a small nonprofit, here is the part nobody tells you about your chart of accounts: the COA itself is rarely where the books break. The feed into it is.

One Friday bank deposit holds a $300 snack-bar take, $200 in spirit wear, six donations split across three restricted funds, and a processor fee that turns a $5,000 gift into $4,912 on the deposit line. Someone (often a volunteer treasurer with a day job) has to hand-split that single deposit into ten separate COA lines before Sunday night.

So the honest plan for a small org is two parts. First, design the leanest viable COA: five categories, 30 to 50 accounts, numbered with the common convention, mapped to Form 990. Second, fix the upstream feed so revenue arrives already broken down by campaign and fund instead of as one mystery deposit.

This guide does both. You can grab the free Excel and Google Sheets template below, then work through the setup steps, numbering convention, Form 990 mapping, and the common mistakes that turn a clean COA into a 200-line mess.

‍

What is a nonprofit chart of accounts?

A chart of accounts (COA) is the numbered list of every account your nonprofit uses to record money in and money out. Think of it as the index for your books. Every donation, grant payment, payroll run, and office-supply purchase lands in one specific account, so you can pull a clean report when a funder, board member, or auditor asks.

The big difference from a for-profit COA is the Net Assets section. For-profits track owner equity. Nonprofits track funds that donors have restricted (you can only spend them on a specific program) and funds with no strings attached. That single difference flows through everything: how you record gifts, how you report on grants, and how you fill out Form 990.

Your COA does not have to be fancy. For a small org, 30 to 50 accounts across five categories is plenty. The free template below gives you a starting point you can customize in an afternoon.

For a small nonprofit: a lean COA you actually maintain beats a 200-line custom COA that nobody updates. Aim for "good enough to file Form 990 and answer a grant report in 10 minutes," not "perfect."

‍

Why your nonprofit needs a well-structured COA

A good COA is not paperwork for paperwork's sake. It saves you real time when it matters:

• Grant reports in minutes, not hours. When a funder asks how you spent their $10,000 program grant, a clean COA lets you pull the answer in two minutes instead of two evenings of digging through bank statements.

• Faster Form 990 prep. Categories that already map to Form 990 Part VIII (Revenue) and Part IX (Functional Expenses) cut your tax prep time sharply.

• Audit readiness. If you cross the federal Uniform Guidance threshold ($750,000 in federal funds spent in a year), or if a state or grantor requires an audit, a structured COA is what the auditor opens first.

• Honest board reporting. Restricted vs. unrestricted balances show up cleanly, so your board sees what you can actually spend.

• Catch problems early. Categories like "Bank fees" and "Payment processor fees" surface costs that otherwise hide inside revenue lines.

• Budgeting that works. Year-over-year category totals make next year's budget a 30-minute exercise instead of a guess.

For a small nonprofit: the COA pays for itself the first time a grant officer emails you "how did you spend our money?" and you answer the same day.

‍

Free nonprofit chart of accounts template (Excel + Google Sheets)

The template below is a lean 30 to 50 account starter COA, pre-numbered with the common convention, sorted into the five categories, with an instructions tab.

‍

What is inside:

• 45 pre-numbered accounts in one sortable tab, color-coded into the five nonprofit categories: Assets, Liabilities, Net Assets, Revenue, and Expenses

• Columns for Account Number, Account Name, Type, and Description

• Standard 1000s numbering convention (1000s Assets → 5000s Expenses)

• An Instructions tab with notes on customizing for your programs and funds

• Open it in Google Sheets (File → Make a copy), or export to Excel anytime via File → Download → .xlsx

Customizing takes about an afternoon: add rows for your specific programs, rename a few accounts to match how your team talks, and delete anything that does not apply.

‍

The 5 core account categories for nonprofits

Every nonprofit COA is built around five categories. Below is what each one tracks, the typical numbering range it uses (a common convention, not a federal rule), and the accounts a small org usually needs.

‍

1. Assets (1000 to 1999)

What your nonprofit owns: cash, receivables, prepaid expenses, equipment.

Typical accounts:

• 1010 Checking account

• 1020 Savings account

• 1030 Money market or reserve account

• 1100 Pledges receivable

• 1110 Grants receivable

• 1200 Prepaid expenses

• 1500 Equipment and furniture

• 1510 Accumulated depreciation

‍

2. Liabilities (2000 to 2999)

What your nonprofit owes: bills, payroll liabilities, loans, accrued PTO.

Typical accounts:

• 2010 Accounts payable

• 2020 Credit card payable

• 2100 Payroll liabilities

• 2110 Accrued PTO

• 2200 Deferred revenue (event tickets sold for next fiscal year)

• 2500 Loans payable

‍

3. Net Assets (3000 to 3999)

This is the section that makes a nonprofit COA different from a for-profit COA. Under FASB ASU 2016-14, nonprofits present net assets in exactly two classes: net assets with donor restrictions and net assets without donor restrictions. That replaced the older three-class system (unrestricted, temporarily restricted, permanently restricted). This two-class requirement is confirmed in the IRS 2025 Form 990 Instructions (Glossary; Part X Balance Sheet).

Typical accounts:

• 3010 Net assets without donor restrictions

• 3020 Net assets with donor restrictions (purpose)

• 3030 Net assets with donor restrictions (time)

• 3040 Net assets with donor restrictions (perpetual / endowment)

• 3100 Board-designated reserves

The Net Assets section only stays clean if the restriction is captured the moment the gift comes in, not three weeks later when the treasurer tries to remember which donations were for the building fund. That is a donor management problem, not a COA problem. Free donor management built for small nonprofits captures the fund designation at the donation form, so the restriction flows through to your COA automatically.

‍

4. Revenue (4000 to 4999)

All money in: contributions, grants, program fees, event income, investment income.

Typical accounts:

• 4010 Individual contributions

• 4020 Recurring giving

• 4030 Corporate contributions

• 4100 Foundation grants

• 4110 Government grants

• 4200 Program service fees

• 4300 Event revenue (tickets, sponsorships)

• 4400 Membership dues

• 4500 Investment income

• 4600 In-kind contributions

This is the section where the upstream feed matters most. If a $5,000 donation arrives in your bank as $4,830 after a 3.4% + $0.30 processor fee, your COA needs both: $5,000 in revenue and $170 in payment-processing expense. Most small orgs get this wrong because their fundraising platform only deposits the net. A 100% free online donation platform closes that gap by charging zero platform, transaction, and credit-card fees, so the deposit equals the gift. No platform fee, no transaction fee, no credit card fee. Ever.

‍

5. Expenses (5000+)

All money out, organized so you can split it into the three functional categories Form 990 expects: program, management and general, and fundraising.

Typical accounts:

• 5010 Salaries and wages

• 5020 Payroll taxes

• 5030 Benefits

• 5100 Program supplies

• 5110 Program travel

• 5200 Rent and utilities

• 5300 Office supplies

• 5400 Professional fees (legal, accounting)

• 5500 Fundraising expenses

• 5600 Payment processing fees

• 5700 Bank fees

• 5800 Insurance

For a small nonprofit: resist the urge to create a sub-account for every nuance. Start with one row per category above, then add sub-accounts only when you have a reporting need you cannot answer today.

‍

Standard account numbering convention

One thing to clear up first: GAAP does not require you to use any specific account numbers. The 1000s-for-assets, 2000s-for-liabilities pattern below is a widely used convention in nonprofit accounting, not a federal rule. You can use any system that is consistent and makes sense to your team. Most nonprofits adopt the convention because auditors, bookkeepers, and software defaults all expect it.

‍

‍

Why this works: the leading digit tells you the category at a glance, and the trailing digits leave room for sub-accounts. If you ever need to split "5100 Program supplies" into youth programs and adult programs, you can use 5110 and 5120 without renumbering everything. Most accounting software (QuickBooks, Aplos, Sage Intacct, Xero) defaults to a version of this convention out of the box.

For a small nonprofit: use four-digit numbers, leave gaps (every 10 or 100, not every 1), and you will never paint yourself into a corner.

‍

Sample nonprofit chart of accounts

Below is a complete 45-account lean COA you can copy or download from the template above. This is sized for a small-to-mid nonprofit. If your accountant suggests blowing this out to 200 lines, ask what reporting question the extra accounts answer that this one does not.

‍

‍

For a small nonprofit: 45 lines is the sweet spot. You can add 5 to 10 program-specific accounts and still be under 60 lines, which is what your auditor actually wants to see.

‍

How to set up your chart of accounts, step by step

Set aside a half-day. Open the template, work through these eight steps in order, and you will have a usable COA by the end of the afternoon.

‍

Step 1: Review how you track money today

Pull the last three bank statements, your most recent grant report, and your last Form 990 if you have filed one. Note every type of income and expense that shows up. This is your starting list.

‍

Step 2: Identify your reporting needs

List the questions you have to answer at least once a year: grant reports by funder, Form 990 functional expenses, board financials by program, audit trial balance. Each answer becomes an account or sub-account.

‍

Step 3: Choose your numbering system

Use the 1000s convention from the table above unless you have a hard reason not to. Stick with four digits and leave gaps of 10 between accounts.

‍

Step 4: Set up your five main categories

In your template (or accounting software), confirm the five top-level categories: Assets, Liabilities, Net Assets, Revenue, Expenses. Every account you add lives under one of these.

‍

Step 5: Add sub-accounts for programs and funds

If you run three programs, you might add 5101, 5102, 5103 under "Program supplies." If you have two restricted funds, set up 3021 (building fund) and 3022 (scholarship fund) under "Net assets with donor restrictions." Do not over-build. You can add more later.

‍

Step 6: Configure your accounting software (and fix the upstream feed)

Import the COA into your accounting software. This is also the moment to be honest about where your COA gets messy in practice. For most small nonprofits, the highest-volume rows are revenue lines: donations, recurring gifts, event tickets, store sales, raffles. If those arrive in your bank as one lump deposit per week with a processor fee baked in, your treasurer is hand-splitting that deposit into ten COA lines every Sunday night.

The fix is upstream of the COA, not inside it. Zeffy's free QuickBooks integration pushes payouts to QuickBooks already broken down by campaign and fund, mapped to the accounts and classes you chose during setup. Other fundraising platforms charge $17 to $29 a month for QuickBooks sync; with Zeffy it is free. Your treasurer opens the deposit, clicks "Match," and reconciliation is done.

‍

Step 7: Test with sample transactions

Before you go live, run five or six real transactions through: a $50 donation, a $1,000 grant deposit, a payroll run, an office-supply purchase, a credit-card payment to a vendor. Walk each one to its account. If you cannot decide where it goes, your account names need clarification.

‍

Step 8: Document and share

Write a one-page "how we use our COA" doc: which accounts get which transactions, who has the final call on judgment cases, when you will review the COA. Share it with your bookkeeper and treasurer.

‍

‍

For a small nonprofit: the half-day investment here saves you a full day every month for the rest of the year. The upstream feed fix saves you a weekend a month.

‍

3 types of nonprofit chart of accounts

1. Unified Chart of Accounts (UCOA)

UCOA is a standardized framework built specifically for US nonprofits, with account codes pre-aligned to Form 990 line items. It is the most thorough option and the most complex (the full UCOA runs over 200 accounts).

Right fit when: you are a large nonprofit (typically $5M+ in revenue) with multiple programs, multiple funders, and a dedicated accounting staff.

‍

2. Operating chart of accounts

An operating COA focuses on day-to-day activity: regular income, regular expenses, the accounts a small team actually uses every week. This is the lean approach the template above takes.

Right fit when: you are a small or mid-sized nonprofit (under $5M revenue, fewer than five programs) and want a COA you can maintain without a full-time accountant.

‍

3. Group chart of accounts

A group COA uses a parent structure with child sub-charts for each location or program. The parent enforces consistency; the children let each unit track its own specifics.

Right fit when: you run multiple chapters, branches, or distinct programs that each need their own books but consolidate into one financial statement.

For a small nonprofit: start with operating. You can graduate to UCOA or group later if you actually need to. Most small orgs never do.

‍

How your COA aligns with Form 990

If your COA categories already match the structure of Form 990, your tax prep collapses from a weekend project to an afternoon. The two parts to align with are Part VIII (Statement of Revenue) and Part IX (Statement of Functional Expenses), per the IRS 2025 Form 990 Instructions.

‍

‍

Salaries (5010) and benefits (5020, 5030) typically split across all three functional columns. Track the allocation with timesheets or estimated percentages, and document your method.

For a small nonprofit: if you only do one thing on this list, set up the three functional-expense buckets (program, management, fundraising) inside your accounting software now. Backfilling that split at year-end is miserable.

‍

6 best practices for maintaining your COA

1. Use main accounts and sub-accounts on purpose

Main accounts handle category-level reporting (total program expense). Sub-accounts handle drill-down (program supplies vs. program travel). Do not create a sub-account unless you have a real reporting question it answers.

‍

2. Keep account names clear

"Miscellaneous" is the enemy. Use names like "Youth program supplies" or "Annual gala expenses." If a new volunteer cannot guess where a transaction belongs from the account name, the name is wrong.

‍

3. Design for flexibility

Leave numbering gaps. Avoid hyper-specific accounts that lock you in. If a new revenue stream appears next year, you should be able to add it with one new line, not a reorg.

‍

4. Pair your COA with the right software

A spreadsheet works for the first year. After that, accounting software pays for itself. See the software section below.

‍

5. Review annually during budget planning

Once a year, during budget season, scan your COA for unused accounts, missing accounts, and renaming opportunities. Combine accounts that always move together; split accounts that hide useful detail.

‍

6. Get professional input when stakes are high

If you are filing your first Form 990, going through your first audit, or onboarding a major federal grant, a nonprofit-experienced bookkeeper or CPA for a few hours is cheap insurance. You do not need them year-round.

For a small nonprofit: a 30-minute annual review of the COA prevents 90% of the "why does our budget never tie out?" problems.

‍

Common chart of accounts mistakes to avoid

• 1. Too many accounts. 200 lines is not "thorough," it is unmaintained. If you cannot fill out a transaction without scrolling, you have too many accounts.

• 2. Mixing restricted and unrestricted in one bucket. If your "Donations" account holds both general gifts and restricted building-fund gifts, you cannot answer the building-fund donor when they ask how their gift was used. Set up the restriction at the source.

• 3. Using "Miscellaneous" as a real account. Every "Miscellaneous" transaction is a deferred decision. Make the decision once and name a real account.

• 4. Skipping the functional-expense split. If you do not track program vs. management vs. fundraising splits during the year, Form 990 Part IX becomes a guess.

• 5. Never updating the COA. The org grows. The COA does not. Two years later, half your transactions live in "Other revenue." Annual review fixes this.

• 6. No documentation. The treasurer who set up the COA leaves. The new treasurer guesses where everything goes. Write the one-page guide.

For a small nonprofit: the most common failure mode is over-building the COA and then quietly dumping everything into "Other" because no one remembers the rules. Lean beats elaborate every time.

‍

Nonprofit accounting software that works with your COA

Your COA lives inside a general ledger. The GL lives inside accounting software. Here are the four options most small and mid-sized nonprofits actually use, and how Zeffy fits in as the upstream feed (not a replacement for any of them).

‍

QuickBooks Online

The default for nonprofit accounting in North America. Most auditors, bookkeepers, and treasurers already know it. Strong nonprofit ecosystem, class tracking for programs, broad integration support.

Right fit when: you are a US or Canadian nonprofit and want the easiest hire-a-bookkeeper experience. Pair it with Zeffy's free QuickBooks integration so your fundraising revenue flows in pre-sorted.

‍

Aplos

Purpose-built for nonprofits with native fund accounting and Form 990 support. Less universal than QuickBooks but stronger out-of-the-box for restricted-fund tracking.

Right fit when: you have heavy restricted-fund activity (church, foundation, scholarship org) and want fund accounting without configuring it yourself. Aplos is a paid product after the trial.

‍

Sage Intacct

Enterprise-grade. Multi-entity consolidation, deep dimensions, strong audit trails.

Right fit when: you are a larger org ($5M+ revenue), multi-entity, or facing a federal single audit. Overkill for a small org.

‍

Xero

Clean interface, strong outside the US. Less nonprofit-specific tooling than QuickBooks or Aplos but a solid GL.

Right fit when: you are outside North America or already use Xero for another entity.

For any of these, your fundraising data is the layer upstream of the accounting system, not a competitor to it. If you are on Xero, Aplos, or even a spreadsheet, Zeffy's free public API lets you pull payment, contact, and campaign data into whatever GL or COA you use, without paying for a sync tool. You can also see our deeper nonprofit accounting software guide for a full comparison.

Zeffy is not a general ledger or a replacement for QuickBooks, Aplos, Sage, or Xero. The QuickBooks sync is one-way (Zeffy to QB) and covers future payouts (it does not backfill history). Refunds today require a manual journal entry in QuickBooks; they do not auto-sync.

Zeffy is trusted by 100K+ nonprofits who have raised $2B+ on the platform. It is 100% free: no platform fee, no transaction fee, no credit card fee. Ever.

For a small nonprofit: QuickBooks Online plus Zeffy upstream is the lowest-effort stack for a North American org. Use the time you save on something that grows revenue.

For more on nonprofit financial operations, see our guides to nonprofit accounting, nonprofit bookkeeping, and nonprofit financial statements.

‍

‍

‍

‍

‍

‍

‍

‍

‍