01 July, 2011

We've just started a make it happen for UK direct debit integration - something that lots of UK non profits have been asking for and we are happy to provide :)

The fabulous Eileen will be carrying out the work and we are aiming to raise the total amount needed by August 15 in time for her trip to the UK so we can spend some time kick starting it all.

So if direct debit is important to you or your clients, please step up and help us reach the goal amount.

The requirements and specification are being developed on the wiki.  The spec. will be finalised before work commences based on requirements expressed by contributors and we can't garuntee to fulfill all requirements so please discusss any specific questions you have with us before adding requirements...

Read more
05 April, 2011

As part of the Google Grants program for non-profits, Google offers their Google Checkout service to qualifying non-profits at no-charge with no processing fees. Depending on the fees you would pay with a competing processor this represents an instant 3% jump in your organization's fundraising efforts just by using Google Checkout.


The only limitation has been recurring donations. To address this Google launched Google Subscriptions and now we need to get support into CiviCRM so we can enjoy a single free processing fee payment gateway.


A new Make it Happen iniative was launched to get this going in 4.1 or even 3.4 if we meet the campaign...

Read more
04 November, 2010

There have been a number of blog posts discussing the needs for improved accounting features in CiviCRM. The results and current specification is at the wiki at: http://wiki.civicrm.org/confluence/display/CRM/Finance+and+Accounting


Its time to help to make-it-happen for CiviAccounts once the specifications on the wiki are streamlined and prioritized.   Dave has requested that all interested parties join this new CiviAccounts team.


My priorities are: 

1) Get many-to-many transactions to obligations working, both in the database as well as the UI. Many-to-many includes the following use cases:  

 - One check/credit card transaction that needs to be allocated to many obligations ( such as event fees, member dues, donations, etc )


- One obligation that will be fufilled by many transactions. Also known as partial payments. So...

Read more
03 October, 2010

Today at the Bristol Code sprint a few of us made a concerted effort on getting making Giftaid 'plug and play' for Civi.

Our starting point is code written by Millertech and our aim is to get it into a state that we can package it as a Drupal module.  Once we've done that, we're hopeful that we'll be able to package it for Joomla also.

We're having to make a few improvements to Civi's hooks, and some modifications to the existing functionality to enable us to package it up, but the benefits are obvious: much easier installation and thus wider uptake of the module, and thus higher CiviCRM adpotion in the UK :)

We spent most of the morning familiarising ourselves with the code and discussing the necessary changes we would need to make.  This threw up some difficult problems (I'll spare you the details) but the result was this outline of...

Read more
03 May, 2010

I have shared the slides ( and video ) from my ignite session at CiviCon, which describes a case study of my use of CiviCRM for a synagogue, including invoicing and non-Western calendars. Everything is at my blog.


04 January, 2010
By Eileen

This is really a continuation of previous blogs on CiviCRM accounting integration. I now have some basic integration bewteen CiviCRM and Xero working and decided to do a screencast.

Screencasts are hardly my preferred medium - especially now that I've tried to make one but I thought it might be useful for people to see what a CiviCRM integration with the accounting package Xero would look like. The screencast doesn't show you any CiviCRM - just Xero and is more intended to give people an idea of what the day-to-day reality of it is.


This is a pretty limited integration with a fair bit of hard coding and a narrow focus on event registrations but it's enough to cut down the work for our next block of classes pretty substantially.

In getting this far the issues I had were in many senses fairly predictable as several have been discussed before but it did throw some light :

  1. ...
Read more
05 October, 2009
By DaveD

The Physician Health Program of BC has a task that goes something like this: Their vendors, and even staff and board members, are not paid directly by them but by the provincial medical association (BCMA), so when invoices from vendors come in, they need to enter the information onto a special form and send that off to the BCMA for payment. Then they periodically send back a statement to reconcile against. Since all the vendors are contacts in CiviCRM already, it made sense to think about putting this in there too.

The customization for entering the invoices and generating the printable forms is currently in first-attempt mode and might still need some tweaking. You can find it in the unfortunately named php repository (php = physician health program). The reconciliation part isn't done yet so I'll just describe the first part. Well, I guess "not done yet" is a form of...

Read more
19 September, 2009
By Eileen

A while back I wrote a forum post on how CiviGrant could be usefully extended to fulfill a wider function. I have just received a message from someone (datakid) who is prepared to put some time into extending it for his purposes which are explained here so I thought it might be worth soliciting people's thoughts and ideas.

Datakid has indicated that he is new to the CiviCRM community and keen to get started so there are a couple of things that people might choose to comment on -
1) the approach that he can take that will best meet his goals and also help the broader community.
2) how to get help (IRC) & how to contribute his code back.

While I have ideas about how CiviGrant might be made more generic I'll focus on Datakid's use case which is basically to records different types of expenses against each grant...

Read more
20 August, 2009

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:

  1. Map sources of income in CiviCRM with accounts in QuickBooks.
  2. Insert Donations, Deposits and Payments from CivCRM to QuickBooks.
  3. 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...

Read more
14 August, 2009
I've been offline for a week, so a bit of delay in continuing this discussion on Invoicing and Accounting Integration. I thought it would be helpful to jump in with a quick review / reminder of existing functionality and data structures and some thoughts about what's missing based on my understanding "so far".
  • All financial transactions in CiviCRM are represented by a Contribution record. This includes "regular" contributions, membership payments, event registration payments and pledge payments. For "multiple participant registrations", a single contribution record is created for the grand total.
  • The Contribution record includes in Invoice ID column. This is populated automatically with a unique value for "online" transactions, and is can be populated manually (via form field) for offline transactions. The auto-...
Read more