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.

-Sarah

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.

screencast

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