Sage MicrOpay

The system supports exporting timesheet information as a Sage MicrOpay file which can be exported from VTEvents, and imported into Sage MicrOpay for payroll.

This includes the following information;

  • Timesheets (both for rostering allocations, as well as any admin-hours setup to go through to payroll)

  • Allowances

  • Expenses

To import timesheets, Sage MicrOpay requires a base pay-rate which hours are applied against, as well as any variants of that rate as additional lines in the data-file.

The base-pay rate is worked out on a per-person basis (so each person can have a rate set for themselves). If no rate is set, the rate setup for the group a person is allocated-to, will be used instead.

From there, hours are associated with the different relevant rates (eg. the base-rate, any weekend rates which might be setup, public holiday rates, etc), added together (so 1 line for each rate will appear in the timesheet)

A simplified version of what is exported is;

Person

Pay-rate-code

Number of hours worked

Person

Pay-rate-code

Number of hours worked

Jane Smith

(base-rate - not shown)

23

Jane Smith

WEEKEND-RATE

5

Kate Jones

(base-rate - not shown)

2.53