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 Dave D

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
10 August, 2009
By Eileen

I wasn't really sure when I wrote my first blog on accounts and CiviCRM whether it was a topic that would draw much interest but in fact I got a lot of really thoughtful comments and something of a blogathon took place. I have some ambition to write another piece summing up what I think has come out of the discussion - but in the meantime I want to pick up now on something Dave & I have talked about a little bit on the forums: invoice numbers.

To quickly recap on previous conversations - CiviCRM does not have a clear concept of an invoice. From an accounts point of view it would be great to see this considered in some future version but must be noted that it is not trivial.

In the meantime, many CiviCRM users need to meet legal invoicing requirements when people sign up for memberships or events online. In New Zealand, to my knowledge, the legal requirements for an invoice are:

1) The words 'Tax Invoice' must appear on it
2) The GST number (if...

Read more
05 August, 2009
By andrew
This post started out as a reply to Eileen's "Banking Screen?" comment on my previous post on this topic, but by the time I was done, I thought that this warranted its own post. I think that the core "Accounts" or "Banking" functionality that could be helpful to Civi users without getting too out of control, is:
  1. generate a listing of the individual cheque and cash "receipts" processed since the last "deposit" was generated, add selected receipts to a deposit and print it as a deposit listing, using a template that would enable you to submit the listing to your bank with a deposit slip;
  2. enable a bank reconciliation to confirm that each deposit was successful and highlight any discrepancies such as bounced cheques or typo's when entering cash or cheque amounts. Ideally you would be able to tick off each receipt within a deposit as reconciled (or just tick the deposit as a whole and have the system mark each receipt within that deposit as reconciled). If a...
Read more
04 August, 2009
By andrew

We are finding that CiviCRM/accounts issues are becoming increasingly important for our clients, and Eileen's recent blogs and the discussion they are generating are a fantastic step towards helping find the best way for Civi to deal with financial transactions.

For example, I think it could be useful for Civi to ultimately develop functionality for maintaining simple bank accounts within CiviCRM, so that small organisations can maintain basic accounts without the headaches of integration with an external package.

Currently we have clients who are willing to rely on CiviCRM as being the central repository for the detail of all contributions, with a lump sum figure hitting their GL at the end of each month which can be reconciled against CiviCRM's records. This is largely reliant on the organisation having very good procedures in place to attend to banking on the same day as transactions are entered into CiviCRM, to make it easier for payments to be reconciled. It...

Read more