Salary tds working with tax computation for f.y. 2011-12

Others 6373 views 7 replies

Friends,

Click here to download  one excel file (in zip format)  to compute TDS from Salary of Employees with tax computation for F.Y. 2011-12 works in Excel-2007( service pack 2)  only.

See three sheets as under:

1. Declaration form by Employee.

2. Salary Statement sheet from Payslip.

3. Tax Computation.

Fill declaration form received from Employee, Fill 2nd sheet for salary working from payslip & other details in yallow highlited cells.You can enter remaining month to know tds per month to deduct from salary.

It also caculate interest u/s 234 A B C

When you open file select enable macro to work this file.

If anyone have problem opening this file in excel-2007, report here with screenshoot.

Exshail

 

Replies (7)

Image of first sheet i.e. employee decleration form:

Image of 2nd Sheet : Salary Working from Payslip.

Image of 3rd Sheet : Computation of Tax:

Nice work done.

Originally posted by : Manish Negi

Nice work done.


Thanks.

Salay TDS Working for F.Y. 2011-12.

Now this is the last month to revised tds if any from the salary of Employee for F.Y. 2011-12.

So download attached revised file with minor bugs fixed.

How it works?

It will be very useful to save your time in processing Salary tds working.

1. Email this file to all employee to fill their details in declaration form & get it back to you.

     or

Take blank print out of this form & give to employees to fill the declaration form & you yourself fill this sheet from the information provided by employee. (You have to save the file with the name of employee in your seperate folder for further updates from employee.)

2. Now click on View Statement button as shown in above image to fill details regarding Salary payment from payslip or salary records. See Income tax liability & tds to deduct from remaining month from top rows of statement sheet.

3. Now click on View Computation button as shown in Image to View\Print Computation of Tax as per details provided by employee.

You can print any sheet by pressing Ctrl-P.

After finalisation print Delcleration Sheet duly filled to take signature of employee for phyisical record. & you can further give printout of computation to employee for thier records.

dear sir  

    i have not practicaly know.tds return And challan some know of tds compution how i can received tds return and tds challan konwaladge 


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register