Back to Case Studies

Embedding Financial Compliance Directly Into the System

Foundation Internal Control Design

Grants were being recommended and disbursed, but financial controls relied on staff remembering to check thresholds and documentation before every payment. I made compliance structural instead of dependent on vigilance.

Results at a Glance

800+

Disbursements / Year

Zero

Audit Findings

~180 hrs

Saved / Year

The Challenge

Every control depended on attention, and attention fails under pressure.

  • Was a W-9 on file?
  • Had this payee crossed the IRS reporting threshold?
  • Was the amount high enough to require executive approval?
  • Had a budget change been formally approved before overspending?

The Approach

  • Threshold enforcement: the system tracks year-to-date payable totals by Account and blocks disbursement when IRS reporting thresholds are approached and documentation is missing
  • Multi-level approval routing: amounts route automatically based on thresholds, sending high amounts to VP/CEO approval
  • Budget governance: payments exceeding approved budget lines require Budget Change records with their own approval chain
  • Payment infrastructure: approved payments sync automatically to Bill.com with inherited parent data

Salesforce Objects & Tools

Year-to-date payable tracking Threshold-based disbursement blocking Multi-level approval routing Budget Change records Bill.com payment sync

Results

  • Embedded structural compliance into every transaction, blocking payments missing W-9s or exceeding thresholds across 800+ disbursements per year
  • Produced a complete, auditable trail for every financial decision, resulting in zero findings in the last two external audits
  • Eliminated repetitive manual oversight, saving the finance team roughly 180 hours per year

FAQ

Have a Salesforce system that needs this kind of work?

Let's talk about how I can bring the same clarity, stability, and structured thinking to your organization's Salesforce.

Related case study: Rebuilding a Grantmaking System, From Intake to Disbursement