Data Analytics in Banking & Finance
A Few of the Ways You can Put Arbutus Analytics to Work in Banking & Finance
-
Loans by Bank or Branch
- Subtotal, total, and print outstanding loan balances by any categories
- Calculate unearned revenues from interest, discounts, insurance, etc.
- Isolate delinquent accounts issued prior to a specific date
- Identify loans over or under specified amount, terms, or interest rate
- Test liability (by branch, location, etc.) in excess of lending limits
- Identify accounts with balances exceeding credit limits by overage
-
Real Estate Loans
- Print a schedule of pre-paid accounts in any order or selection
- Verify daily interest accrued, detail or summary, by any criteria
- Track activity and market value of collateral of non-performing loans
-
Investment Securities
- Calculate average yield by investment type and show detail variances
- Select samples of purchases and sales since last audit
- Identify investments for which no dividends or interest have been
received - Compare computed interest to amount actually received on
investments
-
Pension and Other Trusts
- Scan and total the schedule of investments (year-end or year-to-date)
- Verify accrued interest calculations for assets in trust accounts
- Select trust assets for auditing current market value
- Extract trust asset information based on any criteria
- Check participants’ file for nonallowable data (age, seniority, gender)
- Verify interest and capital gain income/loss distributed to accounts
-
Credit Card Management
- Identify and list accounts past due for specified time, order by amount
- Extract accounts with balances over credit limit and sort by any criteria
- Test for specific conditions (excessive adjustments, credits, etc.) by account
- Select and print detail activity for auditing selected accounts
- Recalculate and verify current month’s interest charges
Real Estate Loans
Investment Securities
Pensions and Other Trusts
Credit Card Management
Banking & Finance Applications
Download Application Sheet
Case Study
Anti-Fraud
Corporate Credit Cards & Vendor Master Data
Through the application of Arbutus Analyzer and sound audit techniques, they were able to join and analyze the entire population of 250,000+ credit card transactions (1 entire year), and then drill down to 2000 that met their audit criterial for further investigation.
For vendor master data, Arbutus Analyzer revealed 160 high risk employee/ vendor matches, from an entire population of 750,000+ records. The analysis allowed the IA team to gain massive efficiencies and quickly identify control breakdowns, root causes underlining the exceptions for management to address and remediate.
Analytics By Business Process
Learn more about various analytics tests to meet business needs.
Analytics By Business Process