Free tool

Free attendance sheet for Excel and Google Sheets

Many classes run on WhatsApp and a spreadsheet. This sheet makes the spreadsheet part easier: attendance, payments and members in one Excel file, with the totals done for you.

What is in the sheet

• Attendance. One row for each member and one column for each session date. Select P (present) or A (absent) from a list. Each absence turns light red. The sheet counts the present and absent marks for each member and for each date, and shows the attendance rate.
• Payments. One row for each member and month: the amount in AED, paid Yes or No, the date paid, and the method (cash, card or transfer). A row that is not paid turns light amber. The total not paid is at the top.
• Members. Name, parent name, phone, group and level, with a count of the members.
• How to use. The steps on one page, so anyone on your team can use the file.

Member	2 Nov	4 Nov	9 Nov	11 Nov	16 Nov	18 Nov	23 Nov	25 Nov	Present	Absent
Adam Haddad	P	P	P	A	P	P	P	P	7	1
Lina Saleh	P	P	P	P	P	P	P	P	8	0
Yousef Karim	P	A	P	P	P	A	P	P	6	2
Maya Nasser	P	P	P	P	P	P	A	P	7	1
Zaid Hamdan	P	P	A	P	P	P	P	P	7	1

How to use it

1. Download the file and open it in Excel. For Google Sheets, upload it to Google Drive and open it with Google Sheets.
2. Delete the sample rows: rows 7 to 16 on the Attendance, Payments and Members sheets. They have fictional names.
3. Write your members on the Members sheet. Write the same names in column A of the Attendance sheet (with the group in column B) and of the Payments sheet. Write the session dates in row 4 of the Attendance sheet.
4. After each session, select P or A for each member. Record each payment on the Payments sheet.

When the sheet is not enough

A sheet records what happened. Somebody still types every mark, asks every parent for the fee, and posts every change in the group chat. Teamna does this work for you:

• Staff mark attendance with one tap on their phone, and the record is there for you at once.
• Members see what they owe and pay by card, and you record cash and transfers. Read about class payments.
• Members book, cancel and get reminders in the app, so the WhatsApp questions stop.

Start free trial

7-day free trial. No card needed.

Frequently asked questions

Is the attendance sheet free?

Yes. Download it and use it as you want. You do not need to give an email or make an account.

Does it work in Google Sheets?

Yes. Upload the file to Google Drive and open it with Google Sheets. The lists, the totals and the colours work the same as in Excel. It also opens in Numbers on a Mac.

How do I mark attendance?

Click a cell under a session date and select P (present) or A (absent) from the list. An absence turns light red. The totals for the member and for the date change at once.

Can I track payments in the same file?

Yes. The Payments sheet has one row for each member and month. Select Yes when the member pays. A row that is not paid turns light amber, and the total not paid is at the top of the sheet.

How many members and sessions does it hold?

The Attendance, Payments and Members sheets each have room for 200 rows after you delete the sample rows. The Attendance sheet has 12 session dates. For more dates, insert a column between two date columns, then copy rows 5 and 6 from the date column next to it into the new column, so the new date has its totals. For more groups, make a copy of the Attendance sheet for each group.

When is a sheet not enough?

A sheet records what happened. It does not remind parents, take bookings, or ask for payment. Teamna does that work for you: members book in an app, attendance is one tap, and each member sees what they owe.