What We Learned Building Mortgage Payment History Review Automation

“When I worked as a Data Entry Analyst in MIAC’s Due Diligence Group, I completed Payment History and Collection Comments reviews, commonly known as PHCC reviews.

What I remember most is opening a payment history for the first time.

It looked like a long list of dates, payments, balances, codes, and transaction descriptions. But reviewing it was not a matter of copying information. We had to work through the activity line by line, compare transactions across different records, determine what happened to the loan, and enter our findings into the review system.

Sometimes, simply understanding what the payment history was saying was the hardest part.”

That experience belongs to Kelly Granillo, AiCR’s SVP of Marketing. Four years later, she found herself looking at the same process from a completely different perspective as part of the team building AiCR’s Automated Mortgage Payment History Review.

This time, the challenge wasn’t completing a single review. It was translating years of mortgage servicing expertise into technology that could reduce one of the industry’s most labor-intensive review processes.

We all came away with one important lesson.

Mortgage payment history review isn’t difficult because the data is hard to find. It’s difficult because understanding the relationship between thousands of transactions requires mortgage expertise.

From an operational perspective, that’s why payment history review remains one of the most labor-intensive processes in mortgage due diligence. Experienced reviewers spend valuable time reconstructing payment activity before they can begin evaluating the loan itself. Every servicing transfer, reversal, suspense balance, and fragmented payment history adds manual effort to a process that depends on skilled mortgage professionals.

Organizations aren’t looking to replace experienced reviewers. They’re looking to eliminate the hours spent manually reconstructing payment histories so those reviewers can focus on applying their expertise where it delivers the greatest value.

What is a PHCC review?

PHCC, or Payment History and Collection Comments review, combines financial transaction history with servicing comments to provide a more complete understanding of a loan’s performance. Together, these records help reviewers understand not only what happened to a loan, but why.

Why payment history review remains a manual process

At first glance, a payment history may look like a spreadsheet of dates and dollar amounts. In reality, it’s a financial timeline that often spans years of servicing activity. Before a reviewer can evaluate loan performance, they must first understand how every payment, reversal, suspense balance, fee, and servicing transfer contributed to the loan’s history.

To reach those conclusions, a reviewer may need to determine:

  • What payment was due
  • When funds were received
  • Which monthly payment the funds satisfied
  • Whether the full amount was received
  • Whether funds were held in suspense
  • Whether a payment was later reversed
  • How far behind the borrower was
  • Whether the loan eventually returned to current status

The reviewer isn’t documenting transactions. They’re reconstructing the financial history of the loan before meaningful analysis can begin.

Why extraction alone doesn’t solve the problem

Extracting information from a payment history is not the same as reviewing it.

Any extraction technology can identify dates, balances, payment amounts, and transaction descriptions with impressive accuracy. But identifying data isn’t the same as understanding it. Payment history review depends on how transactions relate to one another over time, not simply whether individual fields were extracted correctly.

A payment may appear in one section of a history and be reversed later. Funds may be received but held in suspense before eventually being applied. Activity may be divided across multiple servicing histories that use different layouts, terminology, and transaction codes.

Looking at transactions individually doesn’t provide a complete understanding of the loan. They must be connected into one continuous history so reviewers can follow the movement of funds, understand delinquency over time, and accurately evaluate loan performance.

Real mortgage documents aren’t standardized

Document automation sounds straightforward until you begin working with real mortgage servicing records.

Payment histories arrive in many forms, including PDF, Excel, text files, servicing ledgers, and other proprietary formats. Even when two files contain similar information, they may use completely different layouts, transaction codes, balances, and structures.

During one of our development sessions, Mychal, one of AiCR’s lead developers, walked the team through several payment histories that represented the same type of document but looked completely different from one another. One servicer used clear transaction descriptions. Another relied on abbreviated internal codes. Dates, balances, fees, escrow activity, and suspense transactions appeared in different locations depending on the servicing platform.

Seeing the files side by side changed how we thought about automation.

We weren’t building software for ideal documents. We were building software for the fragmented servicing records mortgage professionals receive every day.

In one example our team reviewed, a single loan had moved through five different servicers. Each produced its own payment history.

The borrower had one loan.

The reviewer received five different histories.

AiCR was designed to identify those related histories, connect them at the loan level, and organize the transaction activity into one continuous history instead of requiring reviewers to reconstruct it manually.

What is a mortgage pay string?

One concept our development team quickly discovered was the mortgage pay string.

A mortgage pay string is a concise summary of a borrower’s payment status over a series of months. Rather than reviewing hundreds or thousands of individual transactions, experienced reviewers can often understand a loan’s delinquency pattern by interpreting the pay string generated from those transactions.

