QuickBooks Online TimeActivity Data Destination

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.

 

 

About

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 destinations to work properly.

 

qb128x128.png  

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.

 

Set up the Data Destination

Create the data destination, selecting QuickBooks Online Data Destination as the type.

 

1. Destination Basics

Under the Destination Basics tab:

  • Name (Required): Create a name for the destination.  

  • Activate destination to receive data records at this locationTurn on the QuickBooks Online destination to receive data from submitted forms. This must be enabled to receive data. 

  • 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.

[top]

 

2. Filtering

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. 

Quickbooks_Destination_Filtering_Rules_2.png

 

Filter Rules

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. 

Quickbooks_Destination_Filtering_Rules.png

[top]

 

3. Connection

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. 

democonnetcion.png

[top]

 

4. TimeActivity Fields

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

    • Employee ID (Required):   The unique employee ID being collected must match 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

  • Activity
    • Date (Required): Date must be collected using a date control 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 control type.

    • Description

  • Service
    • 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

 To send multiple line items to QuickBooks Online:

  • 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 ##]).

             2015-09-03_15_36_25-Calendar.png

 

Testing and Troubleshooting Data Destinations

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.

[top]

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments