When you need this
You import JC timesheets into Greentree from a file. Sprintsuite generates that file from a pay run.
LIVE path only: Staff Times â Pay Runs â Export GreenTree CSV. This is not API Push to Greentree.
Before you start
greentree_integrationon; company Enable CSV timesheet export (timesheet_csv_export_enabled) on General.Connected Greentree with company code as needed for filename/context.
Staff linked to Greentree (not Do not link) with Emp Code.
Pay Types / Combinations / Automatch set so Activity can resolve (see related how-tos).
Jobs that use combination Activity have Field / rostered set when required.
Permission to export Greentree timesheets.
Steps
Go to Staff Times â Pay Runs.
On the pay-run row, click Export GreenTree CSV.
In the options modal:
Choose Export New or Export All (include previously exported).
Optionally filter by Pay group.
Confirm export.
If Sprintsuite finds unmapped Activity lines, the Could not be exported mapping panel opens:
Fix rows via Fix (Job edit for Field/rostered; Activity Codes for letter/combination issues), or
Click Export anyway â unmapped lines export with a blank Activity.
Download the finished file from the Background Jobs tray.
Check GreenTree Export Status on the pay-run row: Exported (N/M), Partially Exported (N/M), or Not Exported, plus mapping-error counts when relevant.
[Screenshot: Pay Runs Export GreenTree CSV]
[Screenshot: Export options modal with Pay group]
[Screenshot: Mapping-errors panel with Export anyway]
[Screenshot: GreenTree Export Status cell]
[Video: Full CSV export including Export anyway]
CSV behaviour (LIVE)
Column / rule | Behaviour |
Activity | From Pay Types activity mapping if set; else Automatch / Combinations (trade + Field/rostered + shift type). Never connection default. Never job JCActivity. |
Wcentre | Always blank |
Scope | Staff producing entries only (no asset / non-producing lines) |
Allowances | Extra rows; PayCode + Activity from Pay Types â Allowances |
Filename | Uses company code + pay-run dates + generated timestamp when company code is set |
What success looks like
Tray job completes; CSV downloads.
Status shows Exported or Partially Exported with expected N/M.
Greentree import accepts the file for your JC layout.
If it fails
Nothing to export â check period, staff links/Emp Code, CSV toggle on General.
Mapping panel loops â fix Activity Codes / trades / Field-rostered, or Export anyway knowingly.
Permission / not available â role + CSV toggle + parent gate.
See Troubleshooting for more.