Timesheet extract for payroll

*Custom enhancement

Content was last updated in 06.01.12-00

This enhancement allows you to extract the approved Timesheet lines (CSV format) for the crew type 'Freelancer' with no company tagged to them.

Once the file is extracted, then the status of all the extracted timesheet lines will be marked as 'Paid and Closed'.

This extracted file can be imported into any compatible payroll software.

Table 1.0: Following are the column details of the extracted CSV file

Column	Description
Employee	Full name of the crew on timesheet.
Work Name	This will always be 'Freelance Pay' (hard coded value for all the rows in csv file).
Date	Timesheet lines start date. Note: The Date format in the extracted files is dd/mm/yyyy. The Month and date is prefixed with '0' if it is a single digit (ex:01/03/2021).
Employee e-mail address	Crew’s communication e-mail address.
Timesheet Notes	Blank value
Start Time	Blank value
End Time	Blank value
Duration	Blank value
Break Duration	Blank value
Units	Timesheet line total amount

Pre-requisites

To get this feature working, you just need to create a initialization file. Follow the simple steps below to create one.

Create an '.ini' file

Create a file by the name R2Integr8.ini in R2 home folder.
Add the following parameters in the file.

Table 2.0: Parameters

Parameter	Description
IntegrationEmployeeID=<Integration EmployeeID>	Employee's user ID who performs the integration.
LaborTimeSheetExportFilePath=<Export File Path>	Integration ExportFilePath.

Figure 1.0: Input the parameters

Batch file set up
Click here to download the sample batch file and place it in R2 home folder.
Edit the batch file and update the two attributes — LOCAL_JAVA_HOME and R2_HOME to their respective root folder path.

Figure 1.1: Sample batch file

Sample Workflow

Create an Order in R2 and add the labor positions.
In R2Labor, open the Order and assign the dates to the booking lines.
Assign the Freelancer Crew ( who are not tagged to any company).
Change the status to 'Confirmed'. Make sure the total amount is populated for the booking lines.

Create a timesheet and get it approved.
Now the status displays as 'Approved'.

Figure 2.0: Timesheet

Open command prompt with 'Run as administrator' option.
Run the batch file by providing the parameters as mentioned in Table 3.0.

Figure 2.1: Run command

Table 3.0: Batch file parameters

Parameter	Description
PayRollExportNEPNZ.bat <start_date> <end_date>	To extract the approved timesheet lines within a date range
PayRollExportNEPNZ.bat	To extract the approved timesheet lines without a date range**

** System extracts all the timesheets in approved status which are dated before Current Week Start (Week Start is defined in R2Labor Configuration settings).

The extracted 'CSV' file displays only the approved timesheet lines.

Figure 2.3: Sample CSV file showing the header row

Now, go to R2 Labor> Timesheet, all the extracted approved timesheet lines display as Paid and closed.

Version No.	Reference No.	Changes
06.01.12-00	R2-17042	Timesheet extract for payroll in CSV format displays the header row
06.01.09-00	R2-16021	Timesheet extract for Payroll of freelancer in CSV format compatible with PayHero Software.

Timesheet extract for payroll

Version No.

Reference No.

Changes

Table 1.0: Following are the column details of the extracted CSV file

Column

Description

Pre-requisites

Table 2.0: Parameters

Parameter

Description

Figure 1.0: Input the parameters

Figure 1.1: Sample batch file

Sample Workflow

Figure 2.0: Timesheet

Figure 2.1: Run command

Table 3.0: Batch file parameters

Parameter

Description

Figure 2.3: Sample CSV file showing the header row

Figure 2.4: Paid and Closed timesheet