Payroll Reports in TallyPrime: Generate, Analyze & Manage Employee Data

Payroll reports in TallyPrime display salary, attendance, deductions, and statutory compliance data. Access them via Gateway of Tally > Payroll or Alt+G, filter by date and employee, and export to Excel or PDF for analysis and reconciliation.

What Are Payroll Reports in TallyPrime?

Payroll reports in TallyPrime are automated summaries and detailed statements that track employee compensation, attendance, deductions, and statutory contributions. They form the backbone of HR and finance operations, enabling accurate salary processing, compliance reporting, and financial reconciliation. Whether you manage five employees or five hundred, these reports ensure transparency, accuracy, and regulatory adherence.

TallyPrime's payroll module generates reports that feed directly into your general ledger, eliminating manual entry errors and saving hours of reconciliation work. Every salary component, tax deduction, and statutory contribution is tracked in real time and available for instant reporting.

How to Access Payroll Reports in TallyPrime

There are two main pathways to access payroll reports in TallyPrime:

1. Gateway of Tally > Payroll > Reports - This is the primary navigation menu.
2. Alt+G shortcut - Press Alt+G to open the Gateway, then navigate to Payroll section.

Once you enter the Payroll Reports section, you will see a list of available reports. The menu updates dynamically based on whether you have enabled payroll in Tally and which statutory modules are active (PF, ESI, Professional Tax, etc.).

Salary Register Report: The Core Payroll Document

The Salary Register is the most frequently used payroll report. It displays a complete summary of salaries paid to all employees during a selected period, broken down by pay head (basic, HRA, DA, allowances, deductions, taxes, etc.).

To generate a Salary Register:

1. Gateway of Tally > Payroll > Reports > Salary Register
2. Press F2 (Period) to set the month or date range
3. Press F3 (Filter) to select specific employees or departments
4. Press F4 (Configure) to add or remove columns (e.g., bank account, cost centre)
5. Press Ctrl+P to print or Ctrl+E to export to Excel

Worked Example: Salary Register for March 2026

Assume a small manufacturing firm in Purnea has three employees. Here is a sample Salary Register output for March 2026:

Employee Name	Basic	HRA	DA	Gross	PF	ESI	PT	Income Tax	Net Pay
Rajesh Kumar	25,000	5,000	3,000	33,000	1,800	198	150	0	30,852
Priya Singh	20,000	4,000	2,400	26,400	1,440	158	150	0	24,652
Amit Patel	30,000	6,000	3,600	39,600	2,160	237	150	1,500	35,553
Total	75,000	15,000	9,000	99,000	5,400	593	450	1,500	91,057

This report shows that total gross salary is Rs 99,000, statutory deductions total Rs 7,943, and net payable is Rs 91,057. The finance team uses this to journalize the salary expense and the HR team uses it to verify accuracy before bank transfer.

Salary Slip Report: Individual Employee Statements

A Salary Slip is a detailed statement issued to each employee showing their earnings, deductions, and net pay for a specific period. It serves as proof of income and is legally required in India under the Payment of Wages Act.

To generate individual salary slips:

1. Gateway of Tally > Payroll > Salary Slip
2. Select the employee name and month
3. Review all components (earnings and deductions)
4. Press Ctrl+P to print or Ctrl+E to export as PDF

TallyPrime allows you to customize the salary slip format under F11 (Payroll Settings) > Salary Slip Format. You can add company logo, employee photo, bank details, and custom text.

Attendance Register and Leave Report

The Attendance Register tracks daily presence, absence, leave, and holidays for each employee. This data directly impacts salary calculations when you have variable pay components linked to attendance.

Access via: Gateway of Tally > Payroll > Attendance Register

You can view attendance by:

• Individual employee (select name, view month-by-month)
• Department (see all employees in one view)
• Date range (custom period analysis)

The report shows Present, Absent, Leave (with type), and Holidays. If you have created employees in Tally with shift assignments, the report auto-calculates expected working days.

Deduction Summary and Statutory Contribution Reports

These reports break down all employee deductions and employer contributions by type and statutory category.

Deduction Summary Report shows:

• Professional Tax (PT) collected
• Income Tax (TDS) deducted
• Employee PF contributions
• Employee ESI contributions
• Other deductions (loan EMI, advance recovery, etc.)

Statutory Contribution Report displays:

• Employer PF contribution (matching employee PF)
• Employer ESI contribution
• Total statutory liability

Access: Gateway of Tally > Payroll > Reports > Deduction Summary or Statutory Contribution Report

These reports are critical for reconciling payroll liabilities with your Balance Sheet and for filing statutory returns (Form 12BA for PT, Form 16 for income tax, etc.).

Pay Head Analysis Report

The Pay Head Analysis report aggregates all earnings and deductions across employees to show which pay heads consume the most budget and identify trends.

For example, a Pay Head Analysis might reveal:

• Basic salary: Rs 75,000 (76% of gross)
• HRA: Rs 15,000 (15%)
• DA: Rs 9,000 (9%)
• Total Gross: Rs 99,000

This helps management forecast payroll costs and adjust compensation structures. Access via: Gateway of Tally > Payroll > Reports > Pay Head Analysis

Employee Master Report

The Employee Master Report lists all active and inactive employees with their master data: name, employee ID, date of joining, designation, department, bank account, PAN, Aadhar, and statutory registration numbers (UAN for PF, ESI ID, etc.).

This report is useful for:

