When you import a QuickBooks Online customer as a client, Forecast now brings the customer's contact across as the client's primary contact, along with its website, and keeps them up to date as they change in QuickBooks. Import also checks for existing clients first, so importing a customer you already have no longer creates a duplicate.
What's new
Contacts come across from QuickBooks. The contact on a QuickBooks customer becomes the primary contact on the Forecast client, so you can see who to speak to, with their email and phone number, without opening QuickBooks or asking finance.
Website comes across too. The client's website is filled in from QuickBooks, so the client record is complete without manual entry.
No more duplicate clients on import. Forecast matches QuickBooks customers to your existing clients by primary contact email. When the match isn't clear, you decide.
What comes across from QuickBooks
In QuickBooks, the contact's name, email and phone are stored on the customer itself, so each customer has one contact. That contact becomes the client's primary contact in Forecast.
| QuickBooks field | Where it goes in Forecast |
|---|---|
| Contact first name, last name, email | Primary contact: First Name, Last Name, Email |
| Phone number | Primary contact: Phone Number |
| Website | Client: Website |
First name, last name and email are all needed to create the contact. If any of them is missing, the client is still imported with its website and address, and the contact is added later once QuickBooks has all three.
How the import works
Import as you do today: click Import From QuickBooks and select the customers you want. Forecast then compares each selected customer's email (exact match, capitalization ignored) with the primary contact email of your existing clients, whatever created them: QuickBooks, Xero, HubSpot, Salesforce or a person.
| What Forecast finds | What happens |
|---|---|
| No match | A new client is created and linked, as before. |
| 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 | That client is left alone, and a new client is created for the customer. |
Review matching clients
When a match needs your input, the Review matching clients window opens.
- A line at the top shows how many customers will be linked automatically.
- Each group that needs your input is marked Needs review. Pick the right customer or client, or choose Do not link.
- The Import button shows how many customers will be imported: new clients, automatic links and the matches you confirm. It's available as long as there's at least one customer to import.
- Any group you don't resolve is skipped. Its customers stay in the import list, so you can import them later.
- If you close the window without importing, nothing is imported or linked. Run the import again to return to it.
When a customer is linked to an existing client, automatically or by you, the client's existing primary contact is updated from QuickBooks rather than a second contact being added. Website and address fields are filled in only where they're empty, so details you already have in Forecast are kept.
Keeping clients up to date
Changes in QuickBooks reach Forecast when you click Synchronize on the invoices page, or when you export an invoice. The sync only goes one way, from QuickBooks to Forecast.
- Name, email or phone changed in QuickBooks: the primary contact is updated. Changing the email never re-matches or re-links the client.
- Website or State changed in QuickBooks: the client is updated.
- A missing contact detail filled in QuickBooks: if a contact was skipped because a name or email was missing, it's created once all three are filled, and set as the primary contact.
- A value cleared in QuickBooks: Forecast keeps its current value until QuickBooks has a new one.
Good to know
- QuickBooks values overwrite Forecast values. When a field changes in QuickBooks, it replaces the value in Forecast, including details someone typed in by hand. Changes made in Forecast are never sent to QuickBooks.
- Existing QuickBooks-linked clients are updated on your next Synchronize. Their contact is added, unless the client already has a primary contact with a different email. Website and State are filled in only where they're empty on that first sync, and stay in step with QuickBooks after that.
- Where you'll see the difference. QuickBooks-linked clients now show a primary contact with name, email and phone from QuickBooks, plus the client's website.
For step-by-step instructions, see Integrate QuickBooks Online with Forecast.
Comments
0 comments
Please sign in to leave a comment.