Skip to main content

Lessons from Bona View Farm – Tractors and Databases

Last weekend we sat on our porch and watched our neighbor mow his 80 acres and the scant few acres we have.  It took him several days to mow, rake and bale the hay.  He had a process and the right equipment. By the end of the weekend we were looking out on rolling acres of freshly mown hay.  But, what’s this got to do with databases?   There are lessons we can learn …


The right tractor – The SKC staff is often asked for our recommendations for donor databases to support fundraising and communications activities.  You may do well with a push mower during the start-up phase by utilizing excel spreadsheets or an Access database.  At some point, you’ll want to step up into a database software that helps you not only manage names, addresses and donor acknowledgement letters, but also is a tool that tracks and analyzes fundraising efforts and links to your fund development plan.  When considering what product to step up to, whether it’s the tractor with the air conditioning  and GPS (Raiser’s Edge) or something mid-range like DonorPerfect - do a three year cost analysis.  Can you afford the fees now and can you sustain the cost over time?  What’s the cost of human effort to implement and maintain?


Follow the contours of the land – There is no one size fits all setup.  Give considerable thought to the database layout and the customized fields.  Who are your key stakeholders and constituents?  How do you communicate with them?  How do you track and analyze their giving?  What information do the end-users (staff and board) need to see in the reports?  Keep your database and the information you collect relevant.   Keep the information in your database secure and respect the privacy of your donors.


Mow often – Use good database “hygiene.”   Develop procedures and protocols for putting data into the system and share with staff and volunteers.  Routinely query new records and gifts added to make sure procedures are understood and being followed.  Reconcile the income recorded in your database with your accounting system each month.  If you follow these three basic recommendations, you won’t be second guessing and wondering whether the information is accurate and trustworthy a few years down the road.

At SKC, we help nonprofits develop tools that support their work.  We see good database management as an essential building block to supporting communications, transparency, and the fundraising success of your organization.   The end product may not be as pretty as a field of freshly mown hay on a crisp fall day, but it’s a critical piece of your organization’s equipment.  




Debra Box
Executive Director

Comments

Popular posts from this blog

From the Board President

I was invited to participate as a panel member in the Board Chair Boot Camp on February 3, 2009, sponsored by Nonprofit Connect. The four-hour workshop consisted of a three hour training class, led by Larry Guillot from Park University, Hauptmann School of Public Affairs, followed by a one-hour panel discussion. This is the first time this workshop has been offered: congratulations to our board member Amy Mulligan Kennedy for putting together a great program for this sellout event! Amy serves as Education and Member Services Manager for Nonprofit Connect. The other panel members were Tracy Foster, Board Chair of KCPT, Gavin Steketee, Board Chair of the Dream Factory and Jarene Stafford, Community Volunteer, which represented a wide variety of agencies and board leadership experiences. In our overview, I described some of the keys to our success at Support Kansas City, which include recruiting and developing good people, developing a commitment to planning and processes and measuring a...

33 Principles for Good Governance and Ethical Practice

I love it when someone makes my life easier! In 2007, the Independent Sector created 33 Principles for Good Governance and Ethical Practice as part of its efforts to strengthen good practices for the nonprofit sector. I use the principles as guidelines for the board development and strategic planning assistance we provide to our clients. Now The Independent Sector has teamed up with BoardSource and developed a great workbook based on the principles, The Principles Workbook: Steering Your Board Toward Good Governance and Ethical Practice. The workbook is a very practical tool, with well-developed sample worksheets that are visually appealing. Each principle has good background information, solid definitions, and focused worksheets. There is sound guidance for using the workbook. The principles are divided into four sections; legal compliance and public disclosure, effective governance, strong financial management, and responsible fund-raising. Most of the language and layout is c...

Tracking and Reporting Agency Performance

Does your nonprofit agency have a way to measure performance for your organization? Not just the financial measures, but mission delivery and the organization’s effectiveness? The tool agencies most commonly use to measure and evaluate the agency's overall performance is called a dashboard or sometimes a scorecard. Your agency performance reports should help you better lead your agency and make informed decisions. Recently, I heard two hybrid car owners with different models and years discuss how their dashboards provided information and the layout of their respective dashboards. It appeared one model had a dashboard that clearly defined the car’s performance and better reported what the engine was doing. The car owner stated simply, “because I have been monitoring what’s going on with the engine and the mileage performance, I’ve changed my driving style.” Just like your car’s dashboard, your organization’s dashboard should be designed to help monitor your agency’s performance...