Paycode Calculation is not correct when a paycode is Calculate at Runtime
Reasons
1. Check the order/sequence of paycode in paycode master and also paycode property template master. If Basic is dependent on Monthly CTC then Monthly CTC sequence should be less than Basic for eg. Monthly CTC should be 1 and Basic as 2.
2. Check "Calculate at Runtime" and Present Dependent property of all paycodes. If Basic is dependent on Monthly CTC then make Monthly CTC as Present Dependent but do NOT make Monthly CTC as "Calculate at Runtime". Create Basic as NOT Present Dependent but make Basic as "Calculate at Runtime". Similarly paycode property of HRA should be similar to Basic. Then we also need to create a paycode like Supplementary Allowance or Special Allowance (this paycode is used as left over amount) which is Monthly CTC -(All paycodes paid to employee including Employer PF Share), here Supplmentary Allowance or Speciall Allowance will NOT be Present Dependent and it will be "Calculate at Runtime". If in the above example you make Monthly CTC as Calculate at Runtime then the calculation can not be achieved.
Please contact us with your queries at support@bbspl.com
Webpay by BBSPL
Blog by BBSPL
Friday, April 30, 2010
Month does not appear in ESS to view salary
Month does not appear in ESS to view salary
Reason:
You have not authorised employee to view that months data. To give the rights please to from "Give Authority to View Salary Slips, TDS"
Leave Template and Leave Process
Steps that you need to do:
Step 1: Create a Template
Step 2: Create Leave through Leave Master and map it with Template
Step 3: Modify the template as shown in video.
Step 4: Modify mstemployeeotherdetails table: In this table you need to enter the template ID and the date
Query 1: select fk_temp_id,tempassign_date,* from mstempotherdetails
Query 2: update mstempotherdetails set fk_temp_id='TestTemp', tempassign_date='1 apr 2010' where fk_emp_code in
(
'1013',
'1025',
'1048'
)
Step 5: Trnempleaveassign
select * from trnempleaveassign
If the employee has balance then insert the balance of the employee (here only those leaves will appear which are credited every month)
Step 1: Create a Template
Step 2: Create Leave through Leave Master and map it with Template
Step 3: Modify the template as shown in video.
Step 4: Modify mstemployeeotherdetails table: In this table you need to enter the template ID and the date
Query 1: select fk_temp_id,tempassign_date,* from mstempotherdetails
Query 2: update mstempotherdetails set fk_temp_id='TestTemp', tempassign_date='1 apr 2010' where fk_emp_code in
(
'1013',
'1025',
'1048'
)
Step 5: Trnempleaveassign
select * from trnempleaveassign
If the employee has balance then insert the balance of the employee (here only those leaves will appear which are credited every month)
Thursday, April 29, 2010
Configure email settings in Webpay
How to configure email settings in webpay?
Reasons if mail does not go in Webpay:
1. Server address might be incorrect.
2. Password might be incorrect.
3. Check the AuthMail value. The email id should be correct.
4. Make sure the host is correct. Default SMTP Port is 25.
5. Make sure username and password is correct.
AuthenticationType:
“DB” If you are using Admin login VIA “FrmMainLogin.aspx” and ESS login VIA “FrmEmpLogin.aspx”
OR
“AD” If you are using Admin login VIA “FrmMainADLogin.aspx” and ESS login VIA “FrmAdLogin.aspx”
AuthMail will be same as given in network user name in Smtp section.
Blog by BBSPL
Webpay Copyright BBSPL
Reasons if mail does not go in Webpay:1. Server address might be incorrect.
2. Password might be incorrect.
3. Check the AuthMail value. The email id should be correct.
4. Make sure the host is correct. Default SMTP Port is 25.
5. Make sure username and password is correct.
AuthenticationType:
“DB” If you are using Admin login VIA “FrmMainLogin.aspx” and ESS login VIA “FrmEmpLogin.aspx”
OR
“AD” If you are using Admin login VIA “FrmMainADLogin.aspx” and ESS login VIA “FrmAdLogin.aspx”
AuthMail will be same as given in network user name in Smtp section.
Blog by BBSPL
Webpay Copyright BBSPL
Monday, April 26, 2010
Tax Deduction Settings for Arrear in Webpay
Tax Deduction Settings for Arrear in Webpay
You have three options to deduct tax on arrear amount.
1. Deduct TDS on Arrear in the Arrear pay month if the Arrear Amount is Positive.
2. Deduct TDS on Arrear in the Arrear pay month if the Arrear Amount is Positive or Negative.
3. Do not Deduct TDS on Arrear in the Arrear pay month.
Choose the Option from Company Specific Parameter from.
You have three options to deduct tax on arrear amount.
1. Deduct TDS on Arrear in the Arrear pay month if the Arrear Amount is Positive.
2. Deduct TDS on Arrear in the Arrear pay month if the Arrear Amount is Positive or Negative.
3. Do not Deduct TDS on Arrear in the Arrear pay month.
Choose the Option from Company Specific Parameter from.
Configuring Mail Settings in Webpay
Configuring Mail Settings in Webpay
There are two functions which are used in WEBPAY:
1. Direct Company Mail Authentication
2. Web.Config AuthMail Authentication
Direct Company Mail Authentication: In this function the following is considered:
From ID: Companies Email ID mentioned in Company Master Form.
To ID: Employee’s Email ID.
CC ID: Companies Email ID mentioned in Company Master Form.
Web.Config AuthMail Authentication: In this function the following is considered:
From ID: Email mentioned in web.config file -- AppSettings -- AuthMail
ReplyTo: Companies Email ID mentioned in Company Master Form.
To ID: Employee’s Email ID.
CC ID: Companies Email ID mentioned in Company Master Form.
Web.config Method Implemented on: Forgot Password, Chapter VI A Requisition (ESS)and Chapter VI A Approval forms (Admin).
There are two functions which are used in WEBPAY:
1. Direct Company Mail Authentication
2. Web.Config AuthMail Authentication
Direct Company Mail Authentication: In this function the following is considered:
From ID: Companies Email ID mentioned in Company Master Form.
To ID: Employee’s Email ID.
CC ID: Companies Email ID mentioned in Company Master Form.
Web.Config AuthMail Authentication: In this function the following is considered:
From ID: Email mentioned in web.config file -- AppSettings -- AuthMail
ReplyTo: Companies Email ID mentioned in Company Master Form.
To ID: Employee’s Email ID.
CC ID: Companies Email ID mentioned in Company Master Form.
Web.config Method Implemented on: Forgot Password, Chapter VI A Requisition (ESS)and Chapter VI A Approval forms (Admin).
Friday, April 23, 2010
HRA Exemption and CLA Calculation in Webpay
HRA Exemption and CLA Calculation
To check how HRA Exemption and CLA is calculated please go to the dashboard / home as shown below.
To check how HRA Exemption and CLA is calculated please go to the dashboard / home as shown below.
Children Education Allowance in Webpay
Children Education Allowance seems to be incorrect
Please check the image attached herewith.
Please check the image attached herewith.
CLA Calculation in Webpay
CLA Calculation in Webpay seems to be incorrect
The reason of CLA Calculation not being correct might be wrong mapping of paycodes. Please check the example as shown herein.
Thursday, April 22, 2010
Car Perquisite Method in Webpay
Car Perquisite in Webpay
You can use Import Car Perquisite method. I have attached a word document where it is explained how you enter the car perquisite. The attached sheet has three examples.
Watch the video on how to import
You can use Import Car Perquisite method. I have attached a word document where it is explained how you enter the car perquisite. The attached sheet has three examples.
Watch the video on how to import
When you enter the car perquisite as explained in the attached document, the taxable value of car perquisite is shown on Pay Slip and Tax Summary (TDS Estimation Slip)
Leave Request Email does not reach the desired user
Leave Request Email does not reach the desired user
Check the following settings
1. What is the request flow. Check from Leave configuration form. See the image with the title "Leave Priority and Configuration Setting".
2. Check the email id's of the employee's who are marked as sanction authority.
3. Check the email id of adminca user account.
4. Check web.config file for email server settings. If the server settings are not correct email would not go.
Tuesday, April 20, 2010
Paycode / Pay components / Pay heads Properties
Paycode Properties
Selecting paycode properties is one of the most important steps to configure Webpay. If the selection of properties is incorrect then the salary process would be incorrect. Please read the following very carefully.
1. Code: By default a code is generated (i.e.A00001 to additional pay heads or D00001 to deduction pay heads etc.)
2. Description: Paycodes description (i.e.Basic or Hra or conv etc.)
3. Display Caption: Display caption on salary slip or salary register or tds estimation slip and all related to salary paid details(i.e. you write "conv" of description of pay heads but you want display caption on salary slip or register “conveyance” then you write "conveyance" into display caption textbox)
4. Pay Code Mapping: When you map the paycode system understands its property for tax calculation like for eg. mapping a paycode with HRA tells the system that the business rule of HRA is applicable on this paycode.
5. Pay Code Type: Pay code type (i.e. “Addition” pay heads or “Deduction” pay heads or “Other” type or “Bonus” pay code select then simple assign that type pay heads to employee but if you made “Loan” or “Advance” type pay heads then you must be use “loan” and “advance” module and if you select “Reimbursement” pay code type then must be use Reimbursement module.)
6. Calculation Method: This gets active when you create a loan or advance type paycode. This is for interest calculation.
7. Assignment: Assignment in which two type first is “Manual assign pay code” and second is “Automatic assign pay code” (i.e. “Manual assign pay code” means assign pay heads manually to employee and “Automatic assign pay code ” means Automatically will be assign to employee.)
8. Ledger Group: This is used for internal processing. Just create one ledger type and always select as this is a mandatory field.
9. Taxable: This property tells whether pay code is taxable or non taxable or partial taxable
10. Non Taxable Limit (PA): Non taxable limit(PA) this is use for part of taxable pay heads in which give partial taxable limit amount(for example – “Reimbursement” type pay heads like “Medical Reimbursement” that type pay heads create partial taxable in which Non taxable limit=”15000” according to Gvt. Rule.)
11. Tax to be deducted: Pay month means deduct the tax on the whole amount in the month of payment and remember this option is used when the paycode is of variable nature and NOT fixed. Proportionately means that the tax will be proportioned as per the remaining months.
12. Pay Code Sequence to calculate paycode at runtime: Pay code sequence to calculate pay code at runtime that means for example first create pay heads with name “Basic” then “HRA” the first sequence will be “1” and if you want calculate “Hra” on basic then pay sequence will be “2”.)
13. Pay Slip / Register Sort Order: Pay slip / Register Sort Order means display pay heads on salary slip or salary register according to sort order.
14. Calculate Salary According To: Calculate Salary According To “Day Rate” or “Month Rate” that means if select “Day Rate” then salary will be calculate according to daily wages and if select “Month Rate” alary will be calculate according to daily wages and if select “Month Rate” then salary will be consider for month wise.
15. Formula / Amount: Formula / Amount that means if create formula then must select “formula” else put “0” amount into textbox.
16. Paycode Section: You select Section 10 or Section 16 which is used to publish on form 16
17. Rounding: For rounding the paycode amount
18. Present Dependent: Present Dependent that means if check box is check then calculate amount according to present day on that pay heads and if not check then calculate according to total amount assigned.
19. Part of PF Gross: Part of Pf gross that means if check box is check then amount consider for part of Pf gross and if not checked then not consider part of Pf gross on that pay heads.
20. Part of Gross: Part of Gross means if check box is checked then amount will be add into total salary if not checked then amount not will be add into total salary on that pay heads.
20A. Part of Rate Gross: Part of Rate Gross means the paycodes which are checked will added as Rate Gross to show the employee Entitled Salary. For eg. Overtime is not part of rate gross but it is part of gross. Therefore when a paycode like overtime is create it should not be part of rate gross.
21. Show on Pay Slip: Show on pay slip that means if check box is checked then pay code will be display on salary slip if not checked then not display on salary slip.
22. Show on Salary Sheet: Show on salary sheet that means if check box is checked then pay code will be display on salary sheet if not checked then not display on salary sheet.
23. Part of Tax: Part of tax that means if check box is checked then pay code amount consider for tax if not checked then not consider for income tax.
24. Variable Paycode: Variable Pay code that means if check box then pay code consider for “variable” else “Fixed” (i.e. “variable” that means pay code amount consider for assign month only not for next month or future month and “Fixed” that means pay code amount will be consider from assign month up to last month of the financial year.
25. Calculate at Runtime: Calculate at runtime that means if check box is checked then pay code amount calculate on salary process time. It is basically use to formula type pay code only.
26. Active: Active that means if check box is checked then pays code work and not checked then not works.
27. Used For Reimb. Claim: You select this option if you pay reimbursement claim amount in the salary through this paycode.
28. Part of CTC: Part of CTC that means if check box is checked then pay code amount consider(ADD) for “CTC” if not checked then pay code amount not consider(ADD) for “CTC”.
29. Part of ESI Rate Gross: Part of ESI Rate Gross that means if check box is checked then pay code amount consider for “Part of ESI Rate Gross” only not for deduction. It is only check your company ESI limit setting like 10000
30. Part of ESI Gross: Part of ESI Gross that means if check box is checked then pay code amount consider(ADD) for ESI Gross and if not checked then pay code amount not consider(ADD) for ESI Gross.
31. Part of Professional Tax: Part of professional tax that means if check box is checked then deducts professional tax amount on that pay code amount if not check then not deduct professional tax amount on that pay code.
32. Prorate According To DOJ and DOL: Prorate According to DOJ and DOL: You can use this option only for Reimbursement Type Paycodes which are NOT Present Dependent. As per this option entitled amount will be prorated according to DOJ and DOL.
Selecting paycode properties is one of the most important steps to configure Webpay. If the selection of properties is incorrect then the salary process would be incorrect. Please read the following very carefully.
1. Code: By default a code is generated (i.e.A00001 to additional pay heads or D00001 to deduction pay heads etc.)
2. Description: Paycodes description (i.e.Basic or Hra or conv etc.)
3. Display Caption: Display caption on salary slip or salary register or tds estimation slip and all related to salary paid details(i.e. you write "conv" of description of pay heads but you want display caption on salary slip or register “conveyance” then you write "conveyance" into display caption textbox)
4. Pay Code Mapping: When you map the paycode system understands its property for tax calculation like for eg. mapping a paycode with HRA tells the system that the business rule of HRA is applicable on this paycode.
5. Pay Code Type: Pay code type (i.e. “Addition” pay heads or “Deduction” pay heads or “Other” type or “Bonus” pay code select then simple assign that type pay heads to employee but if you made “Loan” or “Advance” type pay heads then you must be use “loan” and “advance” module and if you select “Reimbursement” pay code type then must be use Reimbursement module.)
6. Calculation Method: This gets active when you create a loan or advance type paycode. This is for interest calculation.
7. Assignment: Assignment in which two type first is “Manual assign pay code” and second is “Automatic assign pay code” (i.e. “Manual assign pay code” means assign pay heads manually to employee and “Automatic assign pay code ” means Automatically will be assign to employee.)
8. Ledger Group: This is used for internal processing. Just create one ledger type and always select as this is a mandatory field.
9. Taxable: This property tells whether pay code is taxable or non taxable or partial taxable
10. Non Taxable Limit (PA): Non taxable limit(PA) this is use for part of taxable pay heads in which give partial taxable limit amount(for example – “Reimbursement” type pay heads like “Medical Reimbursement” that type pay heads create partial taxable in which Non taxable limit=”15000” according to Gvt. Rule.)
11. Tax to be deducted: Pay month means deduct the tax on the whole amount in the month of payment and remember this option is used when the paycode is of variable nature and NOT fixed. Proportionately means that the tax will be proportioned as per the remaining months.
12. Pay Code Sequence to calculate paycode at runtime: Pay code sequence to calculate pay code at runtime that means for example first create pay heads with name “Basic” then “HRA” the first sequence will be “1” and if you want calculate “Hra” on basic then pay sequence will be “2”.)
13. Pay Slip / Register Sort Order: Pay slip / Register Sort Order means display pay heads on salary slip or salary register according to sort order.
14. Calculate Salary According To: Calculate Salary According To “Day Rate” or “Month Rate” that means if select “Day Rate” then salary will be calculate according to daily wages and if select “Month Rate” alary will be calculate according to daily wages and if select “Month Rate” then salary will be consider for month wise.
15. Formula / Amount: Formula / Amount that means if create formula then must select “formula” else put “0” amount into textbox.
16. Paycode Section: You select Section 10 or Section 16 which is used to publish on form 16
17. Rounding: For rounding the paycode amount
18. Present Dependent: Present Dependent that means if check box is check then calculate amount according to present day on that pay heads and if not check then calculate according to total amount assigned.
19. Part of PF Gross: Part of Pf gross that means if check box is check then amount consider for part of Pf gross and if not checked then not consider part of Pf gross on that pay heads.
20. Part of Gross: Part of Gross means if check box is checked then amount will be add into total salary if not checked then amount not will be add into total salary on that pay heads.
20A. Part of Rate Gross: Part of Rate Gross means the paycodes which are checked will added as Rate Gross to show the employee Entitled Salary. For eg. Overtime is not part of rate gross but it is part of gross. Therefore when a paycode like overtime is create it should not be part of rate gross.
21. Show on Pay Slip: Show on pay slip that means if check box is checked then pay code will be display on salary slip if not checked then not display on salary slip.
22. Show on Salary Sheet: Show on salary sheet that means if check box is checked then pay code will be display on salary sheet if not checked then not display on salary sheet.
23. Part of Tax: Part of tax that means if check box is checked then pay code amount consider for tax if not checked then not consider for income tax.
24. Variable Paycode: Variable Pay code that means if check box then pay code consider for “variable” else “Fixed” (i.e. “variable” that means pay code amount consider for assign month only not for next month or future month and “Fixed” that means pay code amount will be consider from assign month up to last month of the financial year.
25. Calculate at Runtime: Calculate at runtime that means if check box is checked then pay code amount calculate on salary process time. It is basically use to formula type pay code only.
26. Active: Active that means if check box is checked then pays code work and not checked then not works.
27. Used For Reimb. Claim: You select this option if you pay reimbursement claim amount in the salary through this paycode.
28. Part of CTC: Part of CTC that means if check box is checked then pay code amount consider(ADD) for “CTC” if not checked then pay code amount not consider(ADD) for “CTC”.
29. Part of ESI Rate Gross: Part of ESI Rate Gross that means if check box is checked then pay code amount consider for “Part of ESI Rate Gross” only not for deduction. It is only check your company ESI limit setting like 10000
30. Part of ESI Gross: Part of ESI Gross that means if check box is checked then pay code amount consider(ADD) for ESI Gross and if not checked then pay code amount not consider(ADD) for ESI Gross.
31. Part of Professional Tax: Part of professional tax that means if check box is checked then deducts professional tax amount on that pay code amount if not check then not deduct professional tax amount on that pay code.
32. Prorate According To DOJ and DOL: Prorate According to DOJ and DOL: You can use this option only for Reimbursement Type Paycodes which are NOT Present Dependent. As per this option entitled amount will be prorated according to DOJ and DOL.
Blog by BBSPL
Copyright BBSPL
Monthly Rent Paid Details on ESS
Monthly Rent Paid Details on ESS
If the user (employee) enters the rent value as 12000 and from and to dates are chosen as 1st April 2010 to 25th June 2010, this means that the rent is 12,000 per month from April to June. Here 12000 is for the whole month of June and not upto 25th June.
If the user (employee) enters the rent value as 12000 and from and to dates are chosen as 1st April 2010 to 25th June 2010, this means that the rent is 12,000 per month from April to June. Here 12000 is for the whole month of June and not upto 25th June.
Blog by BBSPL
Webpay Copyright BBSPL
PDF file does not open
PDF file does not open
1. Try by changing one line in web.config file i.e. debug = true instead of debug=false.
1. Try by changing one line in web.config file i.e. debug = true instead of debug=false.
Monday, April 19, 2010
Paycode does not show on payslip and pay register
Paycode does not show on payslip and pay register
Make sure that the two options on Paycode Master "Show on Pay Slip" and "Show on Pay Register" are checked.
Also make sure that the same options on Paycode Property Template are checked. You need to Edit the template and choose the options as you wish to.
Another very important thing: If the option was earlier unchecked and you processed the salary for the month of April and after locking April you have checked these properties ON and processed for May; then the paycodes will be shown for May and for April it will not show. This is because when the salary is locked the data of previous month does not get changed on change of an option as all the options also get stored as per that month's data.
Webpay Help
CLA Calculation in Webpay
How to check CLA and HRA calculation by Webpay?
On the dashboard you will find a section HRA/CLA Calculation. Enter the employee codes, use comma as seperator between two employee codes.
Choose from drop down either HRA or CLA and click on View Details button. You will find the calculations in a report.
On the dashboard you will find a section HRA/CLA Calculation. Enter the employee codes, use comma as seperator between two employee codes.
Choose from drop down either HRA or CLA and click on View Details button. You will find the calculations in a report.
Saturday, April 17, 2010
Professional Tax is not deducting
Professional Tax is not deducting in Webpay
Reasons:
1. The location might not be mapped with the state correctly.
2. Professional Tax Apply option might be not checked in State Master.
3. PT Slab might be stored twice or PT Slab might not be stored in database for current financial year.
4. Option in Employee Master for PT Deduction might be disabled.
5. Paycodes may not be mapped with PT.
6. Please check the Start Financial Year and End Financial Year of the Professional Tax Slab.
7. PT Apply is not checked in PF/ESI/PT configuration.
If the above does not solve the problem, please contact me back.
Reasons:
1. The location might not be mapped with the state correctly.
2. Professional Tax Apply option might be not checked in State Master.
3. PT Slab might be stored twice or PT Slab might not be stored in database for current financial year.
4. Option in Employee Master for PT Deduction might be disabled.
5. Paycodes may not be mapped with PT.
6. Please check the Start Financial Year and End Financial Year of the Professional Tax Slab.
7. PT Apply is not checked in PF/ESI/PT configuration.
If the above does not solve the problem, please contact me back.
Subscribe to:
Posts (Atom)