Template 01
Close-to-File Filing Calendar
Turns one period-end date and your Rule 12b-2 filer status into the right report (10-K or 10-Q), the holiday-adjusted statutory due date, and a dated close-to-file milestone timeline.
Tab structure
- Instructions
- Setup – company, period end, FYE month, filer status; derives report type, fiscal quarter, period label and comparative dates
- 10-K Timeline – milestones by workstream with owner, T+ offsets for large accelerated / accelerated / non-accelerated filers, target date, business days to due, status
- 10-Q Timeline – same structure for quarterly filings; only the timeline for the detected report type is active
- Lists – dropdown values
- Holidays – observed federal holidays used for business-day math
Key checks and flags
- 10-K vs 10-Q detected from the period end and fiscal year-end month
- Statutory due date rolled to the next business day for weekends and holidays (Rule 0-3)
- Target dates from T+ offsets by filer status; business days remaining to the deadline
- Overdue milestones flagged in red
- "Statuses are for period" check flags last period's statuses as stale after you roll forward
Who uses it
The SEC reporting manager who owns the calendar, shared with the controller, auditors and reviewers.
Primary sources
Previews
Rendered from the actual workbook with illustrative sample data ("Example Company, Inc.", period end December 31, 2026). Scroll sideways on small screens.
Setup
Setup tab: one period-end cell drives report type, quarter, comparatives and deadlines.
10-K Timeline
10-K Timeline tab: milestones, owners, T+ offsets by filer status and target dates.