During one of our meetings, Jeff Zuckerman, Director at AiCR, walked the team through a sequence of letters and numbers such as “X, 0, 1, 3.”

Jeff immediately recognized what the sequence represented. To many of the developers, it looked like a code that needed to be deciphered.

That moment highlighted an important lesson. A pay string isn’t simply another field to extract. It’s the result of understanding the payment history. Every character represents a conclusion drawn from the underlying transaction activity.

Although pay string formats vary depending on review requirements, they all serve the same purpose: providing an experienced reviewer with a concise view of how a loan performed over time.

Generating that summary requires much more than identifying dates and payment amounts. It requires understanding the relationship between every transaction that contributed to the loan’s history.

What did our developers have to learn?

Building Automated Mortgage Payment History Review required far more than identifying dates and dollar amounts.

The development team had to understand how experienced reviewers interpret payment histories, connect servicing records, normalize different transaction types, generate pay strings, and identify situations that require additional review.

Every enhancement required translating mortgage expertise into repeatable logic that could perform consistently across different servicing platforms, document formats, and loan scenarios.

Some payment histories were clean and well structured.

Others were difficult even for experienced reviewers to interpret.

The challenge wasn’t teaching the software how to read a document. It was teaching the system how to organize fragmented information into something a reviewer could confidently analyze.

That is the reality of working with mortgage servicing data.

The information may represent the same loan activity, but it rarely arrives in the same format twice.

How does AiCR approach mortgage payment history review?

Rather than requiring every servicer to produce information in the same format, AiCR works with the payment histories organizations already receive.

PDFs, Excel files, text files, and multiple servicing histories can be processed and connected into a single loan-level history. Transaction activity is normalized into a consistent structure, allowing reviewers to analyze combined histories instead of manually rebuilding them from multiple source documents.

Reviewers can sort and filter transaction activity, compare results against an existing Excel analysis, and export structured transaction data and reconstructed cash flows.

The objective isn’t to replace the review with a black-box answer.

It’s to organize the information so experienced mortgage professionals can spend their time evaluating loan performance rather than reconstructing payment histories.

What did we learn?

Building Automated Mortgage Payment History Review reinforced something all of us learned throughout this project.

Mortgage expertise remains one of the industry’s greatest assets. The challenge isn’t replacing experienced reviewers. It’s giving them better tools to apply that expertise.

Automation should remove repetitive, manual work, not the judgment that drives sound loan review decisions.

That philosophy shaped every decision we made while building this feature. Rather than producing a black-box answer, AiCR organizes fragmented payment histories into a structured, loan-level view that reviewers can analyze, validate, and trust.

For lenders, servicers, investors, and due diligence firms, that means spending less time reconstructing servicing records and more time evaluating loan quality, identifying risk, and making informed decisions.

This project also reminded us that the best technology isn’t built by software developers alone. It comes from collaboration between mortgage professionals who understand the work and engineers who understand how to transform that knowledge into scalable solutions.

Mortgage servicing data will continue to evolve. Document formats will continue to vary. New challenges will emerge.

Our commitment is to keep building technology that helps mortgage professionals work more efficiently without sacrificing the expertise that makes high-quality loan review possible.

If your organization is looking for a better way to review mortgage payment histories, we’d welcome the opportunity to show you what we’ve built and hear about the challenges your team is solving.

Request a personalized demonstration of AiCR’s Automated Mortgage Payment History Review and see how structured, review-ready payment histories can help your team spend less time rebuilding data and more time delivering insights.

Frequently asked questions

What is mortgage payment history review?

Mortgage payment history review is the process of examining a servicing ledger to understand how a borrower paid over time. The review may include payments, missed payments, reversals, suspense activity, fees, escrow activity, and other transactions that affect the loan’s status.

What is the difference between PHCC and payment history review?

PHCC stands for Payment History and Collection Comments. Payment history review focuses on financial transactions recorded on the loan. Collection or servicing comments provide additional context about borrower communications and other events affecting the loan.

Why is extracting payment data not enough?

Dates and amounts alone may not show which monthly payment was satisfied or how a transaction changed the loan’s status. The transactions must be connected and interpreted together to understand the loan’s performance.

Can one loan have multiple payment histories?

Yes. A loan may have multiple payment history files when servicing transfers from one company to another. Those files must be connected to create one continuous loan history.

What types of payment history files can AiCR process?

AiCR can process mortgage payment histories provided as PDF, Excel, and text files.

Can AiCR compare its results with an existing analysis?

Yes. Users can upload an existing Excel analysis and compare it with AiCR’s results to identify matching and differing information.

See Automated Mortgage Payment History Review in action

Learn how AiCR turns complex mortgage payment histories into structured, loan-level results that are easier to review, compare, and use.

Explore Automated Mortgage Payment History Review