CiviCRM Community Forums (archive)

This is probably useless to 100% -1 of the users of CiviCRM, but can give some pointers to the "Accounting integration improvements and Quickbooks integration" effort.

We recently integrated the Collmex Bookkeeping site (online site in Germany) with CiviCRM. Here are the goals:

a) Members need to be synced between the Collmex (which supports Members in addition to Customers) and CiviCRM.
b) Customers need to be transferred between CiviCRM and Collmex. A customer is any contact without an active membership, who has (had) to pay something (e.g. event contribution).
c) When a participant goes into the "Pending from pay later" or "Registered" state the invoice information needs to be transferred to Collmex, so bookkeeping can use the internal methods for payments tracking and so on.
d) Payments done using direct debit / direct transfer need to be imported into CiviCRM so we can set participants from "Pending from pay later" to "Registered".
e) If a participant changes the contact details, this needs to be reflected in Collmex as well.

Technically it was done using the Collmex API which supports sending CSV files back and forth. Depending on the event type, the accounting is different (accounting laws in Germany) and a Cron Job for importing Payments and Member updates.

If you need further information, don't hesitate to contact me.

Sounds interesting sussdorff - yes , please do post the code etc. There are various sync efforts that this might be useful for beyond the bookkeeping one. WRT the latter, I'm currently developing a batch direct debit and direct credit system that will extend the work of Bernhard Fürst for a German DTA system. The CiviAccounts team expect to be supporting exports of financial transaction batches of various sorts in a general way.

Thanks! And best wishes!

Hi sussdorf,

Sorry for the delay in replying due to my vacation. You might want to post information about your code, including a link to repository holding it, at http://directory.civicrm.org/

Here is a good link for detailed implementation information on the CiviAccounts: http://wiki.civicrm.org/confluence/display/CRM/Accounting+integration+improvements

Look at the child pages for specifications in different areas.

Here is a link to outdated estimates based on a previous data architecture, but which is good for an overview of the pieces:
http://wiki.civicrm.org/confluence/display/CRM/CiviAccounts+Project+Estimates

We're taking Bernhard's Drupal module which uses the PHP PEAR package for German DTA transactions and updating it for Drupal 7, and implementing a plugin for the Royal Bank of Canada, our largest bank here. The direct debit donations will all go to the central organization, which will then distribute the funds to its local entities based on which one the donor is a member of. Here is a link to a bit of information on that effort, which will all be shared back to the community but will not be going into core: http://wiki.civicrm.org/confluence/display/CRM/Direct+Debit+and+Direct+Credit+-+Monthly+Batches

An IRC chat would be great. Contact me at joe (dot) murray (at) jmaconsulting (dot) biz to arrange a time if you don't find me in there when you are.

Cheers,
Joe