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

6779 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 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
23 July 2026
Senior Accountant

Felicity Adobe LLP

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 16 July 2026
Article Assistant

G A R U D & Associates

New Delhi

CA Inter

View Details
Company
06 July 2026
Chartered Accountant (Indirect Taxation)

Gowra Ventures Pvt Ltd

Hyderabad

CA

View Details
Company
11 July 2026
CA semi qualified

Vakilsearch.com

Chennai

CA Inter

View Details
Company
06 July 2026
Senior Accountant

Arvindkumar Maniar & Co.

Rajkot

CA

View Details
Company
29 June 2026
ACCOUNTANT

SANDEEP AASHISH & CO

Araria

B.Com

View Details
Company
Featured 16 July 2026
CA Inter, CA Intermediate, CA IPCC, CA CPT, CA SemiQualified

Vakilsearch.com

Chennai

CA Inter

View Details
Company
ARTICLESHIP 30 June 2026
Taxation Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details