HR company that provides Professional Employer Organizations (PEO) services, Administrative Services Organizations (ASO) services and Payroll services. HR company that provides Professional Employer Organizations (PEO) services, Administrative Services Organizations (ASO) services, and Payroll services.
Client processes payroll for multi-location franchises bi-weekly. Each franchise location sends multiple reports (PDF) from their ERP system and Client manually tallies hours, tips, and other data; performs an overtime allocation; and then applies custom (each franchise uses different rules and bonuses) payroll rules for commissions and bonuses to determine each employee’s pay.
Because of the unusual report structures, the level of detail required (employees can work in multiple locations with multiple pay types), the complexity of the rules, and the almost completely manual process, this effort inherently creates payroll errors and takes multiple man-days to complete every other week. Sometimes payroll is late. Also, because of the complexity, some franchises may not comply with state payroll laws.
The franchises are not happy with the results and threaten to replace Client.
Clear Data Incorporated created an Excel/VBA-based system that processes Excel and CSV versions of the reports (unusal layouts make these difficult for people to read and use) quickly and accurately, calculates a complex (multi-role/rate, multi-location) proportional overtime allocation, applies the various custom rules for each franchise, produces a CSV file for import into Client’s Payroll system, and provides administration forms and tables to maintain employee data.