This article is a work in progress. If you have any questions, thoughts, or corrections, contact us.

Technology and infrastructure

Investor portals and integration

Investor portals and integration

Once you have multiple capital providers or facilities over $100M, self-service access becomes valuable. An investor portal gives your lenders what they need without requiring your team to respond to every data request. Beyond portals, your systems need to integrate with payment processors, banks, credit bureaus, and facility counterparties. The quality of these integrations determines how much manual reconciliation your team does.

What capital providers expect

A functional investor portal provides three categories of access:

Document repository

  • Monthly servicer reports
  • Quarterly performance decks
  • Borrowing base certificates
  • Compliance certifications
  • Legal documents (facility agreement, amendments)

Organized by date and document type, searchable, with clear naming conventions. Lenders should be able to find any document without asking you.

Data access

  • Downloadable loan tape (current and historical)
  • Stratification tables
  • Performance charts
  • Custom data queries (advanced feature)

Most lenders want the raw data so they can run their own analysis. Don’t assume a dashboard is sufficient; provide download capability.

Notifications

  • Monthly report availability
  • Covenant compliance status
  • Material events (trigger breach, amendment, etc.)

Automated notifications reduce “where is the report” inquiries. Set clear delivery schedules and stick to them.

Portal platform options

Third-party fund administration platforms

PlatformServicesTypical Cost
Alter DomusFull fund administration with investor portal$30-75K annually
SS&CEnterprise-scale administration$50-100K+ annually
CitcoStrong in credit funds$40-80K annually
CSC GlobalDocument and reporting services$20-50K annually

Illustrative pricing. See pricing disclaimer.

These platforms bundle portal functionality with fund administration services. If you need NAV calculation, investor accounting, or regulatory reporting, the bundled approach makes sense. For pure document and data access, you’re paying for functionality you don’t use.

Custom build

If your needs are specific or you have strong internal technology capabilities, a custom portal is achievable. Expect:

  • $100-300K to build
  • 6-12 months development time
  • Ongoing maintenance (1-2 engineers or contractor support)

Custom builds make sense when:

  • You have multiple products with different reporting needs
  • You want to differentiate on investor experience
  • Your data access patterns don’t fit standard platforms
  • You have the technical team to maintain it

Hybrid approach

Many originators use a simpler approach until scale demands more:

  • Document repository (SharePoint, Google Drive, Dropbox) with controlled sharing
  • Automated report distribution by email
  • Structured folder organization by investor and date

This works until you have 5+ capital relationships or lenders start expecting real-time access. The main downside is no unified view across investors and no self-service for historical data.

Report formats and frequency

What lenders actually want (vs. what you might assume):

ReportFrequencyFormatNotes
Loan tapeMonthlyCSV/ExcelStandardized format per facility
Servicer reportMonthlyPDF + ExcelSummary + detail
Borrowing baseMonthly/WeeklyExcelCalculation with supporting schedules
Covenant certificateMonthly/QuarterlyPDFOfficer certification
Performance deckQuarterlyPDF/PowerPointVisual summary with commentary
Static pool dataMonthlyExcelCohort-level performance tracking

Note: Ask your capital providers what format they actually want before you build elaborate reporting. Many prefer a clean Excel file over a fancy dashboard they’ll never log into.

Report delivery timing

Set clear expectations and meet them consistently:

  • Monthly reports: Due within 15-20 business days of month-end
  • Borrowing base: Per draw frequency (weekly or monthly)
  • Quarterly decks: Within 30 days of quarter-end
  • Annual reviews: Align with facility anniversary

Late reports signal operational issues. If you’ll miss a deadline, communicate proactively with your lenders.

Integration requirements

Your systems need to talk to each other and to external parties. Plan these integrations as core infrastructure, not afterthoughts.

Payment processing

ACH/NACHA file generation and transmission: Your LMS generates NACHA files for ACH debits and credits. These go to your processor (bank or third party).

