TDS Calculation Sheet - Urgent - Pivot Table
CiteLegal
 
HOME RISE NEW ABOUT LOGIN
Home > Human Resource Section > Financial Management

TDS Calculation Sheet - Urgent - Pivot Table

selja Started The Discussion:

Dear All, Kindly send me the tds calculation sheet on monthly basis for salary . Thankx & regards, selja

A P Srivastava - Member Since: Jul 2007
Hi Selja

Solution 2.
Click here to download IT 2007-08....
or copy and paste it in address bar and enter you get this IT Calculator.

http://www.ynithya.com/taxcalc/TaxCalc_2008.xls
Designed by Banglore based SE.

Akhilesh
e-mail:

yogimsw - Member Since: Jul 2008
DEAR ALL
This is to inform all the professionals, please send the TDS salaries deduction Formula Format, as earliest. I have joined newly in our organization Call Juki India PVt, LTd japan based company here i am looking for tds calculation, in TDS about i dont know anything so that please help me as earliest. Iam waiting for your valuble reply.


Thanking You

Yogeesh

rameshmshetty - Member Since: Feb 2008
Dear Friends

I am sharing herewith TDs calcutaion workbook in excel created by me which can be used for calculation of TDs on salaries

following points to be noted while using this excel workbook
1. You need to enable macro as there are few functions written in VBA
2. Monthly data to be updated everymonth
3. range named "BM" stores no of balance months (to be updated every month once monthly data is updated
4. Piviot table to be refreshed after updating monthly data
5. Employees' name to be updated in the data sheet once. (EPF No is a key criteria which captures data from the pivot table. So EPF no must be entered in the monthly data sheet.
6. report sheet will provide you the IT calculation summury for the year 2008-09, Plese change the employee serial no for getting appropriate report
7. Modify the sheet accordingly if required (password to open/sheets is "admin"

Ramesh Shetty
Mangalore

Muralidhar.K - Member Since: Sep 2008
Hi

This is Muralidhar.k,Please tell me how to calculate TDS on salary if any one joined in the middle of the financial year and he drawn consolidated salary around 25000 per month.
and
what is the procedure of income tax when the person is a employee of any company


Muralidhar.k
UDUPI

pranesh007 - Member Since: Nov 2008
Dear Selja Find attached TDS file 2008-09 Pranesh


Attached FilesProvided by community member pranesh007. Join us to learn and grow with your peers.
File Type: xls TDS Rates - FY 2008-2009(Format).xls (182.5 KB, 1977 views)
pruthak - Member Since: Jul 2008
Dear, Ramesh Shetty The file is protected. plz send me pw on my mail i.d. pruthak_acharya@yahoo.co.in Regards, pruthak

Muralidhar.K - Member Since: Sep 2008
HI

Please give a answer for the following questions:

1.when any employee joined in any company/Institution in the middle of the financial year,how we calculate the TDS .

2.As a accountant / HR executive what is the procedure for filing income tax of employee.

3.what is the procedure when any NRI employee joined in the middle of the financial year.

4.as a accountant how to file income tax of emploee.

5.what are the documents i get from employee & what is the documents i prepared.

Thanking you & Regards


Muralidhar.K
UDUPI

sarithayadavg - Member Since: Mar 2009
how to calculate tds on salary,as per format we deduct professional tax,pf,esi,can you let me know

debabrataroy - Member Since: Jul 2009
Please let me know about TDS, I hv joined a new company. My sal is 20k pm, and they are duducting my TDS from the very first month. Is it mandatory, I know TDS is deducted at the end of the financial year that to for the entire year in a single month. Please let me know

Found This Useful? +Vote Up This Page Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.






Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


11363
VIEWS

9
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network