Projected PTO Balance
{{ formatAmount(totals.endingBalance) }}
{{ summaryLine }}
{{ formatAmount(totals.earned) }} earned {{ formatAmount(totals.used) }} used {{ formatAmount(totals.capLost) }} cap loss {{ formatAmount(totals.carryoverLost) }} carryover trim
PTO accrual inputs
Choose Hours or Days, then enter all PTO amounts in that same unit.
Enter the current balance; negative values work for borrowed-leave policies.
{{ unitLabel }}
{{ accrualMethodHint }}
Enter a non-negative rate; decimals are allowed for fractional hours or days.
{{ rateSuffix }}
Use whole periods or months, e.g. 6 for the next six accrual cycles.
Enter PTO already used in this range; add future scheduled leave under Advanced.
{{ unitLabel }}
Pick a quick-fill, then adjust unit, rate, cap, and periods to match the policy.
Optional date for ledger labels; leave as-is if only balances matter.
Use final, even, or first-period placement to match how your report summarizes usage.
Enter regular eligible hours per period, such as 80 for a biweekly schedule.
Common values: 12 monthly, 24 semimonthly, 26 biweekly, or 52 weekly.
Choose the reporting increment, from 0.01 for detail to 1.00 for whole units.
{{ cap_enabled ? `Cap on: trim each period at ${formatAmount(balance_cap)}.` : 'Cap off: balances can grow above the configured cap amount.' }}
{{ cap_enabled ? 'On' : 'Off' }}
Enter the policy cap in {{ unitLabel }}, such as 120 hours or 15 days.
{{ unitLabel }}
{{ carryover_enabled ? carryoverHint : 'Carryover off: no reset checkpoint is applied.' }}
{{ carryover_enabled ? 'On' : 'Off' }}
Enter the maximum PTO carried past the checkpoint in {{ unitLabel }}.
{{ unitLabel }}
Use a whole period number, often the final period of a policy year.
Planned future leave:
Add optional future leave by period, amount, and note; historical PTO stays in the main field.
No planned future leave rows.
Use a whole period number from 1 to {{ normalizedPeriodCount }}.
Enter planned PTO in {{ unitLabel }}; decimals are allowed.
{{ unitLabel }}
Optional note up to 80 characters, e.g. vacation, shutdown, appointment.
Period Opening Earned Used Planned Cap lost Carryover trim Ending Copy
{{ row.label }} {{ formatAmount(row.opening) }} {{ formatAmount(row.earned) }} {{ formatAmount(row.used) }} {{ formatAmount(row.planned) }} {{ formatAmount(row.capLost) }} {{ formatAmount(row.carryoverLost) }} {{ formatAmount(row.ending) }}
Brief item Value Note Copy
{{ item.label }} {{ item.value }} {{ item.note }}
No valid PTO projection to chart.

                    
:

Introduction

PTO accrual is the running balance of paid time away from work. A balance grows when a policy credits new hours or days, shrinks when leave is used, and may stop growing or be reduced when a cap, carryover rule, or reset point applies.

That running total matters because leave planning often happens before the pay cycle is finished. An employee may want to know whether a vacation week will leave enough time for a later appointment. A manager may need to explain why a balance did not grow after a cap was reached. HR may need a period-by-period view that shows earned leave, used leave, planned leave, and policy trims in one place.

Flow diagram showing opening PTO balance plus earned leave minus used leave, planned leave, caps, and carryover trims to reach ending balance

Policies differ. Some employers credit a fixed amount each pay period, some credit a monthly amount, some use an hourly rate such as one hour earned for every 30 hours worked, and some state the benefit as an annual allowance that is spread across payroll periods. PTO may also combine vacation, personal days, and sick time, so the rules behind one balance may not match another employer's leave bank.

A PTO projection is planning arithmetic, not a guarantee of entitlement, approval, payout, or legal treatment. In the United States, federal law generally does not require ordinary vacation or PTO, and state law, contracts, handbooks, and collective agreements can change how earned balances, caps, carryover, and payout must be handled.

Technical Details:

A PTO projection is a repeated balance calculation. Each period starts with the prior ending balance, adds the earned amount for that period, applies any accrual cap, subtracts leave that was already taken and future planned leave, then applies a carryover limit at the selected checkpoint period.

The earning rule is the first technical choice. Fixed pay-period and monthly policies credit the rate directly. Per-hour policies multiply eligible hours worked by the per-hour rate. Annual allowance policies divide the yearly amount by the periods per year before the projection begins.

Formula Core

The period formula below shows the order used for a single period. Display rounding changes visible numbers and exports, while the calculation keeps full precision until values are shown.

