Free Attendance Sheet for Small Business
Free attendance sheet templates for small business: daily, weekly, monthly, yearly, payroll, and blank. Excel, status codes, FLSA-ready. No signup.
Attendance Sheet Templates
Six free attendance sheet templates for small business: daily, weekly, monthly, yearly, a payroll version, and a blank sign-in roster. Download as Excel, with status codes and FLSA-ready fields built in. No signup.
An attendance sheet records who was present, absent, late, or on leave, and it is one of the simplest and most useful documents a small business keeps. It tells you who was working, surfaces the attendance patterns worth addressing, and forms part of the payroll record that federal law requires you to hold onto. The cost of not tracking it is real: the CDC Foundation put the annual cost of absenteeism to US employers at about $225.8 billion, and on a small team a single unplanned absence removes a large share of the day.
These six templates cover the range: a daily sheet for shift work, weekly and monthly versions for those payroll cycles, a yearly summary for reviews, a payroll version that ties attendance to pay, and a blank sign-in roster you can print. Each downloads as an Excel file, free and without an email, with the status codes and totals already built in. Because attendance sits next to your absence and leave rules, this pairs with your absenteeism policy and your time off policy.
What an Attendance Sheet Is
An attendance sheet is a document that records each employee's presence or absence over a period, marking a status for each day using a legend of codes. It answers a single question for every person and every day: were they here, and if not, why. Attendance sheet, attendance record, and staff attendance sheet describe the same document.
It is an employer-side record kept by a manager or, in a small business, by the owner. Beyond telling you who was working, it does two jobs: it reveals attendance patterns that may need attention, and it forms part of the payroll and recordkeeping trail that the Fair Labor Standards Act requires. The Department of Labor recordkeeping rules treat time and attendance records as wage records you must preserve.
Attendance Sheet vs. Timesheet
An attendance sheet and a timesheet are often confused, but they record different things. An attendance sheet tracks presence and absence, whether someone showed up and in what status. A timesheet tracks hours worked, and often the tasks or projects those hours went to. They overlap, but a small business gets cleaner records by knowing which one each task needs.
| Attendance sheet | Timesheet | |
|---|---|---|
| Records | Presence and absence status | Hours worked and tasks |
| Answers | Was the person here? | How many hours, on what? |
| Unit | A status code per day | Clock-in and clock-out times |
| Best for | Staffing, absence patterns, discipline | Hourly pay, overtime, client billing |
| Overtime | Not calculated from it | Calculated from actual hours |
The practical rule: use an attendance sheet to track who is present and to spot absence patterns, and a timesheet to capture the hours that drive pay. If you pay directly from attendance, the payroll template below bridges the two, but hourly overtime always needs actual clock hours because it is owed on hours worked past forty in a workweek.
What to Include
A complete attendance sheet covers four groups of fields: identifying fields, attendance data, a status-code legend, and an audit trail. The groups below are the consensus set that strong attendance sheets share.
The two elements small businesses most often skip, and most need, are a visible code legend and a signature line. The templates here build both in by default, with the legend on its own tab.
Which Template Should You Use?
Match the template to your payroll cycle and business type. Daily for shift work, weekly or monthly for those payroll rhythms, yearly for reviews, the payroll version if you pay from attendance, and the blank roster for sign-in or printing.
6 Free Attendance Sheet Templates
Download all six as a single Excel workbook set or grab individual templates. Each downloads as an Excel file with the status codes, totals, and a legend tab already built in, free and with no signup. Every template also opens cleanly in Google Sheets. Fill in your employees, mark the daily status, and the sheet is ready.
Template 1: Daily Attendance Sheet
Time in, time out, break, and a status code per employee, with a daily present, absent, and on-leave tally. For shift-based businesses that track attendance one day at a time.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Employee Name | Employee ID | Time In | Time Out | Break (min) | Status | Notes | Supervisor Initials |
| 2 | Jordan Blake | E-001 | 8:58 AM | 5:03 PM | 30 | P | JB | |
| 3 | Sam Rivera | E-002 | 9:12 AM | 5:00 PM | 30 | L | Late, traffic | JB |
| 4 | Taylor Kim | E-003 | A | Called in sick | JB | |||
| 5 | Alex Chen | E-004 | 8:45 AM | 4:30 PM | 30 | S | Left early, approved | JB |
| 6 | ||||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 | ||||||||
| 10 | Total Present | |||||||
| 11 | Total Absent | |||||||
| 12 | Total On Leave |
Template 2: Weekly Attendance Sheet
A status code for each employee across all seven days, with a days-present total and a notes column. For weekly payroll or rotating shifts where the week is the unit.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Employee Name | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Days Present | Notes |
| 2 | Jordan Blake | P | P | P | P | P | 5 | |||
| 3 | Sam Rivera | P | L | P | A | P | 4 | Absent Thu | ||
| 4 | Taylor Kim | P | P | S | P | P | 5 | Sick Wed pm | ||
| 5 | Alex Chen | V | V | P | P | P | 3 | PTO Mon-Tue | ||
| 6 | ||||||||||
| 7 | ||||||||||
| 8 | ||||||||||
| 9 |
Template 3: Monthly Attendance Sheet
Employee, ID, title, and department with a day-by-day grid for the month, present, absent, and leave totals, and signature lines for the employee and manager.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Employee Name | Employee ID | Job Title | Department | Days 1-15 | Days 16-31 | Total Present | Total Absent | Leave Days |
| 2 | Jordan Blake | E-001 | Sales Associate | Sales | PPPPPPPPPPP.. | PPPPPPPPPPPP. | 21 | 0 | 1 |
| 3 | Sam Rivera | E-002 | Line Cook | Kitchen | PPPLPPPPPAP.. | PPPPPPPPPPPP. | 19 | 2 | 0 |
| 4 | Taylor Kim | E-003 | Server | Front | PPPPSPPPPPP.. | PPPVVPPPPPPP. | 18 | 1 | 3 |
| 5 | |||||||||
| 6 | |||||||||
| 7 | |||||||||
| 8 |
Template 4: Yearly Attendance Sheet
A twelve-month summary per employee with monthly totals, days absent, and an annual attendance percentage. For year-end reviews and audits.
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Employee Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Days Absent | Attendance % |
| 2 | Jordan Blake | 21 | 20 | 22 | 21 | 22 | 21 | 22 | 22 | 21 | 23 | 20 | 21 | 3 | 98.9% |
| 3 | Sam Rivera | 20 | 19 | 21 | 20 | 21 | 20 | 20 | 21 | 20 | 22 | 19 | 20 | 9 | 96.6% |
| 4 | Taylor Kim | 19 | 18 | 20 | 20 | 21 | 20 | 21 | 20 | 20 | 21 | 19 | 20 | 12 | 95.5% |
| 5 | |||||||||||||||
| 6 | |||||||||||||||
| 7 |
Template 5: Attendance Sheet with Payroll
Attendance fields plus working days, paid days, overtime hours, deductions, and a net-pay formula. For a small business that calculates wages from attendance.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Employee Name | Employee ID | Working Days | Paid Days | Absent Days | Overtime Hrs | Basic Salary | Deductions | Net Pay |
| 2 | Jordan Blake | E-001 | 22 | 22 | 0 | 3 | 3300.00 | 0.00 | =G2/C2*D2 |
| 3 | Sam Rivera | E-002 | 22 | 20 | 2 | 0 | 2860.00 | 260.00 | =G3/C3*D3-H3 |
| 4 | Taylor Kim | E-003 | 22 | 21 | 1 | 1 | 3080.00 | 0.00 | =G4/C4*D4 |
| 5 | |||||||||
| 6 | |||||||||
| 7 |
Template 6: Blank Sign-In Roster
A print-ready blank roster with name, signature, and time-in and time-out columns, plus a header for the event, date, and location. For meetings, training, and on-site sign-in.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | # | Name | Signature | Time In | Time Out | Notes |
| 2 | 1 | |||||
| 3 | 2 | |||||
| 4 | 3 | |||||
| 5 | 4 | |||||
| 6 | 5 | |||||
| 7 | 6 | |||||
| 8 | 7 | |||||
| 9 | 8 | |||||
| 10 | 9 | |||||
| 11 | 10 | |||||
| 12 | 11 | |||||
| 13 | 12 |
Status Codes to Use
Status codes are the single-letter shorthand that make an attendance sheet fast to fill in and easy to read. The rule that matters is consistency: use the same codes the same way on every sheet, and keep the legend visible so anyone reviewing the record understands it. Here is the common set the templates use.
Adjust the set to fit your business, adding a code for unpaid leave or a partial day if you need one, but keep the legend on the sheet itself. A code without a visible key is exactly what confuses a new manager or an auditor reading the record months later.
How to Fill Out the Template
Filling out an attendance sheet takes a couple of minutes a day once it is set up. Here is the sequence the templates are built around.
Attendance Records and FLSA Compliance
Attendance and time records are not just internal notes. Under the Fair Labor Standards Act, they are part of the payroll record an employer must keep, and there are minimum periods you have to hold them for. A small business that discards attendance sheets at year end is creating a compliance gap that surfaces precisely when a wage dispute or audit arrives.
Two related points matter for the payroll version of the sheet. Non-exempt employees must be paid overtime at one and one-half times their regular rate for hours worked over forty in a workweek, and they must be paid at least the minimum wage. The federal minimum wage is $7.25 an hour, but many states set a higher rate, so confirm the rule for the state where your employees work. For the discipline side of chronic absence, the absenteeism policy templates cover the progressive-discipline steps with the same at-will and documentation guardrails.
Attendance Tracking for Small Business
A large company runs attendance through dedicated software and an HR team. A small business has an owner or a shift manager doing it directly, between everything else, and feels each absence more sharply because there is no bench. The framework is the same at any size; a small business just needs it kept simple, consistent, and compliant.
The single most valuable habit is picking one format, using it the same way every time, and holding onto the completed sheets. A consistent record you actually keep is what turns attendance from a guess into something you can manage and defend.
From Spreadsheet to HR Software
A spreadsheet attendance sheet is the right tool for a small team, and these templates work on their own. The point where it starts to strain is when attendance, leave requests, and record retention live in separate files that only the owner understands, and a missed absence or a lost sheet becomes a real problem.
When that point arrives, FirstHR centralizes what the spreadsheets were doing separately: employee profiles hold the roster, a self-service portal lets employees request and log time off, document storage keeps attendance and leave records in one retrievable place for the retention period, and the employee handbook and attendance policy live alongside the record. FirstHR is an onboarding and HR platform, not a payroll processor: it does not run payroll or calculate overtime hours itself, so pair it with your payroll provider and, for wage questions, a professional advisor. Applicant tracking is coming soon to FirstHR.
Frequently Asked Questions
What is an attendance sheet?
An attendance sheet is a document that records whether employees were present, absent, late, or on leave during a given period. It typically lists each employee by name and ID and marks a status for each day, using a legend of codes such as P for present, A for absent, L for late, S for sick, and V for vacation. Attendance sheets come in daily, weekly, monthly, and yearly formats, and a small business picks the one that matches its payroll cycle. The sheet serves three purposes: it gives managers a record of who was working, it surfaces attendance patterns that may need addressing, and it forms part of the payroll and recordkeeping trail that federal law requires employers to maintain. A good attendance sheet includes the status codes on the sheet itself and space for totals and a supervisor signature.
What is the difference between an attendance sheet and a timesheet?
An attendance sheet records presence and absence, whether someone showed up and in what status. A timesheet records hours worked and often the tasks or projects those hours went to. They overlap but answer different questions: attendance answers was the person here, and a timesheet answers how many hours did they work and on what. A small business tracking staffing, absence patterns, and discipline needs an attendance sheet. A business billing clients or paying hourly workers based on exact hours needs a timesheet to capture clock-in and clock-out times. Many businesses use both, and the payroll attendance template on this page bridges them by adding paid days and a net-pay calculation on top of the attendance record. For hourly overtime specifically, you still need actual clock hours, because overtime is owed on hours worked over forty in a workweek.
What should an attendance sheet include?
A complete attendance sheet includes identifying fields, attendance data, a status-code legend, and an audit trail. The identifying fields are the employee name and ID, and often the job title, department, company name, and the date or period the sheet covers. The attendance data is a status for each day, and for daily sheets often a time in, time out, and break. The legend is the key to the status codes, printed on the sheet itself so anyone reading it understands what P, A, L, S, and V mean. The audit trail is the running totals of present, absent, and leave days, plus space for supervisor initials or an employee and manager signature. The two elements small businesses most often leave out, and most need, are a visible code legend and a signature line, because both are what make the record clear and defensible later.
How do I create an attendance sheet in Excel?
The fastest way is to start from a template rather than a blank grid. Download one of the Excel attendance sheets on this page, and you get the columns, status codes, and totals already built. If you build your own, put employee name and ID in the first columns, then a column for each day of the period, then columns for totals. Add a small legend somewhere visible that defines each status code. For a monthly sheet, use one column per day across the month. To total automatically, use a COUNTIF formula to count how many cells in a row hold a given code, for example counting the P entries to get days present. Freeze the top row and the name column so they stay visible as you scroll. Every template here is already set up this way, with a frozen header row and a separate legend tab, so you can fill it in immediately.
Is there a free blank attendance sheet I can print?
Yes. The blank sign-in roster on this page is a print-ready attendance sheet with numbered rows and columns for name, signature, time in, time out, and notes, plus a header for the event or meeting, date, and location. It downloads as an Excel file you can print on Letter or A4 paper and fill in by hand, which makes it useful for meetings, training sessions, on-site sign-in, and events as well as day-to-day staff attendance. Because it is blank and generic, it works for any purpose that needs a simple record of who was present. If you want a version that tracks status codes and totals rather than just signatures, the daily, weekly, and monthly templates on this page do that instead, and all of them are free with no signup required.
How long do I have to keep attendance records?
Under federal law, attendance and time records are part of the payroll record and must be kept for a set period. The Department of Labor's recordkeeping rules under the Fair Labor Standards Act require employers to preserve payroll records for at least three years, and the records used to compute wages, which include time cards and work and time schedules, for at least two years. In practice, many advisors recommend keeping everything for three years to cover the longer window and the statute of limitations for wage claims. Some states require longer retention, so a business should confirm its own state's rule. The practical takeaway for a small business is simple: do not throw out completed attendance sheets at the end of the year. Store them somewhere retrievable and hold them for at least the required period, because they are the record you rely on if a wage dispute or audit arises. This is general information, not legal advice.
What do the status codes on an attendance sheet mean?
Status codes are single-letter shorthand for each employee's attendance status on a given day, and the sheet should always include a legend defining them. The common set is P for present, A for absent when the absence is unexcused, L for late, S for sick, V for vacation or PTO, and H for a company holiday. Some businesses add codes for specific situations, such as an unpaid leave code or a code for a partial day. The important rule is consistency: use the same codes the same way across every sheet, and print the legend on the sheet itself so anyone reviewing it, including a new manager or an auditor, can read it without guessing. The templates on this page include a legend on a separate tab and use this common code set, which you can adjust to fit your business.
How much does employee absenteeism cost a business?
Absenteeism is a real and measurable cost. The CDC Foundation reported that productivity losses linked to absenteeism cost US employers about $225.8 billion a year, or roughly $1,685 per employee. Industry estimates cited by SHRM put the cost of unscheduled absences even higher for hourly workers. For a small business the impact is sharper than the averages suggest, because a single absence on a small team removes a larger share of the day's capacity and often forces overtime or a scramble for coverage. This is exactly why tracking attendance consistently matters: an accurate sheet shows you the patterns, tells you which absences are excused versus unexcused, and gives you the record you need to address chronic problems fairly. The sheet itself does not reduce absenteeism, but it gives a small business the visibility to manage it.