how to create salary and pf statement in excel sheet?
- 1 Answers
- 2182 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
can any one send me tally professional version link
what is amalgamation?
What is Mixed Invoice
when we use credit card, then what will do entries in tally erp as a accountant and second question that if he do entry then what will thay keep under the ledger of credit card.
1 Answers State Bank of Mysore SBM,
how to make contra entry in sap fico.?
explain me what steps would you take to increase revenue for this company?
amount paid to rajiv as tour advice-2000
In Accounting Terms 1. what is meant by debit Rs.1000/- to Mr.Ramu account ?. 2. What is meant by credit Rs.1000/- to Mr.Ramu account ?. 3. What is meant by Ramu account was Debited or Credited ?. 4. Generally in accounting terms what is meant by Debit or Credit His / Her account ?.
what is contigent liability
How to split the company in tally?
What is diffrence Between GPF and EPF?.. can anybody explain..?
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.
Audit 
