Periodicity Conversion

Rate conversion formulas convert amounts to different periodicities for payroll calculations. These calculations use rate conversion formulas:

  • Proration

  • Hours multiplied by rates calculation of an element run result

  • Rates based on rate definitions

Predefined Periods

These are the predefined periods for use when setting periodicity.

If these values don't meet your requirements, you can copy a predefined rate conversion formula and edit its periodicity values.

Periodicity

Valid for Payroll Periods

Number of Periods per Year

Annually

Yes

1

Bimonthly

Yes

6

Biweekly

Yes

26

Calendar Monthly

Yes

12

Daily

No

365

Hourly

No

2920 (365 days multiplied by 8 hours)

Lunar Month

Yes

13

Periodically

No

Payroll frequency determines the number of periods to use in the rate conversion.

Quarterly

Yes

4

Semiannually

Yes

2

Semimonthly

Yes

24

Workday

No

260

Weekly

Yes

52

Work Hour

No

2080 (260 days multiplied by 8 hours)

Define Periodicity

You can define periodicity in these ways:

Object

Task

Description

Elements

Elements

The Periodicity input value specifies the frequency of the element value.

For example, salary element entries that hold annual salary values have an annual periodicity.

Payrolls

Payroll Definitions

Period Type specifies the number of payroll periods.

For example, the Monthly Lunar period type includes 13 payroll periods.

Rates

Rate Definitions

Rate definition can specify the following periodicities:

  • Return periodicity of the rate

  • Periodicity of each rate contributor

  • Periodicity of the calculated sum of the rate contributors

Rate Conversion Formulas

Rate conversion formulas change the periodicity of an amount.

For example, the Standard Rate Annualized conversion formula can convert an annual salary amount to a weekly amount.

This table describes the predefined formulas.

Rate Conversion Rule

Description

Example

Standard Rate Annualized

Calculates the annual rate using the input periodicity and converts the amount to an output periodicity and rate.

This rule uses default values, such as 2080 hours or 260 working days, to calculate the annual rate. You select the day or hourly basis during element definition.

To convert a weekly amount to a semimonthly periodicity, the formula:

1. Multiplies the weekly amount by 52.

2. Divides the result by 24.

Standard Rate Daily

Calculates the daily rate using the input periodicity and converts the amount to an output periodicity and rate.

This rule uses a default value, such as 260 working days a year, to calculate the daily rate.

To convert an annual amount to daily periodicity, the formula:

1. Divides the annual amount by 365.

2. Multiplies the result by the number of days in the payroll period.

Standard Working Hours Rate Annualized

Uses the employee's standard working hours to convert the monetary value and working hours to an annual value before calculating the rate.

The employee works 40 hours a week with a monthly salary of 1000 CAD:

((1000*12)/(40.00*52) = 5.77 an hour

Assignment Working Hours Rate Annualized

Uses the employee's working hours to convert the monetary value and working hours to an annual value before calculating the rate.

The employee works 40 hours a week, with 37.5 standard working hours a week, and a monthly salary of 1000 CAD:

((1000*12)/(37.50*52) = 6.15 an hour

Periodic Work Schedule Rate Annualized

Uses the employee's work schedule for the payroll period for daily and hourly conversions.

For an employee:

  • With a monthly salary of 1000 CAD

  • Assigned a monthly payroll

The formula checks the work schedule details for the month.

For a daily conversion:

1000 a month/20 days in the month = 50

Note: For compensation calculations where the employee isn't assigned a payroll, the rate is calculated using the weekly rate calculation. The amount is converted to an annual figure and divided by the number of days or hours in that week based on the work schedule.

China Standard Rate Conversion

Uses the employee's work schedule to calculate the daily and hourly rates.

To convert a monthly amount to a daily periodicity, the formula:

  • Divides the monthly amount by 21.75

To convert a monthly amount to an hourly periodicity, the formula:

  • Divides the monthly amount by 21.75 first and then further divides the remainder by 8.

For example, if the input is 10,000 yuan per month.

  • The daily periodicity = 10000/21.75 = 460 per day

  • The hourly periodicity = (10000/21.75)/8 = 57.47 an hour

This formula defaults the periodicity value to Calendar Month. You can change the input periodicity to a value other than the Calendar Month. The China Standard Rate Conversion formula calculates the daily and hourly rate according to the input periodicity you specified.

If you set the periodicity to Annually, and if the input is 120,000 yuan per year.

  • The daily periodicity = (120000/12)/21.75 = 460 per day

  • The hourly periodicity = ((1200/12)/21) /8 = 0.595 an hour

The impact of the rate conversion rule is summarized below:

  • Periodicity: The conversion rule for periodicity applies to Flat Amount, Hours * Rate, and Days * Rate calculation rules. You can override the periodicity used as the default for the element definition at the element entry level.

  • Work Units: The Work Units conversion rule applies only to flat amount calculation rules for standard and supplemental earnings elements. The selection of which work units to use in reports and payslips determines the conversion calculation. The application creates the element input values using the default values of the rate conversion formulas.

  • Proration: The element template includes a new question for proration units. Proration rate conversion rules replace the previous proration methods in the element template. You have greater flexibility, for example, to base proration on calendar days when using work units for conversion.

    Note: If the conversion rules don't meet your requirements, you can copy and edit the rules using the Fast Formulas task in the Payroll section of My Client Groups.