Missing a template? Request it →
№ · Spreadsheets · Business

From the rota to the pay period, in one workbook.

Schedule shifts in one list; the weekly rota, the timesheet check and gross pay work themselves out, with overtime flagged and open shifts in plain sight.

Google Sheets · Excel .xlsx · Blank + filled example

Language

Instant download. Permanent link in your account.

Instant download. Permanent link in your account. Yours forever, no subscription. Open it live, read‑only.

Staff Schedule & TimesheetWeek
Staff Schedule & Timesheet, the Week tab

The week: people against days, coloured by role, with hours, wages and overtime.

The honest split of labour

You set the shifts. It works out the pay.

You type

  • Your staff and their hourly rates
  • The shifts, once
  • Clock in and clock out

It works out

  • The weekly rota, coloured by role
  • Overtime, flagged
  • Gross pay per pay period
  • Open shifts and hours to approve
Compared

A plain spreadsheet, and this one.

A plain spreadsheet The schedule

Names and breaks on one side. Hours, wages and the week ahead, on the other.

  1. 1

    Buy it once.

    €35, no subscription. Your order email and your account both carry the download, permanently.

  2. 2

    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.

  3. 3

    Start in the example.

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

The whole system: Contractor & Trades Spreadsheet Kit

Four sheets, one routine.

The estimator, the quote and purchase order pack, the staff rota and timesheet, and the bookkeeping workbook, together for €114.99 instead of €156.99. Every one in Google Sheets and Excel, blank and filled with an example.

  1. Estimate & Job Costing
    1

    Estimate & Job Costing

    Win the job at a price that clears.

    Alone €52.99
  2. Quotes & Purchase Orders
    2

    Quotes & Purchase Orders

    Order the materials on paper that fills itself.

    Alone €34.99
  3. Staff Schedule & Timesheet You are here
    3

    Staff Schedule & Timesheet

    The crew rota, and what they are owed.

    Alone €34.99
  4. Bookkeeping
    4

    Bookkeeping

    The month closes itself.

    Alone €34.99
Contractor & Trades Spreadsheet Kit €157.96 one by one €114.99 you keep €42.97
See everything in it

Separate files that share one routine, each the same file sold on its own page. Also in the Nonprofit Kit.

№ · Schedule it once, pay it right

A staff schedule and timesheet spreadsheet that flags overtime before the week starts

The Staff Schedule & Timesheet is for a cafe, shop, clinic or crew that schedules by the shift and pays by the hour. On Settings, set the day your week starts, the pay period (every two weeks to start) and when the first one began, the overtime limit (40 hours a week) and rate (1.5), and your roles. Add your people on Staff with their role, hourly rate and most hours a week.

Schedule, then what really happened

  1. Schedule on Shifts, one row per shift: date, person, role, start, end and unpaid break. Leave the person blank and it is an open shift.
  2. Week turns the list into a rota, people against days, coloured by role, with hours and wages each. Anyone scheduled past the overtime limit shows Overtime before the week starts, when it is cheapest to fix.
  3. Timesheet records clock in, clock out and break, sets the hours worked against the schedule, and takes an Approved tick.
  4. Pay Period gives regular and overtime hours and gross pay per person for any weekly or two-week period.

A shift that ends after midnight needs no trick: type the end time as it is. The same week again? Copy the week’s rows on Shifts, paste them below and add 7 to the dates.

The download is a short PDF with two Google Sheets buttons, one for a blank copy in your own Drive and one for a copy filled with an example, the same workbook as blank and example Excel files, and a one-page Quick Start for each.

Before you ask

The questions we actually get

How is overtime worked out?

Per week. Hours past the limit on Settings, 40 to start, in any one week are paid at the overtime rate, 1.5 to start. Both are yours to change.

What about a shift that ends after midnight?

Type the end time as it is. The hours still come out right.

Can it show open shifts?

Yes. A shift with no person on it is open, and the Dashboard counts the open shifts in the next 14 days.

Does it calculate net pay?

It gives gross pay per person for the period, regular and overtime. Taxes and deductions come from your payroll provider.

Does it work in Excel?

Yes. The download carries native .xlsx files, one blank and one filled with an example, for Excel 2010 and later, Excel for Mac and Microsoft 365. Every formula is ordinary Excel, with no macros to enable.

Staff Schedule & Timesheet

The rota and the pay, together.

Schedule, timesheet and pay period, in Google Sheets and Excel, no subscription, no year baked in.

Get the schedule · €35

Still deciding? Open it live, read‑only. 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.