Quick answer: Indian payroll produces four groups of reports. Processing reports check the payroll before payment (payroll register, gross-to-net, variance, attendance). Payment and accounting reports move the money and update the books (bank advice, payslips, payroll GL report, reconciliation). Statutory reports support filings (PF ECR, ESI contributions, professional tax, TDS and Form 138, Form 130, Labour Code registers and returns). Management reports analyse cost and headcount (payroll cost by department, YTD, budget vs actual).
Running payroll is not only about paying people correctly; it is also about proving it. Each month, payroll generates reports that check the calculation, instruct the bank, update the accounts, support PF, ESI, PT and TDS filings, and tell management what the workforce costs. Knowing which report does what helps you build a monthly pack that catches errors early and answers auditors' and inspectors' questions quickly. This guide lists the payroll reports used in India, what each shows, how often to run it and who uses it. It is part of our guide to the payroll process in India.
Payroll reports at a glance
| Report | Group | Frequency | Main user |
|---|---|---|---|
| Payroll register | Processing | Every pay period | Payroll, approver, auditor |
| Gross-to-net (GTN) | Processing | Every pay period | Payroll, approver |
| Variance / movement report | Processing | Every pay period | Payroll reviewer, finance |
| Attendance, LOP and overtime report | Processing | Every pay period | HR, payroll |
| Joiners, leavers and changes report | Processing | Every pay period | HR, payroll |
| Bank advice / transfer report | Payment | Every pay period | Finance, bank |
| Payslips | Payment | Every pay period | Employees |
| Payroll GL / journal report | Accounting | Every pay period | Accounts |
| Payroll reconciliation report | Accounting | Monthly and year end | Accounts, auditor |
| PF ECR and contribution report | Statutory | Monthly | Payroll, EPFO |
| ESI contribution report | Statutory | Monthly | Payroll, ESIC |
| Professional tax and LWF reports | Statutory | Monthly / periodic, by State | Payroll, State authority |
| TDS deduction report and Form 138 | Statutory | Monthly / quarterly | Payroll, tax |
| Form 130 and annual tax statement | Statutory | Annual | Employees, tax |
| Labour Code registers and annual returns | Statutory | Ongoing / annual | Compliance, inspectors |
| Payroll cost by department / cost centre | Management | Monthly | Management, finance |
| Year-to-date (YTD) report | Management / statutory | Monthly | Payroll, tax, finance |
| Budget vs actual and headcount reports | Management | Monthly / quarterly | Management, HR |
Payroll processing reports
Payroll register
The complete record of the pay period: one row per employee with paid days, each earning, gross, each deduction, net pay and employer contributions. It is the source of almost every other report. See our full guide to the payroll register.
Gross-to-net (GTN) report
The GTN report shows, for each employee or in total, how gross pay becomes net pay. For the three-employee October 2026 payroll used in our payroll in Excel guide, the total GTN is:
| Line | Amount (₹) |
|---|---|
| Gross pay | 81,387 |
| Less: employee PF | (6,816) |
| Less: employee ESI | (135) |
| Less: professional tax | (200) |
| Less: TDS | (1,500) |
| Net pay | 72,736 |
Reviewers use it to spot impossible results, such as negative net pay, total deductions above the 50% limit under the Code on Wages or a missing TDS line for an employee who should have one.
Variance or movement report
Compares this period with the last: headcount, gross pay, each component and each deduction, with the reasons for change (joiners, leavers, revisions, arrears, loss of pay). Every rupee of difference should be explained before approval; our payroll reconciliation guide shows a worked movement reconciliation.
Attendance, loss-of-pay and overtime report
Lists paid days, loss-of-pay days, leave and overtime hours by employee, as fed into payroll. It lets HR confirm the inputs and lets payroll explain pay changes. Overtime, paid at no less than twice the ordinary rate, should be checked against approvals.
Joiners, leavers and changes report
Lists new employees, exits, salary revisions, bank-detail changes and other master-data changes in the period. It is one of the most important fraud and error controls, because most payroll errors start with a change that was missed or not authorised.
Payment and accounting reports
Bank advice or bank transfer report
Lists each employee's name, account number, IFSC and net pay, in the format your bank accepts for bulk upload. Its total must equal net pay in the register. Approve it separately and check the bank statement after payment for returned transfers.
Payslips
Each employee's line from the register, with earnings, deductions, net pay, paid days and year-to-date figures. See our explanation of the salary slip and the free salary slip generator.
Payroll GL or journal report
Maps the register totals to ledger accounts: salary expense, employer PF and ESI expense, salary payable and each statutory payable, often by department or cost centre. It produces the monthly salary journal entry.
Payroll reconciliation report
Shows that the register, ledger, bank and challans agree, with any differences and their causes. It is prepared monthly and in more detail at the year end for the audit.
Statutory payroll reports
| Report | What it shows | Timing |
|---|---|---|
| PF ECR and contribution report | Member-wise UAN, wages, EPF, EPS and EDLI wages, contributions and NCP days | Paid and filed by the 15th of the next month |
| ESI contribution report | Employee-wise ESI number, days, wages and contributions | Paid by the 15th of the next month |
| Professional tax report | Employees by slab and PT deducted, in the State's format | State due dates (monthly, quarterly, half-yearly or yearly) |
| Labour welfare fund report | Employee and employer LWF, in States that levy it | Monthly, half-yearly or yearly, by State |
| TDS deduction report | Employee-wise salary, TDS deducted and challan details | Monthly; TDS deposited by the 7th (30 April for March) |
| Form 138 (earlier Form 24Q) | Quarterly statement of TDS on salary | 31 Jul, 31 Oct, 31 Jan, 31 May |
| Form 130 (earlier Form 16) | Annual TDS certificate for each employee | By 15 June after the tax year |
| Labour Code registers | Wages, attendance, deductions and overtime in prescribed formats | Maintained continuously |
| Annual returns under the Labour Codes | Consolidated annual return, for example Form XVII under the OSH Central Rules | By the end of February for the previous calendar year (central sphere) |
Our guides cover each of these in depth: PF ECR filing, ESIC challan, professional tax, Form 138, statutory registers and the full payroll compliance calendar. Official rules are on the EPFO and Income Tax Department websites.
Management payroll reports
- Payroll cost by department or cost centre: gross pay plus employer contributions, so managers see the true cost of their teams.
- CTC vs actual cost: compares budgeted cost to company with what was paid, highlighting overtime, arrears and one-off payments.
- Headcount and attrition: employees at the start and end of the month, joiners and leavers, by department.
- Budget vs actual: monthly payroll cost against budget, with forecasts for the rest of the year.
- Overtime and incentive analysis: trends by team, useful for staffing decisions and for checking compliance with overtime limits.
- Salary distribution: ranges by grade or role, used in pay reviews and pay-equity checks.
Year-to-date and year-end reports
The YTD report adds each month's figures for every employee from April onwards. It feeds TDS projections through the year, the final quarter's Form 138 and Form 130, bonus calculations, and the year-end reconciliation of salary in the books with the tax records. At the year end, payroll also supplies data for the bonus, gratuity and leave provisions; see our payroll provisions guide.
A monthly payroll reporting pack
- Before approval: changes report, attendance report, payroll register, GTN and variance report.
- At approval: payroll summary signed off with the variance explanations attached.
- Payment: bank advice, then the bank statement confirming payment.
- Accounts: payroll GL report and journal, then the reconciliation report.
- Statutory: PF ECR, ESI, PT, LWF and TDS reports with the challans and acknowledgements.
- Management: cost by department, headcount and budget vs actual.
File the pack for each month together. When an auditor or inspector asks about a month, everything is in one place.
Where payroll reports come from
Payroll software produces these reports as standard, usually with export to Excel and PDF. In TallyPrime, the payroll module offers the pay sheet, payroll statement, payment advice, payroll register, attendance reports and PF, ESI, PT and income-tax reports; see our payroll in Tally Prime guide. In Excel, the register, GTN, summary and statutory totals can all be built from one well-structured workbook, as shown in our payroll in Excel guide. Whatever the source, the reports should agree with each other, and the register should be the single source of truth.
HR payroll reports
HR teams use payroll data for their own reports: headcount and attrition, joiners and leavers, leave balances, salary revisions and increment history, and the wage report showing each employee's wages against the applicable minimum wage. These HR payroll reports should come from the same approved register, so headcount and cost figures match what finance reports.
Payroll report formats
Most payroll reports are needed in more than one format. PDF is for approval and filing, because it gives a fixed record of what was approved. Excel or CSV is for analysis and for uploads, such as the bank bulk-payment file or the ECR text file for the EPFO portal, which must follow the portal's exact format. Printed or digital registers in prescribed formats are kept for inspections. Name files consistently, for example "Payroll_Register_2026-10.pdf", and keep the approved PDF alongside the working spreadsheet.
Payroll reports the auditor will ask for
- Monthly payroll registers and approvals for the year, and the YTD register.
- The reconciliation of salary in the books with Form 138 and Form 130 totals.
- PF ECRs and challans, ESI contribution details and challans, PT and LWF returns, with payment dates, so late payments and the tax treatment of employee contributions can be checked.
- Joiners, leavers and revisions with their approvals, to test that only genuine employees were paid at approved rates.
- TDS challans and Form 130 issue dates.
- Data used for bonus, gratuity and leave provisions.
Keeping these together each month makes the year-end audit far quicker.
Common reporting mistakes
- Reports from different versions of the data: a bank file generated before a last-minute correction will not match the final register.
- No variance review: payroll approved without comparing with last month misses missed leavers and duplicate payments.
- Statutory reports not tied to the register: the PF ECR or Form 138 should total to the same figures as the register for the period.
- Reports shared too widely: payroll reports contain salaries, PAN and bank details; share summaries with managers, not full registers.
Get the core reports from one workbook. The Complete Indian Payroll Excel Workbook produces the payroll register, payslips, summary and PF, ESI, PT and TDS totals for each month.
Frequently asked questions
What is a payroll report?
A payroll report is any report produced from payroll data to check, pay, account for, file or analyse employee pay. Common examples are the payroll register, payroll summary, gross-to-net report, bank advice, PF and ESI contribution reports, TDS reports, variance reports and year-to-date reports.
What reports should be generated every month in payroll?
Every month, generate the payroll register, a payroll summary, a variance report against the previous month, the bank transfer report, payslips, the PF ECR and contribution report, the ESI contribution report, professional tax and TDS deduction reports, and the payroll journal or GL report for accounts.
What is a gross-to-net report?
A gross-to-net (GTN) report starts with each employee's gross pay, lists every deduction such as PF, ESI, professional tax, TDS and recoveries, and ends with net pay. It shows how take-home pay was reached and is used to check payroll before payment.
What is a payroll GL report?
A payroll GL report maps payroll totals to general ledger accounts: salary expense, employer contributions, salary payable and each statutory payable, often split by department or cost centre. It is the basis of the monthly payroll journal entry in the books.
What is a YTD payroll report?
A year-to-date (YTD) payroll report shows each employee's cumulative earnings, deductions and tax from the start of the tax year to the current month. It is used for TDS projections, annual tax statements such as Form 130, and year-end reconciliations.
Position as of 15 November 2026. Due dates as they apply to private-sector employers; State professional tax and LWF rules vary. General information, not legal or tax advice.