&
LibPlus Nigeria Limited
Total Office Management System
TOM-S
Payroll Administration User Guide
January 2006
Contact: TOF Engineers & Consulting Ltd.: 56 Femi Ayantuga Crescent, Off Adelabu Street Surulere, Lagos. P.O. Box 4629 GPO Marina, Lagos. Tel: 0803-3045117 E-mail enquiries@softprotof.com,
Payroll Administration User Guide 1
1. Introduction to the TOM-S – Payroll Administration 4
2. An Overview – Terminologies and Workflow 5
2.2 Automatic incrementing of steps 5
2.4 Bulk Claims & Deductions Processing 5
2.5 Personnel Details Change Processing: 5
2.6 Registration and Activation of Standard Deductions 6
2.10 Security and Privileges of TOM-S – Payroll Administration 7
2.11 The Workflow Payroll Production using TOM-S – Payroll Administration 7
A: Collating Payroll Information 7
C: Approval and Payment of Payroll 8
D: Start collating data for next month’s payroll. 8
3. Starting TOM-S Payroll Administration 9
3.1 Starting TOM-S Payroll Administration 9
3.2 Getting ready for payroll processing 10
4. Configuring TOM-S – Payroll Administration Module with Operational Data 12
4.1 Sequence for configuring TOM-S – Payroll Administration with operational data 13
4.2 Staff Distribution in TOM-S – Payroll Administration 14
4.3 Payscales Organisation in TOM-S – Payroll Administration 14
4.3.1 Defining Payscales Emoluments 14
4.3.2 Domestic Servants Allowanaces 15
4.4.1 Extending Payscale Components 16
4.4.2 Special Allowances, Special Deductions and Monetised Allowances 17
5. Personnel Data Entry and Modifications 19
5.1.1 To add details for a new employee 19
5.1.2 To modify details of an existing employee 19
5.1.3 To Validate Pending Changes 20
5.1.4 Special Cases: Affecting Promotions & Bank Account Details Changes and Retirement 20
5.1.5 View history of changes made to employee’s details 21
6. Preparing Payroll Information 23
6.1 Specifying the year and month to process payroll 23
6.2 Affect Annual Increments 24
6.3 Processing Payroll Payroll 24
6.4.1 Leave Allowance Claims 25
6.4.2 Other Allowances and Deductions 26
6.4.3 Assessing Claims/Deductions for Approval/Rejection 26
6.5 Union, Thrift & Funds Deductions 28
6.6 Special Allowances and Special Deductions 28
6.8 Bulk (Group) Claims/Deduction Registration And Processing 30
7. Prepare Payroll for the Month 32
7.2 Updating Existing Payroll 32
7.4.3 Effects of Payroll Assessment 35
7.5 Monitoring Progress of Payroll: Payroll Production Status 35
8.1 To print payroll reports 37
9. Special Payroll Operations 40
9.1.1 Closing Payroll Computations 40
9.2 Re-opening Payroll Approved for Payment 40
10. Searching Personnel and Payroll Records 42
10.1 Searching Personnel Records 42
10.2 Searching Payroll Records 42
11.1 Tax Computation Process 46
11.1.1 Nett Pay Computations 46
Introduction to the TOM-S – Payroll Administration
TOM-S Payroll Administration is designed to automate the process of preparing payroll at the end of each month, thereby improving operational efficiency. TOM-S Payroll Administration has the following features:
- Easy to use with its user friendly graphical user interface (GUI). Simply selecting and clicking on objects on the interface using a mouse performs operations.
- Configurable as a stand-alone system or a multi-user system in a network of computers such that multiple users can share application data from several workstations.
- Based on a flexible pay structure, incorporating Civil Service pay structure (HAPSS & HATISS).
- Integrates staff auditing with payroll computation.
- Captures personnel details permanently on the computer with facility to keep a history of all modifications to, and variations of, personnel details.
- Produce salaries of all employees every month, with facilities for processing overtime and arrears claims, pro-rating of salary, affecting regular deductions due to loans, union and thrift society contributions, and other specified non-standard pay related claims/deductions; including bulk processing of claims and allowances.
- Generate payslips for individual staff members at the end of every month.
- Provides instant up-to-date access to current and historical payroll information.
- Allows modification of parameters that affect the payroll such as changes in tax laws and other government regulations.
- Allows amendments the parameters/ variables (payscale, allowances etc.) that affect the remuneration of individual staff members.
- Provides a simple but sophisticated change request procedure for affecting changes to personnel details, ensuring that history of changes is maintained.
- Provides facility to modify configuration data to handle future reorganisation of the company structure such as changing/adding new departments and sections and updates to payscales.
- Maintains a concise audit trail of payroll production activities.
- Provides standard and user defined detailed reports and graphs on payroll.
- Provides versions for managers to monitor payroll production activities from remote locations (multi-user version).
- Provides a flexible and easy to use back-up procedure.
- The payroll databank provides a wealth of payroll information from which we can derive statistical information to inform policy making, budgeting and planning.
- Customisable to meet the company specific payroll operations.
To fully, and effectively, grasp the concepts and procedures presented in this document, it is strongly recommended to initiate a session of TOM-S – Payroll Administration on the computer in parallel to studying this document.
An Overview – Terminologies and Workflow
TOM-S – Payroll Administration introduces concepts describing key operations that would be performed using the payroll system. The concepts are:
- The Working Period
- Automatic incrementing of steps
- Claims Processing:
- Claims Registration
- Claims Assessment
- Bulk Claims/Deductions Processing
- Personnel Details Change Processing:
- Personnel Details Change Requests
- Personnel Details Change Validation
- Promotions Processing
- Payroll Assessment
- Registration and Activation of standard deductions (Loan, Thrift, Union & Funds)
- Staff Auditing
- Audit Trailing
The Working Period
The working period comprises of the year and the month for which you are preparing payroll. This concept is in keeping with the normal practice to produce payroll in monthly batches. TOM-S – Payroll Administration module demands that the working period should be defined.
Automatic incrementing of steps
Increments to employees’ step on his/her grade level can be done automatically depending on the employment date and, subsequently, on the date of the employee’s last promotion. The increment stops at the limit of the steps on the grade level, until the employee is promoted to another grade level. TOM-S – Payroll Administration module provides a simple facility for performing the increments automatically by simply clicking a button on one of the applications interface before you start processing payroll for the month.
Claims Processing:
TOM-S – Payroll Administration introduces an approach to processing claims (leave, arrears, overtime, monetised allowances etc) that affect payroll, ensuring the following:
- security and consistency of information by using a unified method for registering the claims and assessing the claims for approval or rejection;
- keeping a concise log of the claims to enhance auditing, enquiries and useful historical analysis of employees remuneration;
- simplicity of claims processing procedure to minimal errors and easy identification of errors in registration
Bulk Claims & Deductions Processing
Considering that the staff strength of your company can be in excess of 300+, it is most likely that situations will arise where groups of employees would be entitled to the same value of certain allowances such as bonus, for example. TOM-S – Payroll Administration introduces a facility for bulk processing of claims and deductions to perform group entries of claims and deductions.
Personnel Details Change Processing:
Changes to details of employees are placed under a strict auditing procedure such that, when modifications are made to details of an employee, the changes are recorded in history. Depending on the user’s access level, the changes are either reflected immediately on the record of the employee (users with VALIDATE privileges) or registered as pending changes, which are validated at a later time by a user with VALIDATE privileges.
Pending changes are assessed for approval, commitment (validation) or rejection by any user with VALIDATE privileges via the Validate function on the personnel administration module of TOM-S – Payroll Module.
The procedure for processing promotion of staff is done by the Promotions function, which generates a set of Change Requests, such as the new grade level and step, which are then processed by the Change Request Assessment function.
The history of all changes made to personnel information are kept permanently in the database and users can view/print the history of all requests registered, approved, rejected and committed, for each employee at any time.
Registration and Activation of Standard Deductions
Deductions such as loans, unions, funds and thrift deductions are deductions affected every month. Furthermore, these deductions are usually consistent in terms of amounts deducted/contributed and it would be time wasting to enter them every month when payroll need to be prepared. TOM-S – Payroll Administration allows the deduction to be registered once and the user (with appropriate privileges) only needs to activate, or deactivate, it when it is to be reflected, or suspended, in payroll.
Payroll Assessment
When a monthly batch of payroll is completed, it is customary to review the payroll and introduce cut off dates after which new claims would not be entertained. Furthermore, it is imperative to maintain the integrity of payroll data that have been disbursed to employees such that modifications to the data are not inadvertently made. TOM-S – Payroll Administration provides the means to assess globally all payroll schedules produced such that when tagged as approved or paid, the integrity of the information would be maintained.
Audit Trailing
TOM-S – Payroll Administration keeps a log of useful information on all the payroll production activities. This log of activities is called the audit trail. It is like a logbook of activities from which managers and supervisors can easily monitor the overall progress of payroll production. The audit trail includes the activities of each operator and each log is stamped with a date and time the activity that took place. Access to the facility is restricted to users with the highest access level to the payroll system.
To complement the audit trail facility, a history of key activities, such as overtime claims, leave claims, union deductions and loan deductions, are also kept to enable a more thorough audit of each employee’s remuneration history to be performed. Thus, it is easy and less time consuming to respond to queries and enquiries made by employees concerning their remuneration
Staff Auditing
TOM-S – Payroll Administration integrates staff auditing into its payroll administration. The module essentially suspends payroll production of employees who have not been confirmed as valid employees of the company. Staff audit can be initiated as frequently as your company policy dictates. Implementation is simple, but the result is powerful.
Security and Privileges of TOM-S – Payroll Administration
TOM-S – Payroll Administration provides several levels of privileges indicating operations according to division of tasks.
ENQUIRIES: View information and search for information
DATAENTRY: Data entry purposes only
OPERATIONS: Performs functions relating to calculating payroll, data entry and modifications, logging claims and deductions and configuring the application with payroll data.
VALIDATE: Supervisory Role performing higher level functions such as
- processing claims and deductions for approval or rejection,
- processing changes made to personnel details,
- assessing payroll for approval and payment,
- maintaining staff audit and
DELETEDATA: Delete data such as personnel information details.
SPECIAL OPERATIONS: Performs special operations such as
- Close Payroll Computation on completion and payment so that no changes to existing payroll can be made
- Reopen payroll computations after they have been closed
- Process for unclaimed wages
HOUSKEEPER: Performs Backups and Restore of TOM-S database
SYSADMIN: Performing system administrative functions, including creating user accounts, assigning users privileges and controlling access to TOM-S.
The Workflow Payroll Production using TOM-S – Payroll Administration
A: Collating Payroll Information
- Collate information on new staff
- Collate information on claims for the month; Arrears, Leave, Overtime and Miscellaneous Claims
- Collate information on deductions for the month; Unions, Thrift and Loan deductions
- Collate employees to be promoted and remuneration to reflect in payroll
- Collate new payscales values, if changes are required
- Start and Log on to TOM-S using your user name and password.
- Initiate staff audit and complete the auditing process
- Set the Month and Year for payroll production
- Enter details of new employees.
- Register personnel details changes for relevant employees
- Register promotions details for relevant employees
- Process the Personnel Details Changes
- Register Claims for the month; Leave, Arrears, Overtime and Miscellaneous claims
- Register new Loan deductions, Union deductions, Thrift deductions and Funds deductions
- Register claims and deductions for groups of employees, if required.
- Process (Approve/Reject/Commit) all emolument change requests, particularly those to reflect for the month of production
- Process (Approve/Reject) all claims requests, particularly those for the month of production
- Activate/Deactivate all new Loan, Union and Thrift deductions
- Compute Payroll for the month of production:
- Update Payroll for the month of production to reflect new claims and changes
- Assess payroll for approval for the month of production
- Reviewing audit trail and history of activities
- Print Payroll Reports
- Print Payroll Graphs
- Print Audit Trail Reports
- Print activity history reports on request
C: Approval and Payment of Payroll
- Review Payroll Reports and Graphs
- Obtain approval of payroll reports from your Manager
- Pay the staff salaries based on the approval
- Mark the payroll as Paid on the TOM-S – Payroll Module
- Exit TOM-S
D: Start collating data for next month’s payroll.
In the manual process of producing payroll you must follow strictly a sequential (stage-by-stage) procedure. There is little flexibility to vary the procedure during production. Errors and mistakes, inevitable with the manual process, can be difficult to identify early in the process and cumbersome to rectify. For example, you must receive, validate and process all arrears, overtime and leave claims, all loan deductions, enter all new employee details, enter new details for promoted staff, process all the increments for all members of staff before you can begin to prepare (manually write) the vouchers for each employee. If you discover a mistake at the voucher preparation stage, rectification may impact on many of the manual calculations and computations you have made up to date.
TOM-S Payroll Administration simplifies the workflow and makes it very flexible. Most of the stages in payroll production can be done in any order and the errors are mistakes are minimised in production. This flexibility is made possible by the provision of an update payroll facility. You can create payroll “vouchers” early in the production process and update relevant vouchers for individual or groups of employees as and when new claims, personnel details changes, promotions and even new employee records are received and processed. You just need to ensure updates to payroll are made as one of the last processes you do before assessing payroll and printing of reports.
The stages of the workflow indicate the logical procedure and the functions taken over by the computerised system. The sequence may not necessarily be strictly followed. From the workflow chart and diagram in the subsequent pages, the Producing Payroll stages are computerised by the TOM-S – Payroll Administration. You can start the TOM-S – Payroll Administration (B1 in Producing Payroll) and immediately proceed to create payroll (B13) for the month based on standard payscale components and deductions. Then the stages A (Collating of Payroll Information) and stages B2 to B12 in Producing Payroll can be implemented at the convenience of the production staff following the most logical sequence. Subsequent changes are reflected in the payroll by updating payroll (B14) instead of creating payroll (B13). You will only need to create payroll when new employees are created in the system.
For example, you must have collated claims (A2) before registering the claims (B7); processing for approval (B11) can then be done. Thus, A2-B7-B11 is the logical sequence. To reflect these claims perform update payroll (B14). You can suspend the updating for now and a make all the required changes and new claims before updating. On completion of the updates, proceed from processing payroll (B15) downwards.
Reviewing audit trail and history of key activities can be done at any time during payroll production.
Starting TOM-S Payroll Administration
Starting TOM-S Payroll Administration
- Double Click on the TOM-S icon on your desktop or select TOM-S from on Programs menu.
- On the resulting interface (displayed above) select Payroll Administration from the Total Office Management Launch Menu.
- Log in with you username and password (mainuser, with no password if this is the first time). This starts Payroll Administration module and displays the interface shown below.
- Click Payroll Administration on the resulting interface. This displays the Payroll Administration interface depicted below
Note that all the operations you wish to perform can be accessed from the menu bar with the following menus
-
- General,
- Configure Payroll,
- Personnel Information,
- Claims and Deductions,
- Payroll Production
- Staff Auditing
- Search Engines
- Export Information and
- Info
Getting ready for payroll processing
You are now ready to use this module to prepare payroll. We will go directly into these processes assuming that you have procured TOM-S – Payroll Administration with some default data. The basic steps you follow are
- Enter New Personnel or Modify existing personnel records if required
- Specifying the month and year to process payroll.
- Register Arrears, Overtime and Leave Allowance Claims.
- Register Miscellaneous Claims/Deductions.
- Register Salary Prorating Requirements.
- Register Claims for groups of employees for the working period.
- Register & Activate Loan Deductions for employees
- Register & Activate Union Deductions for employees
- Register & Activate Thrift (Coop) Deductions for employees
- Register & Activate Fund/Investment Deductions for employees
- Assess all the registered claims/deductions
- Validate all the pending personnel details changes
- Affect Annual Increments for employees at anniversary of employment
- Compute payroll Or Update existing payroll .
- Review Payroll
- Assess Payroll
- Print Payroll reports
How to perform these procedures will be dealt with in subsequent chapters.
In the sequence of things, we should have configured TOM-S Payroll with operational data it will use to produce meaningful results. Data, such as payscales and related emoluments, geographical distribution of employees, tax formula, union and thrift societies you staff contribute, must already be available to perform payroll production. Finally, searching personnel and payroll history will treated followed by special operations.
Configuring TOM-S – Payroll Administration Module with Operational Data
The Personnel Information and Payroll sections of Operational Data Management And Configuration is used to configure TOM-S Payroll Administration with operational data, such as payscales, allowance types and remuneration and overtime rates thus tailoring to your specific environment.
TOM-S – Payroll Administration would have been supplied pre-configured with necessary default data, but some of the information may need to be modified as rules and regulations change. This section describes briefly the various necessary operational data and the procedures to configure the system with new data. The diagram below shows buttons indicating information that must be defined for operation.
- Click Operational Data Management And Configuration on the main interface Or Select Operational Data from the Configure Payroll menu. It displays the interface below.
- To configure TOM-S Payroll Administration you need General Information, Personnel Information and Payroll.
- Click General Information and enter the information indicated
- Click Personnel Information and enter the information indicated.
- Click Payroll and enter the information indicated
Sequence for configuring TOM-S – Payroll Administration with operational data
The sets of information required to configure TOM-S – Payroll Administration are related and as such some data must be defined before others. For example, you must define Departments before you specify the Sections under them. The following are the sequences that must be followed when configuring TOM-S – Payroll Module.
Group 1 Sequence: States Of Nigeria – Zones – Locations
Group 2 Sequence: Departments – Sections
Group 3 Sequence: Payscales – Grades and Step limits – Payscales
Group 4 Sequence: Banks – Bank Branches – Bank Account Details
Group 5 Sequence: All other data in any order
All groups are independent of each other
Staff Distribution in TOM-S – Payroll Administration
TOM-S – Payroll Administration assumes the following distribution of staff.
- Employees are distributed into Departments and Sections under each department.
- Employees are distributed into Locations under Zones.
- Employees are categorised into groups called Payscales, which defines the various payscales employed in you company.
- Each Payscale has its own Payscale Emoluments defined with corresponding Grades and Grade Level Steps.
Payscales Organisation in TOM-S – Payroll Administration
TOM-S – Payroll Administration supports payscales that capture a wide scope of payroll components based on standard pay structures in Nigeria. TOM-S – Payroll Administration also offers specification of different payscales for the various categories of workers you may support (eg HAPSS and HATISS payscales). The interface below defines the structure of the payscale supported.
Defining Payscales Emoluments
- Click Operational Data Management and Configuration on the main interface Or Select Operational Data from the Configure Payroll menu.
- Click “Payroll” on the operational data interface.
- Click “Payscales Emoluments” on the resulting form. This will display the appropriate form (above) for specifying Payscales information.
- The fields available on the form are Payscale, GradeLevel, Grade Level Step and the standard components of the payscale.
- To add details for a new grade and step, click the “Add” button.
- Enter Staff Category, GradeLevel, Grade Level Step and all the Annual Salary Component Values.
- Click the navigation button to move forward to save the information and clear the form ready for inputs for a new record. The monthly salary components will be computed on saving the information.
- To modify existing data for a grade and step, click “Modify” button.
- Use the navigation button to scroll through the records to the particular grade level and step for the specified staff category Or select the “Staff Category” and “Grade Level” from the respective buttons, then scroll to the desired step.
- Type in new data in the appropriate field(s). The information is saved once you move away from the record in view or click “Save” or close the form.
Domestic Servants Allowanaces
Another component of the payscale deals with domestic servants allowances due to certain category of staff. These are defined in a separate interface via clicking the “Domestic Servants” on the Payroll Operational Data form. In this form you specify the domestice servant entitlements for those grades that are entitled to domestice servants. The interface to do this is depicted below.
Note that all special allowances/deductions due to the domestic staff on the grade is due as an allowance to the beneficiary as is reflected in the inset. Also TOM-S, automatically adds leave allowance of the domestic staff to that of the beneficiary when the latter claims the leave allowance.
Extending Payscales
TOM-S Payroll Administration has got two powerful features.
- the ability to extend payscale components structure.
- the ability to define allowances and deductions personal to each employee.
The ability to extend payscale components is designed to capture any eventuality in the future to handle new allowances and deductions that may be introduced in your payscale structure.
The ability to extend allowances/deduction of the individual is designed for situations where some employees, by virtue of their schedules/appointments/postings, attract some allowances personal to them but not standard as part of payscale. TOM-S handles this effectively by allowing you to specify the allowances/deductions freely and assign emolument values to them.
TOM-S handles these functionality via
- Extended Salary Allowances for extending payscale on basis of grade/step of payscales.
- Special Allowances and Special Deductions for attaching allowances/deduction personal to the individual
Extending Payscale Components
In organisations such as academic institutions there are some allowances that are due to staff on various grades. For example, in academic institutions we have Excess Workload Allowances and Examination Supervision Allowances attached to the appropriate grades.
To implement this we simply specify these allowances and the appropriate emolument.
- Click Operational Data Management and Configuration on the main interface Or Select Operational Data from the Configure Payroll menu.
- Click Payroll.
- Click Extended Salary Components to display the interface below.
- Select the Payscale to extend
- Click Add and enter the names of the allowances (Excess Workload Allowances and Examination Supervision Allowances)
- Click Save, then Finish.
- Click Emoluments for Extended Salary Components at the base of the interface
- Select the Component, i.e. the new allowance.
- Click Prime for Component. This adds the annual and monthly allowance components with values of 0 to the payscale indicated beside the component. (You can Prime for All, to prime for all payscales if required)
- Repeat step 8 for all the new components you have created
For each New Salary Component
For each Grade and Step on the payscale,
- Click Modify
- Enter the annual amount in the text field labelled Annual Allowance. This would automatically compute the Monthly Allowance
Once you have completed this process, the allowance would automatically reflect on payroll of any staff on the grade/step on the payscale.
This process may be cumbersome, but you only need to do it once, or when payscale emoluments changes such as salary increases.
Special Allowances, Special Deductions and Monetised Allowances
Suppose your organisation introduces Computer Allowance as inducement for those in the Computer Department and Secretarial Allowances for secretaries attached to Ministers, Permanent secretaries and Director Generals. To implement this we create the allowance and then attach emoluments to them via Claims and Deductions prior to payroll production.
- Click Operational Data Management and Configuration on the main interface
- Click Payroll on the Operational Data Setup interface
- Click Names of Special Allowances to display the interface below.
- Click Add and enter the names of the allowances (Computer Allowance, Secretarial Allowance e.t.c.)
- Click Save, then Finish.
Any staff member that is entitled to these allowances will have it specified in the Payroll Production modules (Chapter 6). The specification is only done once and activated with the amount due. You simply deactivate it when the staff is no more entitled to it.
Follow same procedure for Special Deductions and Monetised Allowances
Personnel Data Entry and Modifications
Important Note: If you have procured the Personnel Information module, personnel data should be entered through the Personnel Information module. You will not be able to add new personnel details from through the Payroll Administration module. Only Payroll Allowance Details and Bank Account details of staff can be entered (as modifications) through the module. In this document we assume Payroll Administration is procured on its own.
- On the main interface, click Payroll Administration. This displays the Payroll Administration Interface.
- Click Personnel Information. To begin to enter and modify staff details.
To add details for a new employee
NB. Available only if Payroll Administration is procured without the Personnel Information modules.
- Click “Add” button.
- In each field, type in the appropriate entries for the new employee.
- The table on the next page indicates primary information that defines the employee.
- The information is grouped appropriately into pages identified by the tabs, namely Employment Information, Payroll Allowance Information and Bank Account Details
- To add photo of the employee click Insert Photo. This opens a dialog box from which you search your computers file system for the photograph of the employee
- Select the photograph file.
- Click Save so save the entry
- Click Finish to return the interface to original state
To modify details of an existing employee
- Click Personnel Information on the Payroll Administration interface.
- Select the employee whose detail you want to change from Employee combo box
- Click Modify.
- Click the appropriate tab such as Employment Information, Payroll Allowance Information and Bank Account Details.
- Enter new values in required field on the interface.
- Click Save to save the changes.
- If you have VALIDATE privileges the changes will be reflected immediately.
- Otherwise, they are logged as Pending Changes and the Validate Changes button will be activated.
- Click the Pending changes tab to reveal the list of changes requested for the employee (see interface below).
- Click Finish to return the interface to original state
NB: If Personnel information module is procured, then only Payroll Allowance Details and Bank Account details can be entered (as modifications) via the Payroll Administration module. The Pending Changes tabs will not be visible.
To Validate Pending Changes
If you have VALIDATE privileges you can assess these pending changes for approval/rejection and the affect the changes
- Click Pending Changes tab
- Notice that all the pending changes are tagged as Approved by default.
- If you want to reject any of the changes, double click on the record to toggle between Approved and Rejected.
- When you are satisfied with the validity of the changes, Click Validate Changes.
- All the Approved changes will be marked as Validated, and the changes will reflect on the employee’s details (Verify by clicking the appropriate table showing the respective detail).
This procedure ensures a proper audit of the changes made to employee details is available.
Special Cases: Affecting Promotions & Bank Account Details Changes and Retirement
In the case of affecting promotions, TOM-S – Payroll Administration provides a utility that unifies the process. It allows you to specify all the employee details that change for promotions, in one interface. This avoids having to specify each detail change (5 details) individually, thereby avoiding omission or errors.
- Click Personnel On Payroll (Full Details) on the Payroll Administration interface.
- Select the employee whose promotion you want to affect
- Click Pending Changes tab
- Click Affect Promotions on the on the tab.
- Specify the following: Promotion Date, New Staff Category, New Grade, New Step and New Designation as required
- Click Affect Promotion to log the related requests in the pending changes request log.
- Close the interface and you will see that the related details changes are logged as pending changes which can be assessed and validated as described in earlier procedures.
- Follow the same process for bank account changes: Click Change Account Details in Step 4.
- Follow the same process for bank account changes: Click Affect Retirement in Step 4.
View history of changes made to employee’s details
- Click Change History on the Pending Changes tab. This displays the interface below showing the list of all changes made to the details of the employee on the Full Details Change History tab.
- To see pending changes for the employee, click Pending Details Changes tab.
- To see the photograph history for the employee, click Photograph History tab.
- To see the history of changes for each detail (emolument), click Change History By Detail
Note that you can Register Claims And Deductions and view Payroll History of each employees via appropriately labelled tabs
Preparing Payroll Information
You are now ready to begin collating information to prepare payroll. The information to collate include arrears, overtime and leave claims as well as loan, thrifts and union deductions.
- Click Payroll Production on the Payroll Administration interface Or Select Payroll Production from the Payroll Production menu.
Notice that you have several tabs on the form each labelled according to the functions provided.
- Compute Payroll tab (top level) with a button Process Payroll.
- Claims And Deductions tab through which you register and process claims (leave, overtime arrears, loan deductions, special allowances, special deductions etc).
- Charts and Graphs tab to print payroll reports and charts.
- Statistics tab to monitor payroll progress.
- Special Operations tab, to Close Payroll Computations, process Unclaimed Wages Affect Annual Increments.
- Cheque Payments to enter cheque numbers to payroll if each member of staff is issued a cheque directly for payment of salaries.
- Payroll History tab, through which you monitor the history of payroll computations.
Specifying the year and month to process payroll
Before you start processing payroll, you must specify the year and month you are processing for.
- Click the button Click To Specify Month and Year.
- On the resulting form enter the month and year for which to produce payroll.
- Click the button labelled Set.
Subsequent operations will be based on this new month and year until it is changed either in the way described above or when new salary schedules are created.
Affect Annual Increments
It is standard practice in the Nigerian Civil Service to affect salary step increments to employees on the anniversary of employment/appointment until he/she has reached the bar of the grade.
- Click Payroll Production on the Payroll Administration interface.
- Click Special Operations tab
- Click Affect Annual Increments on the tab page
- Click Yes in response to the message prompt
On completion, the increments should be reflected on the current step of the employee.
Processing Payroll Payroll
If at this point you have no extra information to enter you can proceed to processing payroll by clicking Process, Review and Assess Payroll on the Compute Payroll tab. The interface below is displayed.
However, in real situations you will usually have leave claims, overtime claims, arrears claims and other type of claims and deductions (loans, thrift etc) that are incorporated into payroll. So we must affect these before finally calculating payroll.
Claims and Deductions
- Click Payroll Production on the Payroll Administration interface Or Select Payroll Production from the Payroll Production menu.
- Click Claims And Deductions tab. This displays the variety of claims and deductions that you can specify for each employee.
Leave Allowance Claims
- Click “Claims And Deductions” tab.
- Click “Overtime, Arrears, Leave etc” button.
- Click Leave Allowance tab to give Payroll Claims Registration interface (below)
- Move/Select the employee who has to be paid the leave allowance
- Click “Add” and
- Click Ind check box. The leave allowance amount will be displayed for the claim month and year specified.
- Enter the Amount (if the allowance amount you want to pay is different)
- Enter Month and Year to pay the allowance if different from the default (NB you can specify in advance).
- Click “Save” to save the information
- Return to 4) to enter another leave allowance claim for another employee
- Click Exit to remove the interface from focus.
The same procedure is followed to register other claims such as overtime, arrears, other allowances and deductions, monetised allowances, salary prorating and special cases of promotion and increment arrears.
Other Allowances and Deductions
Other Allowance Claims and Deductions registration and processing is the mechanism by which TOM-S Payroll Administration introduces non-standard emoluments and deductions into payroll.
Examples are affecting bonuses and refunds to members of staff or deducting some amount from the payroll for a specific (one-off for example) purpose.
- Click “Claims And Deductions” tab.
- Click Other Allowances and Deductions tab.
- Select the employee who has to be paid arrears
- Click “Add” and
- Select Type of allowance/deduction.
- Enter the Amount
- Enter Month and Year to pay/deduct the amount if different from the default (NB you can specify in advance).
- Click “Save” to save the information
- Return to 4) to enter another allowance/deduction for the employee
- Return to 3) to enter allowance/deduction for another employee
- Click Exit to remove the interface from focus.
This facility provides TOM-S Payroll Administration with a very powerful and flexible means for handling various scenarios in payroll processing.
Assessing Claims/Deductions for Approval/Rejection
After entering claims and deductions, your superior must assess them for approval/rejection. He/she must have VALIDATE permissions for payroll module.
Each claim/deduction type has its own assessment interface and procedure is simple, as follows:
- Click Process Claims and Deductions for Approval/Rejection on the Claims And deductions tab on Payroll Production interface.
- Click the button indicating the type of claim you want to assess.
- Select the claim to process.
- Click Approve or Reject as required.
A typical situation for leave allowance claims processing is displayed below.
Tip. Since it is unlikely that most of the claims you register will be wrong or rejected, a quick way to process will be to Approve All the claims and then begin to Reject the claims that are unacceptable.
Union, Thrift & Funds Deductions
- Click “Claims And Deductions” tab.
- Click “Union, Thrift And Investments” to give Union, Thrift and Investments interface (below).
- Click Union Deductions Register tab.
- Move/Select the employee whose contribution you want to register.
- Click “Add”.
- Select the Union.
- Enter the Amount or % of Basic Salary to contribute.
- Click Activate to activate the monthly deduction of the contribution
You must be a user with VALIDATE privileges to Activate a contribution, so inform appropriate user to activate the contribution.
- Click “Save” to save the information
- Return to 5) to enter the contribution to another union for the employee
- Return to 4) to enter union contributions for another employee
- Click Exit to close the interface.
The same procedure is followed for cooperatives (thrift) societies and investment funds contributions. Pension Contribution profile is where you personalised pension formulae for each employee.
Special Allowances and Special Deductions
- Click “Claims And Deductions” tab.
- Click “Special Allowances and Special Deductions” to give the interface (below).
- Click Special Allowances Register (or the Special Deductions Register) tab.
- Move/Select the employee whose allowance (or deduction) you want to register.
- Click “Add”.
- Select the Allowance Name.
- Enter the Amount or % of Basic Salary to contribute.
- Click Activate to activate the monthly deduction of the contribution
You must be a user with VALIDATE privileges to Activate a contribution, so inform appropriate user to activate the contribution.
- Click “Save” to save the information
- Return to 5) to register another allowance for the employee
- Return to 4) to enter register allowance for another employee
- Click Exit to close the interface.
Loans Advanced
It is customary to provide your staff with loan packages as part of the welfare packages in your organisation. Loans such as salary advance and car refurbishment loans are customary. Loan records, including repayment policy on the loans, are recorded in TOM-S in the same manner as leave allowance and overtime claims were recorded.
- Click “Claims And Deductions” tab on the Payroll Production interface
- Click “Loans Advanced” to give Union, Thrift and Investments interface (below).
- Move/Select the employee whose contribution you want to register.
- Click “Add”.
- Select the Type of loan (e.g. Salary Advance, Motor Vehicle etc).
- Enter the loan details
- Principal amount of the loan
- Date procured
- Months To Pay.
- Interest Rate
- Month To Start payment
- Year to Start payment
- Month To End payment
- Year to End payment
- Monthly Repayment amount
- Total To Pay
- Click Activate to activate the monthly deduction of the loan from payroll.
You must be a user with VALIDATE privileges to Activate repayment
- Click “Save” to save the information
- Return to 4) to enter another loan for the employee
- Return to 3) to enter a loan for another employee
- Click Exit to close the interface.
You can also log loans whose repayments would start in the future.
Bulk (Group) Claims/Deduction Registration And Processing
As mentioned in a previous chapter there are situations where claims and deductions are uniform for all or a group of employees. In such cases it will be inconvenient to register the information individually for each employee. Bulk processing of claims and deductions is therefore useful. This in provided through the button “Group Variations”.
- Click “Claims And Deductions” tab on the Payroll Production interface
- Click “Group Claims And deductions” on the Claims And Deductions tab
- Select the required emolument type in the option group labelled Emolument Type.
- Select the grouping of employees to affect from the option group labelled Employee Group.
- Select the corresponding group of employees to affect.
- Specify details of the claim/deduction in the activated text boxes and option buttons
- Click Enter Claims when you have specified the claim/deduction.
- Click Process Claims to process the claims as in 5.4.3.
Prepare Payroll for the Month
You have now finished collating all claims and deductions and have assessed them for approval to be incorporated in the payroll for this month. You now have to prepare the payroll for the month.
Processing Payroll
- Click “Payroll Production” in the Payroll Administration interface Or Select Payroll Production from the Payroll Production menu.
- Click Process, Review and Assess Payroll on the Compute Payroll tab to display the Process Payroll form below.
- Enter the month and year (if you require a different one). This would become the month and year on which subsequent payroll operations would be based.
- Select from the appropriately labelled combo box, the group of employees for which to produce payroll for the specified month: You have the choice of producing payroll for
- All Employees
- By Location
- By Zone
- By Bank
- You can extend the criteria by clicking Extend Criteria tab to specify for
- an individual employee
- all employees on a payscale
- all employees in a department
- all employees in a section
- Click COMPUTE Payroll
- On completion (this may take some time), click Yes on the prompt to review the full details of the payroll computations for each employee.
- You can review and print the payroll immediately if no additional information need to be included in the payroll.
You must UPDATE payroll after the first computation so that new/modified claims and deductions or changes to employee can be included in payroll simply by updating the existing computations.
Updating Existing Payroll
If after preparing payroll for a month you may have new claims and deductions to incorporate or a new employee is introduced or changes are made to employees details, you must reflect these in the current payroll. In this case you Update the payroll to reflect these new information.
- Repeat Step 5 above
- Click UPDATE Payroll in step 6
- On completion, click Yes on the prompt to review the full details of the payroll computations for each employee.
- You can review and print the payroll immediately if no additional information need to be included in the payroll.
Review payroll would show the new claims and changes to employee emoluments are reflected.
It is recommended that updating payroll for all employees is performed as the final step prior to printing the payroll for the working period. This would ensure consistency of payroll with current claims, deductions and changes to payroll information.
Reviewing Payroll
You are usually given the choice to review the payroll computations after computation of payroll completes. Alternatively, the review can be done independently of these procedures, provided data exists for the month/year specified. To do this
- Click “Review Payroll” on the Process Payroll form. This would display a form showing the full details of the components of the payroll for each employee (see below).
- Use the navigation buttons to scroll through to view the details for other employees or alternatively, select the employee’s details you want to view from the combo box labelled “Employee”
From this interface, you can assess the payroll for employees individually
- Click Approve to affect interim approval of the particular employee payroll in focus
- Click Approve for Payment to approve the payroll of that employee for payment
Assessing Payroll
When you complete computing payroll, your superiors or auditors are expected to check your computations and approve or reject the payroll schedules you have prepared. This function is handled by the Assess Payroll facilities.
Interim Approval
To affect interim approval of payroll and temporarily prevent updates.
- Click “Assess Payroll” on the Process Payroll form.
- Enter the year and the month to assess payroll (if different from the default displayed).
- Select the group of employees for which to assess payroll.
- Click the button labelled “Interim Approval of Payroll”.
To reject payroll of selected employees
- Click “Reject/Open Approved Payroll” to reject the payroll for the selected group of employees.
Approval for Payment
After interim approval and you are ready to pay, you must approve the prepared payroll for payment.
- Select the group of employees.
- Click “Approve Payroll for Payment”
- You will be prompted accordingly on completion of each function
- Respond by clicking Yes or No as desired.
Effects of Payroll Assessment
The overall aim of payroll assessment is to ensure integrity of payroll information. Payroll calculations that have been marked as Approved cannot be updated with new information such as new claims/deductions and changes to employee details. They can however be rejected/opened to allow updates in employee information to be reflected.
Payroll calculations that have been marked as Approved For Payment cannot be updated with new information and cannot be rejected, since the salaries would by then have been paid.
We however provide a function Re-Open Payroll Approved For Payment with the means of re-opening Approved For Payment schedules to allow updates, should it be necessary. Only users with SPECIAL OPERATIONS privileges are allowed to do this. This function will only be available to a high ranking officer in your institution to prevent undue violation of the integrity of payroll data.
Monitoring Progress of Payroll: Payroll Production Status
At any point in time during processing you can assess the status of payroll production for the current month. This provides you with a guide to payroll progress by presenting statistics in a unified manner.
- Click Statistics tab on the Payroll Production interface
- Click Payroll Production Status on the tab. This will display the production statistics interface below.
- You can view all information on payroll you have been producing, including statistics of all claims and deductions.
.
Reports and Charts
To print payroll reports
- Click “Payroll Production” in the Payroll Administration interface.
- Click Payroll Reports The interface below is displayed.
- Select the Report Category, either
- Payroll Not Approved for Payment (default)
- Payroll Approved for Payment
- Claimed Payroll.
- Select a report to print/preview.
- Enter the year and month of the period you want to print.
- Select the group of employees for which the report will be printed (All Employees is default)
- Click Preview to preview the report Or click Print to print the report on the printer.
The following table lists the reports available as standard with TOM-S. Customised reports can be designed based on your specifications.
ReportDesc |
Arrears Claims History |
Comprehensive Papslip Grouped By Location |
Comprehensive Payslip Grouped By Zone |
Coop Contributions History |
Coop Contributions to all Cooperatives |
Employees Emolument Change History |
Employees Salary History |
Employees Salary Prorating History |
End of Year Summary for Earnings |
End of Year Summary of Allowances |
End of Year Summary of Gross Pay |
Fund Contributions History |
Fund Contributions to all Unions |
Leave Allowance Claims History |
Loan Repayments History |
Miscellaneous Claims History |
Monthly Totals of Tax, NHF, Thrift and Union Deductions |
NHF Deductions |
NHF Deductions grouped by Department |
NHF Deductions grouped by Location |
NHF Deductions grouped by Zone |
Overtime Claims History |
Payment Schedules to Banks |
Payroll Summary |
Payroll Summary grouped by Department |
Payroll Summary grouped by Location |
Payroll Summary grouped by Zone |
Staff List |
Staff List Grouped By Department, Sevtion and Location |
Staff List Grouped by Grade Level |
Summary of Payroll Schedules (LAC Format) |
Tax Deduction History |
Tax Deductions |
Tax Deductions grouped by Department |
Tax Deductions grouped by Location |
Tax Deductions grouped by Zone |
Tax Deduction History Grouped by Employees, Location, Zone & Year |
Totals of Payroll Summary grouped by Department |
Totals of Payroll Summary grouped by Location |
Totals of Payroll Summary grouped by Zone |
Union Contributions History |
Union Contributions to all Unions |
Graphs and Charts
Bar charts, PIE charts and plots can be produce to give a graphical picture of payroll trends over the year and distribution within employee groups such as departments and sections. Charts and plots are based on payroll that has been approved for payment.
For PIE Charts
- Click “Payroll Reports And Charts” tab in the Payroll Administration interface.
- Click Graphs and Charts. This displays Payroll Charts and Plots interface.
- Select the type of graphical output you want (PIE Charts, Bar Charts and Plots).
- Click PIE Chart. This will display an option group PIE Chart Distribution.
- Enter the year and month for which you want to see the distribution
- Select the PIE Chart Distribution for the PIE chart.
- Click Preview to preview the graphs Or Print to print the graph.
For Bar charts and Plots
- Click “Payroll Reports And Charts” in the Payroll Administration interface.
- Click Graphs and Charts. This displays Payroll Charts and Plots interface.
- Click Bar Chart. This displays an option group Plot/Bar chart group.
- Select the year for which you want to see the trend
- Select the employee group for which to plot the Bar chart trend
- Click Preview to preview the graphs Or Print to print the graph.
Special Payroll Operations
Special Payroll Operations are functions that can only be performed by users with SPECIAL OPERATIONS privileges, which would typically be Directors and Departmental Heads. Those functions are
- Closing Payroll Computations
- Processing Unclaimed Wages
Closing Payroll Computations
The Close Payroll Computations function provides a lock to payroll of the specified month. When closed for a particular month, you will not be able to compute payroll for that month. This protects the overall integrity of information by preventing the creation of payroll after you have completed all activities for that month.
- Click Special Operations tab on the Payroll Production interface
- Click Close Payroll Computations on the Assess Payroll interface.
- Specify the Month and the Year to close.
- Click Close Payroll.
- You can reverse the operation via Open Payroll.
Also, this function will only be available to a high ranking officer in your institution to prevent undue violation of the integrity of payroll data.
Re-opening Payroll Approved for Payment
Payroll calculations that have been marked as Aproved cannot be updated with new information. They can however be rejected/opened to allow updates in employee information to be reflected. Payroll calculations that have been marked as Approved For Payment cannot be updated with new information and cannot be rejected, since the salaries would by then have been paid.
We however provide a function Re-Open Payroll Approved For Payment with the means of re-opening Approved For Payment schedules to allow updates, should it be necessary. Only users with SPECIAL OPERATIONS privileges are allowed to do this. This function will only be available to a high ranking officer in your institution to prevent undue violation of the integrity of payroll data.
- Click Assess Payroll on Payroll Production interface
- Enter the year and the month to assess payroll (if different).
- Select the group of employees for which to assess payroll.
- Click Re-Open Payroll Approved for Payment on the Assess Payroll interface.
Remember to re-assess the payroll when completed . This procedure will not work if payroll of the month has been closed.
Unclaimed Wages
TOM-S – Payroll Administration provides the facility to manage unclaimed wages. It simply marks the respective payroll vouchers as unclaimed.
- Click Special Operations tab on the Payroll Production interface
- Click Process Unclaimed Wages, to display the interface below.
- Specify the year and the month.
- Select the Employee whose wage is unclaimed
- Click Set As Unclaimed Wage (To Reverse Reset as Claimed Wage).
- To view the list of unclaimed wages, click View Unclaimed Wages List.
Searching Personnel and Payroll Records
Searching Personnel Records
This module is the search engine you use to search through the database of employee records.
- Click Personnel On Payroll (List) button on the Personnel Administration interface to display the Personnel Search interface.
- Click Search on the bottom right hand corner of the Personnel List interface.
- Specify the search criteria in appropriate text boxes on the Basic Search tab. (enter * in the SurName text box to obtain all employees in the database).
- To extend search criteria click Extend Search tab, and specify your criteria
- Click “Search” to query the database. The resulting records will be displayed on the list labelled Search Results and the number of records displayed as a prompt (and on a text box above the list).
- To obtain the full details of a particular employee on the list, Double–click on the record.
- Click Display List to display the employees based on the search criteria in steps 3 and 4. You have the choice to display the list or full details of the employees.
- Click Preview/Print to preview a report on the list of employees the meet the search criteria.
Searching Payroll Records
TOM-S – Payroll Administration provides a flexible search engine to perform general search on existing payroll information in the database.
- Click “Payroll History and Search ” on the Payroll Administration interface.
- Click “Payroll History Search” on the resulting interface to invoke the interface below
- Specify the search criteria in the text boxes on the Basic Payroll Search tab
- To extend search criteria, Click Extend Payroll Search tab and make specifications
- Click “Search”. This displays the results of the search on the list labelled Search Results.
- Click “Display Details” to display full details of the search
- Click Preview Or Print to preview or print the results of the search.
This search engine facility is a powerful tool designed to offer extensive querying options to assess and analyse payroll production progress and history.
Payroll History
When operating TOM-S – Payroll Module, the system keeps a history of the key payroll production computations. The Payroll History and Search function of TOM-S – Payroll Administration provides the means for viewing the history of the payroll production for all employees: TOM-S – Payroll Administration provides the history of the following, for each employee,:
- Salary history
- Arrears and Overtime claims history
- Leave Allowance claims history
- Other Allowance And Deductions history
- Salary Prorating history
- Thrift, Union and Funds Deductions history
- Loan Deductions history
- Personnel Details Changes history
- Click “Payroll History” tab on the Payroll Production interface Or Select Payroll History from the Payroll Production menu.
- Click the preferred activity whose history you want to view. The options are as follows.
- Payroll History Search
- Claims And Deductions History
- Salary and Details Change History
- Loans Repayment History
- As an example, click Claims And Deductions History in 2) to display the form below.
- Scroll through the list of employees or select the employee from the combo box labelled “Employee”.
- Click the tab indicating the particular claim or deduction history you want to view. The choices are
- Arrears
- Overtime
- Leave
- Special Allowances
- Other Claims And Deductions
- Thrift Deductions
- Union Deductions
- Fund and Investments Deductions
- Special Deductions
- Loan Repayments
- Follow the same procedure for other claims/deductions.
In Step 3, click Salary and Details Change History to produce interface below
To Print or Preview the history of the activity in report form:
- Click Print/Preview on the interface showing the history
- Select the required report from the combo box labelled “Report”
- Enter the period over which to print the history
- Click Preview to preview the report on the screen Or Print to print the report on the attached/specified printer.
Appendix
Tax Computation Process
Nett Pay Computations
Nett Pay = Gross Pay – Total Deductions
Where
Gross Pay = Total Earnings + Total Allowances
Total Earnings = Basic Salary + Basic Arrears + Transport Arrears + Rent Arrears + Other Arrears + Acting Allowance + Overtime Allowance + Other Earnings
Total Allowances = Housing Allowance + Transport Allowance + Meal Allowance + Utility Allowance + Dress Allowance + Entertainment Allowance + Quarters Maintenance Allowance + Education Allowance + Extended Salary Allowances + Gift Allowance + Robe Allowance + Leave Allowance + EmpProvPension Allowance + Other Allowance + Bonus + DomesticAllowance + Special Allowances + Monetised allowances
Total Deductions = Tax Deduction + NHF Deduction + Staff Bus Deduction + Loan Deduction + Union Deduction + Thrift Deduction + Fund Deduction + Other Deduction + Special Deductions
Note: The components of salary are those supported by the standard TOM-S – Payroll Module. Customisation to meet your needs may add new components or suspend existing components.
Tax Computation
The following is the basic procedure employed to compute the tax paid on salary.
- Extract and sum the taxable amount from all the standard allowances on the payscale, if the allowance is above the tax-free limit.
Taxable Standard Allowance = (Limit – Standard allowance)for all standard allowance
Taxable Pay = Basic Salary + Taxable Standard Allowance
- Tax is computed on the Taxable Pay using the Tax Fomula define in the Application Setup.
Tax computation meets the Inland Revenue standard for the Civil Service Pay Structure and has been tested for validity and accuracy.
Provision to tax all other allowances and extend tax equation is available in TOM-S – Payroll Administration.