
Nonprofit Income Statement Template
Report your nonprofit's revenue and expenses with a statement of activities template built for fund accounting — grants, donations, program fees, and functional expense allocation included.
What's Inside This Nonprofit Income Statement Template
This template includes 5 worksheets, each designed for a specific part of your nonprofit financial workflow:
Statement of Activities
The core sheet structured as a GAAP-aligned statement of activities — the nonprofit equivalent of an income statement.
Monthly Breakdown
A month-by-month view of revenue and expenses across all 12 months.
Functional Expense Allocation
Allocates shared costs — such as personnel, rent, and technology — across the three functional categories required by GAAP: program services, management and general, and fundraising.
Program Expense Detail
Breaks down expenses by individual program rather than by functional category.
Dashboard
A one-page visual summary with charts and key ratios for board meetings and donor reports.
Nonprofit Income Statement Template Features
- GAAP-aligned statement of activities with unrestricted, temporarily restricted, and permanently restricted revenue
- Functional expense allocation across program services, management & general, and fundraising
- Program-by-program expense detail for multi-program organizations
- Program expense ratio and fundraising efficiency auto-calculated
- 12-month revenue and expense breakdown for grant reporting and board updates
- Operating reserve calculation in months of operating expense coverage
How to Use This Nonprofit Statement of Activities Spreadsheet
Start by downloading the .xlsx file and opening it in Excel or Google Sheets. No macros or add-ins required. Go to the Statement of Activities sheet first and review the revenue and expense categories. Most nonprofits will keep the majority of categories as-is, but you'll want to customize the program services rows to match your actual programs and adjust the grant line items to reflect your specific funders. This setup takes about 20 minutes if you have last year's Form 990 or audit handy.
Once the structure looks right, work through the Monthly Breakdown sheet for the current fiscal year. Enter each revenue source month by month — grants when they're received or recognized, donations as they come in, and program fees in the month earned. For expenses, align your entries with your actual disbursement schedule. If you allocate shared costs like rent or salaries across programs, use the Functional Expense Allocation sheet to set your percentages once; the sheet will distribute those costs automatically going forward.
15 minutes from download to your first statement of activities
Download the template, plug in your grant and donation figures, and see your nonprofit's full financial picture — program expense ratio, operating reserve, and functional expense breakdown included.
Why Every Nonprofit Needs a Proper Income Statement
Nonprofits operate under a different financial logic than businesses. There is no profit motive, but there is accountability — to donors, funders, the IRS, and the communities you serve. A well-structured income statement (formally called a Statement of Activities under GAAP) shows not just whether you spent less than you raised, but how you spent it and whether that spending fulfilled your mission. Program expense ratio — the share of total expenses going directly to programs versus overhead — is the single metric that donors, foundations, and watchdog organizations use to evaluate financial health. Most high-performing nonprofits maintain ratios above 70%, and many large foundations will not fund organizations below 65%.
The structure of a nonprofit income statement differs meaningfully from a for-profit P&L. Revenue must be classified by restriction: unrestricted funds can be used for any purpose, temporarily restricted funds are tied to a specific grant period or use, and permanently restricted funds (endowments) must be maintained in perpetuity with only the investment income available for spending. Expenses must be reported by function — program services, management and general, and fundraising — not just by department or account. This functional expense classification is required on Form 990 and drives the ratios that stakeholders scrutinize. Getting it right in your spreadsheet means your 990 preparation is largely done before your accountant touches it.
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 Income Statement 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 Expense Tracker Template for Excel
$29
Nonprofit Financial Model 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 Income Statement Templates
Accounting Firm Income Statement Template for Excel
$29
Auto Repair Income Statement Template for Excel
$29
Car Wash Income Statement Template for Excel
$29
Church Income Statement Template for Excel
$29
Cleaning Service Income Statement Template for Excel
$29
Coffee Shop Income Statement Template for Excel
$29
Nonprofit Income Statement Template
$29