Casual & Part-Time Labour Register with Payroll Calculator: Shift Pay with Overtime, Holiday and Night Rules, Pay-Run Holds, Outlet Labour Cost and a Timesheet Slip for Restaurant, Bar and Event Managers
Full description
For restaurant, bar, banquet and hotel managers, HR coordinators and payroll clerks who run a pool of casual and part-time staff. The main workbook holds a pool register with an hourly rate from your rate card, a register of shifts with scheduled and actual times, an advances log and an appraisals log. Each shift is split into regular, overtime, holiday and night hours; pay follows your settings and every shift is flagged: not in register, person not active, unsigned, overlapping, break missing or over schedule. Pay Period gives one row per person with gross pay, advances, deductions, the statutory deduction, net pay and a payment status of Ready or Hold. Outlet Cost compares casual pay with revenue, covers and budget hours against a cost range. The register also shows hours this month against a cap, incomplete files, idle people and appraisals due. The companion workbook prepares a timesheet and a printable payment slip for one person.
What is inside
- Casual_Labour_Register_and_Payroll_Calculator.xlsx: 11 tabs, 4,734 formulas, 2 native charts, 30 drop-down and input rules, 13 integrity checks
- Pool Register: 26 sample people plus 10 spare rows, with rate, shifts, last worked, hours this month, cap, file check, idle days and appraisal due
- Shifts: 132 sample shifts plus 30 spare rows, with paid, regular, overtime, holiday and night hours, pay components, allowance, gross and a shift flag
- Pay Period and Outlet Cost: net pay and payment status for every person; casual cost % against revenue, cost per cover and hours against budget for 3 outlets
- Dashboard with 9 tiles and 2 charts; Method with 12 rows
- Timesheet_and_Payment_Slip.xlsx: 4 tabs, 396 formulas, timesheet, payment slip and 9 checks
- Casual_Labour_and_Payroll_Guide.docx and PDF: 10 pages with 19 standards, equations, a worked example, a tracing exercise, forms and a pay-run checklist
- README.txt and LICENSE-and-Terms.txt
How it works
- Set the pay period, the overtime, holiday and night rules, allowances, deduction, cap, rate card and holiday dates on Settings.
- List the people and enter each shift with times, break and signature.
- Log advances, deductions and appraisals; fix every shift that is not flagged OK.
- Clear every Hold on Pay Period, pay, and issue the payment slip.
Details
- Formats: 2 Excel workbooks (.xlsx), 1 Word guide (.docx) and PDF, English
- Software: Excel 2016 or later, or LibreOffice Calc 7 or later
- No macros, no external links, no data tables, no array formulas
- 4 files plus README and license; instant digital download
Good to know
- Sample data is illustrative. Replace it with your own figures.
- Overtime, holiday, night, cap and statutory values are inputs. The workbook does not know your labour law, contract or tax rules, and this is not legal or tax advice.
- It stores IDs only: no names, identity documents or bank details.
- Single-user license. Do not redistribute.
FAQ
How is overtime decided?
Paid hours above the daily threshold in a shift are overtime. The threshold and the multiple are on Settings.
How are holidays handled?
List the dates on Settings. All paid hours on those dates are paid at the holiday multiple and no overtime is added.
What puts a payment on hold?
A person who is not active, has unsigned shifts, has an incomplete file or has net pay below zero.
Can I add people, shifts or roles?
Yes. Pool Register has 10 spare rows, Shifts has 30 and the rate card has one spare role.
Do I need macros?
No. Every result is a standard worksheet formula.
