This article is about Justworks PEO. What product am I using?
Getting Started
To get started, select Connect NetSuite on the Invoices tab within Pay by clicking the icon with three dots.
From there, you'll be asked to connect your NetSuite account to Justworks.
After clicking Connect, you will be redirected to NetSuite to authorize access for Justworks.
You will now be successfully connected!
After connecting to NetSuite, you can decide how Justworks syncs data with your NetSuite account under Preferences.
Based on your company needs you can select:
- Bank Account: This should be the account that you use to process payroll.
- Sync method: Manually sync invoices or Allow them to automatically sync the day after processing.
- Transaction Type: Currently only Journal Entry is supported for NetSuite
- Granularity: Allows each line item mapped to either be aggregated into a single line per payroll, or into multiple lines for each individual employee regardless if they have a shared account.
Company Mapping
Now that you’ve set up your preferences, you’ll need to map each pay type in Justworks to an account or sub-account from your Chart of Accounts in Netsuite.
Each payment type is grouped in a category with similar line item types (ex: Earnings, Deductions, Fees etc). After expanding a given category, you can use the drop down next to each individual line item type to specify the Xero account it should be mapped to.
Keep in mind here that you’ll have to map every visible line item to an account in order to complete setting up your integration. You can see your progress based on the status shown next to each category.
Only items that have appeared on processed invoices will be available to map. As you process additional payrolls, new items may be used and will need to be mapped at that time to continue syncing to NetSuite.
Department Override
Once you’ve set up your default company mappings you’ll have the option to override the same line items by department to their own accounts in NetSuite. Department overrides are totally optional and are not a required step to complete your account mapping.
First, you can choose the department from the drop down to see the same categories as the company level.
Similar to the company level mappings, you can expand a category within an individual department to see the individual line items. The default account will be visible and you can choose a different account from the drop down to assign as an override.
Unlike in the company-level defaults, you will not need to assign an account override to every department or for each pay type within a department. Any pay type not mapped on the department level will still map to the account listed in the company-level settings.
Office Override
Similar to departments, you are able to override line items at the individual Office level. This is optional and you do not need to map each line item and only need to edit the account if it needs an override compared to the default company or department-, or employee-level mapping.
Employee Override
You are also able to override line items at the individual employee level. This is optional and you do not need to map each line item and only need to edit the account if it needs an override compared to the default company or department-, or office-level mapping.
Tracking Categories
If you utilize tracking categories in NetSuite, you can map these at the department level. Similar to department overrides, tracking categories are optional and can be mapped only to the applicable departments.
International (EOR) Payroll and NetSuite
You can map and include EOR payroll information with your data syncs to NetSuite. Find out more by visiting International Mapping for Accounting Integrations.
Sending Invoices to NetSuite
After your payroll process and an invoice is created in Justworks, you will be able to send each invoice over to NetSuite with the click of a button or sync automatically the day after processing. If you have enabled automatic sync, you can still manually sync the invoice at any time if you would like.
From the Invoices tab in Pay, you’ll see an icon with two arrows next to each invoice. If syncing manually, clicking that icon will sync the invoice to your Xero accounting integration. When successful, it will turn green with a check mark inside.
If you don’t see the icons next to each invoice, return to the Xero setup page to make sure you have connected properly to Xero.
If the icon is instead red with an exclamation mark, the sync to Xero will have failed, likely due to a new line item appearing and needing mapped.
You will be able to tell which category the new type appears in as the status will change from “Completed” to “In Progress”. After mapping the missing item, you can return to invoices and resync to NetSuite.
Disclaimer
This material has been prepared for informational purposes only, and is not intended to provide, and should not be relied on for, legal or tax advice. If you have any legal or tax questions regarding this content or related issues, then you should consult with your professional legal or tax advisor.