You must be licenced for the Securities Register Add-On to use the functionality described below.

To open the Account Security Analysis Report, from the Report menu, click Report Explorer and select the Security Statement Reports group.

Report

Description	The Account Security Analysis Report shows amounts secured and balances.
Purpose	An effective marketing tool which allows you to analyse amounts secured and any excessive surplus or deficit.

Select the Order By and Accounts to show

Order By

Select the order in which the report is to appear, by Code, Name, Date Opened, Date Quoted, Overdue, Overdue Days, Contractual Overdue, Contractual Overdue Days, Balance, Next Payment Date, Last Payment Date and Maturity Date.

Descending

Tick to display in a descending order or leave blank to display in an ascending order.

Accounts

Select the Accounts to be included or leave blank to include all.

Alternatively use F6 to look up Accounts.

Date As At

Enter the report "As At" date. The Date 'As At' is used when calculating values such as Monitor Categories, Balance and Overdues.

Specify Report options

Details

Select to display as Summary, Details, Type Summary or Details plus the Summary.

Option

Select to display either LVR (Loan to Value ratio) or Security Value.

Include Accounts with no Securities

Tick to display Accounts with no securities.

Select Columns to include

Columns

Tick to include the applicable Columns in the report.

See Topics, for more information about Account Filters, Ranges, Grouping, Printer, Data Export, Add to Queue and Settings.

Reports, Security Statement Reports, Account Security Analysis Report