A journal service is a feature that allows you to connect your accounting software with your payroll platform so that you can capture journal entries to the chart of accounts. With our journal service integration, if you use for Netsuite and Netsuite OneWorld -an enterprise module - for your accounting software you can connect them with our platform so that you can export your journal data.
Token Based Authentication in NetSuite.
- Log into your Netsuite account.
- Go to Setup > Company > Setup Tasks > Enable Features;
- Click on the SuiteCloud subtab;
- Scroll down to the Manage Authentication section.
- Tick the Token-based Authentication checkbox;
- Click I Agree on the SuiteCloud Terms of Service page.
- Click Save.
Journal integration in Payroll
- Go to Payroll Settings.
- Click on Business Management
- Select Integrations.
- Navigate to Netsuite and click Add. Please note, there is the option to connect to NetSuite and NetSuite One World.
- From here you need to enter the following details:
- Netsuite Account Id
- Consumer Key
- Consumer Secret
- Token Id
- Token Secret
Click Connect to Netsuite.
How to find your Account Key
Step 1: Netsuite/NetSuite OneWorld Account Id. You can locate your Account Id by navigating to Setup -> Integration -> Web Services Preferences (in NetSuite). The Account Id appears on the top left hand side of the screen.
Step 2: You will now need to create an integration record if one does not exist. The integration record identifies the payroll software in NetSuite’s system and is also what is required to create the Consumer Key and Consumer Secret. To create an integration record:
- Go to your NetSuite account.
- Setup > Integration > Manage Integrations > New.
- In the Name field, enter the name of the payroll application (or any other name that is easily identifiable to users);
- With the State field, keep the value as Enabled.
- In the Authentication subtab, tick the TOKEN-BASED AUTHENTICATION checkbox.
- Click Save.
The Consumer Key and Consumer Secret details will then be displayed on the screen. You MUST copy/paste this information in a secure location and then enter in the relevant fields in the payroll software.
Important: For security reasons, the Consumer Key and Consumer Secret values are only displayed on the initial setup page. They cannot be retrieved from the system after you navigate away from the screen.
If you (a) did not retain the consumer key and consumer secret details or (b) already have an existing integration record but have not retained the consumer key and consumer secret details, you will need to reset credentials to obtain new values. To do this:
- Click on Edit.
- Click on reset credentials.
- Confirm by clicking OK.
Step 3: The NetSuite administrator role does not have token permissions by default. If you do not create a token role and assign it to your administrator, you will get a “Login access has been disabled for this role” error when creating a token. To do this:
- Go to Setup > Users/Roles > User Management > Manage Roles > New.
- Click on New Role.
- Enter a Name for the role.
- Navigate to Permissions > Setup and add the following permissions:
- User Access Token: Full
- Access Token Management: Full
- Web Services: Full
- Navigate to Permissions > Lists and add the following permissions:
- Accounts: Full
- Classes: Full
- Departments: Full
- Employee Record: Full
- Employees: Full
- Locations: Full
- Tax Items: Full
- Subsidiaries: Full (OneWorld users only)
- Navigate to Permissions > Transactions and add the following permission:
- Make Journal Entry: Full
Additional note for OneWorld users: the role must have explicit access to every individual subsidiary in the business; not just the parent subsidiary. In addition for Netsuite user profile there it is required for REST Web services to be set up else there would be issues trying to establish a connection.
Step 4: The new role created in Step 3 now needs to be assigned to employee/user. To do this:
- Do a global search for "page:employees";
- Click on Edit for “Employees”;
- Click on Edit for the relevant employee;
- Navigate to Access (subtab) > Roles;
- Add the new role created;
- Click Save.
Step 5: This step requires creating a new access token that will then supply the values for the Token Id and Token Secret. To create a new access token:
- Go to Setup > Users/Roles > User Management > Access Tokens > New;
- Select the application created in Step 4 from the dropdown list;
- Select the user from the dropdown list;
- Select the role created in Step 3 from the dropdown list;
- The Token Name pre-populates by default with a concatenation of Application Name, User, and Role. You can however override this and enter your own token name.
- Click Save.
The Token Id and Token Secret details will then be displayed on the screen. You MUST copy/paste this information in a secure location and then enter in the relevant fields in the payroll software.
Important: For security reasons, the Token Id and Token Secret values are only displayed on the initial setup page. They cannot be retrieved from the system after you navigate away from the screen. If you did not retain these details, you will need to create a new access token.
Step 6: This last step requires you enter the applicable values against each field in the Integrations screen of your payroll software, as shown in Step 2. Then click Enable. After the connection is established, you will be able to:
- Choose whether you want to post the journals as approved
Important: Please make sure you have the access rights to post "approved Journals" to Netsuite.
- Select a Subsidiary (OneWorld users only).
You have now connected your payroll file to NetSuite and may assign classes, departments, subsidiaries to your locations.