Church KPI Dashboard Template

For ongoing use, update the sheets monthly — typically after your monthly bookkeeping close. The Giving & Revenue sheet is most useful when updated after each Sunday giving total is reconciled, but monthly summaries work well for most churches. The Facility Utilization sheet takes five minutes per month: log the actual hours each space was used during the period. If you track giving in Planning Center Giving or Breeze, you can copy monthly totals directly into the spreadsheet rather than entering line by line.

The metrics that healthy churches track consistently are well-known among church finance practitioners. Giving per attender — total giving divided by average weekend attendance — is the most important leading indicator of financial health, typically ranging from $25 to $75 per attender per week depending on congregation demographics and generosity culture. Personnel costs at 45–55% of total expenses is the widely cited benchmark; churches above 60% often face the choice between staff cuts and reduced ministry programming. Facilities costs above 30% typically signal either an aging building with deferred maintenance or a congregation that has outgrown its giving capacity relative to its building size. Operating reserves of three to six months protect against the inevitable summer giving dip and any unexpected capital expenses.