BorrowerFirst

[BORROWER_FIRST]

First Name

Example: Jane

BorrowerMiddle

Middle Name

Example: B.

BorrowerLast

Last Name 

Example: Doe

BorrowerFirstMiddleLast

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

BorrowerOrg

N/A

Organization Name

Example: ACME Building Supply

BorrowerFullName

[BORROWER_

FULLNAME]

Organization and Full Name combined

Example: ACME Building Supply / Jane Doe

BorrowerPhone

N/A

Primary Phone Number 

Example: 800-555-1212

BorrowerEmail

Email Address 

Example: jane.doe@acme.com

BorrowerStreet1

[BORROWER_ STREET1]

Street 1 

Example: 1600 Pennsylvania Avenue NW

BorrowerStreet2

Street 2 

Example: Suite 100

BorrowerCity

City 

Example: Washington

BorrowerState

State 

Example: DC

BorrowerZip

Zip 

Example: 20500

BorrowerFullAddress

[BORROWER_

FULLADDRESS]

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

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

LoanName

Name of Loan 

Example: LOAN-123456

ClosingDateShort

Closing Date of the Loan in short date format 

Example: 2/14/2021

ClosingDateLong

Closing Date of the Loan in long date format 

Example: Sunday, February 14, 2021

OriginalLoanAmount

[ORIGINAL_LOAN_AMT]

Original Loan Amount 

Example: 120,000.00

ActiveInterestRate

Current Interest Rate 

Example: 7.000%

MaturityDate

[MATURITY_DATE]

Maturity Date

Example: 12/31/2030

DocumentDatePerDiem

N/A

Per Diem (Daily Interest Accrued)

Example: 33.33

MonthlyPaymentDay

[REG_MONTHLY_PMT_DAY]

Monthly Payment Day

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

NumberOfPayments

N/A

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

RemainingNumberOfPayments

N/A

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

DaysPastDue

N/A

Days Past Due

FirstPaymentDate

N/A

First Payment Date

PaymentFrequency

N/A

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

GracePeriodDays

N/A

Grace Period Days as an integer.

ActivePrincipalBalance

N/A

Current Principal Balance 

Example: 118,323.86

DocumentDate PrincipalBalance

N/A

Principal Balance on the "Document Date"

Example: 118,323.86

DocumentDateOutstandingLateFeeBalance

N/A

Outstanding Balances – Late Fee

Example: 0.00

DocumentDateImpoundBalance

Outstanding Balances – Impound

Example: 25.65

DocumentDateOutstandingInterest

Outstanding Balances – Interest

Example: 0.00

DocumentDateLenderFeeBalance

N/A

Outstanding Balances - Lender Fees

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

Example: $250.00

BalloonAmount

N/A

Balloon Amount - Amount of final balloon payment

DocumentDatePayoffAmount

N/A

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

InArrearsTotalAsOfDate

N/A

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

DocumentDateHoldBalance

N/A

Document Date Hold Balance

DocumentDateOutstandingBalancesTotals

N/A

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

Example: $14,325.83

PaymentTotalFeesDue

Total (Lender) Fees Due
Example: 20.00

PaymentTotalImpoundDue

Total Impound Due
Example: 8.55

PaymentInterestDue

Interest Due
Example: 358.95

PaymentPrincipalDue

Principal Due
Example: 241.93

PaymentTotalDueWithoutLate

[NEXT_DUE_AMOUNT_

WITHOUT_LATE]

Amount of next payment without any accrued late fees

Example: 1,000.00

N/A

[NEXT_DUE_AMOUNT_

WITH_LATE_DUE]

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

NextDueAmountWithLate

[NEXT_DUE_AMOUNT_

WITH_LATE]

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

NextDuePaymentWithOutstandingTotals

N/A

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

PaymentDueDateShort

[NEXT_DUE_DATE]

Next payment due date 

Example: 6/30/2021

PaymentLateFeeAmount

[NEXT_DUE_LATE_FEE]

Late fee amount if not paid by next due date 

Example: 100.00

PaymentGracePeriodEnds

N/A

Last Date of the Payment Grace Period

Example: 5/31/2022 

LastRegDueDate

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.

LastRegPmtCheckNumber

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

LastPaymentDate

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.

LastPaymentAmount

N/A

Last Payment Amount, regardless of Document Date.

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

LastPaymentPrincipal

N/A

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

Example: $22.33

LastPaymentInterest

N/A

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

Example: $125.00

LastPaymentLateFee

N/A

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

Example: $15.00

LastPaymentImpound

N/A

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

Example: $20.00

LastPaymentLenderFeeTotal

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

LastUnScheduledPaymentDueDate

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.

LastUnScheduledPaymentCheckNumber

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

LastUnScheduledPaymentDate

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

LastUnScheduledPaymentAmount

N/A

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

Example: $200.00

LastUnScheduledPaymentPrincipal

N/A

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

Example: $175.00

LastUnScheduledPaymentInterest

N/A

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

Example: $25.00

LastUnScheduledPaymentLateFee

N/A

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

Example: $15.00

LastUnScheduledPaymentImpound

N/A

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

Example: $75.00

LastUnScheduledPaymentLenderFeeTotal

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

TotalDuePaidLast31Days

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

PrincipalDuePaidLast31Days

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

InterestDuePaidLast31Days

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

LateFeesDuePaidLast31Days

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

TotalLateFeesPaidLast31Days

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

FeesPaidLast31Days

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

ImpoundDuePaidLast31Days

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

HoldAccountPaidLast31Days

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

