Template 01
SEC Filing Calendar Template: Close-to-File Timeline
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, plus the statutory due date, days left, Rule 12b-25 dates and the Part III date; ownership and review block
- 10-K Timeline – progress line (milestones complete, overdue, next milestone, days left), then 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)
- Rule 12b-25: Form 12b-25 due date (next business day) and extended due date (15 calendar days for a 10-K, 5 for a 10-Q)
- 10-K Part III date: 120 days after fiscal year-end, if Part III is incorporated from the proxy
- Target dates from T+ offsets by filer status; business days remaining to the deadline
- Next milestone and overdue count at the top of each timeline; overdue and blocked milestones flagged in red
- Holidays tab coverage check warns before the holiday list runs out
- "Statuses for" 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.