Friday, December 30, 2011

Steps involved to capture time automatically in WebPay


Steps involved to capture time automatically in WebPay

1. Enter the Employee in biometric database either manually or create a schedular to capture the employees from WebPay database.

Whenever an employee is inserted in Webpay a column(Updation_flag) in Employee Master table  is ‘N’.

Updation_flag Char(1) Default 'N'

To create the schedular to capture the employees from WebPay database you can use this flag and make that ‘Y’ after capturing. 

2. Send the punch time data in TrnPunchTime table whenever a punch is made in biometric machine. For this use the following table structure:

Table Name TrnPunchTime

Column_Name       Type        Length      Description
Pk_Id             BigInt      -           Identity Column (Auto Generated)
fk_emp_code       VarChar     10          Employee Code
DeptccCode        VarChar     10          StaffID / CardID
TrnDate           DateTime    -           Punch DateTime


Note: You only need to send TrnDate as datetime and fk_emp_code in case card id and employee code is same or DeptccCode in case card id is different from employee code. No need to send both fk_emp_code and DeptccCode.

3.  Whenever you insert the punch time record in TrnPunchTime table remember to insert all the previous punch time records in WebPay database which are not inserted in WebPay database due to network failure or any other disinterruption between the two databases.


Blog by BBSPL


Difference between Pension wage and EDLI wage

Difference between Pension wage and EDLI wage

The employee whose PF is deposited but pension is not deposited are included in EDLI wages.  Reason can be attainment of pension limit age of 58.

For e.g

Employee E0001 has a Basic wage of 10000 but no Pension is desposited, 100% amount is deposited as EPF. Let's take 10000 as Basic Wage for E0001. Employee's PF is deposited on the basis of actual basic and not the 6500 limit.


Employee E0002 has a Basic wage of 6500 and Pension is also desposited. In this case 6500 is PF / Basic Wage and 6500 is pension wage for E0002.

And to calculate EDLI, we consider 6500 for both the employees.

Therefore in above example:
Basic Wage is 16500 (10000 + 6500)
EDLI Wage is 13000 (6500 + 6500)
But Pension wage is 6500 (6500)

Remember  EDLI wage is also limited to 6500 like Pension.


Blog by BBSPL















Friday, December 23, 2011

Changes in Report Builder

Changes in Report Builder

Please download the Presentation file from here.

Some important changes have been done to the report builder, which are explained in the slides along with the snapshot.

You will also find some slight change in looks of Report Builder.

Some Important Changes:
a). Sorting
b). 3 level Grouping
c). Edit Reports

Blog by BBSPL

Friday, November 25, 2011

Wednesday, November 16, 2011

PAN of Landlord mandatory for exemption of HRA - If rent exceeds Rs.180000 PA

Greetings of the day!

This is to bring to your notice a very important amendment made in Law by way of Annual Circular on Salaries. In the cases where annual rent paid by the employee is more than 180,000 (i.e. 15,000 per month) HRA exemption will be available only if PAN of the Landlord is provided. The relevant extracts are reproduced below

Further if annual rent paid by the employee exceeds Rs 1,80,000 per annum, it is mandatory for the employee to report PAN of the landlord to the employer. In case the landlord does not have a PAN, a declaration to this effect from the landlord along with the name and address of the landlord should be filed by the employee.

For detailed Circular please refer the attached file. For specific reference you may refer 5.2 Incomes not included under the Head "Salaries"(Exemptions) Point 9 Page 24

Thus to summarise:-

Obtain landlords PAN if rent exceeds Rs. 15,000/- per month

1.Employees who are paying rent of more than Rs. 15,000/- per month (more than Rs. 180,000/- per year) and claiming HRA benefit and are compulsorily required to furnish the Permanent account number (PAN) of the landlord to its employer in order to claim the HRA benefit.

2.In case the landlord does not hold a PAN, then in such a situation, a declaration is to be obtained from the Landlord confirming that he does not hold a PAN. Such declaration must be signed by the landlord with complete name and address and identifying himself by mentioning his valid ID number (like DL, Adhar, pass port, etc.). Copy of declaration format attached.

3.In case any of the above documents are not provided by the employee to his employer, HRA benefit cannot be provided.
 Actions required

1.The employees should be informed about this requirement and advised to obtain the PAN of the landlord immediately. If the PAN of the landlord is not furnished by the employees before the furnishing of the dates of actual proofs (before January 2012 payroll run ), then in such a situation the HRA benefit shall be withdrawn and the additional tax liab ility for year 2011-23 may be recovered over Jan-Mar 2012 period.

Watch-outs

1.There are no alternatives or options provided in the circular if PAN / declaration is not available. Thus if the PAN / declaration signed by the landlord is not available, then in such a situation HRA benefit cannot be given to the employee from the ongoing year i.e. 2011-12 onwards

Download the circular from www.bbspl.com/download/webpay/CirNo5Section192.pdf

Download the Employee Declaration Form from www.bbspl.com/download/webpay/DECLARATIONREGARDINGPERMANENTACCOUNTNUMBER.doc

Regards

Vikas Sapra
BBSPL

P.S.: Credits for the above information: Mr. Kamal Tejwani, practising C.A. in Delhi.
Webpay, An HRMS and Payroll Solution
http://www.bbspl.com
http://webpayhelp.blogspot.com

Monday, November 14, 2011

Generating TDS Calculation of All Employees (including Finalized) in Webpay

Generating TDS Calculation of All Employees (including Finalized) in Webpay

Please download the presentation from the below mentioned link and see how TDS calculation is done by Webpay. Excel is generated from Webpay.

TDS Calculation by Webpay PPT

Blog by BBSPL

Wednesday, November 9, 2011

Employee Master Pension Option Issue Resolved

In employee master the pension option remained unchecked if Customized PF option was enabled but PF option was disabled. Because of this pension was not deducted in audit module.

This has been solved.

Webpay