Reserve Reporting: Seller/Servicer User Guide
Contents
1. Address PostalCode BOTTM Bottom Dollar Markets Elizabeth Lincoln Accounting Manager 23 Tsawassen Blvd T2F 8M4 FISSA FISSA Fabrica Inter Salchichas 5 A Diego Roel Accounting Manager C Moralzarzal 86 26034 HANAR Hanari Carnes Mario Pontes Accounting Manager Rua do Paco 6 7 05454 876 LILAS LILA Supermercado Carlos Gonzalez Accounting Manager Carrera 52 con Ave Bolivar 765 98 Llano Largo 3508 OLIEDE Que Delicia Bernardo Batista Accounting Manager Rua da Panificadora 12 02389 6735 QUICK QUICK Stop Horst Kloss Accounting Manager Taucherstrabe 10 01307 ROMEY Romero y tomillo Alejandra Camino Accounting Manager Gran Via 1 26001 SUPRD Supr mes delices Pascale Cartrain Accounting Manager Boulevard Tirou 255 B 6000 VINET Vins et alcools Chevalier Paul Henriot Accounting Manager 59 rue de l Abbaye 51100 WARTH Wartian Herkku Pirkko Koskitalo Accounting Manager Torikatu 38 90110 M 4 2j2 3456789 10 gt m Pagesze 10 91 items in 10 pages Some grids have a default sort enabled and the user is able to override this default by clicking the header to sort by a different column If the user leaves the page and returns the grid will return to the default sort Filtering When filtering is enabled a filtering item appears below the column header The user can enter a filter criterion in the filter box A drop down list allows the user to select a filter expression that is applied to the criterion for the column When the user presses the filter but2. Click Change Forgotten Password An email will be sent to the address associated with your account that includes a temporary password Use this temporary password to log into the system If the temporary password is accepted you will be immediately asked to provide a new password If you have forgotten your username or are unable to access your login page please contact your administrator GE a 0 em April 2015 10 Freddie Mac Multifamily Home S S Overview Reserve Reporting Seller Servicer User Guide The Seller Servicer Overview provides a summary of information regarding the Seller Servicer including any current meaningful system notifications Click Add New on the respective grid to add new Office Locations or Contacts S S Homepage RR S S Overview S S Overview RR Messages Notification Date Priority Title Notification No records to display S S Overview RR Overview Portfolio Demo Servicer 3 Division 2 Demo Servicer 3 Division 1 Demo Servicer 3 Division 3 S S Overview RR Office Locations Add New Edit Location Name Street Address 1 Street Address 2 City State Zip Delete amp Test Office 1 5200 Peachtree RD Suite 3001 Atlanta GA 30302 S S Overview RR Contacts Add New Edit Contact Type Contact Name Title Street Address City State Zip Code Main Phone Direct Phone Mobile Phone Facsimilie Email Address Delete
3. Demo Porfolio Captial Markets Demo Portfolio d Demo Company Back Upon clicking the Add New or Edit button users are presented with the edit screen that allows them to manage the user name display name parent Company e mail address and Active flag The asterisk indicates required field before saving Add New Edit Display Name User Name Client Corporate PRS Portfolios O NI RI WI Display Nane e ie Company Select a Parent Company Ze mA Tm Active E Note Users cannot be permanently deleted but can be statused as Active or Inactive by setting the Active check box accordingly April 2015 12 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide Manage RR Portfolios context menu option lets administrations to assign portfolios to users The portfolios that are available in the pop up window are portfolios that are under parent company selected when creating or editing a user ie nl i WI h T WIO S II Jn TT ww Wl hw Freddie Mac p ga DH Manage RR Portfolios Sub Companies Company Name Company No Demo Servicer 3 Division 3 Demo Servicer 3 Division 1 Demo Servicer 3 Division 2 Role Assignment The Role Assignment screen allows users under the RR S S Admin role to be able to add edit users to a particular Role S S Homepage Role Assignment RR S S Admin RR S S Read Only amp RR S S User Edit Users H Demo Servicer 4 Edit the Role you
4. Demo Servicer 3 Division 3 Property City City of mortgage property must be exact ma CHECIO Context Menu Items these apply to items selected on the Grid 1 View Comments Allows user to view comments on warnings individually This action cannot be performed in bulk Kal Freddie Mac Data Warning Comments View View Existing Comments CommentedBy CommentedOn Comments RRS FM Business Admin 1 21 2015 5 27 33 PM test Demo Servicer User 1 21 2015 5 26 26 PM test April 2015 22 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide FM Final Approval The FM Final Approval Queue is populated by warnings Preliminarily accepted by FM to accept the Seller Servicer Value or warnings that have updated value The warning status for warnings in this gueue is FM Preliminary Approved S S Reserve Reporting FM Final Approval Drag a column header and drop it here to group by that column Output to Excel FM Loan No S S Name S S No Field Name Warning S S Value FM Value CH hd hd H hd hd uu Property City City of mortgage property must be exact match with FM City Baltimore S a CLEVELAND CH Demo Servicer 3 Division 3 Property City City of mortgage property must be exact match with FM City HEIGHTS CLEVELAND HTS CH Demo Servicer 3 Division 3 Property City City of mortgage property must be exact match with FM City CHARLESTON TEST CITY bi ffs b Loa Page 1 of 1 Go Page se
5. FM Under Review Warnings under review by Freddie Mac FM Final Approval Warnings awaiting Final Approval by Freddie Mac View All All of the above warnings Due Loan is due from Seller Servicer or Under Review Accepted All loans when all warnings associated with a loan has been Accepted and or Approved or when a loan does not have any discrepancies ool Se NS S S Under Review The S S Under Review Queue is populated with warnings for loans within the uploaded file upon passing the warning validations and a loan has one or many warnings Warnings can also be moved to S S Under Review Queue when warnings are returned by Freddie Mac The warning status for warnings in this queue is S S Under Review S S Sales Data Update S S Under Review Drag a column header and drop it here to group by that column Output to Excel Accept FM Value Send to Freddie Mac Under Review Add a Bulk Comment Ol FM Loan No S S Name S S No Field Name Warning FM Value S S Value Creation Dat e Y e e Y y Mi 5 RE A e TEn Gnonte Original Amortization must be exact match with FM View Add Comments Loan Term Tot S a SS Monthly Debt Service Payment Monthly Debt Payment Amortizing must be within p RETIR O Demo Servicer 3 Division 3 AMORTIZING 99 Cents of FM value 54268 39 54318 59 01 26 2015 ol Demo Servicer 3 Division 3 Amortization Term months EES mist he exact match wii FM 0 360 01 26 2015 rn i a Monthly
6. 3 Original Amortization must be exact match with FM Loan Term Amortization Term months 360 0 Demo Servicer 3 Monthly Debt Payment Amortizing must be within 99 Cents of FM value Monthly Debt Service Payment AMORTIZING 53605 88 53556 34 Warning Comment Are you sure you want to send warning to Freddie Mac Under Review Submitted By demouser3 Submitted On 1 26 2015 12 21 25 PM Yes No 3 Add a Bulk Comment Allows user to insert bulk comments into warnings by selecting multiple warnings from the grid B Freddie Mac B amp oO Add Bulk Comments Add Bulk Warning Comments FM Loan No S S Loan No Company Name FieldName Warning Details Demo Servicer3 Property City City of mortgage property must be exact match with FM City Demo Servicer3 Amortization Term months Original Amortization must be exact match with FM Loan Term Demo Servicer3 Monthly Debt Service Payment AMORTIZING Monthly Debt Payment Amortizing must be within 99 Cents of FM value Add Comment Submit Context Menu Items these apply to items selected on the Grid 1 View Add Comments Allows user to add custom comments to warnings individually This action cannot be performed in bulk Freddie Mac BB 5 e D Data Warning Comments View Add View Existing Comments CommentedBy CommentedOn Comments E Add Warning Comments Warning Details Cit
7. Excel d S S Name Portfolio S S Number Due 96 Due Under Review Under Review Accepted 96 Accepted Approved Approved Total Demo Servicer 3 Demo Servicer 3 Division 2 0 0 0 0 00 6 100 00 0 0 00 6 Demo Servicer 3 Demo Servicer 3 Division 1 0 0 8 13 11 53 86 89 0 0 00 61 Demo Servicer 3 Demo Servicer 3 Division 3 0 0 56 7 60 681 92 40 0 0 00 737 0 64 740 0 804 S S Homepage Rsv Reporting Warnings Summary Output to Excel S S Name Portfolio S S Number S S Under Review S S Under Review FM Under Review 96 FM Under Review S S Accepted 96 S S Accepted FM Accepted 96 FM Accepted FM Under Final Review 96 FM Under Final Review Total Deno DA 8 100 00 0 0 00 0 0 00 0 0 00 0 0 00 8 Servicer 3 Division 1 Demo Demo Servicer 3 Ge 57 100 00 96 0 0 00 0 0 00 0 0 00 0 0 00 57 Servicer 3 Division 3 65 0 0 0 0 65 User Management The Users screen allows users under RR S S Admin role to be able to add edit users and manage their relationship to their parent company User Management Add New Edit Display Name User Name Client Corporate PRS Portfolios LY LY LY LY Demo Portfolio Bonds Demo Porfolio Captial Reset Password Demo Company Markets Z ew Unlock User Demo Porfolio Captial Markets Demo Portfolio y Demo Company Z Manage RR Portfolios Bonds d Demo Portfolio Bonds Demo Porfolio Captial Demo Company Markets
8. Mac Multifamily Reserve Reporting Seller Servicer User Guide Reserve Reporting Queue All Warning and Loan Queues in the system use the Grid control Basic functionality of the Grids is described in the Common Controls section of this User Manual Functionality specific to each page is described below Warnings move through the Queues S S Under Review FM Under Review and FM Final Approval Loans move through the Due and Accepted Queue Loans with one or more warnings Under Review will be in the Due Queue until warnings have been accepted and or approved and then will be moved to the Accepted Queue by the system S S Under Review Warnings under review by Seller Servicer FM Under Review Warnings under review by Freddie Mac FM Final Approval Warnings awaiting Final Approval by Freddie Mac View All All of the above warnings Due Loan is due from Seller Servicer or Under Review Accepted All loans when all warnings associated with a loan has been Accepted and or Approved or when a loan does not have any discrepancies S S Under Review The S S Under Review Queue is populated with warnings for loans within the uploaded file upon passing the warning validations and a loan has one or many warnings Warnings can also be moved to S S Under Review Queue when warnings are returned by Freddie Mac The warning status for warnings in this queue is S S Under Review ool Se NS SIS Reserve Reporting S S Under Review Drag a column h
9. No 504190970 OH SalesDataUPdatev1 12 2014 1 26 2015 2 50 42 PM Escrow previously uploaded for this loan FRE Loan No 504191063 IL SalesDataUPdatev1 12 2014 Als 1 26 2015 2 50 42 PM Escrow previously uploaded for this loan FRE Loan No 504191071 m SalesDataUPdatev1 12 2014 1 26 2015 2 50 42 PM Escrow previously uploaded for this loan FRE Loan No 504191101 April 2015 T Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide S S Homepage RR Validation Failures _ Output to Excel File Name Upload Date Time Loan No Error Description Error Field Value ReserveReportingv1 O3 2014 xls 1 26 2015 3 36 11 PM Columns do not sum Current Balance of all Reserves 78 965 99 LI ReserveReportingv1 Q3 2014 xls 1 26 2015 3 36 11 PM Columns do not sum Current Balance of all Reserves 182 513 62 O ReserveReportingvi O3 2014 1 26 2015 3 36 11 PM Columns do not sum Current Balance of all Reserves 95 193 94 die ReserveReportingv1 Q3 2014 Als 1 26 2015 3 36 11 PM Columns do not sum Current Balance of all Reserves 174 400 92 Ej ReserveReportingvi Q3 2014 x 1 26 2015 3 36 11 PM Columns do not sum Current Balance of all Reserves 0 00 The Validation Failures screen shows each individual field level validation that failed while attempting to upload the file Users can look at each validation failure and address each one in their source file or click the Output to Excel button at the top of the V
10. cla a E April 2015 3 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide Workflow Process The chart below represents the flow of Assessments and Attachments through PRS Warnings Generated April 2015 4 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide Getting Started System reguirements Computer Processor Computer with a 233 megahertz MHz processor or higher Pentium processor recommended Operating System Windows 7 Windows XP 32 bit with Service Pack 2 SP2 or higher Windows XP Professional x64 Edition Windows Vista 32 bit Windows Vista 64 bit Windows Vista with Service Pack 1 SP1 or higher Windows Server 2003 32 bit with Service Pack 2 SP2 or higher Windows Server 2003 64 bit with Service Pack 2 SP2 or higher Windows Server 2008 32 bit or higher Windows Server 2008 64 bit or higher Windows 7 128MB Windows XP 32 bit with Service Pack 2 SP2 or higher 64 MB Windows XP Professional x64 Edition 128 MB Windows Vista 32 bit 512 MB Windows Vista 64 bit 512 MB Windows Server 2003 32 bit with Service Pack 2 SP2 or higher 64 MB Windows Server 2003 64 bit with Service Pack 2 SP2 or higher 128 MB Windows Server 2008 32 bit 512 MB Windows Server 2008 64 bit 512 MB Hard Disk Space April 2015 Windows 7 150MB Windows XP 32 bit with Service Pack 2 SP2 or higher 150 MB Windows XP Professional x64 Edition 200 MB Windows Vi
11. on multiple records To select multiple rows check the box on the left side of each row To perform an action on these rows click the appropriate button on the Grid Menu April 2015 29
12. wish to add a user too and click the Add New Button Then select the User from the Drop Down Box you wish to add and slick Save Only a single role may be assigned to a User at any time April 2015 13 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide S S Homepage Role Assignment RR S S Admin RR S S Read Only o RR S S User Add New Delete Users Please Select User Role RR S S User Team Freddie Mac Demo Servicer 4 RR Upload Failures The Upload Failures page provides a list of uploads that have failed during the upload process and includes a description of the error S S Homepage RR Upload Failures Output to Excel IC File Name Upload Date Time v Error Description Field Name Value CH SalesDataUPdatev1 12 2014 Als 1 26 2015 2 50 42 PM Escrow previously uploaded for this loan FRE Loan No 504190970 OI SalesDataUPdatev1 12 2014 Als 1 26 2015 2 50 42 PM Escrow previously uploaded for this loan FRE Loan No 504191063 m SalesDataUPdatevi 12 2014 xls 1 26 2015 2 50 42 PM Escrow previously uploaded for this loan FRE Loan No 504191071 b fal SalesDataUPdatevi 12 2014 xls 1 26 2015 2 50 42 PM Escrow previously uploaded for this loan FRE Loan No 504191101 RR Validation Failures The Validation Failures page provides a list of field level validations that failed during the upload process and includes a description each validation failure S S Homepage RR V
13. 2014 Current Balance 5 100 000 00 Current Balance 5100000 00 Current Balance 5 100 000 00 Current Balance 1 5 100 000 00 Current Balance 1 5100000 00 Current Balance 1 5 100 000 00 of Times 30 Delinquent 0 of Times 30 Delinquent 0 Note Rate 0 04260 Note Rate 0 0426000 Note Rate 0 04260 Loan Terms 84 Loan Terms 84 Loan Terms 84 Amortization Terms 360 Amortization Terms 0 Amortization Terms 360 Interest Only Period 12 Interest Only Period 12 interest Only Period 12 Data Warnings Data Warnings section on Loan Details displays all warnings associated with a particular loan for the current month Example tenho er Loan Details Seles Data Wimings La Deas IR ek Vi Na DN NI bwn Mm Mie M yddo us Kuren Gate een Lee 5i membr hy A3 ent Dr FM had by dad yd e f April 2015 25 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide Common Controls Grids Many screens in PRS are grid based that include similar functionality This functionality is enabled as needed on each grid and is not be available on all pages depending on required functionality This section reviews the basic functionality of the grids that applies across the system Sorting If sorting is enabled users are able to sort the grid by any column by clicking on the column header The sorting function toggles between three modes e ascending e descending no sort _ CustomerlD CompanyName ContactName ContactTitle
14. 27 33 PM test Demo Servicer User 1 21 2015 5 26 26 PM test View All View All Queue displays all warnings for the current month This is a read only queue displaying warnings that are currently in S S Under Review FM Under Review and FM Final Approval S S Sales Data Update View All Drag a column header and drop it here to group by that column Output to Excel IL FM Loan No S S Name S S No Field Name Warning Warning Status S S Eu El ba uu Wl Original Amortization must be exact match with FM Preliminarly geg Amortization Term months 360 E View Comments FM Loan Term Approved z TT Monthly Debt Service Payment Monthly Debt Payment Amortizing must be FM Preliminarly m Perne ACE LU AMORTIZING within 99 Conds ok FHA vake Barod aal m Demo Servicer 3 Division 3 cd Hi ni bnd Original Amortization must be exact match with FM Preliminarly 260 FM Loan Term Approved Context Menu Items these apply to items selected on the Grid 1 View Comments Allows user to view comments on warnings individually This action cannot be performed in bulk Freddie Mac B D Data Warning Comments View View Existing Comments CommentedBy CommentedOn Comments RRS FM Business Admin 1 21 2015 5 27 33 PM test Demo Servicer User 1 21 2015 5 26 26 PM test April 2015 18 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide Due The Due Queue includes all loans that are Due and currently Unde
15. Debt Service Payment Monthly Debt Payment Amortizing must be within a E EES c i SE 354 37 26 201 L Demo Servicer 3 Division 3 AMORTIZING 99 Cents of FM value 181186 76 181354 3 01 26 2015 Command Bar Menu Items these apply to items selected on the Grid 1 Accept FM Value Allows user to accept the Freddie Mac value displayed in the grid and change warning status to Accepted This action can be performed in bulk by selecting multiple warnings Freddie Mac B e D F Accept FM Value S S Loan No FM Loan No S S Name Warning Field Name S S Value FM Value Demo Servicer 3 Original Amortization must be exact match with FM Loan Term Amortization Term months 360 0 Are you sure you want to accept the FM Value Submitted By demouser3 Submitted On 1 26 2015 12 17 02 PM Yes No 2 Send to Freddie Mac Under Review Allows user to send warning to Freddie Mac to review the data by changing warning status to FM Under Review and reguires to comment This action can be performed in bulk by selecting multiple warnings April 2015 15 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide y U u El Freddie Mac gt G amp G DH Return to Freddie Mac Under Review S S Loan No FM Loan No S S Name Field Name S S Value FM Value Demo Servicer 3 City of mortgage property must be exact match with FM City Property City ORLANDO Clearwater Demo Servicer
16. Financial Test Contact Superviserl 5300 Peachtree RD Atlanta Georgia 30341 404 275 1251 Sales Data Summary The Sales Data Summary Dashboard provides a summary of the Sales Data Loan and Warning summary status by portfolio for the current month History pipelines can be accessed via reports S S Homepage Sales Data Summary RR SIS Homepage Sales Data Loans Summary H Output to Excel S S Name Portfolio S S Number Due Under Review Due Under Review Accepted Accepted Approved Approved Total Demo Servicer 3 Demo Servicer 3 Division 3 0 0 00 43 67 19 21 32 81 0 0 00 64 0 43 21 0 64 S S Homepage Sales Data Warnings Summary Output to Excel S S Name Portfolio S S Number S S Under Review 96 S S Under Review FM Under Review FM Under Review S S Accepted S S Accepted FM Accepted 96 FM Accepted FM Under Final Review 96 FM Under Final Review Total SE a ag 101 100 00 95 0 00 0 0 00 0 0 00 0 0 00 101 101 0 0 0 101 Reserve Reporting Summary The Reserve Reporting Summary Dashboard provides a summary of the Reserve Reporting Loan and Warning Summary status by portfolio for the current month History pipelines can be accessed via reports April 2015 11 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide S S Homepage Rsv Reporting Summary RR _ S S Homepage Rsv Reporting Loans Summary Output to
17. View View Existing Comments CommentedBy CommentedOn RRS FM Business Admin 1 21 2015 5 27 33 PM Demo Servicer User 1 21 2015 5 26 26 PM FM Final Approval The FM Final Approval Oueue is populated by warnings Preliminarily accepted by FM to accept the Seller Servicer Value or warnings that have updated value The warning status for warnings in this gueue is FM Preliminary Approved S S Sales Data Update FM Final Approval Drag a column header and drop it here to group by that column Output to Excel FM Loan No S S Name S S No Field Name Warning S S Value i Wl a q Original Amortization must be exact match with FM 360 m Demo Servicer 3 Division 3 Amortization Term months Loan Term E Monthly Debt Service Payment Monthly Debt Payment Amortizing must be within View Comments AMORTIZING 99 Cents of FM value Original Amortization must be exact match with FM 360 Loan Term LR bal ed LR Page In o E Demo Servicer 3 Division 3 Amortization Term months Context Menu Items these apply to items selected on the Grid 1 View Comments Allows user to view comments on warnings individually This action cannot be performed in bulk April 2015 17 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide Freddie Mac B G O Data Warning Comments View View Existing Comments CommentedBy CommentedOn Comments RRS FM Business Admin 1 21 2015 5
18. ZZ E i E Z Z zz Freddie A Mac W Multifamily D Za Wr ai WAAAY Reserve Reporting Seller Servicer User Guide April 2015 1 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide Table of contents IR OH CHOR I OF DN GU aot arsed DYA UO UO GADDO CU o 3 Keel 3 WV OPTION PTOC amp ES S naccnnasanciadunaatgbenesimaiiauseanienedenauidedeaglenodenauidudenleaedsnauiauseagleaedenauimedeanlaaudeanuntuaeant 4 E El Te eo et E 5 el Ee WL LC EFYRNWY NF FR HF EFE FRYN N FF TYNN DFTN NNFANW 5 Beigl E 6 Upload Eiles erru YYYY HYAY LAHH LLA LLA LEL L LLYR LEL LLE L LLE HELA LLE GYLLELL HALE DELE LEL DR FR DELE LLE LLE YL Y FLuniu 7 How to Upload an Individual RR Ee 7 REDONO ee ee REF NN ee ee ee ee ener ee en eee re eee eee 9 Y PCC OUI EE 10 nange PASS WON NYD FAN EN NN FF NF RY NF FN REF YH RF RF NWFN FN NN NU YN FFF NN NNNW R 10 Sarl e oo E 10 lei 11 Se EE 11 EEN eege ee ee ee 11 Reserve Reporting SUMMA EE 11 Bs cu Fu LL I FR FFFRY z E EE 12 Role ASS IIMs E 13 RR Upload Reg UE 14 RR Validation TI 14 aeS DIa Upda OU UG e CUT Cg GOD DD E GN EDD Co DN DALO 15 EEN 15 sai 0 8 a1 ah TT 17 FM Final Approval nr YYYY YAA LAL LLY H RL LLY LEL LEL LLE RE LLE RE LLE RL LEE H LLE LE EE RE DDE LLD FF nny 17 VION EE 18 DUG e E 19 AC OL O WEE 19 RESENSEER DOT Be ETH 20 o Eege 20 VUNG CE TE 22 FM Final Teielte VIN 23 El 23 BI 24 ANG 2 6 210 A ee eee er er er eT eT er er err re rrr rT T
19. alidation Failures April 2015 _ Output to Excel di File Name Upload Date Time Loan No Error Description Error Field Value i ReserveReportingv1i Q3 2014 xls 1 26 2015 3 36 11 PM Columns do not sum Current Balance of all Reserves 78 965 99 H CH ReserveReportingv1 Q3 2014 xls 1 26 2015 3 36 11 PM Columns do not sum Current Balance of all Reserves 182 513 62 f ICH ReserveReportingv1 Q3 2014 xls 1 26 2015 3 36 11 PM Columns do not sum Current Balance of all Reserves 95 193 94 CL ReserveReportingv Q3 2014 xls 1 26 2015 3 36 11 PM Columns do not sum Current Balance of all Reserves 174 400 92 g mj ReserveReportingv1i Q3 2014 xls 1 26 2015 3 36 11 PM Columns do not sum Current Balance of all Reserves 0 00 14 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide Sales Data Update Oueue All Warning and Loan Queues in the system use the Grid control Basic functionality of the Grids is described in the Common Controls section of this User Manual Functionality specific to each page is described below Warnings move through the Gueues S S Under Review FM Under Review and FM Final Approval Loans move through the Due and Accepted Gueues Loans with one or more warnings Under Review will be in the Due Oueue until warnings have been accepted and or approved and then will be moved to the Accepted Queue by the system S S Under Review Warnings under review by Seller Servicer
20. alidation Failures display grid to export all validation failures to Microsoft Excel Once in Excel users can sort filter as desired while still addressing each validation failure in their source file Once all validation failures are addressed the file can be re uploaded via the same procedures as described above April 2015 8 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide Reports The reports menu shows the list of available reports that can be previewed printed Home Upload Reports My Account Help Freddie Mac Property Reporting System PRS EE Output Type _ Seller Servicer Summary Report Reserve Reporting Validation Upload Error Report April 2015 9 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide My Account Change Password To view or update your User Profile perform the following functions 1 On the Main Menu go to the My Account drop down menu and select Change Password Home Reports My Account Help Change Password Property Reporting System PRS 2 Enter your current password and new password twice Click Change Password Home Reports My Account Help Freddie Z Mac Property Reporting System PRS Change Password Current Password New Password Confirm Password Change Password Forgotten Password Go to the Login page Click Forgot your password Enter your username
21. e the sort order of the grouping click the down arrow in the GridGroupPanel for that item Received Received From Folder name Size wr Received from date Monday March 28 2005 3 28 2005 EWarnerEweb com Drafts 2 3 26 2005 NBullard web com Deleted Items a 3 28 2005 TSholl web com Deleted Items 9 3 28 2005 SWardBweb com Deleted Items 65 3 28 2005 GTomlinson web com Drafts 6 w Received from date Sunday March 27 2005 3 27 2005 FOuncan web com Deleted Items 54 3 27 2005 KAnn web com Drafts 2 To add fields to the grouping drag the header into the GridGroupPanel April 2015 27 Freddie Mac Multifamily SupplierlD 1 CaterinrwlD 1 Chal Chang CatesnrwlD 2 Anzeed Syrup SupplierlD 2 lt CatersnrwlD 2 Chet Anton s Laun 2 Seasoning Louisiana Fiery Hot Reserve Reporting Seller Servicer User Guide 10 boxes x 20 bags 24 1207 bottles 12 550 mi bottles 18 14 10 465 6 oz jars 22 Some grids have a default grouping enabled and the user is able to override this default by adding or removing items to the GridGroupPanel If the user leaves the page and returns the grid will return to the default grouping Row Selection Selecting a Row with a Click Users can select a single data row in the grid by left clicking anywhere within the row Customer ALFEI AMATR ANTON AROLIT BERGS Change page 2 P Company Alfreds Futterkiste Ana Truj
22. eader and drop it here to group by that column Output to Excel Accept EM Value Send to Freddie Mac Under Review Add a Bulk Comment lLl FM Loan No S S Name S S No Field Name Warning S S Value FM Value Creation Date S S Subr x al Y iw yl Tal a View Add Comments B City of mortgage property must be exact match with FM City CH Demo Servicer 3 Division 3 Property City City of mortgage property must be exact match with FM City URBANDALE Des Moines 01 26 2015 mi Demo Servicer 3 Division 3 Property City City of mortgage property must be exact match with FM City HARRISON Harrison Township 01 26 2015 m Demo Servicer 3 Division 3 Property City City of mortgage property must be exact match with FM City CLINTON Clinton Township 01 26 2015 Command Bar Menu Items these apply to items selected on the Grid 1 Accept FM Value Allows user to accept the Freddie Mac value displayed in the grid and change warning status to Accepted This action can be performed in bulk by selecting multiple warnings Freddie Mac gt amp D ES Accept FM Value j S S Loan No FM Loan No S S Name Warning Field Name S S Value FM Value Demo Servicer 3 City of mortgage property must be exact match with FM City Property City WASHINGTON Washington Twp i Demo Servicer3 City of mortgage property must be exact match with FM City Property City URBANDALE Des Moines i Are you sure you
23. ie Mac Multifamily Reserve Reporting Seller Servicer User Guide Freddie Mac m G D Data Warning Comments View View Existing Comments CommentedBy CommentedOn RRS FM Business Admin 1 21 2015 5 27 33 PM Demo Servicer User 1 21 2015 5 26 26 PM Due The Due Queue includes all loans that are Due and currently Under Review S S Reserve Reporting Due Drag a column header and drop it here to group by that column Output to Excel II FM Loan No Servicer Loan Number Servicer No Mortgage Loan Servicer Property Name City LZ uu LY ha ha Lt Washington dn View Loan Details Demo Servicer 3 Division Milwaukie Demo Servicer 3 Division 1 INGLEWOOD imie E Context Menu Items these apply only to a single selected Assessment 1 View Loan Details Opens a new page with uploaded tape details with which this Loan is associated including data warnings if any Accepted The Accepted Gueue includes Loans that were reviewed by Freddie Mac and Seller Servicer This gueue also includes Loans that have no data warnings and were accepted immediately during upload S S Reserve Reporting Accepted Drag a column header and drop it here to group by that column Output to Excel Ll Population Date S S Name S S No FM Loan No S S Loan No Property Name S S Accepts FM Acce kd bd kd kd ug kd UL 01 26 2015 aiaiai 3 Division 1 FA View Loan Deta
24. illo Emparedados y helados Antonio Moreno Taqueria Around the Horn Berglunds snabbkop Selecting a Row with a Checkbox Contact Maria Anders Ana Trujillo Antonio Moreno Thomas Hardy Christina Berglund Country Germany Mexico Mexico UK Sweden Displaying page 1 of 19 tems 1 to 5 of 91 If available users can select one or more data rows in the grid by clicking the check box within the row April 2015 29 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide F CustomerlD CompanyName Contactame Country ALEN Alfreds Futterkiste Maria Anders Germany AMATRA Ana Trujillo Emparedados y helados Ana Trujillo Mexico ANTON Antonio Moreno Taqueria Antonio Morena Mexico AROUT Around the Horn Thomas Hardy URK BERGS Berglunds snabbk p Christina Berglund Sweden Change page 4 P Displaying page 1 of 18 items 1 to 5 nf 91 Context Menu The Context Menu or Right click Menu is used to perform an action on a single record While hovering over a row on a grid click the right button on the mouse to bring up the Context menu The Context Menu offers a limited set of choices that are available in the current state or context of the items on the grid 4 Trouble Ticket New Trouble Ticket 1 22 2008 7 43 15 PM New Trouble Ticket 1 22 2008 7 43 16 PM New Trouble Add PM New Trouble Equipment Request Help Desk Question Grid Menu The Grid Menu is used to perform an action
25. ils Ll 01 26 2015 wrermrwerydf 3 Division 3 0 0 E 01 26 2015 Demo Servicer 3 Division 3 0 0 Context Menu Items these apply only to a single selected Assessment 1 View Loan Details Opens a new page with uploaded tape details with which this Loan is associated including data warnings if any April 2015 24 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide Loan Details Loan Details Loan Details Overview provides information regarding the loan Data on this section is being populated from the Population File Loan Details Sales LG Loan Details Sales Loan Details ads DH DH SN e Loan Details Overview ee aa FM Loan No Servicer Loan Number S S No S S Name Demo Servicer Division 1 Property Name S City State Freddie Mac Property Number In the Loan Details section users can view details of the Seller Servicer tape Population Tape and Final Value In addition users can compare the data discrepancies by comparing the three columns of data If Seller Servicer tape value column appears blank a tape has not yet been uploaded or if the Fields in the Final Value column are blank there is an outstanding warning waiting to be accepted and or approved Loan Details Sales Seller Servicer Tape Value Population Upload Value Final Value City City City State State State Due Date of Last Paid Installment 11 01 2014 Due Date of Last Paid Installment 11 01 2014 Due Date of Last Paid Installment 11 01
26. l 3 C Context Menu Items these apply to items selected on the Grid 1 View Comments Allows user to view comments on warnings individually This action cannot be performed in bulk Freddie Mac B G D Data Warning Comments View View Existing Comments CommentedBy CommentedOn Comments RRS FM Business Admin 1 21 2015 5 27 33 PM test Demo Servicer User 1 21 2015 5 26 26 PM test View All View All Queue displays all warnings for the current month This is a read only queue displaying warnings that are currently in S S Under Review FM Under Review and FM Final Approval S S Reserve Reporting View All Drag a column header and drop it here to group by that column Output to Excel O FM Loan No S S Name S S No Field Name Warning Warning Status S S Value FM Value iz Wl mu UL H H hd hd E R I View Come 3 Property City aa must be exact EM Preliminarly Approved ARBUTUS Baltimore rni P EL City of mortgage property must be exact SC CLEVELAND mj Demo Servicer 3 Division 3 Property City match with FM City FM Preliminarly Approved HEIGHTS CLEVELAND HTS OH Demo Servicer 3 Division 3 Property City EE REE DEAE mp Bee CHARLESTON TEST CITY match with FM City Context Menu Items these apply to items selected on the Grid 1 View Comments Allows user to view comments on warnings individually This action cannot be performed in bulk April 2015 23 Fredd
27. r Review S S Sales Data Update Due Drag a column header and drop it here to group by that column Output to Excel II FM Loan No Servicer Loan Number Servicer No Mortgage Loan Servicer Property Name City State Current Balance x 7 Cig x x Wl e Ei uey dn View Loan Details Vogt e See CH Demo Servicer 3 Uivision 3 Vancouver WA 34 327 000 00 CH Demo Servicer 3 Division 3 PHOENIX AZ 10 000 000 00 Context Menu Items these apply only to a single selected Assessment 1 View Loan Details Opens a new page with uploaded tape details with which this Loan is associated including data warnings if any Accepted The Accepted Queue includes Loans that were reviewed by Freddie Mac and Seller Servicer This queue also includes Loans that have no data warnings and were accepted immediately during upload SIS Sales Data Update Accepted Drag a column header and drop it here to group by that column _ Output to Excel ICH Population Date S S Name S S No FM Loan No S S Loan No Property Name S S Accepts FM Accepts S hs hd __ hd KM ha 3 yd b i 01 26 2015 Dese OF 0 0 o View Loan Details El o1 26 2015 D MG 0 0 ICH 01 26 2015 Demo Seniebr Diwdon 3 0 o Context Menu Items these apply only to a single selected Assessment 1 View Loan Details Opens a new page with uploaded tape details with which this Loan is associated including data warnings if any April 2015 19 Freddie
28. sta 32 bit 70 MB Windows Vista 64 bit 120 MB Windows Server 2003 32 bit with Service Pack 2 SP2 or higher 150 MB Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide e Windows Server 2003 64 bit with Service Pack 2 SP2 or higher 200 MB e Windows Server 2008 32 bit 150 MB e Windows Server 2008 64 bit 200 MB Drive e CD ROM drive if installation is done from a CD ROM Display e Super VGA 800 x 600 or higher resolution monitor with 256 colors Peripherals e Modem or Internet connection e Microsoft Mouse Microsoft IntelliMouse or compatible pointing device Log In You must have a valid user account to access the application The login is located at https multifamily prs covius com On the sign in screen enter your supplied Username and Password Freddie P R S B n Mac Property Reporting System Log In to PRS Welcome to Property Reporting System PRS To access the system enter your user id in the space provided User ID LOGIN April 2015 6 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide Upload Files How to Upload an Individual RR File To upload a bulk RR file Excel format perform the following functions 1 On the Main Menu go to the Upload drop down menu and select Upload Individual RR File Reports My Account Administration Help Upload individual RR File Freddie Mac Property Reporting System PRS 2 This will take you
29. t be exact match with FM City Demo Servicer 3 Property City City of mortgage property must be exact match with FM City Add Comment Context Menu Items these apply to items selected on the Grid 1 View Add Comments Allows user to add custom comments to warnings individually This action cannot be performed in bulk April 2015 21 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide 5 Freddie Mac p h Data Warning Comments View Add View Existing Comments CommentedBy CommentedOn Comments Add Warning Comments i Warning Details City of mortgage property must be exact match with FM City FieldName Property City PopulationFileValue Harrison Township VendorFileValue HARRISON Add New Comments Comments Added By Demo Servicer 3 Comments Added On 1 26 2015 2 18 48 PM FM Under Review The FM Under Review Queue is populated by warnings returned by the S S Under Review Queue The warning status for warnings in this queue is FM Under Review S S Reserve Reporting FM Under Review Drag a column header and drop it here to group by that column Output to Excel TI FM Loan No S S Name S S No Field Name Warning WI SI WI BLOU Demo Servicer 3 Division 3 Property City City of mortgage property must be exact ma m l Property City City of mortgage property must be exact ma m Demo Servicer 3 Division 3 Property City City of mortgage property must be exact ma m
30. to the Upload Individual RR File page Upload Individual RR File This page is ONLY for upload of Bulk Data Excel files Please DO NOT upload Assessment or Attachment files here Select Submit 3 Either enter the file path or click Select and locate your Excel file that is ready for upload Once you have entered the path click Submit The filename of any bulk file must begin with one of the following file naming convention prefixes o SalesDataUpdatev1 Submission Month MM YYYY 6 digit Servicer Number RS e g SalesDataUpdatev1 04 2015 321654 o ReserveReportingv1 Submission Quarter Q N YYYY 6 digit Servicer Number e g ReserveReportingv1 O1 2015 654321 4 The bulk file will upload and you will be provided with a notification outlining any errors o If successful the warnings will be generated in the S S Under Review page o If unsuccessful the uploaded file failed File or Loan validation The type of failure will guide user s to Upload Failures or Validation Failures accessible by clicking the RR Upload Failures or RR Validation Failures link on the left navigation which provides feedback on the reason for failure Failures must be corrected and file must be re uploaded S S Homepage RR Upload Failures Output to Excel ml File Name Upload Date Time v Error Description Field Name Value m SalesDataUPdatev1 12 2014 1 26 2015 2 50 42 PM Escrow previously uploaded for this loan FRE Loan
31. ton next to the filter box the grid displays only the records matching the filter criteria specified using the filter boxes CustomenD CompanyName ContactName C Rm TT Chr gt NoFilter ALFKI Alfreds Futterkiste Contant Ana Trujillo DoesNotContain ANATR Emparedados y helados i Antonio Moreno EndsWith ANTON All filters in a single table are applied using AND operator That is only items grid rows that comply with all filters are displayed Note When you have more than one value to filter on values should be entered separated by a space April 2015 26 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide Grouping If enabled on the grid the grid can be grouped based on the value of a particular column Users can also have multilevel grouping based on different criteria To facilitate grouping a special area called the GridGroupPanel will be displayed at the top of the grid to display the grouping options ordGraupPanel SupplierlD 1 CategorylD 1 10 boxes x 1 hail Bune 15 2 Chang SEN E ig CatesnrwlD 2 Anizeed 12 550 ml 5 FUE i bottles UL supplierlD 2 CategorylD 2 Chef Anton s Cajun 2 45 6 az jars 22 Seasoning Louisiana Fiery Hat When a table is grouped all group fields appear in this group panel as elements with an icon that indicates the sort order To remove a field from the grouping click the X To chang
32. want to accept the FM Value Submitted By demouser3 i Submitted On 1 26 2015 2 17 15 PM j Yes No 2 Send to Freddie Mac Under Review Allows user to send warning to Freddie Mac to review the data by changing warning status to FM Under Review and reguires to comment This action can be performed in bulk by April 2015 20 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide selecting multiple warnings i Freddie Mac Return to Freddie Mac Under Review S S Loan No FM Loan No S S Name Field Name S S Value FM Value Demo Servicer3 City of mortgage property must be exact match with FM City Property City LOS ANGELES WILMINGTON Demo Servicer3 City of mortgage property must be exact match with FM City Property City LOS ANGELES WILMINGTON Demo Servicer3 City of mortgage property must be exact match with FM City Property City LOS ANGELES VENICE Warning Comment Are you sure you want to send waming to Freddie Mac Under Review Submitted By demouser3 Submitted On 1 26 2015 2 17 50 PM 3 Adda Bulk Comment Allows user to insert bulk comments into warnings by selecting multiple warnings from the grid 2 Freddie Mac Add Bulk Comments Add Bulk Warning Comments FM Loan No S S Loan No Company Name FieldName Warning Details Demo Servicer 3 Property City City of mortgage property must be exact match with FM City Demo Servicer 3 Property City City of mortgage property mus
33. y 24 LOAN 18 E 25 LOAM I CLAMS FYRFYFYR YRR EEE EEEE EEEE EAEE E 25 REENEN 25 cC Omni COD te 26 E IL 26 SOO E 26 Filtering E 26 RO el Te EE 27 ROW SS BE 28 Selecting a Row with a Check 28 Selecting a TOW Witht a GieChKDOX EE 28 Eege 29 ACL ISU NEE 29 April 2015 2 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide Introduction Welcome Freddie Mac s Reserve Reporting RR functionality within the Property Reporting System PRS has been developed to facilitate the workflow process of collecting and validating each of the following escrow and loan bond terms data from Sellers Servicers HFS amp HFI and Bond loans RR will enable Sellers Servicers to view key data about their active FreddieMac loans online electronically upload escrow and loan terms data in bulk view discrepancies update individual data elements online and add comments relative to discrepancies Warnings move through the Queues S S Under Review FM Under Review and FM Final Approval Loans move through the Due and Accepted S S Under Review Warnings under review by Seller Servicer FM Under Review Warnings under review by Freddie Mac FM Final Approval Warnings awaiting Final Approval by Freddie Mac View All All of the above warnings Due Loans due from Seller Servicer or Under Review Accepted All loans when all warnings associated with a loan has been Accepted and or Approved or when a loan does not have any discrepancies
34. y of mortgage property must be exact match with FM City FieldName Property City PopulationFileValue Clearwater VendorFileValue ORLANDO Add New Comments Comments Added By Demo Servicer 3 4 Comments Added On 1 26 2015 12 34 31 PM April 2015 16 Freddie Mac Multifamily Reserve Reporting Seller Servicer User Guide FM Under Review The FM Under Review Oueue is populated by warnings returned by the S S Under Review Gueue The warning status for warnings in this gueue is FM Under Review S S Sales Data Update FM Under Review Drag a column header and drop it here to group by that column Output to Excel Ll FM Loan No S S Name S S No Field Name Warning S S Value FM Value i hd E ad hd hd ha Original Amortization must be exact match with FM 260 0 REENEN Amortization Term months View Comments Loan Term ES g Ss 7 Ee Monthly Debt Service Payment Monthly Debt Payment Amortizing must be within Demo Servicer 3 Division 3 AMORTIZING 99 Cents of FM value 53605 88 53556 34 City of mortgage property must be exact match with ORLANDO Demo Servicer 3 Division 3 Property City FM City Clearwater o og aaa ia a sr at D at st Fas Context Menu Items these apply to items selected on the Grid 1 View Comments Allows user to view comments on warnings individually This action cannot be performed in bulk Freddie Mac B amp D Data Warning Comments
Download Pdf Manuals
Related Search