HR, Scheduling & Payroll Suite

HR, Scheduling & Payroll Suite runs the people side of a small business from one Excel workbook. Keep your employee records, plan the weekly roster, log hours, manage leave and run monthly payroll, and the dashboard pulls it together: headcount, new hires, turnover, average tenure, pending leave, gross and net payroll, employer cost, year-to-date cost and overtime, plus a department breakdown, an alerts panel, a 12-month payroll table and a list of who is out in the next 14 days.

The Employees tab works out probation end dates, tenure, effective hourly rate and leave balance for each person, and raises alerts for contracts ending, probation ending and negative leave balances. The Schedule tab is a weekly roster: pick a shift code from a dropdown and it totals hours, counts how many people cover each shift every day, and turns a cell red when someone is booked during their approved leave. The Timesheet splits clock-in and clock-out times into regular hours and overtime on its own.

Leave counts working days only, skipping weekends and the public holidays you list. Annual leave can accrue monthly or be granted upfront, with carry-over, and the Leave Balances tab fills itself in. Weekend days are configurable, including Friday and Saturday or Thursday and Friday weekends.

Payroll takes one row per employee per month and calculates base pay, overtime, deductions for unpaid leave, gross pay, employee and employer contributions, progressive income tax, net pay and total cost to the company. Duplicate rows are flagged before they can double a payment. Pick an employee and a month on the Payslip tab to get a printable payslip.

Tax brackets, contribution rates and the overtime rule are set by you on the Settings tab. The sample figures are for illustration only and are not the official rates of any country, so enter the rules that apply to your business and check them with your accountant or local authority.

Over 59,000 formulas sit in locked cells, so a stray keystroke cannot break a calculation. Protection has no password, so you can unprotect any tab to customise it. Sample data from an example company is included so you can see every tab working before you add your own. Built for Microsoft Excel (desktop or Excel for the web) and contains no macros.