Integrate with Timesheet Portal

How to set up a Timesheet Portal (TSP) integration

What is Timesheet Portal?

Timesheet Portal or TSP is an online recruitment solution which allows users to manage timesheets for temp/contract workers. Timesheets can be submitted by workers on the web or mobile devices and if required approved by your clients online or by email.

The platform provides you with a branded portal and streamlines the process of time & expense capture to automatic invoice and payrun creation, ensuring you can pay and bill faster.

If you aren't already a Timesheet Portal user, get in touch with them for a demo of their platform by contacting them here!

For more information on the Timesheet Portal integration see this page.

How it works: Via the Firefish API

The Firefish API integration with Timesheet Portal allows all of your contract at placement information to be regularly sent and uploaded directly into Timesheet Portal behind the scenes. All information for all contract placements, contract roll ons, terminations and extensions are updated every 15 minutes over a rolling 7 day period, meaning that any changes you make to any of your data will automatically appear in Timesheet Portal.

As the information is transmitted as read only data rather than an export we recommend the API as the preferred method of Timesheet Portal integration.

To get connected, get in touch with your Firefish Success Champion or Support and we can arrange this for you.

You can find more information about the Firefish API here.

The User Journey

Watch the below video to find out how smooth the user journey is when using Firefish with Timesheet Portal.

Jobs Search Placement Reference

Within the Jobs page you now have the ability to search for a job using the Candidate's placement reference.

Entering the placement reference in the field above will search the placements and return the job relating to the placement reference.

What information is sent?

Information sent from FF to TSP Includes:

• Contractor details such as personal and payment information

• Pay and charge information based on the billing information in Firefish

• Job Information including start and end dates, custom fields and client approvers

Note: if you create any new candidate details or enable any custom fields within Properties settings you should inform Timesheet Portal so they can map these accordingly.

Below you will find a table to fields that are passed over from Firefish to Timesheet Portal. You will see both the field name from Firefish and the name that is attributed in Timesheet Portal.

