Former long-time business officer, recent interim CFO, and founding member of NBOA Jim Pugh shares wisdom he has collected in his decades of service to independent schools.
This is the 12th and final article in the Business Office Basics series.
Information will not help an organization unless it is communicated effectively. A dashboard, that is, a select collection of key data graphics and visualizations, can serve a school well.
These two Excel files are updated versions of The Trustee Dashboard – Day Schools and The Trustee Dashboard – Boarding Schools, which I created 12 years ago. These have been used by hundreds of schools over the years.
The topics include budget & capital, operating cash, admissions, enrollment, endowment, reserves & debt, student attrition, tuition and fees, financial aid, faculty, staffing, and the board. The workbooks include Excel tips for modifying data tables and charts. They also include instructions to update the dashboard for a new school year.
These two files are not intended to be “plug and play.” They offer a wide sample of charts that show the visual display of quantitative information. By no means do they exhaust all of the possible charts that can be presented to the board. There could be more charts about facilities, for example. My two favorite charts are those for operating cash and student attrition because each tells an important but rarely reported story, and in a surprisingly simple way.
“The Visual Display of Quantitative Information” by Edward R. Tufte, is the classic work on this subject. It includes 250 examples of the best (and a few of the worst) statistical graphics, with detailed analysis of how to display data for precise and quick understanding.
A school will need to decide how many of the charts to present to the board. There is no typical size. Some schools use a dashboard with a dozen charts. Others use two dozen charts.
These Excel files can be a resource for the school that does not currently provide an annual dashboard to its board, as well as for a school whose leaders wish to review the board’s current dashboard. The charts can facilitate a discussion with the finance committee about the creation of a dashboard that meets the trustees’ expectations. Some of the charts may be used to support a specific committee.
The advancement committee, for example, may benefit from a number of charts in the fundraising section.
These dashboard files are designed with the following purposes in mind:
Trends are important. These dashboards look at five prior fiscal years, plus the current school year.
The Board can receive too much information. Pages filled with rows of numbers are fine for the trustee with the time and inclination to drill down into the data. Information should also be presented clearly and succinctly.
Information presented visually is especially effective. Numbers communicate with, at best, half of the trustees. Simple charts communicate with everyone.
Consistency is important. Definitions and organization of data should stay consistent from meeting to meeting and, ideally, from year to year.
The dashboard, in its entirety, should be presented at least once each year. This is usually in September. Some topics, such as operating budget and cashflow, should be reported at each Board meeting.
These dashboards were created with input from trustees at 15 schools, who I interviewed in 2011. In the course of these interviews, several of trustees described the purpose for which their board would use a dashboard. The reasons included:
To ensure that board members are informed about, and with repeated viewing, understand the key numbers.
To provide all trustees with the same base of information, and get them on the same page.
To inform them about changes since the last meeting.
To reminds trustees what they knew at the end of the prior board meeting – so they don’t have to take up meeting time becoming reacquainted with the school’s structure and issues. One of the interviewed trustees put it bluntly: “I want them to remember what school they are at today.”
The Trustee Dashboard is copyrighted by the National Association of Independent Schools. It is used in this article with the kind permission of NAIS.
This article originally appeared in NBOA's Net Assets magazine as part of Jim Pugh's Business Office Basics series, we have made minor alterations for an international school context. Sage Consultancy strongly recommends membership of NBOA for international schools as a great resource for school leadership.
留言