Salaried and partial periods

A salaried employee is hired at an annual amount, but they are paid in pieces: every week, every two weeks, twice a month or once a month. Working out each piece is one division. The care goes into knowing how many periods a schedule has, and into paying the right amount when someone starts or leaves partway through a period. This page covers both, with a worked example for a small staff.

Pay per period in plain English

For a salaried employee, pay per period is:

Pay per period = annual salary ÷ pay periods per year, rounded to the cent.

The only thing to get right is the number of periods. The exercises use this example pay calendar:

Biweekly and semimonthly are the pair that causes trouble. They sound alike and both come out at roughly two paydays a month. The difference is that biweekly follows the calendar of weeks (52 weeks ÷ 2 = 26 periods), while semimonthly follows the calendar of months (12 months × 2 = 24 periods). That gives a biweekly employee two extra paydays a year, so each of their paychecks is smaller than a semimonthly employee's on the same salary.

A useful way to remember it: "bi-" here means "every two" (every two weeks), and "semi-" means "half" (half a month).

Worked example: Bluebird Veterinary

Bluebird Veterinary pays its salaried staff on different schedules. Here is each employee's annual salary and the pay per period it gives:

Take L. Adeyemi. Biweekly means 26 periods, so $86,900.00 ÷ 26 = $3,342.307..., which rounds to $3,342.31. For A. Rivera, semimonthly means 24 periods: $109,400.00 ÷ 24 = $4,558.333..., which rounds to $4,558.33.

In a spreadsheet, round each result to the cent with =ROUND(salary/periods,2). A cell formatted to show two decimals still holds the long unrounded number underneath, and that hidden fraction of a cent can carry into later steps. See round to the cent in Excel for why the difference matters.

Rounding has a side effect worth knowing about. C. Okafor's 52 weekly payments of $948.08 add up to $49,300.16, not exactly $49,300.00. Those few cents are a normal result of rounding each period. Some employers adjust the last payment of the year; the exercises simply round each period to the cent.

Partial periods: joining or leaving mid-period

When an employee starts or leaves partway through a period, they have not earned the full period's pay. The usual answer is to prorate: pay the share of the period they actually worked. There is more than one way to measure that share, and companies choose their own method. The exercises use one example company policy:

Example policy: pay this period = full-period pay × working days worked ÷ working days in the period, rounded to the cent.

Two details of this example policy matter:

• It counts working days in this particular period, not calendar days and not a fixed number for the year. A month with 23 working days and a month with 21 give different daily amounts.
• It starts from the rounded full-period pay, then rounds the prorated result to the cent.

Prorating a partial month

In July, four of Bluebird Veterinary's monthly-salaried employees joined or left partway through the month:

E. Haddad step by step:

• Full monthly pay: $124,800.00 ÷ 12 = $10,400.00.
• Share of the month worked: 8 of 23 working days.
• Pay for July: $10,400.00 × 8 ÷ 23 = $3,617.391..., which rounds to $3,617.39.

B. Chen shows why the order of rounding matters. Full monthly pay is $49,300.00 ÷ 12 = $4,108.333..., which rounds to $4,108.33. Prorating the rounded figure gives $4,108.33 × 19 ÷ 22 = $3,548.10. Prorating the unrounded figure instead would give $3,548.11. One cent is small, but a payroll that is a cent off is still wrong, and the example policy is clear: start from the rounded full-period pay.

In a sheet, that is =ROUND(ROUND(salary/12,2)*worked/workdays,2), or a full-period pay column and then =ROUND(fullpay*worked/workdays,2) next to it.

Mixed schedules

The hardest exercise mixes both ideas. Each employee has their own schedule, and only some of them had a partial period. First find the full-period pay for the right schedule, then prorate only if the employee did not work the whole period:

F. Larsen earns $127,200.00 a year, paid biweekly: $127,200.00 ÷ 26 = $4,892.31. They worked the whole period, so they receive the full amount. H. Ito earns $44,200.00 paid semimonthly, so the full period is $44,200.00 ÷ 24 = $1,841.67, and joining with 10 of 11 working days left gives $1,841.67 × 10 ÷ 11 = $1,674.25.

Notice that the working days in a period depend on the schedule. A weekly period here has 5 working days, a biweekly one 10, a semimonthly one about 10 to 12, and a monthly one about 20 to 23. The exercise gives you the exact count for each person.

Common mistakes

The exercises check for each of these and tell you which one you made.

Treating biweekly as twice a month

Dividing L. Adeyemi's $86,900.00 by 24 gives $3,620.83. Biweekly means every two weeks, which is 26 periods a year, so the answer is $3,342.31. In the mixed exercise, the same slip gives F. Larsen $5,300.00 instead of $4,892.31.

Treating semimonthly as every two weeks

The mirror image: dividing A. Rivera's $109,400.00 by 26 gives $4,207.69. Semimonthly means twice a month, which is 24 periods, so the answer is $4,558.33. D. Novak's $82,000.00 should be $3,416.67, not $3,153.85.

Paying the full period to someone who joined or left

Paying E. Haddad the full $10,400.00 for July overpays by $6,782.61. An employee who joined or left during the period is paid only for the working days they worked: $3,617.39 under the example policy.

Taking a daily rate from the annual salary

Another method you may meet divides the annual salary by a fixed number of working days in a year, such as 260, and multiplies by days worked. For E. Haddad, that gives $124,800.00 ÷ 260 × 8 = $3,840.00. It is a real method some employers choose, but it is not this exercise's example policy. The example policy prorates the period's own pay by that period's own working days, which gives $3,617.39. The lesson: read the policy you are given and apply it exactly.

Prorating from the unrounded amount

As B. Chen showed, prorating from $4,108.333... instead of $4,108.33 can move the answer by a cent. Round the full-period pay first, then prorate and round again.

How to check your salaried payroll

• Pay per period × periods per year comes back to the annual salary, give or take a few cents of rounding.
• For the same salary, weekly pay is the smallest, then biweekly, semimonthly and monthly.
• A prorated amount is always less than the full-period pay, and anyone who worked every working day gets exactly the full-period pay.
• Days worked over working days in the period gives the share paid. For B. Chen, 19 of 22 days is about 86%, and $3,548.10 is about 86% of $4,108.33.

Hourly staff are covered in overtime pay calculation, and sales pay in commission calculation. Once gross pay is known, payroll calculations in Excel takes it to net pay, and payroll journal entries records it in the books.