Check a salary sheet for mistakes before paying
Catch wrong totals, missed deductions and odd jumps.
- ForOwners and HR who make salaries in Excel each month.
- HelperPayroll
- ModeBerri Mango 1
- AttachExcel sheet
Copy the prompt
Check this salary sheet for [month]. Recalculate gross, deductions and net for each row, compare with last month’s column, and list anything that looks wrong.
Change the words in [brackets] to your own.
What to attach
An Excel sheet (.xlsx). Berri reads the first sheet, so keep the data there.
Run it
Berri opens with the prompt filled in and the Payroll helper picked. Nothing is sent until you press send.
Run this in BerriTips
- Berri checks the maths and flags what looks odd; you decide what is right.
- Remove bank account numbers from the sheet before you share it.
Check a salary sheet for mistakes before payingPayroll
XLSsalary-nov.xlsx
Check this salary sheet for November. Recalculate gross, deductions and net for each row, compare with last month’s column, and list anything that looks wrong.
Reading salary-nov.xlsx
18 rows checked. Three need a look:
- Row 6: net is Rs 2,000 more than gross minus deductions
- Row 11: advance of Rs 5,000 last month is not deducted
- Row 14: salary up 40% from October, please confirm
- All other rows add up correctly
Figures here are made up to show the shape of the answer. Yours come from your own file and words.