Nonprofit Grant Tracking: See What's Left on Every Grant Today

Nov 11
5 min read
Updated: 5 days ago

How much is left on your largest grant? Today. Not last quarter.
If you need a day and two spreadsheets to answer that, you are not alone. Nonprofit grant tracking breaks down in the same place for most small organizations: the money is spread out, and the reporting is rebuilt by hand.
In this article, you will learn:
Why grant balances end up living in spreadsheets
A five-step setup for nonprofit grant tracking in QuickBooks Online
How to give a program director a report they can read without finance training
Five questions to check your own setup tonight
Why nonprofit grant tracking breaks
Here is a pattern we see often.
A nonprofit runs three funding streams. Each sits in its own bank account. Each has its own spreadsheet.
Every funder report is a rebuild. Someone exports transactions, pastes them into a workbook and reconciles by hand.
Then the month will not close. A stack of grant payments was never coded to a funder.
Nobody can say which grant paid for what until someone traces each one.
None of that is a staff problem. It is a structure problem.
Your team can only report what the books were set up to capture. If the accounting file does not know which funder paid for an expense, no amount of effort at month-end will fix that quickly.
What good grant tracking answers
Nonprofit grant tracking is how you record each grant's budget, income and spending so you can see the remaining balance by funder and by program at any time.
A working setup answers five questions from one report:
1. How much did each funder give or commit?
2. How much have you spent against each grant?
3. How much is left on each grant today?
4. Which programs did each grant pay for?
5. Are you over or under the approved budget, line by line? If any answer needs a spreadsheet, the structure is incomplete.
How to set up nonprofit grant tracking in QuickBooks Online
Five steps. Each one removes a manual task.
Step 1: Move every account into one accounting file
Three bank accounts can stay three bank accounts. They should not mean three sets of books.
Connect every account to one QuickBooks Online file. One chart of accounts your list of income and expense categories covers the whole organization.
You now run one close, one set of reports and one audit trail.
Step 2: Use locations for funding streams and classes for programs
QuickBooks Online gives you two labels you can put on transactions. Use one for where the money came from and one for what it paid for.

With both in place, one profit and loss report splits either way: by funder, by program, or both.
One practical note: a location applies to the whole transaction, while classes can be set line by line. If one bill is shared by two funders, split it into two transactions or record a monthly allocation entry.
Step 3: Load the approved grant budget
Enter each approved grant budget into QuickBooks Online's budget tool, split by location and class.
Now "how much is left" is a Budget vs. Actuals report. Nobody recalculates it by hand.
Anyone with access gets the same answer on the same day.
Step 4: Build a one-page summary for program directors
Your program director does not need a full financial statement. They need to know if they can spend.
Build a short summarized profit and loss statement a one-page view of money in and money out for their program. Keep it to:
Money received this month and year to date
Money spent this month and year to date
Budget remaining
If they can read it in two minutes without a finance background, it works.
Step 5: Write the close down with screenshots
The close the steps you run each month to finalize the books should not live in one person's head.
Write each step down. Add a screenshot for every screen. Note what to check and what "done" looks like.
If the person who runs the close leaves, the process stays.
Grant compliance starts with your chart of accounts
Grant compliance is not paperwork you do at the end. It is a chart of accounts decision you make at the start.
Every funder report pulls from how transactions were coded on day one. If the code is missing, the report is a rebuild. If the code is right, the report is a click.
So ask the question before the first dollar arrives: what will this funder ask us to report, and does our setup capture it?
Check your setup tonight: five questions
Can you see the remaining balance on your largest grant without opening a spreadsheet?
Is every grant payment from last month coded to a funder?
Does your program director get a report they actually read?
Is your approved grant budget inside your accounting system?
If your bookkeeper left tomorrow, could someone else close the month?
One "no" is a fix you can start this week.
Common grant tracking mistakes
Coding grant spending to a general expense with no funder label. It saves a minute now and costs hours at report time.
Tracking grants in a memo field. Typing a grant code into the description works only as long as one careful person types it every time.
Mixing grants you receive with grants you award. If you pass money to partner organizations, define which balance people mean when they ask "how much is left." They are two different reports.
Keeping the budget outside the books. A budget in a separate workbook means every comparison is manual.
Conclusion
Nonprofit grant tracking does not need more spreadsheets. It needs one accounting file, two labels used consistently, the budget loaded where the actuals live, a one-page report for program staff and a written close.
Set that up once and "how much is left?" becomes a report you run, not a project you start.
Get the setup
Any questions? Email to ktorres@finanzeal.com
Katherine Torres | CEO & Founder | Finanzeal Solutions, LLC
FAQ
What is nonprofit grant tracking? It is how you record each grant's budget, income and spending so you can see the remaining balance by funder and by program at any time, from your accounting system.
Can QuickBooks Online track grants? Yes. Use locations for funding streams, classes for programs and the budget tool for each approved grant budget. Classes, locations and budgets need QuickBooks Online Plus or Advanced.
Should I use classes or locations for grants? Use both, for different questions. Locations answer "who paid?" Classes answer "what did it pay for?" Together, one report splits both ways.
How many classes and locations can I use in QuickBooks Online? QuickBooks Online Plus allows up to 40 classes and locations combined. Advanced has no cap. If you run many grants and programs, plan your list before you build it.
Do I need a separate bank account for each grant? Not usually. Read your grant agreement. Some funders require a separate account. If yours does not, one file with funder labels is enough to track the balance.
How often should I check remaining grant balances? At least once a month, at close. Program staff should see their one-page summary every month, before they commit new spending.
Is grant money revenue when it hits the bank? Not always. A grant with conditions is earned as you meet those conditions. Treatment depends on the agreement. Confirm with your auditor before you record it.




Comments