ASCEND PAYROLL
7

Historical imports

Stage ADP spreadsheets

Upload one spreadsheet at a time. Files are parsed into staged import rows, validated against deterministic counts and totals, and kept separate from canonical employee and payroll collections until promotion.

Employees.xlsx

Stages directory records with stable ADP employee codes and zeroed payroll totals for clean validation.

WageAndTaxRegister.xlsx

Stages employee-level payroll history rows with gross, net, and tax detail for payroll-entry promotion.

PayrollLiability.xlsx

Stages run-level liability snapshots for payroll-run promotion and summary cross-checks.

Recent import batches

Validation and promotion stay server-side. Imported history remains a snapshot and is never recomputed by the live engine.

Back to Settings

No staged batches yet. Upload an ADP workbook to create the first one.

Promotion rules

  1. 1. Stage spreadsheet rows into an import batch.
  2. 2. Run validation and review actual-vs-expected totals plus row-level issues.
  3. 3. Promote only validated batches into employees or historical payroll snapshots.
  4. 4. Keep failed or unvalidated batches out of canonical payroll data.
The page now exposes the full admin sequence: stage, validate, review, and promote. Imported history remains snapshot data and is never recomputed by the live payroll engine.