ATTACHMENT_D_Reporting_Library.pdf
PDF 147 KB Posted
- Solicitation number
- VA119A17R0010
About this file
Attachment D - Reporting Library
View the file
Other files
| File | Type | Posted |
|---|---|---|
| ATTACHMENT_H_Pricing_Spreadsheet_Reviewed_Per_Amendment_A00003.xls | XLS spreadsheet | |
| VA119A-17-R-0010_A00003.pdf | ||
| VA119A-17-R-0010_A00002.pdf | ||
| VA119A-17-R-0010_A00001.pdf | ||
| ATTACHMENT_K_Answers_to_RPSC_Questions.docx | DOCX document | |
| ATTACHMENT_J_Past_Performance_Questionnaire.docx | DOCX document | |
| ATTACHMENT_G_Fee_Attorney_Contract_Provisions.pdf | ||
| ATTACHMENT_I_TECHNICAL_EVALUATION_MATRIX.xls | XLS spreadsheet | |
| ATTACHMENT_F_PROPERTY_PRESERVATION_FLAT_FEE.docx | DOCX document | |
| VA119A-17-R-0010_Final.docx | DOCX document | |
| ATTACHMENT_A_RPSC_Related_Documents.pdf | ||
| ATTACHMENT_B_Background_Investigation_Worksheet.docx | DOCX document | |
| ATTACHMENT_H_Pricing_Spreadsheet.xls | XLS spreadsheet | |
| ATTACHMENT_C_Schedule_of_Deliverables.docx | DOCX document | |
| ATTACHMENT_E_QASP.docx | DOCX document | |
| VA119A-17-R-0010-000.docx | DOCX document |
Show all 16
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
ID Report Name Due Dates Contract Current Data Fields Purpose
1 VA BAM Report 5th Federal working day after Quarter end.
Portfolio Summary Section: Date; Total Loans; Monthly Decrease; Balance @ Maturity Monthly Detail: VA#; Contractor#; VA Type; PRIBAL; PAYTHRUDATE;
MATDTE; Remaining Term; ORIGTERM; NOTRAT; PRINPT; Balance at Maturity; WARNCD; INVREF; STNAME; Last Pmt Rec; Origination Date;
Actual Board Date; Needed Balance; Balance Diff; Payment; Pmt Diff out FCL Loan Detail: VA#; Contractor#; VA Type; PRIBAL;
PAYTHRUDATE; MATDTE; Remaining Term; ORIGTERM; NOTRAT;
PRINPT; Balance at Maturity; WARNCD; INVREF; STNAME; Last Pmt Rec; Origination Date; Actual Board Date; Needed Balance; Balance Diff; Payment; Pmt Diff out BK Loan Detail: VA#; Contractor#; VA Type; PRIBAL; PAYTHRUDATE;
MATDTE; Remaining Term; ORIGTERM; NOTRAT; PRINPT; Balance at Maturity; WARNCD; INVREF; STNAME; Last Pmt Rec; Origination Date;
Actual Board Date; Needed Balance; Balance Diff; Payment; Pmt Diff out
This report is to a list of all VA portfolio loans which will have a Balance at Maturity (BAM). The VA needs this list to be able to make a business decision on how to fix these loans.
2 VA NADL Report 5th Federal working day
Portfolio Three tabs (Active, Paid-off, and Delinq). Data fields are: VA#;
Contractor#; NAME1; NAME2; ADDRS; CTYST; ZIP; STNAME;
ORIGAM; AI Codes; INTPTD; Date of Mtg; INVREF; NOTRAT; Principle Balance; RLC
This is a report of all NADL loans (active an inactive) and includes the MOU codes (AI Codes) which is a unique field for Native American Properties. Report is sent out to all the RLCs.
3 VA Equator Reconciliation
On Demand REO VA Loan #|Asset ID|City|State|Address|Date Created in SP|Disposition Date|Asset Status|Sub Status|Change Date|Prior Owner
It is a monthly reconciliation between the SP system and VA system.
4 VA Portfolio Billing As outlined in Section B.2 of the contract.
Portfolio Invoice files sent monthly on the loan portfolio to request payment on REO billing
Invoice files sent monthly on the loan portfolio to request payment on REO billing.
5 VA FUND&COHORT 5th Federal working day
Portfolio VA#; BOARDD; Cohort; Board Month; PRIBAL; Loan type; ZIP;
ORIGAM; DTEMTG; Investor code, Delinquency Flag, Client #
Report of all VA loans boarded in a given month with the FUND and COHORT data
6 VA Trust Status 5th Federal working day
Portfolio Overall Status (list of all active Vendee loans not in a trust sale) :
BAC#; LOANID; Rate; Current Balance; Scheduled Balance; Pre/Post April; Eligible; Overall; PAYTHRUDATE; Date of Mtg; Overall w/o
BK&FC;
Overview: Summary tab of the custodial status for all active Vendee Loans listing the following:
Total Marketable (loans; over 89 days loans; Actual Balance; Scheduled
UPB)
Loans Passing VA Criteria by Custodial Status (loans; over 89 days loans; Actual Balance;Scheduled UPB) Loans Failing VA Criteria by Custodial Status (loans; over 89 days loans;
Actual Balance; Scheduled UPB) Permanent Deletes (loans; over 89 days loans; Actual Balance;
Scheduled UPB) Historical view of Loans Passing VA Criteria by Custodial Status: (Date, Loan count summary) Vendee Performance Summary – monthly section outline ALL Vendee performance segregates by BAC originated, OCWEN originated, and VA originated. Fields are (Originator; Status, Loans, % of Group) Vendee Originations: Historical Report of all Vendee originations:
Metrics: (Apps; Submissions; Funded Loans; Funding Volume; Month over Month Fundings($) Canceled Loans; Pipeline; TurnRatio) Aging: (1-10; 11-20; 21-30; 31-45; 46-60; 61-90; 90+) Pipeline Aging (% of Pipeline) – (1-10; 11-20; 21-30; 31-45; 46-60; 61- 90; 90+ Pull through (Within 45 day SLA; 30 day Pull through; 60 day Pull through; 90 day Pull through; 120 day Pull through; Avg App to Fund TT)
Report provided to the VA to give a status on Vendee portfolio loans as they relate to adding them to the Vendee Trust
7 VA Trust Extracts Due dates to be set per sale by VA
Portfolio BAC#; LOANID; PMTPITI; PNI; SERVBRANCH; PAYTHRUDATE;
ACTBAL; BNAME; CBNAME; BSTREET1; BSTREET2; BCTYST; BZIP;
PMTESCROW; BALESCROW; ORIGBAL; Rate; ORIGDATE;
FSTPAYDATE; ORIGTERM; MATDATE; PSTREET; PCTYST; PZIP;
PSTATE; PCOUNTY; APPVAL; FHAVACASEPRE; FHAVACASENO;
OCCTYPE; PROPTYPE; SALEPRICE; PARTIALBALANCE;
FIPS_State; FIPS_County; REHAB; TIFPTR; LSTNME; SMP230; LTV;
12 month dot history; RemTerm; Scheduled Balance;
Extract file produced on demand for the VA to pass data out to third parties in order to conduct a Vendee Trust sale.
8 VA Repair Report On Demand REO Report Criteria: Asset Mgr Name/VA LIN #/Amount Spent on Repair/Date of Repair/REO Appraisal Recommended Repair/Lender Required Repair?/Repair Undertaken after offer accepted?/Tran Code/Description/Estimated Repair Costs/ Cost > 1k date mgmt approval/Repair start date/repair end date/Broker Agent Supervised?/Basis for repair/Date added/Item type/path
9 VA+270 Properties by Asset Manager
6th Federal working day
REO Unch
10 VA Financing for Sold Properties
6th Federal working day
REO Type of Financing Tab: Criteria reflects by Asset Mgr/Type of Financing and the total number of Financing types.
Sold Property Data Tab: Criteria reflects Lender ID/Contractor#/REO #/Address/Status/Offer Accepted Date/Closing Date/Type of financing/Asset Mgr
11 VA Flash 6th Federal
REO VA REO Flash Criteria Tab: Inventory Detail from start to end which includes the total number of acquisitions/dispositions/COES/Adjustments/Agent Inventory by Count and Percentage /Redemption/Closed Escrow by month and fiscal Year.
Key Metric Closings include Average Sales Price/Vendee COEs/Eviction/Average List to Accepted Offers/Average Accepted Offer to COE/Cancellation Counts/Rollover Counts/Controllable count & percentage/Non-Controllable count & Percentage by month and fiscal Year. Key Metric Pipeline include Average Acquisition to Secure Days/No Eviction Needed/Eviction Needed/Avg Secured to List/Relocation Assistance % Accepted to Offer/Vendee Applications, Funded Loans, Funding Volume, Month over month findings, canceled loans, and pipeline. VA Operations include VA Mgmt Fee Income/Operating Expenses, VA Total Monthly Income.
TOP 10 States Criteria Tab: Includes the top 10 states and the total number of properties by property Status.
12 VA Habitable Audit Report (FEMA)
On Demand REO 3 Tabs include the following:
Summary for that week- Habitable & UnHabitable by State/Habitable & UnHabitable by Property Status/Habitable & UnHabitable by Region FEMA Habitable/UnHabitable tab- LN #/VA LN #/Property Status/Task/Address/Region/Stories/Construction/Color Style Exterior/Parking/Description/Stability/For Sale Signs/Negative Factors/Neighborhood Comments/Siding & Trim/Outbuildings/Fence/Ext Trash & Debris/Ext Hazardous & Safety Issues/Pool/Pool Options/Trees/Ext Grass/Ext Landscaping/Winterized/Winterized Date/Broom Cleaned at minimum/Unsanitary Conditions/Int Hazardous & Safety Issues/Mold & Mildew/Ceiling/Walls/Windows/Doors/Floors/Bath Fixtures/Kitchen Fixtures/Light Fixtures/Appliances/Interior Comments/ Following determines if its UnHabitable- Roof – Poor Doors - Poor Windows – Poor Walls – Poor Mold/Mildew – Poor Hazardous Conditions (Internal) – Yes Hazardous Conditions (External) – Yes
Floors – Poor Int. Debris Personal Property - Yes
13 VA Daily Key Metrics Daily REO Report that provides the Key Metrics (points) for the current VA Portfolio.
14 Property Detail Report
5th Federal working day after Quarter end.
REO 3 tabs include the following:
Month Criteria- Account #/VA LIN #/Avg Days-Standing Inv. BAC Boarding (Redemption Adjusted)/Avg. Days-Standing Inv. BAC Boarding/Avg. Days-Standing Inv. VA Acquisition (Redemption Adjusted)/Avg. Days-Standing Inv. VA Acquisition/City & State Month Criteria greater than 270- Account #/VA LIN #/Standing Inventory Days Month NS Original List- Account #/VA LIN #/Net Sale/Orig List/ROS/City & State/Monthly ROS Average
This is part of the Quarterly Report
15 VA-Quarterly-Q1- (2011)
6th Federal working day after Quarter end.
REO VA Quarterly Criteria: Properties Sold/Avg Sales Price/Net Sales Proceeds/Net Sales Proceeds Totals/Latest List Date to Closing Date/Properties Listed/Total Properties listed in Inventory/Avg. Listing Price/Percent of Properties over List Price by Quarter and a total 4 Quarterly comparison, definition/Calculation and Source.
3 tabs include the following:
Month Criteria- Account #/VA LIN #/Avg Days-Standing Inv. BAC Boarding (Redemption Adjusted)/Avg. Days-Standing Inv. BAC Boarding/Avg. Days-Standing Inv. VA Acquisition (Redemption Adjusted)/Avg. Days-Standing Inv. VA Acquisition/City & State Month Criteria greater than 270- Account #/VA LIN #/Standing Inventory Days Month NS Original List- Account #/VA LIN #/Net Sale/Orig List/ROS/City & State/Monthly ROS Average
16 Homeless Provider Report
6th Federal working day
REO 4 Tabs include the following:
Closed/In Process/Denied and/or Withdrawn tabs-VA LIN #/REO Number/Offer Received Date/Offer Acceptance Date/Executed Contract Date/COE Date/Property Address/Homeless Provider/DOM at the time of Offer/Previous offers/list price/offer amount/loan amount/finance type/loan term/interest rate/property type Inquiries- Date/Provider/Contact/Contact Info/Email
17 Auction Report 6th Federal after quarter end
REO Criteria: Month to month comparison regarding the total number of properties auctioned/ percentage auctioned from the VA portfolio/ Total & Percentage properties under contract/Total & Percentage Closed (COE)/Total & Percentage cancelled/Total properties still under contact. Key Metrics is a break down by month regarding the Avg.
Sales Price & Latest REO Appraisal/Avg. Sales Price & Original REO Appraisal/Avg.
Sales Price & Original List Price/Avg. Net Proceeds to Original List Price/ Avg. Sales Price.
18 Final Auction Results 6th Federal after post auction period
REO
19 VA National TB Active loans
5th Federal working day
Portfolio Prev Inv Num; Prev Inv Blk;Contractor#; VA's Loan Number; Beg UPB;
Beg Ln Cnt; UPB - Loans Added; Loan Cnt - Added Loans; Adj Beg UPB; Adj Beg Ln Cnt; Principal; Collections; Loans Removed - New Sale; Writeoffs; Ending UPB; P&I Constant; Interest Paid-to-Date;
Escrow Balance Partial Balance; Payoff Date; Warning Code; Lockout Code; Closed Code; Ending Ln Cnt; New Inv Num; New Inv Blk; First Due; NOTRAT; ORIGAM; TERMLN; MATDTE; Fund; Cohort
20 VA National Tran 940 Reporting_Final
3rd to last Federal working day of month
Portfolio Contractor#, VA NUMBER, TRNTYP, MBSNBR, TRNPRN,WRITEOFF, TOTAL IN ADJSUTMENT, DIFFERENCE, COMMENTS
21 VA National Collection Reporting_ Active Loans - EOM Collections Summary
5th Federal working day
Portfolio Investor #, Block #, Contractor#, VA Loan Number, Principal Collection, Interest Collections, Late Charges, Unapplied Funds, Total Remittance, Notes
22 VA Accrual Reporting work-around for 2nd day reporting
5th Federal Working Day of
Month
Portfolio As Of Date; TransTypeInt; TransTypeLtChg; TransTypePrepaidInt;
RevSourceInt; RevSourceLtChg; LtChg; RevSourcePrepaidInt; RCS Ln Number; VA Ln Number; RCS Investor Number; RCS Block Number;
InvestorName; InterestPTD; NoteRate; PrinShare; CurrInterest;
UncollCurrInt; UncollIntPrev; UnearnedInt; PrePaidInt;
PrePaidIntAccrual; PI_Pymnt; PctOwned; OwnedCd; IntMeth; LoanType;
AccrualFlag; PeriodEnding; PymtCycleCd; VALoan Type; VAFund;
VACohort
Excel forma to pass data at a loan level on the second working day of each month.
23 VA Quarterly Report
15th Calander Day following quarter end.
Portfolio Report has multiple sections and is not at a loan level Section A Receivables and Collections: (1) Beginning FY Balance; (2) New Receivables (+); (3) Accruals (+); (4) Collections on Receivables (- ); (A) At Agency (-); (B) At Third Party (-); (C) Asset Sales (-); (D) Collections by Treasury through Offset and Cross-Servicing (-); (E) Collections by Sale After Foreclosure (-); (F) Collections by Department of Justice (-); (G) Other - must footnote (-); (5) Adjustments (+ or -); (A) Reclassified/Adjusted Amounts (+ or -); (B) Adjustments Due to Sale of Assets (+ or -); (C) Consolidations (+ or -); (D) Foreclosure Adjustments (+ or -); (E) Written-Off Debts Reinstated for Collection (+); (6) Amounts Written Off (-); (A) Currently Not Collectible (-); (B) Written Off and Closed Out (-); (7) Ending Balance;
Section B Additional Receivables Data (Information Only): (1) Subsets
TROR Report of Ending Balance; (A) Foreign/Sovereign Government (+); (B) State and Local Government (+); (C) Rescheduled Debt - Delinquent (+); (D) Rescheduled Debt - Non-Delinquent (+); (E) Interest & Late Charges (+);
Section C Delinquent Debt (Excluding CNC Debts): (1) Delinquencies by Age; (A) 1-90 Days (+); (B) 91-180 Days (+); (C) 181-365 Days (+);
(D) 1-2 Years (+); (E) 2-6 Years; (F) 6-10 Years (+); (G) Over 10 Years (+); (H) Total Delinquencies by Age; (2) Delinquencies by Category; (A) Commercial (+); (B) Consumer (+); (C) Foreign/Sovereign Government (+); (D) State and Local Government (+); (E) Total Delinquencies by Category;
Part II - Debt Management Tool and Technique Performance Data Section A Delinquent Debt 180 Days or Less: (1) Delinquencies 1-180 Days; (A) In Bankruptcy (+); (B) In Forbearance or In Formal Appeals Process (+); (C) In Foreclosure (+); (D) At Private Collection Agencies (+); (E) In Litigation (At DOJ or Agency Counsel) (+); (F) In the Process of Internal Offset (+); (G) In Wage Garnishment (+); (H) At Treasury for Cross-Servicing (+); (I) At Treasury for Offset (+); (J) At Agency (+); (K) Other - must footnote (+); (L) Total Delinquencies 1- 180 Days;
Section B Delinquent Debt (Over 180 Days Delinquent) Eligible for Referral to Treasury for Offset and Cross-Servicing: (1) Debt Eligible for Referral to Treasury for Collection; (A) Delinquent Debt Over 180 Days (+); (B) Currently Not Collectible Debt (+); (C) Total Delinquent Debt Over 180 Days and CNC Debts; Debts Ineligible for Treasury Offset Program (TOP) and Cross-Servicing (lines D through G); (D) In Bankruptcy (-); (E) In Forbearance or Formal Appeals Process (including Litigation) (-); (F) In Foreclosure (-); (G) Other - must footnote (+ or -); (H) Balance of Debt Eligible for Referral to Treasury for Collection; (2) Debt Eligible for Referral to Treasury Offset Program;
(A) Debt Eligible for Referral to Treasury for Collection (from 1H); (B) Foreign/Sovereign Debt (-); (C) Debt in Litigation for Enforced Collection (-); (D) Other - must footnote (+ or -); (E) Debt Required to be Referred to Treasury Offset Program by Agency; (F) Debt Referred to Treasury Offset Program (-); (G) Debt Referred to Treasury Offset Program through Cross-Servicing (-); (H) Balance Remaining to be Referred; (3) Debt Eligible for Referral to Treasury or a Designated Debt Collection Center for Cross-Servicing; (A) Debt Eligible for Referral to Treasury for Collection (from 1H); (B) Foreign/Sovereign Debt (-); (C) Debt in Litigation for Enforced Collection (- ); (D) At Private Collection Agencies (-); (E) In the Process of Internal Offset (-); (F) Debt Exempted by Treasury from Cross-Servicing (-); (G) Debt Returned from Cross-Servicing (-); (H) Other - must footnote (+ or -); (I) Debt Required to be Referred to Treasury or a Designated Debt Collection Center for Cross-Servicing; (J) Debt Referred to Treasury or a Designated Debt Collection Center for Cross-Servicing (-); (K) Balance Remaining to be Referred;
24 VA Invoice Reporting (1A &1B) We prepare & send to
As outlined in Section B.2 of the contract.
Portfolio Service Fee report
Billing
25 VA FORE (related to VA Fore Bi-Weekly Processing) and VA GL (related to Daily gain & loss) reports
5th Federal working day
Portfolio Internal Cumulative Rpt
26 VA Legal Report On Request Portfolio Contractor loan #; va loan #; contractor employee making request; short leagl; former owner; county; notes.
Get Legal descriptions to tax lines can be set up
27 Van Bi-Weekly Report (VAN PL Companion Report)
Due 1 Federal working day after each PL file
Portfolio Contractor#; VA Loan Number; digit; Block Number; Investor; Mortgagor;
Property Address; City; State; Date of Original Loan; Interest Paid to Date; Breach Letter Date; Termination Type; Termination / FCL Department Referral Date; Termination / FCL Attorney Referral Date;
Attorney Number Termination Sale / Payoff Date; Actual Unpaid Principal Balance; Actual Delinquent Interest From INTPTD to Termination / Sale Date (+); Outstanding Fees Due (+); Escrow Balance Suspense Balance(-); Uncollected Late Charges; Total Indebtedness;
"As Is" Appraisal Amount; Net Value to VA at Termination / Sale; VA Bid Amount; Successful Bid Amount; Termination / Sales Results; (Loss)/ Gain to VA; State Fee Exclusion Amount; Actual Loss to VA; Notes;
Reporting of VA Admin Sales.
Report also has a second tab listing the Fund and Cohort for the loans.
28 VA Title Report 1st and 15th of each month (next federal working day if on weekend)
Portfolio The SP has created a suite of 6 separate title reports on demand in the SP system to cove this need.
Status of titles to be sent to VA
29 VA 602 Report 3 Federal working days after receipt of new loan data
Portfolio VA#; Contractor#; NAME1; LNTYPE; SUBCLS; TERMLN; NOTRAT;
INTPTD; PRIBAL; PRINPT; ESCPMT; ESCBAL; SLRACCT#; INVREF;
INVBLK; INCURT; APPRAM; SRFECD; TRANSDTA;Fund: Cohort:
Report sent to VA to obtain Boarding approval for loans.
30 Vendee Boarding Repot
3 Federal working days after receipt of new loan data
Portfolio Contractor#; Previous Servicer Loan#; Mortgagor Name; Property Address; Principal Balance; Escrow Balance; Buydown Amount;
Company Name; Originator #; Originator Name; Investor Reference #;
Boarding Date; Inv. Account No.; Seller Account No.; Fund & Cohort of new vendee loan
Report sent to VA to provide final data on new Vendee loans loaded to
AS400.
31 Advance Payment Escrow
Due dates to be set per sale by VA
Portfolio Loan Count; Fund; Cohort; Investor #; Block #; VA Loan Number;
BAC Loan Number; Scheduled_UPB; [Principal] Prepayments Curtailments; UPB; Note Rate; P&I Constant; Due_MM; Due_YY;
Escrow Balance; Late Charges; Number of Payments Delinquent;
Principal; Delinquent Interest; s/fee; P&I; Month 1 Collected; Month 2 Collected; Month 3 Collected; Month 4 Collected; Month 5 Collected;
Month 6 Collected; Total Collected; Total Uncollected; Status of Uncollected; Date Foreclosure Completed; Number of Payments;
Prepaid Principal; Prepaid Interest; sfee; P&I [Interest]; Paid To Date;
Report to reconcile cash at the end of a trust sale.
32 Vendee Loan Sale 2011-01/Discount Comp Sheet
Due dates to be set per sale by VA
Portfolio Loan Count, Fund Cohort (summary format) Inv Blk, VA Loan Number, BAC Loan Number, Actual Unpaid Principal as of settlement date, PrePd & Curtailment Prinicipal Due Trust,Delinquent Principal to be paid to VA upon Collection, Net Unpaid Principal Balance Sold, Accrued Interest due to buyer-scheduled date of settlement # of days with dates, Delinquent Interest to VA be paid upon collection, Prepaid Interest collected by VA due Trust, Amount due VA
Report to record portfolio loans sold
33 VA Suspense Report 5th Federal working day
Portfolio Contractor loan #; va loan #; state; borrower last name; pbal; next payment due; total arrears; escrow balance; suspense balance. 2nd tab for a roll-up to summary level.
This report shows all funds in suspense on portfolio loans
34 Monthly delinquency report
5th Federal working day
Portfolio
35 VA Scorecard fcl sales report
5th Federal working day
Portfolio Report to rate foreclsure atty performance
36 The monthly low principal balances report
5th Federal working day
Portfolio Report to pass to VA regarding delinquent loans with very low UPB's to help VA decide if a write of is warranted
37 VA BAC Insurance Loss Pending report
5th Federal working day
Portfolio Report to VA on pending insurance loss drafts
38 Quarterly Program Management Status Reports
5th Federal working day after Quarter end.
All
39 Monthly Project(s) Level Status Report
5th Federal working day
All
40 QCP Quarterly Updates
On Request All
41 Quarterly report listing authorized signers and their titles
On Request All
42 Quarterly Insurance Recovery Report
6th Federal working day after Quarter end.
REO
43 Quarterly Report for Federal Asset Sales
6th Federal working day after Quarter end.
REO
44 Electronic record of customer inquiries and responses
On Request Portfolio Report to VA of all correspondence requests and responses for audit purposes.
45 Subcontracting 20 Days after the end of the
Quarterly review with VA
All Format to mirror the data provided in SF294 and SF 295 as directed by
VA.
Report form SP PMO on summary of subcontracting performance
46 VA Pay-Off Report 5th Federal working day
Portfolio VA#, RCS#, Payoff Date A report for VA to list all the loans in their portfolio that have paid off normalled (i.e. not in the FORE report)
47 Rental Report 6th Federal working day
REO • VA LIN
• Property Address
• Name of Tenant
• End Date of Lease
• Amount of Rent Paid
• Date Last Payment Made
• If Payments are not current- Description of Efforts to terminate lease or obtain possession
• Listed subject to tenancy- Yes or no. If yes, current listing status. If no, why not.
• Other expenses made due to occupancy-repair costs to date
Monthly report to pass data to VA on their rental properties
48 LS FLASH See Comments Portfolio To provide a report to VA at a summary level to give an overview of historical performance
49 Deactivation Comparison
Weekly (plan for Monday)
REO Weekly report to ALAC to indicate the discrepancies between an asset being closed in the SP system and still showing open in CPTS. This discrepancy affects the timeline for billing.
50 VA Title Reconveyance
Auto REO All open files that have current "on hold" flag for the reason of reconveyance for management of the title processes.
51 VA Regional Counsel Title Timeline
Auto REO Time for VRC review for both historical and current data grouped by State then timeline brackets.
51 VA Regional Counsel Response Past Due/Late
Auto REO Capture all files in all open statuses that are past due or late of the task "Client Review Title Package"
53 VA Regional Counsel "No Opinion" in Closing Phase
Auto REO Capture files in Awaiting HUD/Proceeds & Sale Pending and are pending client review (title) awaiting approval from VA.
54 VA Cross-Ref Monthly (1st 10 working days)
All VA#; BAC#; RCS#; SP#; Borrower; Address; VA Loan Type; LNTYPE;
SUBCLS; Loan Type BAC; Delinquency Flag; Months Past Due; Interest Paid Thru Date
This is a list of all VA properties in the portfolio dating back to 2001 listing all the companies account numbers and property data.
It is used by VA to more quickly look up accounts thus saving them the trouble and time of reaching out to the contractor(s) past and present for data.
55 Monthly Bi-Weekly 5th Federal working day
Portfolio Contractor#; VA Loan Number; digit; Block Number; Investor; Mortgagor;
Property Address; City; State; Date of Original Loan; Interest Paid to Date; Breach Letter Date; Termination Type; Termination / FCL Department Referral Date; Termination / FCL Attorney Referral Date;
Attorney Number Termination Sale / Payoff Date; Actual Unpaid Principal Balance; Actual Delinquent Interest From INTPTD to Termination / Sale Date (+); Outstanding Fees Due (+); Escrow Balance Suspense Balance(-); Uncollected Late Charges; Total Indebtedness;
"As Is" Appraisal Amount; Net Value to VA at Termination / Sale; VA Bid Amount; Successful Bid Amount; Termination / Sales Results; (Loss)/ Gain to VA; State Fee Exclusion Amount; Actual Loss to VA; Notes;
Report to ALAC combining all Bi- Weekly reports from the ending month into a single report and adding
FUND & COHORT
56 VA Missing Collateral Document Report
5th Federal working day after 1st Monday of the month
Portfolio 3 tabs in Excel:
Tab 1: Summary data and charts for exeutive review Tab 2: Contractor#; VA#; Previous Contractor #; Borrower Name;
Servicing Transfer Date; NADL; VA Type; Delinquency Flag;
SpecialHandlingCode; IC_Yes; NOTE; DEED; IC; Station; Status;
Location Tab 3: List of loans where the RLC has not yet delivered collateral which need to be investigated
Report to VA on the current collateral status of all their loans.
57 Actions to fee attorneys
Monthly Fee Attorney State; property address; VA Loan #; attorney; attorney contact info;
Court; purpose of referral
NPG Oversight of legal actions taken by fee attorney’s
58 Status Report of closed litigation matters
Quarterly and annually
Fee Attorney State; VA Loan #; attorney; attorney contact info; court; action taken;
decision; date of closure; attorney fees charged; number of hours charged if using hourly rate.
NPG Oversight of legal actions taken by fee attorney’s
File details come from the government source that posted it. Updated .