← Templates

Free template · Excel & PDF

Church & Sunday school attendance sheet

A quarter of Sundays on one page. Track in-person and online attendance, total each Sunday for your report, flag people to follow up with, and keep first-time visitors on the same sheet.

Free · No sign-up · Made by the Attendable team · US Letter, landscape ·

Church attendance sheet with 13 Sunday columns, a weekly total row, and a first-time visitor table
Preview of the printable PDF

What's in the sheet

  • 13 Sunday columns for one quarter. Enter the first Sunday and the other dates fill in.
  • Four codes: O Attended, N Online, X Absent, E Excused.
  • Per-person totals and an attendance rate of (O + N) ÷ (O + N + X), plus a Weekly total row for your attendance report.
  • Class/cell and contact columns, a Follow-up check for people you plan to call, and a table for first-time visitors.
  • 40 people in Excel and 18 on the PDF, with room for 10 and 6 visitors.

Codes

  • O Attended
  • N Online
  • X Absent
  • E Excused

How to use it

  1. Type the ministry or class, the leader, and the date of the quarter's first Sunday.
  2. List members with their class or cell and a contact number.
  3. Each Sunday, mark O, N, X, or E. Check Follow-up for anyone you want to call that week.
  4. Write first-time visitors in the table below and tick Followed up after you've been in touch.

When a paper sheet starts to slow you down

One report from many classes
A department report needs every class's weekly totals, which means collecting each teacher's sheet first.
Spotting who has drifted away
Someone who has missed four Sundays in a row only stands out on paper if a leader reads across the row.
Teachers who take turns
When different teachers lead on different Sundays, the sheet has to be handed over every week—and sometimes it isn't.

Automate it with the Attendable app

Attendable keeps the same roster on your phone and does the counting for you. It's free on iOS and Android and contains ads.

On the sheetIn the app
Hand the sheet to the next teacherShare the group; Editors record attendance on their own phones
Add up weekly totals by handStatistics count each status for any period you choose
Read across rows to find absencesSort individual statistics to see who has missed the most
Look up a number to follow upCall or text directly from the member's record
Scribble newcomer notes in the marginMemo templates such as First visit or Needs a call
Download Attendable on the App StoreGet Attendable on Google Play

Free on iOS & Android · Contains ads

Read the step-by-step guide: Shared attendance for churches and small groups
Shared Attendable groups with Owner, Editor, and Viewer roles
Actual app screen · Sample data

Questions about this template

Why are excused weeks left out of the rate?

Someone traveling or sick with notice shouldn't look less committed than someone who was simply absent. The rate is (O + N) ÷ (O + N + X), so E weeks don't count either way.

Can I use it for a youth group or cell group?

Yes. Change the title and the Class/cell heading, and keep one sheet per group so each group's weekly total stays separate.

How do I start the next quarter?

Copy the sheet tab, clear the marks, and enter the next quarter's first Sunday. The 13 dates update automatically.