Account Arrears Report

Account Arrears Report

Purpose

This report details the Arrears Position of the company loan portfolio

It will be used for regular credit control and management reporting

Timing

The Arrears report is usually run after daily processes of posting cash, recurring charges and instalments

Access

  1. Accounts | Print Account Arrears Report (by Amount)

Report

Report Specific Parameters

Field
Explanation
Date
The Date the report is run to

This will affect the calculation of the number of arrears days
Ageing
Determines whether the Arrear Ageing will be displayed in weekly or monthly ageing buckets
Arrears Less Than Amount
Restricts the output to those accounts where the Current Ledger Balance is less than this amount
Arrears More Than Amount
Restricts the output to those accounts where the Current Ledger Balance is more than this amount
Arrears Less Than DaysRestricts the output to those accounts where the Days in Arrears is less than or equal to this value
Arrears More Than Days
Restricts the output to those accounts where the Days in Arrears is greater than or equal to this value
Net Receivable Less Than
Restricts the output to those accounts where the Net Receivable Balance is less than this amount
Net Receivable More Than
Restricts the output to those accounts where the Net Receivable Balance is more than this amount
Instalment Frequency
Restricts the output to those accounts with the selected instalment frequency
Memo Communications
When checked on, the output includes the latest Memo Communications

A maximum of 4 may be entered
Limited Ageing
If this checkbox is selected, ageing is reduced to four buckets and the following columns are included
  1. Open Date
  2. Due Date
  3. Last Paid Date
  4. Last Paid Amount
  5. Last Letter Sent
  6. Last Letter Date
The Arrears Charges, Inst Pst and Sold Date columns are also removed
Included Security
Check this on to print details of the collateral items loaded against the account
Client on Separate Line
Check this on to print the client address details under the client name
Summary Only
Check this on to display only the summary total for the selected Report Order, Company, Currency and Ledger
Page Break
Check on if the report should begin on a new page when the selected report order changes
Include Client Tags
Check on if Client Tags are to be included in the Export of Report Data



    • Related Articles

    • Variable Loan Account Type Setup

      Purpose Account Types are to differentiate the types of Variable Loans provided. Examples may be: Interest only compounding Interest only repayable Principal and interest Or the distinction may be by product offering: Revolving Credit Mortgage ...

    • Credit Control - Enquiry Dialog

      Purpose Credit control is undertaken initially through access to a lending account Enquiry dialog. The Enquiry dialog is a display only summary dialog, which provides a snapshot of an account with information specific to credit control. Shortcut ...

    • 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 ...

    • Missed Payments Report

      Purpose To identify any Vault loan account against which no repayment has been received between a specified date range This will include accounts with credit current (arrears) balances Timing Report can be run at any time Access Accounts | Print ...

    • Bailment Credit Facility Report

      Purpose Provide details of credit limits by Bailment Dealer Included are the limit types, amount of the limit, utilised credit, utilised credit percentage and the credit status for each bailment dealer Timing This report may be run at any time Access ...