earned per period = rate, rate x hours worked, or annual allowance / periods per year after cap = min(opening + earned, balance cap) when the cap is on ending = after cap - historical used - planned leave - carryover trim carryover trim = max(0, balance after usage - carryover limit) at the checkpoint period
PTO accrual method rules
Accrual method How earned leave is calculated What to verify
Fixed per pay period The entered rate is credited in every projected period. Use the same period length as the payroll or handbook wording.
Fixed per month The monthly rate is credited once per projected month. Use a monthly projection when the policy accrues by calendar month.
Per hour worked Eligible hours worked per period are multiplied by the per-hour PTO rate. Enter only hours the policy treats as accrual-eligible.
Annual allowance spread over periods The yearly allowance is divided by periods per year and credited each period. Set periods per year before comparing the result with a handbook amount.

Usage timing affects when historical leave is subtracted from the ledger. The whole used amount can land in the first period, be spread evenly, or land in the final period. Planned future leave rows stay separate and are assigned to their own projection periods; a planned row beyond the projection length is applied to the final period and reported as a warning.

PTO policy adjustment and validation behavior
Rule or boundary Applied behavior Why it matters
Balance unit Hours and days are supported, but all balances, rates, usage, caps, and planned leave must use the same unit. Mixed hours and days need a separate conversion before projection.
Negative opening balance Allowed. Useful for borrowed PTO policies, but it can expose a negative period in the ledger.
Projection length At least 1 period is required, and the internal projection is capped at 260 periods. Very long schedules should be reviewed in smaller ranges.
Accrual cap The cap is applied after earned leave is added and before usage is subtracted. Using leave later in the same period does not restore earned leave already lost to the cap.
Carryover limit The selected checkpoint period trims the post-usage balance down to the carryover limit. Match the checkpoint to the policy year or reset point before relying on the trim amount.
Display rounding Visible figures can round to 0.01, 0.05, 0.10, 0.25, 0.50, or 1.00 units. The ledger may look cleaner, but rounded figures should not be treated as payroll-system source data.

Public examples show why PTO math needs policy context. Federal employee annual leave uses service-based accrual rates, while many private employers define their own vacation or consolidated leave plans. Some states treat earned vacation or PTO as wages and limit forfeiture rules. A general projection should therefore be checked against the specific policy and law that applies to the employee.

Everyday Use & Decision Guide:

Start with Balance unit and keep every amount in that unit. If the handbook gives PTO in days but payroll stores hours, convert first and use one unit for Opening balance, Accrual rate, PTO already taken in range, Balance cap, and planned leave rows.

Choose Accrual method from the policy wording. Fixed per pay period fits a policy such as 3.08 hours per biweekly paycheck. Per hour worked fits a policy such as 0.033333 hours per eligible hour worked. Annual allowance spread over periods fits a yearly grant that should be allocated across the selected number of periods.

  • Use Policy quick-fill only as a starting point. Check every number after applying 80 hours yearly, 1 hour per 30 hours worked, or 20 days yearly.
  • Set Historical usage timing to match the story you need the ledger to tell. Final-period timing is useful for a quick balance forecast, while evenly spread timing can better approximate a past range.
  • Turn on Apply accrual cap when the policy stops earning above a ceiling. Read cap loss before assuming all earned PTO increased the balance.
  • Turn on Apply carryover limit when a reset trims the balance at the end of a year or policy cycle. Check carryover trim and the checkpoint period together.
  • Add planned future leave rows for trips, shutdowns, appointments, or other known absences that should reduce the projection without being mixed into historical usage.

The best first pass is a short projection that matches one policy cycle you understand, such as six biweekly periods or twelve monthly periods. Once the ledger agrees with a known example from payroll or the handbook, extend the period count or add planned leave.

Do not treat a clean projection as an approval or payout answer. Use Projected PTO Balance for planning, then compare Accrual Ledger, Balance Brief, and any warnings before sharing the number with HR, payroll, or a manager.

Step-by-Step Guide:

Build the projection from the policy rule first, then use the result tabs to check the balance movement.

  1. Choose Balance unit. The unit label should appear beside opening balance, rate, usage, caps, and planned leave amounts.
  2. Enter Opening balance, then select Accrual method. The helper text should change to explain the selected earning rule.
  3. Enter the rate field shown for that method. For per-hour accrual, also enter Hours worked per period. For annual allowance, check Periods per year.
  4. Set Periods to project or Months to project, then enter PTO already taken in range and choose the timing rule in Advanced.
  5. Turn on Apply accrual cap or Apply carryover limit only when the policy uses those rules. Confirm the cap amount, carryover limit, and checkpoint period.
  6. Add Planned future leave rows when needed. Each row should show the period, amount, and optional note in the row summary.
  7. Clear validation errors such as a negative accrual rate, projection length below 1, negative PTO used, negative cap, negative carryover limit, or display rounding below or equal to zero.
  8. Read Projected PTO Balance, then open Accrual Ledger, Balance Brief, PTO Balance Chart, and JSON to verify earned leave, used leave, planned leave, cap loss, carryover trim, and ending balance.

