Account Liquidity Report

Account Liquidity Report

Purpose

To show the split of cashflows by module into the aging buckets specified. Detailed on the report are for each account by aging bucket:
  1. Arrears
  2. Net Principal
  3. Carrying Amount (Arrears + Net Principal)
  4. Effective Interest Rate
  5. Accrued Interest
  6. Accrued RWT
  7. Gross Nominal Inflow/(Outflow) (Carrying Amount + Interest Accrued - RWT Accrued)

Timing

Report may be run at any time, but normally at month end

Access

  1. Accounts | Print Account Liquidity Report

Report


Report Specific Parameters

Field
Explanation
# Months in Age Bucket 1-12
Enter the number of months required in each aging bucket


From the above example:
  1. Bucket 1 will include all Accounts that have amounts to be repaid within one month will be included in this bucket. All Call Accounts will be included in this bucket
  2. Bucket 2 will include all Accounts with amounts to be repaid in months 2-3
  3. Bucket 3 will include all Accounts with amounts to be repaid in months 4-6
  4. Bucket 4 will include all Accounts with amounts to be repaid in months 7-12
  5. Bucket 5 will include all Accounts with amounts to be repaid in months 13-60
  6. Any Accounts with amounts to be repaid over 60 months will fall into a final bucket
Active Accts Only
Check on if only active accounts are to be included




    • Related Articles

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

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