Tally & Accounting Systems

Chapter 10
Payroll Accounting

Certificate in Accountancy
Tally & Accounting Systems   •   Certificate

Payroll Accounting

Introduction and Context

Payroll accounting is the systematic recording, calculation, payment, and reporting of employee remuneration. It connects human-resource information with accounting records by converting employment terms, attendance data, pay rates, deductions, and statutory contributions into reliable payroll transactions.

In Tally-based accounting systems, payroll is managed through linked masters and vouchers. Employee masters identify workers; payroll units and attendance types measure time or output; pay heads define earnings and deductions; employee groups support classification; and payroll vouchers record salary calculations. The resulting reports assist management, employees, auditors, and regulatory authorities.

Payroll is both an accounting process and a control process. An error in an employee’s master data can affect gross salary, deductions, net pay, expense recognition, statutory liabilities, and financial reporting. Consequently, payroll requires accurate configuration, documented approval, confidentiality, and regular reconciliation.

Learning Objectives

After studying this chapter, the learner should be able to:

  1. Explain the purpose and structure of payroll accounting.
  2. Create employee and employee-group masters in Tally.
  3. Define attendance types, units, pay heads, and salary details.
  4. Calculate gross pay, deductions, net pay, and employer contributions.
  5. Process salary using payroll vouchers.
  6. Record payroll liabilities and payments correctly.
  7. Generate and interpret payroll reports.
  8. Apply basic controls, ethical principles, and compliance procedures.

1. The Payroll Accounting Model

A payroll system transforms employment data into accounting information through the following sequence:

Employee terms → attendance or production data → earnings → deductions → net pay and employer contributions → accounting entries → reports and statutory returns

The principal components are:

  • Employee master: Name, code, department, designation, date of joining, bank information, and other approved personal or employment details.
  • Employee group: A classification such as Production Staff, Administrative Staff, or Sales Staff.
  • Attendance or production type: A measure such as Present, Absent, Overtime Hours, Paid Leave, or Units Produced.
  • Pay head: A payroll component such as Basic Salary, House Rent Allowance, Overtime, Provident Fund, Tax, or Loan Recovery.
  • Salary details: The employee’s applicable pay structure, calculation basis, rate, and effective date.
  • Payroll voucher: The transaction used to calculate and record salary for a specified period.
  • Payroll report: A structured presentation of payroll data, liabilities, attendance, pay slips, or statutory information.

Fundamental payroll relationships

Gross earnings are the total earnings before employee deductions:

Gross Earnings = Σ Earnings Components

The symbol Σ means “sum of.” The formula applies when all earnings components are identified for the same employee and payroll period.

Net pay is the amount payable to the employee after employee deductions:

Net Pay = Gross Earnings − Employee Deductions

Employer contributions are normally additional employment costs rather than deductions from the employee’s net pay. Total employer payroll cost is therefore:

Total Employer Payroll Cost = Gross Earnings + Employer Contributions

These relationships assume that employer contributions are not included in gross earnings and that employee deductions are separately identified. Local legislation may define particular items differently for tax or social-security purposes.

Example 1: Basic payroll calculation

An employee has the following monthly earnings:

ComponentAmount
Basic salary20,000
House rent allowance8,000
Overtime2,000
Gross earnings30,000

Employee deductions are social-security contribution 1,800, income-tax withholding 2,200, and loan recovery 1,000.

Net Pay = 30,000 − (1,800 + 2,200 + 1,000) = 25,000

If the employer also contributes 1,800 to social security, the employer’s payroll cost is:

Total Employer Payroll Cost = 30,000 + 1,800 = 31,800

The employer contribution does not reduce the employee’s net pay in this example.

2. Employee and Payroll Masters in Tally

Masters are relatively permanent records used repeatedly in transactions. A well-designed master structure reduces repeated data entry and improves consistency.

2.1 Employee groups

Employee groups should reflect useful reporting and control requirements. Possible groups include:

  • Administration
  • Finance
  • Sales
  • Production
  • Supervisory staff
  • Contract employees

Groups should not be created merely for every minor difference in salary. Excessive grouping makes maintenance difficult. A group is useful when it supports payroll calculation, approval, cost allocation, or reporting.

2.2 Employee master

