Custom Document Templates and Variables
  • 05 Sep 2024
  • 17 Minutes to read
  • Dark
    Light

Custom Document Templates and Variables

  • Dark
    Light

Article summary

This article includes downloadable starter/sample document templates and our list of merge field variables.
If you're unfamiliar with the custom document module, please review the following guide to learn how to use it. 

Legal Disclaimer: Sample document templates are provided below as examples of how to create various automated documents in Bryt.  These samples are not intended to be legal documents as laws and regulations vary greatly by state and by type of business.  It is important to have your document templates reviewed by your legal counsel before use. 

Creating a Document Template: Want to create your document template from scratch?  The following guide explains how to insert merge fields (including custom user field variable data) into your Microsoft Word document (Google Docs do not work).

Starter/Sample Document Templates for Download

1) Welcome Letter Template: Welcome letter using contact information and loan information.


2) Amortization Schedule: Amortized schedule of payments for the term of the loan. NOTE: This template is intended to be used before accepting loan payments. Once principal or interest payments are made on the loan, those payments may not be accurately reflected in the schedule.


3) ACH Authorization Form: Recurring ACH Payment Authorization through ACHQ template with contact and loan information.


4) Periodic Statement H-30(A): Sample Template modeled from Regulation Z Appendix H - H-30(A) Sample Form of Periodic Statement - Click here to View Reg Z Sample


5) Loan Summary (Invoice): Periodic Loan Summary Statement containing contact and loan information with next payment breakdown, YTD paid amounts, and outstanding balances. 


6) Payment Request (Notices): This template is a mirrored copy of the Payment Request template from Bryt's Notices. 

Note: This excludes the ACH payment link since that's not available under custom documents but you can grab an ACH Payment Link and manually insert it before sending it to the borrower. 


7) Payment Receipt: Payment receipt for the last payment made by the borrower.


8) Payoff Statement - Combined: Payoff Demand Letter with borrower information, payoff date, table containing payoff items, and per diem.  The "Payoff Demand - Simple" table returns a payoff table with all lender fees and late fees combined (no details).


9) Payoff Statement - Detailed: Payoff Demand Letter with borrower information, payoff date, table containing payoff items, and per diem.  The "Payoff Demand - Detailed" table returns a payoff table with all lender fees and late fees detailed.


10) Lender Statement of Account: Only for Investments Module users - shows a Lender's (Investor) Investment portfolio, Funding Activity, and Account Activity as table variables which output data dependent on the selected Date Range option set for the document template. 


Bryt's Merge Field Custom Document Variables

Document Variables: The Bryt system uses numerous document variables in our system. Verify you understand the function of the document variable used in your template(s). Using an incorrect document variable may cause your template to produce an inaccurate document. You should thoroughly test your document templates against various loans to ensure accuracy before using them. If you need assistance with document variables, please contact Bryt support - support@brytsoftware.com.

This list of variables below is available for the Custom Documents module (Except for lender/investment variables limited to Investments add-on module users. Including module-specific variables like Impound, Lender Fees, etc.), it also outlines which merge field variables correspond with existing Notice variables. The variables list has a column to note differing custom document targets/sources, such as Per Loan (Default - which applies to most users), Per Borrower, and Per Lender (Investor). The Variables list will be followed by a section outlining table variables. 

CategorySource/Target Availability for Document TemplateDocument VariablesNotice VariablesDescription of Field in Bryt
ContactPer Loan and Per BorrowerBorrowerFirst

[BORROWER_FIRST]

First Name
Example: Jane

ContactPer Loan and Per BorrowerBorrowerMiddleN/A

Middle Name
Example: B.

ContactPer Loan and Per BorrowerBorrowerLast

[BORROWER_LAST]

Last Name
Example: Doe

ContactPer Loan and Per BorrowerBorrowerFirstMiddleLastN/AFull Name (combined first name, middle name and last name) Example: Jane B. Doe
ContactPer Loan and Per BorrowerBorrowerOrgN/A

Organization Name
Example: ACME Building Supply

ContactPer Loan and Per BorrowerBorrowerFullName

[BORROWER_FULLNAME]

Organization and Full Name combined
Example: ACME Building Supply / Jane Doe

ContactPer Loan and Per BorrowerBorrowerPhoneN/A

Primary Phone Number
Example: 800-555-1212

