Skip to content

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

  1. Navigate to Reports in the main menu
  2. Select the report type
  3. Choose the workbook or scenario
  4. Click Generate
  5. Download when ready
  1. Navigate to Reports > New Report
  2. Select report type
  3. Configure options:
    • Date range
    • Workbooks to include
    • Sections to include
    • Format options
  4. Preview the report
  5. Click Generate
  6. 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:

{
  "report_id": "rpt_abc123",
  "status": "generating",
  "estimated_duration_seconds": 30
}

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

  1. Navigate to Reports > History
  2. Find the report
  3. Click the download icon
  4. Select format if multiple available
# Download PDF
curl -X GET https://api.calcbridge.io/api/v1/reports/{report_id}/download \
  -H "Authorization: Bearer $TOKEN" \
  -o report.pdf

# Download as Excel
curl -X GET https://api.calcbridge.io/api/v1/reports/{report_id}/download?format=xlsx \
  -H "Authorization: Bearer $TOKEN" \
  -o report.xlsx

Sharing Reports

Share reports with external stakeholders:

  1. Generate the report
  2. Click Share on the report
  3. Configure sharing options:
    • Expiration date
    • Password protection (optional)
    • Download limit (optional)
  4. Copy the secure share link
  5. 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

  1. Navigate to Reports > Schedules
  2. Click New Schedule
  3. Configure:
    • Report type
    • Workbooks to include
    • Format
    • Frequency (daily, weekly, monthly)
    • Time
    • Recipients
  4. 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:

  1. Navigate to Reports > History
  2. Filter by:
    • Date range
    • Report type
    • Status
    • Creator
  3. View report details
  4. 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

  1. Navigate to Reports > Templates
  2. Click New Template
  3. Configure:
    • Base report type
    • Default sections
    • Default filters
    • Branding options
  4. Save the template

Using a Template

  1. Click New Report
  2. Select From Template
  3. Choose the template
  4. Modify as needed
  5. Generate

Best Practices

For Trustee Reports

  1. Use Detailed Compliance report type
  2. Include all test results and calculations
  3. Add executive summary for quick review
  4. Include historical trend for context
  5. Generate in PDF format for archival

For Internal Review

  1. Use Compliance Summary for quick checks
  2. Export to Excel for further analysis
  3. Include charts for visual communication
  4. Schedule daily generation for monitoring

For Audit Support

  1. Use Calculation Audit report type
  2. Include full data lineage
  3. Generate in multiple formats (PDF + JSON)
  4. Retain reports per audit requirements
  5. Document report generation in audit trail