Public Administration Chart of Accounts: Grant Funds, Restricted Revenue, and Program Costs
A complete guide to setting up your public administration chart of accounts in QuickBooks. Learn how to separate restricted grant revenue from general fund dollars, track deferred grant revenue, and keep direct program costs apart from administrative overhead.
If you run the books for a municipal department, special purpose district, housing authority, or any grant-funded public program, you've probably landed in QuickBooks Online because a dedicated government ERP system is out of reach for an entity your size. The problem is that QuickBooks' default chart of accounts assumes a private business with one pool of cash and one revenue stream. Public entities don't work that way — grant dollars, property tax revenue, and program fees are legally distinct pools of money under fund accounting principles that fall under Generally Accepted Accounting Principles (GAAP), specifically the standards set by the Governmental Accounting Standards Board (GASB). Mixing them into one "Income" account isn't just messy bookkeeping. It makes it impossible to show a grantor how their money was spent, or to tell your board which programs are actually self-sustaining.
This guide walks through the accounts a public administration entity needs beyond the QuickBooks default, using the structure our chart-of-accounts template applies to government agencies and public-sector organizations.
Why a Generic Chart of Accounts Fails Public Administration Entities
Government and public-sector accounting differs from a typical small business in ways a generic chart of accounts can't represent:
- Restricted vs. unrestricted money — a dollar of grant funding obligated to a specific program is legally different from a dollar of general tax revenue, and that distinction has to show up on the books, not live in a side spreadsheet.
- Grant cash isn't automatically grant revenue — funds received before the qualifying work happens are a liability, not income, until the agency actually earns them.
- Direct program costs vs. administrative overhead — most grants cap what share of funding can go to administration, so the two need separate account ranges to report against.
- Revenue by source — property tax, federal grants, state grants, and intergovernmental transfers each need their own line for budget and compliance reporting.
Tracking Grant Funds and Restricted Revenue
| Account | Number | Purpose |
|---|---|---|
| Grant Funds Account | 1030 | Dedicated bank account for grant-funded programs |
| Government Grants Receivable | 1210 | Federal and state grant funds receivable |
| Deferred Grant Revenue | 2230 | Grant revenue received in advance of expenditure |
| Fund Balance | 3000 | Unrestricted fund balance |
| Restricted Fund Balance | 3100 | Restricted fund balance for specific purposes |
| Tax Revenue - Property | 4000 | Property tax revenue |
| Grant Revenue - Federal | 4100 | Federal grant funding |
| Intergovernmental Revenue | 4200 | Revenue from other government entities |
| Grant-Funded Labor | 5000 | Salaries for grant-funded program staff |
| Program Services - Public Safety | 5200 | Direct costs for public safety programs |
| Administrative Salaries | 6000 | Administrative staff salaries |
Grant Funds Account keeps grant cash physically separate from the general operating account, which most grant agreements require anyway. Government Grants Receivable and Deferred Grant Revenue work together to handle timing: when a grant is awarded but not yet paid, the receivable records what's owed; when cash arrives before the work is done, it sits in Deferred Grant Revenue until the agency earns it. On the equity side, Fund Balance and Restricted Fund Balance separate money the agency can use for any government purpose from money that's obligated to a specific program — the same restricted-vs-unrestricted distinction that shows up throughout state and local government fund accounting.
Separating Direct Program Costs from Administrative Overhead
The template splits program costs (5000-5999) from administrative expenses (6000-6999) on purpose:
- Grant-Funded Labor (5000) — salaries for staff whose time is spent directly on a grant-funded program, booked as a direct program cost rather than a general payroll expense
- Program Services - Public Safety (5200) — direct, non-labor costs of running a specific program
- Administrative Salaries (6000) — the salaries of staff who run the agency itself, kept in a separate range from program labor
This split matters because most grant agreements, federal and state alike, cap the share of funding that can go to administration — often somewhere in the 10-15% range. If a program coordinator's payroll lands in Administrative Salaries instead of Grant-Funded Labor, the agency's indirect cost ratio looks wrong on paper even though nothing improper happened. Keeping the two ranges separate from the start is what makes a clean cost report possible at grant closeout.
How This Gets Booked
A grant paid in advance. A county receives a $50,000 federal grant for a public safety program, and the funds land in the bank before any of the grant-funded work happens. That $50,000 debits Grant Funds Account (1030) and credits Deferred Grant Revenue (2230) — it's cash in hand, but it isn't revenue yet, because the agency hasn't earned it by incurring the costs the grant is meant to cover. As staff work the program and the agency records Grant-Funded Labor (5000) and Program Services - Public Safety (5200) against it, a matching amount moves out of Deferred Grant Revenue and into Grant Revenue - Federal (4100). By year-end, only the unspent portion of the grant should still sit in the deferred revenue account.
Splitting a coordinator's time. A program coordinator spends 70% of their week running a grant-funded social services program and 30% on general agency administration. Instead of one payroll expense, the agency splits the paycheck: 70% posts to Grant-Funded Labor (5000) under the program, and 30% posts to Administrative Salaries (6000). At grant reporting time, the agency can point to the general ledger and show exactly what share of the coordinator's pay was a direct program cost — the number the grantor actually asked for.
Get Started
Our public administration chart of accounts template includes all of these accounts pre-configured — grant funds tracking, restricted fund balance, and the direct-program-cost split grantors expect. Import it into QuickBooks in 60 seconds.