How Cygnum Capital replaced Excel with automated compliance
Cygnum Capital is a private debt fund manager specializing in African development finance. They manage 7 investment funds lending to 191+ borrowers across 25+ countries. This is how they moved from spreadsheet-based compliance tracking to CapitalBridge in 4 weeks.
Cygnum Capital at a glance
Cygnum Capital raises capital from institutional investors (pension funds, DFIs, family offices), pools it into investment funds, and lends to companies across Africa. Each fund has its own investment mandate, risk profile, and reporting obligations.
| Fund | Focus | Borrower Types |
|---|---|---|
| AATIF | Agriculture & Trade | FIs on-lending to agribusiness, direct crop producers, commodity traders |
| ALCBF | Local Currency | Banks, MFIs, housing finance, infrastructure, telecoms |
| OGF | Off-Grid / Clean Energy | Solar home system distributors, renewable energy companies |
| FAY | Energy & Infrastructure | Power producers, energy utilities, infrastructure developers |
| AGG | Agriculture | Agricultural companies, commodity supply chains |
| FEI | Financial Inclusion | MFIs, fintechs, micro-lending institutions |
| LCBF | Local Currency Bond | Banks and financial institutions (local currency lending) |
Two types of borrowers, two types of risk
Banks, MFIs, and lending companies that borrow from Cygnum's funds and on-lend to smaller borrowers. Key metrics: PAR30, PAR90, Capital Adequacy Ratio, gearing. Concentrated in ALCBF and AATIF funds.
Operating businesses that use loans for their own operations: agriculture, manufacturing, energy, commodity trading. Key metrics: DSCR, revenue growth, gross margin. Concentrated in AATIF and OGF funds.
What the Cygnum team was dealing with
Before CapitalBridge, Cygnum's compliance team spent the bulk of every quarter on manual data collection, email follow-ups, and spreadsheet reconciliation across 7 separate fund workbooks.
7 investment portfolios across emerging markets
Each portfolio tracked in its own Excel workbook with different column structures, naming conventions, and versioning approaches.
191+ counterparties submitting quarterly financials
Submissions arrived via email attachments in different formats. No standardized templates, no central intake system.
Compliance tracked in Excel spreadsheets per portfolio
No consolidated view. The COO reviewed seven separate files each week to understand the overall compliance picture.
Manual email chasing for every submission
Staff sent reminder emails individually. Follow-up threads buried in inboxes. No escalation automation.
Covenant breaches discovered after the fact
DSCR, LTV, and ICR calculations done manually in spreadsheets. Threshold violations found during quarterly reviews, not in real time.
120+ hours per quarter on compliance admin
Two full-time staff members spent the majority of each quarter on data collection, reconciliation, and reporting instead of analysis.
What was implemented
CapitalBridge was configured with the organization's exact portfolio structure, sector hierarchies, and reporting requirements. Live submissions started in week 4.
Cascading assignment rules across all 7 portfolios
4-level scope hierarchy: portfolio-wide defaults, sector overrides, sub-sector refinements, and counterparty-specific exclusions. One configuration, consistent enforcement.
27 reporting requirement types configured
AFS, QMA, compliance certificates, ESG reports, and portfolio quality metrics. Each type assigned to the right counterparties automatically based on sector and deal structure.
Counterparty self-service portal deployed
191+ counterparties invited to their own portal. Clear deadlines, document upload, financial data entry, and compliance score visible on login.
7-tier automated escalation reminders
Notifications at 7 days before, due date, +1, +3, +7, +14, and +30 days overdue. No manual follow-up required.
Real-time covenant monitoring with early warning
DSCR, LTV, and ICR auto-calculated on submission. Threshold + headroom monitoring with three-state indicators: Compliant, At Risk, Non-Compliant.
Daily FX sync for all currencies
Spot and forward rates synced daily. Counterparty values in CFA, KES, NGN, ZAR, IDR auto-converted to USD for consolidated portfolio reporting.
Before and after
The Manual Trap
Automated Oversight
27 reporting types, configured in week 1
Each reporting requirement has a default frequency and due date offset. Cygnum's compliance team configured which requirements apply to which borrowers using the cascading assignment engine: set it at the fund level, override at the sector level, exclude specific borrowers where needed.
| Code | Requirement | ||
|---|---|---|---|
| AFS | Audited Financial Statements | ||
| QMA | Quarterly Management Accounts | ||
| CC | Compliance Certificate | ||
| FCC | Financial Covenants Calculations | ||
| ESAP | ESAP Status | ||
| SEMR | Social & Environmental Monitoring | ||
| SEIR | Social & Environmental Impact | ||
| PAR30 | Portfolio at Risk 30 | ||
| PAR90 | Portfolio at Risk 90 | ||
| DSRA | DSRA Certificate | ||
| OR | Operational Report | ||
| FM | Financial Model | ||
| BUDGET | Annual Budget | ||
| INS | Insurance Schedule | ||
| + 13 more: AMA, QFS, ALPR, RCS, TR, CR, NDER, ESLR, IMR, RC, AIR, AATIF, SAR | |||
How cascading assignments work
Fund level
Default rules for all borrowers in a fund. "Every AATIF borrower submits QMA quarterly."
Sector level
Override for a sector. "Financial Institutions in ALCBF also submit PAR30 monthly."
Sub-sector level
Refinement by sub-sector. "Housing finance FIs get DSRA Certificate instead of standard CC."
Borrower level
Specific exclusions or additions. "Borrower X is exempt from ESAP reporting." Most-specific scope always wins.
What runs automatically
Five background jobs keep the system current without manual intervention.
4 weeks from kickoff to live submissions
Not a proof of concept. Not a pilot. Full production deployment across all 7 funds, 191+ borrowers, and 27 reporting types.
Portfolio structure & configuration
All 7 funds created with their sector/sub-sector hierarchies. FI vs DIC classification applied. 27 reporting requirements configured with cascading assignments at fund, sector, and sub-sector levels. Covenant thresholds set for DSCR, LTV, and ICR.
Borrower import & deal mapping
191+ borrowers imported with their fund deal associations, country allocations, committed amounts, and drawdown positions. Multi-currency deals mapped (CFA, KES, NGN, ZAR, IDR, and 15+ other currencies). Borrower groups configured for parent-subsidiary consolidated reporting.
Form templates & testing
Financial data entry templates created for DIC and FI borrower types. Revenue, EBITDA, DSCR, LTV, and other financial metrics configured with formulas and validation rules. End-to-end testing of submission workflows, escalation emails, and covenant calculations.
Go-live & first submissions
Background jobs activated: submission scheduling (90-day lookahead), escalation reminders, FX rate sync. Borrower portal opened to all 191+ counterparties. First round of compliance submissions created automatically. Cygnum's team trained on the fund manager dashboard.
"Seven funds. 191 borrowers across 25 countries. 27 reporting types. Five automated jobs running daily. One person reviews the dashboard each morning. That is the entire compliance operation now."
See how it works with your portfolio structure
Book a 30-minute demo. We configure it with your actual portfolios, categories, and counterparties so you see exactly how CapitalBridge fits. No generic product tour. You talk to the team that built it.
"The gap between a $200K enterprise platform and a shared spreadsheet should not be this wide. We built the thing that belongs in that gap."