List of Smart Markers

To see the full list of Smart Markers, go to Tools → Excel Report. Click the “Report builder” button in the top right corner.
When the “Report builder” window opens, click the Smar markers” button.

image-20240626-072317.png

Click the “Export full list” button to see the list of Smart Markers available for your project.

image-20240626-072446.png

Below is an example of the list of smart markers available for a box project

Name

Description

Copy to file

Name

Description

Copy to file

Accrued admin fee

Sum of all accrued Administration Fees created with the basic view template for the period specified in the time filtering

&=vm.Cashflow_AccruedAdminFee

Accrued fee

Sum of all accrued fees with Fee Type = 'Fee' for the period specified in the time filtering

&=vm.Cashflow_AccruedFee

Accrued interest

Total accrued interest amount for the period specified in the time filtering

&=vm.Cashflow_AccruedInterest

Accrued late fee

Sum of all accrued LateFee created with the basic view template for the period specified in the time filtering

&=vm.Cashflow_AccruedLateFee

Accrued NSF

Sum of all accrued NSF created with the basic view template for the period specified in the time filtering

&=vm.Cashflow_AccruedNSF

Accrued origination fee

Sum of all accrued Origination Fees created with the basic view template for the period specified in the time filtering

&=vm.Cashflow_AccruedOriginationFee

Accrued past due

Sum of all accrued fees with Fee Type = 'PastDue' for the period specified in the time filtering

&=vm.Cashflow_AccruedPastDue

Accrued past due interest

Sum of all accrued PastDueInterest created with the basic view template for the period specified in the time filtering

&=vm.Cashflow_AccruedPastDueInterest

Accrued penalty

Sum of all accrued fees with Fee Type = 'Penalty' for the period specified in the time filtering

&=vm.Cashflow_AccruedPenalty

Repaid admin fee

Sum of all repaid Administration Fees created with the basic view template for the period specified in the time filtering

&=vm.Cashflow_RepaidAdminFee

Repaid fee

Sum of all repaid fees with Fee Type = 'Fee' for the period specified in the time filtering

&=vm.Cashflow_RepaidFee

Repaid interest

Total repaid interest amount for the period specified in the time filtering for the period specified in the time filtering

&=vm.Cashflow_RepaidInterest

Repaid late fee

Sum of all repaid LateFee created with the basic view template for the period specified in the time filtering

&=vm.Cashflow_RepaidLateFee

Repaid leasing

Sum of all repaid fees with Fee type = 'Leasing'  for the period specified in the time filtering

&=vm.Cashflow_RepaidLeasing

Repaid NSF

Sum of all repaid NSF created with the basic view template for the period specified in the time filtering

&=vm.Cashflow_RepaidNSF

Repaid origination fee

Sum of all repaid Origination Fees created with the basic view template for the period specified in the time filtering

&=vm.Cashflow_RepaidOriginationFee

Repaid past due

Sum of all repaid fees with Fee Type = 'PastDue' for the period specified in the time filtering

&=vm.Cashflow_RepaidPastDue

Repaid past due interest

Sum of all repaid PastDueInterest created with the basic view template for the period specified in the time filtering

&=vm.Cashflow_RepaidPastDueInterest

Repaid penalty

Sum of all repaid fees with Fee Type = 'Penalty' for the period specified in the time filtering

&=vm.Cashflow_RepaidPenalty

Repaid principal

Total repaid principal amount for the period specified in the time filtering for the period specified in the time filtering

&=vm.Cashflow_RepaidPrincipal

Customer flags

All active customer's flags

&=vm.Customers_Flags

Customer's bank account type

Type of account (Saving; Checking)

&=vm.Customers_BankAccountType

Customer's city

The city as defined the customer’s address

&=vm.Customers_City

Customer's email

Customer’s Email

&=vm.Customers_Email

Customer's First Name

Customer's First Name

&=vm.Customers_FirstName

Customer's full name

Full name of the customer

&=vm.Customers_FullName

Customer's income type

Customer's income type (depends on the edition)

&=vm.Customers_IncomeType

Customer's Last Name

Customer's Last Name

&=vm.Customers_LastName

Customer's Middle Name

Customer's Middle Name

&=vm.Customers_MiddleName

Customer's phone

Customer’s phone

&=vm.Customers_Phone

Customer's public id

Public customer ID

&=vm.Customers_PublicId

Customer's SSN

Customer’s SSN

&=vm.Customers_SSN

Customer's state

The state as defined the customer’s address

&=vm.Customers_State

Customer's street

The street as defined the customer’s address

&=vm.Customers_Street

Customer's zip code

The zip code as defined the customer’s address

&=vm.Customers_ZipCode

Expected payment amount

Amount of the nearest exptected payment or debt

