Most finance teams have a close calendar. Far fewer have one that someone doesn’t rebuild by hand every month.
The usual version is last month’s file with the dates typed over. It works until the month the 2nd business day is a holiday, or month-end lands on a Saturday and nobody shifts T-1. Then the calendar says one thing, the team does another, and the plan quietly stops being the plan.
A close calendar only has to answer three questions:
- What date is each day of close this month? T-5 through your target day, with weekends skipped.
- What happens on each day, and what do we need from other teams?
- Does a holiday land inside the close window? If it does, you want to know two weeks ahead, not on BD2.
Here’s how to build one that answers all three, plus a free Excel template that does the date math for you.
T-days and BD days, briefly
Close calendars count from month-end in two directions:
- T-days are the business days before month-end. T-1 is the last business day of the month, and T-5 is five business days before it.
- BD days (business days) count after month-end. BD1 is the first business day of the new month.
A “BD5 close” means the financials are final on the fifth business day. For an October 2026 close, that looks like this:
- T-5, Mon 10/26: the cutoff reminder goes out
- T-1, Fri 10/30: last business day of October (the 31st is a Saturday)
- BD1, Mon 11/2: close starts
- BD5, Fri 11/6: target, financials ready
Notice that T-1 isn’t the 31st. That’s exactly the kind of thing a hand-typed calendar gets wrong.
What goes on each day
The dates are the easy part. The value of a close calendar is in deciding, ahead of time, what happens when. A typical BD5 close for a small team:
- T-5: send the cutoff reminder email
- T-4: request open POs, new contracts and amendments. Need from others: open items lists from purchasing, legal and sales ops
- T-3: reconcile quiet accounts; build support for estimate-based accruals
- T-2: prepare fixed-schedule entries; follow up on T-4 requests
- T-1: review prepared entries; test bank feeds; block focus time. Need from others: all invoices and expense reports by 5pm
- BD1: post prepared entries; bank recs; cash. Need from others: payroll’s final register
- BD2: AP accruals; payroll accrual; revenue. Need from others: final bookings and contract changes from sales ops by noon
- BD3: remaining recs; intercompany; fixed assets
- BD4: flux analysis; first-pass review. Need from others: department heads available for variance questions
- BD5: final review; reporting package; lock period
- BD6: 15-minute retro; update the close log
Two things on that list matter more than the rest.
The week before close does real work. Prepaids, depreciation and standard accruals don’t need the month to be over. Preparing them at T-3 and T-2 means close starts with a chunk of the work already done, and BD1 is for posting, not building.
The “what we need from others” column is the point. Most close delays aren’t finance work running long. They’re inputs arriving late. Writing down who owes what, and by when, turns a vague expectation into a deadline people can see.
The holiday problem
Holidays are where hand-built calendars fail. If a holiday falls inside the close window, every BD date after it shifts by a day. Your BD5 target moves, and so does everything behind it.
The fix isn’t complicated. Check the window when you build the calendar, and if a holiday is in it, decide right then: pull more work into T-3 and T-2, or agree a later target with your CFO in advance. Either is fine. Finding out on BD3 is not.
Send it out at T-5
A close calendar that lives on one person’s drive doesn’t change anyone’s behavior. Send it to the departments you depend on at T-5, with the cutoff reminder:
Invoices and expense reports for October are due by 5pm Friday 10/30. Anything after that lands in November. The full close calendar is attached, including what we’ll need from your team and when.
One email, five business days early, heads off most of the late surprises.
The free template
We built a free Excel version so nobody has to retype dates again. You enter two things, the month you’re closing and your target day (BD3 to BD8), and it:
- Fills in every date from T-5 to BD8, skipping weekends and the holidays your company observes
- Warns you when a holiday lands inside the close window
- Comes with the example tasks above, plus the “what we need from others” column, all editable
- Prints on one page, so you can send it out at T-5
Next month, change the month. Everything else updates.
Get the free Close Calendar Generator →
It works in Excel (Microsoft 365 or 2019 and later) and uses formulas only, with no macros.
If you want the rest of close week handled
The calendar is one tab of our Close-Week Toolkit. The full Toolkit adds a close tracker with overdue and at-risk flags, a workload check that shows who’s over their daily hours before close starts, a log that triages ad hoc requests, and three close emails that fill in this month’s dates automatically.
Start with the calendar, though. Most teams get a calmer close from that alone.
General information, not accounting, legal or tax advice. Adapt the schedule to your company’s policies.