TriNet SOI has a feature in their payroll administration to upload a CSV file. Using TriNet Expense's Custom CSV editor, any SOI customer can create the proper file output to uploading into their payroll. The following three fields are necessary in order to upload into SOI:
1. Employee ID (Column 1)
2. Payroll Code (Column 2)
3. Amount Reimbursable (Column 3)
Here are the instructions to do so.
To get started, go to Settings > Add-Ons > Export and find the Custom CSV option. Click Install.
A new window will appear to create your custom SOI CSV output.
Step 1 - Choose Expense Report data in the drop-down.
Select the Add Column button twice. Once that is done, add the following header names and attributes (see image below):
Header name: Employee ID
Attribute: Employee ID
Header name: Payroll Code
Attribute: Payroll Code (Payroll code is entered on the categories page)
Header name: Amount Reimbursable
Attribute: Reimbursable Amount
Once you are finished, select the Save button to publish to the Reports > Company page. You can also download a sample of the data by selecting the Preview button.
If you need to edit your Custom CSV, go to Settings > Personal Settings > Reports and select the Setup button. A list of all Custom CSVs will appear. Select an action to edit, delete, or download.
You're done! Now when you view the Reports > Company page, select the expense reports export to SOI. Click Export Report to download the custom SOI CSV data.
Select the CSV you’ve named SOI in Personal Settings > Reports to export the data.
Once you have successfully setup the SOI CSV file, you will need to confirm your SOI Payroll account is setup to receive the file.
We have attached documentation for the upload process into the SOI platform. You can download the PDF below for directions.
Please contact TIMS@TriNet.com for further instructions or assistance configuring your SOI account.