Your Chart of Accounts Is Your Grant Tracking System
Somewhere on your desktop there is a spreadsheet that exists only to reconcile grant spending back to the general ledger. Someone rebuilds it every month. That spreadsheet is not a tool, it is a symptom. The work it does belongs in your chart of accounts.
Once you know what basis your books are kept on, the next question is whether the structure of those books can tell you what you spent, on which award, in which category, without anyone doing arithmetic by hand.
What a grant ready chart of accounts has to do
The federal requirement reads like a specification, because that is what it is. 2 CFR 200.302(b) lists seven things your financial management system has to do, and five of them are structural. Identify every federal award you received, down to the Assistance Listings number, the federal award identification number, the year, and the agency. Disclose the financial results of each award accurately and currently. Keep records of the amount, source, and expenditure of federal funds, supported by source documentation. Maintain control and accountability over the funds. Compare expenditures against the budget for each award.
2 CFR 200.302(b)(3). Your records must identify the amount, source, and expenditure of federal funds, supported by source documentation. Amount, source, and expenditure, for every award, each one traceable to a document.
Read the whole list as a design brief. It tells you the ledger has to answer several questions at once: whose money is this, which award and which budget period does it belong to, what kind of cost is it, how does it compare to what you budgeted, and what document proves it. A chart of accounts built only around natural expense types answers one of those.
The dimensions that carry the weight
Most accounting systems give you more structure than organizations use. The natural account tells you what you bought, so salaries, rent, travel, and supplies each get a number. Everything else has to come from other dimensions.
You need a funding source dimension so every award has its own identifier, and it has to distinguish budget periods, because year one and year two of the same award are separate reporting universes. You need a program or department dimension so shared costs have somewhere to land before allocation. Local governments already have part of this through fund accounting, which is why a city can often answer the fund question instantly and still struggle to isolate a single award inside it.
Then map your cost categories to the federal budget categories you actually report against, so personnel, fringe, travel, equipment, supplies, contractual, construction, other, and indirect each have a home in the ledger. When the categories in your books match the categories on the budget you submitted, budget to actual reporting stops being a translation exercise. The action plan for the 2026 Uniform Guidance changes puts this near the top for a reason, since more of what you report is about to be checked against what you spent.
If your ledger cannot produce a report your funder asked for, the ledger is incomplete, not the report.
The spreadsheet is the tell
You can diagnose a chart of accounts problem without opening the accounting system. Listen for what people do at month end.
Warning signs
- One account named Grants, or Grant Revenue, holding several awards at once.
- Someone manually splits a payroll line across awards after the fact, every pay period.
- A program manager cannot see how much of their award is left without emailing finance.
- Indirect cost recovery gets calculated in a spreadsheet and journaled in as a single entry.
- Award year one and year two share the same accounts, and the cutoff lives in a memory.
None of these mean anyone did anything wrong. They mean the structure stopped fitting the work, usually around the second or third federal award. The organizations that get caught by this are the ones that grew their funding faster than they grew their ledger.
How to restructure without breaking the audit trail
Restructuring a chart of accounts mid year, mid award, is how you create an audit finding while trying to prevent one. Sequence it instead.
Add dimensions before you renumber accounts. Most systems let you introduce a project or grant segment without touching the existing account structure, which gets you award level tracking without invalidating a single prior entry. Time the change to a fiscal year boundary or the start of a new award, so no reporting period gets split down the middle. Build a written crosswalk from old codes to new ones and keep it with your accounting policies, because that document is what lets a reviewer three years from now follow a transaction across the change. Bring your auditor in before you build, not after, since they will tell you in one conversation what they need to see and save you a rebuild.
Then run both structures in parallel for one reporting cycle and reconcile them. If the numbers tie, the new structure is trustworthy. If they do not, you found the problem while it was still cheap.
A chart of accounts that isolates awards, periods, and cost categories does more than satisfy a reviewer. It gives program staff a real burn rate, gives finance a drawdown they can support, and turns your reporting into a query instead of a project. Build that structure, and the next question becomes how you split the costs that genuinely serve more than one program.
Download the Chart of Accounts Conversation Guide, a free worksheet that gives you the structure to bring to your finance team and the specific questions that surface where your current setup falls short.
