Payroll Analysis

Description: This document sets forth a template spreadsheet than can be used to analyze data about a company's payroll expenses. The spreadsheet will calculate certain earnings details, such as the various rates that employees are paid; amounts paid for payroll tax, including state and federal; and benefits, such as workers' compensation. There is also a worksheet to calculate the amount of earnings, amount of tax, and amount of benefits paid to each individual employee. Company management can use this spreadsheet to analyze the company's overall payroll expenses or to analyze the payroll expenses of certain employees.