certifying mortgages for freddie mac · selling advisor authorized user identification and...

April 2019

Certifying Mortgages for Freddie Mac

The Freddie Mac Single-Family Seller/Servicer (Guide) requires a Seller/Servicer selling Mortgages to Freddie Mac to forward the Notes, assignments and related documents to the Document Custodian for certification and safekeeping. This reference guide provides guidance on how to certify loans using Loan Selling Advisor® .

Loan Selling Advisor lets you handle document certification with ease and convenience. Benefits include:

• Real-time certification

• Online discrepancy reconciliation

• Access anywhere you have a web connection

Before You Begin Using Loan Selling Advisor

Before you begin using Loan Selling Advisor, you must meet the minimum system recommendations. This section provides information on system recommendations, hours of operation, and accessing Loan Selling Advisor.

Hours of Operation

Click this link and navigate to the Loan Selling Advisor’s hours of operation - https://las.freddiemac.com/passch/contactus

Accessing Loan Selling Advisor

Loan Selling Advisor is accessed via the Internet. To access, complete the following steps:

Step / Action Result / Notes

1. Obtain User Names and Passwords

Document Custodians must complete Form 901 [PDF] (Document Custodian Loan Selling Advisor Authorized User Identification and Certification Form) and fax to 703-738-1532 or email to: [email protected].

1. The Loan Selling Advisor Password is emailed to the Primary Contact/Administrator.

2. Your Individual Password and Personal Identification Number (PIN) are emailed directly to you. We recommend you retain this information. You will need your PIN to request a password reset.

If this is the first time using your User Name and Password, you will be prompted to change your password and complete the User Profile page.

For more information, go to FreddieMac.com and visit the Get Started Using Loan Selling Advisor web page.

2. In your Internet browser, enter https://las.freddiemac.com/ into the address line. Then click Enter.

Bookmark this address for future access

https://las.freddiemac.com/passch/contactus.html

http://www.freddiemac.com/singlefamily/forms/sell/pdf/901.pdf


https://las.freddiemac.com/

April 2019 www.FreddieMac.com/learn



The Loan Advisor page displays:

3. Enter the Username and Password from your Freddie Mac email message. Then click LOG IN.

After you click LOG IN, you will see the Loan Selling Advisor Welcome page

You may change your personal password at any time. Launch the following demonstration for help: User Profile and Password Reset

Passwords must be at least eight characters long and must include at least two alpha and one non-alpha character. To ensure the security of your data, we recommend you change your password regularly— at least every 90 days

If you forget your username or password, follow the prompts from the links Forgot your username/password? at the bottom of the LOG IN window.

http://www.freddiemac.com/learn/

http://freddiemac.elearningserver.com/p/7733093796




4. On the Loan AdvisorSM Welcome page, click Open across from Loan Selling Advisor.

The Loan Advisor Welcome page displays:

5. Click View Guide to see link descriptions displaying on the Welcome page, then click Close.





6. Login: System Context page -

Select the appropriate Unit Name and Seller/Servicer Number from the drop-down menus, and then click Continue.

▪

▪ Based on your assigned user role(s), the Unit Name drop-down menu may appear during your log in process.

7. The Login: Terms & Conditions page will display. This page displays every time you log in.

Review the Terms & Conditions and click I Agree to proceed. The Welcome to Loan Selling Advisor Home page displays.




Welcome to the Loan Selling Advisor Home Page

The home page can always be accessed by selecting Loan Selling Advisor from the blue title bar.

The table below outlines the functions and features available in Loan Selling Advisor:

▪ Feature ▪ Description

Loan Advisor Menu

• Links to the Loan Advisor home page.

• Menu links to the Loan Advisor suite of tools

User Information

Access to resources and support:

1. Displays the User ID used to log into Loan Selling Advisor. When you click your User ID, a drop-down menu displays with My Preferences information and lets you log out.

• Contact Us displays the number to obtain live support, business support, and application availability hours.




▪ Feature ▪ Description

2. Help provides access to the Loan Advisor Suite online help system.

3. User Context: User ID, when selected, displays your organization information. If you operate under multiple Seller/Servicer numbers, you may log in using a different number or branch (if applicable) without entirely logging out of the system.

Online Help ▪ Provides access to process overviews and procedures.

▪

Main Menu • Provides access to the main menu functions for your user role. Scroll over a menu

topic to access the panel of functions.

News and Resources

