Excel Automation
Salary File Automation
Salary comparison → filter (Active + FALSE) → fill upload template. Both comparison and upload template filling run seamlessly in a single step.
1
The client Salary file and the BenJ work file are matched on Employee ID (with SSN fallback).
2
Salary values are cleaned, normalised, and compared across both files to generate a comparison workbook.
3
Rows that have an Active status with a FALSE comparison match are automatically filtered for upload.
4
The upload template is populated and saved with yellow highlighted cell differences ready for direct portal import.
Input Files & Run
Requires Salary, Work, and Template files
Step 1 — Salary Comparison Files
Step 2 — Upload Template Destination
Ready