&=vm.ExpectedPayments_ExpectedAmount

Expected payment status

Status of the next expected payemnt (scheduled; late; grace; past due)

&=vm.ExpectedPayments_Status

Next payment date

Date of the nearest expected payment

&=vm.ExpectedPayments_NextPaymentDate

Accrued unpaid interest

Total unpaid Interest by the reporting date

&=vm.Loans_AccruedUnpaidInterest

Applicant Credit Bureau Score

Applicant Credit Bureau Score

&=vm.Loans_CreditBureauScore

Application date

Date the application was created

&=vm.Loans_ApplicationDate

Average installment

Average Installment amount.

 

(Sum of all installments according to the initial schedule) / ( number of installments).

 

Grace period installments are not included.

 

Past due, late fee values are not included

&=vm.Loans_AverageInstallment

Close date

Date the loan was closed (repaid, written off, restructured, rejected, agreement declined or expired)

&=vm.Loans_CloseDate

Co-Applicant Credit Bureau Score

Co-Applicant Credit Bureau Score

&=vm.Loans_CoApplicantCreditBureauScore

Contract date

The date when the contract was signed.

 

If the loan is e-signing, it is the date when Customer signed the loan agreement.

 

If the is loan signed manually, it is the date when the back-office registered manual signing

&=vm.Loans_ContractDate

Contract leasing amount

Total amount of all the fees of Fee type = 'Leasing' to be accrued according to the schedule as it was on the disbursement state.

&=vm.Loans_LeasingContract

Credit product

Credit Product Name

&=vm.Loans_CreditProduct

Days past due

Number of days past due for an overdue loan

&=vm.Loans_DaysPastDue

Disbursement date

The date when the transaction of Loan Disbursement was done.

 

For the Loan Agreement where the loan has not been disbursed - the Current date

&=vm.Loans_DisbursementDate

Down-payment

Sum of all accrued 'Down payment' fees

&=vm.Loans_DownPaymentAmount

Equal payment

Equal payment.

Applicable if 'Enable equal payments'=ON

&=vm.Loans_EqualPayment

First disbursement amount

First funds tranche.

Applicable if 'Enabled multiple disbursement'=ON

&=vm.Loans_FirstDisbursementAmount

First payment date

The first due date according to the initial schedule

&=vm.Loans_FirstPaymentDate

Full loan term

Loan term in months, (e.g. “12 months”)

&=vm.Loans_LoanTermFull

Interest rate

Interest rate for the loan; is set in the given credit product

&=vm.Loans_InterestRate

Last payment date

The date of the most recent successful payment transaction the client made towards the account

&=vm.Loans_LastPaymentDate

Loan amount

Loan amount value. Set by the Borrower or Originator when a the loan application was created

&=vm.Loans_LoanAmount

Loan auto-decision date

Date when the loan was auto-processed and then moved into the Underwriting workspace or auto-decisioned

&=vm.AutoDecisionDate

Loan branch

Lowest-level branch to which the loan is assigned

&=vm.Loans_LoanBranch

Loan Cancellation Reason

Loan Cancellation Reason

&=vm.Loans_CancellationReason

Loan ID

Unique identifier of the loan that is visible to all users of the System.

&=vm.Loans_LoanID

Loan Rejection Reason

Loan Rejection Reason

&=vm.Loans_RejectionReason

Loan status

Loan status on the current system (in a human-readable format).

&=vm.Loans_Status

Maturity date

