Record Values for Financial Summary Reports

For the record values available for other report types, see Record Values Available for Report Columns.

Most of the SummaryOfFinancesRecord values will be adjusted by the ownership percentage of the selected lender whenever a specific lender is selected in the Lender drop-down of the report viewer.

• SummaryOfFinancesRecord:AccountNumber - The account number of the row’s loan.
• SummaryOfFinancesRecord:AdjustmentDecreases - The sum of all negative adjustments on the loan within the report’s date range.
• SummaryOfFinancesRecord:AdjustmentIncreses - The sum of all positive adjustments on a loan within the report’s date range.
• SummaryOfFinancesRecord:Adjustments - The sum of all adjustments (may be positive or negative depending on if more positive or negative adjustments were made) within the report’s date range.
• SummaryOfFinancesRecord:Aging0 - Usually used in conjunction with the other Aging columns. The portion of the amount due on the report's end date that became due 30 days or less before the report's end date.
• SummaryOfFinancesRecord:Aging31 - Usually used in conjunction with the other Aging columns. The portion of the amount due on the report's end date that became due 31 to 60 days before the report's end date.
• SummaryOfFinancesRecord:Aging61 - Usually used in conjunction with the other Aging columns. The portion of the amount due on the report's end date that became due 61 to 90 days before the report's end date.
• SummaryOfFinancesRecord:Aging91 - Usually used in conjunction with the other Aging columns. The portion of the amount due on the report's end date that became due more than 90 days days before the report's end date.
• SummaryOfFinancesRecord:AmountDue - The balance of the amount due account on the loan at the end of the day on the report’s ending date.
• SummaryOfFinancesRecord:AmountDueDate - The date that corresponds with the Loan:AmountDue, it is the date that appears in the details panel of the main window (this will be the greater of the loan's current due daye and its next payment due date).
• SummaryOfFinancesRecord:AmountDueInitial - The balance of the amount due account on the loan at the beginning of the day on the report’s starting date.
• SummaryOfFinancesRecord:Attachments - List of all attached files on a loan that were attached during the report date range, showing attachment date and file name.
• SummaryOfFinancesRecord:AverageMonthlyPIReceivable - The regular payment amount set on the loan converted to an average monthly value. Using the amount reported in the RegularPaymentAmount value, and multiplying or dividing based on the schedule of the the last payment setting on the loan that occurs on or before the report's end date. Ex: semimonthly payment amount multiplied by two, quarterly payment amount divided by three, etc.
• SummaryOfFinancesRecord:BorrowerAddress - Address of the primary borrower.
• SummaryOfFinancesRecord:BorrowerCompany - Company of the primary borrower.
• SummaryOfFinancesRecord:BorrowerEmail - Email of the primary borrower.
• SummaryOfFinancesRecord:BorrowerFormattedName - Assembled name of the primary borrower, usually “First Last”, or “Company”.
• SummaryOfFinancesRecord:BorrowerPhone - The day phone of the primary borrower.
• SummaryOfFinancesRecord:BorrowerTaxID - The Tax ID or Social Security Number of the primary borrower.
• SummaryOfFinancesRecord:CostBasisBeginning - The cost basis unrecovered as of the start of the report's date range. Only populates when a specific lender is chosen for the report. PrincipalRepaid during the report period will be the difference between CostBasisBeginning and CostBasisRemaining, and PrincipalRepaid plus DiscountEarned represents the portion of payments received that are marked "principal". When a specific lender is selected, and the cost is set on the lender setting for the loan, the principal paid is split into the basis (money invested) and the discount (markup). When added to the OpeningDiscountUnearned (the part of the principal that is profit) it should equal the opening principal balance on the loan.
• SummaryOfFinancesRecord:CostBasisRemaining - The cost basis unrecovered as of the end of the report's date range. Only populates when a specific lender is chosen for the report. When added to the RemainingDiscountUnearned (the part of the principal that is profit) it should equal the ending principal balance on the loan.
• SummaryOfFinancesRecord:CreditLimit - The credit limit of the loan.
• SummaryOfFinancesRecord:CurrentInterestRate - The interest rate on the loan at the end of the day on the report’s ending date.
• SummaryOfFinancesRecord:DiscountEarned - The amount of purchase discount earned by the selected lender as a result of principal pay-down from all payments within the report’s date range.
• SummaryOfFinancesRecord:EscrowBalance - The balance of the escrow account at the end of the report’s date range.
• SummaryOfFinancesRecord:EscrowCharge - The escrow charge amount in effect at the ending date of the report’s date range.
• SummaryOfFinancesRecord:EscrowDepositsCollected - The total of all payments that were put into the escrow account within the report’s date range, including both Escrow Only payments and the portion of Regular or Interest Only payments that was diverted to the escrow account.
• SummaryOfFinancesRecord:EscrowDisbursements - The total of all funds disbursed from the loan’s escrow account during the report’s date range.
• SummaryOfFinancesRecord:EscrowDue - The balance of the escrow due account on the loan on the report’s ending date. This is how much of the next payment would be diverted to the escrow account to comply with the escrow charge settings on the loan.
• SummaryOfFinancesRecord:EscrowDueInitial - The opening balance of the escrow due account on the report’s start date. This is how much was already due to be paid into escrow when the report period started.
• SummaryOfFinancesRecord:Extension1Charged - The sum of all transactions that increased the Extension1 account.
• SummaryOfFinancesRecord:Extension1EndingBalance - The balance of the Extension1 account after all the transactions during the report period.
• SummaryOfFinancesRecord:Extension1OpeningBalance - The balance of the Extension1 account before any transactions during the report date range.
• SummaryOfFinancesRecord:Extension1Paid - The sum of all transactions that reduced the Extension1 account (includes payments and adjustments).
• SummaryOfFinancesRecord:Extension2Charged - The sum of all transactions that increased the Extension2 account.
• SummaryOfFinancesRecord:Extension2EndingBalance - The balance of the Extension2 account after all the transactions during the report period.
• SummaryOfFinancesRecord:Extension2OpeningBalance - The balance of the Extension2 account before any transactions during the report date range.
• SummaryOfFinancesRecord:Extension2Paid - The sum of all transactions that reduced the Extension2 account (includes payments and adjustments).
• SummaryOfFinancesRecord:Extension3Charged - The sum of all transactions that increased the Extension3 account.
• SummaryOfFinancesRecord:Extension3EndingBalance - The balance of the Extension3 account after all the transactions during the report period.
• SummaryOfFinancesRecord:Extension3OpeningBalance - The balance of the Extension3 account before any transactions during the report date range.
• SummaryOfFinancesRecord:Extension3Paid - The sum of all transactions that reduced the Extension3 account (includes payments and adjustments).
• SummaryOfFinancesRecord:FeesDueInitial - The opening balance of the fees account on the report’s starting date. This is the total of unpaid fees that were owed at the beginning of the report period.
• SummaryOfFinancesRecord:FeesOutstanding - The ending balance of the fees account on the report’s end date. This is the total of unpaid fees that have accumulated on the loan by the report’s end date.
• SummaryOfFinancesRecord:FeesRepaid - The total of the portion of all payments within the report date range that was applied towards fees on the loan.
• SummaryOfFinancesRecord:FinalPaymentDate - The last scheduled payment date on the loan.
• SummaryOfFinancesRecord:InterestDueInitial - The amount of unpaid interest accumulated on the loan at the beginning of the report’s start date. The opening balance of the fees account on the loan.
• SummaryOfFinancesRecord:InterestEarned - The sum of all interest transactions that added interest to a loan during the report’s date range.
• SummaryOfFinancesRecord:InterestOutstanding - The balance of the interest account at the end of the report’s date range. This is how much unpaid interest remained at the end of the report period.
• SummaryOfFinancesRecord:InterestRepaid - The sum of the portion of all payments within the report’s date range that was applied toward interest.
• SummaryOfFinancesRecord:InterestUnearned - Not implemented. Will always have a value of zero.
• SummaryOfFinancesRecord:LateFeesCharged - The total of all late fees added to a loan within the report’s date range.
• SummaryOfFinancesRecord:LateFeeSettingAmount - The number from the last late fee setting on a loan, or zero if no late fees apply.
• SummaryOfFinancesRecord:LatestPaymentAmount - The amount of the last payment received on a loan, including payments marked returned (see RecentPayment below). Ignores the report’s date range.
• SummaryOfFinancesRecord:LatestPaymentDate - The date of the last payment received on a loan, including payments marked returned (see RecentPayment below). Ignores the report’s date range.
• SummaryOfFinancesRecord:LenderAddress - The address of the primary lender.
• SummaryOfFinancesRecord:LenderCompany - The company of the primary lender.
• SummaryOfFinancesRecord:LenderEmail - The email of the primary lender.
• SummaryOfFinancesRecord:LenderFormattedName - The formatted name of the primary lender – same as the lender’s company.
• SummaryOfFinancesRecord:LenderOwnershipBeginDate - When the lender's ownership share on the loan takes effect during the report period, the date that ownership begins is shown. Otherwise blank. This value is only populated when a specific lender is chosen in the report options at the top of the report viewer window.
• SummaryOfFinancesRecord:LenderOwnershipEndDate - When a lenders ownership share on the loan ends during the report period, the date ownership ends is shown. Otherwise blank. This value is only populated when a specific lender is chosen in the report options at the top of the report viewer window.
• SummaryOfFinancesRecord:LenderOwnershipPercent - The percentage ownership from this lender's setting on the loan.
• SummaryOfFinancesRecord:LenderPayableTo - The payable-to field of the primary lender.
• SummaryOfFinancesRecord:LenderPhone - The service phone of the primary lender.
• SummaryOfFinancesRecord:LenderPricePaid - The Price Paid from the lender setting on the loan, regardless of when that purchase occurred.
• SummaryOfFinancesRecord:LenderPricePaidWithinReport - The value from the price paid on the lender setting for this lender-loan combination, but only if the purchase was during the report date range. If the lender is on the loan for the whole loan, the loan's Origination Date is used. If the lender has a specific ownership start date, that date is used to determine if th epurchase happened within the report date range.
• SummaryOfFinancesRecord:LenderTaxID - The primary lender’s tax ID.
• SummaryOfFinancesRecord:LoanExpenses - The sum of any expenses entered on the loan within the report's date range.
• SummaryOfFinancesRecord:LoanStatus - A number to indicate the status of the loan - corresponds to the icon shown on the left side of the main window: 0 - current, 1 - due, grace period - late, 30 - one month late, 60 - two months late, 90 - three months late, 120 - severely late (four or more months late)
• SummaryOfFinancesRecord:NextDueDate - The oldest due date that has not been fully paid by the borrower yet. Same as Loan:NextPaymentDue.
• SummaryOfFinancesRecord:Notes - List of the notes on the loan within the report date range in the format Date - Tite. One note on each line.
• SummaryOfFinancesRecord:NotesDetails - - List of the notes on the loan within the report date range including date, tite and note text.
• SummaryOfFinancesRecord:OpeningDiscountUnearned - The amount of the selected lender’s discount that had not yet been earned at the beginning of the report’s start date.
• SummaryOfFinancesRecord:OtherFeesCharged - The total of other fees that were added to a loan within the report’s date range.
• SummaryOfFinancesRecord:OverallBeginningBalance - The opening balance of the Ledger account on the loan at the beginning of the report’s start date.
• SummaryOfFinancesRecord:OverallEndingBalance - The ending balance of the Ledger account on the loan at the report’s end date.
• SummaryOfFinancesRecord:PaidThrough - The newest payment due date that has been fully satisfied by the borrower, always the due date before the NextPaymentDue date. Same as Loan:PaidThrough.
• SummaryOfFinancesRecord:Payments - The sum of the amount of all payments received within the report’s date range.
• SummaryOfFinancesRecord:PerDiemInterest - The daily interest accruing on the loan based on the interest rate and interest bearing balance on the final day of the report's date range.
• SummaryOfFinancesRecord:PointsPaid - The points paid value from the loan, same as Loan:PointsPaid.
• SummaryOfFinancesRecord:PrepaymentPenaltyFeesCharged - Not implemented. Moneylender 3 does not currently support preconfigured prepayment penalties. Rule of 78’s, commonly called a prepayment penalty, is actually a discount against the precomputed interest on a loan and will appear as a negative adjustment to the interest on the loan when configured.
• SummaryOfFinancesRecord:PrincipalBeginningBalance - The opening balance of the principal account on the report’s start date.
• SummaryOfFinancesRecord:PrincipalChargedOff - The amount of principal charged off is the loan was closed within the report’s date range, otherwise zero.
• SummaryOfFinancesRecord:PrincipalDisbursed - The total of all principal disbursals that fall within the report’s date range.
• SummaryOfFinancesRecord:PrincipalOutstanding - The ending balance of the principal account on the report’s end date.
• SummaryOfFinancesRecord:PrincipalRepaid - The sum of the portions of all payments within the report’s date range that were applied to principal.
• SummaryOfFinancesRecord:RecentPaymentDate - The amount of the last payment received on a loan that was not marked returned (see LatestPayment above). Ignores the report’s date range.
• SummaryOfFinancesRecord:RecentPaymentAmount - The amount of the last payment received on a loan that was not marked returned (see LatestPayment above). Ignores the report’s date range.
• SummaryOfFinancesRecord:RegularPaymentAmount - The amount of the last regular payment that became due on or before the report’s end date (if the last regular payment was due before the report’s start date, this amount is still shown).
• SummaryOfFinancesRecord:RemainingDiscountUnearned - The amount of the purchase discount that has not yet been earned by the selected lender
• SummaryOfFinancesRecord:TotalFeesCharged - The sum of all fees (both Late Fees and Other Fees) added to a loan within the report’s date range.
• Loan:… - all values prefixed with Loan: are taken directly from the loan record at the time the report is run. No consideration is made on these values for the selected date range, lender, or other settings. These values provide a snapshot of the loan as it is configured and represented in the portfolio file. Some values that should be self-explanatory have been omitted. Details about certain values are listed below.
• Loan:AvailableCredit - The credit limit minus the principal outstanding on the loan.
• Loan:Closed - The loan’s status – open, application, satisfied, unsatisfied, declined application.
• Loan:CurrentDueDate - Based on the “Statements and main window use amount due from X days in the future”, this is the last scheduled payment due date that is not more than X days in the future.
• Loan:PaymentCount - Total number of scheduled payments on the loan.
• Borrower:… - All Borrower: values are taken directly from the primary borrower record without regard to report date range or other report configuration.
• Lender:… - All lender data is taken directly from the primary lender record on the loan without regard to the date range or other report configuration.
• CustomLoan…, CusomtBorrower…, CustomLender… - any custom fields you have added to the loan, borrower, or lender records can be used as record values for creating a report column.