• Provides information about upcoming or current system availability. These messages may indicate scheduled down time for technical enhancements or may reference potential data delays if processing jobs are running longer than expected.

• Provides links to additional resources.

▪

▪ This page will provide updates regarding Loan Selling Advisor. It is updated regularly, so check it often.

Customer Service

Displays customer-service contact information.

Establishing User Roles

User roles determine a person’s authority within an organization to select screens and perform various functions within Loan Selling Advisor.

Loan Selling Advisor has defined two user roles for the Document Custodian. To obtain access to Loan Selling Advisor, or to certify or uncertify loans, complete Form 901: Authorized User Identification and Certification Form. Sellers may assign multiple user roles to a single individual. For additional information, refer to Guide Section 2403.11.

▪

Once you receive your user ID and password, test them immediately to verify that you have the appropriate access for your user role(s).

Use the following table to help you determine which role(s) you need.

User Roles

If you need to… Your user role is…

Certify loans, propose changes and batch certify Document Custodian

Uncertify loans External Certification Manager

Navigation and Main Menu

You’ll navigate Loan Selling Advisor using the main menu, visible at the top of each Loan Selling Advisor page. It gives you access to the functions you’ll use. There are three menu sections: Certification, Settlements and Data Sets. Hover your mouse over each section to view the functions for that topic.

The following table shows the functions available under the Certification menu.





The following table describes the functions available from the main menu

Menu Name

Menu Name Function Name Use to….

Certification Certify Individual Loans Certify one loan at a time

Review Certification Issues Review certification issues for individual loans

View Certification Pipeline View and access your certification pipeline at a loan-level, contract-level or seller-level. Access multiple functions from a single page:

• Review and Certify Loans

• Batch Certify

• Review Issues

• Export Select Results

• View Certified Loans

• View History

View Import Results View the results of xml files imported including summary information on the number of files imported, files with errors and files updated

Search for Loans Search for loans that have not been certified

Record Note Received Date Enter the date the Notes were received by the Document Custodian

View Certified Loans View loans already certified

Uncertify Loans Uncertify a loan: Must have user role of External Certification Manager

Certify Loans in Batch Certify a of loans

View Certification Exceptions Review errors that occurred during Certification

Import Certified Loans Import loans already certified

Settlements View Certification Forms Lets you view or print the following

• Select Summary Schedule to access the Custodial Certification/Note Delivery Cover Sheet

• Select Detailed Schedule to access Form 1034E, Custodial Certification Schedule

Data Sets Export Certification Data • Export data using preset data sets

• Customize, edit or preview a data set in comma delimited or excel formats




Menu Name

Menu Name Function Name Use to….

• Preview the data set specification for Appendix - Custodian Fields MISMO 3.0 Export Layout in comma delimited or excel format

• View Export Results

View Export Results View the results for the files exported, including the number of files exported and choose a location to save the files

Export Batch Loans Export a batch of loans based on specific criteria that you choose: you can mark or unmark loans as exported.

For more information on custodial requirement, refer to the Guide and to the Document Custody Procedures Handbook, at http://www.freddiemac.com/cim/handbook.html.

Overview of Certification

Certification is the process of comparing data in Loan Selling Advisor against the original note and related documents for discrepancies and to verify that the information on the documents meet Freddie Mac’s certification requirements. This requires reviewing the signatures and assignment and endorsement chains. Document Custodians verify certain information contained in the notes and related documents for the mortgages sold to Freddie Mac and for certifying that they have performed those verifications and that the original documents are in their possession. We refer to this process as “certification” or “certifying” the notes.

To prepare the loans for certification, the seller builds Form 1034E, otherwise known as the Custodial Certification Schedule – Detailed, in Loan Selling Advisor. Once the Form 1034E is built, the certifiable fields on the loan cannot be edited or changed by the seller.

Certifying Mortgages in Loan Selling Advisor

Freddie Mac’s Loan Selling Advisor provides three methods to certify loans:

• Certify Individual Loans

To review and certify individual loans, you compare the physical note and related documentation to the loan data in Loan Selling Advisor to verify they match. If the data and the documentation are compliant, you certify the loan. If the data and/or the documentation are not compliant, you indicate proposed changes and/or the documentation discrepancies.

• Certify Loans in Batch

The second method is to certify loans in batch. When you select this method, you identify the loans to be certified and then print a Form 1034E. You compare the note data to the Form 1034E report and review the documentation. For each loan with discrepancies, you must use the Certifying Individual Loans method (shown above), to enter proposed changes or documentation discrepancies. For loans that are compliant, you will update the status to “Certified”.

