Please enter data in cells that are red in color.
On the Annual Sheet, enter data in red cells on lines 1, 2, 5, and 9. "W2s" in Line 9 refers to the number of income/tax statements issued to current and former employees for the previous tax year. Most managers are surprised to learn the total number of people who worked for their company during the year.
In Column B of Row 10 on the Monthly Sheet, enter a number from 1 to 12 to correspond to the desired starting month for the workbook; 1 = January to 12 = December.
In Columns E and F of Rows 10 to 21 on the Monthly Sheet, enter the number of employees who left during the month (Col. E) and the number of employees who were hired during the month (Col. F).
Bob Gately
gately@csi.com