QuickBooks data integration with Intuit Field Service Management

/, User Tips, Work Order Wednesday/QuickBooks data integration with Intuit Field Service Management

QuickBooks data integration with Intuit Field Service Management

Let’s talk about integration between IFSM and QuickBooks, and beyond!

This article describes built-in integration via the Corrigo Integration Client, as well as how to import information that is not part of our built-in integration.  Lastly, this article touches upon reporting and data exporting out of IFSM.

When you purchase your Intuit Field Service Management (“IFSM”) subscription, Corrigo provides you with a new database.  Next you’ll log in, access the Settings area, and configure the system (your company logo, hours of operations, technician skills, teams, services and categories, etc.).  Then you activate the integration between IFSM and your QuickBooks via our Corrigo Integration Client (IFSM integrates with supported  U.S. versions of QuickBooks Online, and supported U.S. versions of QuickBooks Desktop Pro, Premier, or Enterprise).

What data integrates between IFSM and QB?

  1. Active customer list in QB will sync to IFSM.
  2. Active item list in QB will sync to IFSM.
  3. As you make new customers or invoices or time card records in IFSM, these will sync into QB. Invoices syncing from IFSM into QB containing inventory items will decrement those inventory items accordingly inside your QB.
  4. Sales orders and invoices you create inside QB will never appear in IFSM. If you want a work order or invoice to appear in IFSM you must make it in IFSM and sync the invoice to QB if you want the invoice to appear in both databases.
  5. As part of IFSM’s integration with QB Merchant Services “Web Store”, payments taken inside the IFSM itself will sync “hand in hand” with the IFSM invoice into QB such that the invoice inside QB will show “Paid” without additional effort. However, IFSM payments taken outside of the IFSM (Square, Go Payment, etc.) will need to be manually associated with the appropriate invoice inside QB.

Importing Data or Work Order history into Intuit Field Service Management

Sometimes new IFSM customers were using a competing work order software package prior to their IFSM and want only some of the prior work order history and customer equipment list to appear inside IFSM. This is typically accomplished by enabling and creating back dated work orders.  There is no fee to make back dated work orders (only your own time and effort).

Sometimes new IFSM customers were using a competing work order software package prior to their IFSM and they want all of this work order history, as well as customer equipment list and attributes, to appear inside IFSM so all of the information is in one place. This is possible by hiring a professional services firm to use the SOAP language and the Corrigo web services API to push data into IFSM.

Sometimes new IFSM customers were using invoices in QB as “work orders” prior to their IFSM and they want these invoices in QB to somehow appear inside IFSM as work orders.  This is possible by hiring a professional services firm to use the SOAP language and the Corrigo web services API to push data into IFSM.

Exporting data out of Intuit Field Service Management

Sometimes IFSM customers wish to export data from IFSM.   This can usually be accomplished by creating a report inside IFSM.  Once you run your report you can save the output in the desired file format (XLS, CSV, XML, PDF…).

If you require the data in a very specific data format (often called an EDI), this can be accomplished by hiring a professional services firm to use the SOAP language and the Corrigo web services API to export data out of IFSM in the file format you require — and even push this data into another system.

Additional Resources

Additional questions related to data export should be directed to Corrigo Support.  Our Support team will assist, as well as introduce you to a professional services firm to use the SOAP language and the Corrigo web services API to help you achieve your data import/export goals.

By | 2017-09-12T09:31:00+00:00 June 15th, 2017|getting started, User Tips, Work Order Wednesday|0 Comments