Interpreting Results:

The headline Projected PTO Balance is the ending balance after every projected period. Read it together with the badges for earned, used, cap loss, and carryover trim. A balance can end positive while still dipping below zero earlier, so the ledger and warning area matter.

A high earned amount does not always mean the employee kept that much leave. If cap loss is greater than zero, the cap reduced the balance before usage was subtracted. If carryover trim is greater than zero, the checkpoint reset removed time that otherwise would have remained in the projection.

How to interpret PTO accrual outputs
Output cue Read it this way Check before using it
Earned PTO Total credited by the selected accrual method across the projection. Compare earned per period with the handbook rate or payroll example.
Historical usage PTO already taken in the range, placed according to the timing rule. Confirm whether first, even, or final timing best matches the record.
Planned future leave Future rows subtracted from the selected period. Look for warnings when a row lands beyond the projection length.
Cap and carryover loss Leave removed by the balance cap or checkpoint limit. Match both rules to the actual policy before explaining a lost amount.
Lowest balance The lowest point reached during the projection, reflected in warnings when it goes negative. Check whether borrowed PTO, unpaid time, or a timing correction applies.

The chart is a visual review of the same ledger values, not a separate calculation. If the chart, Balance Brief, and period rows disagree with the policy you intended to model, adjust the method, periods per year, usage timing, cap, carryover checkpoint, or planned leave rows before exporting anything.

Worked Examples:

Six biweekly periods with one planned vacation

With Opening balance set to 24.00 hours, Fixed per pay period set to 3.08 hours, six periods, 8.00 hours of historical usage at the final period, and a planned vacation of 16.00 hours in period 4, Earned PTO is 18.48 hours. Projected PTO Balance ends at 18.48 hours, with no cap loss and no carryover trim.

Cap reached before usage can help

Start with 112.00 hours, earn 5.00 hours per period for four periods, and apply a 120.00 hour balance cap. The projection earns 20.00 hours, but cap loss totals 12.00 hours because the balance reaches the ceiling in period 2 and stays there. The ending balance is 120.00 hours, not 132.00 hours.

Monthly annual allowance with a carryover checkpoint

Use days as the unit, set an annual allowance of 20.00 days spread over 12 periods, open with 2.00 days, and set a carryover limit of 5.00 days at period 12. The balance reaches 22.00 days before the checkpoint, then carryover trim removes 17.00 days. Projected PTO Balance ends at 5.00 days.

Planned leave row outside the projection

If the projection length is six periods and a planned leave row is entered for period 8, the row is applied to period 6 and the warning area reports that a planned leave row is beyond the projection length. Move the row into the intended period or extend the projection before relying on Accrual Ledger.

FAQ:

Should I use hours or days?

Use the unit used by the policy record you are checking. If payroll stores an 8-hour day but the handbook says 10 days, convert the entire run before entering the opening balance, rate, usage, caps, and planned leave.

Why did earned PTO not increase the balance?

The accrual cap may have been reached. The cap is applied after leave is earned and before usage is subtracted, so cap loss can appear even when usage later lowers the same period's ending balance.

Can I model borrowed PTO or a negative balance?

Yes. A negative opening balance is allowed, and the warning area reports when the projection drops below zero. Confirm whether the employer treats that as borrowed PTO, unpaid time, or an adjustment that should be corrected elsewhere.

Why does annual allowance depend on periods per year?

Annual allowance is divided by Periods per year to get the earned amount for each projected period. An 80-hour yearly allowance with 26 periods earns about 3.08 hours per period, while the same yearly allowance with 24 periods earns about 3.33 hours per period.

Does this decide whether PTO must be paid out?

No. The result is a balance projection from the inputs. Payout, forfeiture, sick-leave treatment, waiting periods, and use-it-or-lose-it rules depend on the policy and applicable law.

Are my PTO entries sent to a PTO backend?

No. The calculation, ledger, brief, chart values, copy actions, and downloads are generated in the browser session from the current page state.

Glossary:

Accrual
The amount of paid leave earned under a policy during a pay period, month, worked-hour period, or annual allowance split.
Earned per period
The PTO credited to each projected period after the selected accrual method is applied.
Balance cap
A maximum balance that stops additional PTO from remaining in the bank once the ceiling is reached.
Carryover limit
The maximum balance allowed after a reset checkpoint, often at the end of a policy year.
Policy trim
PTO removed by a cap or carryover rule rather than by taking leave.

References: