The purpose of this template budget assumptions spreadsheet is to help nonprofit organizations to document and reflect on the assumptions for individual revenue and expense items that make up their annual budgets. This spreadsheet includes space to show individual departments and accounts within multiple-entity or single-entity structures, compare amounts used in past budgets (projected and actual numbers), a monthly breakout for budget planning, notes to capture details about assumptions and future plans, and more.

To realize the full potential of structures with multiple nonprofit entities, Board members, management, and staff must see how resources, programs, and activities are gathered and deployed across both organizations. This template multi-entity budget spreadsheet displays the budgets of two related entities (for example, a 501(c)(6) chamber of commerce or membership association and a 501(c)(3) educational foundation) in an easy-to-view grid showing how resources are allocated and shared, providing a starting point that can be easily expanded and reformatted to meet the needs of your organization.