• Import Certified Loans

If you have a proprietary data management system for certifying loans, the third method is to certify loans in your certification system and import the loan status into Loan Selling Advisor.

Your decision to certify the loans or indicate discrepancies is visible to the Seller immediately. Once the loans are certified, the Seller can sell the loans to Freddie Mac. If the notes are not certified due to data or documentation discrepancies, the Document Custodian must indicate the discrepancies in Loan Selling Advisor. The Seller simultaneously receives an email notifying them to access Loan Selling Advisor and verify the proposed changes. The Seller must accept or reject the proposed changes. If the Seller:


http://www.freddiemac.com/cim/handbook.html



• Accepts the proposed changes and there are no document discrepancies outstanding, the loan is automatically certified and you are not required to perform any further action.

• Rejects the proposed changes or documentation discrepancies are outstanding, the Seller must resolve the issues and provide you with the documentation that to resolve the discrepancy. You must update the certification status to “Certified”.

Certification Status Type

Loan Selling Advisor provides several certification statuses, called the Certified Status Type. The status updates automatically each time you certify or propose changes to a loan, and is available on several Loan Selling Advisor pages such as:

• Loan Certification: Results Confirmation

• Search for Loan: Results

• Certification Pipeline: Loan Level

• Certification: Search Results

Example – Certification Status Type:

The chart below defines each type of Certified Status Type.

Certified Status Type Definition

New Indicates the loan is not certified

Issue Outstanding Indicates that data or documentation issues have been identified for the loan.

Certification Released Indicates the loan is certified.

Certified Indicates that issues have been resolved and the loan is certified.

Accessing Form 1034E - View and Print Certification Forms

The Seller may send this form with the notes and documents, otherwise, you need to access and print the form from Loan Selling Advisor using the View Certification Forms function. Work with the Seller to determine the best method to access the form

Follow the procedures below to view and print certification forms.

1. From the Settlements menu, click View Certification Forms. The View Certifications Forms: Search page displays.




2. Select the type of search you want by clicking the button for Bill of Sale(s), Certification Batch Identifier followed by the Batch ID number, or click the radio button to select Allocated Loans or Unallocated Loans. Next, complete one or more search fields, as applicable, to narrow down your results.

The search type defaults to the Certification Batch Identifier, which is assigned when the Seller assigns loans to Form 1034E or the Note Cover Sheet.

If you… Then you can…

Select the default search type of Certification Batch Identifier

View Form 1034E across multiple contracts, all having the same Certification Batch Identifier number.

You cannot select other search criteria fields to narrow down the search results.

Allocated Loans or Unallocated Loans

Select multiple search criteria fields to narrow the search results.

3. Click Search. The View Certification Forms: Results page displays with the loans matching the search criteria entered.




Click the blue column headings to sort your results by acending or descending: default sort is Freddie Mac loan number.

Use the horizontal scroll bar to view all columns.

4. Select the loans to print on the Form 1034E by clicking the button next to the certification batch identifier. The certification batch identifier for all of the selected loans must be the same and will display on the Form 1034E.

5. Click View Detailed Schedule. The Form 1034E displays in a separate window and contains a Certification Due Date if the Seller entered one. The Seller’s contact information (preparer’s name and telephone number) appears at the bottom of the Form.

6. Click Print to print the Form 1034E.

You can also print the Note Delivery Cover Sheet by selecting View Summary Schedule.

Example of Certification Form - Note Delivery Cover Sheet/Custodial Certification Schedule:




Example of Form 1034E- Custodial Certification Schedule):

If a search results in more than 20 loans, Form 1034ES – Custodial Certification Schedule Summary, will display with two options at the bottom of the page:

• PDF 1034E Loan Details: View or print the loan detail with all the certificable fields.

• Export 1034E Loan Details: Links you to the View Export Results page and lets you export data.

Certify Individual Loans

You must compare the loan information to data in Loan Selling Advisor and data on the Form 1034E to verify they match. You must also verify that the supporting documentation meets the documentation requirements in the Guide and the Handbook (FreddieMac.com/cim/handbook.html). This section describes the process to certify or to propose changes for individual loans.

Follow the procedures below to certify individual loans.

1. From the Certification menu, click Certify Individual Loans. The Certification: Search page displays.





2. Before you enter search criteria, choose a search selection type by clicking the button for the default field of Certification Batch Identifier, and enter the Certification Batch ID number, or select the checkbox for Allocated Loans or Unallocated Loans. Next, complete search fields to narrow your results.

