PTO Accrual Calculator

PTO per paycheck or hour worked, your balance on any date, and what it is worth.

  • Free, no sign-upNo sign-up
  • Hours or daysHours or days
  • Free Excel versionExcel file
  1. 1Pick a tab for the answer you needPick a tab
  2. 2Change the example to your own policyEdit the example
  3. 3Press Calculate to see the result and every stepCalculate

Use this when your policy gives a set number of days or hours a year and PTO is added on every payday.

Show in
From your offer letter or handbook
PTO is usually added on each payday
hrs
To show what you earn per hour worked

PTO Accrual Calculator results · aiforesight360.com/tools/pto-accrual-calculator/

Your result…Change the example to your policy, then press Calculate.
…
…
…

    Chart

    Paycheck by paycheck schedule

    Same result in Excel or Google Sheets

    Show the working
      01
      Start here

      How to use the PTO accrual calculator

      Short answer: pick the tab that matches your question, replace the example numbers with your own policy, and press Calculate. After the first result, every change updates instantly. The tabs pass numbers to each other, so you can go from your accrual rate to your balance on a date and its cash value in about a minute.

      1. Per paycheck

        Enter your yearly PTO in days or hours and how often you are paid. You get the PTO added to each paycheck, per month, per week and per hour worked, plus the same allowance on every other pay schedule.

      2. Hours worked

        For hourly and part-time staff. Enter the rate, such as 1 hour for every 30 hours worked, your usual hours per week and any yearly limit. You get PTO per week and per year, and the hours of work needed for one day off.

      3. Balance on a date

        Enter today's balance, the PTO added each paycheck, your next payday and a future date. Add time off you have booked, a cap or a carryover limit. You get the balance on that date, a chart and a paycheck by paycheck table.

      4. Value and payout

        Enter unused hours and an hourly rate, or a salary. You get the cash value of the PTO, the cost with employer payroll taxes, and the journal entry to record it.

      Tip: use Show in Hours or Days to switch every result, and change Workday if your day is not 8 hours (for example 7.5). Share link saves your exact numbers in a link, and Print or PDF gives a one page summary for HR or payroll.

      Where to find each number

      NumberWhere to find it
      Yearly PTO (days or hours)Offer letter, employee handbook or HR portal
      How often you are paidYour pay stub or payroll calendar
      Accrual rate per hour workedHandbook, or "accrual rate" on your pay stub
      Current PTO balanceLatest pay stub or HR system
      Cap and carryover limitThe PTO or vacation section of your handbook
      02
      The basics

      What is PTO accrual?

      Short answer: PTO accrual means you earn paid time off gradually as you work, instead of getting the whole year's allowance on day one. A little PTO is added on every payday, every month or for every hour worked, and it builds into a balance you can use for vacation, sick days or personal time.

      PTO stands for paid time off. Some employers combine vacation, sick and personal days into one PTO bank; others keep separate vacation and sick balances that each accrue on their own. That is why this PTO calculator also works as a vacation accrual calculator or a sick leave accrual calculator: the math is the same.

      A

      Accrual

      PTO builds up each pay period or hour worked. A new employee with 15 days a year has about 4.6 hours after the first biweekly paycheck, not 15 days.

      F

      Front-loaded

      The full yearly allowance is added at once, usually on January 1 or the work anniversary. Nothing to calculate per paycheck, but the balance resets each year.

      U

      Unlimited

      No set number of days and no balance that accrues. Time off is approved case by case, so there is usually nothing to pay out when someone leaves.

      US Department of Labor

      Federal law does not require paid vacation. The Fair Labor Standards Act "does not require payment for time not worked, such as vacations"; these benefits are matters of agreement between employer and employee. State laws and your own policy decide the rest. Read the DOL page

      03
      The formulas

      How do you calculate PTO accrual?

      Short answer: turn the yearly allowance into hours, then divide by the number of paychecks (for accrual per pay period) or by the hours worked in a year (for accrual per hour). Example: 15 days × 8 hours = 120 hours; 120 ÷ 26 biweekly paychecks = 4.62 hours per paycheck.

      Here is how to calculate PTO accrual by hand, with the same example all the way through.

      Yearly PTO hoursDays of PTO × Hours in a workday15 × 8 = 120 hours
      PTO per pay periodYearly PTO hours ÷ Paychecks per year120 ÷ 26 = 4.62 hours
      PTO per hour workedYearly PTO hours ÷ Hours worked per year120 ÷ 2,080 = 0.0577, about 1 hour per 17.3 hours
      PTO per monthYearly PTO hours ÷ 12120 ÷ 12 = 10 hours

      A full-time year is usually counted as 2,080 hours (40 hours × 52 weeks). The number of paychecks depends on how you are paid: 52 for weekly, 26 for every two weeks, 24 for twice a month and 12 for monthly.

      Watch out for biweekly pay: 26 paychecks is the normal count, but some calendar years have 27 biweekly paydays. If your employer accrues the same hours on every paycheck, you earn one extra paycheck's worth of PTO in those years unless the policy adjusts for it.
      04
      Quick reference

      PTO accrual per pay period: the table

      Short answer: with 8 hour days, 10 days a year is 3.08 hours per biweekly paycheck, 15 days is 4.62 hours, 20 days is 6.15 hours and 25 days is 7.69 hours. Find your row and your pay schedule below, or use the calculator for any other number.

      PTO per yearWeekly52 paychecksEvery 2 weeks26 paychecksTwice a month24 paychecksMonthly12 paychecks
      10 days80 hours1.543.083.336.67
      15 days120 hours2.314.625.0010.00
      20 days160 hours3.086.156.6713.33
      25 days200 hours3.857.698.3316.67

      Hours of PTO added per paycheck, rounded to two decimals. Payroll systems often keep more decimals, so a stub can show 4.6154 instead of 4.62.

      05
      Hourly and part-time

      PTO accrual based on hours worked

      Short answer: divide the PTO you earn by the hours it takes to earn it, then multiply by the hours you work. At 1 hour of PTO for every 30 hours worked, a 30 hour week earns 1 hour of PTO, and 52 weeks earn 52 hours (6.5 days of 8 hours).

      PTO per year from hours worked(PTO hours earned ÷ Hours worked to earn it) × Hours per week × Weeks per year(1 ÷ 30) × 30 × 52 = 52 hours
      Accrual rate20 hrsa week30 hrsa week40 hrsa week
      1 per 20hours worked5278104
      1 per 30hours worked34.675269.33
      1 per 40hours worked263952

      Hours of PTO earned in a 52 week year, before any yearly limit.

      The 1 hour per 30 rate is common in paid sick leave rules. Two examples you can check:

      US Department of Labor

      Employees of covered federal contractors earn "one hour of paid sick leave for every 30 hours worked," and contractors may limit accrual to 56 hours a year (Executive Order 13706). DOL fact sheet

      Colorado Department of Labor

      Under Colorado's Healthy Families and Workplaces Act, employees accrue "one hour per 30 hours worked, up to 48 per benefit year." CDLE summary (PDF)

      Ask whether overtime counts. Some policies accrue on every hour paid, others only on regular hours, and some leave hours (like PTO itself) may not earn more PTO. Enter only the hours that count under your policy.

      06
      Conversions

      How many days is my PTO in hours?

      Short answer: divide PTO hours by the hours in your workday. With 8 hour days, 40 hours is 5 days (a work week), 80 hours is 10 days and 120 hours is 15 days. With 7.5 hour days, 15 days of PTO is 112.5 hours.

      4 h½ day8 h1 day16 h2 days24 h3 days40 h1 week56 h7 days80 h10 days120 h15 days160 h20 days

      Based on 8 hour days. Change Workday in the calculator for any other length.

      07
      Limits

      PTO caps, carryover and use-it-or-lose-it

      Short answer: a cap stops PTO from accruing once your balance reaches a set number of hours; you start earning again after you use some. A carryover limit sets how much unused PTO moves into the new year. Use-it-or-lose-it means unused PTO disappears at a set date, which some states, such as California, do not allow.

      C

      Accrual cap

      Example: a 120 hour cap. At 120 hours, new paychecks add nothing until you take time off. Nothing you already earned is lost.

      R

      Carryover limit

      Example: up to 40 hours roll into January. Anything above that is forfeited at year end, unless state law says otherwise.

      L

      Use-it-or-lose-it

      All unused PTO expires on a set date. Some states, such as California, do not allow it, so check your state's labor department.

      California Labor Commissioner

      In California, a policy that forfeits earned vacation "is an illegal policy under California law," while a cap that "simply places a limit on the amount of vacation that can accrue" is allowed. The Labor Commissioner treats PTO policies the same way. California vacation FAQ

      Add your cap and carryover limit on the Balance on a date tab. The chart marks the payday you hit the cap, and the table shows hours lost at year end, so you can plan time off before December 31.

      08
      Money

      PTO payout: what unused PTO is worth

      Short answer: multiply unused PTO hours by the hourly pay rate. For a salary, find the hourly rate first: yearly salary ÷ 2,080 for a 40 hour week. Example: 64 hours × $30 = $1,920 before tax. Whether it must be paid out when someone leaves depends on state law and the employer's policy.

      PTO payoutUnused PTO hours × Hourly pay rate64 × $30 = $1,920
      Hourly rate from a salaryYearly salary ÷ (52 × Hours per week)$62,400 ÷ 2,080 = $30.00
      Federal rule

      No federal law requires paying out unused vacation; the US Department of Labor treats it as a matter of agreement between employer and employee. DOL vacation leave

      California

      Earned, unused vacation and PTO must be paid in the final paycheck, "at the final rate of pay in effect as of the date of the separation." California vacation FAQ

      Other states set their own rules, and many leave it to the written policy. A PTO payout is paid as wages, so normal payroll tax and withholding apply (federal rules treat vacation allowances as wages for withholding under 26 CFR 31.3402(g)-1). The Value and payout tab adds the employer's share of payroll taxes if you enter a rate.

      09
      For employers and accountants

      How do you record accrued PTO on the balance sheet?

      Short answer: under US GAAP (ASC 710), an employer records a liability for PTO employees have earned but not used when four conditions are met. The entry debits wages expense and credits accrued PTO payable, for the unused hours times the current pay rate.

      1. The obligation comes from work employees have already done.
      2. The PTO vests or accumulates (it is paid out or carries forward).
      3. Payment is probable.
      4. The amount can be reasonably estimated.

      The four conditions of FASB ASC 710-10-25-1, as summarized by the Journal of Accountancy. Sick days are accrued only when the policy lets employees bank them.

      Month end: record PTO earned but not used (example: 64 hours × $30)
      Dr Wages expense (PTO)$1,920.00
      Cr Accrued PTO payable$1,920.00
      When the employee takes the time off or is paid out
      Dr Accrued PTO payable$1,920.00
      Cr Cash or wages payable$1,920.00

      Many companies also accrue the employer's payroll taxes on the balance. In the US, the employer's share of Social Security is 6.2% and Medicare is 1.45%, a total of 7.65%, according to the IRS (Social Security stops at the yearly wage base). The calculator splits these into their own debit and credit lines when you add a tax rate.

      10
      Worked examples

      PTO accrual examples

      Full-time, salaried

      Maya: 15 days a year, paid every two weeks

      • Yearly PTO: 15 × 8 = 120 hours
      • Per paycheck: 120 ÷ 26 = 4.62 hours
      • One full day off after 2 paychecks; a full week after 9

      She earns 10 hours a month on average.

      Part-time, hourly

      Leo: 1 hour per 30 worked, 25 hours a week

      • Rate: 1 ÷ 30 = 0.0333 hours per hour
      • Per week: 0.0333 × 25 = 0.83 hours
      • Per year: 0.83 × 52 = 43.33 hours

      About 5.4 days a year of 8 hours.

      Employer payout

      A $62,400 salary leaves with 64 hours unused

      • Hourly rate: 62,400 ÷ 2,080 = $30.00
      • Payout: 64 × $30 = $1,920.00
      • Employer taxes at 7.65%: $146.88

      Total cost to the business: $2,066.88.

      11
      Free download

      PTO accrual calculator Excel template (free download)

      Short answer: download the free Excel template below. It has the same four calculators as this page, uses plain formulas you can see and edit, and works in Excel, Google Sheets and LibreOffice. Yellow cells are inputs; everything else updates by itself.

      PTO Accrual Calculator (Excel)

      • Per paycheck and per hour worked
      • Paycheck by paycheck balance with a cap
      • PTO payout and employer cost
      Download free Excel

      The same math in any spreadsheet

      What you wantFormula
      PTO per paycheck=B2*B3/B4 days × hours per day ÷ paychecks
      PTO per hour worked=B2/B3 PTO hours earned ÷ hours worked
      Running balance with a cap=MIN(Cap,C2+Accrual) fill down one row per payday
      Payout value=B2*B3 unused hours × hourly rate
      12
      Get it right

      Common PTO accrual mistakes

      • Using 26 paychecks for semimonthly pay.Twice a month is 24 paychecks, not 26. Using 26 understates each paycheck's accrual.
      • Mixing days and hours.A policy of "15 days" and a pay stub in hours need the same unit. Convert with your real workday, not always 8.
      • Ignoring the cap.Once you hit it, accrual stops. Booking time off before you reach the cap keeps PTO flowing.
      • Counting hours that do not accrue.Overtime, unpaid leave and PTO hours themselves may not earn PTO under your policy.
      • Paying out at an old rate.Where payout is required, states like California require the final rate of pay, not the rate when the PTO was earned.
      • Forgetting the liability.Employers who let PTO carry over or pay it out usually need to accrue it at month end, not only when it is used.

      How this calculator works

      • Uses the standard accrual, conversion and payout formulas shown on this page
      • Every table and example on this page was checked against the calculator and the Excel file
      • Legal points link to the US Department of Labor, the California Labor Commissioner, Colorado and the IRS
      • Runs in your browser; your numbers are never sent or saved
      • For planning only, not legal, tax or payroll advice; your policy and state law decide

      Built and checked by Ahmad Hussain, AI specialist and finance professional. Last reviewed .

      FAQ

      PTO accrual questions

      How do I calculate PTO accrual per pay period?

      Convert your yearly PTO to hours, then divide by the number of paychecks in a year. For example, 15 days of 8 hours is 120 hours, and 120 divided by 26 biweekly paychecks is 4.62 hours per paycheck. Use 52 for weekly pay, 24 for twice a month and 12 for monthly pay.

      How do I calculate PTO accrual based on hours worked?

      Divide the PTO you earn by the hours you must work to earn it, then multiply by your hours worked. At 1 hour of PTO for every 30 hours worked, each hour of work earns 0.0333 hours. A 30 hour week earns 1 hour, and 52 weeks earn 52 hours, or 6.5 days of 8 hours.

      What is a normal PTO accrual rate?

      There is no single legal standard, because federal law does not require paid vacation. Rates come from each employer's policy. Paid sick leave rules often use 1 hour for every 30 hours worked, for example for covered federal contractors and in Colorado. For full-time staff, 15 days a year equals about 4.62 hours per biweekly paycheck.

      How many hours is 15 days of PTO?

      With 8 hour workdays, 15 days of PTO is 120 hours. With 7.5 hour days it is 112.5 hours. Multiply the number of days by the hours in your normal workday. The calculator does this for you and can show every result in hours or in days with the Show in switch.

      How do I convert PTO hours into days?

      Divide your PTO hours by the hours in your workday. With 8 hour days, 40 hours is 5 days, 80 hours is 10 days and 120 hours is 15 days. If your workday is shorter or longer, change the Workday box in the calculator and every result switches to your real day length.

      How much PTO do I earn per paycheck with 10 days a year?

      Ten days of 8 hours is 80 hours a year. That is 3.08 hours per paycheck if you are paid every two weeks, 1.54 hours if you are paid weekly, 3.33 hours if you are paid twice a month and 6.67 hours if you are paid monthly. It takes three biweekly paychecks to earn one full day off.

      What is a PTO accrual cap?

      A cap is the most PTO your balance can hold. Once you reach it, new paychecks add nothing until you use some time off, so accrual pauses rather than earned hours disappearing. For example, with a 120 hour cap you stop earning at 120 hours. Enter your cap on the Balance on a date tab to see when you reach it.

      Does unused PTO roll over to the next year?

      It depends on your employer's policy and state law. Many policies let some or all unused PTO carry over, sometimes up to a set limit. In California, earned vacation and PTO cannot be forfeited, although a reasonable cap on accrual is allowed. Check your handbook, then test your carryover limit on the Balance on a date tab.

      Is unused PTO paid out when you quit or are fired?

      Federal law does not require it; the US Department of Labor treats vacation pay as an agreement between employer and employee. Some states do require payout. In California, earned and unused vacation or PTO must be included in the final paycheck at the final rate of pay. Elsewhere, your state's law and the written policy decide.

      How is a PTO payout calculated?

      Multiply the unused PTO hours by the hourly pay rate. For salaried employees, divide the yearly salary by 2,080 hours for a 40 hour week to get the hourly rate. For example, a $62,400 salary is $30 an hour, so 64 unused hours are worth $1,920 before tax. Employers also pay their share of payroll taxes on it.

      Do part-time employees earn PTO?

      Federal law does not require it, so it depends on the employer's policy and state or local rules. Part-time staff often accrue PTO per hour worked, for example 1 hour for every 30 hours. Paid sick leave laws, such as Colorado's, generally apply to part-time workers too. Use the Hours worked tab with your real weekly hours.

      Does overtime count toward PTO accrual?

      Only if your policy says so. Some employers accrue PTO on every hour paid, others only on regular hours up to 40 a week, and hours of PTO or unpaid leave often do not earn more PTO. Check the accrual section of your handbook, then enter only the hours that count in the Hours worked tab.

      Do employers have to record accrued PTO as a liability?

      Under US GAAP (ASC 710), employers record a liability for compensated absences when the PTO comes from work already done, it vests or accumulates, payment is probable and the amount can be estimated. The entry debits wages expense and credits accrued PTO payable. Sick days are accrued only when employees can bank them.

      Is there a free PTO accrual calculator in Excel?

      Yes. This page offers a free Excel PTO accrual calculator with the same four tools: accrual per paycheck, accrual per hour worked, a paycheck by paycheck balance with a cap, and the payout value with employer taxes. It uses plain formulas, works in Excel, Google Sheets and LibreOffice, and needs no sign-up.

      Need a calculator we do not have yet?

      Tell us what you work out by hand, and we may build it next.

      Suggest a calculator