VALERI info requested

VA Loan Electronic Reporting Interface (VALERI)
Claims Import Spreadsheet
Version 19.1

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 located at
https://www.vbavaleri.com. If you require assistance in using this spreadsheet, please contact your assigned
technician.

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 13 digits to the left of the decimal, and two to the right.

Integer

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

InterestRate

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

Date

A date in the format YYYY-MM-DD

Optional Fields:
A column that is optional will display an asterisk "*" in the column name.

VALERI-R Notes:
4/10/18: Removed the Foreclosure Buydowns and Origination Buydowns tabs
4/10/18: On the SCRA Interest Rate Change Tab, Removed column (B) SCRA Relief Requested Date and (C) SCRA Relief Effective Date. Remo
5/18/18: Added Match Criteria to Required Information Tab
5/18/18: Added New Step Rate Tab
5/18/18: Updated Debris Removal/Vehicle Removal to Drop Down Values
11/07/18: Added State Pre-Foreclosure Fee to OtherFees
11/07/18: Added Insurance Policies and Owed Taxes Tab
12/28/18: Updated Insurance Policies type
PRIVACY STATEMENT
FEDERAL STATUTES PROVIDE SEVERE PENALTIES FOR FRAUD, INTENTIONAL MISREPRESENTATION, CRIMINAL
CONNIVANCE OR CONSPIRACY PURPOSED TO INFLUENCE THE ISSUANCE OF ANY GUARANTY OR INSURANCE BY THE
SECRETARY OF VETERANS AFFAIRS (e.g. 18 U.S.C. § 1001, 372 and 287)
26-1874, 26-1874a, 26-6850a, 26-8778, 26-6850, 26-6851, 26-8903, 26-8802, JUL 2016 -OMB Control No. 2900-0021, Respondent Burden: 1 minute, Expiration Date: 6/30/2020

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