General discussion
Reasons to stop using spreadsheets for audit analysis
Forums
I just found this presentation by CaseWare on why you should stop using spreadsheets for audit analysis. Through everyone might be interested.
http://www.slideshare.net/CaseWare_Analytics/reasons-to-stop-using-spre…
Variance in totals appended versus excel
Forums
Hi Brian,
Hope you are doing good. I have a question regarding the differces found in totals with appended database and individual totals of the files.
for eg 12 months data in text imported into idea with four decimal places and to validate the appended database i have taken the total of each file from the field statistics and input the same into excel, but after appending all the 12 files i am facing a difference of more than 1000 with the appended database and the grand total of excel file. What could be the reason for this??
Thanks for your help.
- Read more about Variance in totals appended versus excel
- 5 comments
- Log in or register to post comments
Benford's Law in the Movies
Forums
I haven't seen the Ben Affleck movie the Accountant yet but I understand that he uses Benford's Law in one area. I guess he finds a larger than expected use of the number three which would entail him using Benford's law.
http://www.thewrap.com/accountant-adds-up-real-review-ben-affleck/
- Read more about Benford's Law in the Movies
- Log in or register to post comments
IDEA 10.2 has been released
Forums
Just saw this on the CaseWare Analytics web site that they have released 10.2.
https://www.casewareanalytics.com/blog/product-close-whats-new-idea-102
- Read more about IDEA 10.2 has been released
- Log in or register to post comments
6th IDEA User Conference and Anniversary Celebration
Forums
Just saw this posted on linkedin by Audimation:
We are pleased to announce that we will be hosting the 6th IDEA User Conference and Anniversary Celebration. Audimation will be 25 and IDEA will be 30!! Mark your calendars and make plans to join us in Houston, TX on November 1 & 2, 2017. It’s going to be a great time, with sessions by our expert IDEA users and hands-on training by our top-notch team of trainers. We hope to see you there! Registration will open in the spring. - Carolyn Newman
- Read more about 6th IDEA User Conference and Anniversary Celebration
- Log in or register to post comments
Calculating cumulative sum of a particular column
Forums
Hi,
Is it possible to calculate the cumulative sum of any column in IDEA?
Thanks,
Bibin
Question regarding Summarized Data
Forums
Hi,
Is it possible to get the base population file in case we are provided with only Summarized data? It is taking time to extract each summarized data (by cliking oin the number of records hyper link)and finally we need to append. Is there any easier way to do the same?. Thanks, Bibin
- Read more about Question regarding Summarized Data
- 4 comments
- Log in or register to post comments
5 Key Areas to Test When Building an Effective Audit Plan
Forums
CaseWare IDEA has just released a white paper entitled 5 Key Areas to Test when Building an Effective Audit Plan. This document has a list of tests that an auditor might perform in the areas of Accounts Payable, Accounts Receivable, General Ledger, Payroll and Inventory and Stock Data. Well worth checking out. https://www.casewareanalytics.com/sites/default/files/whitepapers/5_key…
Adding Columns to Views
Forums
Hi everyone,
I know this is a basic question, but is it possible to add one single column at a time to existing view?
I didn't see where this functionality exits in IDEA but maybe I missed it? Any help would be appreciated!
Mike
- Read more about Adding Columns to Views
- 6 comments
- Log in or register to post comments
Computer Assisted Auditing Using IDEA - With Carolyn Newman
Forums
I was doing a google search and came across this transcript. I saw IDEA and recognized Carolyn Newman as being part of Audimation in the US. I started reading the transcript and some of the things seemed funny so I went back and looked at the date and it was from Jan 2000. If you read it you will see t