ContactPer Loan and Per BorrowerBorrowerEmailN/A

Email Address
Example: jane.doe@acme.com

ContactPer Loan and Per Borrower

BorrowerStreet1

[BORROWER_ STREET1]

Street 1
Example: 1600 Pennsylvania Avenue NW

ContactPer Loan and Per BorrowerBorrowerStreet2

[BORROWER_ STREET2]

Street 2
Example: Suite 100

ContactPer Loan and Per BorrowerBorrowerCity

[BORROWER_CITY]

City
Example: Washington

ContactPer Loan and Per BorrowerBorrowerState

[BORROWER_STATE]

State
Example: DC

ContactPer Loan and Per Borrower

BorrowerZip

[BORROWER_ZIP]

Zip
Example: 20500

ContactPer Loan and Per Borrower

BorrowerFullAddress

[BORROWER_FULLADDRESS]

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

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

Loan - Info

Per Loan

LoanName

[LOAN_NAME]

Name of Loan
Example: LOAN-123456

Loan - InfoPer LoanClosingDateShortN/A

Closing Date of the Loan in short date format
Example: 2/14/2021

Loan - InfoPer LoanClosingDateLongN/A

Closing Date of the Loan in long date format
Example: Sunday, February 14, 2021

Loan - InfoPer LoanOriginalLoanAmount

[ORIGINAL_LOAN_AMT]

Original Loan Amount
Example: 120,000.00

Loan - InfoPer LoanActiveInterestRateN/A

Current Interest Rate
Example: 7.000%

Loan - InfoPer LoanMaturityDate

[MATURITY_DATE]

Maturity Date
Example: 12/31/2030

Loan - InfoPer LoanDocumentDatePerDiemN/A

Per Diem (Daily Interest Accrued)
Example: 33.33

Loan - InfoPer LoanMonthlyPaymentDay

[REG_MONTHLY_PMT_DAY]

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

Loan - InfoPer LoanNumberOfPaymentsN/A

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

Loan - InfoPer LoanRemainingNumberOfPaymentsN/ARemaining Number of Payments - Total remaining unpaid payments left on a loan
Loan - InfoPer LoanDaysPastDueN/ADays Past Due
Loan - InfoPer LoanFirstPaymentDateN/AFirst Payment Date
Loan - InfoPer LoanPaymentFrequencyN/AFirst Frequency - Frequency of payments at the beginning of the schedule
Loan - InfoPer LoanGracePeriodDaysN/AGrace Period Days as an integer.

Loan - Balances

Per LoanActivePrincipalBalanceN/A

Current Principal Balance
Example: 118,323.86

Loan - BalancesPer Loan

DocumentDatePrincipalBalance

N/A

Principal Balance on the "Document Date"
Example: 118,323.86

Loan - BalancesPer LoanDocumentDateOutstandingLateFeeBalanceN/A

Outstanding Balances – Late Fee
Example: 0.00

Loan - BalancesPer LoanDocumentDateImpoundBalanceN/A

Outstanding Balances – Impound
Example: 25.65

Loan - BalancesPer LoanDocumentDateOutstandingInterestN/A

Outstanding Balances – Interest
Example: 0.00

Loan - BalancesPer Loan

DocumentDateLenderFeeBalance

N/A

Outstanding Balances - Lender Fees
(Will sum all lender fees together as one outstanding balance)
Example: $250.00

