Mera Hisab
How to make the salary sheet
- Add your staff with their monthly salary or daily wage. If you already added them in the attendance sheet, they are here too: just set their pay with the pencil button.
- Choose the month. If you marked attendance, each person's days come from it. Otherwise monthly staff get the full month and daily-wage workers need their days typed in.
- Choose how the monthly salary is divided: by the days in the month, by 30, or by 26 working days.
- Enter bonus or overtime, advance and other deductions for each person. Net pay updates as you type.
- Mark people as paid when you pay them, then download the salary sheet. Staff sign against their name on the printout.
- Salary slip: make a PDF slip for each person, or send the details on WhatsApp.
How salary for the month is worked out
| Pay type | Earned salary |
|---|---|
| Monthly salary | Monthly salary × paid days ÷ days in the basis (never more than one month's salary) |
| Daily wage | Daily wage × days worked |
Net pay = earned + bonus/overtime − advance − other deductions
Paid days from the attendance sheet are: present + paid leave + weekly offs + half days ÷ 2. With the 26-working-day basis and for daily-wage workers, weekly offs are not counted.
Example
Suresh earns ₹15,000 a month. In September (30 days) he has 27 paid days, took a ₹2,000 advance and did overtime worth ₹600.
- Earned: ₹15,000 × 27 ÷ 30 = ₹13,500
- Net pay: ₹13,500 + ₹600 − ₹2,000 = ₹12,100
With the 26-day basis, one day's pay would be ₹15,000 ÷ 26 = ₹577 instead of ₹500, so every day of absence costs more.
Good practice and the rules
- Pay on time: under the labour codes, monthly wages generally must be paid by the 7th of the next month.
- Minimum wages: check that the pay for your type of work is at least the minimum wage notified by your state.
- Limit deductions: total deductions (including advance recovery) should not be more than 50% of the wages for the month.
- Keep records: a signed salary sheet and slips protect both you and your staff, and a slip helps a worker prove income for a loan or rent agreement.
This tool does not calculate PF, ESI, professional tax or TDS. If those apply to your business, deduct them under "Other deduction" as your accountant advises.
Frequently asked questions
Which basis should I choose: days in the month, 30 or 26?
Use what you agreed with your staff. "Days in the month" and "30 days" include weekly offs as paid days. "26 working days" leaves weekly offs out, which is common in shops and factories with one weekly off.
Can I change the days that came from attendance?
Yes. Type any number in the days box and it is used instead. Clear the box to go back to the attendance figure.
How do I record an advance given during the month?
Enter it in "Advance" for that month. It is deducted from the net pay and shown on the salary slip.
Where is the data saved?
Only on this device, shared with the attendance sheet. Nothing is uploaded. Download a backup every month.
Can I send the salary slip on WhatsApp?
Yes. Add the person's mobile number in the staff list. A WhatsApp button then appears to send the slip details, and "Salary slip" makes a PDF you can share.