⏱️ 2 minute read
Import customers, export invoices and synchronize payments with the QuickBooks Online (QBO) integration.
This article includes:
- Data flow between Forecast and QBO
- Setting up the QBO integration
- Linking client profiles with QBO customers
Data flow between Forecast and QBO
Setting up the QBO integration
Connecting QBO with Forecast is fast and easy. Simply authorize your QBO account, import customers or link existing client profiles and begin invoicing. Check out Using the QBO integration for invoicing to learn how to export and synchronizing your invoices and payments.
To connect the QBO integration
- Click on Admin in the top bar.
- Select Integrations from the dropdown.
- In Accounting & billing select QuickBooks Online.
- Click Connect.
- Log into your QBO account and select your company.
Linking client profiles with QBO customers
Import QBO customers to create new Forecast client profiles or link QBO customers with existing Forecast clients.
To import QBO customers and create new Forecast client profiles
- Click Admin in the top bar.
- Select Clients from the dropdown.
- Click Import From QuickBooks.
- Select the customers to import or use Select all.
- Click Create Clients.
- Forecast checks each selected customer's email against your existing clients:
- No match: a new client profile is created and linked to the customer.
- One match: the customer is linked to that existing client automatically. No duplicate client is created.
- More than one possible match: the Review matching clients window opens so you can choose the right link. See Reviewing matching clients below.
-
If some customers will be linked automatically, Forecast tells you how many before the import runs. Click Import to finish.
What comes across with each customer
Primary contact. The contact details on the QBO customer are added as a contact on the Forecast client and set as the client's primary contact.
| QBO customer field | Forecast contact field |
|---|---|
| First name | First Name |
| Last name | Last Name |
| Phone | Phone Number |
- First name, last name and email are required. If any of them is empty in QBO, the client is still imported, but without a contact. The contact is created the next time you synchronize after all three are filled in QBO.
- Phone is optional. If it's empty, the contact is created without a phone number
Website and billing address. The customer's Website and billing address are copied to the client.
| QBO customer field | Forecast client field |
|---|---|
| Website | Website |
| Billing address: Street address 1 | Street |
| Billing address: City | City |
| Billing address: State | State/County/Region |
| Billing address: ZIP code | Zip Code |
| Billing address: Country | Country |
How Forecast matches QBO customers to existing clients
Before creating anything, Forecast checks for existing clients so that importing a customer you already have does not create a duplicate. It compares each selected customer’s Primary Person email (exact match) with the primary contact email of your existing Forecast clients.
| What Forecast finds | What happens |
|---|---|
| No match | A new client is created and linked. |
| One customer matches one client | The customer is linked to the existing client automatically. No duplicate is created. |
| One customer matches several clients | You choose which client to link. |
| Several customers match one client | You choose which customer to link. |
| Several customers match several clients | You see all the candidates and can confirm one or more pairs at once. |
| The only matching client is already linked to a different QuickBooks customer | New client is created and linked |
Reviewing matching clients
The Review matching clients window opens when a match isn't one-to-one:
- One selected customer matches several Forecast clients.
- Several selected customers match the same Forecast client.
- Several selected customers and several Forecast clients share the same email.
Forecast doesn't link any of these automatically. You choose.
The window shows:
- How many other customers matched exactly one client and will be linked automatically.
- A card for each group of matches, marked Needs review.
- A count of matches confirmed so far, for example "1 of 4 matches confirmed".
- An Import button showing how many customers will be imported. This includes new clients, automatic links and the matches you confirm.
To review matching clients
- On each card, select the customer or client to link. To link none of them, select Do not link.
- When several customers and clients share an email, you can pair more than one of them on the same card.
- Click Import.
What happens to customers you don't link
- Customers on a card you leave unresolved, or mark Do not link, are not imported.
- When you pick one customer on a card, the other customers on that card are not imported.
- Customers that weren't imported stay in the Import From QuickBooks list, so you can import them later.
To link existing Forecast client profiles with QBO customers
- Click Admin in the top bar.
- Select Clients from the dropdown.
- Click Edit on the profile you need to link.
- Scroll down to QuickBooks.
- Select the QBO customer from the dropdown and click Link.
- Successfully linked profiles display the QBO logo.
- To unlink a client profile from a QBO customer, edit the Forecast client profile and Unlink.
Comments
0 comments
Article is closed for comments.