• Verifying employee records are complete before payroll processing
• Exporting employee data for statutory filings
• Auditing employee master changes

Access: Gateway of Tally > Payroll > Reports > Employee Master Report

Reconciling Payroll with Accounting

One of the most critical tasks in finance is reconciling payroll expenses with the general ledger. TallyPrime makes this straightforward because payroll entries automatically create GL vouchers.

To reconcile:

1. Generate Salary Register for the month (note total gross and deductions)
2. Open Profit & Loss (Alt+P) and check Salary/Wages account (should equal gross salary)
3. Check statutory liability accounts (PF Payable, ESI Payable, PT Payable)
4. Verify bank account shows net salary paid

If numbers do not match, check for:

• Duplicate salary entries (delete and re-enter)
• Salary reversals or adjustments not visible in Salary Register (check Payroll Vouchers)
• Employees added/removed mid-month (verify Salary Register filters)

Filtering and Customizing Payroll Reports

TallyPrime's report filters allow you to slice payroll data by multiple dimensions:

• F2 (Period): Select month, quarter, or custom date range
• F3 (Filter): Choose specific employees, departments, cost centres, or designations
• F4 (Configure): Add/remove columns, change sort order, set decimal places
• F5 (Sort): Sort by employee name, ID, gross salary, or deduction amount
• F9 (Print): Print to paper, PDF, or email
• Ctrl+E (Export): Export to Excel (.xls or .xlsx) for further analysis

For example, to see only employees in the Production department earning over Rs 30,000, apply filters in F3 and F4 sequentially.

Exporting Payroll Reports to Excel

Exporting payroll reports to Excel is essential for sharing with auditors, management, and statutory authorities. The process is simple:

1. Open any payroll report (e.g., Salary Register)
2. Press Ctrl+E or click the Export button
3. Select Excel format (2007 or 2003)
4. Choose destination folder (default is Tally data folder)
5. File saves with timestamp (e.g., SalaryRegister_20260315.xlsx)

Exported files retain all formatting and can be further manipulated in Excel for pivot tables, charts, and custom analysis.

Setting Up Payroll Before Generating Reports

To generate meaningful payroll reports, you must first set up payroll infrastructure in TallyPrime. This includes:

• Enable payroll in Tally under F11 (Payroll Settings)
• Create employee masters with personal and statutory details
• Define pay heads (Basic, HRA, DA, allowances, deductions)
• Configure PF setup in Tally if applicable
• Configure ESI setup in Tally if applicable
• Set up Professional Tax if applicable to your state
• Enter salary slips or use salary import for bulk entry

Once these are in place, reports will auto-populate with accurate data.

Common Issues and Troubleshooting Payroll Reports

If payroll reports show incorrect data or fail to generate, try these steps:

• Missing employees in report: Check F3 (Filter) is not restricting the employee list. Verify employee status is "Active" in Employee Master.
• Zero salary amounts: Confirm salary slips were entered or imported. Check Payroll Vouchers (Gateway > Payroll > Vouchers).
• Mismatch with GL: Run Data Repair (Alt+Y > Data > Repair) to fix corruption. Back up first.
• Report takes too long to load: Reduce date range using F2 (Period). Export to Excel and analyze offline.
• Cannot see statutory reports: Verify statutory modules (PF, ESI, PT) are enabled under F11 > Statutory Settings.

Payroll Reports and Compliance

Payroll reports in TallyPrime directly support statutory compliance:

• Form 12BA (PT filing): Generated from Deduction Summary Report (PT deducted)
• Form 16 (Income Tax): Use TDS Deduction report; TallyPrime integrates with e-filing portals
• PF Return (Form 3A/5IF): Pulled from PF setup in Tally data and Salary Register
• ESI Return (Form 5): Generated from ESI setup in Tally and Statutory Contribution Report
• Salary Certificate: Issued to employees; based on Salary Register

All these reports are audit-ready because TallyPrime maintains a complete transaction trail.

Choosing the Right TallyPrime Version for Payroll

Payroll reporting capabilities are consistent across TallyPrime editions. However, the number of concurrent users and data storage differ. For small to mid-sized businesses in Purnea and Bihar, we recommend:

• TallyPrime Silver: Single-user, perpetual license at Rs 22,500 + 18% GST. Ideal for sole proprietors and small firms (up to 20 employees).
• TallyPrime Gold: Unlimited LAN users, perpetual license at Rs 67,500 + 18% GST. Best for growing firms and multi-department payroll.

Both include 1 year of Technical Support Services (TSS) free. See TallyPrime price for current rates and upgrade options. For remote access, Tally on Cloud offers secure RDP hosting from Rs 899-1,299 per month with daily backups and 99.9% uptime.

Conclusion: Mastering Payroll Reports in TallyPrime

Payroll reports in TallyPrime transform raw salary data into actionable insights for HR, finance, and compliance teams. By understanding how to access, filter, customize, and export these reports, you can streamline payroll processing, ensure accuracy, and meet statutory deadlines with confidence. Whether you are managing payroll in TallyPrime for the first time or optimizing an existing process, these reports are your single source of truth for employee compensation.

Ready to master payroll reporting and take control of your HR finances? Contact Global IT Care, a Tally 3 Star Certified Partner in Purnea, Bihar, serving businesses since 2010. We offer hands-on training, payroll setup, and ongoing support to ensure your TallyPrime investment delivers maximum value. Call us at +91 75469 00951 or visit our office in Purnea to schedule a free consultation today.