Skip to content
Sick Leave Tracker cover: a sample sheet with sick days taken, allowance left and days without a note and a bar chart, beside the Dashboard and Balances tabs

Sick Leave Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The Sick Leave Tracker is for office managers, HR assistants and small employers who record sick days against an annual allowance. The Balances tab lists each person's allowance, days used and days left. The Sick days tab logs each absence with the employee, start date, number of days, reason and whether a note is on file. The Dashboard totals days taken by reason and the days used and left by person.

Set each allowance to match your own policy and your state rules, since some states require paid sick time beyond what a company offers. Keep reasons general, such as Illness or Family care, and do not record diagnoses. Store the file in a restricted folder, because it holds health-related information about named staff. Rows of three or more days without a note turn red.

Useful for

  • Track sick days against each person's allowance
  • Spot absences that need a doctor's note
  • Report sick leave taken by team for the year

What's included

  • 4 tabs: Dashboard, Balances, Sick days, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Balances: a table
  • Sick days: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Balances tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Can each person have a different allowance?

Yes. Type a separate allowance in the Allowance column of the Balances tab. Days left works out from that number and the days already logged, so part-time staff and new starters can each have their own amount.

When is a doctor's note needed?

That depends on your company policy and local law, so check current rules where you work. The sheet only records whether a note is on file. Tick Note on file when you have one, and use the red highlight to find longer absences that still lack one.

What if someone uses more days than their allowance?

Days left turns negative and the row shows red, which makes the overspend clear. Decide with HR how to handle it under your policy, such as unpaid time or a carry-over, and note the decision beside the row so the balance stays accurate.

  • #attendance-tracker
  • #sick-leave-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More attendance tracker templates

See all 8

Also in Human resources

All human resources templates
Get this template

Preparing your template…