Variable Loan Account Status Report
Purpose
This
report provides a snapshot of the Variable Loans
Accounts within the selected parameters. It
can be run in detail to provide an account by account overview or in summary
It
includes details such as:
- Account Balance Current (Arrears and Prepayments), Future Ledger and Total Outstanding
- Accrued Interest Position of both the Current and Future Ledgers
- Available / Overdrawn Facility Limits
- Maturing Loans
Timing
The
report may be run at any time, it is strongly recommended it is always run
prior to month end
Access
- Variable Loan | Print Variable Loan Account Status Report
| Reports | Print Account Status Report
Report
Report Specific Parameters
Field | Explanation |
Operational Status | Combo Box Selection, Defaults to All Dropdown and select to run report for only accounts with an operational status of normal or suspended |
Due Over (Months) | Provides a total of the "Total Outstanding" for all accounts where the maturity date is the specified number of months in advance of today's date |
Due Less Than (Months) | Provides a total of the "Total Outstanding" for all accounts due to mature with the specified number of months |
Credit Balances (Current) | Check this flag on to report only clients with credit current ledger balances |
Credit Balances (Future) | Check this flag on to report only clients with credit future ledger balances |
Debit Balances (Current) | Check this flag on to report only clients with debit current ledger balances |
Debit Balances (Future) | Check this flag on to report only clients with debit future ledger balances |
Future Zero | Check this flag on to report only clients with Future Ledger balances of zero Can be used in conjunction with the current balance flags |
Exclude Accts w/no Maturity Date | Check on if clients that do not have a maturity date are to be excluded from the report |
Overdrawn Facility | Check this on to report only accounts that have a balance greater than their facility limit |
Related Articles
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 ...Unit Fund Account Status Report
Purpose Provides details of the Unit Fund account current and future ledger balances in dollar and unit amounts. Accrued Interest may also be reported. Timing The report may be run at any time Access Unit Fund | Print Variable Loan Account Status ...Account Status Report
Purpose Provides details of the account current and future ledger balances Accrued Interest may also be included Timing Account Status Reports can be run at any time Mandatory reporting for Month End Processing Access Accounts | Print Account Status ...Distributor Account Status Report
Purpose Provides details of the Distributor account current and future ledger balances Accrued Interest may also be included Timing Account Status Reports may be run at any time Mandatory reporting for Month End processing Access Bailment | Reports | ...Insurer Account Status Report
Purpose Provides details of the Insurer account current and future ledger balances Accrued Interest may also be reported Export report data option can be used to review additional set up structures that have been applied to the insurer accounts (such ...