An employee master generally includes:

  • Employee name and unique identification code
  • Employee group
  • Date of joining
  • Designation and department
  • Location or cost centre
  • Bank and payment information
  • Contact information
  • Statutory identification details, where legally required
  • Employment status and effective dates

Employee codes should be unique, stable, and unrelated to sensitive personal information. A terminated employee should normally be marked inactive rather than deleted, because historical payroll records must remain auditable.

2.3 Security and privacy

Payroll masters contain personal and financial information. Access should therefore follow the principle of least privilege. For example, a payroll operator may enter attendance but not change bank details; a finance manager may approve salary; and an auditor may view reports without altering transactions.

Sensitive fields should be protected through user permissions, passwords, audit trails, controlled exports, and secure backups. Payroll data should not be shared through unsecured personal messaging accounts or unnecessary spreadsheets.

3. Attendance, Units, and Pay Components

3.1 Attendance types and units

Attendance types represent the basis on which time or output is measured. Common examples are:

Attendance typeUnitTypical use
PresentDaysMonthly attendance
AbsentDaysUnpaid absence
Paid leaveDaysApproved paid leave
OvertimeHoursAdditional working time
Units producedUnitsPiece-rate workers

An attendance unit must correspond to the calculation rule. Hours should not be recorded as days, and production quantities should not be treated as attendance unless the pay policy expressly permits it.

3.2 Pay heads

Pay heads classify payroll components. They may be configured as earnings, deductions, employer contributions, or informational items.

Earnings may include basic salary, dearness allowance, house rent allowance, transport allowance, commission, bonus, and overtime.

Employee deductions may include social-security contributions, income-tax withholding, insurance, salary advances, loans, and authorised recoveries.

Employer contributions may include the employer’s share of social security, pension, insurance, or other employment-related funds.

A pay head should have a clear name, category, calculation basis, accounting ledger, applicability rule, and effective date. Its configuration should state whether it affects gross pay, net pay, statutory reporting, or cost-centre allocation.

3.3 Calculation bases

Pay components may be calculated using:

  • A fixed amount per period
  • A percentage of a specified salary component
  • Attendance or workdays
  • Overtime hours
  • Units produced
  • A slab or rule-based statutory schedule
  • A manually entered amount subject to approval

For a monthly salaried employee, a common pro-rata rule is:

Pay for Period = Monthly Rate × Eligible Days ÷ Calendar Days

This formula is applicable only when the organisation’s policy uses calendar days. Some organisations use working days, fixed 26-day bases, or another legally permitted basis. The selected denominator must be documented and applied consistently.

For overtime:

Overtime Pay = Overtime Hours × Overtime Rate per Hour

If the overtime rate is derived from monthly salary:

Overtime Rate per Hour = Monthly Overtime Base ÷ Standard Hours in the Period × Overtime Multiplier

The formula requires a defined overtime base, standard hours, and multiplier. These variables differ across policies and jurisdictions; a system user must not assume that one universal rate applies.

Example 2: Pro-rata salary and overtime

An employee’s monthly salary is 26,000. The organisation uses a 26-day payroll basis. The employee is eligible for 23 days and worked 6 overtime hours at 150 per hour.

Salary for Period = 26,000 × 23 ÷ 26 = 23,000
Overtime Pay = 6 × 150 = 900

Total earnings before other components are 23,900. The calculation is valid because the organisation has explicitly adopted a 26-day basis and the overtime rate is already established.

4. Salary Structures and Effective Dates

A salary structure defines which pay heads apply to an employee and how they are calculated. It should have an effective date so that changes are applied from the correct payroll period. For example, a promotion approved on 15 June may become effective on 1 July according to company policy.

A salary revision should not overwrite historical information without an audit trail. The system should preserve the old rate, record the authorising document, and apply the new rate only from the approved effective date.

Important design questions include:

  • Is the component fixed or variable?
  • Is it based on attendance, output, or another pay head?
  • Is it included in statutory bases?
  • Is it subject to employee deduction or employer contribution?
  • Which expense ledger receives the amount?
  • Does it require cost-centre allocation?

5. Processing Payroll in Tally

Menu names can differ by Tally product and release, so the organisation should consult its installed version and configuration. The logical workflow remains substantially similar.

Step 1: Enable payroll features

Create or open the company, enable payroll functionality, define financial-year and payroll-period settings, and establish required accounting and cost-centre features.

Step 2: Create payroll masters

