Payroll Calendar Templates for Small Business

The first payroll question I could not answer as a founder had nothing to do with arithmetic. Somebody asked me which day they would be paid in the week of the Fourth of July, and I realized I had a pay frequency but no calendar. I knew we paid every two weeks. I did not know what happened when every two weeks landed on a day the banks were shut.

That gap is where small payroll problems come from. Not the tax math, which software handles, but the dates: a cut-off nobody was told about, a deposit deadline that moved because of a Monday holiday, a January that quietly contained an extra pay period. Six templates below, five as editable Word documents and one as a five-tab spreadsheet, free and with no email form.

What a Payroll Calendar Is

A payroll calendar is the dated schedule that turns a pay frequency into specific dates for a whole year. The frequency is an abstraction. The calendar is 26 or 24 or 52 actual rows, each carrying the deadlines that make the run happen on time.

It is a different document from a pay schedule, which is the policy decision about how often you pay. The schedule is one sentence. The calendar is the year of consequences that follow from it, including the ones nobody thinks about until the week they arrive.

The Five Columns It Needs

Five columns, and most published payroll calendars carry two of them. The missing three are the ones that cause the failures, because a pay date on its own tells nobody when to act.

The approval cut-off is the column that changes behavior. Employees care about the pay date and nothing else; managers only ever need to know their deadline, which is why sending them a recurring reminder tied to the cut-off works better than sending the whole calendar. Time that arrives after it goes on the next check, and saying that once in writing prevents a year of exceptions.

The right-hand column is the practical difference. A weekday-anchored schedule only ever collides with holidays, so it is stable and boring, which is what you want. A date-anchored schedule collides with weekends constantly, which is why a semimonthly schedule needs a written shift rule more than any other.

Which Calendar Should You Use?

Pick by your pay frequency, then add the processing checklist and the deposit calendar regardless of which one you took. Those two are frequency-independent and they cover the failures that pay dates alone do not.

If you also need the run itself calculated rather than just scheduled, that lives in the payroll spreadsheet templates, which handle gross to net and year-to-date totals. This page is the dates. FirstHR is an onboarding and HR platform, not a payroll provider, so it holds the employee record the calendar depends on rather than moving the money. Applicant tracking is coming soon to FirstHR.

6 Free Payroll Calendar Templates

Download all six together as a zip, or copy an individual template. Five are editable Word documents and one is an Excel workbook. Every date in them is built for one specific year on the assumptions stated at the top of each file, so confirm your own first pay date and your own depositor status before you rely on a deadline.

Template 1: Biweekly Payroll Calendar

Twenty-six Friday pay dates with period start, period end, approval cut-off and deposit due date on every row. The four cut-offs that move off a Monday holiday are already marked, and so is the year-end Friday where the banking answer is not the obvious one.

Template 2: Semimonthly Payroll Calendar

Twenty-four pay dates on the 15th and the last day of each month. Eight of them move, and each shows the date it moved from so the decision is visible rather than remembered. Includes the overtime warning for hourly staff whose workweeks straddle two periods.

Template 3: Weekly Payroll Calendar

Fifty-two workweeks on a Sunday to Saturday boundary, paid the following Friday, with a cut-off on every row. Built for hourly crews, where timesheet approval is the step that actually slips and where the workweek boundary decides the overtime.

Template 4: Payroll Processing Checklist

One copy per run, from five business days out through the cut-off, building, submitting, the pay date and afterwards. The step most often skipped is comparing this run to the last one line by line, which is the cheapest error check there is and the closest thing to a reconciliation you can do before the money moves.

Template 5: Tax Deposit and Filing Due Dates

The deadlines that are not pay dates: monthly depositor due dates with the three that shift, the semiweekly payday table, quarterly Form 941 filing dates, the FUTA deposit threshold, and the year-end forms. Cross-check any date you rely on against the IRS employment tax due dates page and your own notices.

Template 6: Payroll Calendar Builder (Spreadsheet)

Five tabs: all three frequencies as editable rows, a deposit and filing tab, and a holidays tab with blank rows for your own closures. Dates are in sortable ISO format so filtering to next month takes one click. This is the one to adapt if your pay day is not a Friday or your cut-off is not where the templates put it.

Weekends, Holidays, and Which Way to Move

When a pay date lands on a weekend or a holiday, move it back to the preceding business day. Never forward. Paying early is legal everywhere and costs nothing; paying late can breach a state pay-timing rule and is the version employees remember. There are eleven federal holidays a year, and the ones that matter to a payroll calendar are the ones that shift.

Your own closure days are a third list, separate from both. A company that shuts between Christmas and New Year has nobody available to approve time or fix a failed deposit, whatever the banks are doing. Put those days on the calendar when you build it, because the cut-off is the deadline that breaks first when the office is empty.

The Year With an Extra Pay Period

A biweekly schedule pays 26 times in most years and 27 times in some. Twenty-six payments of 14 days is 364 days, a year is 365 or 366, and that leftover day accumulates until a 27th pay date falls inside the same calendar year. Weekly schedules do the same thing with 53.

Whether it happens to you depends only on where your existing cycle sits. Two businesses paying biweekly on Fridays can hit the extra period in different years, which is why you cannot look it up and have to count your own rows. What matters for the calendar is narrower.

Deposit Dates Ignore Your Pay Cycle

Your federal tax deposit due dates are not derived from how often you pay people. They are set by a lookback period, and this catches out more small employers than any other rule on the calendar.

The lookback period is the four quarters ending June 30 of the prior year. If the employment taxes you reported in that window came to $50,000 or less, you are a monthly depositor for the coming year and you deposit by the 15th of the month after wages were paid. Above $50,000 and you are a semiweekly depositor, where the deadline follows the day of the week your pay date falls on.

So a weekly employer can be a monthly depositor, and a monthly employer can be a semiweekly depositor. The two are decided by completely different mechanisms and the calendar has to carry both.

How to Build Next Year’s Calendar

Four steps, in this order. The order matters because each one constrains the next, and doing them backwards produces a calendar you have to rebuild.

The step people skip is the first. Starting from January 1 feels natural and quietly creates a gap or an overlap at the year boundary, which then has to be explained to whoever gets a short check. Anchoring to your last pay date of the current year takes thirty seconds and removes the problem entirely.

If you are running the whole thing yourself rather than handing it to a provider, the calendar is the first artifact to produce and the one that makes the rest of the process manageable. Everything else in a pay run is triggered by a date on it. Applicant tracking is coming soon to FirstHR.

Publishing It So People Use It

A payroll calendar that lives in one person’s spreadsheet is not a calendar, it is a personal note. The whole point is that other people can see a deadline without asking, which means publishing it deliberately rather than attaching it to an email once.

Two versions works better than one. Employees get pay dates and nothing else, ideally alongside the payroll policy so the shift rule is written down in the same place. You keep the full version with cut-offs, deposit deadlines and filing dates, because those are operational and putting them in front of the whole company just adds noise.

That is the part FirstHR makes easier: the employee record the calendar depends on, new hires and departures and rate changes, all sit in one place with a dated history, so the person building the run is not chasing four inboxes to find out who started on the 12th. FirstHR is an onboarding and HR platform, not a payroll provider and not a tax advisor, so it does not move money, calculate deposits, or tell you your depositor status. Applicant tracking is coming soon to FirstHR.

Frequently Asked Questions