Servicing Guide

Published September 9, 2020

For best results, pose your search like a question.

Guide Resources

For a comprehensive list of resources such as forms, announcements, lender letters, notices and more.

Visit Selling and Servicing Guide Communications and Forms

Customers Recommend Ask Poli

AskPoli

If you have additional questions, Fannie Mae customers can visit Ask Poli to get information from other Fannie Mae published sources.

Launch Ask Poli  

Download PDF Guide

You can also download the printable ~800 page PDF, which include links.

Download Now

Converting a Delinquent Reporting File for Bulk Submission in AMN

Converting a Delinquent Reporting File for Bulk Submission in AMN

Below are instructions to convert an Excel file to text format to perform bulk upload to report delinquent loans to Fannie Mae using AMN.

For more information on your Delinquency Reporting Responsibilities see section F-1-22: Reporting a Delinquent Mortgage Loan via Fannie Mae’s Servicing Solutions System (02/12/2020) in the Servicing Guide.

  1. The Excel spreadsheet should be in the below format.

NOTE: The order of the column should not be changed (as per the current design)

NOTE: The first 4 columns are mandatory (Servicer Number, Loan Number, Status Code, Reason Code)

NOTE: The data in the remaining columns is optional. However, if no data is available for those columns in order for the system to treat it as null/empty blank spaces need to be inserted in the cell. (The Number of blank spaces should match the length of the field specified in job aid – screen shot also shows the currently defined lengths for each of those fields.)

NOTE: The Total Length of all of the columns should be 80.

Click here for a Sample Document in desired format.

 

2. Once all of the data is entered, save the document as shown below.

  1. Select File > “Save As”
  2. Browse to the location the file will be saved.

 

3. Select the “Save as type” of CSV (Comma delimitted) (*.csv) 

 NOTE: The name could be a little different based on Excel version being user.

4. Name and save the file.

5. Click “Yes” if the message below pops up.

NOTE: Close the file and click “Don’t Save” on the below Pop up.

6. Browse to the saved location and change the file type to .txt by removing “csv” and adding “txt” at the end. The file will be renamed shown below.

7. Open the renamed file (This will generally open in notepad or any other text file editor.)

8. Delete the header rows highlighted below.

NOTE: The header row can also be deleted from excel file before it’s saved as .csv)

 

9. Press Ctrl + H (Find and Replace functionality) and replace all commas (,) with a space. Click the “Replace All” button and save the file.

10. Save the changes. The file is now ready to be uploaded.

11. To verify that the file is in the correct format, highlight the text fields from left to right and confirm where the highlight ends is cut off at 81.

Have You Tried Ask Poli?

Poli knows. Just ask.

Ask Poli features exclusive Q&As and
more—plus official Selling & Servicing
Guide
content.

Try Ask Poli

Related Articles


AskPoli

Customers Recommend Ask Poli

If you have additional questions, Fannie Mae customers can visit Ask Poli to get information from other Fannie Mae published sources.

Guide Resources

For a comprehensive list of resources such as access forms, announcements, lender letters, notices and more.

Visit Selling and Servicing Guide Communications and Forms

X
Having Issues with Seeing this Page Correctly?

Use Firefox or Chrome   How to do a hard refresh in Internet Explorer
We recommend that you use the latest version of FireFox or Chrome.

Download Firefox
Download Chrome
  A hard refresh will clear the browsers cache for a specific page and force the most recent version of a page.
    Hold the Ctrl key and press the F5 key.
     

Email Us
If you still have Technical Support questions, feel free to emailAsk_Poli@fanniemae.com.