You ask, we build it. Missing the template you need? Send a request and a real person replies.
№ · Spreadsheets · Business

Leave that accrues itself. Payroll that adds up.

Log leave requests and pay runs; workdays, balances, what unused PTO is worth and gross to net work themselves out, with a colour-coded leave calendar for the whole team.

  • Google Sheets
  • Excel .xlsx
  • Blank + filled example

Instant download. Permanent link in your account.

Instant download. Permanent link in your account. Yours forever, no subscription.

PTO, Payroll & Employee Records, the Leave Calendar tab

The leave calendar: any month, everyone, each day of leave coloured by type.

What If

What does the owed leave cost?

The PTO still owed, as money, today and at the PTO year end, and who ends the year over a carry-over cap. Move the share taken before year end, or the cap.

PTO, Payroll & Employee Records, the What If tab

PTO Balances

Earned, taken and left.

Earned, carried in, taken, booked and left for every person, with sick leave kept apart.

PTO, Payroll & Employee Records, the PTO Balances tab

Payroll Register

Every pay run, gross to net.

Hours, overtime, bonus, deductions, gross and net for each person on each run.

PTO, Payroll & Employee Records, the Payroll Register tab

And the quiet ones

The team, the records and where to start.

PTO, Payroll & Employee Records, Team overview

Team overview

Headcount, who is out today, payroll this month, unused PTO value and anniversaries.

PTO, Payroll & Employee Records, Employee records

Employee records

Role, department, hire date, pay, allowances and cost an hour.

PTO, Payroll & Employee Records, Start here

Start here

Every tab in one line, then the order to fill it in. The first tab you open, and the only instructions you need.

The honest split of labour

You log the requests. It keeps the balances.

You type

  • Your people and their allowances, once
  • Each leave request
  • Each pay run

It works out

  • Workdays, skipping weekends and holidays
  • PTO balances, accrued
  • Gross to net, with overtime
  • What unused PTO is worth
Both apps, one price

Google Sheets or Excel. You do not have to choose.

The download carries both: the Sheets copy link and the native .xlsx. Every formula is chosen to work identically in the two, and we test the round trip on every build.

Google Sheets
Blank and filled-example copies, one click into your Drive.
Excel .xlsx
Native files, not exports. Blank and filled example included.
How buying works

A link, not a file to babysit.

One

Buy it once

$49, no subscription. Your order email and your account both carry the download, permanently.

Two

Copy it into your Drive

One click and it is yours, in your own Google account, forever. We keep no access to your copy and nothing in it phones home.

Three

Start in the example

The filled copy shows every tab already working. Poke it, break it, then open your blank and type your own.

Before you ask

The questions we actually get

Is there a year printed in it?

No. No year is printed anywhere in the files, so it starts the day you do and keeps working next year.

Does it work in Excel?

Yes. The same workbook comes as native .xlsx files, one blank and one filled with an example, checked in Excel with every formula recalculated.

Do I need spreadsheet skills?

No. Every formula is already built. Open the example copy first to see every tab working, then type into your blank one.

What exactly do I receive?

A small PDF with your links: the Google Sheets copy links, blank and filled example, and the native Excel files of both. Buying once covers your personal use in both apps, forever.

PTO, Payroll & Employee Records

Leave and pay, kept straight.

PTO, payroll and records, in Google Sheets and Excel, no subscription, no year baked in.

Get the tracker · $49

Not the sheet you need? See every spreadsheet template or ask at Templacity Hall.

№ · Reviews

Be the first to say something.

Nobody has written about this one yet. If it is on your device, yours is the first thing the next person reads.

Read by a person before it goes up, usually within a day. Your email stays with us and never appears on the page.

Instant download.

Your file is in your account the moment you check out, yours to re-download any time. A receipt lands in your inbox, too.

One-time purchase.

No subscription, no annual renewal, no upgrade nags. Pay once and the file is yours.

Quiet, secure checkout.

Stripe. Apple Pay. No spam, no “partners,” no reselling your details. Receipt, file, done.