Skip to main content

GROWING AND SUSTAINING RELATIONSHIPS

GROWING AND SUSTAINING RELATIONSHIPS
Close
Katy Jockelson

Implementor, administrator

Third Sector Design

http://thirdsectordesign.org

We work with non-profits to help them use and understand Civi. It's such an important tool for these organisations and it's great to see people using it in different and interesting ways. Using and working with Civi is made so much more fun and useful by the enthusiastic and talented community surrounding it.

GROWING AND SUSTAINING RELATIONSHIPS
Close
Micah Lee

Developer

Electronic Frontier Foundation

http://www.eff.org

I work for the Electronic Frontier Foundation. We switched to CiviCRM so that we could be sure that our membership data stays safe, secure, and private. Now we have control over our CRM and can customize it to work for our needs.

GROWING AND SUSTAINING RELATIONSHIPS
Close
Erik Hommel

Implementer, Developer

EE-atWork

The CiviCRM community is a very friendly and helpful community. Whatever the challenge, I always get enough help from the forum or IRC to nudge me in the right direction. For me joining in a CiviCRM sprint once or twice a year is the best, meeting other community members in real life, sharing successes, challenges, problems and meals :-) Seriously, I think the active community is one of the serious assets of CiviCRM and I am proud to be part of it! And when I grow up I promise to do more :-)

GROWING AND SUSTAINING RELATIONSHIPS
Close
Richard Hunter

Administrator, End-user

AustLII

http://www.austlii.edu.au

AustLII is the leader in the free access to law movement and has a philospophical bias towards open source systems. After investigating all the other possible major alternatives it seemed logical to turn to CiviCRM. We have software developer resources, and though it is not core business, we may be able to direct some of these resources towards improving CiviCRM for the community.

GROWING AND SUSTAINING RELATIONSHIPS
Close
Jake Martin White

Implementor, Developer

PeaceWorks Technology Solutions

http://www.peaceworks.ca

PeaceWorks provides technology solutions for not-for-profit organizations. CiviCRM fills an important niche among our clients who need a flexible, comprehensive, user-friendly, web-integrated CRM solution.

GROWING AND SUSTAINING RELATIONSHIPS
Close
Abril Rocabert

Administrator and End-user

http://www.alternativasycapacidades.org

CiviCRM is a powerful tool that could be really useful for many non-profits in Mexico.
Unfortunately the community is very small in my country. I hope that in the next years the community expands around Latin America.

GROWING AND SUSTAINING RELATIONSHIPS
Close
Coleman Watts

End-user and Developer

Woolman Sierra Friends Center

http://woolman.org

If it weren't for CiviCRM we'd be using at least 5 different
systems for Woolman: one for donor management, another for email newsletters, a third for our school enrollment, a fourth for our summer camp registration, and then a whole bunch of spreadsheets for keeping track of things like event attendance, prospective students, CSA memberships, etc. And of course none of those systems would talk to each other or make it possible to get a whole picture of the many ways one person might participate in our education center's activities. Migrating all of our scattered data and disparate systems to CiviCRM was a long and challenging process, but the results have been more than worth it. Our ability to track and report on our programs has improved dramatically, while the burden on staff to do data entry has been greatly reduced, and our participants are happy that they can now register/enroll online rather than mailing or faxing paper forms.

GROWING AND SUSTAINING RELATIONSHIPS
Close
Merlise Clyde

End-user, administrator

International Society of Bayesian Analysis

http://bayesian.org

ISBA is an international non-profit society with members from all over the world. We have sections that represent different scientific areas and chapters that represent different regions of the world. Civi Member powers our membership system! We use CiviEvent for Conference and Workship registration, and utilize CiviPetition for creating new sections to our society through member petitions. We are epxloring how CiviGrants can be used to track our travel awards and look forward to features for integrating accounting and finance. As a growing non-profit CiviCRM plays a major role in managing our membership system!

GROWING AND SUSTAINING RELATIONSHIPS
Close
Samuel Vanhove

Developer, Implementor

Réseau Koumbit

http://koumbit.org

As non-profit consultants working for non-profit organizations, we found CiviCRM to be particularly well suited to answer the common needs of activist associations, charities and other medium-sized groups. Based in Montréal, we've helped local and international organizations migrate to CiviCRM to manage their memberships, events, communications and fundraising campaigns. We empower our clients and assist them when they need us.

GROWING AND SUSTAINING RELATIONSHIPS
Close
Sarah Gladstone

Implementor, Developer

Pogstone, Inc.

http://pogstone.com

I have been involved in the CiviCRM community for over 4 years, and enjoy implementing and programming CiviCRM for a variety of non-profits. I have been amazed at the rapid pace of innovation delivered with each new release, and CiviCRM's flexibility in being able to accommodate a variety of requirements. I have learned a lot about CiviCRM by participating in CiviCon, online forums, and CiviCRM book sprint.

