more-arw search

Q&A Forum

Does Host Analytics integrate with Quickbooks?

Mark Valderrama's Profile

Hey All,

We have gotten pretty deep into the evaluation of the budget software vendors and the question has come up regarding QB seemless intregration with Host Analytics. It does not appear to be an issue with Adaptive and PlanGuru. I was curious if there was anyone in the forum community who has implemented Host with Quick Books as an accounting system.

While Quickbooks certaintly isn't our accounting software of the future, we still need our chosen vendor to be able have seemless intregration with QB and then have the ability to scale up to whichever ERP system we eventually upgrade to. Is there anyone out there who has Quickbooks + Host? I found quite a few Quickbooks + Adaptive users.

Also, has anyone exported data from ADP to Host or Adaptive's personnel planner? What are your thoughts on the data and reporting you get once these was done and how easy was this to do? If not ADP, what other payroll providers have you exported to these systems?

- Mark

 

Answers

Sara Laidlaw
Title: President
Company: Accounting Services Bureau Inc
LinkedIn Profile
(President, Accounting Services Bureau Inc) |

I just want you to know that QuickBooks does not produce a Trial Balance in a net change format or with the expenses broken out by class code. We use class codes for either department codes or for non-profit function codes so this was important to my firm. It also exports the account number imbedded with the description. When integrating with another product, ask if it uses the csv from QuickBooks (out-of-the-box) or if it actually reads the data and can pull what you need. If not, I wrote a little program that will do this. If interested, Google: TBX Trial Balance Exporter.

Chrissy Hildebrandt
Title: Sr Director, Finance
Company: Jasper Wireless, Inc
(Sr Director, Finance, Jasper Wireless, Inc) |

Hi Mark,

Our company is currently doing an integration with Host and QB. Further to Sara's trial balance comment above, we faced a number of Quickbooks quirks during this integration. While we have to do minimal amounts of manual manipulation between exporting the data from QB and importing into Host, the flexibility of Host has really allowed us to overcome the GL flaws. Like yourself, we do not envision ourselves on QB for the long term, however, we are not in the position to upgrade GL systems just yet.

When we went through the analysis of Host vs Adaptive, we found that the Host solution really brought us to where we want to be now, and it could best scale with us in the future. As you know, the reporting in QB can have a lot of shortcomings; we, in particular, cannot get our P&L in the correct format that we want for true GAAP purposes, as well as for proper business analysis. With the help of our integration team from Host, we are going to be able to produce the financials we want from a GL system that cannot provide that ease for reporting. While QB has a lot of shortcomings, the ease of changing structure in QB is sometimes a bit of a benefit as well.

We have not integrated ADP with Host but we will integrate Paychex into the workforce module. It appears to be pretty straightforward.

Hope that helps.

1936 views
Topics

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.