QDH (Freddie Mac)

Original guide

This page is the Whole Loan Sale Tracker (WLST) User Guide, rewritten for the web.

The Whole Loan Sale Tracker (WLST) is the part of QDH where buyers’ due-diligence requests on non-performing whole loans are tracked before the loans are purchased from Freddie Mac. Each request is routed between the buyer, the servicer, Freddie Mac, and any vendor needed, until the deal’s final loan population is set.

This guide is for buyers, and for the servicers, lien vendors, and Freddie Mac staff who answer their requests. For an overview of QDH, see QDH on Quandis Learn.

What WLST is for

WLST isn’t a repository for all of a buyer’s due-diligence results, and Freddie Mac doesn’t re-price or discount loans based on due-diligence findings. Limit requests to critical document deficiencies that affect lien enforceability, requests for updated status, and formal loan drop requests under the program’s representations and warranties.

Open a deal

1. Sign in at www.freddiemacdealhub.com.
2. From Home, go to Deals > Whole Loan Sale Tracker.
3. Select the project or deal from the dropdown. Give it a moment to load all loans and requests.

Each deal has three tabs:

Tab	What it shows
Deal Summary	The deal name and loan count (read only). The Documents panel below the tabs lists your Excel exports.
Loans	Every loan in the deal with its deal status, and request status by due-diligence area (read only)
Requests	Every request. Most of your work happens here.

On the Loans tab, request status by area uses these codes:

Code	Meaning
R	Requested
RD	Requested Drop
C	Cleared
NCK	Cannot be cleared, but keep
X	Dropped

Tip

QDH doesn’t refresh every view on its own. Use the refresh button after an import, after an export, or when you come back to an idle screen. Two monitors help with the wide views.

Two ways to work

• In the browser: open or filter requests on the Requests tab, add new requests, update comments, attach documents, and change status. Everyone’s updates appear as soon as they’re saved.
• In Excel: export a template, record your findings, and import it back. Each new export includes everything all parties have added since, so the cycle repeats until the pools are final at the cutoff date.

Add a single request

1. On the Requests tab, select the + icon at the right of the header bar.
2. Enter the Freddie ID: the 9-digit Freddie Mac loan number, with leading zeros. QDH won’t save until it recognizes a valid loan.
3. Choose the Issue Category Detail from the list. Categories cover BPO, collateral, compliance, lien, title, and servicing notes. Choose carefully: once a request is saved, its category can’t be changed.
4. Enter comments that are specific and complete. For a lien exception, include dates, party names, and exact amounts.
5. Select Verify to confirm the request isn’t a duplicate for that loan. Save appears once it passes.
6. Optionally fill in your own references:
   • Buyer Issue ID ties the request to your own exception ID.
   • Buyer Loan ID ties it to your internal loan ID.
7. Select Requested Drop only if you want the loan removed when the issue can’t be resolved. It’s usually set after Freddie Mac and the servicer have had a chance to respond.
8. To add supporting documents, check Attach Supporting Document and drag files onto the field. File names don’t need a convention here. Wait for the name to appear in blue.
9. Select Requested to save and send the request.

Saving gives the request a system-generated Freddie Exception ID. The Responsible Party is set for you: collateral requests go straight to the servicer, and all others go first to Freddie Mac.

One request covers one issue on one loan. Don’t describe several issues in one request’s comments; Freddie Mac and the servicer respond to the issue in its category.

Work in Excel

Export a template

Freddie Mac provides the first, blank templates before due diligence starts. After that, export your own:

1. On the Requests tab, hover over the magnifying glass and select Refine Search. The panel widens to show a filter for each column.
2. Filter down to the requests you want, and note the record count.
3. Hover over the magnifying glass again and choose your export: Buyer, Lien Vendor, Servicer, or FM (Freddie Mac).
4. Scroll to the Documents panel and download your export. Sort by Created to bring the newest file to the top, and check that its record count matches your filter.

To clear the filters, reset each one to -- --, or select Refine Search again.

Edit the template

The template (Pre-Deal Issue Request Export.xlsx) is protected so that each party can change only its own columns. Don’t change its protection or structure, or the import will fail. Buyers can change:

Column	Notes
Freddie Mac ID	A valid 9-digit Freddie Mac loan number
Buyer Loan ID, Buyer Exception ID	Your own references
Requesting Drop	Yes or No
Issue Comments	The original citation. Leave it unchanged after the request is created, unless Freddie Mac asks for more detail.
Request Status	Requested or Cleared
Buyer Internal Organization Message	Notes for your own team; Freddie Mac can see them too
Buyer Response	Your responses and rebuttals
Lien Amount	If applicable

Issue Category Detail isn’t shaded, but it’s open: fill it in to add new requests in new rows below the existing ones. You can paste values or pick from the dropdowns, and pasted values must still match the list.

Keep all correspondence in your Response column. The All Dialogue column builds a running timeline of every party’s responses. QDH only recognizes an update on a row whose Response has changed, and it reassigns the Responsible Party for you on import.

Import your updates

1. Always start from a fresh export, so your edits are made to the latest data. Don’t re-import a template that has already loaded.
2. From Home, go to Import Files > All Import Files.
3. In the dashboard panel, select the matching Pre-Deal Issues template (Buyer, FM, Servicer, or Lien Vendor). If it isn’t listed, open the … menu next to refresh, select By Setup, and clear the other options.
4. Drag your file onto the blue import area.
5. Large files can take 5 to 10 minutes. Wait for the email confirming the import is complete before you check your changes; until then some updates may look missing.

Only rows with a valid Freddie Mac loan ID, a valid issue category, and changed response comments are imported. To see the results, select the summary icon next to the file name on the Transactions tab. QDH removes duplicate rows before importing, so if the success and error counts add up to fewer than your rows, the difference is duplicates. If the status shows Error, contact your Freddie Mac transaction manager; the status can switch between Complete and Error until the load finishes.

Upload many supporting documents at once

Drag files onto the Documents panel on the Deal Summary tab, named so QDH can file each one with its request:

{5-digit Freddie Exception ID}.DropRequest.{description}

For example, 12345.DropRequest.Recorded assignment.pdf.

Correctly named files are filed with their requests and don’t appear in the deal’s Documents panel, so don’t upload them again. Files QDH can’t match do appear in the deal’s Documents panel; rename them and upload them again.

Status and decisions

Open any request from the Loans tab (the status link under its due-diligence area) or from the Requests tab (the Freddie Exception ID link).

• Every new request starts as Requested.
• Buyers can mark a request Cleared once they’ve reviewed the responses, and are encouraged to clear what they can.
• Freddie Mac decides Drop, Cleared, Cannot be cleared, or Cannot be cleared but keep, depending on whether the buyer asked to drop the loan.

A loan’s Deal Status comes from its requests, taking the most severe:

1. Drop
2. Requested Drop
3. Requested Issue
4. Keep

For example, a loan with one request that leads to Requested Drop and another that leads to Keep is Requested Drop. By the end of the deal, every Requested Drop and Requested Issue is resolved to Drop or Keep.

Help

Contact your Freddie Mac transaction manager about a deal or a request. For problems with the system itself, email qdh.support@quandis.com.