The Certification Batch Identifier is assigned when the Seller assigns loans to Form 1034E or the corresponding Note Cover Sheet.


Select the Certification Batch Identifier

View the Form 1034E across multiple contracts with the same Certification Batch Identifier.

You will not be able to select or enter any search criteria fields.


Enter search criteria fields to narrow the search results. Commonly used search fields are: Seller Identifier, Pool #, Note Rate Percent, and Loan Referenced Product Label.

3. Click Search. The Certification: Search Results page displays loans matching the search criteria entered.

4. Click the box next to each loan you want to review and certify.




You may choose individual or multiple loans to certify by using the Select Page or Select All Loans options located at the top of the page. This queues the loans so that you can efficiently move between them.

5. Click Review Loan(s) to display the loans one at a time. The Certification: Loan page displays the loans in sequential order based on the Freddie Mac loan number.




6. Review the Custodian Note Received Date to verify it is accurate: it must reflect the date the documents are received by the document custodian. Loan Selling Advisor defaults to the current date when the page initially displays. To change this, enter the correct date.

You can View and Certify up to five borrowers on each loan.

7. You are now ready to begin the loan data and documentation review:

• This review involves comparing data in Loan Selling Advisor or on the 1034E to the data on the note.

• The documentation review involves analyzing the original note for errors such as signature problems or missing addendums, etc.

If… Then…

There are no discrepancies in either the loan data or documentation,

• Click Certify Loan. If there’s more than one loan to certify, navigate to the next loan.

• Click Skip to Next Loan are not ready to process the current loan and want to go to the next loan.

There are discrepancies, Click Enter Discrepancy and follow the instructions below on Enter Proposed Data Change and/or Document Discrepancy.

8. After you have certified or entered discrepancies for the loans you selected, the Loan Certification: Results Confirmation page displays with status information for each loan processed.

You can select Certify Remaining Loans in Batch to batch certify the rest of the loans that displayed in your search results. See Certify Loans in Batch.

Enter Proposed Data and/or Document Changes

Proposed data and documentation changes are entered at a loan-level, one loan at a time. You will enter these completing steps 1 – 7 above. This is how to enter a data discrepancy, followed by the steps to enter a document discrepancy:

1. From the Selling Certification: Loan page click Enter Discrepancy to indicate that the loan data and/or documentation have discrepancies.

2. The Certify Loan: Report Discrepancy page displays two tabs titled Loan Data and Documents. Loan Selling Advisor defaults to the Loan Data tab.




3. For a data discrepancy, enter the proposed correction in the Proposed Changes column. If you do not have any document discrepancies, skip to step #6 below.

Type in the complete contents of the field. For example, if the street address is incorrect (123 North Main Street), you must type in the entire correct address (123 South Main Street), since the data submitted overwrites the existing data. This also applies to entering dates.

Some fields have “N/A” next to them. Clicking on a N/A box proposes a blank. This is used, for example, for a non-individual borrower. In this case, the entity name is entered in the Primary Non-Individual Borrow Name field, and the Primary Borrower First Name, Primary Borrower Middle Name and Primary Borrower Last Name fields are left blank.

4. For a document discrepancy, click the Documents tab to view a list of discrepancies.

Documentation issues prevent you from certifying the loan until they are remedied by the Seller. These might include:

• Signature or endorsement issues

• Missing original notes

• Missing modification documents, addendums or powers of attorney




5. Indicate the document discrepancy type by clicking the checkbox next to the document discrepancy name. If the document discrepancy does not display in the list, check the Other box and describe the discrepancy in the comments text box.

6. Click Submit All Data and Documentation Issues to report the proposed data and documentation changes to the Seller. If you selected more than one loan, the next loan displays. Once you have completed entering discrepancies for all loans you selected, the Certification: Results Confirmation page displays with status information for each loan.

Select Certify Remaining Loans in Batch to batch certify the remaining loans in your search results. See Certify Loans in Batch.

You cannot return to the Loan Certification: Results Confirmation page after you leave it, but, you can print the page.

Certify Loans in Batch

This section describes the process for certifying a group of loans. To Certify Loans in Batch, you must compare the notes to the data on Form 1034E, Custodial Certification Schedule – Detailed and verify they match. You must also verify that the supporting documentation complies with the Guide and the Handbook (FreddieMac.com/cim/handbook.html).

