WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Accounting Tutorials » Bookkeeping Tutorials » Payroll Formula

Payroll Formula

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

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 –

Payroll Formula Example 1

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

Popular Course in this category
Sale
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

Example 1.1

  • =$350 – $280

Net Amount Payable to the Employee will be –

Payroll Formula Example 1.2

  • =$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 –

Payroll Formula Example 2

Calculation of Gross Pay Per Week –

Example 2.1

  • =$10.50 * 38
  • =$399

Calculation of Total Withholdings –

Example 2.2

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

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

Example 2.3

  • =$399 – $275.19

Net Amount Payable to the Employee will be –

Payroll Formula Example 2.4

  • =$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 –

Payroll Formula Example 3

Calculation of Gross Pay Per Week –

Example 3.1

  • =$13.50 * 40
  • =$540

Calculation of Total Withholdings –

Example 3.2

  • =$45.90 + 19.44 + 51.30 + 106.92 + $110
  • =$333.56

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

Example 3.3

  • =$540 – $ 333.56

Net Amount Payable to the Employee will be –

Payroll Formula Example 3.4

  • =$206.44

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

Recommended Articles

This has been a guide to Payroll Formula. Here we discuss its calculation along with practical examples, and downloadable excel template. You can learn more from the following articles –

  • Payroll Records
  • Payroll Accounting
  • Payroll Tax
  • Income Tax vs Payroll Tax
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Accounting Course

You will Learn Basics of Accounting in Just 1 Hour, Guaranteed!

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Download Payroll Formula Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More