Upcoming Events
San Francisco CiviCRM Meetup - February 8th, 2012
February 8th, 2012
Come meet others from the Bay Area who are interested in, using or developing (more...)
UK usergroup - London meetup
February 8th, 2012
Come and meet others from the UK that are using CiviCRM or are interested in (more...)
Chicago CiviCRM Meetup
February 17th, 2012
Please join other CiviCRM users, administrators, and developers in the Chicago (more...)
London user and administrator training
February 23rd, 2012
A comprehensive two day hands on training course covering the configuration, (more...)
CiviCRM Seminar - London
February 23rd, 2012
NfP Services free seminar
CiviCRM London sprint Feb 2012
February 27th, 2012
Following the CiviCRM training here in London, we will have a CiviCRM code (more...)
Philadelphia - CiviCRM Meetup for Q1 2012
March 13th, 2012
UK South West - CiviCRM Meetup
March 20th, 2012
Come meet others from the Area who are interested in, using or developing for (more...)
[Bristol, UK] user and administrator training
March 21st, 2012
A comprehensive hands on training course covering the configuration, (more...)
San Francisco user and administrator training
March 29th, 2012
A comprehensive two day hands on training course covering the configuration, (more...)
CiviCRM Usability, Test and Code Sprint - San Francisco (March 2012)
March 29th, 2012
This usability, code and test sprint is targeted at CiviCRM users and (more...)
CiviCon 2012 San Francisco Bay Area - April 2nd 2012
April 2nd, 2012
CiviCon is THE annual event bringing together the people who use, develop, (more...)
CiviCRM Documentation, Test and Code Sprint - after CiviCon San Francisco (April 2012)
April 4th, 2012
This sprint is targeted at CiviCRM users and developers who want to work on (more...)
CiviCRM Components
Tools for engaging your supporters...
CiviCRM and QuickBooks
- Not Just a Contact Database
-
These optional components give you more power to connect and engage your supporters.
civiCASE
Case management for clients and constituents.
civiCONTRIBUTE
Online fundraising and donor management.
civiEVENT
Online event registration and participant tracking.
civiMEMBER
Online signup and membership management.
civiMAIL
Personalized email blasts and newsletters.
civiREPORT
Report generation and template management.
About 8 weeks ago we began looking into a CiviCRM / QuickBooks integration framework. Our goal is to write a module that allows CiviCRM contributions and contact information to be written to QuickBooks. Our target version is QuickBooks 2009 Premier Non-Profit edition, since that's what we use.
At the very least, the module should be able to:
- Map sources of income in CiviCRM with accounts in QuickBooks.
- Insert Donations, Deposits and Payments from CivCRM to QuickBooks.
- A seamless process that requires little management from the staff.
We found the QuickBooks PHP framework by Keith Palmer to be the best fit for our needs:
It's being actively developed and supported by a handful of programmers who are also using the framework in production environments. It makes SOAP calls using QuickBooks XML (QBXML) to the QuickBooks Web Connector (QBWC). QBWC runs on the same machine as QuickBooks, but CivCRM can of course be running anywhere... locally, on the same network, or in the cloud. The advantage of using his framework is that it already knows how to build proper QBXML messages, simplifies the setup/teardown of the SOAP server, has decent error handling, etc.
Our first task in evaluating the framework was to write some unit tests. We built out all the Object tests (~1800) using PHPUnit and contributed those back to the project. In the process we discovered bugs, fixed them, and contributed those changes back as well. Many more tests will eventually need to be written, but writing the core object tests gave us confidence in the framework.
We're still in the scoping/requirements/use-case phase and without funding it's a low priority for us. If you're interested in funding a CiviCRM/QuickBooks integration, please contact us. We're also blogging about this project on our site, regarding next steps and progress.
Comments
Re: License and some other notes
I'm the author of the above mentioned PHP framework (Keith Palmer of ConsoliBYTE, LLC).
Just wanted to note that my PHP code has recently undergone some changes:
1. It's been changed to the EPL license, which removes that advertising clause. Might still not be GPL compatible, but is probably better for many people's uses. This is the standard license for code.intuit.com open-source projects on Intuit's website...
2. The code is now hosted on code.intuit.com, Intuit's open-source developer network. I'm still the guy developing it, but I have a bit of an "in" and a bit more backing from Intuit as well now. Check it out here: https://code.intuit.com/sf/projects/php_devkit
3. There has been some Drupal/CiviCRM discussion on the project forums, so anyone interested might want to get in on that: https://code.intuit.com/sf/discussion/do/listPosts/projects.php_devkit/discussion.developer_forum.topc1770
Sounds great
Sounds great. Quickbooks is the 500lb guerrilla in small org accounting.
A couple quick comments:
Thanks for the response. We
Thanks for the response. We have no plans to handle QBOE at the moment, since we don't use it. It seems like there might be more options for hooking CiviCRM data into QBOE... possibly using REST. Keith's framework also has support for QBOE but we haven't written any tests around it so we can't vouch for the stability. Would be great to get your insight and experience if we ever get a chance to build out that aspect.
Seems like a modified BSD license is compatible with GPL. Keith mentions both in his documentation and on the download page that he will work with a group around licensing. It's unlikely that it will be a problem, but definitely something worth investigating. We've had some e-mail exchanges with him and he's been very helpful in the past.
Time and Cost Estimate for the project ..
can you give us a ballpark estimate of how many hours it will take to get this done. Since i dont know a lot about accounting or QB, lets just estimate for the most basic feature set (and useful). i.e. something that meets 80% of your needs
lobo
There are two use cases
There are two use cases that represent ~70% of our needs:
1. "How to collect program fees."
An organization gives us a check. In CiviCRM, we add their contribution and CiviCRM pushes contributor, contribution type, total amount and received date into QuickBooks as an invoice. QuickBooks sends a result code or status message back to CiviCRM and contributions that have been "processed" will be flagged accordingly.
2. "How to collect individual donations/foundation grant/corporate giving."
An individual sends a check and we add their contribution OR someone makes an online donation. CiviCRM pushes contributor, contribution type, total amount and received date into QuickBooks as a donation. QuickBooks sends a result code or status message back to CiviCRM and contributions that have been "processed" will be flagged accordingly.
Based on these two use cases, which are basically the same, we think it will take approximately 25 hours to write the code and unit tests. We've already contributed 50 hours to the project and we're looking for the community to fund $2500 to complete the initial prototype. Our hope is that the initial prototype will demonstrate that this approach works and help kick start a larger QuickBooks/CiviCRM integration effort.
We also posted a more detailed review of our scope of work.
Accounting Integration
I definitely see alot of potential for an accounting integration module/etc., and would certainly be willing to get involved and help out. Where does this project stand at this time?
Still willing to help?
Now that you know more about the project, are you still eager to help out?
check the blog post on DT's blog ..
http://dharmatech.org/blog/quickbookscivicrm_initial_scope/08/21/09
they are looking to raise 2500 for approx 50 hours worth of work on the package
lobo
CiviCRM & Quickbooks
(accidentally posted above with reply to older post)
I have some accounting experience myself. I started looking around for other similar solutions that are already implemented in the open source community, and that work well already, so we could have a better grasp of what works well already, and then improve on it if necessary.
I might also be able to contribute man-power to this as well.
I will throw an update here shortly.
Quickbooks Integration
How is progress on everything so far guys?
I was looking around, and I'm amazed by the EXTREME lack of accounting integration in ALL open-source programs...
Below are a number of useful resources I've found.
To get us started, here's Quickbooks Import QBI for Zen Cart:
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=144
Support Forum Thread for the above:
http://www.zen-cart.com/forum/showthread.php?t=35220
This creates iif files, which are then imported into QB.
Take a look at this thread:
http://www.sugarcrm.com/forums/showthread.php?t=17411
Somebody mentions a possible integration using Jitterbit, but it's only partially open-source... and licensed under their own license ( jitterbit {dot} com/Product/license.php ). Is there anyone with legal experience in the forums who can take a look at this and see how open source it really is?
Also, take a look at the Compare Editions tab on their website.
Now, this seems to be a fully open source data mashup integration solution:
http://www.apatar.com/
http://www.apatarforge.org/
Check out this thread:
chasesagum {dot} com/zen-cart-sugar-crm-quickboks-heaven
This seems to be an implementation guide for a proprietary SugarCRM-QuickBooks integration module that we can glean some ideas from:
thelongreach {dot} com/Brochure%20Files/info@hand%20Finance%20(QB)%20Implementation%20Guide.pdf
Here's a movie demo of how the integration module works:
infoathand {dot} com/videos/info@hand%20Finance%20for%20QuickBooks.mov
PHP Quickbooks Framework:
https://idnforums.intuit {dot} com/messageview.aspx?FTVAR_FORUMVIEWTMP=Threaded&catid=56&threadid=9164
Please share your thoughts. We should all decide on a platform/course of action, and I don't see why we couldn't have something usable for civiCRM very shortly.
thanks
The PHP framework you mention at the end of your post is the conclusion we came to a few months ago after researching different solutions. We've already developed a slew of tests to help validate functionality. We've blogged about it on our site as well as the CiviCRM Blog. The PHP framework is a starting point of proven code, running in production, used and supported by the developer. The tests and bug fixes we've provided helps sets the stage for a prototype module.
Again, we are looking for funding sources from the community or users with similar requirements listed to develop the prototype. If you know of anyone, please send them our way.