DASHSQUARED/CASE FILES
The work, on the record

Case files, not logo walls.

We publish what we can substantiate and redact the rest. Client data, donor identifiers, and financial figures never appear on this site. What you can read here is how the systems were designed, released, and handed over.

1 DECLASSIFIED5 IN DECLASSIFICATIONALL DATA REDACTED BY DESIGN
Index

Six sheets. One released.

A case file is released only after the facts in it are signed off. The rest stay sealed — we would rather show you one complete engagement than six confident summaries.

FLAGSHIP · DELIVERY

Fresh Start Community Fund

A community giving platform rebuilt end to end — payments, CRM, website, and reporting reconciled into one governed system.

→ Read the case file
SHEET 01REV ATOTAL SOLUTION2025–2026
PRODUCT

Talent Tuner

Case file in preparation. Contents withheld pending fact sign-off.

IN DECLASSIFICATION
SHEET 02REV —SEALEDPENDING
AI / PIPELINE

Document Translation

Case file in preparation. Contents withheld pending fact sign-off.

IN DECLASSIFICATION
SHEET 03REV —SEALEDPENDING
DATA / REPORTING

Analytics Stack

Case file in preparation. Contents withheld pending fact sign-off.

IN DECLASSIFICATION
SHEET 04REV —SEALEDPENDING
GIS

Enterprise GIS

Case file in preparation. Contents withheld pending fact sign-off.

IN DECLASSIFICATION
SHEET 05REV —SEALEDPENDING
PRODUCT LAB

PassPlay

Case file in preparation. Contents withheld pending fact sign-off.

IN DECLASSIFICATION
SHEET 06REV —SEALEDPENDING
SHEET 07 · UNOPENED

Your project

Every file above started as a loose description of something the business could not do. Six questions is all it takes to open the next one.

→ Build your brief
SHEET 07REV —INTAKEOPEN

WANT ONE OF THE SEALED FILES WALKED THROUGH LIVE? WE DO THAT ON A CALL, UNDER NDA WHERE THE CLIENT REQUIRES IT.

Sheet 01 · Declassified

A 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
01

Reconcile 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.

02

Re-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.

03

Redesign 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.

04

Make 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.

How releases ran

Six steps. Six signatures.

Every change moved through the same explicit sequence, and each step was separately approved. Nothing touched production donor data until the step before it was signed off.

See the full method →
  1. 01Database migration
  2. 02Secrets
  3. 03Blocked deploy
  4. 04Read-only preview
  5. 05Publication
  6. 06Controlled writes
THE ACCOUNTING BOUNDARY

Salesforce 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 MODEL

Least-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.

OPERATIONS REVIEW
HOMECLIENTSCHECK-INSCARDSSPENDFUNDSREPORTS
CLIENTS
RESOURCES
NEEDS REVIEW
Daily review path READY
Recent imports LOADED
One calm place to start the day. Custom tabs follow the review flow — no raw object lists.
SPEND REVIEW
HOMECARDSSPENDFUNDS
NEEDS REVIEW
DRAFT
REVIEWED
Spend stages as Draft / Needs Review so operational triage happens before accounting decisions. Posting stays in the ledger system — by design.
DECISION DASHBOARD
HOMESPENDREPORTS
Charts prioritize review; they never replace reconciliation. The accounting boundary is written into the interface.

INTERFACE RECREATIONS FROM THE DELIVERED WORKSPACE — ALL DATA REDACTED BY DESIGN

OUTCOME

Campaign 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.

THIS IS THE SHAPE OF A DELIVERY ENGAGEMENT

Different systems, same discipline. Tell us what the business can't do today.

Build your brief