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. My advice to any owner is to start one before you need it, because no one can rebuild a past month's attendance from memory.
Below are six free templates: 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. Every file is an Excel download with no email required, and the tracking sheets have the status codes and totals built in.
Keeping the record matters because the cost of absenteeism is real. According to the CDC journal Preventing Chronic Disease (2009), US employers lose about $225.8 billion a year in productivity to employees' personal and family health problems, counting both missed days and reduced output at work. On a small team, a single unplanned absence removes a large share of the day.
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, staff attendance sheet, and employee attendance tracker all describe the same document.
The sheet is an employer-side record, kept by a manager or, in a small business, by the owner. Besides showing who worked, it reveals attendance patterns that may need attention and forms part of the payroll and recordkeeping trail that the Fair Labor Standards Act (FLSA) 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 presence and spot absence patterns, and a timesheet to capture the hours that drive pay. The payroll template below bridges the two if you pay straight from attendance, but hourly overtime always needs actual clock hours, because the Fair Labor Standards Act makes it due 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. Well-built attendance sheets share all four groups, shown below with what goes in each.
The two elements small businesses most often skip, and most need, are a visible code legend and a signature line. The daily, weekly, and monthly templates keep the legend on its own tab, the daily sheet has a supervisor-initials column, and the monthly sheet adds employee and manager signature lines.
Which Template Should You Use?
Match the template to your payroll cycle and business type. Use the daily sheet for shift work, the weekly or monthly sheet for those payroll rhythms, the yearly sheet 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 in one ZIP file or grab individual templates, free and with no signup. Each downloads as an Excel file with a frozen header row, and the daily, weekly, and monthly sheets add status codes, totals, and a legend tab. 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 | No call, no show | 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. | 23 | 0 | 0 |
| 3 | Sam Rivera | E-002 | Line Cook | Kitchen | PPPLPPPPPAP.. | PPPPPPPPPPPP. | 22 | 1 | 0 |
| 4 | Taylor Kim | E-003 | Server | Front | PPPPSPPPPPP.. | PPPVVPPPPPPP. | 20 | 0 | 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.8% |
| 3 | Sam Rivera | 20 | 19 | 21 | 20 | 21 | 20 | 20 | 21 | 20 | 22 | 19 | 20 | 9 | 96.4% |
| 4 | Taylor Kim | 19 | 18 | 20 | 20 | 21 | 20 | 21 | 20 | 20 | 21 | 19 | 20 | 12 | 95.2% |
| 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-H2 |
| 3 | Sam Rivera | E-002 | 22 | 20 | 2 | 0 | 2860.00 | 0.00 | =G3/C3*D3-H3 |
| 4 | Taylor Kim | E-003 | 22 | 21 | 1 | 1 | 3080.00 | 0.00 | =G4/C4*D4-H4 |
| 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 that the daily, weekly, and monthly templates draw on.
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 in the same file as the sheet. 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
Under the Fair Labor Standards Act, attendance and time records are part of the payroll record an employer must keep, not just internal notes, and you have to hold them for set minimum periods. A small business that discards attendance sheets at year end creates 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 according to the Department of Labor (July 2026), 30 states and the District of Columbia set a higher rate, so confirm the rule for the state where your employees work.
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 are no spare hands to cover. The framework is the same at any size; a small business just needs it kept simple, consistent, and compliant.
Using the Sheet as an Ongoing Attendance Tracker
A single filled-in sheet is a snapshot. An employee attendance tracker is the same sheet used continuously: one workbook per year, a tab for each period, and a running record that shows patterns no single week reveals. You start to see who is late on Mondays, which absences cluster around scheduled days off, and where coverage keeps breaking down.
For teams that split time between the office and elsewhere, add a code for on-site days, O for office, and mark it alongside the usual statuses. The weekly sheet handles this best, because a seven-day row shows a whole schedule at a glance when the question is who was in and on which days.
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 gives the records around attendance one home: employee profiles hold the roster, a self-service portal lets each employee keep their contact details current and sign documents, 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, so keep the daily attendance count on these sheets and run pay, overtime, and time off through your payroll provider, with a professional advisor for wage questions. Applicant tracking is coming soon to FirstHR.
Frequently Asked Questions
What is an attendance sheet?
An attendance sheet is an employer's day-by-day record showing, for each employee, whether they were present, late, absent, or on leave during a set period. Each row covers one person, identified by name and ID, and each day gets a short status code from a key: P for present, A for absent, L for late, S for sick, and V for vacation. Attendance sheets can run daily, weekly, monthly, or yearly, and a small business usually chooses the period that lines up with its payroll cycle. The record earns its keep in three ways: managers can see who actually worked, attendance patterns that may need addressing come to the surface, and the sheet becomes part of the payroll and recordkeeping file federal law requires employers to maintain. A good version keeps the code key with the sheet and leaves room for totals and a supervisor's signature.
What is the difference between an attendance sheet and a timesheet?
An attendance sheet tracks whether someone was at work, while a timesheet tracks how many hours they put in. The two records overlap, but they answer different questions. The attendance record gives each person a status for the day, such as present, absent, late, sick, or on vacation. A timesheet captures time, usually as clock-in and clock-out entries, and often notes which tasks or projects the hours went to. Choose by the question you need answered: staffing, absence patterns, and discipline call for an attendance sheet, while billing clients by the hour or paying hourly staff for exact time calls for a timesheet. Many businesses keep both, and the payroll attendance template on this page connects them, adding paid days and a net-pay formula to the attendance columns. It cannot stand in for clock hours on hourly overtime, though, because non-exempt employees are owed overtime for every hour past forty in a workweek.
What should an attendance sheet include?
Four kinds of information belong on every attendance sheet: who the record covers, what happened each day, what the codes mean, and proof that someone checked it. Start with identifying details, meaning each employee's name and ID, often with job title, department, company name, and the dates the sheet covers. Next comes the daily entry: a status code for each day and, on a daily sheet, often a time in, time out, and break. Then add a legend that spells out what P, A, L, S, and V stand for, so no reader has to guess. Close with an audit trail of running totals for days present, absent, and on leave, along with space for supervisor initials or employee and manager signatures. The legend and the signature line are the two pieces small businesses leave off most often, yet they are what keep 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, such as the daily, weekly, or monthly sheet, and you get the columns, status codes, and totals already built. If you build your own, start with columns for each employee's name and ID, then add 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. All six files open with the header row already frozen, and the three status-code sheets (daily, weekly, and monthly) carry their legend on a second tab, so you can start filling one in right away.
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?
Federal law sets a minimum of two or three years, depending on the record. Attendance and time records count as part of your payroll paperwork, and the Department of Labor's rules under the Fair Labor Standards Act require employers to keep payroll records for three years or more, and wage-computation records, such as work and time schedules and time cards, for no less than two. Many advisors hold everything for the full three years, which covers the longer window and the statute of limitations for wage claims. Some states require longer, so confirm the rule in each state where you have employees. For a small business the habit that matters is simple: never clear out completed attendance sheets at year end. File them where you can find them and keep them at least as long as required, since they are the record you will lean on if a wage dispute or audit comes up. This is general information, not legal advice.
What do the status codes on an attendance sheet mean?
Each status code is a one-letter shorthand for how an employee spent a given day, and every sheet needs a legend that says what the letters stand for. The usual set is P (present), A (unexcused absence), L (late), S (sick), V (vacation or paid time off), and H (company holiday). You can add your own for situations that come up often, such as unpaid leave or a partial day. What matters most is consistency: a code should mean the same thing on every sheet you keep, and the legend should be somewhere anyone who reviews the record, whether a new manager or an auditor, can read it without guessing. On this page, the legend sits on a separate tab of the daily, weekly, and monthly templates, which draw their codes from this common set, and you can change the set to suit your business.
How much does employee absenteeism cost a business?
Absenteeism carries a real, measurable cost. In 2009 the CDC journal Preventing Chronic Disease published an estimate that health problems among employees and their families cost US employers roughly $225.8 billion annually in lost productivity, about $1,685 for each worker. That figure combines missed days with the reduced output of people who came to work unwell, and the study behind it was published in 2003, so treat it as a measure of scale rather than a current price tag. On a small team the hit is sharper than any national average suggests, because one absence removes a bigger share of the day's capacity and often means overtime or a scramble to cover the shift. Consistent tracking is how you respond: a reliable sheet reveals patterns, separates excused absences from unexcused ones, and gives you the record you need to deal with chronic problems fairly. The sheet will not lower absenteeism on its own, but it gives a small business the visibility to manage it.