2027 Payroll Calendar Template

A template that already knows the 2027 holidays

A payroll calendar is only as good as its holiday handling. The 2027 twist: three holidays fall on Saturdays (Juneteenth, Christmas, New Year's 2028). Federal offices close the preceding Fridays, but Federal Reserve settlement stays open — so ACH direct deposits process normally on June 18, December 24, and December 31. This template uses the Fed's actual settlement calendar, the same one banks clear against, so your pay dates match reality instead of the federal-employee day-off list.

The default template shown above runs the GSA pattern (26 biweekly paydays in 2027, EFT Fridays from January 15) — the schedule federal agencies themselves pay on. Payroll submission deadlines are typically 5–10 business days before the deposit date; with the CSV export (date, period start, period end, frequency) you can drop exact dates straight into a spreadsheet and compute check dates, submission cutoffs, and accrual periods from one source.

Frequently asked questions