When you've completed your payroll reconciliation, you can export timesheets ready to be imported to Sage.

Load Payroll View

Select Date Range

Click on first day of pay period

Then click on last day of pay period

All timesheet data for this period will load in the view

Export timesheets

There are multiple export options available depending on your needs.

You will have multiple options on what to include in your export but for Sage import you only need to choose “Total Pay Hours” And “Include Holiday Hours”

This will download the file ready for import. Save this somewhere convenient on your local work station.

NOTE: Before importing to Sage please ensure the import file is closed.

Open your sage payroll application.

Click File -> Advanced Data Import

Click Next

Choose last option “Timesheet Payments”

Locate the file you exported from Gig Grafter.

This is where you match the columns in our csv (below) to the corresponding pay references in Sage.

This is the trickiest part but once done you can then save this mapping map. Sage saves the map as a .MAP file in it's default template location.

This map should load by default on the next pay run.

Click on Import to complete.

Check values are correct.

NOTE: sometimes sage does not pick up the file header row from a csv. If this happens simply open our file and save as an .xlsx file instead and repeat the import steps.