Transaction data enables CRB to collect interest based on an adjusted loan balance. The table below is the transaction reference information for the files.
- File format is CSV.
- Naming convention: MplId_TransactionTape_yyyymmdd.csv, where yyyymmdd is the date of file generation.
- File should contain prior day transactions.
- Make sure to provide a list of possible TransactionCodes and SourceCodes.
- This file should include all borrower payments, payment reversals, cancelations, refunds, charge offs, loan modifications, and fee assessments.
Transaction code mapping table is below.
October 21, 2021
October 21, 2021
Unique loan transaction ID. Use the ID from the servicing system.
Unique loan number.
Date the transaction was processed by the servicing system.
An identifier used to describe the method of the transaction.
A description that correlates to the SourceCode identifier such as personal check, money order, AutoPay, etc.
An identifier used to describe the type of transaction - use the transaction code from the servicing system.
A description that correlates to the TransCode identifier such as boarding, scheduled payment, AutoPay fee payment, refund, cancellation, fee assessment, charged off principal, loan modification, etc.
Note on operators: A transaction that increases the balance should be positive (+), and a transaction that decreases the balance should be negative (-).
0 = No balance impact
0 - Cash transaction
0 - Reversal of original transaction
A description that indicates the reason for reversal such as ACH return, bounced check, etc.
The date the transaction affected the loan.
The date the funds are remitted to CRB.
Principal paid by borrower
Principal adjustment (small $ write off)
Interest paid by borrower
Principal payment reversal
Late fee assessed
Late fee paid
Updated 7 months ago