Nonprofit Income Statement Template preview

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.

$29Save 5+ hours vs. building a nonprofit statement of activities from scratch
Secure checkout
|
|
Powered by
Instant download after purchase
Works in Excel & Google Sheets
30-day money-back guarantee
.xlsx235 KB5 sheetsUpdated 2026-03-23

What's Inside This Nonprofit Income Statement Template

This template includes 5 worksheets, each designed for a specific part of your nonprofit financial workflow:

1

Statement of Activities

The core sheet structured as a GAAP-aligned statement of activities — the nonprofit equivalent of an income statement.

2

Monthly Breakdown

A month-by-month view of revenue and expenses across all 12 months.

3

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.

4

Program Expense Detail

Breaks down expenses by individual program rather than by functional category.

5

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.

Secure checkout
|
|
Powered by

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

Program expense ratioFundraising efficiency ratioOperating reserve monthsCost per beneficiaryGrant renewal rate

Nonprofit Income Statement Template FAQ

Nonprofit Income Statement Template

$29