how to create salary and pf statement in excel sheet?
- 1 Answers
- 2183 Views
- I also Faced
- E-Mail Answers
Answer Posted / Anurodh Saxena
To create a salary and PF (Provident Fund) statement in Excel, you can follow these steps:
1. Create a table with headers like Employee Name, Salary, Deductions (PF), Net Pay, etc.
2. Fill in the employee data for each row.
3. Calculate the deductions based on the employee's salary and the PF rate set by the employer.
4. Add formulas to calculate the net pay (Salary - Deductions).
5. Save and format the table as required.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
As you know account executives need to be talented salespeople. Do you have experience making sales?
How to get C forms in online? Plz give me Processor Thanq
describe any accounting process that you have developed or revised
hi, this is shanthi kumar(M.Com). i would like to attend interview in genpact company.please send finance interview questions and interview details. thank u very much
please send me banking question on my email ID as I have been selected for state bank of india .my email ID is sawant.supriya51@gmail.com
Which accounting applications are your familiar with?
What qualities have you got that would make you a good accountant?
The following information is extracted from the audited books of accounts of a chain of food stores for the period ended 31st December 2015. Revenue Statement (Trading and Profit and Loss Account for the year ended 31st December 2015. BWP’000 BWP’000 Sales 460 Cost of good sold (220) Gross profit 240 Wages 50 Other expenses 30 (80) Net Profit 160 Note: The purchase figure included in the cost of goods sold of P255 000. Balance Sheet as at 31st December 2015 BWP’000 BWP’000 Fixed Assets 400 Current assets: Stock 80 Debtors (trade) 120 Bank 400 ----- [600] Current liabilities: Trade creditors 300 ------ [300] 300 Net Assets 700 ==== Financed by: Share capital 600 Revenue reserves 100 ------ 700 Shareholders Funds 700 ===== Required: (a) Calculate the following accounting ratios: (i) Current ratio (ii) Acid test ratio (iii) Stock turnover (in days) (iv) Debtors turnover (in days) (v) Creditors turnover (in days) (vi) Return on capital employed (ROCE) (vii) Gross profit percentage (viii) Net profit percentage (b). Give a brief comment on the performance of the company, based on the above ratios.
Tell me do you have any professional experience of this field?
VAT PER SURCHARG KAB SE KIS DATE SE LAG RAHA HAI
can any one send me tally professional version link
There is no item category assigned to account
Tell me which accounting application you prefer most and why?
What is your greatest achievement and why?
Do you have any professional experience in this field?