Payment posting from processor to LMS: When payments clear, your LMS needs to know. Automated posting eliminates manual entry errors.

Return handling: NSF returns, unauthorized transactions, and disputes need automated processing. Manual return handling becomes a bottleneck at volume.

Reconciliation: Daily reconciliation between payment processor and LMS. Every payment received should match a payment posted.

Bank accounts

Daily balance feeds: Your LMS should know current cash positions without manual lookup.

Transaction-level detail: For reconciliation, you need every transaction, not just end-of-day balances.

Automated cash positioning: When managing multiple accounts (collection, operating, reserve), automation prevents manual errors.

Credit bureaus

Metro 2 reporting: Monthly required for consumer loans. Fixed-width format with specific field requirements.

Dispute handling workflow: When consumers dispute information, you need a documented resolution process.

Credit pull integration: For collections, pulling updated credit helps prioritize accounts.

Custodian

Document status tracking: Know which loan files are certified, which have exceptions.

Exception notifications: Automated alerts when documents are missing or deficient.

Certification workflow: Streamlined process for getting new loans certified.

Trustee/calculation agent

Distribution files: Amounts and accounts for waterfall distributions.

Investor reports: Required format varies by trustee; automate generation where possible.

Reconciliation data: Your numbers should tie to theirs without manual intervention.

Data delivery standards

Different counterparties accept different formats and delivery methods:

CounterpartyTypical FormatDelivery Method
Lender/trusteeCSV, XML, ExcelSFTP, email, portal upload
Calculation agentXML, CSVSFTP, API
Credit bureausMetro 2 (fixed-width)SFTP
Payment processorNACHA (fixed-width)Direct connection or SFTP
CustodianCSV, XMLSFTP, portal

APIs are becoming more common but are still not universal. Plan on supporting SFTP and flat file delivery for at least some counterparties. File formats are usually prescribed; you adapt to their requirements.

Reconciliation procedures

You need documented reconciliation for each data interface:

Cash reconciliation

Bank account balances match expected cash position in LMS.

  • Frequency: Daily
  • Tolerance: $0 variance (investigate everything)
  • Owner: Operations team

Loan count reconciliation

Number of loans in LMS matches trustee/lender records.

  • Frequency: Monthly
  • Tolerance: Zero variance
  • Owner: Operations team

UPB reconciliation

Total principal balance matches across systems.

  • Frequency: Monthly
  • Tolerance: Less than 0.01% variance (investigate larger)
  • Owner: Finance team

Payment reconciliation

Payments posted match payments received.

  • Frequency: Daily
  • Tolerance: $0 variance
  • Owner: Operations team

Build these reconciliations into your monthly close process. When they break, fix the root cause, don’t just adjust the numbers.

Integration implementation priorities

Not all integrations are equally urgent. Prioritize in this order:

Phase 1: Critical operations

  1. Payment processor (can’t service without this)
  2. Bank accounts (cash visibility)
  3. LMS reporting (loan tape generation)

Phase 2: Compliance and reporting 4. Credit bureaus (Metro 2 regulatory requirement) 5. Investor reports (lender relationship) 6. Custodian (document certification)

Phase 3: Efficiency 7. Trustee/calculation agent (waterfall automation) 8. Analytics platform (data warehouse feeds) 9. Investor portal (self-service access)

Common integration mistakes

Underestimating file format complexity. Metro 2 and NACHA formats have specific requirements that aren’t obvious. Budget time for testing and certification.

Skipping reconciliation. Just because data flows doesn’t mean it’s correct. Build reconciliation from day one.

Manual processes that don’t scale. Uploading files manually works at 1,000 loans. At 10,000 loans with daily processing, you need automation.

Ignoring error handling. What happens when a file fails? Integration design should include alerting, retry logic, and exception queues.

Assuming APIs exist. Many counterparties still require SFTP and flat files. Don’t architect for APIs without confirming availability.