Census Pro | Quick-Entry Tool

v.1.4.1

Welcome to Quick-Entry Census!

Here is your complete guide to rapidly collecting and managing census data.

Data Entry & Import

AI Auto-Mapping

Import unstructured CSV or Excel files. Provide your Gemini API key, and our AI will automatically detect headers, format dates, and group dependents under their correct employees.

Smart Zip Lookups

Type a 5-digit zip code to automatically fetch the City, State, and FIPS code. For zip codes spanning multiple counties, a dropdown will automatically appear for you.

Dependent Management

Add spouses and children directly under an employee. Use the "Extract to Employee" action button on any dependent to instantly split them into their own standalone household.

Premiums & Billing

Global Premium Rates

Set the default Adult and Child Premium rates in the top toolbar. The system will automatically calculate the total premium for each household based on the number of enrolled members.

Employer Contribution

Adjust the "Employer %" field in the toolbar to automatically calculate the split between the Employer Share and the Employee (Ee) Share across the entire census.

Manual Premium Override

Check the "Man" (Manual Override) box at the end of an employee's row to disable auto-calculation. You can then type in custom exact dollar amounts for their specific Total and Employer Share.

Don't show this again

Notice

Message goes here.

Are you sure?

This action cannot be undone.

Assign to Employee

Select the employee this dependent belongs to.

Keyboard Shortcuts

Add New Employee Ctrl + Shift + A

Add Dependent Ctrl + Shift + D

Move Up/Down ↑ / ↓

Next Field Enter

Import Paste Ctrl + V

Import & Map Data

The file you uploaded doesn't match the standard format. Please map the columns below.

Gemini API Key (Optional)

Quick-Entry Census

No employees added yet