Grant Tracking and Restricted Funds: Why Nonprofit Bookkeeping Needs More Detail
For many nonprofits, the books look simple at first. Money comes in, bills are paid, and the bank balance seems to tell the story. But once the organization receives grants, donor-restricted contributions, scholarship funds, program-specific gifts, or board-designated funds, basic bookkeeping is no longer enough.
Grant tracking and restricted fund bookkeeping require more detail because not every dollar can be used the same way. Some funds may be limited to a specific program. Some grants may have spending deadlines. Some donations may be restricted by purpose. Some funds may need to be reported separately to the board, grantor, or tax preparer.
If your nonprofit does not track these details clearly, leadership may not know how much money is truly available for general operations. That can create cash flow stress, grant reporting problems, board confusion, and extra work when preparing annual filing support.
Why Restricted Fund Bookkeeping Is Different
Nonprofit bookkeeping is different from regular small business bookkeeping because the organization is accountable not only for income and expenses, but also for how certain funds are used. A business owner usually wants to know whether the company made a profit. A nonprofit board also needs to know whether funds were used according to donor, grantor, board, and mission expectations.
This is especially important when money is restricted. Restricted funds may include:
- Grant funds awarded for a specific program
- Donor gifts restricted to a specific purpose
- Scholarship funds limited to eligible recipients
- Capital campaign funds restricted for building or equipment needs
- Church or ministry funds designated for outreach, missions, or benevolence
- Foundation funds approved for a particular project
- Board-designated funds set aside for a specific internal purpose
When these funds are mixed into general income without tracking, the reports may show cash in the bank but not explain whether that cash is actually available to spend freely.
Grant Tracking Is More Than Recording a Deposit
A common mistake is treating a grant like a normal donation deposit. The deposit is recorded, the money lands in the bank, and the organization moves on. But grant-funded nonprofits often need to track more than the amount received.
Good grant tracking may include:
- The grantor or funding source
- The approved grant period
- The program or purpose of the grant
- Restrictions on allowable expenses
- Required matching funds, if applicable
- Reporting deadlines
- Budgeted versus actual spending
- Remaining grant balance
- Supporting documentation for expenses
- Any funds that may need to be returned or carried forward
This level of detail helps the executive director, treasurer, and board understand whether the organization is spending grant funds properly and whether reports can be prepared without rebuilding the numbers from scratch.
Common Problems With Grant and Restricted Fund Tracking
Most restricted fund problems start small. A deposit is coded too broadly. A grant expense is not tagged. A spreadsheet is created outside QuickBooks but never reconciled to the accounting file. Over time, these small gaps can become a major cleanup project.
1. Restricted Funds Are Mixed With General Operating Money
This is one of the biggest problems. A nonprofit may have $80,000 in the bank, but if $60,000 is restricted for a specific grant or program, the organization may only have $20,000 available for general operating needs.
Without restricted fund tracking, the board may unintentionally overestimate available cash and make spending decisions based on incomplete information.
2. Grant Expenses Are Not Matched to the Correct Grant
Some organizations track grant income but do not track expenses by grant. This makes it hard to know whether a grant has been fully spent, overspent, or underspent.
When grant reports are due, staff may have to search through bank statements, receipts, vendor records, payroll details, and spreadsheets to reconstruct the activity.
3. QuickBooks Is Not Set Up for Nonprofit Reporting
QuickBooks Online can be useful for nonprofits, but the setup matters. If the chart of accounts, classes, locations, customers, projects, or tags are not designed around the organization’s reporting needs, the reports may not answer the right questions.
A good setup should help leadership see income and expenses by program, grant, restriction, or activity when needed.
4. Grant Reports Depend on Manual Spreadsheets
Spreadsheets can be helpful, but they should not become the only place where grant balances are tracked. If QuickBooks says one thing and the spreadsheet says another, the organization may not know which report to trust.
Cleanup often involves comparing QuickBooks, bank statements, grant agreements, and spreadsheets so the records can be brought into alignment.
5. Board Reports Do Not Show Restricted Versus Unrestricted Funds
A board report that only shows total cash and total income may not be enough for a grant-funded nonprofit. Board members need to understand which funds are restricted and which funds are available for general operations.
Clear reporting helps the board make better decisions, especially when approving budgets, hiring staff, launching programs, or committing to future expenses.
Practical Checklist for Grant Tracking and Restricted Funds
If your nonprofit receives grants or restricted contributions, use this checklist to review whether your bookkeeping system is detailed enough.
- List each grant and restricted fund separately. Include the funding source, purpose, grant period, and restrictions.
- Review grant agreements and donor restrictions. Confirm what expenses are allowed and whether there are reporting deadlines.
- Separate restricted and unrestricted activity. Do not rely only on the bank balance to determine available funds.
- Track expenses by grant or program when needed. Use a consistent method in QuickBooks Online or supporting schedules.
- Reconcile bank accounts monthly. Grant reports are more reliable when the bank activity agrees to the accounting records.
- Compare budget to actual spending. Review whether grant spending is on track and whether restrictions are being followed.
- Keep support for grant expenses. Maintain invoices, receipts, payroll records, reimbursement forms, and approval documentation.
- Review restricted fund balances with the board. Make sure board members understand what money is available and what money is limited.
- Update reports before Form 990 preparation. Clean records can help support annual filing information and reduce last-minute confusion.
- Create a monthly review process. Grant and restricted fund tracking works best when it is maintained throughout the year, not recreated at year-end.
How Better Tracking Helps the Board
Board members do not need to see every transaction, but they do need reports that help them understand the organization’s financial position. For nonprofits with grants or restricted funds, a basic profit and loss report may not be enough.
Useful board reporting may include:
- A profit and loss statement by program or activity
- A budget versus actual report
- A restricted fund balance summary
- A grant spending summary
- A balance sheet that clearly shows assets, liabilities, and net assets
- A cash flow or available cash summary
- Notes explaining major changes, unusual items, or upcoming deadlines
These reports help the board move beyond the question, “How much is in the bank?” A better question is, “How much money is available, what is restricted, and are we using funds in line with our mission and obligations?”
Board report note: Board financial reports prepared as part of bookkeeping support are generally for internal management and board use unless a different engagement is specifically agreed to in writing. Small Business Accounting Inc. does not claim to provide CPA audit, review, or compilation services.
How Grant Tracking Supports Form 990 Preparation
Clean grant and restricted fund tracking can also help with annual filing support. Many tax-exempt organizations have an annual IRS filing requirement unless an exception applies. Depending on the organization’s gross receipts, total assets, and facts, many nonprofits may file Form 990-N, Form 990-EZ, or the full Form 990.
For many exempt organizations, Form 990-series returns are generally due by the 15th day of the 5th month after the end of the organization’s accounting period. Requirements can vary depending on the organization’s tax year, exemption status, organization type, gross receipts, assets, and activities.
Grant tracking and restricted fund bookkeeping can help organize information such as:
- Total contributions, grants, and program revenue
- Program service expenses
- Management and general expenses
- Fundraising expenses
- Net assets with and without donor restrictions
- Grant-related activity and supporting documentation
- Board-approved financial information
When the books are clean, the annual filing process can be more efficient. When the books are messy, the organization may need cleanup before reliable filing support can be prepared.
Compliance note: This article provides general educational information and is not legal or tax advice for any specific organization. IRS filing requirements, filing thresholds, deadlines, penalties, extension options, and tax-exempt status issues can vary based on the organization’s facts. Always confirm current IRS and state requirements before filing.
Red Flags That Your Nonprofit Needs Better Fund Tracking
Your nonprofit may need stronger grant tracking or restricted fund bookkeeping if any of these issues sound familiar:
- The board does not know how much cash is truly unrestricted.
- Grant reports take hours or days to rebuild manually.
- Grant expenses are tracked in spreadsheets that do not match QuickBooks.
- Donor-restricted contributions are deposited but not tracked separately.
- The organization cannot easily show remaining grant balances.
- Program expenses are not separated from administrative or fundraising costs.
- The treasurer is unsure whether funds were spent according to grant terms.
- Board reports show total income and expenses but not restricted fund activity.
- QuickBooks has too many vague categories, such as miscellaneous or uncategorized expense.
- The organization is preparing for Form 990 and the books are not ready.
If several of these apply, your nonprofit may need more than a few quick corrections. It may need a cleaner bookkeeping structure and a monthly reporting process that supports board oversight, grant reporting, and annual filing support.
When to Get Professional Help
Grant tracking and restricted fund bookkeeping can become complicated quickly, especially when an organization has multiple funding sources, multiple programs, or changing leadership. Professional support may help when your nonprofit needs cleaner records, better QuickBooks organization, or more useful reports for the board.
Consider getting help if:
- Your nonprofit receives grants with specific reporting requirements.
- You have donor-restricted funds that are not tracked clearly.
- Your board needs better financial reports to understand available cash.
- Your QuickBooks Online file is not organized by program, grant, or restriction.
- You are relying heavily on spreadsheets because QuickBooks reports are not useful.
- You are preparing for Form 990, 990-EZ, or 990-N and need cleaner support.
- Your organization has had a change in treasurer, bookkeeper, executive director, or board leadership.
- You want to build a monthly bookkeeping process instead of waiting until year-end.
Small Business Accounting Inc. provides nonprofit bookkeeping support, QuickBooks Online cleanup, board financial report support, grant tracking, restricted fund bookkeeping, and Form 990 support for nonprofits nationwide.
FAQ: Grant Tracking and Restricted Funds for Nonprofits
1. What is restricted fund bookkeeping for nonprofits?
Restricted fund bookkeeping means tracking money that must be used for a specific purpose, program, grant, or donor restriction. It helps the organization separate funds that are available for general operations from funds that have limitations.
2. Can QuickBooks Online track nonprofit grants?
Yes, QuickBooks Online can be organized to help track grants, programs, and restricted funds when the setup is planned carefully. Depending on the organization, this may involve classes, locations, customers, projects, tags, or supporting schedules.
3. Why can’t we just track grants in a spreadsheet?
Spreadsheets can be helpful, but they should agree with the accounting records. If the spreadsheet and QuickBooks do not match, grant reports may become difficult to support and board reports may be unreliable.
4. What should a nonprofit board know about restricted funds?
The board should know which funds are restricted, what they are restricted for, how much has been spent, what remains available, and whether any deadlines or reporting requirements apply.
5. Does restricted fund tracking affect Form 990?
It can. Clean tracking may help support annual filing information, including revenue categories, program expenses, and net assets with or without donor restrictions. The exact filing impact depends on the organization’s facts and the form required.
Need help getting your nonprofit books organized?
Small Business Accounting Inc. helps nonprofits with bookkeeping cleanup, QuickBooks Online organization, board financial reports, grant tracking, restricted fund bookkeeping, and Form 990 support. Remote support is available nationwide. Hawaii and Oahu clients may request local appointment availability when appropriate.