Sheet 01 · DeclassifiedA community giving platform, rebuilt end to end.
Donations in Stripe, operations in spreadsheets, a half-adopted Salesforce org, and a live website nobody could safely change. The core problem was not any single system — it was the absence of a reconciled source of truth and a safe way to make changes.
Real money. Live traffic. Zero cowboy deploys.
SHEET 01 · ENGAGEMENT SPECIFICATION
- CLIENT
- Fresh Start Community Fund
- ENGAGEMENT
- Concept-to-operations delivery
- PERIOD
- 2025–2026
- SYSTEMS OF RECORD
- Stripe · Salesforce · QuickBooks · PEX · public website
- DISCIPLINES
- Web platform · CRM · payments · integration · reporting · release governance
- DATA POSTURE
- Donor identifiers pseudonymized · reconciliation strictly read-only
- FIGURES
- Withheld — impact measures are the client's to publish
SHEET 01REV ATOTAL SOLUTION2025–2026
01Reconcile before you build
Nothing was designed until every system of record agreed with every other one. Payments, CRM records, the accounting ledger, and card controls were reconciled first — read-only, with donor identifiers pseudonymized throughout. Reconciliation is not a prerequisite we bill around; it is the only way to know what the system actually does today.
02Re-baseline the live site
The public site could not be changed safely because no one could say with certainty what was running. We re-established a pinned, verified source-control baseline so changes became possible again — and reversible. Campaign publication moved from a hope to a procedure.
03Redesign the CRM around the operation
The Salesforce org was rebuilt around how the organization actually works: a daily review path, custom tabs that follow the review flow, and no raw object lists in front of non-technical staff. We solved the operating problem, not the field layout.
04Make every integration idempotent
Duplicate donation records were prevented structurally, not by cleanup jobs. Every integration write carries a stable external key, so a retried or replayed sync updates the existing record instead of creating a second one. A duplicate financial record can never be produced by a retry.
THE ACCOUNTING BOUNDARYSalesforce became the operational review layer. QuickBooks remained the accounting source of truth and PEX remained the source of truth for card controls. Spend staged as Draft / Needs Review so operational triage happened before any accounting decision. The boundary is written into the interface, not into a policy document nobody reads.
SECURITY MODELLeast-privilege integration identities. Field-level allowlists on what each sync could read or write. Per-function secrets. A full audit ledger recording every sync request. Donor identifiers pseudonymized throughout the reconciliation work, which was strictly read-only.
OUTCOMECampaign publication, fund tracking, and reporting now run as one governed system, with documentation the organization's own non-technical staff use daily. The engagement ended the way we want every engagement to end: the client's team operating the system without us.