Filter by:

March 10, 2017
Q: Does IDEA provide a way to normalize vendor names? For example, I would like to change AMAZON MKTPLACE PMTS to AMAZON, WAL-MART002 to WAL-MART, and UPS 091238547 to UPS. The database I am working with has at least 500,000 records. A: If you are using IDEA 10, first look for exact duplicates,... Read More »
March 7, 2017
As more companies opt to reduce costs by introducing purchasing card (P-Cards) programs, stories of employees misusing the cards are increasingly making the news. Here are some of the stories making headlines recently: According to an audit conducted by the agency’s inspector general, employees of... Read More »
March 1, 2017
Like milk and cookies, our IDEA specialists like to pair functions together to get deeper insights into the data they’re analyzing. IDEA specialists Jairam Rajshekhar, Director of Client Relations at Sama Audit Systems in Mumbai, India recently shared how to apply his favorite IDEA pairs. Top... Read More »
February 24, 2017
As the Chief Operating Officer for a company that develops data analysis software, I’m frequently approached by auditors who—though deeply interested in using a data analytics tool in their engagements—simply don’t know how where to start. Data analysis is nothing new. It’s been around for decades... Read More »
February 22, 2017
Paying its due for almost a decade’s worth of crime, Western Union recently reached a settlement with the Justice Department, the Federal Trade Commission (FTC) and several U.S. Attorney’s offices. The company has agreed to pay USD $586 million for failures in its compliance program that led to... Read More »
February 15, 2017
With 30 years of experience as a Senior Computer Audit Specialist at D'Arcangelo & Co. LLP, an audit and consulting firm in New York State, Fred Lyons is an expert in the audit field. Here’s what he shared with CaseWare Analytics during a recent interview: Q: What is the most important process... Read More »
February 10, 2017
Struggling to get started using data analytics in your audit projects? Feeling intimidated by the technology or don’t know where to find the data you need to input into the data analysis tool? In the webinar presentation Surefire Ways to Succeed with Data Analytics, presenter Lenny Block, Associate... Read More »
February 9, 2017
​Most small financial institutions would agree that they’re seeing, if not feeling, an impact from the growing trend of de-risking. Earlier this week, Dave Garcia, General Manager – Group Legal and Compliance, at the National Commercial Bank Jamaica Limited (NCB), delivered an educational webinar... Read More »
February 1, 2017
The risk appetite of correspondent banks is declining. Seen as an unfortunate outcome of the 2008 financial crisis—and often used as a way to avoid potential anti-money laundering (AML) enforcement actions—many banks are opting to exit relationships with other financial institutions that are seen... Read More »
January 27, 2017
Q: I’m a tax auditor and would like to use IDEA to check sales and purchases records, look at mark-ups and verify that taxes are recorded correctly. Which @ functions can help me when appending files, sorting purchase invoices and linking names with similar addresses? A: For your project, the @... Read More »