We're experiencing abnormally high support volume that has created a backlog delaying our responsiveness. Please visit our status page for more details and to subscribe to updates.

How-to: Connect to QuickBooks Desktop

Brigid  BelloBrigid Bello Posts: 61Expensify Team Expensify Team
edited December 2019 in How-tos

In order to integrate Expensify with QuickBooks Desktop, we suggest that you host QuickBooks Desktop on a Right Networks server. If you don’t already have an account with Right Networks, get in touch with a Sales Consultant by filling out the form here.

Before you can connect your Expensify policy to QuickBooks Desktop, make sure you are logged in as an Admin in QuickBooks, and that the company file that you need to connect to is the only company file that you have open.

Step 1: Set up submitters in QuickBooks Desktop

All report submitters must be set up as Vendors in QuickBooks Desktop with the email that they use in Expensify on file in the "Main Email" field of their Vendor record.

To set this up, click into your vendor section of QuickBooks: 

imagepng

imagepng

If you want to export reports to your users' employee records instead of their vendor records, you will need to select Check or Journal Entry for your reimbursable export option. If you are setting up Expensify users as employees, you will need to activate QuickBooks Desktop Payroll to view the Employee Profile tab where submitter's email addresses need to be entered.

Step 2: Initiate the connection

To connect, navigate to Settings > Policies > Group > [Policy Name] > Connections > QuickBooks Desktop.

Select the Connect to QuickBooks Desktop radio button and click Connect to QuickBooks:

imagepng

Step 3:  How do you access QuickBooks desktop? 

In the near future, Expensify will only be supporting QuickBooks Desktop through Right Networks, so it is highly recommended that you select "Third-Party Remote Desktop" and then "Right Networks" in order to get the best experience and to avoid needing to adjust your setup in the future. 


Step 4: Enable the Expensify Sync Manager in Right Networks

If you don't yet have an account with Right Networks, you will first need to get in touch with Right Networks here. You can then either enable the Expensify Sync Manager yourself from the "My Account" section of your Right Networks portal or reach out to Right Networks for assistance. 

Step 5: Complete the Connection

  1. Launch QuickBooks and open your desired Company File using the QuickBooks Admin credentials. Admin credentials are required to create the connection due to the permission requirements but you will not need to be logged in as an admin when you sync or export.

  2. Copy the User Token by selecting the clipboard icon.

  3. Still running QuickBooks, launch the Expensify Sync Manager. Paste your token and click Save.

  4. Once the Sync Manager status is updated to “Connected,” return to Expensify and click the “Continue” button.

  5. Go back to QuickBooks. During the initial connection, you will see an "Application Certificate" screen pop up.

  6.   a) Click "Yes, always; allow access even if QuickBooks is not running.”
      b) Select the admin user from the dropdown, then click "Continue." Selecting
            Admin does not mean you need to be logged in as an admin to use this       
            connection— this is just what you need to select when setting the permissions.
      c) Next, click "Done" on the pop up to finish this step.

  7. Navigate back to Expensify and wait for the syncing process to complete.

  8. You're all set! 

Next Steps

  • Before you can start exporting reports, you will need to Configure your Export and Coding options.

  • If you need to connect more than one policy to QuickBooks Desktop, check out this guide for more details.

Related articles
Deep Dive: Configure Coding Settings for QuickBooks Desktop
Deep Dive: Configure Export Settings for QuickBooks Desktop

Sign In or Register to comment.