Payroll Assurance›New Reconciliation
Checking API…
QA
New reconciliation

Upload the payroll register and funding workbook.

The platform will compare scope, wages, taxes, garnishments, checks and supporting transactions, then surface only the items that need attention.

2 files required

Source files

Step 1 of 1

Select both files to begin. They will be sent to the reconciliation API for deterministic analysis.

What will be checked

  • 1Scope alignment
    Pay period, entity population and control totals.
  • 2Wage funding
    Check + direct deposit versus funded amounts and recon items.
  • 3Tax funding
    Liability scope, bank collections and code-level exceptions.
  • 4Garnishments
    Principal, fees, WAType categories and collection differences.

Designed for auditability

Every issue is presented with the source amount, compared amount, arithmetic bridge, classification and supporting evidence.

MVP behavior: selected files are sent to the connected FastAPI service for analysis. The current backend processes them in temporary server storage and deletes the temporary copies after the request completes.

Analyzing payroll funding

Reading the uploaded sources and building the reconciliation model.

0%
  • 1
    Validate source filesConfirm file types, pay period and available populations.
  • 2
    Build payroll register controlsRead pays, checks, direct deposits, taxes and deduction codes.
  • 3
    Read funding workbookIdentify Page1 totals, UKG Wage, UKG Tax, UKG Garn and recon tabs.
  • 4
    Run reconciliation rulesTest scope bridges, signed recon items, fees and code-level differences.
  • 5
    Prepare findingsClassify resolved items, open variances and process controls.
Reconciliation history

Recent payroll reviews

Runs completed in this browser session. Persistent server-side history will be added in the next phase.

Reconciliation engine

Rules & classifications

The deterministic engine executes these rules against each uploaded pair. The frontend shows the returned arithmetic, classifications and evidence exactly as produced by the backend.

S

1. Scope before dollars

Compare the payroll register population to the funding workbook population before assessing any variance.

  • Pay period and period controls
  • Entity / company coverage
  • Out-of-scope tax codes
W

2. Wage bridge

Rebuild processed net pay and apply signed recon items exactly as stored.

  • Check Amount + Direct Deposit
  • DDA Net Check adjustments
  • Cancellation / refund items
T

3. Tax in two layers

Separate liability scope from collection differences so the product does not mix two different questions.

  • PDF liability vs workbook liability
  • Workbook liability vs bank collections
  • Code-by-code residual analysis
G

4. Garnishment principal first

Rebuild principal from source deduction codes before trusting Page1 residual formulas.

  • Separate fee codes
  • Compare to UKG Garn funding
  • Classify workbook-design residuals separately