In Accounting, click Setup, QuickBooks.

Open Dental has the ability to automatically create accounting transactions for deposits in the QuickBooks accounting software. The bridge was designed using QuickBooks 2012 and may not work with other versions. The online version may be used, see QuickBooks Online.

Follow the instructions below to enable the QuickBooks bridge. Once enabled, see Deposit Slip, QuickBooks, for instructions on sending new and old deposits to QuickBooks.

To enable the QuickBooks bridge:

Company File: Enter the path to your QuickBooks company file. To Browse for the company file, close QuickBooks in the background first. Once added, run QuickBooks in the background again.

Connect: Click to open a security window from QuickBooks.

List of accounts to deposit to: Click Add and select the deposit account to add it to the pick list. Accounts entered here will be options when sending a deposit to QuickBooks on the Edit Deposit Slip window.

List of income accounts: Click Add to select the Income Account options available when the deposit transaction is created.

  • At least one account in both List of accounts to deposit to and List of income accounts must be added.
  • If the account you are looking for is not available when you click Add, make sure you have logged in to QuickBooks as a user who has access to all accounts.

Enable QuickBooks Class Refs: This preference is useful for those who want to track deposits by clinic in QuickBooks (Class Refs).

Click OK to save the settings. The next time a deposit is created in Open Dental, a deposit transaction will automatically be created within the QuickBooks company file, using the accounts you choose at the time of creation.

Technical Details

Multiple Open Dental Databases: One QuickBooks company file can have multiple Open Dental databases making deposits into it. Each Open Dental database will need to have the settings manually set up in order to start making deposits into the company file. Be sure to make a detailed memo if you need to know which database the deposit came from.

Running QuickBooks in Background: Open Dental will run much faster if QuickBooks is open in the background. Make sure to use the exact same company file path to launch QuickBooks outside of Open Dental otherwise you will receive an error that says "Error: A QuickBooks company data file is already open and it is different from the one requested or there are multiple company files open". Having QuickBooks running in the background significantly cuts down on authentication and communication time for every command that Open Dental sends.

Edit Application Permissions in QuickBooks:

  1. Open the company file. Go to the Edit menu, choose Preferences, and click Integrated Applications.
  2. Click the Company preferences tab.
  3. Set the following preferences:
    • Uncheck 'Don't allow any applications to access this company file'.
    • Uncheck 'Notify the user before running any applications whose certificate has expired'.
      Note: If checked, automatic access will be suspended when the application's certificate expires.
  4. Select the appropriate application and click Properties.
  5. Change any of the options.
  6. If the company file has multiple users and 'Allow this application to login automatically' is checked, select a user for the application to log in as. Although you can permit the application to log in as any user you want, you may want to create a user specifically for the application. This lets you control the type of data the application can access.
  7. If necessary, using whatever mechanism is available in the third-party application, set it to communicate with QuickBooks at your chosen time.