First Name

Example: Jane

BorrowerFirst

[BORROWER_FIRST]

Middle Name

Example: B.

BorrowerMiddle

Last Name 

Example: Doe

BorrowerLast

Full Name (combined first name, middle name and last name) Example: Jane B. Doe

BorrowerFirstMiddleLast

Organization Name

Example: ACME Building Supply

BorrowerOrg

N/A

Organization and Full Name combined

Example: ACME Building Supply / Jane Doe

BorrowerFullName

[BORROWER_

FULLNAME]

Primary Phone Number 

Example: 800-555-1212

BorrowerPhone

N/A

Email Address 

Example: jane.doe@acme.com

BorrowerEmail

Street 1 

Example: 1600 Pennsylvania Avenue NW

BorrowerStreet1

[BORROWER_ STREET1]

Street 2 

Example: Suite 100

BorrowerStreet2

City 

Example: Washington

BorrowerCity

State 

Example: DC

BorrowerState

Zip 

Example: 20500

BorrowerZip

Full address - Combination of Street 1, Street 2, City, State, Zip

Example: 1600 Pennsylvania Avenue NW, Suite 100, Washington, DC 20500

BorrowerFullAddress

[BORROWER_

FULLADDRESS]

Name of Loan 

Example: LOAN-123456

LoanName

Closing Date of the Loan in short date format 

Example: 2/14/2021

ClosingDateShort

Closing Date of the Loan in long date format 

Example: Sunday, February 14, 2021

ClosingDateLong

Original Loan Amount 

Example: 120,000.00

OriginalLoanAmount

[ORIGINAL_LOAN_AMT]

Current Interest Rate 

Example: 7.000%

ActiveInterestRate

Maturity Date

Example: 12/31/2030

MaturityDate

[MATURITY_DATE]

Per Diem (Daily Interest Accrued)

Example: 33.33

DocumentDatePerDiem

N/A

Monthly Payment Day

Example: If the payment is due on 31st, will display 31.

MonthlyPaymentDay

[REG_MONTHLY_PMT_DAY]

Number of Payments - Total number of Payments through the loan's originally set schedule

NumberOfPayments

N/A

Remaining Number of Payments - Total remaining unpaid payments left on a loan

RemainingNumberOfPayments

N/A

Days Past Due

DaysPastDue

N/A

First Payment Date

FirstPaymentDate

N/A

First Frequency - Frequency of payments at the beginning of the schedule

PaymentFrequency

N/A

Current Principal Balance 

Example: 118,323.86

ActivePrincipalBalance

N/A

Principal Balance on the "Document Date"

Example: 118,323.86

DocumentDate PrincipalBalance

N/A

Outstanding Balances – Late Fee

Example: 0.00

DocumentDateOutstandingLateFeeBalance

N/A

Outstanding Balances – Impound

Example: 25.65

DocumentDateImpoundBalance

Outstanding Balances – Interest

Example: 0.00

DocumentDateOutstandingInterest

Outstanding Balances - Lender Fees

(Will sum all lender fees together as one outstanding balance)

Example: $250.00

DocumentDateLenderFeeBalance

N/A

Balloon Amount - Amount of final balloon payment

BalloonAmount

N/A

Document Date Payoff Amount - includes interest, principal, outstanding interest, outstanding late fees, Lender fees and Late fees

DocumentDatePayoffAmount

N/A

