WBXPress

NEW SALARY BILL (SSS400)

Home › Forums › Excel Utility › NEW SALARY BILL (SSS400)

  • This topic is empty.
Viewing 10 posts - 1 through 10 (of 12 total)
1 2
  • Author
    Posts
  • March 2, 2012 at 6:50 pm #67216
    Anonymous
    Inactive

    Hi friends, after my hard work for a long time , i have developed a salary programme in excel for all the govt. Employees of west bengal. Its name is sss(400), means simple salary solution and it can prepare salary bill for 400 employees. Many departments may use it and find it very simple to use. Before wide publication of this utility, i would like to have some review/observations of the members of this community. As such, i am to request all of you, please check it and let me know how do you feel about it and your suggestions too. Thanks in advance.
    …………………………………………………………………………………………………………………………..
    After having feedbacks from various ends and special one from d.Roy, the final version is published on 09-03-2012. Though the govt. Of west bengal making mandatory to use cosa, this tool may be a good lesson for the learner of spreadsheet. It has many features which may be observed while using it. As example, it will always open from the instruction sheet, no matter where you closed it.
    ………………………………………………………………………………………………………………………
    A minor upgradation has been made and a new sheet has been attached on the latest version which released on 17-03-2012. Users are requested to check it.

    March 5, 2012 at 9:42 am #71507
    Anonymous
    Inactive

    Re: NEW SALARY BILL (TEST VERSION)
    Please look into the following points, which I think need to be work upon w. r. t. Salary Bill:
    1. If GPF subscription is Rs. 10000 or more, it is not showing in the data input sheet . Please increase the column width.
    2. If HB Loan taken is more than 2 times, it can’t be entered. Actually, We have one employee having 4 different HB Loan.
    3. Schedule of Rent receipt is different for different housing scheme.Please see the COSA schedules.
    4. In case of WB Govt. employees, there are different prefixes for GPF No. like..DIRECTT/PWR/…, EEHDD-1/…, BPC/…,specially for Group-D.
    5. Disbursement certificate should have IFS Code , if salary A/C Bank of the employee is other than SBI.
    6. Statement of staff strength need to be included.
    7. Schedule of GPF deduction shall be according to group of employees as in case of Group D.

    March 5, 2012 at 2:16 pm #71509
    Anonymous
    Inactive

    Re: NEW SALARY BILL (TEST VERSION)
    Thanks a lot Mr.Roy for you valuable suggestions and observations. Wish I could contact you before initiation of the utility because some characters are not changeable now like numbers of House Building Loans and schedule of House Rent. The prefix of G.P.F. is changeable in General Data. I think the schedule of G.P.F. other than group D may be allowed in T.R. Form 47 and separation of group A,B,C is not mandatory. You may put the I.F.S code in within braket beside Bank account number in the Personal Data. It will show in Advice slip. I shall solve the other issues. Thanks again and please inform me whether the buttons are working well or not and any wrong calculation is showing or not.

    March 9, 2012 at 3:15 pm #71535
    Anonymous
    Inactive

    Unmatched, Excellent, Better than the Best. A-1 mind have been applied for preparation of this automated Salary bill. I proud of Mr Somnath Das on his greatest achievement.
    -Jaymangal Misir, Raiganj, Uttar Dinajpur.

    March 9, 2012 at 3:50 pm #71537
    Anonymous
    Inactive

    Thanks a lot for your encouragement Mr. Jaymangal. Its my pleasure to help the employees of my Mother Land.

    March 10, 2012 at 4:27 pm #71552
    Anonymous
    Inactive

    Som Da, Your salary bill utility is just excellent.

    March 10, 2012 at 5:23 pm #71556
    Anonymous
    Inactive

    Thanks bro. Your appreciations are the main source of my encouragement which make me more enthusiastic.

    March 29, 2012 at 3:58 pm #71790
    Anonymous
    Inactive

    Can you prepare this utility for Open Office please?

    March 29, 2012 at 4:33 pm #71791
    Anonymous
    Inactive

    Yes, its possible. Please provide me some time. It may not be for 400 employees as the same may be hanged by the system. I shall try it as much as possible.

    April 5, 2012 at 8:08 pm #71879
    Anonymous
    Inactive

    In my hospital there are three types of gpf account prefix i.E. Health/wb,medical/wb, and bmoh/tkr.Please make a solution.
    Thanks to you.
    Amit kr. Das.

  • Author
    Posts
Viewing 10 posts - 1 through 10 (of 12 total)
1 2
  • You must be logged in to reply to this topic.