Loan - BalancesPer LoanBalloonAmountN/ABalloon Amount - Amount of final balloon payment
Loan - BalancesPer LoanDocumentDatePayoffAmountN/ADocument Date Payoff Amount - includes interest, principal, outstanding interest, outstanding late fees, Lender fees and Late fees
Loan - BalancesPer LoanInArrearsTotalAsOfDateN/AIn Arrears Total As Of Date - Sums up all due payments to catch up a borrower. (Doesn't include principal balance)
Loan - BalancesPer LoanDocumentDateHoldBalanceN/ADocument Date Hold Balance
Loan - BalancesPer Loan

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

Loan - PaymentPer LoanPaymentTotalFeesDueN/A

Total [Lender] Fees Due
Example: 20.00

Loan - PaymentPer LoanPaymentTotalImpoundDueN/A

Total Impound Due
Example: 8.55

Loan - PaymentPer LoanPaymentInterestDueN/A

Interest Due
Example: 358.95

Loan - PaymentPer LoanPaymentPrincipalDueN/A

Principal Due
Example: 241.93

Loan - PaymentPer Loan
PaymentTotalDueWithoutLate[NEXT_DUE_AMOUNT_
WITHOUT_LATE]

Amount of next payment without any accrued late fees
Example: 1,000.00

Loan - Payment

N/A

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

Loan - Payment
Per Loan
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.
Loan - Payment
Per Loan
NextDuePaymentWithOutstandingTotalsN/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

Loan - Payment
Per Loan
PaymentDueDateShort

[NEXT_DUE_DATE]

Next payment due date
Example: 6/30/2021

Loan - Payment
Per Loan
PaymentLateFeeAmount

[NEXT_DUE_LATE_FEE]

Late fee amount if not paid by next due date
Example: 100.00

Loan - Payment
Per Loan
PaymentGracePeriodEndsN/A

Last Date of the Payment Grace Period
Example: 5/31/2022 

Loan - Payment
Per Loan
LastRegDueDateN/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.

Loan - Payment
Per Loan
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

Loan - Payment
Per Loan
LastPaymentDateN/A

The date of the last payment that was made, regardless of the Document Date.
Example: If the last payment made was 11/04/23 and document date is 10/01/2023, LastPaymentDate will be 11/04/2023.

Loan - Payment
Per Loan
LastPaymentAmountN/A

Last Payment Amount, regardless of Document Date.
Returns string “No previous payment” if no prior payment is found

Loan - Payment
Per Loan
LastPaymentPrincipalN/A

The amount paid to principal of the last payment made, regardless of the Document Date.
Example: $22.33

Loan - Payment
Per Loan
LastPaymentInterestN/A

The amount paid to interest of the last payment made, regardless of the Document Date.
Example: $125.00

Loan - Payment
Per Loan
LastPaymentLateFeeN/A

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

Loan - Payment
Per Loan
LastPaymentImpoundN/A

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

Loan - Payment
Per Loan
LastPaymentLenderFeeTotalN/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

Loan - Payment
Per Loan
LastUnScheduledPaymentDueDateN/A

The due date of the last unscheduled payment made.
Example: If unscheduled payment made on 01/15/2023, 01/15/2023 will display.


Loan - Payment
Per Loan
LastUnScheduledPaymentCheckNumberN/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

Loan - Payment
Per Loan
LastUnScheduledPaymentDateN/A

The date of the last unscheduled payment that was made before the document date. Returns "No previous unscheduled payment" if no unscheduled payment is recorded.
Example: 03/15/2023

Loan - Payment
Per Loan
LastUnScheduledPaymentAmountN/A

The total amount of the last unscheduled payment made before the document date.
Example: $200.00

Loan - Payment
Per Loan
LastUnScheduledPaymentPrincipalN/A

The amount paid to Principal of the last unscheduled payment made before the document date.
Example: $175.00

Loan - Payment
Per Loan
LastUnScheduledPaymentInterestN/A

The amount paid to Interest of the last unscheduled payment made before the document date.
Example: $25.00

Loan - Payment
Per Loan
LastUnScheduledPaymentLateFeeN/A

The amount paid to Late Fees of the last unscheduled payment made before the document date.
Example: $15.00

Loan - Payment
Per Loan
LastUnScheduledPaymentImpoundN/A

The amount paid to Impound/Escrow of the last unscheduled payment made before the document date.
Example: $75.00

Loan - Payment
Per Loan
LastUnScheduledPaymentLenderFeeTotalN/A

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

Loan - Payment
Per Loan
TotalDuePaidLast31DaysN/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
Loan - Payment
Per Loan
PrincipalDuePaidLast31DaysN/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
Loan - Payment
Per Loan
InterestDuePaidLast31DaysN/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
Loan - Payment
Per Loan
LateFeesDuePaidLast31DaysN/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
Loan - Payment
Per Loan
TotalLateFeesPaidLast31DaysN/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
Loan - Payment
Per Loan
FeesPaidLast31DaysN/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
Loan - Payment
Per Loan
ImpoundDuePaidLast31DaysN/A
Total Impound (Escrow) Due paid in Last 31 days - (31 days prior from Document Date used). Values return “N/A” if no previous payments are found
Loan - Payment
Per Loan
HoldAccountPaidLast31DaysN/A
Sum of amounts paid into the “Hold” account in Last 31 days - (31 days before the Document Date used). Values return “N/A” if no previous payments are found
Loan - Payment
Per Loan
OutstandingLateFeesPaidLast31DaysN/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
Loan - Payment
Per Loan
OutstandingInterestPaidLast31DaysN/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
Loan - Payment
Per Loan
LastPaymentDateLast31DaysN/A

The payment date of the last payment made 31 days before the Document Date
Example: 11/20/2023

Loan - Payment
Per Loan
LastRegDueDateLast31DaysN/A

The due date of the last payment made 31 days before the Document Date
Example: 11/01/2023

Loan - Payment
Per Loan
LastPaymentAmountLast31DaysN/A

The payment amount of the last payment made 31 days before the Document Date
Example: $1288.00

Loan - Payment
Per Loan
LastRegPmtCheckNumberLast31DaysN/A

The check number information of the last payment made 31 days before the Document Date
Example: Check # 4568

Loan - Payment
Per Loan
LastPaymentPrincipalLast31DaysN/A

The amount paid to principal of the last payment made 31 days before the Document Date
Example: $500.00

Loan - Payment
Per Loan
LastPaymentInterestLast31Days
N/A

The amount paid to interest AND outstanding interest of the last payment made 31 days before the Document Date
Example: $465.00

Loan - Payment
Per Loan
LastPaymentLateFeeLast31DaysN/A

The amount paid to Late Fees AND Outstanding Late Fees of the last payment made 31 days before the Document Date
Example: $50.00

Loan - Payment
Per Loan
LastPaymentImpoundLast31DaysN/A

The amount paid to Impound of the last payment made 31 days before the Document Date
Example: $20.00

Loan - Payment
Per Loan
LastPaymentLenderFeeTotalLast31DaysN/A

The sum total of all Lender Fees paid of the last payment made 31 days before the Document Date
Example: $2125.00

Loan - Payment
Per Loan
LastUnScheduledPaymentDateLast31DaysN/A

The payment date of the last Unscheduled payment made 31 days before the Document Date
Example: 11/25/2023

Loan - Payment
Per Loan
LastUnScheduledPaymentDueDateLast31DaysN/A

The due date of the last Unscheduled payment made 31 days before the Document Date
Example: 11/01/2023

Loan - Payment
Per Loan
LastUnScheduledPaymentAmountLast31DaysN/A

The payment amount of the last Unscheduled payment made 31 days before the Document Date
Example: $1288.00

Loan - Payment
Per Loan
LastUnScheduledPaymentCheckNumberLast31DaysN/A

The check number information of the last Unscheduled payment made 31 days before the Document Date
Example: Check # 4568

Loan - Payment
Per Loan
LastUnScheduledPaymentPrincipalLast31DaysN/A

The amount paid to principal of the last Unscheduled payment made 31 days before the Document Date
Example: $500.00

Loan - Payment
Per Loan
LastUnScheduledPaymentInterestLast31DaysN/A

The amount paid to interest AND outstanding interest of the last Unscheduled payment made 31 days before the Document Date
Example: $465.00

Loan - Payment
Per Loan
LastUnScheduledPaymentLateFeeLast31DaysN/A

The amount paid to Late Fees AND Outstanding Late Fees of the last Unscheduled payment made 31 days before the Document Date
Example: $50.00

Loan - Payment
Per Loan
LastUnScheduledPaymentImpoundLast31DaysN/A

The amount paid to Impound of the last Unscheduled payment made 31 days before the Document Date
Example: $20.00

Loan - PaymentPer LoanLastUnScheduledPayment
LenderFeeTotalLast31Days
N/A

The sum total of all Lender Fees paid of the last Unscheduled payment made 31 days before the Document Date.
Example: $2125.00

Loan - YTDPer LoanPayinsYearToDateFeesN/A

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

Loan - YTD
Per Loan
PayinsYearToDateImpound
N/A

Year-to-Date – Impound Dues
Example: 25.65

Loan - YTD
Per Loan
PayinsYearToDateInterest
N/A

Year-to-Date – Interest Dues
Example: 1025.88

Loan - YTD
Per Loan
PayinsYearToDatePrincipal
N/A

Year-to-Date – Principal Dues
Example: 765.67

Loan - YTD
Per Loan
PayinsYearToDateTotal
N/A

Total Amount Due Paid to Date
Example: 2,500

Loan - YTD
Per Loan
PayinsYearToDateLateFees
N/A
Payins Year To Date Late Fees - Not Inclusive of any outstanding Late Fees paid.
Loan - YTD
Per Loan
PayinsYearToDateOutstandingLateFees
N/A

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

Loan - YTD
Per Loan
PayinsYearToDateOutstandingInterest
N/A

Outstanding interest paid over the past year to date

Loan - Total (Over Life of Loan)
Per Loan
TotalInterestOLOL
N/A
Total Interest Over Life Of Loan (OLOL) - sum of “Interest Due” for all “Regular” and “Prorate” periods
Loan - Total (Over Life of Loan)
Per Loan
TotalPaymentsOLOL
N/A
Total Payments Over Life Of Loan (OLOL) - sum of payments for all “Regular” and “Prorate” periods
Loan - To DatePer Loan
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

Loan - To Date
Per Loan
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

Loan - To Date
Per Loan
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

Loan - To Date
Per LoanLateFeesPaidToDate
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

Loan - To DatePer Loan

LenderFeesPaidToDate

N/A

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

Note(s): If payments exist past the document date, they won't be summed. All lender fees are summed into 1 value, not a breakdown of individual fees.

Loan - To DatePer LoanTotalsPaidToDate
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

DateAllDocumentDateShort
[DATE]

Shows date based on selected document generation date
Example: 6/30/2021

DateAllDocumentDateLong
N/A

Shows date based on selected document generation date
Example: Wednesday, June 30, 2021

AccountAllServicerName

[SERVICER_NAME]

Company Name
Example: RJS Investment Corporation

Account
All
ServicerStreet1

[SERVICER_STREET1]

Street 1
Example: 123 North Main St

Account
All
ServicerStreet2

[SERVICER_STREET2]

Street 2
Example: Suite 220

Account
All
ServicerCity

[SERVICER_CITY]

City
Example: San Mateo
Account
All
ServicerState

[SERVICER_STATE]

State
Example: CA
Account
All
ServicerZip

[SERVICER_ZIP]

Zip
Example: 94010

Account
All
ServicerPhone

[SERVICER_PHONE]

Phone Number
Example: 800.635.9874

Account
All
ServicerEmail

[SERVICER_EMAIL]

Email
Example: rjsinv@gmail.com

Account
All
FullServicerAddress
N/A

Full Servicer Address
Example: 123 North Main St, Ste 220
San Mateo, CA 94010

Investments - DatePer LenderStartOfPeriod
N/A

First Day of Pay Period
Example: Dependent on the 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

Investments - DatePer Lender
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

Investor - ContactPer Lender
InvestorFirst
N/A
First Name
Example: Jane
Investor - Contact
Per Lender
InvestorLast
N/A
Last Name
Example: Doe
Investor - Contact
Per Lender
InvestorMiddle
N/A

Middle Name
Example: B.

Investor - Contact
Per Lender
InvestorFirstMiddleLast
N/A

First Middle Last
Example: Jane B. Doe

Investor - Contact
Per Lender
InvestorOrg
N/A

Organization
Example: ACME Building Supply

Investor - Contact
Per LenderInvestorFullName
N/A

Full Name and Organization
Example: ACME Building Supply / Jane B. Doe

Investor - Contact
Per Lender
InvestorPhone
N/A

Primary Phone Number
Example: 800-555-1212

Investor - Contact
Per Lender
InvestorEmail
N/A

Email Address
Example: jane.doe@acme.com

Investor - Contact
Per Lender
InvestorFullAddress
N/A

Full Address - Combination of Street 1, Street 2, City, State, Zip
Example: 1600 Pennsylvania Avenue NW, Suite 100, Washington, DC, 20500

Investor - Contact
Per Lender
InvestorStreet1
N/A

Street 1
Example: 1600 Pennsylvania Avenue NW

Investor - Contact
Per Lender
InvestorStreet2
N/A

Street 2
Example: Suite 100

Investor - Contact
Per Lender
InvestorCity
N/A

City
Example: Washington

Investor - Contact
Per Lender
InvestorState
N/A

State
Example: DC

Investor - Contact
Per Lender
InvestorZip
N/A

Zip
Example: 20500

Custom UDF/CUF Variables

To insert your custom user field data variables in a document, please refer to the 'How to Use Merge Field Variables' guide to learn how to insert a variable if you're using a Windows or MacOS computer, below are some examples of working with UDF variables. These variables use the following naming convention with all spaces removed and are case-sensitive.

Category: Loan
UDF Name: "Text Loan Udf"
«UDF:Loan:TextLoanUdf»

Category: Loan
UDF Name: "Integer Loan Udf"
«UDF:Loan:IntegerLoanUdf»

Category: Loan
UDF Name: "Decimal Loan Udf"
«UDF:Loan:DecimalLoanUdf»

Category: Loan
UDF Name: "Percentage Loan Udf"
«UDF:Loan:PercentageLoanUdf»

Category: Contact
UDF Name: "first contact udf"
«UDF:Contact:firstcontactudf»

Category: Contact
UDF Name: "second contact udf"
«UDF:Contact:secondcontactudf»

Table Variables

To use table variables, you'll want to insert a 3-by-2 (3 rows and 2 columns) table in your Word document and type in the table variable's name exactly as shown (or copy-paste). The typed variable name must be entered into the first cell (1x1) as shown in the sample images below.

1) Payoff Statement (Combined) 

