Payroll Calculation

Description

This four-section workbook provides a detailed analysis of the projection of jobs to be created from operation over a specified period of time, an employee register, a payroll calculation and bi-weekly time sheet. From information supplied through job creation spreadsheet, you can use the time sheet to determine wages per pay period and flow this information into the employee register, thus calculating total company payroll per period, all with the use of this product package. Employee Register; Payroll Calculator; Individual Pay Stubs with Charting; Year-to-Date Payroll Calculation; and Federal Tax Tables included.

Workbooks included:

Job Creation Analysis – Corporate Officers; Executive Officers; Administrative Staff; Warehouse Staff; Employee Totals; Hours per Week; Hourly Rate; Total per Week; Total per Month; Total per Year; Payroll Tax and Year over Year Staff Projection.

Employee Register – Employee ID No.; Employee Name; Address; Social Security Number; Sex; Hire Date; Job Title; Regular Hourly Rate; Overtime Hourly Rate; Annual Salary; Pay Frequency; Annual Sick Leave Days; Annual Holidays Days; Annual Vacation Days; Exempt from Overtime; Pre-Tax Withholdings (Tax Status; Federal Allowance; 401(k) Contribution; Other); Federal, State Payroll Tax (State Tax, Local Tax, Social Security Tax, Medicare Tax); Post Tax Deductions (Insurance and Other).

Payroll Calculation – Employee ID No.; Employee Name; Pay Period Start; Pay Period End; Total Hours Worked; Regular Hours; Gross Pay on Regular Hours; Holiday Hours; Vacation Hours; Sick Hours; Overtime Hours; Gross Pay on Overtime Hours; Taxable Compensation; Non-Taxable Deductions; Gross Pay; Filing Status; Allowances; Pre-Tax Withholdings (Federal Allowance Tax, 401(k) Contribution Percentage, 401(k) Contribution Amount, Other Pre-Tax Withholdings); Federal Taxable Gross; Federal, State Payroll Tax (Federal Tax, State Tax, Local Tax, Social Security Tax, Medicare Tax); Post-Tax Deductions (Insurance and Other) and Net Pay.

Bi-Weekly Time Sheet – Company Name; Slogan and Logo; Department; Employee Id.; Employee Name; Employee’s Phone Number; Email’s Address; Manager’s Name; Week Commencing; Week Ending; Project Name; Task; Days of the Week Hours Worked; Regular Hours; Overtime Hours; Sick; Vacation; Public Holidays; Other; Total Hours; Chart and Data; Employee’s and Manager’s Signature.