Looking for information about ProntoForms features and functionality? Visit our Product Documentation Portal.
Note:The ProntoForms connection with QuickBooks must be made with a QuickBooks Online Plus account. Learn how to check if an account is QuickBooks Online Plus.
The QuickBooks Online TimeActivity Data Destination creates timesheet entries in QuickBooks Online when mobile forms are submitted, and automatically attaches them to the appropriate employees and clients. QuickBooks Online Data Destinations must pull some date from a QuickBooks Online Destination to work properly.
Unsure of how to set up ProntoForms and Quickbooks? Read: Quickbooks Online: Detailed Integration Guide
Organizations of all sizes use QuickBooks Online to manage their accounting processes. QuickBooks Online is highly customizable and designed to work with add-on applications, making it a flexible and powerful tool for managing many of your business functions. Looking for two-way integration?Read more about the ways ProntoForms can connect to QuickBooks Online.
Create the data destination, selecting QuickBooks Online Data Destination as the type.
Under the Destination Basics tab:
Name (Required): Create a name for the destination.
Auto-Link new forms to this destination: Automatically connect any forms you create in the future to the destination. This will only work if future forms have all required matching labels.
Under the Filtering tab, optionally set up filter rules. The data destination will only create/update a record when these conditions are met.
Form Version State
Archived: Only archived forms will be sent to the data destination.
Active: Only active forms will be sent to the data destination.
Draft: Only draft forms will be sent to the data destination.
Data Record State
Complete: Only completed data records will be sent to the data destination.
Dispatch Declined: Only data records that have been declined will be sent to the data destination.
Use Data Record Expression Language to create filter rules based on questions in the submitted form.
Match All: Forms will only be sent to the destination if they meet all listed filter requirements.
Match Any: Forms will be sent to the destination if they meet any of the listed requirements.
Under the Connection tab, connect the destination to QuickBooks Online. Use an existing connection, or set up a new QuickBooks Online Connection. When creating a new connection, it is necessary to Name the connection.
It is necessary to specify which questions in completed forms QuickBooks Online will be pulling information from. Use Data Record Expression Language to specify which destinations will be filled by which question.
Employee ID (Required): The unique employee ID being collected mustmatch a QuickBooks Online employee ID.
Note: This number must be pulled from a QuickBooks Data Source. To populate a form with Employee IDs, set up a QuickBooks Online Data Source.
Date (Required): Date must be collected using a date data type. When using a Date control type, the data must be formatted in ISO standard: yyyy-MM-dd, else the destination will fail.
Time/Duration (Required): Time/Duration must be collected using a duration data type.
Customer ID: The unique customer ID being collected must be pulled from a QuickBooks Online data source.
Product/Service ID: When building the form, the question label must include [##]. Additionally, the unique ID numbers of products or services being collected must be pulled from a QuickBooks Online data source.
Note: These numbers must be pulled from a QuickBooks Online Data Source. To populate a form with Customer and/or Product/Service IDs, set up a QuickBooks Online Data Source.
When building the form: Give numbered labels to matching line item fields (i.e. Activity 1, Activity 2, Activity 3).
When setting up the destination: Map all fields with one label (i.e. %a[Activity ##]).
Test all data destinations before using them in production. This is key to ensuring that ProntoForms data is received. Please read the recommendations for testing and troubleshooting data destinations.