(year).XLS
There will be one file for each year the servicer has inputted data. These files contain all payment data each calendar year and contain the following data:
A. account nmbr Borrower's account number B. Transx Nmbr The overall transaction number from inception of servicing C. When Rcvd Month payment received D. When Rcvd Day payment received E. When Rcvd Year payment received F. Investor.How Paid How payment was paid, payment reversals, increase/decrease in loan balance or past due fees via cash/non-cash transaction (Letters in parentheses indicate codes shown on screen) 1=Cash (CA) 2=Check (CK) 3=Money Order(MO) 4=Return Check (RC) 5=Posting Error (PE) 6=Suspense Transfer 7=Not used 8=Paid Off 9=Prepaid Interest 10=Credit Interest -1=Visa(VI) -2=M/C (MC) -3=Amer.Express (AE) -4=ACH(AC) -5=other -6=Balance Change – non-cash (BF) -7=Balance Change - Cash (PC)
G. Days Between Days between payments H. Amt Rcvd Amount received for each payment I. Interest Interest amount for each payment J. Principal Principal amount for each payment K. Balance Balance of loan after principal payment L. Fees Paid Fees paid with payment M. Outstanding Fees outstanding fees N. Escrow Paid Escrow amount paid O. Interest Short Interest short on payment (simple interest loans only) P. Maintenance Fee Amount that went to the Maintenance Account Q. Service Fee Paid Amount of fees paid (soon to be added) R. Who Gets Fee Who gets the late fee 0=Servicer 1=Lender
|