Timesheet extract for payroll
*Custom enhancement
Content was last updated in 06.01.12-00
Revision history
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. |
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:
|
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.
Figure 2.4: Paid and Closed timesheet