Create employee groups, employees, attendance types, units, pay heads, and salary details. Link pay heads to the appropriate ledgers and define the calculation methods.

Step 3: Enter attendance or production

Record attendance for the payroll period. Supporting evidence may include approved timesheets, leave records, biometric summaries, overtime authorisations, or production reports. Attendance should be reviewed before salary calculation.

Step 4: Record payroll vouchers

Use the appropriate payroll voucher to calculate salary for the selected period. Review employee-wise and component-wise values before accepting the voucher. Where required, allocate expenses to departments, projects, branches, or cost centres.

Step 5: Review and approve

A reviewer should compare payroll totals with the previous period, investigate unusual changes, confirm new joiners and leavers, and verify deductions and employer contributions. Approval should be documented.

Step 6: Record payment

Salary may be paid through bank transfer, cheque, or another approved method. The payment entry should agree with the approved net-pay schedule and bank statement.

Step 7: Record remittances

Employee deductions and employer contributions create liabilities. When amounts are paid to tax authorities, social-security institutions, insurers, or lenders, the corresponding liability is reduced. Remittance dates and supporting documents should be retained.

6. Accounting Entries

A simplified payroll accrual entry is:

AccountDebitCredit
Salaries and wages expenseGross earnings—
Employer contribution expenseEmployer contributions—
Employee deductions payable—Employee deductions
Employer contributions payable—Employer contributions
Salaries payable—Net pay
TotalGross + employer contributionsDeductions + employer contributions + net pay

The entry is balanced because:

Gross Earnings + Employer Contributions = Employee Deductions + Employer Contributions + Net Pay

Substituting Net Pay = Gross Earnings − Employee Deductions verifies the equality.

When salary is paid:

AccountDebitCredit
Salaries payableNet pay—
Bank or cash—Net pay

When deductions are remitted:

AccountDebitCredit
Relevant payable accountAmount remitted—
Bank or cash—Amount remitted

Actual statutory account names and treatment depend on applicable law and the organisation’s chart of accounts.

7. Payroll Reports and Reconciliation

Useful Tally payroll reports include:

  • Employee pay slips
  • Payroll statement
  • Pay-head summary
  • Attendance register
  • Employee-wise salary details
  • Department or cost-centre reports
  • Salary payable statement
  • Deduction and contribution reports
  • Payroll register
  • Exception or alteration reports

A pay slip should show the pay period, employee identity, earnings, deductions, employer contributions where appropriate, and net pay. It should not expose other employees’ information.

Reconciliation procedure

A monthly reconciliation should compare:

  1. Payroll register with the payroll voucher.
  2. Net-pay schedule with the bank payment file.
  3. Employee deductions with statutory or other payable ledgers.
  4. Employer contributions with the related expense and liability accounts.
  5. Payroll expense with the general ledger and cost-centre reports.
  6. Closing liabilities with amounts subsequently remitted.

Differences may arise from timing, rejected bank payments, rounding, reversals, late approvals, or incorrect master data. Each difference should be investigated and documented rather than adjusted without explanation.

8. Illustrative Case: Sunrise Garments

This is a fictional illustrative case.

Background

Sunrise Garments employs 18 workers. It previously calculated wages in a spreadsheet. The business experienced duplicated employee names, inconsistent overtime rates, and delays in statutory remittances.

Problem

Management could not reliably explain the difference between gross payroll expense, net salary paid, and outstanding deduction liabilities. Departmental labour costs were also unavailable.

Analysis

The weaknesses were traced to four causes:

  • No unique employee codes
  • Attendance and overtime approvals were not linked to payroll
  • Pay heads were not consistently defined
  • Salary payment and liability remittance were treated as one undifferentiated entry

Approach and solution

The accountant created employee groups for Production and Administration, assigned unique employee codes, and entered approved joining dates and departments. Attendance types were created for present days, paid leave, unpaid absence, and overtime hours. Pay heads were configured for basic wages, overtime, employee social-security deduction, employer social-security contribution, and salary advances.

A separate liability ledger was used for employee deductions and employer contributions. Payroll was processed through an approved voucher, reviewed against attendance records, and allocated to production and administration cost centres. Net salary was paid through the bank, while deductions and employer contributions were remitted through separate transactions.

Outcome

