banner_ad

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

Others 6741 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  

Company
26 May 2026
Audit executive

vdsr & co LLP

Chennai

CA Inter

View Details
Company
12 May 2026
Accounts Executive

Nafa Group

Mumbai

B.Com

View Details
Company
04 May 2026
Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details
Company
29 May 2026
Accounts assistant

Shubh Consultancy

Mumbai

Graduate (Any)

View Details
Company
26 May 2026
Senior Accountant cum purchase Manager

Vardhaman Group of India

Pimpri Chinchwad

CA Inter

View Details
Company
ARTICLESHIP 05 May 2026
ARTICLED ASSISTANT

JS ADVISORS

New Delhi

CA Inter

View Details
Company
14 May 2026
Senior Accounts Executive

Karan Gupta & Co.

New Delhi

Graduate (Any)

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details