End-to-end automated remittance reporting from SFTP ingestion to investor-grade output with 9 validation checks.
The Remittance Report is a critical monthly deliverable in mortgage servicing — it reconciles borrower payments, servicer distributions, and investor remittances down to the penny. Nick built an end-to-end automated Remittance Report Data Suite that transforms raw Midwest servicer SFTP exports into investor-grade reports.
The system processes 41,094 cells with 9 automated validation checks per loan, eliminating manual reconciliation steps that previously consumed 10+ hours monthly. The architecture integrates directly with the BigQuery Medallion Architecture for cloud-based processing and with the Enterprise Analytics Engine for Excel-based reporting.
The suite increased automation coverage by 56% over the previous manual process and established a reproducible monthly production pipeline that generates consistent, audit-ready remittance packages for both bank partners.
Interactive demo embedded above. Some features may require full-screen view.