Firefish Name	TSP Field Name	Comments (If applicable)
Job Reference ID	Placement unique code
Job Title	Placement description
Original Contract Start Date	Placement start date	This will be set per contractor at the placement stage.
Final Contract End Date	Placement end date	This will be set per contractor at the placement stage.
Pay Frequency - within candidate record > pay tab	Placement bill frequency	This field can be populated in the candidate pay tab, or can be completed in the compliance section at the placement stage of the workflow
This pulls from the Pay Method field on the Candidate Profile>Pay tab	Placement Payment Method	This field can be populated in the candidate pay tab, or can be completed in the compliance section at the placement stage of the workflow
Pulls from the Splits Modal on the placement Summary	Consultant Split 1 First name Consultant split 1 last name Consultant split 1 email Consultant split 1 code Consultant split 1 percent Consultant split 2 code Consultant split 2 percent Consultant Split 2 First name Consultant split 2 last name Consultant split 2 email Consultant split 3 code Consultant split 3 percent Consultant Split 3 First name Consultant split 3 last name Consultant split 3 email	The following split fields are populated and sent to TSP if a consultant split has been attributed to a placement.
ISO Currency Symbol e.g. GBP	Placement charge currency Placement pay currency	The currency will match the currency that you have set in the system settings
Hourly or Daily Rate	Rate Type
Pulls from placement summary	Pay rate
Pulls from placement summary	Charge rate
Job Company ID	Client unique code
Job Company Name	Client name
Company Accounts Reference in FF	Client accounting code
Company Address 1 in FF	Client address 1	Company fields will be pulled from the company record associated with the job.
Company Address 2 in FF	Client address 2
Company Address 3 in FF	Client address 3
Company Town in FF	Client city
Company postcode in FF	Client Postcode
Accounts Company Address line 1 in FF	Client billing address 1
Accounts Company Address line 2 in FF	Client billing address 2
Accounts Company Address line 3 in FF	Client billing address 3
Accounts Company Town in FF	Client billing city
Accounts Company Postcode in FF	Client billing postcode
Account Company Name in FF	Client billing organisation name
Client Account Contact Email in FF	Client billing email
Client Account Contact FullName in FF	Client billing contact name
Approver Contact Display ID in FF	Approver unique code
Contact FirstName (Approver) in FF	Approver first name	This will be the job contact if a timesheet approver is not selected/if the setting is not activated.
Contact Surname (Approver) in FF	Approver last name
Contact Work Email (Approver) in FF	Approver email
Contact Job Title (Approver) in FF	Approver job title
Contact WorkMob (Approver) in FF	Approver mobile
Candidate Display ID in FF	Contractor unique code
Candidate FirstName in FF	Contractor first name
Candidate Surname in FF	Contractor last name
Candidate Personal Email in FF	Contractor email
Candidate Mobile in FF	Contractor mobile
Candidate Created Date in FF	Contractor join date
Candidate Job Title in FF	Contractor job title
Gender M/F	Contractor gender	This will only be provided if you have the field activated and populated.
Mapped from the Pay Type Field in the Pay Tab of the candidate record	Contractor employment type
Ltd Name Candidate Pay Tab in FF	Contractor limited company name	Fields that pull from the Candidate Pay Tab will display the Candidate's details or selected Supplier details if Pay Type is "Umbrella" Supplier Details are added and edited in People Configuration>Supplier Directory
VAT Number Candidate Pay Tab in FF	Contractor limited company vat number
Mapped from the LTD Email Field in the Pay Tab of the candidate record	Remittance Email Address
NI Number Candidate Pay Tab in FF	Contractor NI number
Unique Tax Reference field Candidate Pay Tab in FF	Contractor UTR number
Candidate Date of Birth in FF	Contractor date of birth
Ltd Address1 Candidate Pay Tab in FF	Contractor company address 1
Ltd Address2 Candidate Pay Tab in FF	Contractor company address 2
Ltd Town Candidate Pay Tab in FF	Contractor company city
Ltd Postcode Candidate Pay Tab in FF	Contractor company postcode
LTD Number Candidate Pay Tab in FF	LTD number
Candidate Address1 in FF	Contractor address 1
Candidate Address2 in FF	Contractor address 2
Candidate Address3 in FF	Contractor address 3
Candidate Town in FF	Contractor city
Candidate Postcode in FF	Contractor postcode
Bank Name Candidate Pay Tab in FF	Contractor bank name
Account Name Candidate Pay Tab in FF	Contractor bank account name
Sort Code Candidate Pay Tab in FF	Contractor bank sort code
Account Number Candidate Pay Tab in FF	Contractor bank account number
User Display ID in FF	Job consultant code
User First Name in FF	Job consultant first name
User Surname in FF	Job consultant last name
User Work Email in FF	Job consultant email
Markup % field on Placement Summary in FF	Markup percentage
Margin % field on Placement Summary in FF	Margin percentage
Markup field on Placement Summary in FF	Markup amount
Start Time field on Placement Summary in FF	Normal Start Time
End Time field on Placement Summary in FF	Normal End Time
Extension ID in FF	Extension ID
StartDate field on Extension Summary in FF	Extension Start Date
End Date field on Extension Summary in FF	Extension End Date
These TSP field names are taken from the client's custom field label	Custom Text Field 2 Custom Text Field 3 Custom Drop-Down 3 Custom Drop Down 4 Custom Drop Down 5 Custom Drop Down 6	The names of these drop downs are dynamic meaning that the field name in TSP will match the name that you have attributed to the field in Firefish.
Job Type Custom Drop Down on the Job Summary	Custom Job Type
This field doesn't appear in FF and is only used for Enterprise Clients with more than 1 Website	Website ID
This pulls from the Pay Method field on the Candidate Profile>Pay tab	Placement Payment Method
This pulls from Engagement Type field on the Candidate Profile>Pay tab	Contractor engagement type