Nonprofits face a unique financial tracking challenge. Unlike a for-profit business where money is simply revenue and expenses, a nonprofit deals with restricted funds, grant reporting requirements, donor tracking, and program budgets that need to be managed separately — all while keeping overhead costs low enough to satisfy donors and board members.
Dedicated nonprofit accounting software like Bloomerang or Blackbaud can handle all of this — but it costs thousands of dollars per year that most small nonprofits can't justify. Excel, set up correctly, handles the core tracking needs of most small to mid-sized nonprofits at zero cost. Here's how.
Three things make nonprofit financial tracking uniquely complex compared to a regular small business. First, restricted funds — money given for a specific purpose that legally cannot be used for anything else. Second, grant reporting — funders require detailed accounting of exactly how their grant money was spent. Third, donor tracking — maintaining relationships with individual donors requires knowing their giving history, communication preferences, and recognition status.
A good nonprofit Excel system addresses all three while keeping things simple enough for a small staff or volunteer treasurer to maintain consistently.
Your donation tracker logs every gift received — one row per donation — with enough detail to support donor acknowledgment letters, year-end tax receipts, and giving history reports.
| Column | What to Enter |
|---|---|
| Date | Date the donation was received |
| Donor ID | Unique code linking to your donor master list |
| Donor Name | Individual or organization name |
| Amount | Gift amount |
| Fund | General, Restricted, Endowment, or specific program name |
| Restriction | If restricted — what must this money be used for |
| Payment Method | Check, online, cash, stock, in-kind, etc. |
| Campaign | Which fundraising campaign or appeal this came from |
| Acknowledged? | Yes/No — has the donor received their receipt |
| Notes | Any relevant details |
Key summary formulas for your dashboard:
Grant management is where Excel earns its keep for nonprofits. Each grant has a budget, a reporting deadline, eligible expense categories, and restrictions on how funds can be used. Tracking this in Excel keeps you organized for reporting and ensures you never accidentally overspend a grant category.
Here's what your grant tracker looks like in practice:
| Column | What to Enter |
|---|---|
| Grant ID | Short unique code for this grant |
| Funder | Foundation or government agency name |
| Program | Which program this grant funds |
| Grant Amount | Total award amount |
| Start Date | Grant period start |
| End Date | Grant period end — flag this with conditional formatting |
| Report Due Date | When your financial report is due to the funder |
| Amount Spent | =SUMIF from your expense tracker filtered by Grant ID |
| Remaining Balance | =Grant Amount - Amount Spent |
| % Spent | =Amount Spent / Grant Amount |
Most nonprofits run multiple programs simultaneously — each with its own budget, its own funding sources, and its own reporting requirements. Tracking budget vs. actual by program gives your leadership and board the visibility they need to make informed decisions about resource allocation.
Set up one budget vs. actual table per program, or use a single table with program as a filter column. For each program track:
| Category | Annual Budget | YTD Actual | YTD Budget | Variance |
|---|---|---|---|---|
| Personnel | $48,000 | $28,400 | $28,000 | -$400 |
| Program Supplies | $8,000 | $3,200 | $4,000 | +$800 |
| Contractor Services | $12,000 | $5,500 | $6,000 | +$500 |
| Travel | $3,600 | $1,100 | $1,800 | +$700 |
| Indirect/Overhead | $6,000 | $3,000 | $3,000 | $0 |
The YTD Budget column is what you should have spent by this point in the year — calculated as Annual Budget × (Current Month / 12). Comparing YTD actual to YTD budget is more meaningful than comparing to the full annual budget because it accounts for where you are in the year.
Acquiring a new donor costs significantly more than retaining an existing one. Tracking donor retention — who gave last year but hasn't given this year — is one of the highest-value activities a small nonprofit can do, and it's easy to set up in Excel.
Key donor retention metrics to track:
Total donors this year:
Donors who gave last year but not this year (lapsed donors):
This requires comparing two lists — last year's donors vs this year's donors. The easiest way is to add a "Gave This Year" column to your donor master list and use COUNTIFS to flag donors who gave last year but have a zero count this year. These are your lapsed donors — the highest priority for re-engagement.
Average gift size this year:
Excel handles the core tracking needs of most small nonprofits — typically those with annual budgets under $500,000 and fewer than ten active grants. Once you're managing dozens of grants simultaneously, processing hundreds of donations monthly, or need automated donor acknowledgments and online giving integration, dedicated nonprofit software starts making more sense.
But for a community organization, a small foundation, a local program, or a startup nonprofit still finding its footing, a well-built Excel system handles everything you need and keeps your overhead costs exactly where donors and funders want them — low.
Tell us about your nonprofit and we'll build a complete Excel system — donation tracking, grant management, program budgets, and donor retention — starting at just $75.
📧 Get Started Today