Inheriting Confusion in Fundraising: Strategies for Database Cleanup | npENGAGE

Inheriting Confusion in Fundraising: Strategies to Cope with Database Cleanup

By on Aug 28, 2017


Database Cleanup

It’s probably happened to anyone who has changed jobs in fundraising a few times – you inherit files that are less than helpful. The details of a deferred gift aren’t complete, who to contact regarding a fundraising agreement are vague, details of donor meetings are sketchy, or any other number of things that can slow you down.

I’ve recently been dealing with “inherited” files, and occasionally it has felt overwhelming. Working with someone else’s filing system – paper or electronic – is frustrating when you’re eager to get to work but first have to figure out what’s what. It also can be embarrassing if you contact the wrong person or ask a question that isn’t appropriate to the situation.

Here are some of the coping strategies I’ve used during a database cleanup:

  1. Don’t purge files too soon, but go through them and put the contents in date order and dispose of any obvious duplicates (if needed). Investing the time to sort and scan the paper trail helps affix at least a broad scope of information in your mind.
  2. As you review files and identify contacts, put a list of names, emails and numbers in the front. If you’re new and you can’t figure out who is the right contact, don’t be embarrassed. Just make a call and start asking. (I recently did this and started out the call by saying, “I know I sound clueless, but…” The end result? A receptionist who was laughing and went out of the way to help me.
  3. As you sort files or review invoices, make a list of every person or organization with whom it appears you have a contract or agreement. Include what services are provided, when the contract expires (or cancellation terms if it is open-ended), terms and cost, and who the main contact is. If you find that there are contractors that have no written agreements, make it a priority to get that resolved. This can often be a cost-savings as there may be lower costs available due to revised services being offered or economies of scale. It never hurt to ask.
  4. Keep a running list of what you need to do in terms of bigger things like writing policies or procedures or revamping a program. While something might not be a high priority, writing it down or adding it to an electronic list lets you deal with it when you can, and keeps it percolating in your mind. You may stumble on a solution in an unlikely place or when you are not looking specifically for it.
  5. Celebrate your wins. Going through 100 files and sorting them so you can find what you need when you need it may not seem like a bragging-worthy event, but taking time to “pat yourself on the back,” however you do that (I find a latte helps), can keep you from growing discouraged when you’re facing the next situation and thinking, “If only I knew the background…”

“Organization” can seem like a waste of time until you’re wasting time due to a lack of organization. But taking time to make the inherited files work for you will likely accelerate your success in fundraising.


Pamela Barden, CFRE, is a Direct Response Fundraising Strategist and Copywriter. With a professional career in strategic fundraising that spans 35 years, Pamela brings a wealth of experience and knowledge to working with nonprofit organizations.  She specializes in writing fundraising copy, P.R. materials and instructional articles, as well as developing and executing fundraising strategy.

As Vice President and Group Director at Russ Reid (2006–2009), she was responsible for the management of the largest single account for this marketing agency specializing in nonprofit fundraising.  Her nonprofit experience includes leading the fundraising work for International Fellowship of Christians and Jews (2001–2006); World Relief Corporation (1988–2001) and Youth for Christ/USA (1979–1988).

Pamela is a Certified Fundraising Executive (CFRE), an Advisory Panel Member for Rogare: The Fundraising Think Tank of the Centre for Sustainable Philanthropy at Plymouth University, winner of a Gold Award for Fundraising Excellence and an ECHO Award from the DMA, a Distinguished Instructor for UCLA Extension, adjunct instructor at University of La Verne and a weekly columnist for “Today in Fundraising.”

Leave a Reply

Your email address will not be published. Required fields are marked *