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)

(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)

(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 Type	application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified	0000-00-00
File Created	0000-00-00