Paste one month of the payroll register with the previous month's gross pay. The tool looks for repeated employee IDs, bank accounts shared by two employees, repeated names, zero pay and pay that moved by more than the limit you set. Flags are leads to inquire into, not conclusions.
Paste from Excel or CSV. Columns are found by header names; if a name is not recognised the default position above is used.
Set the limit from your client's pay cycle. A bonus month or an increment month will move many records. Remove personal data you do not need before pasting; nothing leaves your browser.
| Emp ID | Name | Bank account | Previous | Current | Flags |
|---|---|---|---|---|---|
| E002 | Sunita Rao | 918020045671 | 55,000.00 | 55,000.00 | Employee ID appears more than once; Bank account shared with another employee; Same name as another employee |
| E002 | Sunita Rao | 918020045671 | 55,000.00 | 55,000.00 | Employee ID appears more than once; Bank account shared with another employee; Same name as another employee |
| E006 | Tarun Gupta | 0.00 | 0.00 | Bank account missing; Zero or negative pay | |
| E001 | Ravi Kumar | 501002345678 | 42,000.00 | 42,000.00 | Same name as another employee |
| E003 | Anil Shah | 918020045671 | 30,000.00 | 30,000.00 | Bank account shared with another employee |
| E004 | Meera Joshi | 602003456789 | 38,000.00 | 61,000.00 | Pay moved more than the limit |
| E005 | Ravi Kumar | 701004567890 | 27,000.00 | 27,000.00 | Same name as another employee |
A payroll that pays someone who does not work there rarely looks odd in the totals. It looks odd in the detail: an ID used twice, two employees paid into one account, a pay figure that jumped for no stated reason. Run the tests on the register, then trace each flagged record to the appointment letter, attendance and the person who approved the change.
Employee IDs, bank account numbers and cleaned names are counted across the register. Any value that appears more than once is flagged on every record that carries it.
For pay movement, the current gross is compared with the previous gross. A record is flagged when the change, as a percent of the previous figure, is larger than the limit you enter. Records with no previous pay are not tested for movement.
Zero or negative pay and a missing bank account are flagged separately. All figures are read exactly as pasted.
Two employees in different departments are paid into the same bank account, and one record moved from 38,000 to 61,000.
