Tools
Payroll accrual calculator for weekly and biweekly pay
Paste your pay groups with their pay calendar, pay lag and gross per period. You get the unpaid days at month end, the accrued wages and on-cost, the entry for either reversing method, and how much of the month's payroll expense move is just the day count.
Most payroll accrual calculators handle one pay period that straddles month end. The case they miss is the pay lag: a period that ended in September but isn't paid until October is still unrecorded at September 30, so the accrual covers it in full plus the stub after it.
Runs entirely in your browser. Nothing you paste is uploaded or stored; it stays in your browser.
Month and settings
On-cost is your own rate for employer payroll taxes and benefits, applied to accrued wages. The tool doesn't suggest one. Weekdays have no holiday calendar.
Pay groups
One row per pay group, tab or comma separated: group, frequency, any pay period end date, pay lag days, gross per period. Frequency is weekly or biweekly. The date can be any period end from your payroll calendar; the tool steps forward and back from it. Pay lag is the days from period end to pay date (0 if paid on the last day). Gross per period is the expected gross for one full period. A header row is fine; dates are read month first.
How it's calculated
A pay period counts as recorded once its pay date is on or before month end. Everything worked after the last recorded period's end date, through month end, is accrued.
| Step | Rule |
|---|---|
| Last recorded period | The latest period end whose pay date (period end + lag) falls on or before month end. |
| Unpaid days | Weekdays (or calendar days) from the day after that period end through month end. With a pay lag this can be more than a whole period: one full period plus the stub after it. |
| Accrued wages | Gross per period × unpaid days ÷ days in a full period (5 or 10 weekdays, or 7 or 14 calendar days), rounded once to the cent, half away from zero. |
| On-cost | Accrued wages × your on-cost %, rounded once to the cent. |
| Last month | The same calculation at last month end, unless you enter what was actually booked. |
Which entry to book
If last month's accrual reverses on the first day of this month, book the full accrual again at month end. If it doesn't reverse, book only the change. Both end the month with the same total accrual. Reversing entries covers which accruals usually reverse, and true-ups covers what to do when the actual register comes in different from the estimate.
Why payroll expense moves when nothing changed
With the same gross per period, the payroll expense for a month on an accrual basis works out to the daily rate times the days in the month: the periods paid in the month, plus this month's accrual, less last month's. A month with one more weekday carries one more day of wages. The worked example shows it: the salaried group's August is 21 weekdays and September is 22, so September's expense is one day's pay higher with no change in headcount or rate. That's worth putting in the flux commentary before anyone goes looking for a new hire.
What it doesn't do
It handles weekly and biweekly pay only; semimonthly and monthly payrolls line up with month end differently. It has no holiday calendar, doesn't calculate payroll taxes from statutory rates, and doesn't accrue PTO, bonuses or commissions. It assumes the same gross for every period in a group; if pay changed during the month, split the group or adjust by hand. It doesn't post anything: it gives you the entry to book.
The pay groups and amounts in the worked example are synthetic.
Payroll expense is a line flux review asks about every month. The free flux template flags which balances moved enough to explain. The CloseOps Flux & Variance System ($79) starts from your trial balance instead: confirm each account's classification and it builds the income statement and balance sheet flux statements, then ranks what to investigate.
Related: reversing entries, for which version of the entry to book; true-ups, for when the actual payroll register arrives; month-end flux, step by step; and what can I flux right now?, where “payroll posted” gates the payroll lines.
Found something wrong or missing? Tell me here — anonymous, thirty seconds.