Salary Calculation - Salary Caluculation [Thread 529582]

Hi Rikhi Jha,

1. What will be my salary during February if I joined on 5th Feb and if I joined on 27 Feb (Monthly salary 9000/-)?

2. What will be my salary during March if I joined on 5th March and if I joined on 31st March (Monthly salary 9000/-)?

What is the mean number of days for salary calculation in the private sector?

Please reply fast.

Regards, Rikhi Jha

Dear Rikhi Jha,

1a) If the join date is February 5, the attendance will be 24 days, i.e., 5th to 28th or except 4 (1 to 4) days. Salary for 24 days = 9000 x 24/28 = 7714.29.

1b) If the join date is February 27, the attendance will be 2 days, i.e., 27th & 28th. Salary for 2 days = 9000 x 2/28 = 642.86.

2a) If the join date is March 5, the attendance will be 27 days, i.e., 5th to 31st or except 4 (1 to 4) days. Salary for 27 days = 9000 x 27/31 = 7838.71.

2b) If the join date is March 31, the attendance will be 1 day, i.e., 31st March only. Salary for 1 day = 9000/31 = 290.32.

Abbas.P.S

Your monthly salary will be divided by 28 in February and then delivered to you for one day. Similarly, in March, you will receive less salary as there are 31 days. The deduction will be the same in February, with more salary being deducted in comparison to March.

Usually, companies calculate per day salary based on 30 days for all months in the year. Therefore, it will be calculated as: (total salary/30) * number of days worked in that month.

Make it clear. In seven months, namely January, March, May, July, August, October, and December, there are 31 days. If an employee has an attendance of 30 days and one day of LWOP, will he get the full salary.

Abbas.P.S

If you joined on 5th February, then your salary will be 9000*24/28 = 7714.00.

If you joined on 27th February, then your salary will be 9000*2/28 = 643.00.

If you joined on 5th March, then your salary will be 9000*28/31 = 8129.00.

If you joined on 31st March, then your salary will be 9000*1/31 = 290.00.

If there is no LWOP then
Your Salary if You Joined on 5th February (9000 x 24)/28 = Rs. 7714.28 (we assume Feb has a 28-day month).
Your Salary if You Joined on 27th February (9000 x 2)/28 = Rs. 642.85 (we assume Feb has a 28-day month).
Your Salary if You Joined on 5th March (9000 x 27)/31 = Rs. 7838.70.
Your Salary if You Joined on 31st March (9000 x 1)/31 = Rs. 290.30.

If there are some LWOP then
If there is no LWOP then
Your Salary if You Joined on 5th February (9000 x 24 - LWOP)/28 (we assume Feb has a 28-day month).
Your Salary if You Joined on 27th February (9000 x 2 - LWOP)/28 (we assume Feb has a 28-day month).
Your Salary if You Joined on 5th March (9000 x 27 - LWOP)/31.

I am an Accountant in a Pvt Logistics firm. My job responsibilities in this firm include billing, updating accounting entries in Tally ERP, managing petty cash, following up on payments, bank reconciliation, and other administrative tasks. My boss has asked me to prepare an MIS report, which should include daily billing, channel details, petty cash details, etc., consolidated on one sheet. Could you please help me by providing a format for the MIS sheet for accounting?