Nonprofit P&L Template

Download the .xlsx file and open it in Excel or Google Sheets. Start with the Monthly P&L sheet and review the pre-loaded revenue and expense categories. Rename or adjust the revenue lines to match your specific funding sources — most organizations will keep the structure but relabel a few rows. In the Program Expense Breakdown sheet, replace the placeholder program names with your actual programs or service lines. This setup takes about 20 minutes and only needs to happen once.

Each month, enter your actual revenue by source and actual expenses by functional category in the Monthly P&L. If you track grant revenue on a cash basis (when received) or an accrual basis (when earned), stay consistent throughout the file. Use the Grant Tracker to log each active grant, enter award amounts, and note any spending restrictions. As you enter monthly data, the Annual Summary and Dashboard update automatically — you don't need to touch those sheets to keep them current.

Before board meetings, open the Dashboard tab for a current snapshot of your program expense ratio, fundraising efficiency, and operating reserve. Most nonprofit boards expect to see these ratios alongside the P&L, so having them calculated automatically saves the staff time spent manually computing numbers before each meeting. At year-end, the Annual Summary gives you the full picture needed to cross-check your Form 990 preparation and provide auditors with a reconcilable management report.

Nonprofit financial management operates under different rules than for-profit accounting. Revenue isn't just income — it's grants with restrictions, donations with donor intent, and program fees that may need to be tracked separately from unrestricted funds. Expenses aren't just costs — they're allocated across program, administrative, and fundraising categories that stakeholders use to judge your organization's efficiency. Without a P&L structured around these categories, you're producing financial reports that don't tell the story funders and board members need to hear.

The program expense ratio is the number nonprofits get evaluated on most heavily. Charity Navigator, GuideStar, and most institutional funders expect to see 65–80% or more of total expenses going directly to programs rather than overhead. But calculating that ratio requires knowing exactly how to categorize each expense — and for shared costs like rent, staff time, and technology, that means making a defensible allocation between program, administrative, and fundraising. This template does that allocation math for you and shows the resulting ratio on the dashboard, so you can monitor it monthly instead of discovering a problem when the 990 is already filed.

The practical workflow for most nonprofits is to close the books monthly, compare revenue against grant budgets and donation projections, and review whether program spending is on pace. If a grant is half spent at the midpoint of its grant period, is that on track? If donations are running 20% below projections in Q3, do you have enough operating reserve to cover the gap? This template is built to surface those questions early, when you still have time to adjust — not at the end of the fiscal year when the options are limited.