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.
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.