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.

The six payroll calendar templates below put those dates on paper before the year starts: five editable Word documents and one 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 other names for it are pay period calendar and payroll schedule template. Both describe the same dated grid rather than the frequency decision behind it, and that grid is what the files below give you: a full year of rows with the cut-offs and the deposit deadlines already worked out.

The Five Columns It Needs

Five columns, and a calendar that shows only periods and pay dates carries three of them. The missing two, the approval cut-off and the deposit due date, are the ones that cause the failures, because a pay date on its own tells nobody when to act. Closure days sit beside them as a separate list, not a column.

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 often, which is why a semimonthly schedule needs a written shift rule more than any other.

Everyone in one list, with who they report to

Position, department, type, manager and status for each person. People who have left move to a separate list.

Start free trialSee how core HR works

My TeamManage your team members and their information#EmployeeDepartmentTypeStatus1Dwight SchruteAssistant to the Regional ManagerDepartmentSalesTypeFull-timeStatusActive2Jim HalpertSales RepresentativeDepartmentSalesTypeFull-timeStatusOn Leave3Ryan HowardSales AssociateDepartmentSalesTypeTemporaryStatusActive4Darryl PhilbinWarehouse ForemanDepartmentWarehouseTypeFull-timeStatusActive

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 have not settled on a frequency yet, biweekly is the most common choice. According to the Bureau of Labor Statistics (February 2023), an estimated 43.0 percent of private establishments pay every two weeks, against 27.0 percent weekly, 19.8 percent semimonthly, and 10.3 percent monthly. Construction runs the other way, with 65.4 percent of its establishments paying weekly.

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.

The overtime warning rests on a federal rule. Under 29 CFR 778.104, the Fair Labor Standards Act (FLSA) takes a single workweek as its standard and does not permit averaging hours over two or more weeks, so a workweek split across two pay periods is still totaled on its own.

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 not to skip 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 four that shift, the semiweekly payday table with the six Fridays that get an extra day, and quarterly Form 941 filing dates. Cross-check any date you rely on against the IRS employment tax due dates page and your own notices.

The deposit template also carries the FUTA deposit threshold and the year-end forms. According to the IRS guide to depositing and reporting employment taxes, a FUTA deposit is required only for a quarter in which the tax due exceeds $500, and Publication 15 lets an amount of $500 or less carry into the next quarter.

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 costs nothing; paying late can breach a state payday requirement and is the version employees remember.

There are eleven federal holidays a year, and the trickiest ones for a payroll calendar are those that fall on a weekend, because the observed day off moves to the Friday before or the Monday after.

Your own closure days are a third list, separate from both. A company that shuts between Christmas and New Year’s 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.

Org chart

Michael ScottRegional Manager3 departments

Dwight SchruteSalesReports to Michael

Darryl PhilbinWarehouseReports to Michael

My Team

Ryan HowardSales AssociateActive

Kelly KapoorCustomer ServiceActive

Jim HalpertSales RepresentativeOn Leave

Departments

Dwight SchruteSales3 people

Darryl PhilbinWarehouse1 person

Kelly KapoorCustomer Service1 person

Core HR

Who works here and who does what

Profiles, departments and an org chart, with every change kept on record.

Start free trial

The Year With an Extra Pay Period

A biweekly schedule pays 26 times in most years and 27 times in some. Twenty-six 14-day pay periods add up to 364 days, but a year has 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: spotting the extra date in time to settle salaried pay.

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, which IRS Tax Topic 757 defines for Form 941 filers as the four quarters ending June 30 of the prior year.

If the employment taxes you reported in the lookback period 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. Go above $50,000 and you are a semiweekly depositor, where the deadline follows the day of the week your pay date falls on.

Because of the lookback rule, a weekly employer can be a monthly depositor, and a monthly employer can be a semiweekly depositor. Pay frequency and deposit schedule are decided by completely different mechanisms, and the calendar has to carry both.

The $100,000 row overrides both schedules. According to IRS Publication 15 (2026), the rule counts tax accumulated within a deposit period (a calendar month for a monthly depositor), not one day’s payroll. At $100,000 the tax is due the next business day, and a monthly depositor turns semiweekly for the rest of that year and all of the next.

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 a personal note, not a calendar. 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 work 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.

Each run still starts from who is on the payroll. That is the part FirstHR makes easier: the employee record the calendar depends on (hire dates, departures, FLSA status, and work schedules) sits in one place with a dated history of every change, 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.

Start with the template that matches your pay frequency, then add your own closure days, confirm your depositor status, count the rows, and publish it before the first pay period opens.

Invite your team to FirstHR

4.7 on G2

Start free trial

Ryan HowardActive

Jim HalpertOn Leave

Frequently Asked Questions