How does the pro-rata calculation work? : SimplePay (2024)

Payroll Processing > Frequently Asked Questions > How does the pro-rata calculation work?

Please note: the explanations below refer to months but the same concepts apply to employees with other pay frequencies – simply substitute “month” with “week” / “fortnight”.

A pro-rata percentage is calculated automatically for salaried employees whenever a payslip is not for a full month. This usually occurs in one of three situations:

  • The employee started employment during themonth.
  • The employee’s service ended during themonth.
  • The employee worked for a full calendar month but your pay frequency ends on a day other than the last day of the month.

There is no set requirement for calculating pro-rata percentages, either from SARS or in the relevant legislation, so employers may choose the method they prefer.

SimplePay calculates the pro-rata percentage asdays employed / days in themonth x 100. The following examples illustrate how this is used in each of the three situations mentioned in the previous section:

  • If your pay frequency ends on the last day of the month and an employee starts on 15 March, the pro-rata percentage will be 54.84. This is calculated as 17 / 31 x 100, where 17 represents the days employed and 31 is the total days in the month of March.
  • If your pay frequency ends on the last day of the month and an employee’s service is ended on 20 April, the pro-rata percentage will be 66.67. This is calculated as 20 / 30 x 100, where 20 represents the days employed and 30 is the total days in the month of April.
  • The employee worked for a full calendar month but your pay frequency ends on a day other than the last day of the month.For example, if your pay frequency ends on the 25th of the month and an employee starts on the 1st of June, the pro-rata percentage will be 80.65. This is calculated as 25 / 31 x 100, where 25 represents the days employed and 31 is the total days in the current payment month (26 May to 25 June).

As mentioned in the previous section, there are no set rules for calculating pro-rata percentages, so you may override the calculated value to conform with the calculation generally used by your company.

The most common alternative to the above calculation is days worked / working days in month x 100:

  • For example, if an employee works Monday to Friday and starts employment on 22 June 2016, the pro-rata percentage would be 31.82. This is calculated as 7 / 22 x 100, where 7 is the number of days the employee worked and 22 is the number of working days for this employee in June 2016.

To change the pro-rata calculation method:

  1. Go to Settings > Payroll Calculations > Pro-rata Method.
  2. Select ‘Working Days’ as the Pro-Rata Method and the date that you want to start using this pro-rata method for.
  3. Click Save.

You may also wish to pay an employee their full salary even though they did not work the full period. You can do this by overriding the pro-rata percentage to 100.

To override the pro-rata percentage, go to the employee’s profile and click on the pro-rata percentage on the Payroll tab. Then enter the percentage you would like the system to use.

Please note that the tax calculation will still use the calculated pro-rata percentage using the calendar days method, in line with SARS’s requirements.

The main purpose of the pro-rata percentage is to ensure accurate tax calculations; therefore, it is currently only automatically applied to the Basic Salary as a convenience.

You can enable the pro-rata calculation for custom items that are Income, Allowance or Deduction items if they have been set up to with the Input Type as “Fixed Amount” or “Enter Amount Per Employee”.

More information on custom items can be found in the following article:

Payroll Setup > Company Setup > Custom Items

If any other system or custom items need to be pro-rated, you will need to manually calculate these and enter the relevant amount.

Still stuck? You can browse theindexfor related topics or simplycontact us.

You are using the help system of SimplePay,apayroll systemthat simplifies thepayroll process. Designed just forSouth Africa, it's a fully online solution.Read more.

How does the pro-rata calculation work? : SimplePay (2024)

FAQs

How does the pro-rata calculation work? : SimplePay? ›

SimplePay calculates the pro-rata percentage as days employed / days in the month x 100.

How is pro rata calculated? ›

Pro rata is a calculation that determines the fair distribution of a fixed amount. These calculations are common for issuing dividends and determining part-time salaries. You can calculate pro rata by determining the payee's portion and multiplying it by the total fixed amount.

How is pro rata determined? ›

The amount due to each shareholder is their pro rata share. This is calculated by dividing the ownership of each person by the total number of shares and then multiplying the resulting fraction by the total amount of the dividend payment. The majority shareholder's portion, therefore, is (50 / 100) x $200 = $100.

What does pro rata mean in simple terms? ›

This Latin term, meaning "in proportion," is crucial for a startup founder's financial decision-making process. In simple words, "pro rata" means allocating or dividing something based on a proportion or percentage.

How to calculate prorated pay? ›

The entire calculation is essentially a two-step process:
  1. Divide the employee's salary by the number of hours the employee is expected to work per year.
  2. Multiply the result by the total hours the employee actually worked during the prorated period.