GROWING AND SUSTAINING RELATIONSHIPS
Close
Brylie Oxley

End-user and Developer

Woolman Sierra Friends Center

http://woolman.org

Working with CiviCRM enriches our commonwealth. Any investment in CiviCRM is
shared by the community as a whole. Community organizations naturally complement the spirit of Free/Libre Software.

GROWING AND SUSTAINING RELATIONSHIPS
Close
Arthur Richards

DEVELOPER

WIKIMEDIA FOUNDATION

http://wikimediafoundation.org

At the Wikimedia Foundation, we leverage CiviCRM to maintain millions of records of donors and their contributions. Working with the product and particularly with the community has been a terrific experience. There's nothing quite like two open source organizations working together to meet their respective goals while ultimately strengthening the open source community as a whole.

LOGIN | REGISTER
  • Create new account
  • Request new password

Search form

  • BLOG
  • DEMO
  • Find An Expert
  • NEED HELP
  • SUPPORT US
  • DEVELOPER RESOURCES
CiviCRM Community Site logo CiviCRM Community Site
  • WHAT IS CIVICRM
    • Community
    • Case Studies
    • Experts
    • Contributors
    • Core Team
    • Licensing
    • Contact Us
  • WILL CIVICRM MEET YOUR NEEDS?
    • Contacts
    • Contributions
    • Communications
    • Peer-To-Peer Fundraisers
    • Advocacy Campaigns
    • Events
    • Members
    • Reports
    • Case Management
  • GET STARTED
    • Evaluate Your CRM Needs
    • Evaluate CiviCRM Features
    • Read Books
    • Demo CiviCRM
    • Download CiviCRM
    • Find An Expert
  • PARTICIPATE
    • Join the CiviCRM Community
    • Read Our Blog
    • Community Forum
    • Attend a Training or Meetup
    • Make It Happen
    • Contribute
    • Become A CiviCRM Developer
    • Issue Tracker
    • Help with Documentation
    • Translate

You are here

Home » Blogs » SarahGladstone's blog

Blog

  • Architecture Series
  • CiviCampaign
  • CiviCase
  • CiviCon
  • CiviContribute
  • CiviCRM
  • CiviCRM API
  • CiviCRM Code Sprint
  • CiviCRM Meetups
  • CiviCRM Release
  • CiviCRM Solutions (case studies and user stories)
  • CiviCRM Team
  • CiviCRM Training
  • CiviCRM v1.6
  • CiviCRM v1.7
  • CiviCRM v1.8
  • CiviCRM v1.9
  • CiviCRM v2.0
  • CiviCRM v2.1
  • CiviCRM v2.2
  • CiviCRM v2.3
  • CiviCRM v3.0
  • CiviCRM v3.1
  • CiviCRM v3.2
  • CiviCRM v3.3
  • CiviCRM v3.4 and v4.0
  • CiviCRM v4.1
  • CiviCRM v4.2
  • CiviEvent
  • CiviMail
  • CiviMember
  • CiviMobile
  • CiviPledge
  • CiviReport
  • Documentation
  • Drupal
  • Extensions
  • Finance and Accounting
  • Interface Design and Layout Standards
  • Internationalization and Localization
  • Joomla
  • Older Versions
  • Schools
  • WordPress

Join the team for CiviAccounts

Submitted by SarahGladstone on November 4, 2010 - 20:14

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 someone could make a deposit for an expensive event or member dues, and pay it off over time. 

 

2) Make it easier to reconcile income against deposits. (One bank deposit may include many smaller checks.) 

 

3) Simplify and automate exporting relevant data to QuickBooks and other widely used general ledger programs. 

 

 Who wants to join this team? Also, if you have an accountant or bookkeeper available, ideally they will join the team as well. 

  • SarahGladstone's blog
  • Log in or register to post comments

Comments

(ac)count me in

Permalink Submitted by ken on November 4, 2010 - 21:31

Sarah,

I'm interested in all the points you've raised.

Ken

  • Log in or register to post comments

Very Interested

Permalink Submitted by marktuma on November 8, 2010 - 22:58

Hi Sarah,

 

If it's helpful to have someone who can't really contribute a lot technically, but is a very keen end-user, in on this, then I'm in.  I'd just begun having a conversation with the Dharmatech guys about this, so it's exciting to see I'm not the only one who's keen.

 

Cheers,

Mark

  • Log in or register to post comments

count me in

Permalink Submitted by Guest (not verified) on November 29, 2010 - 18:59

hi,
i work for a non-profit, and we are currently looking at getting a web-based solution.

