Grant Tracking for Nonprofits: How to Keep Better Records

Grant funding can help a nonprofit expand programs, serve more people, and move important work forward. But once the funds arrive, the organization also has a responsibility to track the money clearly.

For many nonprofits, grant tracking becomes stressful because the bookkeeping system was not set up for it. Grant income may be recorded in one place, expenses in another, and reporting deadlines in a separate spreadsheet. By the time the board, grantor, or tax preparer asks for a report, the team may have to search through bank statements, receipts, emails, and QuickBooks reports to piece everything together.

Better grant tracking does not need to be complicated. It does need to be consistent. Your nonprofit should be able to answer three basic questions at any time: how much grant money was awarded, how much has been spent, and how much remains available for the restricted purpose.

This guide explains how nonprofits can keep better grant records, what to include in a grant tracking system, common mistakes to avoid, and when professional bookkeeping support may be helpful.

If you are reviewing your nonprofit records before filing or board reporting, you can also download the free nonprofit bookkeeping checklist to help identify what may need cleanup.

Why Grant Tracking Matters for Nonprofits

Grant tracking is more than a bookkeeping task. It supports accountability, board oversight, donor confidence, and future funding opportunities.

When grant records are organized, nonprofit leaders can:

• Show how restricted funds were used
• Prepare grant reports more efficiently
• Monitor spending against grant budgets
• Avoid accidentally using restricted funds for general operations
• Help the board understand available cash versus restricted cash
• Support year-end financial reporting and Form 990 preparation, when applicable
• Improve readiness for future grant applications

Strong grant tracking also helps leadership make better decisions. If a grant is underspent, overspent, or nearing a reporting deadline, the executive director, treasurer, and board should know early enough to respond.

Small Business Accounting Inc. provides nonprofit bookkeeping support for organizations that need help with grant tracking, restricted fund bookkeeping, QuickBooks organization, board reports, and Form 990 support.

What Should Be Included in a Grant Tracking System?

A grant tracking system should help your nonprofit follow the full life cycle of each grant, from award to final reporting.

At a minimum, your records should include:

• Grantor name
• Grant award date
• Grant period or performance period
• Total amount awarded
• Amount received
• Payment schedule, if funds are received in installments
• Purpose restrictions
• Approved budget categories
• Expenses charged to the grant
• Remaining grant balance
• Required reporting deadlines
• Supporting documents, receipts, and invoices
• Contact person for the grantor

The goal is to make grant activity easy to review without rebuilding the records every time someone asks for an update.

Step-by-Step Checklist for Better Grant Tracking

Grant tracking works best when the process is built into the monthly bookkeeping routine. The following checklist can help your nonprofit improve its records.

1. Create a Separate Record for Each Grant

Each grant should have its own record, folder, or tracking file. This can be handled inside QuickBooks, a spreadsheet, a grant management system, or a combination of tools.

For each grant, save:

• Grant agreement or award letter
• Approved budget
• Grant restrictions
• Payment schedule
• Reporting requirements
• Important deadlines
• Grantor correspondence

This makes it easier to understand the purpose of the funds and avoid mixing one grant with another.

2. Track Grant Income Separately

Grant income should be recorded clearly so the organization can identify where funds came from and what restrictions may apply.

A common mistake is recording all funding as general donations or miscellaneous income. That may make monthly entry easier, but it can create confusion later.

Your bookkeeping should make it clear when income relates to a specific grant, program, or restricted purpose.

3. Match Expenses to the Correct Grant

Grant expenses should be connected to the grant they support. If expenses are not coded properly, the organization may not be able to show how the funds were used.

Examples of grant expenses may include:

• Program supplies
• Payroll allocated to the grant
• Contractor costs
• Travel or outreach expenses
• Training costs
• Equipment or materials, if allowed by the grant
• Administrative costs, if allowed by the grant terms

Not every expense is allowable under every grant. Your nonprofit should review the grant agreement and budget before charging costs to the grant.

4. Track the Remaining Grant Balance

Your grant tracking system should show how much has been received, how much has been spent, and how much remains.

This is especially important when a grant has a spending deadline. If the organization waits until the end of the grant period to review the balance, it may discover too late that funds are underspent or that expenses were charged incorrectly.

A simple monthly review can help leadership stay ahead of these issues.

5. Keep Receipts and Supporting Documents Organized

Grant reports often require support for spending. Even when the grantor does not request every receipt, the organization should keep records that explain and support the expenses charged to the grant.

Helpful support may include:

• Receipts
• Invoices
• Payroll allocation reports
• Contractor agreements
• Timesheets, when applicable
• Approval records
• Program reports
• Proof of payment

Good documentation reduces stress when preparing grant reports, board reports, and year-end financial information.

6. Review Grant Activity Monthly

Grant tracking should not wait until the reporting deadline. A monthly review helps the organization catch issues early.

Each month, review:

• New grant payments received
• Expenses charged to each grant
• Remaining balances
• Upcoming reporting deadlines
• Any spending that may need reclassification
• Any grant that appears over budget or underspent

For a practical self-check, you can use our free nonprofit bookkeeping checklist as part of your monthly or year-end review process.

7. Include Grant Activity in Board Reports

The board does not need every receipt, but it should understand the status of major grants and restricted funds.

A board-ready grant report may show:

• Grant name
• Total award
• Amount received
• Amount spent
• Remaining balance
• Grant period
• Reporting deadlines
• Notes about risks, delays, or spending concerns

Board financial reports are generally for internal management and board use unless otherwise agreed. They are not the same as CPA audit, review, or compilation reports.

How QuickBooks Can Help With Grant Tracking

QuickBooks can support grant tracking, but it needs to be set up carefully. Many nonprofits use QuickBooks but still struggle because grants, programs, and restricted funds are not separated clearly.

