Bilanz · systems switch
Donor database, website or accounting system: most small organizations switch too late, or pick the tool before the need. I start with a fit analysis, move every record, prove the totals still tie, and hand over a routine your staff can run. Any direction: DonorPerfect, Bloomerang, Givebutter, Zeffy, Little Green Light, WordPress, QuickBooks, Sage and the rest.
Step 1
What you actually need, compared across the realistic options, with a plain recommendation. Staying put is a valid answer.
Step 2
Export, clean up, merge duplicates, keep the old lists, import, and tie every total back to the old system and your books.
Step 3
A short staff guide, a parallel run, a cutover date, and a routine for what goes to your bookkeeper and board.
You end up owning it. Every switch closes with the organization holding its own admin logins, domain, DNS and data exports, not a vendor or a former volunteer.
Step 1 · Fit analysis
Birchwood needs year-end mailed appeals, online gifts, an annual gala, capital campaign pledge tracking, and something one part-time staff member can run. Scores are illustrative for this fictional scenario; vendor features and pricing change, so a real analysis is checked against each vendor at the time.
| Option | Records & reports | Online giving | Pledges & campaigns | Ease for staff | Fit for Birchwood |
|---|---|---|---|---|---|
| Bloomerang Donor CRM built around retention; annual subscription | ●●●● | ●●●● | ●●●● | ●●●● | Recommended: strongest for keeping campaign donors and tracking pledge payments |
| Givebutter Online giving, events and CRM; free with optional donor tips | ●●●● | ●●●● | ●●●● | ●●●● | Strong online and gala tools; lighter on pledge schedules |
| Zeffy Free online giving and events, funded by donor contributions | ●●●● | ●●●● | ●●●● | ●●●● | Lowest cost; Birchwood would keep mailed-appeal work outside it |
| Little Green Light Donor database with flexible reporting; annual subscription | ●●●● | ●●●● | ●●●● | ●●●● | Good records, but online giving needs a separate form |
| Stay on DonorPerfect Current system; annual subscription | ●●●● | ●●●● | ●●●● | ●●●● | Fine on paper, but staff use a fraction of it |
Step 2 · What the data says
Every donor system has reports. Few of them tell a board what the numbers mean. This is the report built from your data, in any system: who gives, how, through which lists, and what it means. Totals only, no names. Boards get a one-page version of it every quarter.
From the donor database export of November 2026. Totals only; no individual donors are named. Gifts recorded FY2008 through FY2026 (fiscal years end June 30).
capital campaign years after the campaign
| Fiscal year | Gifts | Donors | Total |
|---|---|---|---|
| FY2021 | 605 | 488 | $748,000 |
| FY2022 | 776 | 641 | $962,000 |
| FY2023 | 897 | 743 | $1,288,000 |
| FY2024 | 903 | 736 | $1,457,000 |
| FY2025 | 711 | 572 | $1,183,000 |
| FY2026 | 604 | 487 | $1,120,000 |
| Donors active in the last 3 years | 920 |
|---|---|
| Have an email address | 667 (72%) |
| Have a good mailing address | 893 (97%) |
| Lapsed (no gift in 3 years) | 1,721 |
| Records with no gift on file | 343 |
| Marked "do not mail" | 246 |
|---|---|
| No forwarding address | 116 |
| Bad address | 68 |
| Deceased | 45 |
| Requested no mail | 17 |
| List | Donors | Active | Last 3 yrs | Lifetime | |
|---|---|---|---|---|---|
| Foundations | 35 | 13 | 18 | $1,676,070 | $4,793,390 |
| Capital campaign | 297 | 132 | 128 | $925,150 | $2,544,020 |
| Neighbors & Friends | 976 | 282 | 497 | $335,175 | $1,345,860 |
| Corporate partners | 39 | 10 | 26 | $220,250 | $924,250 |
| Faith partners | 436 | 157 | 244 | $244,240 | $914,245 |
| Gala guests | 513 | 136 | 262 | $127,305 | $694,020 |
| Riverside mailing | 444 | 110 | 221 | $103,035 | $428,220 |
| (no list) | 121 | 46 | 66 | $67,680 | $211,900 |
| Board & volunteers | 123 | 34 | 56 | $61,095 | $188,095 |
| Gift | Gifts | % | Dollars | % |
|---|---|---|---|---|
| Under $50 | 124 | 6% | $4,275 | 0% |
| $50 to $99 | 251 | 11% | $17,950 | 0% |
| $100 to $249 | 623 | 28% | $103,535 | 3% |
| $250 to $499 | 526 | 24% | $185,050 | 5% |
| $500 to $999 | 338 | 15% | $231,690 | 6% |
| $1,000 to $4,999 | 252 | 11% | $503,925 | 13% |
| $5,000 and up | 104 | 5% | $2,713,575 | 72% |
| Method | Gifts | % | Dollars |
|---|---|---|---|
| Check | 1,289 | 58% | $2,066,910 |
| Online card | 497 | 22% | $250,255 |
| Donor-advised fund | 236 | 11% | $395,125 |
| Cash | 94 | 4% | $42,995 |
| Stock | 71 | 3% | $335,120 |
| ACH / wire | 31 | 1% | $669,595 |
| Lifetime total | Donors | Dollars | % |
|---|---|---|---|
| $25,000 and up | 72 | $7,024,310 | 58% |
| $10,000 to $24,999 | 101 | $1,624,390 | 13% |
| $1,000 to $9,999 | 997 | $2,809,590 | 23% |
| $250 to $999 | 935 | $512,850 | 4% |
| Under $250 | 536 | $72,860 | 1% |
The 10 largest donors account for 28% of all recorded giving; the top 50 for 52%.
Birchwood Community Housing, Inc. and all figures are fictional. Prepared as a Bilanz work sample.
Step 2 · Proof
Nothing goes live until the new system matches the old one to the cent and the books agree.
| Check | Old system | New system | Result |
|---|---|---|---|
| Lifetime giving, all gifts | $12,044,000 | $12,044,000 | Ties |
| FY2026 giving | $1,120,000 | $1,120,000 | Ties |
| FY2026 vs. Statement of Activities, contributions and private grants | $1,120,000 | $1,120,000 | Ties to the books |
| Mailing lists carried over as tags | 9 lists | 9 tags | Complete |
| Do-not-mail and deceased flags | 246 | 246 | Complete |
Step 3 for Birchwood: a two-page staff guide, both systems in parallel through December, cutover January 1, and year-end giving letters from the new system.
Steps 1 to 3
Birchwood's old site ran on a plugin-heavy WordPress install managed by an outside vendor. The move kept every page people search for, added online giving, and put the domain in Birchwood's name.
| Before | After | |
|---|---|---|
| Hosting | Managed server, monthly fee, vendor-only access | Static hosting at no cost, staff can update text |
| Giving | "Mail a check" page and a PDF form | Embedded donation form with Apple Pay, monthly giving and campaign page |
| Speed and security | Slow on phones; 30+ plugins to patch | Loads in about a second; nothing to patch; HTTPS and security headers on |
| Old links | Links in old emails and grant reports | Every old address redirects to its new page; the old site kept as an archive |
| Ownership | Domain and DNS held by the vendor | Domain, DNS and admin logins held by Birchwood, two board-approved admins |
Email kept working through the switch: the move only changed where the website points, not where mail goes.
Step 1 · Fit
Birchwood had outgrown tracking programs and grants with QuickBooks classes and spreadsheets. The fit analysis weighed grant tracking, restricted net assets, multi-entity needs, board reporting and what the outside accountant supports. Bilanz runs the process and the tie-out; the client's bookkeeper or accounting firm keeps doing the entries.
Step 2 · Chart of accounts mapping (excerpt)
| Old account and class | New account | Program | Funding source |
|---|---|---|---|
| 4010 Donations · class Housing | 4100 Contributions, individuals | Rental housing | Without restrictions |
| 4015 Capital campaign | 4150 Contributions, capital | Real estate development | With restrictions, purpose |
| 4200 Grants · class HOME | 4310 Federal grants | Rental housing | HOME award |
| 4210 Grants · class State | 4320 State grants | Supportive services | State housing grant |
| 6100 Salaries · all classes | 6100 Salaries | By timesheet | Allocated |
| 6900 Misc expense | Reviewed line by line, closed | — | — |
Step 2 · Opening balance tie-out at July 1, 2026
Step 3: a month-end close checklist, a board report pulled straight from the new system, and the bookkeeper trained before the first close.
A 30-minute call is usually enough to tell whether you need a new system or just a cleanup of the one you have.
Birchwood Community Housing, Inc. and all figures are fictional. Vendor names are used for illustration; Bilanz is independent of all vendors and is not paid by them.