1095-C RECONCILIATION WORKBOOK LAYOUT
Create these tabs in your controlled spreadsheet.

CONTROL
Year | Employer | Run ID | Source file versions | Prepared by | Review date
Raw HR rows | Raw payroll rows | Raw benefits rows
Distinct people by source | Distinct person-employer keys

SOURCE TABS: HR / PAYROLL / BENEFITS
Source person ID | Internal person key | Employer key | Effective start | Effective end | Source reference

CROSSWALK
Source system | Source ID | Internal person key | Employer key | Mapping evidence

EXCEPTIONS
Person-employer key | Presence pattern | Issue category | Relevant period | Evidence | Owner | Decision | Reviewer | Date

REVIEWED POPULATION
Person-employer key | Inclusion decision | Decision reference | Historical sources complete | Open issue

FICTIONAL CHECK DATA
All three systems: 112
HR and payroll only: 8
Payroll and benefits only: 3
HR only: 2
Benefits only: 1
Expected union: 126; HR: 122; payroll: 123; benefits: 116

FINAL BRIDGE
Source union:
Documented additions:
Documented consolidations / exclusions:
Reviewed preparation population:
Unresolved items:
Preparer loaded count / difference explanation: