Tight Ship
All tools

Time and Attendance

PTO and Attendance Tracker

PTO and attendance tracker in Excel for service companies with a field crew.

Time off balances by the rules you type in, every request and decision, and who's out by trade each day.

$14.00

Buy now

Pay once. No subscription.

If a file won't open, won't work on your computer or Microsoft plan, or isn't what the page described, we fix it or refund you, your choice. Tell us within 14 days of your purchase.

Questions? Email support@tightshiphq.com

  • Needs Excel for Microsoft 365 or Excel 2021 or newer, on Windows.
  • No leave policy is included and no leave law is built in.

How you use it

  1. 2OUT TODAY

    Sample data

    People out each week, next 8 weeks

    10/263
    11/21
    11/92
    11/161
    11/234
    11/301
    12/71
    12/141

    Step 1. Open the sample-data copy first.

    It shows how it all fits together.

    A sample-data copy with a made-up crew and a made-up leave policy, counted as of Oct 26, 2026, so you can click around before adding your own.

    See the real screen: Dashboard

  2. Settings

    Sample data

    Company name
    Brightline Field Services
    Leave year starts
    1/1/26
    Hours per day
    8
    Workdays
    Monday to Friday

    LEAVE TYPES

    Leave typeKeeps a balanceEarnsAmount
    VacationYesYearly80
    SickYesMonthly4
    PersonalYesYearly16
    BereavementNo
    Jury dutyNo
    UnpaidNo

    Step 2. Save the blank workbook where you keep your work files.

    On its Settings tab, type your company name, your leave year's start date, workdays, company holidays, and your leave types and how each is earned.

    The Settings tab's leave types: each earns yearly, monthly, each pay period or by hand, with service steps, a start delay and a carryover cap. A blank file leaves every amount empty; the sample's amounts are made up.

    See the real screen: Settings

  3. Roster

    Sample data

    NameTradeRoleHire date
    Rick SalazarHVACService manager3/10/14
    Ray DelgadoHVACLead technician4/18/17
    Kim LarsenHVACService technician9/6/21
    Ben OkoroHVACService technician3/2/23
    Wes HarmonHVACInstall technician5/15/24
    Janelle OrtizElectricalService manager6/1/16

    Step 3. Add your crew on the Roster, with each hire date.

    The Roster: each person's trade, role, hire date and status. Out today and next leave fill themselves.

    See the real screen: Roster

  4. Adjustments

    Sample data

    PersonLeave typeHoursReason
    Rick SalazarVacation40Carried in
    Rick SalazarSick24Carried in
    Ray DelgadoVacation32Carried in
    Kim LarsenVacation16Carried in
    Kim LarsenSick12Carried in
    Ben OkoroVacation8Carried in

    Step 4. Type each person's carried-in hours on Adjustments.

    Adjustments: one row per change, with the date, person, leave type, hours and reason.

    See the real screen: Adjustments

  5. Leave Log

    Sample data

    PersonLeave typeFirst dayLast dayStatus
    Ray DelgadoVacation8/10/268/14/26Cancelled
    Ben OkoroVacation11/23/2611/25/26Approved
    Ben OkoroPersonal11/20/26Requested
    Wes HarmonVacation12/28/2612/31/26Requested
    Jon PruittVacation11/23/2611/25/26Denied
    Derek FongVacation11/23/2611/25/26Approved

    Step 5. Log each request on the Leave Log.

    Set its status when it's decided.

    The Leave Log: one row per request with the person, leave type, dates and status. Workdays, leave hours, used and booked fill themselves. A person sets every status.

    See the real screen: Leave Log

  6. Coverage

    Sample data

    Showing November 2026.

    TradeOut / crewMo 23Tu 24We 25
    HVAC5 active2/52/52/5
    Electrical3 active0/30/30/3
    Plumbing3 active2/32/31/3
    Office2 active0/20/20/2

    Amber: 50% or more of a trade out

    Step 6. Each week, open the Dashboard.

    Check Coverage before you approve a request.

    The Coverage tab for November: for each trade, how many are out each day out of how many, amber when half a trade is out, then each person's days off and company holidays.

    See the real screen: Coverage

Drawn from the sample data in the file. Each step links to the real screen. Made-up data only, in every file and every image.

What's included

  • PTO and attendance workbook, blank and ready to set up, with ten tabs: Start Here, Dashboard, Roster, Leave Log, Attendance Log, Adjustments, Balances, Year Calendar, Coverage, and Settings
  • A sample-data copy with a made-up crew (14 people, one marked Left) and a made-up leave policy, counted as of Oct 26, 2026, so you can click around before adding your own
  • A one-page quick-start PDF
  • A start-here text file

Before you buy

  • Needs Excel for Microsoft 365 or Excel 2021 or newer, on Windows. Checked in desktop Excel for Microsoft 365 on Windows.
  • Not tested yet in Excel for the web or Excel for Mac.
  • Not for Google Sheets, Apple Numbers, or Excel 2019 and older.
  • No leave policy is included and no leave law is built in. The blank workbook names six common leave types and leaves every amount empty, so you type your own policy.
  • No reminders: nothing is emailed or texted. The workbook shows who's out and what's waiting when you open it.
  • It doesn't connect to payroll. Time earned per hours worked is typed in from your payroll records.
  • Delivered as one .zip file. Unzip it first, then open the Quick Start PDF.
  • Digital download. Nothing is shipped.

A person makes every decision

This is a workflow and organizing tool for your crew's time off and attendance records. It holds the policy you type in and does the arithmetic. It doesn't know your state's leave laws, and it never approves, denies or scores anything. Not legal advice. Check your state and local rules. A person makes every decision.

Questions

Does it come with a PTO policy?

No. The blank workbook names six common leave types and leaves every amount, step and cap empty, so nothing reads as a suggested policy. You type your own policy's amounts after checking federal, state and local leave laws. The sample's amounts are made up for the sample.

Does it approve or deny requests?

No. A person sets every status. The workbook shows what's booked, who's out by trade and each balance, and never blocks a request, even one that takes a balance below zero.

Does it send reminders?

No. Nothing is emailed or texted. Open the Dashboard each week: it shows who's out in the next 14 days and the requests still waiting.

Does it keep an attendance score?

No. The Attendance Log records what happened, and nothing scores it or counts it per person. Before any absence counts against anyone, check federal and state leave law.

Does it work on a Mac or in Excel for the web?

Not tested yet. We've checked it in desktop Excel for Microsoft 365 on Windows. It uses no macros and only functions Excel 2021 has, but we haven't opened it in Excel for Mac or Excel for the web.

PTO and Attendance Tracker

$14.00

Buy now

Pay once. No subscription.