Record Values Available for Report Columns

Each report type has a set of record values that can be used to generate column values.

• Ledger Report
• Payment Report
• Amortization Schedule
• Financial Summary Reports - The SummaryOfFinancesRecord values are computed based on transactions and balances relative to the starting and ending dates on the report. Click for details.
• Payment Summary - these reports will list all the payments in the portfolio. Useful for things such as gross receipts and payment reconciliation purposes.
• Portfolio Transactions - The transaction items available on the Ledger report are exposed as possible column values along with the corresponding loan, borrower, and lender values (and any Custom fields) for each transaction.
• Projected Payment Summary - This matches the payment report format, but hypothetical future payments are auto-generated when the report is run.
• Loan Expenses - This report type exposes the properties of expense items on a single loan.
• Portfolio Expenses - This report type exposes the properties of individual expense items, along with the corresponding loan, borrower, and lender properties and will list expenses for all loans in the portfolio.