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
Nov 16 One of the most powerful tools in IDEA is the ability to create equations, save them as “.eqx” files, and share them with colleagues. By utilizing the list ...
Jul 18 Importing data into IDEA is a popular topic. But sometimes, it might be useful to take those IDEA databases and work on them in another application such as Tabl...
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)...
BROWSER NOT SUPPORTED
This website has been designed for modern browsers. Please update. Update my browser now
