KEMBAR78
Sage Payroll Guide | PDF | Payroll Tax | Payroll
0% found this document useful (0 votes)
112 views42 pages

Sage Payroll Guide

Chapter 3 provides a detailed guide on setting up payroll parameters, including bank and statutory accounts, allowance tables, and personnel file maintenance. It outlines the steps for configuring various accounts such as EPF, SOCSO, and tax, as well as the process for updating and processing payroll. Additionally, it covers reporting and government submissions related to payroll management.

Uploaded by

geniuskk
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
112 views42 pages

Sage Payroll Guide

Chapter 3 provides a detailed guide on setting up payroll parameters, including bank and statutory accounts, allowance tables, and personnel file maintenance. It outlines the steps for configuring various accounts such as EPF, SOCSO, and tax, as well as the process for updating and processing payroll. Additionally, it covers reporting and government submissions related to payroll management.

Uploaded by

geniuskk
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 42

Chapter 3:Payroll 15

Chapter 2

?Company Setting
?Employer Information

In This Chapter
u Parameter Setup
u Bank & Statutory Accounts
u Allowance Table
u Personnel File Maintenance
Chapter 3:Payroll 16
Chapter 3:Payroll 17

Parameter Setup
Note : All new companies created in the system MUST have relevant
information set in the Parameter Setup first before the system can
generate your company payroll correctly.

8 Go to Housekeeping > Setup > Parameter Setup


8 Click on each of the tab, Company Details, Pay Calculation, Pay
Calculation (2) & Control to check on the default values provided in
the system. You may change where necessary to suit your
company’s requirements.

Upon completion of the parameter setup, your next step will be to set up
the bank and other statutory accounts like EPF, SOCSO, Tax, Haji and ASN
via Housekeeping > Setup > Addresses & A/C No.
There are three (3) tabs, Organisation Information, Your Company
Registered Information & Officer In Charge, available for you to key in
relevant information related to the Organisation Type selected at the
header.
Chapter 3:Payroll 18

The default values whenever user accesses this screen will be:

So, let us begin with the Bank Account setup and then move down the list.

Bank Account Setup


Step 1 Go to Housekeeping > Setup > Addresses & A/C No. With the
Organisation Type defaulted to Bank, proceed to key in
information for each of the tab
Step 2 At Organisation Information tab, key in the bank information
for Bank Code, Branch Name and Branch Code and click Save
button to save and store the information
Note: Code, Branch Name & Branch code are provided by the
bank
Chapter 3:Payroll 19

Step 3 At Your Company Registered Information tab, key in your


company Registered Name & company bank Account Number.
Click Save button to save and store the information
At the APS – Auto Pay System section, key in the information
provided by the bank when you register for the banking facilities

Step 4 At the Officer In Charge tab, key in details of the bank officer.
Click Save button to save and store the information.
Chapter 3:Payroll 20

Note: If you are using more than one bank services, you may
continue with the set up for other banks by clicking on
the icon. There are ten (10) bank categories
available for your setup requirement

8 Double-click on sequence 2 (Bank; Category 2) and


repeat Steps 2 – 4 to key in the relevant information
Chapter 3:Payroll 21

After setting up the bank account(s), we will proceed to the EPF


account setup.

EPF Account Setup


Step 1 Go to Housekeeping > Setup > Addresses & A/C No.
Step 2 Click on the icon to select EPF for the Organisation Type
8 double-click to
select any of the
five (5) available
EPF categories.
Note: The selected
EPF category will then
be displayed onto the
Organisation Type
field

Step 3 At Organisation Information tab, key in the information for


Name, Code, Branch Name and Branch Code and click Save
button to save and store the information
Chapter 3:Payroll 22

Step 4 At Your Company Registered Information tab, key in your


company Registered Name & File No. Click Save button to save
and store the information

