Institute for Organization Management - A Program of the U.S. Chamber of Commerce

  • About
    • General Information
      • Institute Policies and Procedures
      • Diversity, Equity, and Inclusion Statement
    • Recruitment Toolkit
    • Prospective Student Toolkit
    • Media
    • Answers to Your Frequently Asked Questions
    • Contact Us
  • Curriculum
    • Core Curriculum
    • Elective Curriculum
    • Webinars & Resource Center
  • Sites & Dates
    • Winter Institute
    • Midwest Institute
    • Southeast Institute
    • Northeast Institute
    • 2023 Institute Schedule
  • Registration
    • Register Now!
    • Deadlines and Fees
    • Scholarships
      • Enrollment Incentives
      • State Partner Scholarship
  • Who’s Who
    • Staff
    • Volunteers
    • Faculty
    • Sponsors
    • Alumni
      • IOM Alumni Database
  • Blog
A PROGRAM OF THE U.S. CHAMBER OF COMMERCE FOUNDATION
 

IOM Blog

July 14, 2010

Managers Drive Projections and Everybody Benefits: It’s All In The Process

As discussed throughout this Budget Management Series, Program and Project Managers represent a vast clearinghouse of relevant new information. Information that is current, real, interactive and informative. A financial report that incorporates rolling projections will allow these managers to get their knowledge into a real-time report in a communicative manor that will give you and your organization the mechanism to be nimble, leading edge and change sensitive.

A rolling projection reporting system allows program and project managers to get relevant new information into the budget process and to the management team on a real-time basis. This is how the process works:

  • It all begins with a timely month-end close by the accounting department and issuance of standard monthly financial reports.
  • Using Excel® or other reporting system, drop in current year-to-date revenue and expense results from the financial reports into a spreadsheet to sit along side the annual budget and year-to-date budget.
    • Note that the year-to-date budget is derived from a real-time (expected) basis, where you best anticipate that budgeted revenue and expenses will occur throughout the coming year. Based on this expectation the annual budget is allocated over the 12 months of the fiscal year.
  • Next insert a column for the remaining months of the budget year to give you an initial projection for year-end where these remaining months of the budget are added to the year-to-date actual results.
  • For example, based on a calendar year-end organization at the 3 month mark which would be at the end of March, the year-to-date budget column would contain 3 months from the real-time budget allocation and the remaining budget column would contain the 9 remaining budget months. The real-time monthly budget allocation would be prepared before the year gets started.
  • This is not an accounting drill. This process of dropping in the freshest of fresh information by the program and project managers will provide an ever evolving look at the future we call year-end.
  • Now the magic. Insert a blank column just after the remaining budget column for use by the program and project managers where they can insert changes based on current known new information. This is where these managers are given the opportunity to interact with the future by plugging in what they know is currently happening differently on the ground from the original budget for the remainder of the year.

This look into the future of what end of the year results will look like is powerful and behavior changing. When you make sure that this projection process is driven by the program and project managers and is refreshed and updated each month, the resulting projection reports will benefit all who come in contact with them and help stir your organization to improved outcomes. Next, I will discuss how to get these managers into a room together to work with this information and collectively drive the organization to a brighter future.

A. Michael Gellman
A. Michael Gellman, CPA, CGMA
Founding Principal Partner
Fiscal Strategies 4 Nonprofits, LLC (FS4N)

Mike is an independent fiscal and financial strategist for nonprofit organizations and a co-founding principal partner of Fiscal Strategies 4 Nonprofits, LLC (FS4N) and co-founder of Sustainability Education 4 Nonprofits (SE4N). Before starting FS4N, Mike had 30 years Public Accounting Firm experience managing not-for-profit business, fiscal and financial services consulting specialty group. He has been designing strategies and teaching budget and projection-based systems and fiscal and financial management enhancement strategies for over 30 years. He has conducted numerous seminars and has written articles on budgeting, operating reserve and investment policies, financial management, fiscal sustainability, leading economic indicators for nonprofits, and the impact on governance and transparency and accountability.

Mr. Gellman teaches courses and has made presentations for Georgetown University, the U.S. Chamber of Commerce Foundation's Institute for Organization Management, American Institute of Certified Public Accountants (AICPA), many State CPA Societies, the Center for Nonprofit Advancement, and for national nonprofit organizations such as the National Urban League, Volunteers of America, and many other nonprofit organizations.

He can be reached at mgellman@fiscalstrategies4nonprofits.com .

  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
DONATE NOW!
UPDATE CONTACT INFO
Sign-up for Emails
Approved Provider

About

  • General Information
  • Contact Us
  • Curriculum
  • Prospective Student Toolkit

Sites & Dates

  • Winter Institute
  • Midwest Institute
  • Southeast Institute
  • Northeast Institute

Resources

  • Scholarships
  • Faculty
  • Sponsors
  • Update Contact Info
  • Volunteers

Follow IOM

  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
IOM Blog

Institute for Organization Management - A program of the U.S. Chamber of Commerce © 2022 | Privacy Policy