Example Payroll Tally Prime in Tamil

Excise Sum : 1

The following Employee’s salary structure entered in payroll model and prepares the pay sheet (An employee’s) pay slip (individual employee) payroll statement and payment advice report of the above company book for the year 2024(April to march)

PARTICULAR	DR	CR
Share capital		25,00,000
Debenture		5,00,000
HDFC Bank Ltd	18,00,000
Work-in-Progress	2,00,000
Condign liabilities		2,00,000
Raw materials	2,50,000
Reliance shares	5,00,000
Bank Loan		4,00,000
Sports Equipments	1,00,000
Preliminary expenses	2,50,000
Royalties payable		1,00,000
Fixed deposit	4,00,000
Reserve fund		3,00,000
Live in stock	2,00,000
Building advance	3,00,000

Purchase Department

Employee Details
Name	S.Nishanth	P.Rathika
Designation	Manager	Accountant
Date of Join	1.8.1995	1.2.1999
Employee ID	258	658
Bank name	HDFC Bank Ltd	HDFC Bank Ltd
Account number	2048	3054

Employee Salary Details
S.Nishanth		P.Rathika
Basic pay	Rs.35000	Basic pay	Rs.30000
DA	40% for Basic pay	DA	30% for Basic pay
TA	6% for Basic pay	Medical allowance	Rs.1000 per Month
Medical allowance	Rs.1000 per Month	Hotel boarding &lodging allownce	Rs.1500 per Month
Advance	Rs.1500 per Month	Advance	Rs.1000 per Month
Food allowance	Rs.1300 per Month	General provident fund	5% for Basic pay + DA
House Rent Allowance	15% for Basic pay	Convince Allowance	Rs.800 per Month
Provident Fund	10% for Basic pay + DA	House Rent Allowance	10% for Basic pay + DA
Income tax	15% for DA	Income tax	10% for DA
House loan	Rs.700 per Month	Food Allowance	Rs.1000 per Month

Production Department

Employee Details
Name	Charles.K	Rajaram.M
Designation	Production Manager	Research & development officer
Date of Join	1.4.1996	1.6.2000
Employee ID	184	1087
Bank name	HDFC Bank Ltd	HDFC Bank Ltd
Account number	6874	7874

Employee Salary Details
Charles.K		Rajaram.M
Basic pay	Rs.40000	Basic pay	Rs.20000
DA	45% for Basic pay	DA	20% for Basic pay
TA	10% for Basic pay	TA	5% for Basic pay
Car loan	Rs.1000 for basic pay	Medical allowance	Rs.600 per Month
Tsunami contribution	2% For Basic pay	Advance	Rs.800 per Month
House Rent Allowance	18% for Basic pay	Food allowance	Rs.700 per Month
Income tax	20% for DA	House Rent Allowance	8.5% for Basic pay
Medical allowance	Rs.2000 per Month	Provident Fund	7% for Basic pay + DA
Provident Fund	15% for Basic pay + DA	Income tax	10% for DA
Public provident fund	10% for Basic pay	City compensatory allowance	15% for Basic pay
		Public provident fund	6.5 for Basic pay

Sales Department

Employee Details
Name	Vimal.N	Deeban.R
Designation	Sales officer	Marketing Manager
Date of Join	1.3.2001	1.9.2003
Employee ID	989	352
Bank name	HDFC Bank Ltd	HDFC Bank Ltd
Account number	5408	5442

Employee Salary Details
Vimal.N		Deeban.R
Basic pay	Rs.25000	Basic pay	Rs.35000
DA	30% for Basic pay	DA	35% for Basic pay
TA	6% for Basic pay	TA	10% for Basic pay
Medical allowance	Rs.1100 per Month	Medical allowance	Rs.1300 per Month
Advance	1300 per Month	Advance	Rs.1700 per Month
Food allowancee	Rs.1500 per Month	Food allowance	Rs.1500 per Month
Hotel boarding & lodging allowance	Rs.900 per Month	House Rent Allowance	18% for Basic pay
House Rent Allowance	10% for Basic pay	General Provident Fund	12% for Basic pay + DA
Provident Fund	8.5% for Basic pay + DA	Income tax	20% for DA
Income tax	20% for DA	Public provident fund	10% for Basic pay
Public provident fund	6% for Basic pay	Tsunami contribution	5 for Basic pay

TRANSACTION DURING THE PERIOD:

Mar 31 Salary payable by cheque and credited the amount individual employee Account of HDFC Bank Ltd

View Answer

Excise Sum : 2

The following ABD Company Pvt Ltd. Employee’s Salary structure entered in payroll model and prepares the pay sheet (an employee’s) pay slip (individual employee) payroll statement and payment advice report of the above company book for the year.

PARTICULAR	DR	PARTICULAR	CR
SBI Bank	200000	Capital	300000
Cash	100000	Sundry income	80000
Rew materials	50000	loan advance	100000
Bill recivable	80000	Provision Bad debit	75000
Factory Rent	20000	Reserve fund	33000
Royalty on production	50000	Sales	350000
free hold property	80000	Bad debit recovered	62000
Discount allowed	20000	Rent received	30000
investing on shares	100000	Purchase	180000
Stock in hand	150000

Purchase Department

Employee Details
Name	V. SARANYA	V. SARATHA
Designation	MANAGER	PRODUCTION MANAGER
Date of Join	1.5.2010	1.8.2000
Employee ID	MC101	MC102
Bank name	SBI Bank	SBI Bank
Account number	5214	8976

Employee Salary Details
V. SARANYA		V. SARATHA
Basic pay	Rs.35000	Basic pay	Rs. 40000
DA	20% for Basic Pay	DA	20% for Basic Pay
Medical allowance	5% for Basic Pay	Medical allowance	5% for Basic Pay
Food allowance	1500 per Month	Food allowance	1200 per Month
Income tax	10% for DA	Income tax	12% for DA
Food allowance	Rs.1300 per Month	Provident fund	5% for Basic pay + DA
Provident Fund	9% for Basic Pay + DA	Hotel boarding	Rs.800 per Month
Hotel boarding	800 per Month	Advance	2000 par Month
Over time	40 per Month	Car loan	10000 per Month
		Over time	50 per Month

Sales Department

Employee Details
Name	V. VANITHA	A.KAVIYA
Designation	SALES MANAGER	MARKETING MANAGER
Date of Join	1.8.2000	1.8.1999
Employee ID	MS102	MS103
Bank name	SBI bank	SBI bank
Account number	8976	6945

Employee Salary Details
V. VANITHA		A.KAVIYA
Basic pay	Rs. 45000	Basic pay	Rs.42000
DA	30% for Basic Pay	DA	25% for Basic pay
Medical allowance	15% for Basic Pay	Medical allowance	12% for Basic Pay
Food allowance	1800 per Month	Food allowance	1500 per Month
Income tax	20% for DA	Income tax	15% for DA
Provident Fund	15% for Basic Pay + DA	Provident Fund	18% for Basic Pay + DA
Rent allowance	800 per Month	Rent allowance	1000 per Month
Advance	2000 par Month	House loan	10000 per Month
Car loan	10000 per Month	Tsunami contribution	7% for Basic Pay
Tsunami contribution	6% for Basic Pay	Over time	50per Month
Over time	80 per Month	Gratuity	Basic Pay +DA
Gratuity	Basic Pay +DA

TRANSACTION DURING THE PERIOD:

Mar 31 Salary payable by cheque and credited the amount individual employee Account of HDFC Bank Ltd

View Answer

Excise Sum : 3

The following Employee’s salary structure entered in payroll model and prepares the pay sheet (An employee’s) pay slip (individual employee) payroll statement and payment advice report of the above company book for the year 2021 (April to March)

Particular	Dr	Cr
Share Capital		2000000
Debenture		500000
Indian Bank	2500000
Royalty on production	50000
Accrued interest	60000
Cash in hand	200000
Trade expenses	50000
Bank O/D		50000
Fuel & power	20000
Bank Loan		350000
Reserved Fund		100000
Preliminary expenses	50000
Reliance shares	70000

Purchase Department

Employee Details
Name	HARINI.A	SIVA.C
Designation	Manager	Employee
Date of Join	1.6.2020	1.10.2000
Employee ID	103	289
Bank name	Indian Bank	Indian Bank
Account number	7358	4156

Employee Salary Details
HARINI.A		SIVA.C
Basic pay	Rs.80000	Basic pay	Rs.50000
DA	20% for Basic pay	DA	20% for Basic Pay
TA	15% of Basic pay	TA	5% for Basic Pay
Medical Allowance	Rs.2500 per month	Medical Allowance	1200 per Month
Food allowance	Rs.3000 per month	Food allowance	12% for DA
Provident Fund	12% of Basic pay + DA	Provident fund	5% for Basic pay + DA
Public provident Fund	15% of Basic pay	Public provident Fund	Rs.800 per Month
Income tax	10% of DA	Income tax	2000 par Month
House loan	Rs.8000 per month	Advance	10000 per Month
Gratuity	Basic pay + DA	Over time	Rs.40 per Month
		Gratuity	Basic pay + DA

Quality Department

Employee Details
Name	YAMUNA.S	PRABAKARAN . G
Designation	Receiving quality engineer	Junior engineer
Date of Join	1.9.2000	1.9.2005
Employee ID	371	496
Bank name	Indian Bank	Indian Bank
Account number	7351	4596

Employee Salary Details
YAMUNA.S		PRABAKARAN.G
Basic pay	Rs.52000	Basic pay	Rs.42000
DA	15% for Basic pay	DA	10% of Basic pay
TA	12% of Basic pay	TA	10% of Basic pay
Medical Allowance	Rs.2500 per month	Medical Allowance	Rs.2500 per month
Food allowance	Rs.3000 per month	Food allowance	Rs.3000 per month
Provident Fund	12% of Basic pay + DA	Provident Fund	10% of Basic pay + DA
Bus allowance	Rs.1500 per month	Bus allowance	Rs.1500 per month
Advance	Rs.5000 per month	General provident fund	6% of Basic pay
Car loan	Rs.2300 per month	house loan	Rs.3500 per month
Over time	Rs.40 (10hrs)	Over time	25per Month
Gratuity	Basic pay + DA	Gratuity	Basic Pay +DA

Production Department

Employee Details
Name	PRIYA.B
Designation	Production Engineer
Date of Join	1.3.2011
Employee ID	731
Bank name	Indian Bank
Account number	5834

Employee Salary Details
YAMUNA.S
Basic pay	Rs.20000
DA	10% for Basic pay
TA	3% of Basic pay
Medical Allowance	Rs.1000 per month
Food allowance	Rs.1500 per month
Provident Fund	10% of Basic pay + DA
Tsunami Contribution	5% of Basic pay
Income tax	10% of Basic pay +DA
Over time	Rs.40 (10hrs)
Gratuity	Basic pay + DA

TRANSACTION DURING THE PERIOD:

Mar 31 Salary payable by cheque and credited the amount individual employee Account of HDFC Bank Ltd