**PAYROLL ACCOUNTING — QUICK REFERENCE**
**Key Formulas:**
• NOEDP = NODM − LWP − Unauthorised Absence
• BPE = BP × NOEDP / NODM
• DA = BPE × DA Rate (%)
• HRA = BPE × HRA Rate (%) [rates differ for Sup/Nsup]
• TRA = Fixed Amount or Percentage
• TE = BPE + DA + HRA + TRA
• PF = BPE × PF Rate (%)
• TD = PF + TDS + LOAN + Other Deductions
• Net Salary (NS) = TE − TD
**Payroll Components — Earnings:**
— Basic Pay (BP): Fixed contractual pay
— Dearness Allowance (DA): % of (BP + DP)
— House Rent Allowance (HRA): % of BPE [different rates for supervisory/non-supervisory]
— Transport Allowance (TRA): Fixed or %
— Any Other Earning: As declared
**Payroll Components — Deductions:**
— Provident Fund (PF): Statutory, % of (BP + DP)
— Tax Deduction at Source (TDS): Monthly apportionment of yearly income tax
— Professional Tax (PT): State-based statutory deduction
— Loan Recovery: Fixed amount per employee
— Any Other Deduction: Advances, festival deductions
**Template Design Steps:**
1. Define fixed parameters in top cells (NODM, DA%, HRA%, PF%)
2. Create data rows for each employee
3. Use formulae in columns: BPE, DA, HRA, TE, PF, TDS, TD, NS
4. Apply same template to all employees — auto-calculates
**Key Points:**
— NOEDP adjusts salary for absences/leave
— DA and PF calculated on BPE (not total earnings)
— HRA rates differ by designation; TRA can be fixed or %
— Spreadsheet automates monthly payroll for entire workforce
Q1. Which of the following is NOT a statutory deduction in payroll accounting?
Answer: C — HRA is an earning/allowance, not a deduction; PF, TDS, and PT are all statutory deductions.
Q2. If an employee has 26 days in a month, takes 2 days LWP and 1 day unauthorised absence, what is NOEDP?
Answer: A — NOEDP = NODM − LWP − Unauthorised Absence = 26 − 2 − 1 = 23 days.
Q3. Basic Pay is ₹30,000, NOEDP is 20 days, and NODM is 25 days. What is Basic Pay Earned (BPE)?
Answer: B — BPE = BP × NOEDP / NODM = 30,000 × 20 / 25 = ₹24,000.
Q4. Dearness Allowance (DA) is calculated as a percentage of which component?
Answer: B — DA is a compensation for price rise and is computed as a percentage of (Basic Pay + Dearness Pay, if applicable).
Q5. In a spreadsheet payroll template, which cells typically contain fixed parameters that apply to all employees?
Answer: C — Fixed parameters (NODM, DA%, HRA%, PF%) are entered once in top cells and used in formulae for all employees.
Q6. If BPE is ₹24,000 and DA rate is 8%, what is the Dearness Allowance amount?
Answer: C — DA = BPE × DA Rate (%) = 24,000 × 8% = ₹1,920.
Q7. Which statement about HRA is correct?
Answer: C — HRA is an earning allowance calculated on BPE with rates differing by employee designation (supervisory vs non-supervisory).
Q8. Total Earnings = ₹35,000 and Total Deductions = ₹8,000. What is Net Salary?
Answer: B — Net Salary (NS) = Total Earnings − Total Deductions = 35,000 − 8,000 = ₹27,000.
Q9. Both: (1) Provident Fund is calculated as a percentage of Basic Pay plus Dearness Pay. (2) Professional Tax is a deduction applicable in all states of India. Which statement(s) is/are correct?
Answer: A — Statement (1) is correct: PF = (BP + DP) × Rate. Statement (2) is incorrect: PT is applicable only in some states, not all.
Q10. HOTS — A spreadsheet template is designed with HRA rates of 12% for supervisory and 10% for non-supervisory staff. If an employee's BPE is ₹25,000 and designation is entered as 'Sup', what Excel formula would correctly calculate HRA?
Answer: B — The formula uses IF logic to check designation and apply the correct HRA rate from parameter cells G5 (supervisory) and G6 (non-supervisory).
What does NOEDP stand for and how is it calculated?
Number of Effective Days Present = (Number of Days in a Month) − (Leave without Pay) − (Unauthorised Absence).
Define Dearness Allowance (DA) and state its basis.
DA is compensation for erosion in purchasing power due to price rise, calculated as a percentage of (Basic Pay + Dearness Pay if applicable).
How is Basic Pay Earned (BPE) different from Basic Pay (BP)?
BPE = BP × NOEDP/NODM, adjusting for actual days present, whereas BP is the fixed contractual pay.
What is the formula for House Rent Allowance (HRA)?
HRA = BPE × (Applicable Rate of HRA for the Month), with different rates typically for supervisory and non-supervisory staff.
Name three statutory deductions in payroll accounting.
Provident Fund (PF), Tax Deduction at Source (TDS), and Professional Tax (PT) are statutory deductions.
What is the purpose of a spreadsheet template in payroll?
A template specifies cell layout, formulae locations, and parameter cells so that values auto-calculate when data is entered.
How is Provident Fund (PF) calculated in payroll?
PF = BPE × PF Rate (%), where the rate is set by government under the Provident Fund Act.
What is the final payroll formula for Net Salary?
Net Salary (NS) = Total Earnings (TE) − Total Deductions (TD).
Why are HRA rates different for supervisory and non-supervisory employees?
HRA rates are differentiated based on employee designation and applicable pay band as per organisational policy.
What information is included in a bank advice generated from payroll?
Bank advice contains net salary to be transferred to individual employee accounts plus statutory payment details (PF, tax, etc.).
Define Basic Pay Earned (BPE) and write its formula. Why is it necessary to adjust Basic Pay for NOEDP? [2 marks]
BPE = BP × NOEDP/NODM adjusts salary for actual days present; without this, employees absent or on LWP would be paid for full month.
An employee has the following monthly payroll data: Basic Pay ₹30,000, DA Rate 8%, HRA Rate 12%, TRA ₹1,500, PF Rate 10%, TDS ₹3,000, Loan Recovery ₹500, NOEDP 20 days, NODM 25 days. Calculate Total Earnings, Total Deductions, and Net Salary. Show all working steps. [5 marks]
First calculate BPE = 30,000 × 20/25; then DA, HRA on BPE; sum TE = BPE + DA + HRA + TRA; sum TD = PF + TDS + Loan; finally NS = TE − TD.
Explain the purpose of a spreadsheet template in payroll accounting for an organisation with 14 employees. Describe the layout, identify which cells contain fixed parameters and which contain formulae, and explain how this design ensures consistency and efficiency in monthly salary computation. [6 marks]
A template standardises payroll structure; fixed parameters (NODM, rates) go in top cells; employee data rows use formulae that reference these parameters; ensures all employees calculated uniformly, saves time, and reduces manual errors.
You've seen the free preview. Open the full interactive study kit — mind map, instant-graded quiz, progress tracking — free, no sign-in required.
Open Full Study Kit — Free →