Accounting Integrations

Coming Soon- QuickBooks Online Enhancements

NOTE: This section refers specifically to customers who have our QuickBooks Online enhancements enabled. If you have questions about when these enhancements will be live for all customers, please reach out to your Account Manager or our Customer Success team.

To get started, select “Connect to QuickBooks Online” under Accounting integrations at the top of the Invoices page. You’ll be prompted to sign into your QBO account. Signing into your account will allow you to map pay types in Justworks to your Chart of Accounts in QBO and then send Justworks invoices to QBO. 

BANK ACCOUNT MAPPING

Next, you’ll need to create a mapping for your bank account. The “Bank account mapping” should be mapped to the bank account you have linked to Justworks.

PAY TYPE TO ACCOUNT MAPPING

Now that you’ve set up your bank account mapping, , you’ll need to map each pay type in Justworks to an Account from your  Chart of Accounts in QBO.

You can also link to sub-accounts from your Chart of Accounts.

Keep in mind here that you’ll have to link every pay type to an Account in order to proceed. You can, though, link multiple Justworks pay types to the same QuickBooks Account from your Chart of Accounts. 

DEPARTMENT MAPPINGS

If you’d like to track payroll expenses by department, you have the option to do so as well. Once you’ve set up your pay type mappings in the general setup above, you’ll see the option to map payment for each department that you have in Justworks to their own accounts in QBO.

Unlike the general settings above, you will not need to map every pay type to an account. Therefore, any pay types not mapped on a department level will still reflect under the larger account for that pay type. 

One good way to use the department mappings is to create sub-accounts of larger accounts for common pay types. For example, you could create several sub-accounts of the larger Salary + Wages account, so that there’s one for each of your company’s departments.

SENDING INVOICES TO QUICKBOOKS

After your payments process and invoices are created in Justworks, you will be able to send each invoice over to QuickBook with the click of a button.

From the Invoices tab, you’ll see the option to ‘Send to QBO’ next to each invoice. 

If you don’t see Send to QBO next to each invoice, return to the “Connect to QuickBooks Online” page to make sure you have all pay types mapped to an Account in QBO.

Once sent, you’ll be able to see each Justworks invoice you send to QBO as an Expense in your QuickBooks Account.

Once you click into ‘View/Edit’ from a certain expense, you’ll see a further breakdown by category. This will match what you see for each invoice in Justworks, mapped out to the specific account in QuickBooks.

Justworks—Quickbooks Online (current features)

Justworks connects seamlessly to Quickbooks Online. Send all your paid invoices to QBO so you can keep track of your entire financial picture in one place. Your invoices have all your payments and transactions - including payroll, vendor and payments, and benefits contributions.

Linking your Quickbooks Online account to Justworks

1. In your Justworks account, navigate to "Invoices" located under “Payments”
2. From you Invoices, click Accounting Integrations > Set up Quickbooks Online
3. A list of Justworks invoice categories will appear. You'll need to make sure you have QBO accounts in your Chart of Accounts for each Justworks invoice category. You can use the same QBO account for multiple invoice categories. Once you've made sure you have your accounts set up in QBO, click the QBO logo to connect.
4. Enter your QBO account information in the pop up window, and click “Authorize.”
5. Map each invoice category to the to the appropriate QBO account that appears in the dropdown. Click “Save.”
6. Once your information is saved, click “Send to QBO” next to each invoice you’d like to sync to your QBO account.

Justworks - Xero integration

Justworks connects seamlessly to Xero. Send all your paid invoices to Xero so you can keep track of your entire financial picture in one place. Your invoices have all your payments and transactions.

To get started, you'll need to make sure you have Xero accounts for each Justworks invoice category listed below. These should be set up directly in Xero. Once you've done so, just click the button below to connect.

Linking your Xero account to Justworks

1. In your Justworks account, navigate to "Invoices" located under “Payments”
2. From your Invoices, click “Accounting Integrations,” then “Set up Xero”
3. A list of Justworks invoice categories will appear. You'll need to make sure you have Xero accounts in your Chart of Accounts for each Justworks invoice category. You can use the same Xero account for multiple invoice categories. Once you've made sure you have your accounts set up in Xero, click the Xero logo to connect.
4. Enter your Xero account information in the pop up window, and click “Authorize.”
5. Map each invoice category to the to the appropriate Xero account that appears in the dropdown. Click “Save.”
6. Please note that your connection to Xero will only last for a limited period of time. You'll be asked to reconnect to Xero once your connection expires.
7. Once your information is saved, click “Send to Xero” next to each invoice you’d like to sync to your Xero account.
8. Invoices will create draft bills in your Xero account, so make sure to login to your Xero account and click “pay bill” to complete the sync

Justworks also supports Quickbooks 2011-2019 for Windows and Quickbooks 2011- 2019 for Mac

Setting up your QuickBooks Export from Justworks

1. In your Justworks account, navigate to "Invoices" located under “Payments”
2. This will bring you to your Update Company Information section.
3. Adjust the names for your accounts as needed, and click "Save"

Mapping Justworks to Quickbooks naming conventions

The file you download from Justworks should not need any additional formatting to be imported into QuickBooks. However, you can make sure your data between QuickBooks and Justworks is properly matched. You can match your existing account names. Go to the dropdown menu under [Your Company Name] & Company Settings

Exporting your Quickbooks IIF file from Justworks

Once you have the Quickbooks details set up, you can navigate to "Invoices", click an Invoice, and then click the "Quickbooks IIF File" link on the top right.

Importing your IIF file into Quickbooks

1. In Quickbooks, go to File > Import
2. Quickbooks may require you to create a backup, simply click OK and confirm the back up.
3. Then select > From IIF Files, and click on the file you just downloaded from Justworks. The file name will look like this ---> justworks_invoice_[date].iif
4. Once your data has been imported, select > OK

That's it - your information is mapped to your accounts in Quickbooks!

View the updated Justworks information in Quickbooks

For an overall view: From the Quickbooks homepage, go to Lists > Chart of Accounts. Here, you can view the overall import from Justworks, and you will see that the money has been debited from the proper accounts.

For a detailed view: From the Quickbooks homepage, go to Reports > Company and Financials > Balance Sheet Standard. You will be able to drill down into the specifics of how the money has been allocated, and to which accounts.

NOTE: Wages, Employer Taxes, Insurance, and Fees will all be imported in aggregate. Contractor Payments and Expense Reimbursements are reported in detail, with each payment broken out into its own line item.

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.