Integrating financial tools has become an essential practice for businesses striving to streamline their accounting processes. A notable example is the integration of Intuit’s QuickBooks Online (QBO) with various business management systems, including FileMaker. With over 2.55 million subscribers, QuickBooks Online is increasingly recognized for managing invoices, payments, and a plethora of accounting tasks efficiently. However, many organizations find themselves trapped in a cycle of double data entry when using both QuickBooks and FileMaker, which can be tiresome and error-prone. This article will explore how integrating FileMaker with QuickBooks Online can alleviate these burdens and enhance operational efficiency.

Understanding QuickBooks Online Integration

The primary motivation for integrating FileMaker with QuickBooks Online lies in the significant reduction of manual data entry. By automating the transfer of information between the two systems, businesses can save time, reduce errors, and ensure that their financial data is up-to-date and accurate. However, to achieve this seamless integration, you need to follow a few important steps which begin with setting up an Intuit Developer Account.

Creating an Intuit Developer Account

The first step in the integration process is to create an Intuit Developer Account. This account will allow you to access the QuickBooks Online API and set up your application for integration. After establishing your account, navigate to the My Apps page and create a new QuickBooks Online application. This involves selecting the API you want to utilize, typically the Accounting API, then clicking the Create App button.

Once your app is created, you will need to navigate to the settings page to configure it, which includes setting the Redirect URL. For instance, you might use a placeholder URL such as Balance 123. This URL serves as a landing page for authentication and does not need any specific features at this stage. After setting your URL, visit the Keys section to obtain your Client ID and Client Secret. Keeping your client secret secure is crucial, as it will authorize your application to interact with a user’s QuickBooks account.

If you lack access to an existing QuickBooks company, you can request an invitation from an administrator to become an accountant on their account. This step is vital, as you will need the proper permissions to access the data required for a successful integration.

Authentication Using OAuth 2.0

As of July 17, 2017, QuickBooks Online adopted OAuth 2.0 for authentication. This protocol is designed to offer enhanced security for the authentication process. To authenticate your integration, you will need to familiarize yourself with the QuickBooks Online API Documentation. This documentation provides detailed guidance on how to construct your authentication requests.

The authentication process involves prompting users to log in to their QuickBooks account through a web viewer. Upon successful login and consent, the user is redirected to the specified Redirect URL, containing the necessary URL-encoded parameters like the authorization code and realm ID (QuickBooks Company ID). These elements will be crucial to obtaining access tokens, which are necessary for making API requests to retrieve or manipulate data.

Making API Requests and Parsing Responses

Once authentication is successful, you can begin making requests to the QuickBooks Online API. It is essential to remember that many API requests, such as creating a customer, will require additional parameters. For instance, while executing a Create Customer request, you will need to submit a POST request with fields like company name, billing address, and various customer settings. This data must be formatted in JSON-encoded text to meet API specifications.

POST https://quickbooks.api.intuit.com/v3/company/[Realm ID]/customer

Upon making a successful request, you will receive a JSON-encoded response containing the details of the newly created customer. You can employ functions such as JSONGetElement() to extract specific information from the response.

Set Variable [ JSONGetElement ( $result ; "Customer.Id") ]

Utilizing a Sandbox Environment

The beauty of creating an Intuit Developer account is that you are provided with a sandbox QuickBooks Online company for testing purposes. This sandbox environment enables you to experiment with your integration without risking any modifications or deletions in your live QuickBooks account. Initially, when you create your application, you will be in the Development section. When confident in your integration’s readiness, you can transition to the Production section, where a consumer key and secret specific to the production environment will be generated.

Understanding User Roles in QuickBooks Online

Effectively managing access and roles within QuickBooks Online is vital for maintaining data integrity and security. Each user associated with your QuickBooks plan must have a defined role that dictates their access rights and capabilities. Here are the distinctions between billable and non-billable roles within QuickBooks:

Billable Roles

These roles count towards your user limit and include:

• Standard All Access: Full system access excluding admin privileges.
• Accounts Receivable Manager: Access to sales and customer reports.
• Company Admin: Full access to all features and the ability to manage users.

Non-billable Roles

These roles do not count towards your user limit and include:

• Track Time Only: Users can submit their own timesheets.
• Take Payments – Created by Self: Limited payment processing capabilities.

Best Practices for QuickBooks Online Integration

When working with the QuickBooks Online API, certain best practices should be adhered to ensure a smooth integration process:

• The API uses SyncTokens to prevent simultaneous updates from conflicting. Always include the expected SyncToken when making updates.
• Ensure that any related records, such as customers, exist before creating dependent records like invoices.
• Consider setting up Webhooks for real-time updates between QuickBooks and FileMaker, enhancing the overall efficiency of the integration.
• Remember that the integration process for QuickBooks Online differs fundamentally from QuickBooks Desktop; it necessitates using the API rather than a plugin.

Conclusion

Integrating QuickBooks Online with your FileMaker solution can dramatically enhance your financial workflow, allowing you to automate processes, minimize manual data entry, and reduce errors. The capabilities are extensive, enabling you to create, update, query, or delete QuickBooks entities seamlessly from within your FileMaker application. For any assistance regarding this integration or to discuss your specific requirements, feel free to contact us.

Did you know we are an authorized reseller for Claris FileMaker Licensing? Contact us to discuss upgrading your Claris FileMaker software.