SAGE Payroll - Web Application

We are a recruitment agency. We supply temporary workers to our clients. This project is to develop a PHP/mySQL web based application to integrate into our existing simple html web site. The application will interface with SAGE PAYROLL (current version V14.01.027) and will allow our clients to submit their weekly timesheets electronically. Weekly timesheets contain the names, payroll numbers and the hours worked, per day, for every worker supplied. Currently we are sending timesheets as simple spreadsheets, to each client once per week. These timesheets are completed by the clients and are used to ensure we invoice the clients for the correct number of hours and we pay the workers the correct hours, including any hours at overtime rates. We manually pre-populate the timesheets with the names and payroll numbers of each worker supplied. Clients enter the number of hours worked for each worker. (See basic example attached) and return completed timesheets back to us by fax or e-mail. We enter the hours manually into SAGE PAYROLL and would like to make this process much more efficient. Ideally we would like the ability to generate 'timesheets' electronically from within SAGE PAYROLL. If this is not possible we can continue to produce spreadsheets manually. We envisage that Clients will log into a secure area on our web site where they will be able to access and complete their 'current week' timesheet. This could be done by downloading the spreadsheet, completing it and re-uploading it, or better still, by completing and submitting the timesheet online via a web browser. Once submitted we require the functionality to import the data directly into SAGE PAYROLL. In their own 'secure area' clients will also be able to view an archive of their previously submitted timesheets. If you have any questions please ask. Many thanks. Steve