X
Icon


Blog Image

Investments

CaseWare IDEA Applications


The following tests are relevant where the accounts are interest-bearing deposits from customers.

 

Analyses

 

  • Stratify balances by size
  • Group accounts by product type
  • Age investment portfolio to analyze interest rate re-pricing risk
  • Stratify portfolio by size
  • Summarize portfolio by type, issuer, interest rate, maturity, etc.
  • Create charts of investment portfolio information

 

Calculations

 

  • Cast (or total) accrued interest
  • Prove interest capitalization, charges
  • Re-perform individual interest calculation

 

Exception Tests

 

  • Extract unusual interest rates or amounts
  • Identify/summarize dormant accounts and identify transactions thereon
  • Identify negative balances
  • Identify accounts with suppressed statements
  • Identify any records that are not complete or up-to-date
  • Test for money laundering
    *Many of the previous tests are applicable to current or checking accounts. There are also a number of tests that can be carried out when searching for money laundering.

 

Other Tests Applicable in Certain Cases

 

  • Identify forward-dated transactions
  • Provide totals of forward-dated transactions
  • Identify overdue maturities
  • Identify customers over their overdraft limit or customers with expired limits
  • Identify dormant accounts and transactions thereon
  • Re-perform currency conversions
  • Provide details of currency exposure
  • Test for cut-off

Areas of Applications , CaseWare IDEA



Posted By

By Audimation Team


Related Posts
A Simple Approach to Fighting Fraud
Feb 19 Applying Data Analysis to Uncover an Ongoing Fraud Scheme   Truth can often be found in simplicity. The Association of Certified Fraud Examiners (ACFE)...
Conducting Attribute Testing with Data Analysis Software
Oct 18 Question:   As an internal auditor, we are approached on a regular basis by software providers offering products that do not appear to have real differ...
Improving Critical Thinking Through Data Analysis
Jul 27 Originally published in the June 2017 issue of Strategic Finance. Written by Kurt Reding, Wichita State University, & Carolyn Newman, Audimation Services ...
BROWSER NOT SUPPORTED

This website has been designed for modern browsers. Please update. Update my browser now

×