How to use the payroll accrual split calculator
- Enter the first day and the last day of the pay period, both included.
- Enter the gross pay for the whole period.
- Choose whether to spread the pay across every calendar day or weekdays only (Monday to Friday).
- Read the amount that belongs to each month, and use the CSV if you want the figures in a spreadsheet for an adjusting entry.
Formula
pay per day counted = gross pay / days counted in the period
amount for a month = pay per day x days counted in that month
cents are assigned by the largest remainder so the months add up exactly
The days counted are every calendar day, or the weekdays only when you choose that. Holidays are not removed from the weekday count.
Two weeks that cross a month end
A pay period runs from Monday, October 26, 2026 to Sunday, November 8, 2026 and pays $4,200 gross. It has 14 calendar days, so each day is worth $300. October holds 6 of them (October 26 to 31) and November holds 8, so $1,800.00 belongs to October and $2,400.00 to November.
On the weekdays-only basis the same period has 10 weekdays, 5 in each month, so each month gets $2,100.00. A period that splits unevenly, such as $3,333.33 over 21 days, produces fractions of a cent. The page assigns the leftover cent by the largest remainder so the months always add up to the gross pay.
Why accruals need a split
When employees are paid after a month ends for work done during the month, the cost of that work belongs to the month in which it was done. Bookkeepers record the unpaid part as an accrued expense at month end. A pay period that crosses the month end therefore has to be divided between the two months, and the division is usually by days.
The calendar day method is simple and matches salaried pay that accrues evenly. The weekday method fits pay that is earned only on working days. Neither uses hours worked, so for hourly staff with varying hours, split by actual hours instead.
Choosing a method
Companies pick one method and apply it consistently, often the one that matches their payroll system. If your pay periods are fixed, such as every two weeks, the same shape repeats and the split can be computed in advance. For rent and other charges that are prorated by days, the Proration Calculator works the same way, and the PTO Accrual Calculator covers time off earned. Use the Gross Pay Calculator to find the gross pay itself.
Assumptions and limits
- Each counted day carries the same share of the gross pay.
- Weekdays are Monday to Friday. Public holidays and company closures are not removed.
- The period can be up to 731 days. Pay is rounded to whole cents with the largest remainder method.
- This is a bookkeeping aid, not accounting, payroll or tax advice. Follow your own policy and your accountant's guidance.
Frequently asked questions
Which days belong to the pay period?
Both the first and the last day you enter are counted. A period from the 1st to the 14th has 14 days, not 13.
Should I use calendar days or weekdays?
Use whichever your payroll or accounting policy uses. Calendar days fit pay that accrues every day, and weekdays fit pay for work done only on working days.
Why might one month be a cent different from my own math?
Dividing by days can leave fractions of a cent in each month. The page gives the extra cents to the months with the largest fractions so that the total is exact, which can differ by a cent from rounding each month alone.
Can I split a pay period over more than two months?
Yes. A long period such as a quarter is split into every month it touches, with one row per month and the same exact total.