Goflow Documentation Logo

QuickBooks Desktop Accounting Integration

Create an accounting integration to Goflow using QuickBooks Desktop. This connection enables you to send order invoices and purchase bills from Goflow to QuickBooks. Additionally, you can synchronize customer and vendor lists, and retrieve open customer balances from QuickBooks while entering a new wholesale order in Goflow.

The integration with QuickBooks Desktop works through a connector app installed on a network machine. This app maintains a continuous connection to QuickBooks and manages the data flow between Goflow and QuickBooks.

Creating a New QuickBooks Desktop Integration

The installation process is divided into two phases. First, your IT department completes a list of tasks to enable the integration. Once these tasks are completed, coordinate with Goflow Integrations to finalize the installation.

Goflow charges a setup fee for the installation, as it involves technical work. Assuming all IT requirements are met, the installation process should typically take no more than one hour to complete.

Completing Pre-Installation Checklist

To create an integration between QuickBooks Desktop and Goflow, your IT department needs to complete the following tasks:

QuickBooks Tasks

  1. Multi-User License: The QuickBooks application must have a multi-user license installed. The connector app will log in to QuickBooks as a user, and there should be at least one additional user available for your accounting department.
  2. Goflow Username: Create a username in QuickBooks named Goflow. This user should be granted External Accountant permissions. Safe keep the login credentials for the Goflow user. You will need it in the future, and Goflow does not keep the credentials to your QuickBooks.
  3. Network Sharing: The QuickBooks file must be shared over a network. This allows for simultaneous access by multiple users.
  4. Dedicate a Machine: Choose a machine within your network where the connector app would be installed. This machine should be one that is not in regular use by other users. Since Goflow will be logging into QuickBooks on this machine, other users will not be able to use it for QuickBooks. The best practice is to dedicate the server for this purpose.

Network Tasks

  1. Static IP: Goflow will access the connector app by calling the network's external IP address. To prevent a loss of connection, ensure that the network has a static IP address.
  2. Forward Port: Goflow communicates with the connector app through network port 8891. Configure port forwarding on your router, and point port 8891 to the local IP address of the server, both internally and externally.
  3. Whitelist: Allow Goflow access to your network. Whitelist the following Goflow IP addresses:

Installing the App

After your IT department completes the pre-installation checklist, get in touch with Goflow Integrations, and request an installation. Coordinate with Integrations on the following:

At the scheduled time, start a shared-screen session from your server by following these steps:

  1. From your server, go to the screen-share page.
  2. Click Start a New Session.
  3. Enter your Name, and click Start Session.
  4. Follow your browser's instructions for running the client.

Please note that during the app installation, Goflow will login to your QuickBooks file with the Admin username. Be prepared to enter the admin password when prompted, and stay available for any potential questions or issues that may arise during the installation process.

Managing QuickBooks Desktop Settings

From the side menu, go to SettingsAccounting. On this page, you can manage the following QuickBooks Desktop settings:

Maintaining the QuickBooks Desktop Integration

Maintaining a constant connection between Goflow and QuickBooks is important to ensure that invoices can flow in uninterruptedly, and that you can keep creating new customers, vendors, and products in Goflow. If you need to log in to QuickBooks in single-user mode, you will have to temporarily disconnect Goflow. Once your single-user tasks are completed, remember to reestablish the connection with Goflow.

Disconnecting the App

To disconnect the Goflow connector app, follow these steps:

  1. Login to your server.
  2. Exit the connector app. While the app is running, access it through the icon in the Notifications Tray. Right-click on the icon, and click Exit.
  3. Log out the Goflow user from QuickBooks.

The connector app is now disconnected. You can log in with single-user mode from another machine on the network.

Reconnecting the App

To reconnect the Goflow connector app, follow these steps:

  1. Login to your server.
  2. Login to QuickBooks with the Goflow user, and in multi-user mode.
  3. Start the connector app. Locate the app icon on the taskbar, and click on it once. While the app is in the process of reconnecting, monitor its status in the Notifications Tray. Once the connection is successfully established, the app icon will display a green dot, indicating a successful connection.

The app is now connected. If necessary, update the status in Goflow as well. Log in to Goflow, and go to SettingsAccounting, and update the QuickBooks status to Connected.

Automatic Disconnection

When Goflow tries to communicate with QuickBooks but fails after several attempts, the integration status is automatically changed to Disconnected. At the same time, an email is sent to the notifications contact informing them about the disconnection. The disconnection status prevents automatic invoices to QuickBooks from failing. Because Goflow is aware that QuickBooks is disconnected, it holds all pending invoices in queue until the connection is reestablished.

If you have enabled automatic syncing, you will not be able to create new products, new vendors, or new wholesale customers until the connection issue is resolved.

Troubleshooting the QuickBooks Connection

If QuickBooks is disconnected, try to reconnecting it.