Successful businesses achieve management excellence in marketing, sales, manufacturing, operations, services and finance. However, as it is invariably people that provide companies with their most tangible competitive edge, human resources assumes increasing importance. 

“Today, companies that achieve excellence in human resource management are more likely to out-perform others,” says Softline Pastel Payroll MD Stephen Corrigan.
“As payroll is a critical function of HR we developed a value-adding business intelligence module that integrates with our payroll software to bolster a company’s competitive edge.”
Known as the Business Intelligence (BI) Payroll: Excel Reporting module, the software functions with Microsoft Excel to provide more than 20 different standard report formats and templates as well as a facility that allows users to create their own report formats.
Corrigan says typical users of the Excel Reporting software would be management, supervisors and team leaders.
“Data for each report can be extracted directly from Pastel Payroll into Excel and presented with automatically generated, easy-to-interpret graphic illustrations such as bar charts, line graphs and pie charts.”
Among the various standard reports relating to individual employees, are detailed summaries of job costing and leave records, gross pay versus net pay, average gross annual income, date of last increase (including details such as the previous salary or wage, new salary or wage and percentage increase) and the dates of leave last taken and leave still owing.
There is also an Equity report that meets the requirements of the Department of Labour, displaying race, gender, age, disability and other individual details by specific occupational category.
“Each report can then be sliced and diced according to the unique requirements of the business using the drag-and-drop functionality of the MS Excel pivot tables,” adds Corrigan.
An example of this is the Job Costing Report which provides accurate statistics on salaries or wages per department, cost centre, or branch in order to measure the profitability of these business units or of the entire operation. It also allows sales team leaders to compare the achievements of their teams within overall sales or by brand.
A Leave Report displays leave days per department or cost centre and per employee. It is easy to identify a department where little or no leave has been taken for the period under review.
The business can then act to ensure that leave is not carried over and that the timing of leave is such that the department does not become short-staffed because too many employees have put in for leave within similar time frames.
A Rate Report displays hourly rates, overtime rates and monthly rates for all employees in the company or by department or cost centre. It simplifies the ongoing monitoring of company compliance with the Basic Conditions of Employment Act.
A Years of Service Report lists all employees by date of employment and provides years and months of service and current salary. This will simplify the planning of long service awards, increase dates and increases in annual leave entitlements.
“Overall, the Excel Reporting functionality revolutionises the way a company is able to make decisions. It brings important employee information into the equation ensuring that attention is also paid to the human element in or impact on, any operational, sales or marketing decision the business is about to make,” says Corrigan.
“The program retains the unique report formats and makes them available for ongoing use. Users can at any time customise the standard set of reports and templates or create new ones. It also offers flexibility in the combinations of payroll data the company or individual managers or supervisors elect to report on.”
Pastel Payroll has also established a Web-based “report download community” for all registered users of the Excel Reporting module. It will display any new reports that are created by Pastel Payroll and these can then be downloaded at no charge. It will also offer suggested enhancements or modifications to reports.
Other new value-adding modules recently introduced by Pastel Payroll provide users with secure bulk-E-mailing of payslips and the automation of returns to major Industrial Councils.
The bulk E-mailing module allows companies to e-mail payslips in groups to a nominated individual for distribution to staff and can be allocated per cost centre, per department or per pay point, whichever best suits company administration.
The Industrial Councils module automates and streamlines processing of transactions and returns that companies have to submit to Industrial Councils such as MIBFA, MIBCO and many more.