Scribd
Upload
6 views2 pages

Salary Preparation and Employee Management

The document outlines procedures for salary preparation, adding a new employee, and removing an existing employee. It includes steps for updating workdays, attendance, accounting entries, and refreshing data in pivot tables. Additionally, it emphasizes the importance of recording total net salary and printing payslips for new employees.

Uploaded by

Vinay HE
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
6 views2 pages

Salary Preparation and Employee Management

The document outlines procedures for salary preparation, adding a new employee, and removing an existing employee. It includes steps for updating workdays, attendance, accounting entries, and refreshing data in pivot tables. Additionally, it emphasizes the importance of recording total net salary and printing payslips for new employees.

Uploaded by

Vinay HE
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

01 Next Month Salary Preparation

01. Year, Month Need to Change


[Link] Need to Change No of WorkDays ,[Link] , OT
03. If it Has Any Adjustment in Payheads , We Need to Consider
04. Total Net Salary Amount Need to Record in Accounting Entries T

02 Add A New Employee

[Link] need to type employees' Personal Information and Payheads information in Raw data table
02 You Need Select the new employee in the payroll sheet table and need to add No of Workdays ,[Link] ,
03 Update the Accounting Entries as per Total Net Salary
04 select one pivot table and click refresh all button to update the data
05 select the new employee ID and Print the Payslip

03 Remove an Existing Employee

[Link] need to the employee from the raw data table


02 You Need remove the employee in the payroll sheet table
03 Update the Accounting Enries as per Total Net Salary
04 select one pivot table and click refresh all button to update the data
05 select the an existing employee in the Payslip
Workdays ,[Link] , OT

You might also like