Transaction data exchange

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 conventions

  • File format is CSV.
  • Naming convention: MplId_TransactionTape_yyyymmdd.csv, where yyyymmdd is the date of file generation.
  • File should contain prior day transactions.

👍

Notes

  1. Make sure to provide a list of possible TransactionCodes and SourceCodes.
  2. This file should include all borrower payments, payment reversals, cancelations, refunds, charge offs, loan modifications, and fee assessments.

Attribute

Description

Valid values/Format

TransactionId
alphanumeric

Unique identifier for the loan transaction.

LoanId
alphanumeric

Unique identifier for the loan.

TransactionDate
date

Date of the transaction event.

SourceCode
numeric

An identifier used to describe the method of the transaction.

SourceCodeDesc
alphanumeric

A description that correlates to the source_code identifier.

Personal check, money order, and AutoPay

TransactionCode
numeric

An identifier used to describe the type of transaction.

11100 - 90001

TransactionCodeDesc
alphanumeric

A description that correlates to the trans_code identifier.

Boarding, scheduled payment, AutoPay fee payment, refund, cancelation

TransactionAmount
money

The gross transaction amount.

Format: -277.85

NonCashFlag
numeric

If the transaction was cash or not.

0 - Cash payment
1 - Other non-cash transaction

ReversalIndicator
numeric

A code that indicates the reason for a transaction reversal.

0 - Original transaction
1 - Reversal of original transaction

ReversalReason
alphanumeric

A description that indicates the reason for reversal.

ACH return, bounced check or other

EffectiveDate
Date

The date the transaction affected the loan.

Format: yyyy-mm-dd

RemittedDate
Date

The date the funds are remitted to CRB.

Format: yyyy-mm-dd

BalancePrior
money

The balance prior to the transaction.

7572.26

PrincipalAmount
money

Amount of the transaction paid to the loan principal.

-230.00

InterestAmount
money

Amount of the transaction paid to interest.

-47.85

LateFeeAmount
money

Amount of the transaction paid to late fees.

0.00

BalanceAfter
money

Remaining balance after the transaction was applied.

7294.10

NextDueDate
date

Date the next payment is due on the loan.

Format: yyyy-mm-dd

Notes
alphanumeric

Open field for text for an agent.

Examples: Boarding transaction, zero-order-hold, balance due to pay off

PaymentOwner
alphanumeric

Payment owner.

CRB


Did this page help you?