Notes:
a. At the APS – Auto Pay System section, the related
information is defaulted upon selection of the EPF category.
The information on EPF Bank Code and APS – Auto Pay
System can be obtained from the respective bank
b. If direct submission to KWSP, ignore the above.

Step 5 At the Officer In Charge tab, key in details of the bank officer.
Click Save button to save and store the information
Chapter 3:Payroll 23

With EPF account setup completed, we will now proceed to set up the SOCSO
account

SOCSO Account Setup


Step 1 Go to Housekeeping > Setup > Addresses & A/C No.

Step 2 Click on the icon to select SOCSO for the Organisation


Type
8 double-click to
select any of the
five (5) available
SOCSO
categories.
Note: The selected
SOCSO category will
then be displayed
onto the Organisation Type field
Chapter 3:Payroll 24

Step 3 At Organisation Information tab, key in the information for


Name, Code, Branch Name and Branch Code and click Save
button to save and store the information

Step 4 At Your Company Registered Information tab, key in your


company Registered Name & File No. Click Save button to save
and store the information
Chapter 3:Payroll 25

Notes:
a. At the APS – Auto Pay System section, the related
information is defaulted upon selection of the SOCSO
category. The information on SOCSO Bank Code and
APS – Auto Pay System can be obtained from the
respective bank
b. If direct submission to PERKESO, ignore the above

Step 5 At the Officer In Charge tab, key in details of the bank officer.
Click Save button to save and store the information

Next, let us proceed to set up the Tax account.

Tax Account Setup


Step 1 Go to Housekeeping > Setup > Addresses & A/C No.
Step 2 Click on the icon to select TAX for the Organisation
Type
8 double-click to select any of the five (5) available TAX
categories.
Chapter 3:Payroll 26

Note: The selected TAX category will then be displayed


onto the Organisation Type field

Step 3 At Organisation Information tab, key in the information for


Name, Code, Branch Name and Branch Code and click Save
button to save and store the information
Chapter 3:Payroll 27

Step 4 At Your Company Registered Information tab, key in your


company Registered Name & File No. Click Save button to save
and store the information

Note: At the APS – Auto Pay System section, the related


information is defaulted upon selection of the TAX
category. The information on PCB Bank Code and APS –
Auto Pay System can be obtained from the respective
bank.
Step 5 At the Officer In Charge tab, key in details of the bank officer.
Click Save button to save and store the information
Chapter 3:Payroll 28

Run Steps 1 – 5 if you are required to set up the accounts for


Haji and ASN.

With the required bank and statutory accounts setup completed,


we will now proceed to set up the Allowance table which will
affect the payroll calculation.

This section is left blank intentionally


Chapter 3:Payroll 29

Allowance Table Setup


Step 1 8 Go to Housekeeping > Setup > Tables Maintenance
8 Select Allowance Table and click OK button

Step 2 8 Key in the Allowance description.


8 Check the boxes where applicable if it is subjected to EPF,
SOCSO, HRD, NPL, Late, Bonus & OT – please refer to the
diagram below
8 Key in the EA row number as it should appear in Part B of
the EA Form
8 Click on the line in the Relief Code column to select the
relevant code to use, where applicable
8 Click Next button to proceed
Chapter 3:Payroll 30

Step 3 8 Click on the relevant checkboxes in the Day Based column


for those allowances that are subjected to attendance for
payroll processing
8 Click Next button to proceed

Step 4 8 Check the Type and Formula setting to ensure correct


payroll calculation
Chapter 3:Payroll 31

The Abbreviation code list for setting the Type :


F – Fixed Allowance
V – Variable Allowance
S – Shift Allowance
D – Daily Allowance

With all the control settings done, we will now proceed to set up
the employee’s record.

This section is left blank intentionally


Chapter 3:Payroll 32

Personnel File Maintenance


Personnel menu is the place for you to maintain employee’s information.
Appended below is the set up flow for proper sequence of setting up the
employee record to ease your payroll processing and reporting:

Step Maintenance File Remarks