How do you calculate a pro rata bill? ›

How to calculate a prorated amount
  1. Take the monthly rate and divide it by 30 to get the amount per day.
  2. Multiply the rate per day by the number of days to get the prorated sum.

How to calculate a prorated amount? ›

By the number of days in a month

For instance, say a tenant is moving in on the 25th of September and the full rent is $1,200. Calculating by the number of days in a month would look like this: 1200/30 x 5=200. Therefore, $200 would be the prorated rent.

How do you calculate pro-rata rule? ›

How Do You Calculate Your Taxable Percentage With the Pro-Rata Rule?
  1. (non-deductible amount) / (total of all non-Roth IRA balances) = non-taxable percentage.
  2. (amount to be converted to Roth IRA) x (non-taxable percentage) = amount of after-tax funds converted to Roth IRA.
Aug 1, 2023

How to calculate pro-rata bonus? ›

Calculating prorated bonuses is relatively straightforward. To do so, you need to divide the number of months, weeks or days the employee worked by 12, 52 or 365, respectively, then multiply the answer by the total bonus amount you would've paid for a full year's work.

What are pro-rata charges with an example? ›

Pro rata charges appear on your telecommunications bill for anything other than the standard recurring fees. For instance, if you sign up for a new service on the 15th of the month, but the billing cycle resets on the 1st of the month, you'll only be charged for the service you've received.

How to calculate pro rata calculator? ›

To calculate prorated rent, divide the total monthly rent by the number of days in the month to get the daily rent amount. Multiply the daily rent by the number of days the tenant will occupy the property during that specific month.

How to calculate pro rata increment? ›

Count the number of months actually worked, and divide it by the number of months under the current increase policy (typically 12 months). Multiply the result by the increase percentage the person would otherwise be entitled to. This is the prorated increase percentage.

What is the legal definition of pro rata? ›

Latin for “in proportion.” The term “pro rata” is used to denote proportional distributions or allocations. In a legal sense, pro rata may refer to a share to be received, an amount to be paid, or liability based on the fractional share of ownership, responsibility, or time.

How do you calculate pro rata money? ›

How to calculate pro rata salary
  1. Divide the full-time annual salary by 52 (number of weeks)
  2. Divide the result by 40 (standard full-time weekly hours) to get the hourly rate.
  3. Multiply the hourly rate by the number of actual work hours per week.
  4. Multiply this by 52 to get the annual pro rata salary.
Aug 13, 2020

How does prorated payment work? ›

Prorated billing is an invoicing method that charges customers based on the proportion of the service they have utilized in a billing period. This system ensures that customers are billed only for the number of days they used the service, not the entire month.

How to do pro rata calculation in Excel? ›

Yes, Excel can calculate pro rata based on varying periods or dates. Use the formula Pro Rata Amount = (Total Amount * Number of Days in Period) / Total Days in Year and adjust the date ranges to suit the specific period you're dealing with. Use Excel's date functions to help with calculations involving days.

What is the formula for pro rata basis? ›

The easiest way to work out pro rate salary is by dividing the total annual salary by the number of full-time hours. You can then multiply the result by the pro rata hours worked.

What are pro rata charges with an example? ›

Pro rata charges appear on your telecommunications bill for anything other than the standard recurring fees. For instance, if you sign up for a new service on the 15th of the month, but the billing cycle resets on the 1st of the month, you'll only be charged for the service you've received.

How to calculate pro rata bonus? ›

Calculating prorated bonuses is relatively straightforward. To do so, you need to divide the number of months, weeks or days the employee worked by 12, 52 or 365, respectively, then multiply the answer by the total bonus amount you would've paid for a full year's work.

How do you calculate pro rata per day? ›

Pro Rata in Everyday Life

They will do so by dividing the total monthly rent due by the number of days in the month to determine the amount of the rent that is proportionate to each day.

Top Articles
Latest Posts
Article information

Author: Ouida Strosin DO

Last Updated:

Views: 6337

Rating: 4.6 / 5 (76 voted)

Reviews: 91% of readers found this page helpful

Author information

Name: Ouida Strosin DO

Birthday: 1995-04-27

Address: Suite 927 930 Kilback Radial, Candidaville, TN 87795

Phone: +8561498978366

Job: Legacy Manufacturing Specialist

Hobby: Singing, Mountain biking, Water sports, Water sports, Taxidermy, Polo, Pet

Introduction: My name is Ouida Strosin DO, I am a precious, combative, spotless, modern, spotless, beautiful, precious person who loves writing and wants to share my knowledge and understanding with you.