Prorated Salary Worksheet

This worksheet prorates a gross salary for one full period using a day-count convention that you supply. Enter the full-period gross amount, the number of eligible days in that same period, and how many of those eligible days are paid. The paid count cannot exceed the eligible count.

Day-rate method

$\text{gross per eligible day}=\frac{\text{full-period gross salary}}{\text{eligible days}}$ $\text{prorated gross salary}=\text{day rate}\times\text{paid eligible days}$

The unpaid portion is the full-period gross salary minus the prorated gross salary. This method assumes every eligible day carries the same share of the entered full-period salary. It has no payroll calendar or jurisdictional default.

Example

For a full-period gross salary of $6,000, 20 eligible days, and 12 paid eligible days:

• gross amount per eligible day is 6,000/20= $300.00;
• prorated gross salary is 300×12= $3,600.00;
• unpaid portion is 6,000-3,600= $2,400.00.

Choose the day counts deliberately

The most consequential input is the eligible-day convention. Calendar days, scheduled workdays, and policy-defined paid days can produce different results. Do not mix a monthly salary with day counts from a different period, and do not count a paid holiday or leave day unless the applicable policy treats it as eligible and paid.

This worksheet does not determine wages, holidays, leave, taxes, deductions, payroll treatment, or legal entitlement. Check the entered day-count convention against the information applicable to your scenario before using the amount.

For a separate salary conversion, use the salary calculator, keeping every amount and day count in a consistent period.

Arithmetic boundary

Equal allocation across the user-entered eligible days is this worksheet’s transparent publisher arithmetic convention. It is not presented as a payroll, policy, agreement, or legal rule.