Loan maturity date according to the contract (date when Loan should be fully paid according to its initial schedule. (Rollovers are not taken into account).

&=vm.Loans_MaturityDate

Next payment date

The nearest future due date according to the actual payment schedule

&=vm.Loans_NextPaymentDate

Oldest missed due date

For accounts that are past due, this is the date of the first missed payment. Due date of the oldest installment with status 'Missed'

&=vm.Loans_OldestMissedDueDate

Originator

Full name of the back-office user who created the loan. If the loan was created from the front-office, the value is empty.

&=vm.Loans_Originator

Outstanding balance

Current outstanding balance of the loan

&=vm.Loans_OutstandingBalance

Outstanding principal

Current outstanding principal of the loan

&=vm.Loans_OutstandingPrincipal

Overpaid amount

Total amount of overpayment for the loan

&=vm.Loans_OverpaidAmount

Paid fees

Total Paid Fees from the Loan Start date to the Current date (except the Initial fees!)

&=vm.Loans_PaidFees

Paid initial fees

Total Initial Fees paid on this loan

&=vm.Loans_PaidInitialFees

Paid total

Amount paid.

Sum of all successful payment transactions

&=vm.Loans_PaidTotal

Past due debt

Current past due debt of the loan. The sum of unpaid debt for all missed installments.

&=vm.Loans_PastDueDebt

Payment amount

Scheduled monthly payment.

Total amount of the installment #1 from the Initial schedule.

Used in annuity loan type without origination fee over equal payment

&=vm.Loans_PaymentAmount

Payoff amount

Payoff amount on the reporting date (can only be calculated on the current date!)

&=vm.Loans_PayOffAmount

Pre-approval fees

Sum of all accrued 'Pre-approval' fees

&=vm.Loans_PreApprovalFeesAmount

Pre-disbursement fees

Sum of all accrued 'Pre-disbursement' fees (including Down payments)

&=vm.Loans_PreDisbursementFeesAmount

Purchase amount

Purchase amount' value. Set by the Borrower or the Originator when a loan is created/modified

&=vm.Loans_PurchaseAmount

Repayment period

Repayment period as defined in the Credit Product settings

&=vm.Loans_RepaymentPeriod

Risk level

Risk level calculated following the loan assessment by the System (Low; Medium; High; Highest; Default)

&=vm.Loans_RiskLevel

Sent for signing date

Date when the loan agreement is generated and sent to the customer for signing

&=vm.SentForSigningDate

Store

Name of the store

&=vm.Loans_Store

Store address

Address of the store

&=vm.Loans_StoreAddress

System decision

Automatic decision suggested by the system (Approve; Refer; Reject)

&=vm.Loans_SystemDecision

Total contract amount

Total amount to be accrued according to the loan schedule as it was at the moment of disbursement

&=vm.Loans_TotalContract

Total contract commission

Total comission accrued according to the loan schedule as it was at the moment of disbursement

&=vm.Loans_CommissionContract

Total contract interest

Total interest to be accrued according to the loan schedule as it was at the moment of disbursement

&=vm.Loans_InterestContract

Total disbursed amount

Sum of all successful disbursement transactions

&=vm.Loans_TotalDisbursedAmount

Total written off amount

The remaining outstanding balance on the account when it was written off

&=vm.Loans_WrittenOffTotal

Underwriter

Full name of the back-office user latest to interact with the loan (approve, reject or sent for reprocessing). If the loan was approved or rejected by System, the value should be empty.

&=vm.Loans_Underwriter

Underwriter's decision

Decision made by a back-office user (Approve; Reject)

&=vm.Loans_UnderwriterDecision

Vendor

Name of the vendor

&=vm.Loans_Vendor

Vendor address

Address of the vendor

&=vm.Loans_VendorAddress

Written off amount

For loans that were written off it is the total write-off amount. For other loans the value is 0.

&=vm.Loans_WrittenOffAmount

Written off interest

Written Off Interest amount (current value)

&=vm.Loans_WrittenOffInterest

Written off principal

Written Off Principal amount (current value)

&=vm.Loans_WrittenOffPrincipal

Written-off fees

Written off fee amount (current value).

Sum of all fees except principal and interest

&=vm.Loans_WrittenOffFees

Comment on failure

Comments from the person who reversed this transaction (Manager) or an error from a payment provider

&=vm.Transactions_FailComment

Created by

Name of the person who created this transaction (Client or Manager) or 'System'

&=vm.Transactions_Creator

Failure date

The date when a transaction became reversed / failed

&=vm.Transactions_FailDate

Fee

Fee amount (total of all the fees with Fee Type = 'Fee')

&=vm.Transactions_Fee

Interest

Interest amount

&=vm.Transactions_Interest

Leasing

Leasing amount

&=vm.Transactions_Leasing

Past due

Past Due amount (total off all the fees with Fee Type = 'PastDue')

&=vm.Transactions_PastDue

Payment type

Pament type (Cash; Check; Bank Transfer; Card)

&=vm.Transactions_PaymentType

Penalty

Penalty amount (total off all the fees with Fee Type = 'Penalty')

&=vm.Transactions_Penalty

Principal

Principal amount

&=vm.Transactions_Principal

Repayment mode

Repayment mode of the transaction

&=vm.Transactions_RepaymentMode

Reversed by

Name of the person who created this transaction (Client or Manager) or 'System'

&=vm.Transactions_FailCreator

Transaction amount

Amount of the transaction

&=vm.Transactions_Amount

Transaction comments

Comments added to the transaction by a back-office user

&=vm.Transactions_Comments

Transaction date

Date/time of the transaction

&=vm.Transactions_TransactionDate

Transaction reference

Reference ID provided for the transaction by a back-office user

&=vm.Transactions_Reference

Transaction status

Transaction status (Successful; Reversed; Failed)

&=vm.Transactions_Status

Transaction type

Type of the transaction (Disbursement or Payment)

&=vm.Transactions_Type

Undistributed amount

A part of the repayment amount that was not allocated to the principal, interest or any fees

&=vm.Transactions_UndistributedAmount