Nonprofit Expense Tracker Template
Track every nonprofit expense by program, grant, and fund — with pre-built IRS Form 990 categories, program expense ratio calculations, and grant-by-grant spending reports.
What's Inside This Nonprofit Expense Tracker Template
This template includes 5 worksheets, each designed for a specific part of your nonprofit financial workflow:
Expense Log
The central entry sheet where every organizational expense is recorded.
Program Expense Report
A breakdown of expenses by program or service area, automatically calculated from the Expense Log.
Grant Expense Report
A per-grant expense tracker that pulls from the Expense Log using the grant code column.
Monthly Summary
A month-by-month expense summary organized by the same functional categories as the Expense Log.
Dashboard
A visual summary of organizational spending with pre-built charts for program expense ratio, expense mix by functional category, monthly spending trend, and restricted versus unrestricted fund usage.
Nonprofit Expense Tracker Template Features
- Pre-built IRS Form 990 functional expense categories: program services, management and general, and fundraising
- Program expense ratio auto-calculated — shows the percentage going to mission vs. overhead
- Per-grant expense tracker with budget vs. actual and remaining balance for grant reporting
- Restricted vs. unrestricted fund tracking across every expense entry
- Monthly summary with functional category subtotals for board and auditor review
- Dashboard with program ratio gauge and restricted fund usage charts
How to Use This Nonprofit Expense Spreadsheet
Download the .xlsx file and open it in Excel or Google Sheets — no macros or plugins required. Start on the Expense Log sheet and review the pre-loaded categories. The default setup covers the functional expense classifications used on IRS Form 990 — personnel and benefits, professional fees, occupancy, technology, travel, printing and communications, supplies, and fundraising costs. Add any categories specific to your organization; if you run a food pantry, you might add a 'food and supplies' line, or if you provide housing services, a 'client housing assistance' category. Then set up your program columns and grant codes to match your active grants and programs. This initial setup typically takes 15–20 minutes.
Enter expenses as they occur, or work backward through bank and credit card statements to build a baseline for the current fiscal year. The most important columns to fill consistently are the program allocation and grant code fields — these are what make the Program Expense Report and Grant Expense Report useful. For personnel costs, which typically represent 50–60% of nonprofit expenses, enter each payroll run as a single expense row or split it across programs if staff time is allocated across multiple grants. The fund type column (restricted vs. unrestricted) is essential for tracking grant compliance; flag any expense paid from a restricted grant using the appropriate grant code.
15 minutes from download to your first expense log
Download the template, set up your programs and grant codes, and start tracking every expense by fund, grant, and functional category — program ratio and grant reports included.
Why Every Nonprofit Needs a Dedicated Expense Tracker
Nonprofit expense tracking is more demanding than for-profit bookkeeping for one core reason: most expenses need to be allocated to a specific program, grant, or functional category before they can be reported to funders, the IRS, and the public. A restaurant tracks whether it spent money on food or labor. A nonprofit needs to know whether that same payroll dollar went to program services, management and general overhead, or fundraising — and which grant or fund it came from. Without that discipline in the expense tracking system, grant reports become guesswork and Form 990 preparation turns into a weeks-long reconciliation project.
The program expense ratio is the number that funders, watchdog organizations like Charity Navigator and GuideStar, and state regulators pay attention to most. Typically, at least 65% of total expenses should flow to program services — direct mission work — with the remainder split between management and general overhead and fundraising costs. Maintaining that ratio requires tracking expenses in real time, not reconstructing allocations at year-end. Personnel costs are the biggest variable: if staff split time across multiple programs and grants, that time needs to be documented and allocated consistently, both for the ratio calculation and for grant compliance.
Nonprofit Industry at a Glance
Financial templates built for nonprofit organizations — from community foundations to service-delivery charities. Pre-loaded with fund accounting categories, grant tracking, and program expense ratios.
Revenue Drivers
- Grants (government & foundation)
- Individual donations
- Program fees
- Membership dues
- Special events
- Corporate sponsorships
Key Cost Categories
- Personnel & benefits
- Program expenses
- Administrative overhead
- Fundraising costs
- Occupancy
- Equipment & technology
Typical Margins
Gross: N/A · Net: 2-5% operating surplus
Seasonality
Grant cycles create Q1 and Q4 revenue spikes; year-end giving peaks in December. Fiscal years often run July–June rather than calendar year.
Key Performance Indicators
Nonprofit Expense Tracker Template FAQ
More Nonprofit Templates
Nonprofit Balance Sheet Template for Excel
$29
Nonprofit Budget Template for Excel
$29
Nonprofit Business Plan Template for Excel
$39
Nonprofit Cash Flow Template for Excel
$29
Nonprofit Financial Model Template for Excel
$29
Nonprofit Income Statement Template for Excel
$29
Nonprofit Invoice Template for Excel
$29
Nonprofit KPI Dashboard Template for Excel
$29
Nonprofit P&L Template for Excel
$29
Nonprofit Pro Forma Template for Excel
$29
Nonprofit Project Budget Template for Excel
$29
Nonprofit Sales Forecast Template for Excel
$29
Nonprofit Valuation Template for Excel
$29
More Expense Tracker Templates
Nonprofit Expense Tracker Template
$29