{"product_id":"staff-roster-timesheet-and-leave-tracker","title":"Staff Roster, Timesheet and Leave Tracker","description":"\u003cp\u003eThis workbook is a record-keeping tool and general information only. It is not legal, employment, tax or financial advice.\u003c\/p\u003e\u003cp\u003eThis workbook holds personal information about people. Look after it: share it only with those who need it and keep it somewhere protected. It has no columns for pay, bank, identity or health details, so please do not type them into Notes either.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Shifts sit in one file, hours worked in another and leave requests in an inbox. Nobody has one clear view of who is rostered, how many hours were scheduled against worked, which leave is still waiting or who is away on a given day.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of staff, one of shifts, one of timesheet days and one of leave requests. The workbook adds up shifts per week, works out scheduled and worked hours for each person, flags overlapping shifts and shifts that fall on approved leave, and shows leave waiting and approved and who is on leave on the date you choose.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee shifts per week, with scheduled and worked hours, as a table and a chart.\u003c\/li\u003e\n\u003cli\u003eSee scheduled and worked hours for each person, and the difference.\u003c\/li\u003e\n\u003cli\u003eSee shifts by role and leave by type.\u003c\/li\u003e\n\u003cli\u003eSee leave waiting and leave approved, and who is on leave on your check date.\u003c\/li\u003e\n\u003cli\u003eSpot overlapping shifts and shifts on a day of approved leave.\u003c\/li\u003e\n\u003cli\u003eType your own leave statuses, leave types, first week, hours window and check date on Settings. Nothing is built in as a rule.\u003c\/li\u003e\n\u003cli\u003eChoose your industry (retail, hospitality or clinic administration) to load suitable Role and Area lists, then edit them to suit you.\u003c\/li\u003e\n\u003cli\u003eKeep your records in a clear structure: a Data Dictionary explains every column, and four export sheets repeat your staff, shifts, timesheets and leave under plain field names.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eHow it works\u003c\/strong\u003e\u003c\/p\u003e\u003col\u003e\n\u003cli\u003eEnter your business name, choose your industry, and type your leave statuses, leave types and dates on Settings.\u003c\/li\u003e\n\u003cli\u003eAdd your staff, then shifts, timesheet hours and leave requests.\u003c\/li\u003e\n\u003cli\u003eCheck the dashboard.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Small employers, such as cafes, shops and practices, who plan shifts and track leave from a list and want to see hours and leave in one place.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Anyone who needs a system that sends reminders, approves leave or works out pay or leave balances. This is a spreadsheet: it does not send anything, approve leave or connect to anything else.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you need.\u003c\/strong\u003e Microsoft Excel 2016 or later. It was tested in Excel for Windows. No macros, no add-ins and no subscription.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eGood to know\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e150 staff, 1,000 shift, 1,000 timesheet and 300 leave rows are ready, and you can add more by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003eShift hours run from start to end; an end earlier than the start is a shift that runs past midnight, and no break is taken off.\u003c\/li\u003e\n\u003cli\u003eTimesheet hours are typed by you; 7 hours 45 minutes is 7.75.\u003c\/li\u003e\n\u003cli\u003eAn example copy with a made-up cafe shows every sheet working before you start.\u003c\/li\u003e\n\u003cli\u003eNothing is locked or password protected.\u003c\/li\u003e\n\u003cli\u003eUse this template to capture and improve your business data now. In future you can automate with AI.\u003c\/li\u003e\n\u003cli\u003eGeneral information only. It is not legal, employment, tax or financial advice.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TeleWorld Online","offers":[{"title":"Default Title","offer_id":48859262582989,"sku":null,"price":39.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_faeb2491-f26e-45b6-b063-952bc957184e.png?v=1795096933","url":"https:\/\/www.teleworld.online\/te\/products\/staff-roster-timesheet-and-leave-tracker","provider":"TeleWorld Online","version":"1.0","type":"link"}