Blog.

Most Recent Posts

WORKSHEET: Funding Pipeline Spreadsheet and Instructions
Resources, Budget and Finance Tools, Preview Budget and Finance Tools A. Michael Gellman (CPA, CGMA) Resources, Budget and Finance Tools, Preview Budget and Finance Tools A. Michael Gellman (CPA, CGMA)

WORKSHEET: Funding Pipeline Spreadsheet and Instructions

The purpose of the funding pipeline worksheet is to help your organization conduct regular periodic assessments of funding and revenue streams, consider changes to anticipated and past funding patterns, and assess whether there is a risk that budgeted funding might not be realized in the near-term and intermediate-term future. Complete this worksheet in collaboration with your development office, senior management team, and staff to help with operational planning and stress test your organization’s anticipated funding sources.

Read More
TEMPLATE: Multi-Year Grant Usage Schedule [SUBSCRIBERS-ONLY]
Subscribers-Only, Resources, Budget and Finance Tools A. Michael Gellman (CPA, CGMA) Subscribers-Only, Resources, Budget and Finance Tools A. Michael Gellman (CPA, CGMA)

TEMPLATE: Multi-Year Grant Usage Schedule [SUBSCRIBERS-ONLY]

Multi-year grants can be very beneficial to a nonprofit organization but can cause significant bottom-line budget (surplus and deficit) volatility. This template multi-year grant usage schedule will help to show the true impact of a grant over the full period of its use and move attention away from the impact on any one single fiscal year budget.

Read More
TEMPLATE: Operating Reserves Status Report Spreadsheet
Resources, Budget and Finance Tools, Preview Budget and Finance Tools A. Michael Gellman (CPA, CGMA) Resources, Budget and Finance Tools, Preview Budget and Finance Tools A. Michael Gellman (CPA, CGMA)

TEMPLATE: Operating Reserves Status Report Spreadsheet

Operating reserves are one the most important components of financial health for a nonprofit organization and a key indicator for long-term fiscal and financial sustainability. Providing regular reports on the status of an organization’s operating reserves is essential for monitoring an organization’s financial health as well as compliance with its operating reserve policy.

Read More
TEMPLATE: Labor Budget Worksheet
Resources, Subscribers-Only, Budget and Finance Tools A. Michael Gellman (CPA, CGMA) Resources, Subscribers-Only, Budget and Finance Tools A. Michael Gellman (CPA, CGMA)

TEMPLATE: Labor Budget Worksheet

Labor costs are usually the largest expense line-item in a nonprofit organization’s budget. Preparing a separate labor budget is key to building a realistic and achievable budget for the next fiscal year. This labor budget worksheet will help you to view and manage the costs of staff salaries, employee benefits, and payroll taxes, show how these labor costs are expected to be allocated to programs, fundraising, and administrative (overhead) departments, and assist with aligning your organization’s budget with reporting requirements under generally accepted accounting principles (GAAP) and Form 990.

Read More
TEMPLATE: Basic Capital Budget Spreadsheet [SUBSCRIBERS-ONLY]
Resources, Subscribers-Only, Budget and Finance Tools A. Michael Gellman (CPA, CGMA) Resources, Subscribers-Only, Budget and Finance Tools A. Michael Gellman (CPA, CGMA)

TEMPLATE: Basic Capital Budget Spreadsheet [SUBSCRIBERS-ONLY]

Capital budgets are an important planning tool, helping nonprofit organizations to avoid problems from capital assets being used past their useful life, address future capacity challenges, and improve long-term cash flow planning. This basic capital budget spreadsheet template will help organizations to start tracking the acquisition and maintenance of their “capital assets,” i.e., material (larger dollar) assets that are expected to have a useful life of more than one year, such as computers, office furniture and equipment, leasehold improvements, and vehicles.

Read More
WORKSHEET: Financial Health Assessment and Implementation Framework [SUBSCRIBERS-ONLY]
Resources, Subscribers-Only, Budget and Finance Tools A. Michael Gellman (CPA, CGMA) Resources, Subscribers-Only, Budget and Finance Tools A. Michael Gellman (CPA, CGMA)

WORKSHEET: Financial Health Assessment and Implementation Framework [SUBSCRIBERS-ONLY]

The purpose of this Financial Health Assessment and Implement Framework worksheet is to help you to step back and assess your organization’s recent financial position and set the stage for planning the next two years. This worksheet will help you to look back at recent history while looking forward to create a path to improve your organization’s financial health and enhancing sustainability.

Read More
CHECKLIST: Simplified Balance Sheet Assessment

CHECKLIST: Simplified Balance Sheet Assessment

Balance sheets are part of standard nonprofit organization financial reporting, but are intimidating to most individuals and often misunderstood. This 3-step checklist uses easy-to-understand “Yes” or “No” questions to help you to work through a new balance sheet and make a quick assessment of an organization’s current financial position and changing financial health trends.

Read More
TEMPLATE: 3-Month Rolling Budget [SUBSCRIBERS-ONLY]
Resources, Subscribers-Only, Budget and Finance Tools A. Michael Gellman (CPA, CGMA) Resources, Subscribers-Only, Budget and Finance Tools A. Michael Gellman (CPA, CGMA)

TEMPLATE: 3-Month Rolling Budget [SUBSCRIBERS-ONLY]

During periods of high growth or rapid expected and unexpected changes and disruption, this 3-Month Rolling Budget Template will be a useful planning tool to help your nonprofit organization strategize, pivot and change course, documenting your search for a sustainable and smooth path forward.

Read More
TEMPLATE: Multi-Year Budget Financial Dashboard [SUBSCRIBERS-ONLY]
Resources, Subscribers-Only, Budget and Finance Tools A. Michael Gellman (CPA, CGMA) Resources, Subscribers-Only, Budget and Finance Tools A. Michael Gellman (CPA, CGMA)

TEMPLATE: Multi-Year Budget Financial Dashboard [SUBSCRIBERS-ONLY]

For evolution and change to be fully appreciated, nonprofit organizations need to include multi-year forecast budgets in financial reporting to show how the organization is evolving and how its programmatic goals and activities will be reflected in the future.

Read More