1 Employees’ Line No. For 1st level grouping of employees

2 Employees Categories For 2nd level grouping of employees

3 Employee Personal Details Individual employee record

1. Employees’ Line No. Maintenance


Step 1 On the left panel, click on Personnel > Add/Edit Line No.
Chapter 3:Payroll 33

Step 2 8 Click Add button to key in Line No and Description


8 Click Save button to save and store the information
8 Click Cancel button upon completion
8 Click Exit button to close the listing screen

2. Employee’s Categories Maintenance


Step 1 On the left panel, click on Personnel > Add/Edit Category

Step 2 8 Click Add button to key in Category and Description


8 Click Save button to save and store the information
8 Click Cancel button upon completion
8 Click Exit button to close the listing screen
Chapter 3:Payroll 34

3. Employee Personal Details


Step 1 8 On the left panel, click on Personnel > Add/Update
Employees to open the Personnel File Maintenance
screen
8 Click Add button to create new employee and personal
details in the Per. Details tab

Step 2 8 Key in relevant particulars required in the following tabs:


Tab Purpose
Pay for employment details and pay package
Govern. for Bank, EPF,SOCSO & Tax setting
Non-Citizen for non-local (expatriate)
Setting for settings that affect payroll calculation
Allow./Ded. for setting of values on allowances and
deductions for payroll calculation
Pre. Relief Information on previous employment
Prev. Year for input of arrears (amount unpaid) from
previous year
BIK for setting of values on Benefit In Kind
8 Click Save button to save and store information after
completing each tab
Chapter 3:Payroll 35

Chapter 3

? Payroll

In This Chapter
u Advanced Pay
u Update Pay
u Process Pay
u Reports
u Government Reports Submission
Chapter 3:Payroll 36

Advanced Pay
1. Update Advance Pay
Advance Pay is a sum of money paid in advance to an employee before 1st
Half Payroll or 2nd Half Payroll processing. When you process the payroll
later, the amount will be deducted accordingly either from 1st Half Payroll
or 2nd Half Payroll.

8 On the left panel, click on 2nd Half Payroll > Advance to Individual

8 Key in the Advance


value for those
employees who
took advance
8 Click Save button to
save and store the
information
Chapter 3:Payroll 37

2. Reporting
a. Listing
nd
8 Go to Payments > 2 Half Payroll > Advance > Listing

8 Click OK button to print out Advance Listing


Chapter 3:Payroll 38

8 Click Preview or Print button to view / print the Advance Listing report
Chapter 3:Payroll 39

b. Advance Pay Slip


8 Go to Payments > 2nd Half Payroll > Advance > Print Pay Slip

8 Click OK button to print the Advance Pay Slip


Chapter 3:Payroll 40

8 Click Preview or Print button to view / print the Advance Pay Slip

Note: You will have to process the payroll first (refer to Process Pay steps
on Pg 41) for the Advance Pay to take effect and be updated into
the 2nd Half Payroll> View Pay Slip > Other Deduction.
Chapter 3:Payroll 41

Update Pay
You will be required to update the pay information before processing
payroll. Follow the steps below to update the pay information:
8 Go to 2nd Half Payroll> Normal Pay

8 At Basic Pay & Overtime tab, key in the Working Days and the
number of DW (Day Worked) and save the entry
Chapter 3:Payroll 42

8 Variable Allowances and Deductions should also be maintained, if


applicable
8 Click Save button to save and store information
8 Click Exit button to close and exit from screen
Chapter 3:Payroll 43

Process Pay
To run the payroll process in the system, follow these few simple steps:

8 Go to 2nd Half Payroll > Process Pay


8 Click to select staff to process payroll selectively or leave it open to
process payroll for all staff
8 Click OK button to start the payroll process

8 Upon completion of the


process, a message box will
be prompted.
8 Click OK button to close
and exit the payroll process
screen
Chapter 3:Payroll 44

