Before You Start

Have you signed up after 19 August, 2020? There's a new way to set up integrations, read more here!

Before exporting to NetSuite, you'll need to approve the timesheets in Deputy for each employee to ready them for export. You can find an overview of how to do so here.

Next, you'll need to connect your Deputy account to NetSuite. To do so, please login to your Deputy account and go to the Locations tab at the top of the screen. Next, please click "Settings" next to the name of the location you'd like to link the account with. Next, click "Payroll" on the left, where you'll see the option to connect to NetSuite as shown below.

After doing so you'll need to enter your details in the screen appearing below. Please ensure you have pop-ups enabled.

If you have not done so before, you will need to setup Token Based Authentication (TBA) in your Netsuite account, and capture all of the required information: Consumer Key, Consumer Secret, Token ID, Token Secret. You can follow this guide to setup TBA in Netsuite.

You will also need your Netsuite account ID. The NetSuite Account ID can be found in your Netsuite account under Setup > Integration > Web Services Preferences, and as shown in the following two screenshots:

After you have found these details, please enter them in the Authentication screen and click "Authenticate".

Matching Employees Between Deputy And NetSuite

To ensure an employee matches between Deputy and NetSuite, we use their Internal Employee ID in NetSuite as their Timesheet Export Code. To find their Internal ID in NetSuite please click Lists->Employees->Employees as shown below:

Once you have found an employee's Internal ID in NetSuite, please find the employee in Deputy on the People page. Next, click "Options->Edit" to the right of their name. Next, scroll to the bottom and enter the NetSuite Internal ID as their Timesheet Export Code.

How To Export To NetSuite

Please navigate to the Timesheets tab at the top of the screen and select "Export Time Sheets". Select the date range for the export from the date selector at the top of screen. This should align with the pay period that NetSuite

Please select the employees to export on the left hand side. To quickly select all employees click "Select All". The details will then be displayed on the right hand side. If you need to edit an item, please click on the item in the list to the right and select "View or edit original item". After selecting the employees and timesheets you'd like to export, please click "Export Selected Items". You'll see a small popup window appear on the screen, asking you to select a payroll application to export to. Please open the drop-down menu and select "Netsuite Export". You can tick the overtime rules you follow for your state and then click "Export".

After the timesheets export successfully you'll be able to find them in NetSuite as shown below:

Deputy will automatically allocate the following attributes in each of the timesheet :

  • Class
  • Location
  • Department
  • Overtime
Did this answer your question?