fund splitting and deposit batches are important components for us - i think civicrm is pretty cool, but would need to build some of this functionality first.

i know a bit about php/mysql but am no expert. if there is anything i can contribute please let me know. if i start building any functionality i will share!

james

  • Log in or register to post comments

We're in!

Permalink Submitted by andrew on November 4, 2010 - 22:12

Hi Sarah

Thanks for all the work you have been doing on the wiki.  We've got the database structure in place in 3.3 to handle 1 & 2 above by:

 

1) One payment transaction being able to be applied to one or more contributions, event registrations, membership etc

 

2) A deposit being treated like another form of payment transaction, in that it can link a whole bunch of payment transactions (ie cheques and cash amounts) into a single deposit

 

I will try to update the documentation of this on the wiki over the weekend.  I have some ideas on how to address 3) as well, which I think I mentioned to Dave on a skype call, but which I have never got back to documenting - so I'll try to do that too and see what you think!

 

(PS - I also have an accounting degree for my sins!)

 

Andrew Perry

Community Builders Australia

  • Log in or register to post comments

Hi Sarah,   I think I'd

Permalink Submitted by Eileen on November 4, 2010 - 22:28

Hi Sarah,

 

I think I'd have to take a very big step back if I wanted to avoid being roped into this one. I'm hoping to see Joe Murray's name on the list too soon

  • Log in or register to post comments

Switchback is in

Permalink Submitted by scolson on November 5, 2010 - 06:02

