From spreadsheet chaos to consolidated stewardship reporting in 90 days
National Church Network (12 parishes)
- Duration
- 14 weeks to go-live, ongoing monthly close
- Team
- Partner, 2 fund accountants, 1 systems consultant
- Scope
- 12 parishes, 4 restricted funds, 38 givers' categories
- Region
- Nigeria (multi-state)
Client challenge
Twelve autonomous parishes reconciled tithes and offerings on disconnected spreadsheets. The board could not answer basic stewardship questions and external audit findings were repeating year over year.
The starting position
Each parish had grown its own bookkeeping habits over two decades. Tithes, project offerings and welfare funds were recorded in parallel spreadsheets that were never reconciled to bank. Trustees received twelve different report formats — none of which could be added together with confidence — and the external auditor repeated the same management-letter points three years running.
What we actually changed
We rebuilt a single chart of accounts with parish classes and restricted-fund tracking, then migrated three years of opening balances into one QuickBooks Online Advanced tenant. Contribution management was integrated so that every giving record flows to the ledger without re-keying. Most importantly, we replaced ad-hoc reporting with a published close calendar: bank reconciliation by day 3, parish review by day 5, partner sign-off by day 6, board pack by day 7.
Why it stuck
Treasurers were trained on their own live data, not a demo file, and each parish kept ownership of its numbers while Soteria owned the consolidation and the review. Quarterly stewardship sessions with the trustees turned reporting into a governance rhythm rather than a compliance chore.
Our solution
Deployed a unified chart of accounts, restricted-fund tracking and a shared QuickBooks Online tenant with parish-level classes. Instituted a monthly close calendar with partner-level review before board release.
Business outcome
Board now receives a consolidated stewardship pack by the 7th of every month. External audit issued a clean opinion with zero management-letter points in the first full year.
- 1
Week 1–2: Diagnostic, fund mapping and stakeholder interviews with senior pastors and treasurers.
- 2
Week 3–6: Chart of accounts rebuild, opening balance migration, contribution-management integration.
- 3
Week 7–10: Parallel run, treasurer training and dashboard rollout to the board of trustees.
- 4
Week 11+: Monthly close operated by Soteria virtual accounting team with quarterly stewardship review.
single tenant, class-level reporting
fully reconciled to bank
live-data workshops
every month, without exception
since go-live
fewer auditor queries
| Metric | Before Soteria | After Soteria |
|---|---|---|
| Close cycle | 22 days | 5 days |
| Fund reporting accuracy | 82% | 99.6% |
| Audit findings | 14 | 0 |
| Trustee reporting SLA | 36% | 100% |
"For the first time in a decade our trustees can see every parish on one page. Soteria brought discipline without bureaucracy."
We can run this playbook for your churches organisation.
In a 45-minute confidential briefing, the partner who led this engagement will benchmark your current numbers, identify the three fastest sources of value and give you a written scope with fixed fees — at no cost.
- Partner-led, not junior-staffed
- Fixed-fee scope before we start
- First results inside 90 days
- NDA signed before any data moves
Recovered 22% of unbilled tuition and rebuilt the school's finance operating model
Premium Secondary School Group
Read case studyHospitalsCut HMO claim leakage by 38% and shortened the revenue cycle from 74 to 31 days
Multi-specialty Tertiary Hospital
Read case studyNGOsPassed a USAID compliance audit with zero questioned costs on a $12m grant portfolio
International Development NGO
Read case study