The Seller may deliver the Form 1034E with the notes; if not, you need to access and print the form from Loan Selling Advisor using the View and Print Certification Forms function. You will certify the loans (one or many) after filtering out all loans with loan and/or documentation discrepancies. Freddie Mac recommends you enter data and document discrepancies before batch certifying to certifying a loan in error. You will enter discrepancies by following the procedure to Certify Individual Loans.

To certify the loans in batch, access Form 1034E, record the note received date, and complete the batch certification process (do not select any loan with a discrepancy). All loans selected in the search results are automatically certified when Batch Certify is selected.

Follow the procedures below to certify loans in batch.

1. From the Certification menu, select Certify Loans in Batch. The Batch Certification: Search page displays.

2. Select the type of search you want to perform by clicking the button for Certification Batch Identifier and enter the Batch ID number or click the checkbox to select Allocated Loans or Unallocated Loans. Next, complete one or more search fields, to narrow your results.





The search type defaults to the Certification Batch Identifier. It is assigned when the Seller assigns loans to Form 1034E or the corresponding Note Cover Sheet.


Select the default search type of Certification Batch Identifier

View Form 1034E across multiple contracts, all having the same Certification Batch Identifier number.

You cannot select other search criteria fields to narrow the search results


Select multiple search criteria fields to narrow the search results.

3. Click Search. The Batch Certification: Search Results page displays with loans that match your search criteria.

4. Click the box next to each loan you want to certify.




To select multiple loans for certification, use the Select Page or Select All Loans options at the bottom of the page.

5. Click Batch Certify. The Certification: Results Confirmation page displays. All loans checked are automatically certified.

Import Certified Loans

If you have a proprietary system for certifying loans, you can import loans to Loan Selling Advisor. With this option, you can import certified loans and loans with data or documentation issues by sending:

• A complete file of certifiable data, or

• A current import dataset format,

You can also import and send the loan identifier and:

• Certification status of “Certified”, or

• The fields causing the data discrepancies and the certification status of “Issues Outstanding”.

Importing issues outstanding, including the certification status and the error, translates into a proposed data change that is sent to the Seller on the Review Certification Issues page.

Follow the procedure below to import certified loans.




1. From the Certification menu, select Import Certified Loans. The Import Certified Loans page displays.

2. Complete the File: field using the Browse button to locate your file.

3. Select a Loan Identifier – either Freddie Mac loan number or Seller Identifier/Seller Loan Identifier.

4. Click Import Loans. The Import Loan Results page displays the status of your import. Some of the information provided includes:

• Total Loans –number of loans in the import file

• Processed – number of loans processed from the loans in the file

• Updated – number of loans updated from the loans processed

• Failed – number of loans failed from the processed loans

• Status –the status of the import (In Progress, Completed, or Error). See table below for a description of each status:

Status Description

In progress The XML is being imported to Loan Selling Advisor.

Completed The XML import process is complete.

Error The XML file did not import. Check your file formatting and correct the error(s) before reimporting.

Large import files may take time to process; you may perform other tasks while awaiting import. To access the results, go to the Contracts menu and select View Import Results.

5. Initially, you’ll see a status of “In Progress”. Click Refresh Screen to update the import status. When the status shows “Completed”, review the import results information. Refer to the following table.




Column Name Click the numeric value hyperlink to….

Update Access the Import Certified Loan: Updated page for a list of loans that were updated.

Failed Access the Import Certified Loan: Errors page for a list of loan errors.

The import history will display for seven calendar days from the date of import.

Managing Loans within the Certification Process

Loan Selling Advisor offers many functions to help you complete tasks and manage loans for the certification. They include:

• Search for Loans

• Record Note Date Received

• Review Certification Issues


• View Certification Pipeline

• Uncertify Loans

The sections below provide step-by-step instructions for function named above.

Search for Loans

Use this to view a loan or group of loans and their certification status. Only loans that are assigned to you for certification display in the search results.

Follow the procedure below to search for loans.

1. From the Certification menu select Search for Loans. The Selling: Search for Loans page displays.




2. Before you enter search criteria, choose a search selection type by clicking the button for the default field of Certification Batch Identifier, and enter the Certification Batch ID number, or select the checkbox for Allocated Loans or Unallocated Loans. Next, complete one or more search fields to narrow down your results.







Enter search criteria fields to narrow the search results. Commonly used search fields: Seller Identifier, Pool #, Note Rate Percent, and Loan Referenced Product Label.

3. Click Search. The Search for Loan: Results page displays loans matching the search criteria selected.




