Skip to content

Reconciliation

Reconciliation compares your internal portfolio data against trustee tapes to identify discrepancies that need investigation.

Overview

The reconciliation workflow:

  1. Upload a trustee tape (Excel file from US Bank, Deutsche, or Wilmington)
  2. Run reconciliation against an internal workbook
  3. Review detected issues by severity
  4. Resolve each discrepancy

Uploading Trustee Tapes

  1. Navigate to Reconciliation in the main menu
  2. Click Upload Tape
  3. Select the Excel file
  4. Choose the trustee (US Bank, Deutsche, or Wilmington)
  5. Enter the statement date
  6. Click Upload

The system parses the tape and extracts loan-level data automatically.

Running Reconciliation

  1. Select an uploaded tape
  2. Choose the internal workbook to compare against
  3. Click Run Reconciliation
  4. Wait for processing (typically under 30 seconds)

Reviewing Issues

Issues are categorized by severity:

Severity Color Action
Critical Red Investigate immediately
Error Orange Review before reporting
Warning Yellow Investigate when possible
Info Blue Log for reference

Issue Details

Each issue shows:

  • CUSIP: The affected loan
  • Field: Which data field differs
  • Trustee Value: What the trustee reports
  • Internal Value: What your data shows
  • Category: Type of discrepancy (completeness, calculation, timing, reference)

Resolving Issues

For each issue, you can:

  • Acknowledge: Mark as under investigation
  • Resolve: Issue has been corrected
  • False Positive: Not a real discrepancy

Resolution Notes

Always add resolution notes explaining what was found and how it was resolved. This creates an audit trail.