Management Reports
After payroll processing, you may print out monthly management reports
such as Employee Pay Summary, Allowance Report, Deduction Report and
so forth.
nd
Step 1 8 Go to 2 Half Payroll > Management Report
8 Select Category and click OK button

Step 2 8 Select required report from the list of management reports


8 At the Paper Size field, click on the drop down icon to select
and set the required paper size for the selected report
8 Click OK button
8 At the print dialog box, click Preview or Print button to view
/ print the selected report
Chapter 3:Payroll 45

8 Select Preview or direct Print the report.


Chapter 3:Payroll 46

Bank Reports

1. Bank Listing
8 Go to 2nd Half Payroll > Net Pay – Cash/Bank/Others
8 Click to select Bank from the list
8 Click OK button to proceed

8 At the print dialog box, click Preview or Print button to view / print
the bank listing report
Chapter 3:Payroll 47

2. Online/Diskette Submission
To submit via diskette or online to bank, follow the steps below:

8 Go to 2nd Half Payroll > Thru Bank Via Diskette


8 Click Generate button to proceed

8 At the Thru Bank Via Diskette screen, key in the date at Salary
Credit Date field
8 Click OK button to generate the text file.
Chapter 3:Payroll 48
Chapter 3:Payroll 49

8 Click Select button to select a directory to save the text file for
submission
8 Click OK button at the message dialog box

Government Reports Submission


All government reports are located in the Government menu
Chapter 3:Payroll 50

1. EPF Reports
8 Go to Government > EPF Reports
8 Select EPF Borang A and click OK button to proceed
8 click Preview or Print button to view / print the EPF Form

For Diskette Submission (EPF Borang A)


8 Click to select Open Format option
8 Click Disk button to proceed
8 Click Select button to select a
directory to save the text file for
submission
8 Click Yes button on the dialog box to view the list; or No button to
close dialog box
8 Click Exit button to close and exit from the screen
For Diskette Submission (EPF Borang BBCD)
8 User is required to print out EPF Borang BBCD as an attachment.
Chapter 3:Payroll 51

2. SOCSO Reports
8 Go to Government > SOCSO Reports
8 Select SOCSO Borang 8A (Contri.) and click OK button to proceed
8 Click Preview or Print button to view / print the SOCSO Form

For Diskette Submission (SOCSO Borang A)


8 Click Disk button to proceed
8 Click Select button to select a directory
to save the text file for submission
8 Click Yes button on the dialog box to
view the list; or No button to close
dialog box
8 Click Exit button to close and exit from the screen
For Diskette Submission (SOCSO Lampiran A)
8 User is required to print out SOCSO Lampiran A as an attachment.
Chapter 3:Payroll 52

3. Income Tax Reports


8 Go to Government > Income Tax Reports
8 Select CP 39 (Monthly) and click OK button to proceed
8 Click Preview or Print button to view / print the Income Tax Form

For Diskette Submission (CP 39)


8 Click Disk button to proceed
8 Click Select button to select a
directory to save the text file for
submission
8 Click Yes button on the dialog box to
view the list; or No button to close
dialog box
8 Click Exit button to close and exit from the screen
Chapter 3:Payroll 53

Chapter 4

? Administrative Task

In This Chapter
u Backup
u Month End Closing
Chapter 3:Payroll 54

Backup
8 Go to File > Backup & Restore > Backup

8 Click on Browser button and select thebackup destination path to


store your backup data
8 Click Backup button to start the backup process
8 Click OK button at the message box
8 Clcik Cancel button to close and exit the backup screen
Chapter 3:Payroll 55

Month End Closing


8 Go to Housekeeping > Month End to perform the month end
closing process

8 Select option as indicated below and click OK button to proceed


Chapter 3:Payroll 56

8 Ensure you have backup your data and click Yes button to proceed

8 A message box will be prompted upon completion of the month end


process. Click OK button to close and exit the screen.

*** The End ***

You might also like