This table variable returns a table with payoff values including principal balance due, interest due, outstanding interest, other charges (including a total of all other fees), and the total payoff amount.

Template Formatting Example:

Generated Document Output Example:

2) Payoff Statement (Detailed) 

This table variable returns a table with payoff values including principal balance due, interest due, outstanding interest, other charges (itemized lender fees), and the total payoff amount.

Template Formatting Example:

Generated Document Output Example:

3) Schedule 

This Table Variable returns a table with payments and future scheduled payments including: due date, paid date, total due, total paid, principal due, principal paid, interest due, interest paid, late fee due, late fee paid, lender fees due, lender fees paid, impound/escrow due, impound/escrow paid, other, and the pay period's ending balance. 

Template Formatting Example:
Generated Document Output Example:

4) Amortization Schedule

This table variable returns an amortization table with projected values including pay period due dates, pay period's starting principal balance, total due, principal due, interest due, and the pay period's ending balance.

Template Formatting Example:

Generated Document Output Example:

5) Principal Additions

This table variable returns a table with the principal additions for the last 31 days including the draw activity date range, effective date, and the amount added. The date range used will be 31 days before the selected document date, through to the document date.
Note: This table variable does not work for investment module users, you would want to use the Investor Funding table with the 'Per Lender' target/source for loan funding/additions. 

