VALERI_Claims_Bulk_Upload_Template_v20 (6).xlsx

Loan Guaranty Servicing Procedures for Holders and Servicers of VA Guaranteed Loans

VALERI_Claims_Bulk_Upload_Template_v20 (6).xlsx

OMB: 2900-0530

Document [xlsx]
Download: xlsx | pdf

Overview

Introduction v20
Documentation
Required Information
Insurance Advances
Insurance Loss Proceeds
Tax Advances
Special Assessment Advances
Ground Rent Advances
Association Fee Advances
Equip Repair Replace Advances
Yard Maintenance Advances
Winterization Advances
Utilities Advances
Securing Advances
Boarding Advances
Hazard Abatement Advances
Debris Removal Advances
Attorney Fees
Appraisal Fees
Title Fees
Filing Fees
Foreclosure Recording Fees
DIL Recording Fees
Foreclosure Facilitation Fees
Other Fees
Property Inspection Fees
Prepayments
Step Interest Rate Change
ARM Interest Rate Change
SCRA Interest Rate Change
Insurance Policies
Owed Taxes


Sheet 1: Introduction v20

VA Loan Electronic Reporting Interface (VALERI)





Claims Import Spreadsheet





Version 20.0





Effective Date: February 1, 2020












Introduction





Welcome to the VALERI claims import spreadsheet. This spreadsheet is a tool that will allow your organization to submit bulk claims to the Department of Veterans Affairs using the VALERI servicer web portal. VALERI is accessed through Access VA (https://eauth.va.gov/accessva). If you require assistance in using this spreadsheet, please contact your assigned technician.












Required Fields:





A column that contains Required Fields will display a green column header. Please see the Documentation Tab for more information. Insurance Policies and Taxes Owed (tabs) are for VA Purchase Claims only and are colored yellow.



















How to use this spreadsheet:





Each worksheet in this document represents a template for one type of claim line item. Each column in a tab represents the data fields required by the VA for that line item. Each row should contain one line item of the type specified for the tab. For example in the tab titled "Filing Fees", each line would contain one filing fee expense incurred by the servicer. Each column has a specified data type in parentheses next to the column name. These data types are described below.












Data Types:





Text An alphanumeric value. Limited to the length specified on the column.





Money A number with up to 13 digits to the left of the decimal, and two to the right.





Integer A number with no decimal. Limited from 0 to 2,147,483,647





InterestRate A number with 2 digits to the left of the decimal, and 4 to the right





Date A date in the format MM/DD/YYYY




















Sheet 2: Documentation

KEY TO THIS WORKSHEET:
Claim Line Item Type: Each tab on the claim event spreadsheet corresponds to a specific claim line item type that is being reported.
Data Element/Field Name: Select from Lists the data elements to be reported for the event. These data elements correspond to a column heading and must be formatted according to the header requirements.
Column Format: The data type and maximum length of characters for that field.
REQUIRED: Provides guidance to determine if the field is required. On each tab, if the data is a required field, the column name will be highlighted in green. If the field is NOT required, the header will be blue.
NOTE: The tabs Insurance Policies and Taxes Owed are for VA Purchase Claims ONLY. Those tabs are in yellow to denote the difference.




CLAIM LINE ITEM TYPE DATA ELEMENT/FIELD NAME COLUMN FORMAT REQUIRED?




Required Information
(MOST fields must be filled out when reporting any event. The exception is "Date Loan Termination Report to Credit Bureaus". That field is optional.)
VA Loan Number Text
Max: 12 characters
Yes
Original Loan Amount Money (two decimal places) Yes
Property State Select from List Yes
Loan Origination Date Date (MM/DD/YYYY) Yes
Payee Vendor ID (Servicer ID) Text
Max: 6 characters
Yes
Payee Loan Number Servicer Loan Number
Max: 20 characters
Yes
Date Loan Termination Report to Credit Bureaus Date (MM/DD/YYYY) No
Refunds of Insurance Premiums (Money) Money (two decimal places) Yes
Tenant Rents (Money) Money (two decimal places) Yes
Escrow Credit Balance (Money) Money (two decimal places) Yes
Suspended Credits (Money) Money (two decimal places) Yes
Unapplied Origination Buydown Credits (Money) Money (two decimal places) Yes
Interest On Escrow (Money) Money (two decimal places) Yes
Other Credits For Application to Liquidation Expenses (Money) Money (two decimal places) Yes
Other Credits For Application to Advances (Money) Money (two decimal places) Yes
Tax Refunds (Money) Money (two decimal places) Yes




Insurance Advances VA Loan Number Text
Max: 12 characters
Yes
Type Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes
Insurance Effective Date Date (MM/DD/YYYY) Yes




Insurance Loss Proceeds VA Loan Number Text
Max: 12 characters
Yes
Proceeds from Insurance Claim Text
Max: 25 characters
Yes
Date Claim Paid Text
Max: 25 characters
Yes
Date Denied Text
Max: 1 character
No
Proceeds Applied to UPB Text
Max: 6 characters
Yes
Proceeds Applied to Security Text
Max: 9 characters (no dashes)
Yes
Proceeds in Suspense Text
Max: 50 characters
Yes
Date Proceeds Applied to UPB Text
Max: 9 characters (no dashes)
No




Tax Advances VA Loan Number Text
Max: 12 characters
Yes
Type (Select from List) Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes




Special Assessment Advances VA Loan Number Text
Max: 12 characters
Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes




Ground Rent Advances VA Loan Number Text
Max: 12 characters
Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes




Association Fee Advances VA Loan Number Text
Max: 12 characters
Yes
Type (Select from List) Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes




Equip Repair Replace Advances VA Loan Number Text
Max: 12 characters
Yes
Type (Select from List) Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes
Work Completion Date Date (MM/DD/YYYY) Yes




Yard Maintenance Advances VA Loan Number Text
Max: 12 characters
Yes
Type (Select from List) Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes
Work Completion Date Date (MM/DD/YYYY) Yes




Winterization Advances VA Loan Number Text
Max: 12 characters
Yes
Type (Select from List) Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes
Work Completion Date Date (MM/DD/YYYY) Yes




Utilities Advances VA Loan Number Text
Max: 12 characters
Yes
Type (Select from List) Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes
Work Completion Date Date (MM/DD/YYYY) Yes




Securing Advances VA Loan Number Text
Max: 12 characters
Yes
Type (Select from List) Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes
Work Completion Date Date (MM/DD/YYYY) Yes




Boarding Advances VA Loan Number Text
Max: 12 characters
Yes
Type (Select from List) Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes
Work Completion Date Date (MM/DD/YYYY) Yes




Hazard Abatement Advances VA Loan Number Text
Max: 12 characters
Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes
Work Completion Date Date (MM/DD/YYYY) Yes




Debris Removal Advances VA Loan Number Text
Max: 12 characters
Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes
Work Completion Date Date (MM/DD/YYYY) Yes
Cubic Yards Removed Number (no decimals) Yes, if Number of Units is reported.
Number of Units Select from List Yes, if Cubic Yards Removed is reported.
Vehicle Removal Select from List Yes, unless Cubic Yards Removed and Number of Units are reported.




Attorney Fees VA Loan Number Text
Max: 12 characters
Yes
Type (Select from List) Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes




Appraisal Fees VA Loan Number Text
Max: 12 characters
Yes
Type (Select from List) Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes
Appraisal Date Date (MM/DD/YYYY) Yes




Title Fees VA Loan Number Text
Max: 12 characters
Yes
Type (Select from List) Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes




Filing Fees VA Loan Number Text
Max: 12 characters
Yes
Type (Select from List) Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes




Foreclosure Recording Fees VA Loan Number Text
Max: 12 characters
Yes
Type (Select from List) Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes




DIL Recording Fees VA Loan Number Text
Max: 12 characters
Yes
Type (Select from List) Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes




Foreclosure Facilitation Fees VA Loan Number Text
Max: 12 characters
Yes
Type (Select from List) Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes




Other Fees VA Loan Number Text
Max: 12 characters
Yes
Type (Select from List) Select from List Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes




Property Inspection Fees VA Loan Number Text
Max: 12 characters
Yes
Payment Amount Money (two decimal places) Yes
Payment Date Date (MM/DD/YYYY) Yes
Date Inspection Completed Date (MM/DD/YYYY) Yes




Prepayments VA Loan Number Text
Max: 12 characters
Yes
Prepayment Amount Money (two decimal places) Yes
Date of Prepayment Date (MM/DD/YYYY) Yes




Step Interest Rate Change VA Loan Number Text
Max: 12 characters
Yes
Change Date Date (MM/DD/YYYY) Yes
New Rate Interest Rate (00.0000) Yes




ARM Interest Rate Change VA Loan Number Text
Max: 12 characters
Yes
Margin Rate (00.00) Yes
Effective Date of Change Date (MM/DD/YYYY) Yes
ARM Interest Rate Caps Interest Rate (00.0000) Yes
Hybrid ARM Loan Terms Select from List Yes




SCRA Interest Rate Change VA Loan Number Text
Max: 12 characters
Yes
SCRA Relief End Date Date (MM/DD/YYYY) Yes
Effective Date of Interest Rate Change for SCRA Date (MM/DD/YYYY) Yes
Interest Rate for SCRA Change Interest Rate (00.0000) Yes
Insurance Policies
VA PURCHASE CLAIMS ONLY
VA Loan Number Text
Max: 12 characters
Yes
Insurance Type Select from List Yes
Policy Number Text Yes
Name of Carrier Text Yes
Expiration Date Date (MM/DD/YYYY) Yes




Owed Taxes
VA PURCHASE CLAIMS ONLY
VA Loan Number Text
Max: 12 characters
Yes
Tax Parcel Identification Number Text
Max: 30 characters
Yes
Tax Type Select from List Yes
Tax Type Description Text
Max: 12 characters
Yes

Sheet 3: Required Information

(A)VA Loan Number (Text 12) (B)Original Loan Amount (Money) (C)Property State (List) (D)Loan Origination Date (Date) (E)Payee Vendor ID (Text 6) (F)Payee Loan Number (Text 20) (G)Date Loan Termination Report to Credit Bureaus * (Date) (H)Refunds of Insurance Premiums (Money) (I)Tenant Rents (Money) (J)Escrow Credit Balance (Money) (K)Suspended Credits (Money) (L)Unapplied Origination Buydown Credits (Money) (M)Interest On Escrow (Money) (N)Other Credits For Application to Liquidation Expenses (Money) (O)Other Credits For Application to Advances (Money) (P)Tax Refunds (Money)

Sheet 4: Insurance Advances

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date) (E)Insurance Effective Date (Date)

