Short answer: Unspent grant money isn’t extra money. Before December 31, list every open grant with its award, spending to date, balance and end date. Release restrictions only where the terms were met. Flag grants that may need a spend-down plan, an extension or a refund. Then show the board each fund’s balance in January.
By the Rektio Accounting team. Rektio is a bookkeeping and controller team in Fishers, Indiana. We keep monthly books, grant tracking and board packages for 501(c)(3) nonprofits with $1M-$15M in revenue across the US, and we prepare Form 990 for our monthly nonprofit clients.
Why does year-end get so messy for grants?
Short answer: Because grants run on their own calendars, and the books run on yours.
Here’s the December we see every year. The executive director thinks there’s “about $40,000 left” on a foundation grant. Program staff swear they spent it. The books show the money sitting in one income account with no way to tell which grant it came from. The board meets in three weeks and the treasurer wants a clean number.
You can’t fix that by staring at the bank balance. A nonprofit can have plenty of cash and still be spending money it doesn’t really have, because part of that cash belongs to donors’ restrictions.
Year-end is when this catches up with you. Grants have end dates. Funders want reports. And the board wants to know whether next year starts in the black or in the hole.
What should I pull together first?
Short answer: A one-line-per-grant list. If you can’t build it in an afternoon, that’s your first finding.
For every open grant or restricted gift, get:
| Column | Why it matters |
|---|---|
| Funder and grant name | So nobody argues about which grant is which |
| Award amount | The total you were promised |
| Received to date | Cash in vs. promised |
| Spent to date | Expenses coded to that grant |
| Balance left | Award or received, minus spent |
| Grant end date | When the money has to be used by |
| Report due date | When the funder expects an update |
| Type | Paid up front, or paid back after you spend (reimbursement) |
In QuickBooks Online, the cleanest way to get “spent to date” is to tag every grant expense with that grant’s project or class all year. If expenses weren’t tagged, someone has to go back and code them now. That’s painful in December. It’s worse in March.
Which balances carry over, and which don’t?
Short answer: Money restricted for a purpose stays restricted until you’ve done the thing. Money with a deadline may have to be spent, extended or sent back. Read the grant agreement.
Sort the list into four piles:
- Spent as agreed. The purpose or time limit was met. Release the restriction for what you spent. That’s a journal entry from net assets with donor restrictions to net assets without donor restrictions. It doesn’t create income or move cash. It shows the money did its job.
- Still in progress, no deadline problem. The balance carries into next year as restricted. It shows on the balance sheet that way, and the board should see it.
- Deadline coming, money left. Look at the agreement now, not in January. Can you spend it on allowed costs in time? Can you ask for a no-cost extension? Funders are far more flexible when you ask before the end date than after.
- May have to go back. Some agreements require unspent funds to be returned. Know that number before the board meeting, not after.
Reimbursement grants are a different animal. You spend first and bill the funder later. The question at year-end is whether you’ve billed for everything you spent, and whether anything you spent isn’t allowed under the grant. Unbilled grant costs are money you’re owed. Don’t leave them sitting.
When a grant has conditions that haven’t been met yet, or the right timing for revenue is unclear, settle the treatment with your outside accountant before you close the year. Don’t guess on those.
What are the common year-end mistakes?
Short answer: Spending restricted money on general bills, releasing restrictions too early, and coding grant costs to the wrong fund.
- Using restricted cash to make payroll and planning to “put it back.” That’s not a bookkeeping shortcut. It’s spending donor money on something they didn’t give it for.
- Releasing the whole grant on receipt. Release as you spend, or as the time restriction passes.
- One “grants” income account for everything. You’ll never get balances by funder that way.
- Shared costs with no method. If rent and salaries are split across grants, use the same allocation method every month and write it down.
- Grant balances that never move. A balance that hasn’t changed in three months as the end date gets close is the first thing a treasurer should ask about.
What should the board see in January?
Short answer: A one-page summary and a fund-by-fund table, not a stack of raw reports.
Your January board package should answer three questions fast: How much cash do we have? Are we on budget? Is donor money being used the way donors asked?
At minimum:
- Statement of financial position, with net assets with and without donor restrictions shown separately
- Statement of activities with budget vs. actual
- A restricted funds table: opening balance, received, released, closing balance for each fund
- A list of grants ending in the next 90 days and any balance at risk
- Cash on hand, and how many months of expenses it covers
We wrote a monthly checklist for nonprofit board treasurers and a guide to tracking restricted funds and grants in QuickBooks Online. Use them together.
How do I make next December easier?
Short answer: Do the year-end list every month. Then December is just month twelve.
- Tag every grant expense to its project or class when you enter it, not later.
- Run a by-grant balance report every month and put it in the board package.
- Keep a grant calendar with end dates and report due dates.
- Release restrictions monthly as you spend.
- Have someone other than the person who enters transactions review the grant report.
How does Rektio help?
Short answer: We keep the books every month, track each grant and restricted fund, and build a board package customized to your organization. For monthly clients, we also prepare Form 990 from the books we keep all year.
A team of two or three people does your bookkeeping and controller close in QuickBooks Online. A U.S.-based account manager reviews the work before your staff or board sees it. We track grant balances and restricted funds monthly, so year-end is a review, not a rescue. Pricing starts at $1,500 a month, scoped to your organization, month-to-month with 30 days’ notice. If the books are behind, catch-up is built into onboarding.
Learn more on our nonprofit page. Call or text (463) 215-0968, or book a call.
FAQ
What happens to unspent restricted grant money at year-end?
It depends on the grant agreement. Money restricted for a purpose usually stays restricted and carries into the next year until it’s used as intended. Grants with an end date may need to be spent, extended or returned. Check the agreement before December 31.
When should a nonprofit release restricted funds?
When the donor’s purpose or time restriction is met, usually as you spend the money on what it was given for. The release is an entry from net assets with donor restrictions to net assets without donor restrictions. It doesn’t create income or move cash.
How do I track grant balances in QuickBooks Online?
Tag every grant’s income and expenses to its own project or class all year. Then run a report by project or class to see received, spent and the balance left for each grant.
Can we ask a funder for more time to spend a grant?
Often, yes. Many funders will consider a no-cost extension if you ask before the grant ends and explain the plan. Asking after the end date is much harder.
What should a nonprofit board see about grants each month?
A restricted funds table with each fund’s opening balance, money received, money released and closing balance, plus a list of grants ending soon with any balance at risk.
Does Rektio work with nonprofits outside Indiana?
Yes. Rektio is based in Fishers, Indiana and works with 501(c)(3) nonprofits across the US in QuickBooks Online.
Do you prepare Form 990?
Yes, for monthly nonprofit clients, from the books we keep all year. We don’t take standalone 990 work.