Click the blue column heading links to sort your results based on that heading. The default sort is by Freddie Mac loan number.

4. To obtain more information on a particular loan, click the Certified Status Type link. This takes you to a page with details on that loan.

Three different certification statuses may display: New, Issue Outstanding, and Certified. If the loan status is New or Issue Outstanding, you may certify the loan or propose data or documentation

corrections. If the loan status is Certified and the details show a symbol to the left of the page, the Seller accepted your proposed data changes and the loan was automatically certified.

Record Note Received Date

The note received date in Loan Selling Advisor defaults to the date Form 1034E was generated. When there is a date difference between Loan Selling Advisor and the date you received the note, you can edit in Loan Selling Advisor to match the date you received the note.

Follow the steps below to enter the Record Note Received Date:

1. From the Certification menu, select Record Note Received Date. The Record Note Received Date: Search screen displays.

2. Before you enter search criteria, choose a search selection type by clicking the button for the default field of Certification Batch Identifier, and you will enter the Certification Batch ID number, or select the checkbox for Allocated Loans or Unallocated Loans. Next, complete one or more search fields, to narrow your results.











3. Click Search. The Certification: Enter Date Note Received page displays loans matching the search criteria entered.

4. The Custodian Date Note Received auto-populates with the current date. You may change the date by clicking the calendar icon and selecting a date, or by entering a date in mm/dd/yyyy format.

5. Click the box next to each loan you want applied to that date.




Click the blue column heading links to sort results based on that heading. The default sort is by Freddie Mac loan number.

To apply the date to multiple loans, click Select Page or Select All Loans.

6. Click Submit Dates. The Certification: Confirm Date Note Received page displays with the updated note receipt date.

Review Certification Issues

As the Custodian, you must know whether action has been taken on outstanding issues. You should document with your Seller to notify you when they have reviewed the issues, so you can complete certification. The following section describes accessing and reviewing certification issues after you have submitted them for resolution to the Seller.

Use the Review Certification Issues function to:

• Remove the document discrepancies indicator when the discrepancies have been resolved.

• Revise proposed data changes if the Seller rejects your original proposed loan data changes and provides the appropriate documentation.

Follow the procedures below to access and review remaining certification issues.

1. From the Certification menu, select Review Certification Issues. The Certification: Review Certification Issue Pipeline page displays with all the loans that still have certification issues.




2. Click the box next to each loan to review loans with outstanding certification issues.

The following symbol may display in the Seller Rejected Changes field:

Seller Rejected Changes Symbol Description

Indicates means the Seller has rejected the proposed change.

3. Click Review Loan(s). The Certify Loan: Review Certification Issue page displays the first loan selected. Loan Selling Advisor defaults to the Loan Data tab.




4. Depending on revisions needed, select the following:

If… Then…

you need to revise or resubmit a loan data discrepancy previously submitted to the Seller,

select the Loan Data tab and make changes in the Proposed Changes column.

you need to remove a document discrepancy indicator after the Seller corrects the discrepancy.

select the Documents tab and deselect the issue by clicking the appropriate box.

5. Click Submit Updates after you have entered the revised loan data change or removed the document discrepancy indicator. The Certification: Results Confirmation page displays.




The Seller must accept any revised loan data you resubmit before the loan is certified. If an issue is not resolved, the loan will remain outstanding and needs to be addressed with the Seller.

If the Seller indicates that the original data or documents were correct, and your changes now reflect this, the loan is automatically certified if there are no further issues.

View Certified Loans

Use the View Certified Loans functionality to view all loans certified in the last 120 days. Follow the procedure below to view certified loans.

1. From the Certification menu select View Certified Loans. The Certification: Search page displays.

2. Before you enter search criteria, choose a search selection type by clicking the button for the default field of Certification Batch Identifier, and enter the Certification Batch ID number or you will select the checkbox for Allocated Loans or Unallocated Loans. Next, complete one or more search fields to narrow your results.











3. Click Search. The Certification: Search Results page displays, listing all loans certified in the last 120 days. You may sort the list by clicking on the header links.

A symbol displayed on the left of the page next to Seller Identifier / Servicer Identifier indicates that the Seller accepted your proposed changes and the loan was automatically certified.

View Certification Pipeline

Certification Pipeline lets you manage your pipeline by displaying contracts and loans assigned to you. You can perform many functions for loans in the pipeline once the contracts or loans display, such as:

• Review and Certify Loans

• Batch Certify