The organisation obtained employee-wise pay slips, a department-wise labour-cost report, and a reconciliation between payroll liabilities and remittance records. Overtime exceptions were identified before payment, and historical payroll remained available for audit.

Learning points

The case demonstrates that payroll software does not replace payroll policy or review. Reliable results depend on master-data discipline, approved source documents, proper ledger design, segregation of duties, and reconciliation.

9. Controls, Ethics, and Compliance

Payroll controls should address the full employee life cycle.

Authorisation: New employees, salary changes, overtime, bonuses, leave adjustments, and termination payments require documented approval.

Segregation of duties: Where possible, different people should maintain employee masters, approve payroll, release payments, and reconcile bank and liability accounts.

Validation: The system should flag duplicate bank accounts, unusually high overtime, negative net pay, inactive employees receiving salary, and large month-to-month changes.

Confidentiality: Payroll data should be accessed only for legitimate business purposes. Privacy laws may regulate collection, storage, retention, and disclosure of personal data.

Compliance: Tax withholding, minimum wages, working-time rules, social-security contributions, leave, payslips, and record retention vary by jurisdiction. Tally can calculate and report configured rules, but the organisation remains responsible for obtaining current legal guidance and updating rates and thresholds.

Ethics: Payroll professionals must not create ghost employees, suppress overtime, manipulate deductions, delay remittances, alter records without authorisation, or disclose salary information improperly.

10. Technology and Contemporary Practice

Modern payroll systems increasingly integrate attendance devices, employee self-service, banking platforms, accounting ledgers, and statutory filing systems. Automation can reduce repetitive entry, but it can also replicate an incorrect rule at scale.

AI-assisted tools may help identify anomalies, classify payroll queries, or compare current and prior-period data. Such tools should support—not replace—professional judgement. Sensitive payroll data should not be uploaded to an unauthorised public AI service. Automated recommendations require human review, explainable rules, access controls, and an audit trail.

Best practices include:

  • Maintain a controlled payroll calendar.
  • Use unique employee identifiers.
  • Record effective dates for all changes.
  • Test pay-head configurations before production use.
  • Keep payroll and statutory rules current.
  • Lock approved periods against unauthorised alteration.
  • Retain source documents and approval evidence.
  • Reconcile payroll, bank, general ledger, and statutory liabilities.
  • Review exception reports before payment.
  • Back up data securely and test restoration.

Challenges and Limitations

Payroll systems face several practical limitations. Complex local legislation may require configurations that differ by employee category. Attendance data may be incomplete or inaccurate. Retroactive salary revisions may require special adjustments. Rounding rules can create small differences between employee-level and summary totals. Integrations may fail because of incompatible formats or duplicate records.

A system report is not automatically correct merely because it is generated by software. Users must understand the underlying masters, assumptions, effective dates, and accounting treatment. Manual overrides should be rare, authorised, and documented.

Chapter Summary

Payroll accounting converts employment terms and attendance information into earnings, deductions, net pay, employer contributions, accounting entries, and reports. In Tally, reliable payroll depends on correctly configured employee groups, employee masters, attendance types, units, pay heads, salary details, ledgers, and payroll vouchers.

Gross earnings are the sum of earnings components; net pay equals gross earnings less employee deductions; and employer payroll cost includes gross earnings plus employer contributions. Payroll liabilities must be distinguished from salary expense and settled through controlled remittance transactions.

A professional payroll process includes approved source data, effective-dated salary structures, segregation of duties, confidentiality, reconciliation, statutory compliance, and exception review. Technology can improve speed and visibility, but human oversight remains essential.

Key Terms

Employee master: A record containing an employee’s identification, employment, payment, and statutory information.

Employee group: A classification used to organise employees for calculation, control, or reporting.

Attendance type: A measure such as present days, leave, absence, overtime hours, or output.

Payroll unit: The unit in which attendance or production is measured.

Pay head: A defined payroll component, such as salary, allowance, deduction, or contribution.

Earnings: Amounts payable to an employee before employee deductions.

Gross earnings: The total of all applicable employee earnings.

Employee deduction: An amount withheld from an employee’s gross earnings.

Employer contribution: An employment cost paid by the employer in addition to gross earnings.

Net pay: The amount payable to an employee after employee deductions.

Salary structure: The approved set of pay heads and calculation rules assigned to an employee.

Effective date: The date from which a master or payroll rule becomes applicable.

