Skip to main content

Export GreenTree timesheet CSV from a pay run

You import JC timesheets into Greentree from a file. Sprintsuite generates that file from a pay run.

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_integration on; 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

  1. Go to Staff Times → Pay Runs.

  2. On the pay-run row, click Export GreenTree CSV.

  3. In the options modal:

  • Choose Export New or Export All (include previously exported).

  • Optionally filter by Pay group.

  1. Confirm export.

  2. 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.

  1. Download the finished file from the Background Jobs tray.

  2. 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.

Did this answer your question?