My company, Switchback (http://switchbackcms.com),  has a specific internal goal of March 1 for this to be tested and in production. We are willing to help with planning, and development.

  • Log in or register to post comments

Yeah! new team members!

Permalink Submitted by SarahGladstone on November 5, 2010 - 14:09

Thanks to everyone who is interested in the new CiviAccounts team! As the main goal of this team is to have a Civi-Make-it-happen campaign, I have clarified the priorities in the wiki document. There is a new first section titled "Priorities for the planned CiviAccounts Civi-Make-it-Happen campaign" 

 

Everyone should update and flesh out these use-cases.  Ideally we should be ready to launch a fundraising "Civi-Make-it-happen" campaign by Nov. 18. To meet this goal, the core team needs detailed use-cases that need to be supported ( as well as prioritizing these goals ) 

 

Also it will be easier to raise money for this project from non-technical folks, if they can understand what the results will be. ( Most bookkeepers eyes glaze over if I start talking about cool new MySQL table columns )

 

Can everyone give their feedback on the wiki ( in the new section at the top ) before Nov. 18 ?  Is this a realistic date? Then after Nov. 18 we can start promoting the new campaign and raise the needed funds. 

 

Thoughts? Ideas? 

 

  • Log in or register to post comments

Definitely ready to support this financially

Permalink Submitted by Robert W (not verified) on November 7, 2010 - 21:07

Especially the part about a deposit for an expensive event (i.e. http://www.studentshelpinghonduras.org/trips)

We'll keep an eye out for when the fundraising meter gets posted!

  • Log in or register to post comments

Great to see such energy!

Permalink Submitted by JoeMurray on November 8, 2010 - 06:47

I'm glad to see such interest. I'll be helping with use cases and development, and expect there may be some Canadian orgs that can assist with development and perhaps some money too. Some of there use cases are for items not identified above, but which are on the wiki and would assist many, e.g. batch add/update functionality to help with cheque entry when some but not all of the payments are from people in CiviCRM.

  • Log in or register to post comments

We can help with QB

Permalink Submitted by dharmatech on November 8, 2010 - 18:27

Great to see this topic coming up again. We did some exploratory work last year with the idea of a QuickBooks integration with CiviCRM. There was some initial interest but the project died because of lack of funding and low priority compared to our client work. We took it as far as pushing a contribution to QuickBooks w/SOAP and QBXML but stopped short of building a working prototype.

 

We would like to help with the planning and development of the QB integration. The QuickBooks PHP Dev Kit would be the logical framework to use but there may be others. It's the one we're familiar with and it really was (and may still be) the only game in town.

  • Log in or register to post comments

Please no Quickbooks integration

Permalink Submitted by Bruce Wolfe (not verified) on November 8, 2010 - 19:28

Quickbooks is too squirrelly. FWIW, using QIF files is kinda okay but since we are FLOSS here we should keep things as open standards as possible.

  • Log in or register to post comments

Quickbooks, open source

Permalink Submitted by SarahGladstone on November 8, 2010 - 20:20

QuickBooks is no more proprietary than Authorize.Net, First.Data, Pay Pal, Google Maps, Yahoo Maps or any of the other 3rd party services/products that CiviCRM already hooks into.

 

What open source accounting package do you see as being widely used? In which countries? Ideally CiviAccounts will have a structure for writing code for other accounting packages.   Also, are you aware of an open standard that supports sending data to multiple accounting packages?

  • Log in or register to post comments

QB vs others

Permalink Submitted by Eileen on November 8, 2010 - 23:11

Hi,

 

I just want to stress that there are 2 sides to this - getting CiviCRM in a state where it more logically integrates and doing the integration with other providers. The funding / enthusiasm will determine which providers are developed for but the preparatory work will need to focus on the underlying recording of transactions in CiviCRM and things like part-payments and the ways in which CiviCRM exposes that data to external systems / accepts data (likely via an API).

 

This isn't an either / or. As Sarah says there are a number of interfaces with proprietary systems in CiviCRM and we should develop CiviAccounts with the expectation that multiple providers will be integrated (eventually)

  • Log in or register to post comments

then what?

Permalink Submitted by dharmatech on November 8, 2010 - 21:53

Bruce,

 

1. What does 'too squirrelly' mean?

2. Most nonprofits use QuickBooks. What do you propose... recreate that functionality in CiviCRM? Who's going to pay for that work? Should CiviCRM step into the 'accounting software' world? Probably not.

3. Look at the QBXML specification and look at QuickBooks PHP Dev Kit, then report back about "open." With a published (and hopefully stable) API, open/close source becomes less of a technical debate and more of philosophical one.

  • Log in or register to post comments

I can help some

Permalink Submitted by Tracy Smith (not verified) on November 9, 2010 - 09:26

Hi Sarah - Thanks for pushing forward this effort. I've recently just finished a project for a non-profit that uses QuickBooks. We are using the Web Connector and the QB web framework from Keith Palmer. Essentially, I wrote a set of modules that create the XML to be passed for Customer Modifications, Sales Receipts, and Customer Additions.

I ran into a lot of nuances that I had to overcome with the way some of the Civi back end is storing items. I don't have a lot of free time between now and the end of the year, but am happy to help however I can. Please feel free to contact me.

Thanks,

Tracy

  • Log in or register to post comments

Joining CiviAccounts

Permalink Submitted by William Owyong (not verified) on November 25, 2010 - 22:00

Hi,

The company I work for would be happy to provide some input and feedback to the CiviAccounts module. We are quite keen to see a good accounting facility working within the CiviCRM framework.

Regards,
William Owyong
Programmer/Developer
Knowall Software Pty Limited

  • Log in or register to post comments

Count me in

Permalink Submitted by naveenn on January 6, 2011 - 14:09

I am CIVIC CRM newbie. But I work for a non profit part time and would like to see this accounting package built.

Count me in as an end-user. I can help with SQL a bit.

 

One request is not to tie in with Quick Books but rather look at some XML or DB based exchange.

Some non profits including us use open source or commonly available MS Office tools for accounting.

 

  • Log in or register to post comments

Is this still a Make-it-Happen?

Permalink Submitted by seGAP on January 14, 2011 - 22:16

We're currently exploring CiviCRM, and once CiviAccounts is available (at least the Multiple Payments concept) then we'll be going ahead.

 

Back in November there was talk of this being a Make-it-Happen project, but I can't find anything more recent, or how to contribute to the funding. What's the latest news?

  • Log in or register to post comments

Re: CiviAccounts

Permalink Submitted by Rod (not verified) on February 15, 2011 - 15:54

I'm interested to help as a user. -Rod

  • Log in or register to post comments

Is anything happening with this?

Permalink Submitted by JudithBarnett on July 31, 2011 - 19:04

I need this functionality for a couple of sites and am more than willing to do whatever coding is necessary to make this happen if someone will point me at the current version or status.

 

 

  • Log in or register to post comments

CIVICRM


GROWING AND SUSTAINING RELATIONSHIPS

WHAT IS CIVICRM
  • Community
  • Case Studies
  • Experts
  • Contributors
  • Core Team
  • Licensing
  • Contact Us
WILL CIVICRM MEET YOUR NEEDS?
  • Contacts
  • Contributions
  • Communications
  • Peer-To-Peer Fundraisers
  • Advocacy Campaigns
  • Events
  • Members
  • Reports
  • Case Management
GET STARTED
  • Evaluate Your CRM Needs
  • Evaluate CiviCRM Features
  • Read Books
  • Documentation
  • Demo CiviCRM
  • Download CiviCRM
  • Find An Expert
PARTICIPATE
  • Join the CiviCRM Community
  • Read Our Blog
  • Community Forum
  • Attend a Training or Meetup
  • Make It Happen
  • Contribute
  • Become A CiviCRM Developer
  • Issue Tracker
  • Help with Documentation
  • Translate