Church Operations and Planning Center

Planning Center Database Health Audit

A sample audit of a church's Planning Center People database that counts duplicate profiles, people not in a household, children without a parent link, missing contact details, inactive records, and inconsistent membership values. It comes with a six-page report and an Excel workbook that lists every record and tracks cleanup.

Sample data. All names, organizations, and figures are fictional.

Planning Center Database Health Audit: Database Audit: Report PagesOpen larger image

About this sample

Every report built on Planning Center depends on clean People data. This audit runs seven checks against a full People export and activity history, then gives each finding a count, examples, a priority, and cleanup steps that use Planning Center's own tools, such as the duplicate detector, merging, bulk actions, and inactivating with a reason.

The Excel workbook has one sheet per finding with every flagged record, a status column with a dropdown, and a summary sheet whose counts and progress update with formulas as staff mark items done. No email addresses or phone numbers are included, only whether each is on file. The audit can be sold on its own or used as the first step before building reports.

What it includes

  • Duplicate profiles with match reason and source
  • Adults likely missing from a household and children with no parent link
  • Recently active adults missing an email or phone
  • Active profiles with no recorded activity in two years
  • Nonstandard membership values with a mapping to the standard list
  • Adults still marked as children
  • Cleanup plan with order, owner, and hours
  • Excel workbook with status tracking and live summary counts

Screenshots

Select an image to see it larger.

More in Church Operations and Planning Center

Weekly Leadership Snapshot

A one-page weekly dashboard for a senior pastor and staff that compares Sunday with the same Sunday last year. It brings attendance, kids check-ins, first-time guests, giving against budget, groups, and serving coverage from Planning Center into one view.

  • Power BI
  • PDF report

Sample data

Giving Analytics Dashboard

A four-page giving dashboard for a church finance team: giving units, recurring share, first-time and lapsed givers, giving bands, fund mix, monthly giving against budget, and a building campaign tracker. It comes with a Power BI rebuild kit that includes the data tables, a theme file, and every DAX measure.

  • Power BI
  • Excel

Sample data