Restaurant payroll template
A free Excel sheet for a two-week pay period. Enter each employee’s hourly rate and the hours they worked in week 1 and week 2. The sheet splits regular and overtime hours (anything over 40 in a week, paid at 1.5x), adds cash tips, and shows gross pay per person and for the whole team.
What's in the sheet
Sample rows. Shaded columns calculate themselves.
| Employee | Hourly rate | Week 1 hours | Week 2 hours | Regular hours | Overtime hours | Regular pay | Overtime pay | Cash tips | Gross pay | Notes |
|---|---|---|---|---|---|---|---|---|---|---|
| Jamie | $18.00 | 40 | 40 | 80 | 0 | $1,440.00 | $0.00 | $0.00 | $1,440.00 | Line cook |
| Alex | $17.00 | 35 | 35 | 70 | 0 | $1,190.00 | $0.00 | $120.00 | $1,310.00 | Server |
| Maria | $19.00 | 47.5 | 24 | 64 | 7.5 | $1,216.00 | $213.75 | $85.00 | $1,514.75 | Covered two closing shifts in week 1 |
What each column is for
- Employee
- One row per person.
- Hourly rate
- Their regular hourly rate.
- Week 1 hours
- Hours worked in the first week of the period.
- Week 2 hours
- Hours worked in the second week.
- Regular hoursCalculated
- Up to 40 hours in each week.
- Overtime hoursCalculated
- Hours over 40 in each week, counted week by week.
- Regular payCalculated
- Regular hours times the hourly rate.
- Overtime payCalculated
- Overtime hours times 1.5 times the rate.
- Cash tips
- Cash tips you pay out with payroll.
- Gross payCalculated
- Regular pay plus overtime pay plus tips.
- Notes
- Role, covered shifts, anything to check.
How to use it
- 1Add each employee once with their hourly rate.
- 2Fill in the hours for week 1 and week 2 from your time clock or schedule.
- 3Add cash tips if you pay them out with payroll.
- 4Check the Total row, then send the hours to your payroll provider or accountant.
Where the spreadsheet stops helping
- Hours live in a time clock app, a schedule and a few texts about swapped shifts.
- Overtime gets counted for the whole period instead of week by week, and the numbers come out wrong.
- Every pay period someone rebuilds the same spreadsheet by hand.
In Markhub
Let staff clock in from the team chat
- 1Staff tap Clock in and Clock out inside the Markhub team chat. That tap is the record.
- 2At the end of the period, the manager asks MAKi to make the payroll sheet.
- 3MAKi builds it from the time records and pay rules. A person checks it before payroll goes out.
Staff clock-in is free. Start a workspace and invite your team from the chat.
Questions
How is overtime calculated?
Under the federal FLSA rule, hours over 40 in a workweek are paid at 1.5 times the regular rate. The sheet counts each week separately, so 47.5 hours in week 1 and 24 in week 2 is 7.5 overtime hours, not zero.
Does it handle daily overtime, like in California?
No. Some states, including California, also pay overtime after 8 hours in a day. If that applies to you, enter the daily overtime hours yourself and adjust the overtime column.
Does it calculate taxes or withholding?
No. It stops at gross pay. Taxes, withholding and tip credits depend on your state and payroll provider. This sheet gets the hours and gross pay right before you hand them off.
Does it work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas and dropdowns carry over. The CSV has the same sample rows as plain values.
More templates
- Daily sales report templateClose each store and channel, match sales to payments, and catch a short cash drawer the same day.
- Shift handover templateHand over what is open, what is blocked and what the next shift has to do by when.
- Equipment maintenance log templateRecord inspections, faults and repairs with downtime, parts cost and the next check date.
- Decision log templateRecord what was decided, why, and what happens next, so a month later you can still answer why.