Fixed Loan Cashflow Report
Purpose
To show the Cashflow impact on the business if all accounts are paid when due
Displays the split between principal and interest each month
Timing
The report may be run and any time, it is strongly recommended it is always run prior to month end
Access
- Fixed Loan | Print Fixed Loan Cashflow Report
Report
Report Specific Parameters
Field | Explanation |
Number of Periods | The number of periods the report is to be run over A separate line will be printed for each period Any loans with a cashflow effect after the nominated periods will be included in the report line for that period |
Include Suspended | By default, accounts that have an operational status of suspended are excluded from the report as the instalment is no longer expected to be receipted Check this on to include those accounts |
New Page Per Group | A separate page will be printed for each change in group of the selected Report Order |
Notes
The View Report option provides a summary Cashflow report
Detailed analysis of each accounts principal and interest for each period is available by using the Export Report data option.
Related Articles
Month End Processing Checklist
The significance of Month End Procedures It is important that checks are made at the time of month end reset, (usually the first working day of a new month) that will ensure the continued integrity of the systems. A brief description of each ...Variable Loan Cashflow Report
Purpose To show the Cashflow Impact on the business if all accounts are paid when due Loans with Compound Interest will show all interest due in the month of maturity Interest Only loans payable monthly will show the interest due month by month, and ...Fixed Loan New Contracts Report
Purpose Provides a list of all accounts opened within the specified date range Timing May be run at any time. Normally run at month end Access Fixed Loan | New Contracts Report Report Report Specific Parameters Field Explanation Transaction Type 1 & ...Fixed Loan Account Status Report
Purpose Provides an overview of the position of the Fixed Loan ledger at a set point in time. Accrued Interest and Early Termination amounts can be included. Timing Must be run during the Month End process for reconciliation to the General Ledger May ...Fixed Loan Dealer Retention Report
Purpose To report Dealer Retentions and commissions for a nominated period Timing This report is usually run at month end This report is required to undertake Dealer Retention Processing Access Fixed Loan | Print Dealer Retention Report Report Report ...