• Review Issues

• Export Selected Results


• View History

Custodians can certify loans allocated to a contract as well as unallocated loans. The Certification Due Date field lets the Seller indicate when a loan should be certified. You can search and sort by the Certification Due Date to manage their daily workflow.




The Certification Pipeline can be searched using many filters: loan level, contract level, pool level, by loan corrections, etc. View history lets you see when loans were added or removed from Form 1034E. In addition, you can see when loans were allocated or de-allocated from the contract through the additional fields on the Loan Level search tab.

Follow the procedures below to view and manage your certification pipeline.

1. From the Certification menu, select View Certification Pipeline. The Certification Pipeline: Loan Level page displays with a default view of the Loan Level section.

2. Select the type of search you want to complete: Loan Level or Contract Level.

3. Enter your search criteria in the applicable section.

The certification Due Date will be auto-populated with the current date. Click the calendar icon to change the date.

When searching from the Loan Level section, select the “Additional Fields” link to access more search options to narrow your search.

A search can be completed from the Loan Corrections tab only if there are loans with outstanding corrections (or corrections status of “Validation Requested”, “Validated” or “Declined”).




4. Click Search. The Certification Pipeline: Loan Level page re-displays showing loans that meet your search criteria at the bottom of the page.

5. To perform a specific action on a loan, contract, group of loans, or group of contracts:

• Click the box next to the applicable loan(s) or contract(s); you may also choose Select All.

• Select the function you wish to perform by clicking the appropriate button:

o Review and Certify Loans: Provides the same functionality as Certify Individual Loans from the Certification menu.

o Batch Certify: Provides the same functionality as Certify Loans in Batch from the Certification menu.

o Review Issues: Provides the same functionality as Review Certification Issues from the Certification menu.

o Export Selected Results: Provides functionality to export selected information on the loan into an Excel spreadsheet.

o View Certified Loans: Provides the same functionality as View Certified Loans from the Certification menu.

o View History: The loan history begins when the Form 1034E is built in Loan Selling Advisor and loans are added to it. This provides a detailed loan history audit trail. To view a history, click the View History. A new window displays showing the loans selected and a history of:

▪ When the loans were allocated to (of de-allocated from) the contract.

▪ When the loans were added or removed from the Form 1034E.




Uncertify Loans

Freddie Mac lets Document Custodians, with the appropriate access privileges, uncertify loans. This may occur for several reasons, some of which include; if the loan was certified in error, a Seller needs to update the wiring instructions, make a correction to a servicer identification number in Loan Selling Advisor. Follow the procedure below to uncertify loans.

1. From the Certification menu select Uncertify Loans. The Uncertify Loan: Search page displays.

2. Before you enter search criteria, choose a search type by clicking the button for the default field of Certification Batch Identifier, and enter the Certification Batch ID number or select the checkbox for Allocated Loans or Unallocated Loans. Next, complete one or more search fields to narrow your results.











3. Click Search. The Certification: Search Results page displays with the loans matching the search criteria selected.

4. Select the loan to uncertify by clicking the box next to the loan.

A symbol displays on the left of the page next to Investor Contract Identifier indicates the Seller accepted your proposed data changes and the loan was certified.

Click the blue column heading links to sort your results based on that heading. The default sort is by Freddie Mac loan number

To uncertify multiple loans at once, use the Select Page or Select All Loans options at the top of the page.

5. Click Uncertify Loans. The Certification: Results Confirmation page displays showing the loans that have been uncertified.

6. Click on the Print Preview button link to print the list of uncertified loans.




Data Sets

Loan Selling Advisor provides the ability to export certification data. The Data Sets menu contains the functions for export which include Export Certification Data, View Export Results, and Export Batch Loans. The procedures below provide instruction on how to use these functions.

Export Data

The Export Certification Data option lets you export preset data sets or create customized datasets. Use the search filters (by selecting between one and six search criteria fields) to narrow the search results. You can export as many as 60,000 loans in a single export file. If you are exporting a large number of loans, Freddie Mac recommends using the Export Batch Loans function. See the instructions in this section titled Export Batch Loans.

Follow the procedures below to export certification data.

1. From the Data Sets menu select Export Certification Data. The Export Data page displays.

2. Select from the Data Set drop-down menu.

3. Select a file format from the File Format: drop down menu, Comma Delimited, Excel, or XML data sets with a file format of Comma Delimited or Excel. For additional information on how to customize, edit, or preview a data set, see Create a Customized Data Set.

