Fmla Tracking Spreadsheet – The Family Medical Law (FMLA) requires employee employers to leave the trail and estimate their return date. If you are a human resources manager or administrative assistant who has been assigned this task, you can set up an Excel program to track each employee’s license date, expected return date and current status. You will have contact information on your fingertips as well.
1 Collect all the paper documentation you need to transfer data to Microsoft Excel.
2 Open Excel and create 11 columns in a new spreadsheet, name, unique identifier field, address, city, state, zip code, phone1, phone2, date of return and status. Date of departure and return date should be date fields.
3 Enter all the data of your written records into the Excel spreadsheet. Status is recorded as an employee is on the way to return to work. Place an “unknown” state for employees who are seriously ill or have their license under open circumstances. Employees in this latter category of nursing include someone caring for a child or a spouse with cancer, for example.
4 Sort the data in “status”. You now have an employee monitoring system using the FMLA.
Fmla Tracking Spreadsheet
You may also like
Client Tracking SpreadsheetClient Tracking Spreadsheet – How To Make a Client Tracking Spreadsheet With the passage of time Excel templates have become our best ally to take care of
Small Business Expense Tracking SpreadsheetSmall Business Expense Tracking Spreadsheet – How to control expenses in Excel. To control expenses in Excel you have to record the expenses and income in
Spending Tracker SpreadsheetSpending Tracker Spreadsheet – How much money have you spent this month on clothes? How much money in fast food last month? And how much in
Credit Card Tracking SpreadsheetCredit Card Tracking Spreadsheet – The excel spreadsheet for Credit Card Expenses carries out a detailed follow-up of the operation, giving the balance according to payments