Sheet 5: Insurance Loss Proceeds

(A)VA Loan Number (Text 12) (B)Proceeds from Insurance Claim (Money) (C)Date Claim Paid (Date) (D)Date Denied * (Date) (E)Proceeds Applied to UPB (Money) (F)Proceeds Applied to Security (Money) (G)Proceeds in Suspense (Money) (H)Date Proceeds Applied to UPB * (Date)

Sheet 6: Tax Advances

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date)

Sheet 7: Special Assessment Advances

(A)VA Loan Number (Text 12) (B)Payment Amount (Money) (C)Payment Date (Date)

Sheet 8: Ground Rent Advances

(A)VA Loan Number (Text 12) (B)Payment Amount (Money) (C)Payment Date (Date)

Sheet 9: Association Fee Advances

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date)

Sheet 10: Equip Repair Replace Advances

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date) (E)Work Completion Date (Date)

Sheet 11: Yard Maintenance Advances

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date) (E)Work Completion Date (Date)

Sheet 12: Winterization Advances

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date) (E)Work Completion Date (Date)

Sheet 13: Utilities Advances

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date) (E)Work Completion Date (Date)

Sheet 14: Securing Advances

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date) (E)Work Completion Date (Date)

Sheet 15: Boarding Advances

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date) (E)Work Completion Date (Date)

