Payroll Formula

What is Payroll Formula?

Payroll formula, calculated differently from country to country, states a process through which the net emolument of the employee or worker is being calculated by deducting federal charges (such as income taxes), and all and other expenses( such as social security, Medicare, etc.) from the gross earnings.

Formula

Net Amount Payable to Employee = Gross Pay – Total Withholdings

Payroll Calculation

#1 – Types of Payroll

There are multiple types of employee and for that different technique of payroll calculation method is followed:

Payroll for hourly workers – To calculate the pay of hourly workers, few documents such as timecard or timesheet are required. Timecard or timesheet is a piece of relevant information for calculation of payroll calculation as it contains the required details of hours worked by an employee or worker. To calculate, the payroll based on hourly requirements, the organization also needs the rate assigned to the various classes of employees or workers. For example: if the worker has worked 38 hrs. A week and the payment schedule is for weekly payments with a rate of $12 an hour, the calculation would be as follows; 38 hrs. * 1 week * $12 per hour = $146.
Payroll Calculation for Salaried Workers – The U.S Department of Labor states that employees in the fixed salary are paid emoluments in terms of salary as a fixed amount and, generally the fixed pay receiver is not entitled to the overtime bonuses. Also, the DOL( Dept. of Labor) has specified criteria for calculation of overtime payments, so, it is better to comply with the criteria laid by DOL and work out the salary payments. For example – An employee has an annual salary of $84000 and he is being paid semi-monthly. Calculate the pay per salary for that particular person. $84,000 / 24 = $3500.

#2 – Deductions

There are multiple mandatory and voluntary deductions from the worker’s salary for federal reserves. The amount received is used by federal structure for multiple causes ranging from social security to medical expenses and so on.

Income Taxes – The employers need to deduct and withhold the portion of the employees’ wages as an income tax to be submitted and paid to the federal agencies. Forms like IRS W-4, or tax tables in IRS Circular E or Employers Tax guide helps the employee and employer to deduct taxes as per the requisite earning structure. The employee fills up a form with all the relevant details such as amount requires to be claimed by him or her, marital status and other required information for the filing of taxes with statutory agencies. The income tax varies for different salary brackets and keeps increasing with the increase in the earning slabs.
Social Security – An another deduction from payroll, these deductions are collected by Federal Insurance Contributions Act (FICA), to cater to social security needs such as disability programs, retirement benefits and so on. It has a wage-based limit and other rates that keep changing from time to time.
Medicare – It is an additional payroll tax deduction that is mandatory in nature, and unlike social security taxes, there is no base limit for deducting the Medicare taxes. The amount deducted is utilized by state and federal insurance and medical services.

#3 – Submission of Withheld Taxes

It is also the duty of an employer to deposit the withheld amount with federal agencies’ data-on a regular basis. The employers are required to report and submit to Federal Unemployment Taxes (FUTA) which also takes care of unemployment compensation issues. As per the IRS’s guidelines, an employer is required to submit details and withheld taxes on a quarterly basis in Form 941 (Employer’s Quarterly Federal Tax Return).

Examples

You can download this Payroll Formula Excel Template here – Payroll Formula Excel Template

Example #1

Calculate the Net amount payable to John a factory worker, if his Gross pay is $350 per week and Total withholdings are $280.

Solution

Below is the given information –

Calculation of net amount payable to the employee can be done as follows,

Popular Course in this category

All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings) 250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion

View Course

=$350 – $280

Net Amount Payable to the Employee will be –

=$70

So, the Net pay available to John is $70 per week.

Example #2

Tony is employed in a grocery store in the U.S and gets a salary of $10.50 per hour. Calculate the total amount to be deducted and withheld under the payroll formula. The health insurance rate is on a weekly basis. Calculate the Net amount receivable to Tony, we need to make certain adjustments for taxes and other deductions.

Solution

Below is the given information –

Calculation of Gross Pay Per Week –

=$10.50 * 38
=$399

Calculation of Total Withholdings –

=$33.92 + $14.36 + $37.91 + $79.00 + $110
=$275.19

Calculation of net amount payable to the employee can be done as follows,

=$399 – $275.19

Net Amount Payable to the Employee will be –

=$123.81

It indicates that out of total earning or gross pay of $399, only $123.81 would be received by the Tony after all deductions.

Example #3

Alisha is hired by a California salon and gets a $13.50 an hour wage. Under the payroll formula, determine the total sum to be deducted and withheld. The cost of health insurance is chargeable on a weekly basis.

Solution

Below is the given information –