Free CSV template · 2026 year-end close

Free 2026 contractor year-end close tracker

Use this tracker to move contractor year-end close from a January reconstruction project into a controlled review of roster, classification, documentation, payment reconciliation, reporting treatment, and ownership.

Download contractor year-end close CSV ↓Year-end close guide →

Fields included

Payee / contractor	Canonical payee ID	YTD settled amount	Tax document status	Classification review status	Primary payment method	Backup withholding	Payment reconciliation status	Federal reporting review	State reporting review	Owner	Close status	Notes
Avery Example	CTR-1042	2850.00	W-9 on file	Reviewed	ACH	No	Reconciled	Needs review	Needs review	Finance	Open	Confirm final Q4 payments
Jordan Example	CTR-2210	1450.00	W-9 on file	Reviewed	Payment card	No	Reconciled	Payment-method review	Complete	Finance	Open	Review settlement-entity reporting treatment

Sample rows are illustrative. “Federal reporting review” is intentionally a review field rather than a yes/no filing output.

How to use the tracker

Use one row per canonical payee rather than one row per payment so year-to-date review is not distorted by duplicate profiles.
Keep classification review separate from tax-document status; a W-9 does not establish independent-contractor status.
Reconcile year-to-date settled amounts to the systems that actually moved money before applying information-reporting rules.
Record the primary payment method so direct payments are not automatically treated the same as payment-card or third-party-network transactions.
Treat the $2,000 federal amount as one input to review, not a stand-alone filing determination; document the reviewer and conclusion separately.
Review state reporting independently and assign an owner to every unresolved year-end exception.

Useful alongside

2026 contractor year-end close guide →2026 1099-NEC readiness checker →Worker classification review checklist →Contractor payment reconciliation template →

The spreadsheet is the handoff point, not the filing decision

Keep contractor records, payment history, reconciliation, and exception ownership connected so your tax adviser or filing workflow starts from a clean ledger.

Screen 2026 1099 readiness →