Export Fixed Loan Arrears Details

Export Fixed Loan Arrears Details

Purpose

Exports the Fixed Loan Arrears details to a file that can then be imported to an external system or viewed within Microsoft Excel

Process

  1. Fixed Loan | Export Arrears Details

Report


Report Specific Parameters

Field
Explanation
Arrears Days <
Use to exclude accounts who are less than x number of days in arrears

E.g. Entering 7 will refine the export to only accounts that are more than 7 days in arrears
Reminder Days <
Not Used
Prepossession Days <
Not Used
Repossession Days <
Not Used
Cash Suspense Acct
[F2] and select the Fixed Loan Cash Suspense account to exclude from export
Ignore Arrears Less than
Enter an amount which will exclude the account from the export if the arrears are less than the specified amount
Salvage Ledger Acc Type
[F2] and select the salvage ledger account type if this should be excluded
Include Non Arrears Accounts
Unless this is checked on, then only arrears accounts will be contained in the Export

Note: Checking this on will override all the less than day field options
Termination Date
Enter the date that the termination / payoff amount should be calculated too

If no date is entered, will default to today



    • Related Articles

    • Create Marketing Communications

      Purpose Allow marketing letters to be created based on completed parameters. Selection parameters allow a refining of performing loans for which associated clients may be offered further finance. Rules used will be dependent upon each business ...
    • Fixed Loan Control Details

      Purpose Provide control details for the month end roll over process, key setup parameters and allow file paths to be selected for custom reports Access Fixed Loan | Edit/View Fixed Loan Control Details Dialog Details Details Specific Fields Field ...
    • Calculate Arrears

      Purpose A powerful arrears calculator function is available in the Fixed Loan Enquiry screen The calculator allows a credit controller to give a precise quote of an expected payment to a client for a future date, taking into account whether ...
    • Fixed Loan Aged Arrears Summary

      Purpose Calculates the number of times the instalment payment has not been received by dividing the standard instalment amount by the current balance Accounts are then grouped into ageing buckets of ‘arrears exceeds instalments by less than x number ...
    • Fixed Loan Finance Details

      Purpose To provide a breakdown of the loan cost items and allows the management of instalments Timing The Finance details may be accessed at any time. Instalments may be altered during the life of the loan. It is recommended that if further funds are ...