Reports Menu

Available from the Main Menu, the Reports menu lets you print informational reports based on a single loan or on an entire portfolio. To print a report on a single loan, you must select the loan in the list of loans first.

The main difference between a report and a statement is that statements display only the current status of a loan, while reports generate numbers computed from a broad arrangement of records summarized and displayed in more complex ways.

This distinction is the reason reports are not customizable, but statements are. Because reports read a large number of records from a portfolio — especially the entire portfolio reports — it takes some time to generate the report, especially in a network environment.

Single Loan Reports

Payment Detail Reports contains four sub-menu items.

Loan Payment Detail generates a report showing the details of each payment applied to a specific loan.
Payment Detail with Notes is similar to the Loan Payment Detail, but the font is smaller. It also includes a column that shows the text from each payment's Note field, such as check number.
Payment Detail Without Rates is similar to Payment Deal with Notes, except interest rates are not included.
Extended Payment Detailis similar to Payment Deal without Rates but includes fees.

Loan Status Detail shows the status of a loan from due date to due date and the total amount of payments received during that period.

The Amortization Tables menu contains two sub-menu items.

Amortization Schedule prints the projected amortization table from open date to maturity, assuming only the regular payment is received each month. If the regular payment or interest rate varies over the life of the loan, it is reflected in the amortization schedule.

Amortization Schedule with Totals prints the same information as the Amortizaion Schedule, but, in addition, each column is totaled.

The Third Party Fees records payments for any additional parties — other than the principals— involved in a loan.

The Complete Accounting Report displays payments, finance charges, credits, balance, and amounts during a specified time period.

The Principal Balance Ledger displays debits, credits, and outstanding principal during a specified time period.

Entire Portfolio Reports

Loan Control Report Displays the net portfolio balance, including breakdowns such as Paid Out, Interest, Special Charges, Payments, and Other Credits.

Income Analysis shows the details of money received monthly over a selected date span. It also shows a breakdown of principal received and interest received.

Cash Flow shows a monthly comparison of principal amount of new loans with payments received for a selected date span.

Summary of Loans shows how much money was received on each loan during a specific period. The report is separated by lender if there are multiple lenders in the portfolio.

Receivables Report shows borrower names, outstanding principal, and payments due for each lending company.

Arrears Report shows andy borrowers with payments outstanding along with the balance, fees, interest, and principal.

Interest Earned Report shows total, earned, and unearned interest during a specific time period for each lending company.

Aging Report show amount due and balance over a select period of time.

Reports - Aging Reports

Gross Receipts shows the payment amount and date receiveved for each account.

Portfolio Snapshot provides an overview of all accounts within a portfolio, including important dates, balance, and amount due.

Borrower List shows contact and other important information for each borrower.

Loan Yields shows average daily balance and interest for each account.

Loan Totals shows basic information about each account, including total due, interest, and fees.

Collections Reportshows amount due, including late fees and past due amounts.

Payments Dueshow payment amount and due date for each account.

The Multiple Lenders menu contains five sub-menu items.

Income Analysis: tracks principal, interest, and fees
Cash Flow: compares amount paid out to amount received
Summary of Loans: provides a full rundown of all loans
Loan Totals: breaks up each loan, including amount due, principal, interest, fees, and balance
Investment Analysis: compares investments to profits