Census Submission Portal

Review, validate, and submit your annual census data
2025 Limit
$23,500.00
SERVING RETIREMENT PLANS SINCE 1985

Experience. Reliability.
Accuracy. Accountability.

The RPA Annual Admin workspace brings census collection, document review, validation, eligibility analysis, compliance reporting, and filing preparation into one coordinated workflow.

Independent TPA Guidance Administration aligned to the plan document and RPA service agreement
Transparent, Individually Quoted Fees Service scope and pricing remain specific to each RPA engagement
Open-Architecture Workflow Designed to coordinate plan, payroll, recordkeeper, and advisor data
White-Glove Service A dedicated retirement benefits consulting team supports the annual cycle
Workflow Inputs
  • Plan document or adoption agreement
  • Prior-year and current-year census data
  • Plan questionnaire and sponsor confirmations
  • Recordkeeper reports and prior filing data, when available

Ready to begin?

Upload your plan files to begin the validation process

Initializing Validation Engine
Loading secure browser-based processing...
Adoption Agreement (Optional)
Upload the plan's ASCi Adoption Agreement to auto-extract eligibility requirements. Powers the eligibility calculation engine downstream. Supports ASCi Cycle 3 format.
Adoption Agreement

ASCi plan document (PDF)

Click or drop PDF
Analyzing...
RPA Parse eligibility engine
Agreement Parsed
--
-- fields extracted | View Eligibility
Plan Questionnaire

PRQ file with plan-level data

Click or drop CSV / Excel
Processing PRQ...
Parsing plan questionnaire
PRQ Loaded
--
Census Files Required
Upload both the Prior Year census (validated baseline) and Current Year census (to be validated and reconciled).
Prior Year Census

2024 validated baseline data

CSV or Excel
Processing census...
Parsing prior year data
Prior Year Loaded
--
-- employees
Current Year Census

2025 data to validate

Excel (.xlsx) preferred
Processing census...
Parsing current year data
Current Year Loaded
--
-- employees
Tip: For best results, upload the Current Year census as an Excel file (.xlsx) directly from the RPA template. CSV exports may have formatting differences.
Recordkeeper Balances (Optional)
Upload account balances from your recordkeeper to enable Top Heavy Testing, RMD Calculations, Force Payout Reports, and Form 5500 Reporting. Supports John Hancock TXT exports and Payout Worksheets, plus CSV and Excel formats. Upload TXT first for full plan data, then optionally add Payout Worksheet for names & SSNs.
Recordkeeper Balances

Account balances by participant

TXT, CSV, or Excel
Processing balances...
Parsing recordkeeper data
Balances Loaded
--
-- accounts | $-- total
Payout Worksheet Merged
0 participants enriched with names & SSNs
Smart Parsing: Auto-detects header rows and normalizes SSN formats for accurate matching

Your data is processed locally and never stored on our servers.

Confirm Your Plan Information

Review the following information from your Plan Questionnaire. Check the box next to each required field (*) to confirm it is accurate.

Please confirm all required fields above to continue.

Census Data Validation

0 Census Correction(s) Applied

Re-run validation to verify fixes and clear resolved errors

Validation results will appear here after processing.

Submit Your Census

Your Census Data is Ready!

All validation checks have passed. Choose how you'd like to submit.

Submit via Email

Send directly to your Client Account Manager

Download Package

Download validated files for manual submission

Plan Sponsor Command Center

Your census has been validated successfully! Welcome to your personalized plan dashboard. Monitor upcoming deadlines, track action items, and manage your plan all in one place.

--
Employees
--
Plan Year

Action Items

0 items

Loading action items...

Upcoming Deadlines

Next 90 Days
  • Loading deadlines...