This app is a Google Sheets extension, designed to assist you with importing timesheets from Shiftcare into Paycat/Keypay. The main features are:
Automatic Reformatting: Shiftcare columns will be reformatted and renamed to be Keypay appropriate.
- ID Validation: Employee, worktype and location ids will be checked against the data in your Keypay file, and missing IDs will be flagged to you. 
- Timesheet Validation: Any timesheets with other validation issues (such as overlaps) will be flagged to you.
- Integration: After reviewing any flagged timesheets, this tool can then be used to import timesheets directly into Keypay without the need for a spreadsheet import.