how to make monthly salary sheets.
Answers were Sorted based on User's Feedback
Answer / nishanth
Format can be made as follows.
Employee Code No. 1
Name Sudhir Gupta
Basic 50000
HRA 28000
Transport Allowance 800
-------
Gross Salary 78800
(-)Professional Tax 300(In Feb month)
(-)TDS 15000
(-)Advances Paid -
------
Net Salary 63500
If No of employees are more than one same can be prepared
in a vertical format.
| Is This Answer Correct ? | 16 Yes | 2 No |
Answer / pardeep kumar vashist
EMPLOYEE CODE : 102458
EMPLOYEE NAME : Mr.Pardeep Kumar
DEPARTMENT NAME : FINANCE
DESIGNATION : GENERAL MANAGER - FINANCE
DATE OF JOINING : 6/11/2011
W.E.F : 4/1/2013
FINANCIAL YEAR : 2013-14
Present CTC
SALARY DETAILS : QTY AMT
SALARY HEAD
BASIC SALARY 8000
HRA 3500
CONVEYANCE/VEH MAINT ALLOW 1000
SPECIAL ALLOWANCE 1500
OTHER ALLOWANCE 1000
TOTAL 15000
PF 0
LTA 0
MEDICAL 0
BONUS 0
EXGRATIA (VARIABLE) 0
GRATUITY 0
FUEL 250 ltrs 0
MOBILE/DATA CARD 0
TOTAL 0
TOTAL CTC (Monthly) 15000
CTC (Yearly) 180000
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sikander
there is no standard format of salary sheet you can design
as per your data. you can also make it as:
Name of emp--basic sal--(less)emp PF(%of basic salary)--
balance of basic salary---add other allownces by name of
each allownce in one column.---total salary
| Is This Answer Correct ? | 5 Yes | 8 No |
Dear Experts, I need your help in deriving a formula for calculating three taxes with a combination of cumulative and inclusive tax. Here are the examples with expected result. Please let me know the formula on how to get the given result. Example1: Total Product Value (V) = 1000 (with inclusive of all 3 taxes and below mentioned cumulative combinations) Tax1 rate is 10% and Tax1 is inclusive. Tax2 rate is 10% with Tax2 is inclusive and cumulative of Tax1 Tax3 rate is 10% with Tax3 is inclusive and there is no cumulative of Tax1, Tax2 Expected Results are: Tax1=76.34 Tax2=83.97 Tax3=76.34 Let me know formula to derive above values? Example2: Total Product Value (V) = 1000 (with inclusive of all 3 taxes and below mentioned cumulative combinations) Tax1 rate is 10% and Tax1 is inclusive. Tax2 rate is 10% with Tax2 is inclusive and cumulative of Tax1 Tax3 rate is 10% with Tax3 is inclusive and cumulative of Tax2 Expected Results are: Tax1=75.70 Tax2=83.27 Tax3=84.03 Please let me know formula to derive above values? Thanks in advance.
Is there any criteria for percentage define of TDS rates? and What is the major advantage of introducing DTC and GST by Central Govt?
how i can grab more information about income tax?
When excise duties differs from 8.24% to 14.24%? Why excise gate pass is required during dispatch of vehicle?
if company have receivables Rs 50000 & payables Rs. 65000 then what will be current ratio ?
what is the tretment if we paid service tax wrongly in different service tax head ex. commissioning , repairs & maintenance.our liability for commissioning but we paid some into repairs & maintance . what can i do in this situation
Can we deduct WCT TDS on Interstate WORKS CONTRACT , Example, Contractor is in Banglore, he has completed work in Mahrashtra which involved Civil work, Furnitures, fixtures & labour etc, Contractor has raised invoice on service receiver adding 13.50% full CST +4.12% Service charges on Total invoice amount, kindly clarify whether Service receiver is eligible to deduct WCT TDS in Maharashtra on invoice value of the contractor, if yes at what rate ?
what is fbt can anybody send me rate of fbt
please tell me friends what are the formats of excise return and vat return?
Provision for Service tax, Income tax and Sales tax
how to treat payment or receit of gift in income tax returns
What is the difference between Direct &indirect tax?