Upflow integrates natively with Quickbooks Online to allow for effective collections process in conjunction with your Quickbooks Online instance. This document describes how to set up the integration and how it works in detail.

Overview

The Quickbooks Online integration ships with the following capabilities:

• 1-way synchronisation with Quickbooks Online with the exception of payment write-back

• New data from Quickbooks Online is synced once every 5 mins

• Supports merchant self-onboarding

Entity Mapping

Setup

Requirements

Admin access: You should have admin rights in Quickbooks Online to setup the integration with Upflow.

Connecting Quickbooks Online to Upflow

Upflow relies on OAuth allowing you to seamlessly connect with your Quickbooks Online account. Refer to this guide for a step-by-step guide on how to connect your Quickbooks Online instance to Upflow.

Features

Contacts

Quickbooks Online doesn’t have concept of contacts for customer objects. Though, Quickbooks Online supports adding multiple emails as commas separated in the “Email” field.

These comma-separated emails will be imported as individual contacts in Upflow.

Main Contact: While importing emails as individual contacts, the first email in the list will be considered as the main contact. And the firstName and lastName will be borrowed from the customer’s details.

Mapping custom fields

Upflow supports import of customer level custom fields from Quickbooks Online . The custom field imported in Upflow are a subset of Quickbooks Online’s native fields.

Below are some of the examples of native fields and custom fields imported from Quickbooks Online into Upflow.

Subsidiaries

In Upflow, parent-child relationships exist at the customer level, and any grandchild is directly linked to the main parent.

Journal Entry

In Upflow, we map journal entries in Quickbooks Online with different payments types- either as a debit or as a credit, i.e. they will imported as payments or refunds depending on their Quickbooks Online type.

Each Journal entry line item belongs to a specific customer.

Deposits

Similar to Journal Entry, Upflow supports Deposits which can be applied across payments and customers.

Payment write-back

All the payments that customers make on Upflow can be pushed back to Quickbooks Online, thanks to the Payment write-back functionality.

Merge Attachments

Upflow allows multiple attachments (pdfs, excel) to be imported from Quickbooks Online either. They can either be imported as a merged pdf attachment or as a zip file. The merged attachments can be sent in collections emails and also hosted on customer portals.