Question

Krunal Mehta's image
Krunal Mehta
Oct. 10, 2016, 12:46 p.m.
Employee Name Basic Salary DA            (20% of Basic) Special Pay 1/2*(basic+da) Incentive      Double of (Basic + Special) Gross Salary PF              (12% OF Basic+DA) Net Salary (Gross Salary-PF)
P 50000            
Q 40000            
R 10000            
S 90000            
T 8000            
Total 198000            

how to solve this sum/example in basic excel with formula?

Answer
Praveen Jha's image
Praveen Jha
Oct. 10, 2016, 11:20 a.m.
when I should service tax deposit 12000. but I deposite service tax 15000. than refund.
Answer
Praveen Jha's image
Praveen Jha
Oct. 10, 2016, 11:18 a.m.
when service tax over amount deposite than refund prosidure.
Answer
Praveen Jha's image
Praveen Jha
Oct. 9, 2016, 7:41 p.m.
when rent rs 80000 service tax rs 12000 and less tds 8000 = 84000. how much amount service tax deposite.
Answer
Praveen Jha's image
Praveen Jha
Oct. 9, 2016, 6:34 p.m.
when rent rs 80000. service tax 12000. And tds 10000. total rent with service tax = 92000-tds 10000=84000 rent received. than service tax how much amount deposite. pls give me answer.
Answer
Chaitali Jiwankar's image
Chaitali Jiwankar
Oct. 9, 2016, 1:08 a.m.
In company final account after sales we show goods destroyed by fire and goods distributed freely for advertisement by company,in trading account on credit side , why it is so??
Answer
Praveen Jha's image
Praveen Jha
Oct. 8, 2016, 3:54 p.m.
when rent 112514 than tds and s.tax include and calculation
Answer
Accounts Tax GST
shouryasharma11's image
shouryasharma11
Oct. 8, 2016, 1:55 p.m.

sir, what the deffination of TDS, SERVICE TAX , ND EXCISE DUTY

Answer
Vijesh Malviya's image
Vijesh Malviya
Oct. 8, 2016, 1:15 p.m.

Pension Received comes under which head

Answer
Arun Kumar's image
Arun Kumar
Oct. 8, 2016, 11:47 a.m.

√7-√5 is irrational

Answer
reshma gavhane's image
reshma gavhane
Oct. 8, 2016, 11:08 a.m.

HOW TO PREPARE  EMPLOYEE INCENTIVE LEDGER UNDER WHICH HEADING

Answer
Maths
SURAJ JHA's image
SURAJ JHA
Oct. 7, 2016, 11:59 p.m.
Why do we multiply by 7 only? 

Answer
Manjula V's image
Manjula V
Oct. 7, 2016, 5:26 p.m.
How to prepare the company reports on excel formats
Example: Cash flow, MIS, Expenses report, 

Answer
Praveen Jha's image
Praveen Jha
Oct. 7, 2016, 4:37 p.m.
when monthly rent rs 192514 than service tax paid
Answer
Praveen Jha's image
Praveen Jha
Oct. 7, 2016, 3:49 p.m.
when rent rs 192514 than service charges of june
Answer
Shaik Saleem's image
Shaik Saleem
Oct. 7, 2016, 3:43 p.m.

what is the meaning of direct and indirect taxes

Answer
Praveen Jha's image
Praveen Jha
Oct. 7, 2016, 3:41 p.m.
ram annually salary rs 650000 when tds deducted and calculation of tds
Answer
Accounts Tax GST
Mohammed Farhatulla's image
Mohammed Farhatulla
Oct. 7, 2016, 3:31 p.m.

 I work as Part time Accountant at a Hospital.There are various entries to be passed in Tally.ERP9 like O/P Income,Lab Income,Pharmacy purchases & Sales,Cash & Bank Vouchers,Bank Reconciliations.etc.,

But My Query is about passing entries of OP Income as the Hospital prepared already an excel statement in which O/P Income received ...60% of Income should go to Dr."A"; 60% to Dr."B"; 60% to Dr."C".;remaining 40% Income goes to Hospital.These entries have to be passed since  April-2016. I have passed just 2 to 3 entries upto 05.04.16 and i have to finish them upto 30-09-2016.

So,Please help me with a quick solution for passing entries in lesser time with ease.

 

Answer