Collaborative budgeting for nonprofits

NP Budgeting is a free Google SheetsTM add-on and template designed to make it simple to track revenue, expenses, and cash flow, enabling you to make data-supported decisions that align with your nonprofit’s goals and values.

Involve more people in the budget development process without worrying about broken formulas. Say goodbye to jumbles of linked spreadsheets, manual expense splitting, and giving up on scenario planning because it’s too hard to keep track of everything.

Features

Separate budget development from budget presentation

This is the biggest benefit of the NP Budgeting template. The building blocks of the template are your individual budget line items. With separate tabs to enter your Income, Expenses, and Payroll Expenses, you can capture all of the details you need for each line item, including notes, what class it should be assigned to, and what month it should appear in (including “Annual”—and the template will do the math for you to divide it equally across each month!). Spend as long as you need to building, editing, and adjusting. When you’re ready to generate budgets, click the “Update Budget” button.

Accurately estimate payroll costs

For most organizations, payroll is one of, if not the, largest expenses. We’ve separated payroll expenses into their own sheet, to give you fine-grained control over your staffing costs, including employer-paid benefits.

Employer payroll taxes are set as a customizable standard percentage in the Budget Setup sidebar and applied automatically to all employees listed in the Payroll Expenses sheet.

Use your own chart of accounts and classes

While the template comes pre-loaded with a chart of accounts, you have complete control over the income and expense accounts that are used in your budget. You can also group accounts by category, which allows you to roll up the budget into condensed categories for simpler reporting.

The template is built for class tracking and can handle as many classes as you need. Every transaction can be associated to a class, and employee time can even be split by percentage among classes.

One budget, four ways

Break down your annual budget by class, month, or both—with one click. No pivot tables needed.

Because the budgets are generated programmatically, the tabs are locked to prevent editing. If you need to adjust a number in the budget, do it from the Income, Payroll Expenses, or Expenses sheets.

Cash flow forecasting

Tracking how much cash is on hand throughout the year is critical for many nonprofits. In the Budget Setup sidebar section, you can enter your cash balance at the beginning of the year and the Monthly Budget will automatically show each month’s ending cash balance based on that month’s net income.

If your organization uses accrual accounting, however, you might have items reflected in net income—like prepaid expenses or unearned income—that need to be shown on the Profit and Loss but don’t represent cash received or spent. Enabling the “non-cash” additional feature will allow you to select which items are non-cash, and the template will appropriately add or subtract the amount as an “Adjustment to Cash” in the Monthly Budget.

Keep track of budget scenarios without losing data

Turn on the additional “Include in Budget Toggle” feature to enable a checkbox next to each income and expense line item to choose whether it’s generated in the budget or not. Use this toggle to quickly check the effect of items on the budget.

Get the Add-on

Resources

Documentation

Read our detailed documentation to learn how to install, configure, and use NP Budgeting. It also covers common errors and troubleshooting.

Support

We offer two types of support for NP Budgeting setup consulting or troubleshooting—free support over email and paid support over Google Meet.

Webinar

Join us on November 14 at 11:00 am PST for a webinar on how to use NP Budgeting in a collaborative budgeting process hosted by Nonprofit Quarterly.

About

NP Budgeting is the result of a years-long collaboration between Rooted in Vibrant Communities (RVC), Ananda Valenzuela, and Alicia Radford, CPA.

In 2018, when Ananda was interim Executive Director of RVC, finance staff transitions meant that no one fully understood how the carefully constructed, Power Query-enhanced Excel workbooks being used for budgeting worked. Alicia was brought in to fix it, but over time the project continued to evolve and expand in scope. The overall goal was always to decrease the opportunity for user error in maintaining the budget, which led to the creation of this add-on in 2022-2023. We’re so pleased to be able to offer NP Budgeting to the nonprofit community as a free resource.

The logo for Rooted in Vibrant Communities

Rooted in Vibrant Communities is a 501(c)(3) nonprofit based in Seattle that promotes social justice by cultivating leaders of color, strengthening organizations led by communities of color, and fostering collaboration between diverse communities.

A photo of Ananda Valenzuela

Ananda Valenzuela (any pronouns) provides interim executive director leadership, facilitates organizational transformation, and coaches values-aligned leaders. He is passionate about nourishing joyful organizational cultures, supporting equitable self-management, and building liberatory practices. They have served as interim executive director at multiple organizations, provided capacity-building support to nonprofits for over ten years, and currently sit on the boards of Change Elemental and Hampshire College. Ananda grew up in Puerto Rico and slowly made her way across the United States, holding a variety of consulting, governance, and activist roles along the way.

A photo of Alicia Radford

Alicia Radford, CPA (she/her) specializes in nonprofit accounting, consulting, and training. After seven years of experience as a nonprofit operations manager and then six years at a nonprofit-focused accounting firm, she now works independently as Waywise Accounting, partnering with clients to extend their finance capacity. She is passionate about making the language of finance accessible and using it to build power for collective liberation.