Depending on the organization, QuickBooks may be used to track grants through classes, customers, projects, locations, tags, or separate income and expense categories. The right setup depends on the organization’s size, reporting needs, and how many grants or programs it manages.

Common QuickBooks grant tracking issues include:

• Grant income recorded as general donations
• Grant expenses mixed with unrestricted expenses
• Unclear restricted fund balances
• Expenses coded inconsistently from month to month
• Grant reports tracked manually but not reconciled to QuickBooks
• Board reports that do not show remaining grant balances
• Old or duplicate transactions affecting grant totals

A nonprofit QuickBooks cleanup and reporting support process can help organize grant records, clean up categories, reconcile accounts, and create more useful reports.

Common Grant Tracking Mistakes to Avoid

Most grant tracking problems are not caused by bad intent. They usually happen because the organization is busy, systems are informal, or bookkeeping duties are split between staff and volunteers.

Mixing Restricted Funds With General Operating Funds

If grant funds are restricted, they should be tracked separately from general operating funds. Otherwise, leadership may think more cash is available for general use than actually is.

Waiting Until the Grant Report Is Due

Grant reporting is much easier when records are updated monthly. Waiting until the deadline can lead to missing receipts, rushed classifications, and unclear balances.

Not Tracking Payroll Allocations

If payroll costs are charged to a grant, the organization should keep support for how those costs were calculated. This may include timesheets, allocation schedules, or other internal records depending on the grant requirements.

Using Too Many Manual Spreadsheets

Spreadsheets can be useful, but they should agree with the bookkeeping system. If grant spreadsheets and QuickBooks reports do not match, the organization may not know which numbers are correct.

Ignoring Reporting Deadlines

Grant tracking should include both financial activity and deadlines. A clean financial report is less helpful if the organization misses the grantor’s reporting timeline.

Red Flags Your Grant Records Need Cleanup

Your nonprofit may need grant tracking cleanup if any of these issues sound familiar:

• Grant balances are unclear
• Grant income is mixed with general donations
• Expenses are not coded to specific grants
• Restricted funds are not shown separately in reports
• QuickBooks reports do not match grant spreadsheets
• Receipts and invoices are hard to locate
• Payroll allocations are not documented
• The board does not receive grant status updates
• Reporting deadlines are tracked only in someone’s email
• Form 990 preparation is delayed because grant records are messy

These issues are common, especially for growing nonprofits. The important thing is to fix the process before the records become harder to reconstruct.

How Grant Tracking Supports Form 990 and Year-End Reporting

Grant tracking can also support year-end financial reporting and Form 990 preparation when an annual filing is required.

IRS filing requirements and deadlines can vary depending on the organization’s facts, gross receipts, assets, exempt status, and tax year. In general, the IRS states that Forms 990, 990-EZ, or 990-PF are due by the 15th day of the 5th month after the end of the organization’s accounting period, and Form 8868 may be used to request an automatic 6-month extension for those forms when filed properly and timely.

The IRS also notes that organizations that fail to file required annual returns or notices for three consecutive years can automatically lose tax-exempt status.

You can review IRS information about annual exempt organization return due dates, extensions of time to file exempt organization returns, and automatic revocation of exemption.

This article is for general educational purposes and is not legal advice. Nonprofits should confirm their specific filing requirements, grant reporting requirements, and deadlines with current IRS guidance, grant agreements, and qualified professional support when needed.

When to Get Professional Help

Some nonprofits can track grants internally, especially if they have only one or two simple grants. But outside bookkeeping support may be helpful when the organization has multiple grants, restricted funds, payroll allocations, reporting deadlines, or messy QuickBooks records.

Consider getting help if:

• Grant balances are unclear
• Restricted funds are mixed with operating funds
• QuickBooks needs cleanup
• Grant reports are difficult to prepare
• The board needs clearer restricted fund reporting
• Payroll or contractor costs must be allocated to grants
• Prior-year grant records do not match current reports
• Form 990 preparation is stressful because records are not organized

Professional support can help your nonprofit clean up old records, improve the bookkeeping setup, and create a grant tracking process that is easier to maintain going forward.

If your grant records are already messy or a deadline is approaching, you can request nonprofit bookkeeping support from Small Business Accounting Inc.

FAQ: Grant Tracking for Nonprofits

1. What is grant tracking for nonprofits?

Grant tracking is the process of recording grant awards, payments received, expenses charged to the grant, remaining balances, restrictions, and reporting deadlines. It helps the organization show how grant funds were used.

2. How should nonprofits track restricted grant funds?

Nonprofits should track restricted grant funds separately by grant or purpose. Records should show the amount awarded, amount received, expenses charged, remaining balance, and any reporting requirements.

3. Can QuickBooks be used for nonprofit grant tracking?

Yes. QuickBooks can be used for grant tracking if it is set up properly. Depending on the organization, grants may be tracked using classes, projects, customers, locations, tags, or carefully designed income and expense categories.

4. What records should be kept for grant reporting?

Useful records include the grant agreement, approved budget, payment records, receipts, invoices, payroll allocation support, contractor records, reporting deadlines, and correspondence with the grantor.

5. When should a nonprofit get help with grant tracking?

A nonprofit should consider help when grant balances are unclear, QuickBooks reports do not match grant records, restricted funds are mixed with general funds, or grant reporting deadlines are becoming stressful.

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.

Learn more about nonprofit bookkeeping support: https://smallbusinessaccountingfirm.com/nonprofit-bookkeeping/

Ready to request help? https://smallbusinessaccountingfirm.com/contact/

Want to start with a checklist? https://smallbusinessaccountingfirm.com/nonprofit-bookkeeping-checklist-pdf/