# Free attendance sheet for Excel and Google Sheets

> A free attendance sheet for Excel and Google Sheets: P or A for each session, totals for each member and date, a payments sheet in AED and a member list.

Download: [teamna-attendance-sheet.xlsx](https://teamna.app/assets/tools/teamna-attendance-sheet.xlsx?v=d052a7e417) (Excel file, 105 KB, no email needed). It opens in Excel, Google Sheets and Numbers.

## 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.

## 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

Teamna does this work for you: staff mark [attendance](https://teamna.app/attendance) with one tap, members see what they owe and pay by card ([class payments](https://teamna.app/class-payments)), and members book and get reminders in the app. 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.

## Links

- [This page](https://teamna.app/tools/attendance-sheet)
- [Start free trial: create your business](https://teamna.app/sign-up)
- [Pricing](https://teamna.app/pricing)