Reports¶
CalcBridge provides comprehensive reporting capabilities for compliance documentation, portfolio analysis, and stakeholder communication. This guide covers report types, generation, customization, export options, and scheduling.
Overview¶
Reports in CalcBridge transform your calculation and compliance data into professional, actionable documents for trustees, regulators, and internal stakeholders.
Key Capabilities¶
| Capability | Description |
|---|---|
| Multiple Formats | Export to PDF, Excel, CSV, or JSON |
| Customizable | Configure content, layout, and branding |
| Scheduled | Automate recurring report generation |
| Audit-Ready | Complete data lineage and timestamps |
| Shareable | Secure links for external sharing |
Available Report Types¶
Compliance Reports¶
| Report | Description | Use Case |
|---|---|---|
| Compliance Summary | Pass/fail status for all tests | Executive overview |
| Detailed Compliance | Full test results with calculations | Trustee submission |
| Cushion Analysis | Distance to breach for each test | Risk monitoring |
| Historical Trend | Compliance status over time | Trend analysis |
| Breach Report | Details on failed tests | Issue investigation |
Portfolio Reports¶
| Report | Description | Use Case |
|---|---|---|
| Portfolio Summary | Key metrics and composition | Daily review |
| Holdings Detail | Complete holdings list | Audit support |
| Concentration Analysis | Exposure by obligor, industry | Risk management |
| Rating Distribution | Portfolio by rating bucket | Quality monitoring |
| Cash Flow Projection | Expected cash flows | Liquidity planning |
What-If Reports¶
| Report | Description | Use Case |
|---|---|---|
| Scenario Comparison | Before/after for scenarios | Trade approval |
| Impact Analysis | Detailed trade impact | Decision support |
| Multi-Scenario Matrix | Compare multiple scenarios | Portfolio optimization |
Audit Reports¶
| Report | Description | Use Case |
|---|---|---|
| Calculation Audit | Formula details and results | Audit support |
| Change Log | All modifications to workbooks | Compliance documentation |
| User Activity | Actions by user | Security review |
| Data Lineage | Source to result tracking | Regulatory inquiry |
Generating Reports¶
Via UI¶
- Navigate to Reports in the main menu
- Select the report type
- Choose the workbook or scenario
- Click Generate
- Download when ready
- Navigate to Reports > New Report
- Select report type
- Configure options:
- Date range
- Workbooks to include
- Sections to include
- Format options
- Preview the report
- Click Generate
- Download when ready
Via API¶
# Generate a compliance summary report
curl -X POST https://api.calcbridge.io/api/v1/reports/generate \
-H "Authorization: Bearer $TOKEN" \
-H "Content-Type: application/json" \
-d '{
"report_type": "compliance_summary",
"workbook_id": "550e8400-e29b-41d4-a716-446655440000",
"format": "pdf",
"options": {
"include_charts": true,
"include_recommendations": true
}
}'
Response:
Check Report Status¶
curl -X GET https://api.calcbridge.io/api/v1/reports/{report_id} \
-H "Authorization: Bearer $TOKEN"
Response (when ready):
{
"report_id": "rpt_abc123",
"status": "ready",
"download_url": "https://api.calcbridge.io/api/v1/reports/rpt_abc123/download",
"expires_at": "2025-01-16T10:30:00Z",
"metadata": {
"format": "pdf",
"pages": 12,
"size_bytes": 245678
}
}
Customizing Reports¶
Report Sections¶
Most reports allow you to include or exclude sections:
| Section | Description |
|---|---|
| Executive Summary | High-level overview and key findings |
| Test Results | Detailed pass/fail status |
| Calculations | Formula breakdowns |
| Charts | Visual representations |
| Data Tables | Raw data in tabular format |
| Recommendations | Suggested actions |
| Appendix | Supporting details |
Example - Custom sections:
curl -X POST https://api.calcbridge.io/api/v1/reports/generate \
-H "Authorization: Bearer $TOKEN" \
-H "Content-Type: application/json" \
-d '{
"report_type": "detailed_compliance",
"workbook_id": "...",
"format": "pdf",
"sections": [
"executive_summary",
"test_results",
"charts",
"recommendations"
]
}'
Filtering and Grouping¶
Control what data appears in reports:
| Filter | Description | Example |
|---|---|---|
| Date Range | Filter by date | 2025-01-01 to 2025-01-31 |
| Status | Filter by test status | failed only |
| Category | Filter by test category | concentration tests |
| Threshold | Filter by cushion level | Cushion < 5% |
Example - Filtered report:
curl -X POST https://api.calcbridge.io/api/v1/reports/generate \
-H "Authorization: Bearer $TOKEN" \
-H "Content-Type: application/json" \
-d '{
"report_type": "breach_report",
"workbook_id": "...",
"format": "pdf",
"filters": {
"status": ["failed", "warning"],
"cushion_threshold": 5.0
}
}'
Branding¶
Customize report appearance with your organization's branding:
| Option | Description |
|---|---|
| Logo | Organization logo in header |
| Colors | Primary and secondary colors |
| Footer | Custom footer text |
| Disclaimer | Legal disclaimer text |
Configure branding in Settings > Organization > Report Branding.
Exporting Reports¶
Available Formats¶
| Format | Extension | Best For |
|---|---|---|
.pdf | Trustee submission, archival | |
| Excel | .xlsx | Data analysis, further processing |
| CSV | .csv | Data integration, simple analysis |
| JSON | .json | API integration, programmatic use |
| HTML | .html | Web viewing, email embedding |
Download Reports¶
- Navigate to Reports > History
- Find the report
- Click the download icon
- Select format if multiple available
Sharing Reports¶
Share reports with external stakeholders:
- Generate the report
- Click Share on the report
- Configure sharing options:
- Expiration date
- Password protection (optional)
- Download limit (optional)
- Copy the secure share link
- Send to recipients
Share Link Security
Share links provide access without authentication. Always set appropriate expiration dates and use password protection for sensitive reports.
Scheduled Reports¶
Automate recurring report generation with schedules.
Creating a Schedule¶
- Navigate to Reports > Schedules
- Click New Schedule
- Configure:
- Report type
- Workbooks to include
- Format
- Frequency (daily, weekly, monthly)
- Time
- Recipients
- Click Create Schedule
curl -X POST https://api.calcbridge.io/api/v1/reports/schedules \
-H "Authorization: Bearer $TOKEN" \
-H "Content-Type: application/json" \
-d '{
"name": "Weekly Compliance Report",
"report_type": "compliance_summary",
"workbook_id": "...",
"format": "pdf",
"schedule": {
"frequency": "weekly",
"day_of_week": "monday",
"time": "08:00",
"timezone": "America/New_York"
},
"delivery": {
"email": ["compliance@example.com", "trustee@example.com"],
"include_attachment": true
}
}'
Schedule Frequencies¶
| Frequency | Options |
|---|---|
| Daily | Time of day |
| Weekly | Day of week, time |
| Monthly | Day of month, time |
| Quarterly | Month, day, time |
| Custom | Cron expression |
Managing Schedules¶
| Action | Description |
|---|---|
| Pause | Temporarily stop schedule |
| Resume | Reactivate paused schedule |
| Edit | Modify schedule settings |
| Run Now | Trigger immediate generation |
| Delete | Remove schedule permanently |
Report History¶
Access all generated reports:
- Navigate to Reports > History
- Filter by:
- Date range
- Report type
- Status
- Creator
- View report details
- Download or share
Reports are retained based on your subscription tier:
| Tier | Retention |
|---|---|
| Free | 30 days |
| Standard | 90 days |
| Premium | 1 year |
| Enterprise | Custom |
Report Templates¶
Create reusable report templates for consistent reporting.
Creating a Template¶
- Navigate to Reports > Templates
- Click New Template
- Configure:
- Base report type
- Default sections
- Default filters
- Branding options
- Save the template
Using a Template¶
- Click New Report
- Select From Template
- Choose the template
- Modify as needed
- Generate
Best Practices¶
For Trustee Reports¶
- Use Detailed Compliance report type
- Include all test results and calculations
- Add executive summary for quick review
- Include historical trend for context
- Generate in PDF format for archival
For Internal Review¶
- Use Compliance Summary for quick checks
- Export to Excel for further analysis
- Include charts for visual communication
- Schedule daily generation for monitoring
For Audit Support¶
- Use Calculation Audit report type
- Include full data lineage
- Generate in multiple formats (PDF + JSON)
- Retain reports per audit requirements
- Document report generation in audit trail