Sage MicrOpay Timesheet Integration
This article is designed to assist providers in setting up Staff Timesheet integration for the Sage MicrOpay payroll system.
Prerequisites
- Payroll Integration Strategy
- Payroll Configuration (specifically configuring the Payroll System Identifier)
Timesheet Export Mapping for Sage MicrOpay
SupportAbility can export (non-award interpreted) timesheet data in a format that can then be imported into Sage MicrOpay.
The following table explains how SupportAbility formats Timesheet data when exporting Timesheet Batches specifically for Sage MicrOpay:
| Characters | Sage MicrOPay Field | SupportAbility Data | Example |
| 1-8 | Emp number | Staff Member's 'Payroll System Identifier' as entered on the Human Resources tab of the Staff Member's record (padded to 8 characters in length with leading zeros) | 00041548 |
| 9-13 | Year | 4 digit Year of Staff shift Start/Stop date (YYYY format) | 2019 |
| 14-15 | Month | 2 digit Month of Staff shift Start/Stop date (MM format) | 01 |
| 16-17 | Day of Month | 2 digit Day of Month of Staff shift Start/Stop date (DD format) | 30 |
| 18-21 | Time | Staff shift Start/Stop time (HHMM format) | 0405 |
| 22 | Direction | I = Start Time O = Stop Time |
I |
SupportAbility exports a pair of (2) rows in the Sage MicrOpay Timesheet Batch Export file for each Timesheet exported. The first row (ending in an 'I') denotes the shift Start date/time, whilst the second row (ending in an 'O') denotes the shift End date/time.
For example, the paired export rows for a timesheet may look as follows:
00000123201905091345I
00000123201905091815O
This would indicate a staff shift with the following information:
- This shift was related to the Staff Member with the Payroll System Identifier of '123'
- The shift start date/time was 09/05/2019 at 1:45 pm
- The shift stop date/time was 09/05/2019 at 6:15 pm
Limitations of this Sage MicrOpay Timesheet Integration
SupportAbility and Sage MicrOpay have identified the following limitations with integration between the two systems.
Limited Data Transmission
This export only allows the following information to be sent to Sage MicrOpay:
- Staff Member Identifier
- Shift start date/time
- Shift stop date/time
Sage MicrOpay does not allow for additional timesheet details to be passed through such as Site, Service, Job Codes, etc...