OutstandingLateFeesPaidLast31Days

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

OutstandingInterestPaidLast31Days

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

LastPaymentDateLast31Days

N/A

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

Example: 11/20/2023

LastRegDueDateLast31Days

N/A

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

Example: 11/01/2023

LastPaymentAmountLast31Days

N/A

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

Example: $1288.00

LastRegPmtCheckNumberLast31Days

N/A

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

Example: Check # 4568

LastPaymentPrincipalLast31Days

N/A

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

Example: $500.00

LastPaymentInterestLast31Days

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

LastPaymentLateFeeLast31Days

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

LastPaymentImpoundLast31Days

N/A

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

Example: $20.00

LastPaymentLenderFeeTotalLast31Days

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

LastUnScheduledPaymentDateLast31Days

N/A

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

Example: 11/25/2023

LastUnScheduledPaymentDueDateLast31Days

N/A

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

Example: 11/01/2023

LastUnScheduledPaymentAmountLast31Days

N/A

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

Example: $1288.00

LastUnScheduledPaymentCheckNumberLast31Days

N/A

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

Example: Check # 4568

LastUnScheduledPaymentPrincipalLast31Days

N/A

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

Example: $500.00

LastUnScheduledPaymentInterestLast31Days

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

LastUnScheduledPaymentLateFeeLast31Days

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

LastUnScheduledPaymentImpoundLast31Days

N/A

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

Example: $20.00

LastUnScheduledPaymentLenderFeeTotalLast31Days

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

PayinsYearToDateFees

N/A

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

PayinsYearToDateImpound

Year-to-Date – Impound Dues
Example: 25.65

PayinsYearToDateInterest

N/A

Year-to-Date – Interest Dues

Example: 1025.88

PayinsYearToDatePrincipal

Year-to-Date – Principal Dues

Example: 765.67

PayinsYearToDateTotal

N/A

Total Amount Due Paid to Date

Example: 2,500

PayinsYearToDateLateFees

N/A

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

PayinsYearToDateOutstandingLateFees

N/A

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

PayinsYearToDateOutstandingInterest

N/A

Outstanding interest paid over the past year to date

TotalInterestOLOL

N/A

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

TotalPaymentsOLOL

N/A

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

PrincipalPaidToDate

N/A

Sum of Principal paid from start of loan to the chosen Document Date.

Note: If payments exist past document date, they won't be summed.

Example: $30,000.00

InterestPaidToDate

N/A

Sum of Interest paid from start of loan to the chosen Document Date.

Note: If payments exist past document date, they won't be summed.

Example: $5,000.00

OutstandingInterestPaidToDate

N/A

Sum of Outstanding Interest paid from start of loan to the chosen Document Date.

Note: If payments exist past document date, they won't be summed.

Example: $2,500.00

LateFeesPaidToDate

N/A

Sum of Late Fees and Outstanding Late Fees paid from start of loan to the chosen Document Date.

Note: If payments exist past document date, they won't be summed.

Example: $500.00

LenderFeesPaidToDate

N/A

Sum of Lender Fees paid from start of loan to chosen Document Date.

Note: If payments exist past document date, they won't be summed.

Note: All lender fees summed into 1 value, not a breakdown of each lender fee summed up.

Example: $600.00

TotalsPaidToDate

N/A

Sum of total payments paid from start of loan to the chosen Document Date.

Note: If payments exist past document date, they won't be summed.

Example: $38,600.00

DocumentDateShort

Current Date 

Example: 6/30/2021

DocumentDateLong

Current Date 

Example: Wednesday, June 30, 2021

ServicerName

Company Name 

Example: RJS Investment Corporation

ServicerStreet1

Street 1 

Example: 123 North Main St

ServicerStreet2

Street 2 

Example: Suite 220

ServicerCity

City 

Example: San Mateo

ServicerState

State Example: CA

ServicerZip

Zip 

Example: 94010

ServicerPhone

Phone Number 

Example: 800.635.9874

ServicerEmail

[SERVICER_EMAIL]

Email 

Example: rjsinv@gmail.com

FullServicerAddress

N/A

Full Servicer Address

Example: 123 North Main St, Ste 220

San Mateo, CA 94010

Click for Details

N/A

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

Principal Additions - This table returns the principal addition/draw activity over the last 31 dats from the date the document is generated.

This table is intended for users without the Investments Module.

Click for Details

N/A

Transactions - This table returns the payment activity made within the last 31 days from the document generation date.

Click for Details

N/A

Custom User Defined Fields

StartOfPeriod

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

EndOfPeriod

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

InvestorFirst

N/A

First Name

Example: Jane

InvestorLast

N/A

Last Name

Example: Doe

InvestorMiddle

N/A

Middle Name

Example: B.

InvestorFirstMiddleLast

N/A

First Middle Last

Example: Jane B. Doe

InvestorOrg

N/A

Organization

Example: ACME Building Supply

InvestorFullName

N/A

Full Name and Organization

Example: ACME Building Supply / Jane B. Doe

InvestorPhone

N/A

Primary Phone Number

Example: 800-555-1212

InvestorEmail

N/A

Email Address

Example: jane.doe@acme.com

InvestorFullAddress

N/A

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

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

InvestorStreet1

N/A

Street 1

Example: 1600 Pennsylvania Avenue NW

InvestorStreet2

N/A

Street 2

Example: Suite 100

InvestorCity

N/A

City

Example: Washington

InvestorState

N/A

State

Example: DC

InvestorZip

N/A

Zip

Example: 20500

Click for Details

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.