In Arrears Total As Of Date - Sums up all due payments to catch up a borrower. (Doesn't include principal balance)

InArrearsTotalAsOfDate

N/A

Document Date Hold Balance

DocumentDateHoldBalance

N/A

Total of outstanding balances as of Document Date. Sums outstanding interest, outstanding late fees, and outstanding lender fees.

Example: $14,325.83

DocumentDateOutstandingBalancesTotals

N/A

Total (Lender) Fees Due
Example: 20.00

PaymentTotalFeesDue

Total Impound Due
Example: 8.55

PaymentTotalImpoundDue

Interest Due
Example: 358.95

PaymentInterestDue

Principal Due
Example: 241.93

PaymentPrincipalDue

Amount of next payment without any accrued late fees

Example: 1,000.00

PaymentTotalDueWithoutLate

[NEXT_DUE_AMOUNT_

WITHOUT_LATE]

Amount of next due with late fee, regardless of whether payment is late already. If payment amount is $100 and late fee is $50, total will display $150 even if the loan isn't late yet.

Example: $150.00

N/A

[NEXT_DUE_AMOUNT_

WITH_LATE_DUE]

Amount of next payment with accrued late fees, only if payment is already considered late. If payment is late on 01/10/2023 and document is generated on 01/01/2023, payment will not display late fee. If document is generated after grace period, then payment will display with late fee.

Example: 1,100.00

NextDueAmountWithLate

[NEXT_DUE_AMOUNT_

WITH_LATE]

Amount of next due payment (without late fee) and with all outstanding balances due (lender fees, late fees, outstanding interest balances).

Example: $1,450.00

NextPaymentWithOutstandingDues

N/A

Next payment due date 

Example: 6/30/2021

PaymentDueDateShort

[NEXT_DUE_DATE]

Late fee amount if not paid by next due date 

Example: 100.00

PaymentLateFeeAmount

[NEXT_DUE_LATE_FEE]

Last Date of the Payment Grace Period

Example: 5/31/2022 

PaymentGracePeriodEnds

N/A

The due date of the last regularly scheduled payment made, regardless of Document.

Example: If the last payment was paid 11/15/2023 and was due on 11/01/2023, this variable will display the due date of 11/01/2023, even if Document Date is 09/01/2023.

LastRegDueDate

N/A

The check reference number that was entered on the last regularly scheduled payment that was made, regardless of Document Date. If no check reference number was entered, will be empty.

Example: Check # 4568

LastRegPmtCheckNumber

N/A

The date of the last payment that was made, regardless of the Document Date.

Example: If LastPayment made was 11/04/23 and document date is 10/01/2023, LastPaymentDate will be 11/04/2023.

LastPaymentDate

N/A

Last Payment Amount, regardless of Document Date.

Returns string “No previous payment” if no prior payment found

LastPaymentAmount

N/A

The amount paid to principal of the last payment made, regardless of the Document Date.

Example: $22.33

LastPaymentPrincipal

N/A

The amount paid to interest of the last payment made, regardless of the Document Date.

Example: $125.00

LastPaymentIntererst

N/A

The amount paid to late fees of the last payment made, regardless of the Document Date.

Example: $15.00

LastPaymentLateFee

N/A

The amount paid to Impound/Escrow of the last payment made, regardless of the Document Date.

Example: $20.00

LastPaymentImpound

N/A

The sum amount paid to all Lender Fees of the last payment made, regardless of the Document Date. Note: If you have multiple lender fees, they will be summed & displayed as 1 total.

Example: $250.00

LastPaymentLenderFeeTotal

N/A

The due date of the last unscheduled payment made. 

Example: If unscheduled payment made on 01/15/2023,

01/15/2023 will display.

LastUnScheduledPaymentDueDate

N/A

The check reference number that was entered on the last unscheduled payment that was made. If no check reference number was entered, will be empty.

Example: EFT

LastUnScheduledPaymentCheckNumber

N/A

The date of the last unscheduled payment that was made prior to the document date. Returns "No previous unscheduled payment" if no unscheduled payment is recorded.

Example: 03/15/2023

LastUnScheduledPaymentDate

N/A

The total amount of the last unscheduled payment made prior to the document date.

Example: $200.00

LastUnScheduledPaymentAmount

N/A

The amount paid to Principal of the last unscheduled payment made prior to the document date.

Example: $175.00

LastUnScheduledPaymentPrincipal

N/A

The amount paid to Interest of the last unscheduled payment made prior to the document date.

Example: $25.00

LastUnScheduledPaymentInterest

N/A

The amount paid to Late Fees of the last unscheduled payment made prior to the document date.

Example: $15.00

LastUnScheduledPaymentLateFee

N/A

The amount paid to Impound/Escrow of the last unscheduled payment made prior to the document date.

Example: $75.00

LastUnScheduledPaymentImpound

N/A

The sum amount paid to all Lender Fees of the last unscheduled payment made prior to the document date. Note: If you have multiple lender fees, they will be summed & displayed as 1 total.

Example: $250.00

LastUnScheduledPaymentLenderFeeTotal

N/A

Total Payment made in Last 31 days - (31 days prior from Document Date used). Values return “N/A” if no previous payments are found

TotalDuePaidLast31Days

N/A

Total Principal paid in Last 31 days - (31 days prior from Document Date used). Values return “N/A” if no previous payments are found

PrincipalDuePaidLast31Days

N/A

Total Interest Due paid in Last 31 days - (31 days prior from Document Date used). Values return “N/A” if no previous payments are found

InterestDuePaidLast31Days

N/A

Total Late Fees Due paid in Last 31 days - (31 days prior from Document Date used). Values return “N/A” if no previous payments are found

LateFeesDuePaidLast31Days

N/A

Total Late Fees paid in Last 31 days... Sum of outstanding AND ‘due’ late fees - (31 days prior from Document Date used). Values return “N/A” if no previous payments are found

TotalLateFeesPaidLast31Days

N/A

Total Fees Due paid in Last 31 days - (31 days prior from Document Date used). Values return “N/A” if no previous payments are found

FeesPaidLast31Days

N/A

Total Escrow/Impiound Due paid in Last 31 days - (31 days prior from Document Date used). Values return “N/A” if no previous payments are found

ImpoundDuePaidLast31Days

N/A

Sum of amounts paid into the “Hold” account in Last 31 days - (31 days prior from Document Date used). Values return “N/A” if no previous payments are found

HoldAccountPaidLast31Days

N/A

Sum of outstanding late fees paid in Last 31 days - (31 days prior from Document Date used). Values return “N/A” if no previous payments are found

OutstandingLateFeesPaidLast31Days

N/A

Sum of outstanding interest paid in Last 31 days - (31 days prior from Document Date used). Values return “N/A” if no previous payments are found

OutstandingInterestPaidLast31Days

N/A

The payment date of the last payment made 31 days prior to the Document Date

Example: 11/20/2023

LastPaymentDateLast31Days

N/A

The due date of the last payment made 31 days prior to the Document Date

Example: 11/01/2023

LastRegDueDateLast31Days

N/A

The payment amount of the last payment made 31 days prior to the Document Date

Example: $1288.00

LastPaymentAmountLast31Days

N/A

The check number information of the last payment made 31 days prior to the Document Date

Example: Check # 4568

LastRegPmtCheckNumberLast31Days

N/A

The amount paid to principal of the last payment made 31 days prior to the Document Date

Example: $500.00

LastPaymentPrincipalLast31Days

N/A

The amount paid to interest AND outstanding interest of the last payment made 31 days prior to the Document Date

Example: $465.00

LastPaymentInterestLast31Days

N/A

The amount paid to Late Fees AND Outstanding Late Fees of the last payment made 31 days prior to the Document Date

Example: $50.00

LastPaymentLateFeeLast31Days

N/A

The amount paid to Impound of the last payment made 31 days prior to the Document Date

Example: $20.00

LastPaymentImpoundLast31Days

N/A

The sum total of all Lender Fees paid of the last payment made 31 days prior to the Document Date

Example: $2125.00

LastPaymentLenderFeeTotalLast31Days

N/A

The payment date of the last Unscheduled payment made 31 days prior to the Document Date

Example: 11/25/2023

LastUnScheduledPaymentDateLast31Days

N/A

The due date of the last Unscheduled payment made 31 days prior to the Document Date

Example: 11/01/2023

LastUnScheduledPaymentDueDateLast31Days

N/A

The payment amount of the last Unscheduled payment made 31 days prior to the Document Date

Example: $1288.00

LastUnScheduledPaymentAmountLast31Days

N/A

The check number information of the last Unscheduled payment made 31 days prior to the Document Date

Example: Check # 4568

LastUnScheduledPaymentCheckNumberLast31Days

N/A

The amount paid to principal of the last Unscheduled payment made 31 days prior to the Document Date

Example: $500.00

LastUnScheduledPaymentPrincipalLast31Days

N/A

The amount paid to interest AND outstanding interest of the last Unscheduled payment made 31 days prior to the Document Date

Example: $465.00

LastUnScheduledPaymentInterestLast31Days

N/A

The amount paid to Late Fees AND Outstanding Late Fees of the last Unscheduled payment made 31 days prior to the Document Date

Example: $50.00

LastUnScheduledPaymentLateFeeLast31Days

N/A

The amount paid to Impound of the last Unscheduled payment made 31 days prior to the Document Date

Example: $20.00

LastUnScheduledPaymentImpoundLast31Days

N/A

The sum total of all Lender Fees paid of the last Unscheduled payment made 31 days prior to the Document Date

Example: $2125.00

LastUnScheduledPaymentLenderFeeTotalLast31Days

N/A

Year-to-Date – Total (Lender) Fees Due
Example: 460.00

PayinsYearToDateFees

N/A

Year-to-Date – Impound Dues
Example: 25.65

PayinsYearToDateImpound

Year-to-Date – Interest Dues

Example: 1025.88

PayinsYearToDateInterest

N/A

Year-to-Date – Principal Dues

Example: 765.67

PayinsYearToDatePrincipal

Total Amount Due Paid to Date

Example: 2,500

PayinsYearToDateTotal

N/A

Payins Year To Date Late Fees - Not Inclusive of any outstanding Late Fees paid.

PayinsYearToDateLateFees

N/A

Payins Year To Date Outstanding Late Fees - OnlyInclusive of outstanding Late Fees paid.

PayinsYearToDateOutstandingLateFees

N/A

Outstanding interest paid over the past year to date

PayinsYearToDateOutstandingInterest

N/A

Total Interest Over Life Of Loan (OLOL) - sum of “Interest Due” for all “Standard” and “Prorate” periods

TotalInterestOLOL

N/A

Total Payments Over Life Of Loan (OLOL) - sum of “Interest Due” for all “Standard” and “Prorate” periods

TotalPaymentsOLOL

N/A

Current Date 

Example: 6/30/2021

DocumentDateShort

Current Date 

Example: Wednesday, June 30, 2021

DocumentDateLong

Company Name 

Example: RJS Investment Corporation

ServicerName

Street 1 

Example: 123 North Main St

ServicerStreet1

Street 2 

Example: Suite 220

ServicerStreet2

City 

Example: San Mateo

ServicerCity

State Example: CA

ServicerState

Zip 

Example: 94010

ServicerZip

Phone Number 

Example: 800.635.9874

ServicerPhone

Email 

Example: rjsinv@gmail.com

ServicerEmail

Payoff Statement (simple) - This table returns a payoff table with all lender fees and late fees combined (no details)

Click for Details

N/A

Payoff Statement (detailed) - This table returns a payoff table with all lender fees and late fees detailed

Click for Details

N/A

Payment Schedule - This table returns a Payment Schedule table with recorded payments and future scheduled payments. For more information regarding what this table includes, please click "Click for Details".

Click for Details

N/A

Amortization Schedule - This table returns an Amortizaion table with Payment Due Date, Starting Principal Balance, Total P&I Payment Due, Total Principal Due, Total Interest Due, and Ending Balance.

Click for Details

N/A

Custom User Defined Fields

Click for Details

N/A

First Day of Pay Period

Example: Dependent on Date Range option you select - setting 7/11/2023 as the document date, with "Month Prior to Document Date", the first day would be 6/1/2023

StartOfPeriod

N/A

Last Day of Pay Period

Example: Document Date selected 3/15/2023, selecting the Date Range Option of "Month Prior to Document Date", then it would yield 2/28/2023

EndOfPeriod

N/A

First Name

Example: Jane

InvestorFirst

N/A

Last Name

Example: Doe

InvestorLast

N/A

Middle Name

Example: B.

InvestorMiddle

N/A

First Middle Last

Example: Jane B. Doe

InvestorFirstMiddleLast

N/A

Organization

Example: ACME Building Supply

InvestorOrg

N/A

Full Name and Organization

Example: ACME Building Supply / Jane B. Doe

InvestorFullName

N/A

Primary Phone Number

Example: 800-555-1212

InvestorPhone

N/A

Email Address

Example: jane.doe@acme.com

InvestorEmail

N/A

Full Address - Combination of Street 1, Street 2, City, State, Zip

Example: 1600 Pennsylvania Avenue NW, Suite 100, Washington, DC, 20500

InvestorFullAddress

N/A

Street 1

Example: 1600 Pennsylvania Avenue NW

InvestorStreet1

N/A

Street 2

Example: Suite 100

InvestorStreet2

N/A

City

Example: Washington

InvestorCity

N/A

State

Example: DC

InvestorState

N/A

Zip

Example: 20500

InvestorZip

N/A

Investor Investments - This table returns an investments table with all associated loans, ownership percentages, next payment due dates, maturity dates, rates, and current value of their investment. 

Click for Details

N/A

Investor Funding - This table returns an investments table with all associated loans, dates of activity, and amounts. 

Click for Details

N/A

Investor Payouts Processed - This table returns an investments table with all associated loans, dates of activity, principal, interest, late fees, other fees, and total fees. 

Click for Details

N/A