From a reconciliation question to a strategic roadmap

Where they started

The first request was specific: how gifts were processed and recorded, and why development and finance struggled to reconcile them.

Committed staff were keeping things moving through extra checking, manual handoffs, spreadsheets and hard-won institutional knowledge. It worked, but it created friction and made reliable reporting much harder than it needed to be. As we looked closer, the questions grew: how was the work distributed, which information could be trusted, and could the existing processes carry the organization into its next stage?

What we foundAssess

The organization was willing to follow the evidence, and each stage widened the question. A gift-processing diagnostic led to a development capacity assessment and a presentation to the board. Leadership then asked for an assessment of the systems, data and operations supporting the whole organization.

What we found wasn’t a shortage of capable people or of investment in technology. Processes and systems built for an earlier stage of growth were carrying far more complexity than they were designed for. Each team had built practical solutions to its own needs, and together those solutions had become a patchwork: partial integrations, shadow spreadsheets, different definitions for the same data, no clear system of record, manual reconciliation, and know-how concentrated in a few people.

Each department could see and solve its own problem. Few people could see the full journey of information, from gift entry to accounting and from daily operations to impact reporting. Local fixes that made sense on their own only showed their combined cost when we interviewed people across every department and mapped how information actually moved.

Where they were headingAlign

Working with leaders and frontline staff across development, finance, operations, programs and administration, the assessment set out a shared, phased path toward trustworthy information and operations that can grow:

• A clear system of record for each kind of information
• Consistent data ownership and definitions
• A dependable development and finance reconciliation
• Less duplicate entry, and stronger connections between systems
• Clear reporting standards, and a governance model for decisions that cross departments

What we builtBuild

• A gift-processing and reconciliation diagnostic pinpointing the friction between fundraising and accounting
• A development capacity assessment, turning day-to-day symptoms into staffing, workflow and strategy decisions, presented to the board
• Organization-wide discovery: interviews, maps of how work and data flow, and a review of the main software platforms and how they depend on each other
• A cross-departmental systems assessment documenting workarounds, shadow systems, fragile integrations, reporting gaps and risks
• A phased roadmap: stabilize and set governance first, then connect the systems, then build reporting and analytics, then plan for long-term growth

What changedStrengthen

For the first time, leadership has one documented picture of how information moves across the organization, where work depends on manual effort, and which governance and technology decisions need to come before any further investment.

That picture gives them a basis for sequencing the work, assigning accountability, and judging any modernization proposal against shared priorities. The assessment has already shaped a multi-year modernization plan.