4. You can narrow the export search results by selecting from a number of search criteria fields. Complete at least two and up to eight fields.

The following parameters apply to certain fields:

• Servicer Identifier or Seller Identifier - up to ten numbers may be selected.

• Investor Contract Identifier or Pool # - up to five numbers may be entered, comma separated. For example, xxxxxxxxx,xxxxxxxxx,xxxxxxxxx,xxxxxxxxx,xxxxxxxxx

• Investor Contract Identifier ranges – up to two contract number ranges may be entered, comma separated ranges with hyphen separating the start and end of the range. For example, xxxxxx-xxxxxx,xxxxxx-xxxxxx




5. Click Create Export File. The Export Data window displays.

If you are exporting a large number of loans or loan data, a prompt displays to build the file in the background.

6. Click the Build File in Background to continue if you receive this prompt. To view your results, follow the procedures in View Your Results.




Create A Customized Data Set

You can customize a data set when the Comma Delimited or Excel file formats are selected from the Export Data page. Through the Customize, edit, or preview data set function, you can build your own data set and save. You can also print and preview any data set available.

Follow the procedure below to create a customized data set.

1. From the Data Sets menu, select Export Certification Data. The Export Data page displays.

2. Select from the Data Set drop down.

3. Select either Comma Delimited or Excel for the File Format

4. Click Customize, Edit, or Preview Data Set. The Export: Customize Data Set page displays.

To add fields from another data set or modify an existing data set, select an existing data set from the Current data set drop down menu.

5. Click the field in the Current Fields box to add to the new data set. For more than one field, press Ctrl on your keyboard while selecting data fields.

6. Click Add >. The selected field from the current data set is placed into the New or Modified Data Set.




7. Repeat this process to continue adding data fields.

8. Remove fields by clicking the field name in the New or modified data set box and click <Remove.

9. If this is a new data set, enter the new data set name in the Data Set Name: field.

10. Click either Save Modifications (saves modifications to the current data set listed) or Save as New. Your customized data set is now available under the Data Set drop down menu.

Preview and Print a Data Set

Follow the procedure below to preview and print a data set.

1. From the Export Data page, click the Customize, edit, or preview data set link. The Export: Customize Data Set page displays.




2. The Current Fields box lists the fields contained in the data set. Use the scroll bar to view the fields.

3. Click Print Preview to print the data set. The Data Set Name: page displays.

4. Click the Printer icon on the browser toolbar to print the data set.

5. Click Close to exit out of the window.

Export Batch Loans

The Export Batch Loans option lets you export certification data for up to 60,000 loan records at a time. Use the search criteria fields to select loans from multiple Sellers, Servicers, contracts, and pools for the export file. You can also mark loans being added to the export file as previously exported or exclude previously exported loan records from subsequent searches.

Follow the procedure below to export a batch of loans.

1. From the Data Sets menu, select Export Batch Loans. The Export Data page displays.

2. Enter the search criteria data you want to export. Complete up to six fields.

The following parameters apply for certain fields:

• Servicer Identifier or Seller Identifier - up to ten numbers may be selected.

• Investor Contract Identifier or Pool # - up to five numbers may be entered, comma separated. For example, xxxxxxxxx,xxxxxxxxx,xxxxxxxxx,xxxxxxxxx,xxxxxxxxx

• Investor Contract Identifier ranges - up to two contract number ranges may be entered, comma separated ranges with hyphen separating the start and end of the range. For example, xxxxxx-xxxxxx,xxxxxx-xxxxxx

3. Click either Create Export Batch File without Marking Loans or Create Export Batch File & Mark Loans as Exported. For more than 500 records, a message displays indicating the request could take some time and the file builds in the background.




4. A message displays indicating if the data format you selected does not match the data format used by Loan Selling Advisor, Loan Selling Advisor will attempt to translate the data into the requested format you selected. Data that Loan Selling Advisor is unable to translate will not be exported. Select Accept to proceed.

View Your Results

Follow the procedure below to access and view your completed Export Files.

1. From the Data Sets menu select View Export Results. The Export Data page displays.

2. Files are displayed on this page for seven days.




3. Click Refresh File Status if your file status is processing.

4. Click the File Name link of your desired file. A new window displays asking if you want to Open or Save the Excel file.

This document is not a replacement or substitute for the information found in the Freddie Mac Single-Family

Seller/Servicer Guide or terms of your Master Agreement or other Pricing Identifier Terms.

© 2019 Freddie Mac
