Account Exposure Report

Account Exposure Report

Purpose

To report the Exposure risk of clients to the company.

This report can be run for all clients or against those with the highest exposure.

Timing

This report may be run at any time

Access

  1. Accounts | Print Account Exposure Report

Report


Report Specific Parameters

Field
Explanation
Top Clients
Used to report Top Client exposures

Results will be restricted to the entered number of clients

If left as 0, all clients will be reported
Report Order
Options of Client or Dealer

If Top Clients is entered Report Order disables and the report is run by Client

If Report Order is Dealer, the Top Clients field is disabled
Summary Only
Check on to summarise the report

When Top Clients is entered, the report defaults to summary
Condensed Layout
Change the report output to exclude the rebate, and percentage calculations. The report instead displays the standard instalment amount and number of instalments posted
Include Residual Value
Only enabled with 'Condensed Layout' is checked on

The Residual Value to be printed will be:
  1. The value of Cost Item 15 on the Lease or Fixed Loan Account
    OR
  2. If the module is Fixed Loan and Cost Item 15 has a zero value then a test will be made for a balloon payment at the end. The test for the balloon payment is if there is a single final instalment (last instalment in the schedule has a court = 1) AND there is a Tax amount associated with the final instalment, then update the RV field on the report with the instalment amount of that final instalment (ex GST)
Maturity Date To/From
Maturity Dates will be as follows:
  1. Fixed Loan - Calculated End Date
  2. Lease - Calculated End Date
  3. Variable Loan - Maturity Date (if a Variable Loan does not have a maturity date will not be displayed)
  4. Bailment - Due in Full Date
Dates are not mandatory
Calculate Rebate @ 100%
Check this on to override the default rebate percentage specified on the Account Type

(Not required if the Default percentage is set to 100%)
Order Exposure by Net Balance
Only available when Top Clients is entered

Reporting by descending order of client net balance
Lending Modules
All Lending Modules are included by default

Check on if only specific Modules should be included



    • Related Articles

    • Account Investment Concentration Report

      Purpose Exposure Report for the Investment Accounts Displays (in descending order) the total value of the investment and number of accounts held by each client Timing Usually run at month end, but may be run at any time Access Account | Print Account ...
    • 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 ...
    • Lease Account Summary Report

      Purpose To provide the client with a transactional history and balance of a Lease Account Rules for selection of transactions to appear on summaries The transaction is not grouped Transaction value date is within the Transaction Date Range specified ...