Sheet 16: Hazard Abatement Advances

(A)VA Loan Number (Text 12) (B)Payment Amount (Money) (C)Payment Date (Date) (D)Work Completion Date (Date)

Sheet 17: Debris Removal Advances

(A)VA Loan Number (Text 12) (B)Payment Amount (Money) (C)Payment Date (Date) (D)Work Completion Date (Date) (E)Cubic Yards Removed (Number) (F)Number of Units (List) (G)Vehicle Removal (List)

Sheet 18: Attorney Fees

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date)

Sheet 19: Appraisal Fees

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date) (E)Appraisal Date (Date)

Sheet 20: Title Fees

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date)

Sheet 21: Filing Fees

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date)

Sheet 22: Foreclosure Recording Fees

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date)

Sheet 23: DIL Recording Fees

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date)

Sheet 24: Foreclosure Facilitation Fees

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date)

Sheet 25: Other Fees

(A)VA Loan Number (Text 12) (B)Type (List) (C)Payment Amount (Money) (D)Payment Date (Date)

Sheet 26: Property Inspection Fees

(A)VA Loan Number (Text 12) (B)Payment Amount (Money) (C)Payment Date (Date) (D)Date Inspection Completed (Date)

Sheet 27: Prepayments

(A)VA Loan Number (Text 12) (B)PrePayment Amount (Money) (C)Date of Prepayment (Date)

Sheet 28: Step Interest Rate Change

(A)VA Loan Number (Text 12) (B)Change Date (Date) (C)New Rate (Interest Rate)

Sheet 29: ARM Interest Rate Change

(A)VA Loan Number (Text 12) (B)Margin (C)Effective Date of Change (Date) (D)ARM Interest Rate Caps (E)Hybrid ARM Loan Terms (List)

Sheet 30: SCRA Interest Rate Change

(A)VA Loan Number (Text 12) (B)SCRA Relief End Date (Date) (C)Effective Date Of Interest Rate Change For SCRA (Date) (D)Interest Rate For SCRA Change (Interest Rate)

Sheet 31: Insurance Policies

(A)VA Loan Number (Text 12) (B)InsuranceType (List) (C)PolicyNumber (Text) (D)NameOfCarrier (Text) (E)ExpirationDate (Date)

Sheet 32: Owed Taxes

(A)VA Loan Number (Text 12) (B)TaxParcelIdentificationNumber (Text) (C)TaxType (List) (D)TaxTypeDescription (Text)
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy