Home

Data Reconciliation

Compare employee data between BambooHR and Spectrum to find mismatches before going live.

BambooHR

Upload BambooHR CSV

Export "Full Employee Information" report as CSV

Spectrum

Upload Spectrum Master Report

Export Employee Master Report as CSV from Spectrum

Upload a paystub PDF to extract Spectrum PTO balances, compare against BambooHR, and sync differences.

Drop Paystub PDF here

This will only extract PTO data — paystubs will NOT be uploaded to BambooHR

Upload the Spectrum Pay Rates history CSV (from PR_Rate_Revision). Each employee's BambooHR compensation history will be replaced with their full Spectrum history.

Drop Spectrum Pay Rates CSV here

Full pay rate history per employee (Annual_Pay_Rate, Effective_Date, Pay_Type…)

Upload the Spectrum Employee Earnings History Summary CSV. Bonus checks (0 hours + Other Earnings) are imported into each employee's BambooHR bonus table. Rows already in BHR (same date + amount) are skipped automatically.

Drop Spectrum Employee Earnings History CSV here

Only company-wide bonus checks (Dec 2024+ = Tenure, earlier = Profit Sharing). One-off bonuses are skipped.

Comparison Results

	Code	Name	Status	Differences	Key Fields