Template Formatting Example:

Generated Document Output Example:

6) Transactions

This table variable returns a table with transaction details for the last 31 days including the transaction activity date range, transaction date, payment type (Regular/Scheduled, Unscheduled, or Payoff), check number/description, and amount.The date range used will be 31 days before the selected document date, through to the document date.

Template Formatting Example:

Generated Document Output Example:

7) Investor Investments (Investment Module Only)

This table variable returns a table with the investor's active investments including loan names, ownership percentages, next payment dates, maturity dates, interest rate, and current investment value, with a last row denoting a weighted interest rate and summed value for the current value column.

Template Formatting Example:

Generated Document Output Example:

8) Investor Funding (Investment Module Only)

This table variable returns a table with the investor's funding activity including funding at the loan's start (closing date) with those funds denoting a disbursement, and reassignment of an investor's portion (depending on the portion being added or lost, it'll be shown as a positive or negative number).

Template Formatting Example:

Generated Document Output Example:

9) Investor Payouts (Investment and NACHA Module Only)

This table variable returns a table with borrower payments that are ready for NACHA processing (to create the NACHA file and be considered 'Processed') and includesthe ready payout date (different from the borrower's payment date depending on the number of days you set to hold funds before 'Ready for Payout'), loan name, principal, interest, late fees, other fees, and total columns. This will include entries based on the selected template's Date Range options.
Note: This table only works if you use both the investments and NACHA modules.

Template Formatting Example:

Generated Document Output Example:

10) Investor Payouts Processed (Investment and NACHA Module Only)

This table variable returns a table with the investor's processed payouts including the date, loan name, principal, interest, late fees, other fees, and total columns.
Note: This table only works if you use both the investments and NACHA modules.

Template Formatting Example:

Generated Document Output Example:


That's all for the custom document resources. If you have any questions, please reach out to support@brytsoftware.com



What's Next