When you need this
You import JC timesheets into Greentree from a file, and SprintSuite builds that file from a pay run.
Before you start
Greentree is connected, with the Company code set. It's used in the file name.
Enable CSV timesheet export is on under Greentree â General.
Staff are linked to a Greentree employee with an Emp Code, and aren't marked Do not link.
Pay Types and the trade and shift type combinations are set up so the Activity column resolves. See Set up Pay Types / Combinations / Automatch so CSV Activity resolves.
Jobs on these timesheets have Field / rostered set where combinations need it.
Your role has the Greentree timesheet push permission under Staff Times. Read lets you download files. Read & Write lets you run exports.
Steps
Go to Staff Times â Pay Runs.
On the pay run, click Export GreenTree CSV.
Choose Export New (only lines not exported before) or Export All. Optionally pick a Pay group to export only staff in that group.
Confirm.
If some lines can't resolve an Activity code, the These lines could not be exported panel opens. It lists each line and the reason. Click Fix to open the job or the Trade and shift type mapping tab in a new tab, then export again. Or click Export anyway to export those lines with a blank Activity.
Download the file from the Background Jobs tray.
Import it in Greentree.
Who's included
The file includes timesheet entries that started within the pay run dates, are manager-approved, are productive staff time, and belong to linked staff. It doesn't include asset timesheets, non-producing time, or unapproved or voided entries.
The file columns
Column | Contains |
Type | Always JC |
Emp Code | The linked Greentree employee code |
PayCode | From the Pay Types mapping |
Date | Entry start date, dd/mm/yyyy |
NetQty | Hours, as calculated in SprintSuite |
Narration | The SprintSuite timesheet entry ID |
Classification | Blank |
AccountJob | The job |
Activity | The resolved activity code, or blank if exported anyway |
Wcentre | Always blank. The column is there for the Greentree import layout. |
Dateto, Start, Finish | Blank |
Rate | Blank, unless Include allowance rates in CSV is on under General. Then allowance rows show their rate, and hours rows stay blank. |
Allowances are added as extra rows, with the PayCode and Activity from Pay Types â Allowances.
How Activity is chosen
If the shift type has an activity code on Pay Types, that code is used.
Otherwise it's built from the trade letter, the shift type letter and the job's Field / rostered setting, then matched to your Greentree activity codes.
The CSV never falls back to a default activity code, or to the job's JCActivity field.
What success looks like
The Background Jobs tray finishes and the file downloads.
GreenTree Export Status on the pay run shows Exported (N/M). N/M counts timesheet entries, not file rows.
Greentree accepts the import.
If it fails
Partially Exported â some entries weren't exported, or changed after export. Use Export New to pick them up.
Nothing to export â check the pay run dates, staff links, and that CSV export is on under General.
The mapping panel keeps appearing â fix the trade or shift type letters, the combinations, or Field / rostered on the job.
Export button missing â check the permission and the CSV toggle on General.