-Pre-flight check for payroll cutover. Make sure each employee’s net pay under SOS matches the old provider within a tight tolerance (default ±0.1%).
-Surface issues fast. It flags who’s off and which component caused it (Gross, Allowances, EE deductions, ER share, Tax) so you can fix before go-live.

1. Open the file
-Tabs: Inputs → Employee_Variance → Summary_Dashboard.

2. Paste your numbers into Inputs (one row per employee)
-OLD = outgoing provider; SOS = your new run.
-Fill these columns: Gross, Allowances, EE_Contrib (employee share), ER_Contrib (employer share), Tax_WHT.
-Keep headers as-is; add rows if you have more staff.

3. Check the dashboard (Summary_Dashboard)
-Look at % within 0.1% and the Problem List (employees over the threshold).
-Aim for ≥98% within 0.1%.

4. Investigate flags (Employee_Variance)
-For each ⚠️ row, see Component_Drivers to spot the cause (e.g., Allowances vs Tax).
-Fix your source numbers (or config in the payroll system), then paste updated values back into Inputs.

5. Re-run until green
-Repeat steps 3–4 until flags clear.
-Sign-off rule of thumb: ≥98% within 0.1% and no single net difference over ~₱1.00 (set your own internal floor if needed).

6. Share the result
-Save and circulate the dashboard (or export to PDF) with any noted exceptions for approval.

Tips:
-If your Excel doesn’t support FILTER, just use AutoFilter on Employee_Variance → Variance_Flag = ⚠️.
-Need simpler data entry? Tell me and I’ll ship a “Simple Mode” that only asks for Gross, Employee deductions, Tax, Allowances (hides the rest).