Payroll voucher: A transaction used to record payroll for a specified period.

Payroll liability: An amount owed to employees, authorities, insurers, lenders, or other parties.

Cost centre: A department, project, branch, or other unit to which an expense is assigned.

Pay slip: An employee-level statement of earnings, deductions, and net pay.

Payroll reconciliation: Comparison of payroll records with ledgers, bank payments, and liabilities.

Ghost employee: A fictitious or unauthorised employee included in payroll.

Segregation of duties: Division of responsibilities to reduce error and fraud risk.

Review Questions

Short Answer Questions

  1. What is the purpose of an employee master in a payroll system?
  2. Distinguish between an employee deduction and an employer contribution.
  3. What is a pay head? Give two examples.
  4. Why are effective dates important in salary structures?
  5. State two reports that can be generated from a payroll system.

Long Answer Questions

  1. Explain the complete payroll workflow from employee master creation to salary payment and statutory remittance.
  2. Describe the main attendance types, payroll units, and pay-head categories used in Tally payroll.
  3. Explain the accounting treatment of gross salary, employee deductions, employer contributions, and net pay.
  4. Discuss the controls required to protect payroll accuracy, confidentiality, and compliance.
  5. Explain how payroll reconciliation is performed and why it is important.

Analytical / Application Questions

  1. An employee earns basic salary of 24,000, allowance of 6,000, and overtime of 1,500. Employee deductions are 2,400 and 1,100. Calculate gross earnings and net pay. Identify one additional reconciliation check before payment.
  2. A company’s payroll expense is correct, but its deduction liability ledger does not agree with amounts remitted. Analyse three possible causes and recommend corrective procedures.
  3. Design a simple Tally payroll structure for a small business with Production and Administration employees. Specify suitable employee groups, attendance types, pay heads, reports, and control checks.

Multiple Choice Questions with Answers

Question 1

Which item is normally an employee deduction?

A. Basic salary

B. Employer social-security contribution

C. Income-tax withholding from the employee

D. House rent allowance

Correct Answer: C. Income-tax withholding from the employee

Question 2

What is the correct general relationship for net pay?

A. Net Pay = Gross Earnings + Employee Deductions

B. Net Pay = Gross Earnings − Employee Deductions

C. Net Pay = Employer Contributions − Gross Earnings

D. Net Pay = Gross Earnings × Employer Contributions

Correct Answer: B. Net Pay = Gross Earnings − Employee Deductions

Question 3

Which master identifies an employee’s department, joining date, and payment information?

A. Employee master

B. Attendance voucher

C. Bank reconciliation statement

D. Payable ledger only

Correct Answer: A. Employee master

Question 4

An employee has gross earnings of 30,000 and employee deductions of 5,000. What is net pay?

A. 25,000

B. 30,000

C. 35,000

D. 5,000

Correct Answer: A. 25,000

Question 5

Which attendance type is measured most appropriately in hours?

A. Present

B. Paid leave

C. Overtime

D. Employee group

Correct Answer: C. Overtime

Question 6

Why should salary revisions have effective dates?

A. To delete historical payroll

B. To apply revised rates from the authorised period

C. To avoid creating employee codes

D. To convert deductions into earnings

Correct Answer: B. To apply revised rates from the authorised period

Question 7

Which entry normally records payment of approved net salaries?

A. Debit Bank; credit Salaries Payable

B. Debit Salaries Payable; credit Bank

C. Debit Gross Salary Expense; credit Employer Contribution

D. Debit Employee Deductions Payable; credit Salaries Expense

Correct Answer: B. Debit Salaries Payable; credit Bank

Question 8

Which report is most directly used to communicate an individual employee’s earnings and deductions?

A. Pay slip

B. Trial balance only

C. Inventory register

D. Purchase order

Correct Answer: A. Pay slip

Question 9

If gross earnings are 40,000 and employer contributions are 4,000, what is total employer payroll cost under the chapter’s model?

A. 36,000

B. 40,000

C. 44,000

D. 4,000

Correct Answer: C. 44,000

Question 10

Which control best reduces the risk of unauthorised salary changes?

A. Allowing all users to edit masters

B. Removing approval records

C. Using effective-dated changes with documented authorisation

D. Deleting inactive employees

Correct Answer: C. Using effective-dated changes with documented authorisation

Tally & Accounting Systems
Chapter 10 of 15