www.TallyERP9Help.Com

Pay Sheet in Tally.ERP 9 Payroll

Pay Sheet is a matrix report with category, groups and employees cascading in rows, and Pay Heads appears as columns. The default report contains all earnings and deduction details for a given month or period with a number of options to re-configure the appearance of rows and columns. Format of the pay sheet report may be configured to serve as a Salary/Wage register as required by the organization. The selection of data can be filtered based on a given category or group of employees.

Go to Gateway of Tally > Display > Payroll Reports > Statements of Payroll > Pay Sheet

In the Employee Filters screen,

  • In the Name of Category field select the required Employee Category from Employee Filter

  • In the Name of Employee Group select the required Employee Group from the List of Employees / Groups


[Img-175]

The Pay Sheet is displayed as shown:


[Img-176]

Scroll towards the right to view other details.


[Img-177]

Configuration options in Pay Sheet report

F12: Configure button in the Pay Sheet brings up a configuration sub-form by which the user can customize the display/printing content and appearance of the Pay Sheet report.


[Img-178]

  • Appearance of Pay Head Types: The Appropriate option can be selected from Earnings/Deductions/All Items to display only Earnings or Deductions or to show All Pay Heads

  • Show ‘Net Amount’ Column: Set this option to Yes to display the Net Amount Column

  • Show Column SubTotals: Set this option to Yes to display the sub-totals of Earnings/Deductions columns

  • Show Pay Slip Names for Ledgers: Set this option to Yes to display the Name to Appear in Pay Slip, defined in Pay Heads, as the column headings. Setting this to No will display Pay Head name

  • Show Gross Salary Details: Set this option to Yes to display Pay Head wise Gross Salary details. This will display all those Pay Heads whose Income Type has been set asFixed in the Pay Head Master.

  • Show Grand Total: Set this option to Yes to display Grand total at the bottom of the report

  • Show Attendance Details: Set this Option to Yes to display the attendance details

  • Display Production Types in Tail Units: For compound units used in Production Type, set this flag to Yes to display value of the Production Data in Tail unit and set the same toNo to display data in Main unit

  • Show Employees By Categories & Groups: Set this option to Yes to display the rows showing Category and Groups. Setting this to No will list only employee information.

  • Show Category/Group Total: Set this option to Yes to display Category and Group wise Totals

  • Show Category / Group in Columns: Set this option to Yes to display Category and Groups in Columns. This option can be set to Yes only when the option Show Employees By categories & Groups is disabled.

  • Remove Zero Entries Employees: Set this option to Yes to remove an Employee with Zero Earnings/ Deductions

  • Format: You can choose either Detailed or Condensed

  • Show Employee Number: Set this option to Yes to display employee number along with the Name

  • Show Employee Bank Details:Set this option to Yes to display the Bank Name and Account Number of the employees along with the employees' names

  • Show Income Tax Number (PAN): Set this option to Yes to display employee IT PAN number.

  • Show Employee PF Account Number: Set this option to Yes to display employee PF Account number.

  • Show Employee ESI Number: Set this option to Yes to display employee ESI number.

  • Show Employee PR Account Number: Set this option to Yes to display the employee Permanent Retirement Account Number.

  • Show Employee Designation: Set this option to Yes to display the Employee Designation.

  • Show Employee Function: Set this option to Yes to display the Employee Function specified under General Information.

  • Show Date of Joining & Resignation: Set this option to Yes to display employees Date of Joining & Resignation details.

  • Expand all levels in Detailed format?: Set this option to Yes to expand all levels and display Employee details. Set the same to No, to display summary report for Category/Group

  • Appearance of Employee Names: The appropriate appearance of names can be selected from the Display Employee Name Style list.

  • Sorting Method: The appropriate sorting method can be selected from the list

Button options in Pay Sheet report

F1: Detailed/Condensed

Use this toggle button (F1) to quickly change the report view from detailed to summary and vice versa.

F2: Period

Using Period (F2) button, you can change the period for which the report is viewed. Using this functionality, you can display the report for any period such as Day, Week, Fortnight, Month, Quarter, Half-Year or entire Year.

Ctrl+F7: Employee Filters

Similar to Payroll and Payment vouchers, using Employee Filters button or clicking on F7: Employee Filters button, the user can quickly select employees/groups to be displayed in the pay sheet report.

C: New Column

Use this button (Alt+C), to add a column for any other Pay Head not part of the default Pay Slip format. Such new column is added on the right-hand side of the existing columns.

A: Alter Column

Use this button (Alt+A), to replace an existing column in the report with a new Pay Head column. The cursor should be positioned in the column to be replaced.

D: Delete Column

Use this button (Alt+D), to delete an existing column in the report. The cursor should be positioned on the column to be deleted.

Use above column buttons to customise the appearance of various Pay Heads as columns as per requirement.

Printing Pay Sheet Report

Printing of Pay Sheet is done in a similar way as any other report in Tally.ERP 9, by Pressing Alt+P from the report display screen.

While printing the Pay Sheet report, choose an option to Increase the Line Height (for each employee line) for the purpose of obtaining signature of employee or fixing a stamp, and use the printed report for manual salary disbursement or any other similar purpose.

E-Mailing Pay Sheet

E-Mailing of Pay Sheet is done in a similar way as any other report in Tally.ERP 9, by pressing Alt+M from the report display screen.

Exporting Pay Sheet

Exporting of Pay Sheet is done in a similar way as any other report in Tally.ERP 9, by Pressing Alt+E from the report display screen.

 
 
 
 
Tally.ERP 9 Reference Manual LIBRARY
1.
Installation of Tally.ERP9
2.
Site Licensing of Tally.ERP9
3.
Shortcut Keys in Tally.ERP9
4.
Maintaining Company Data
5.
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
6.
Voucher Entry
7.
Reports in Tally.ERP9
8.
Excise for Dealer
9.
Excise for Manufacturer
10.
Reports [ Excise for Manufacturer]
11.
Excise for Importer
12.
Service Tax in Tally.ERP9
13.
Tax Collected at Source (TCS) in Tally.ERP9
14.
Tax Deducted at Source (TDS) in Tally.ERP9
15.
Value Added Tax (VAT) in Tally.ERP9
16.
Central Sales Tax (CST) in Tally.ERP9
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
Our Portal : www.TallyERP9Book.Com www.IncomeTaxManagement.Com www.Tally9Book.com www.TallyERP9Help.Com
Disclaimer :
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.
The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications