CaseWare IDEA is a data analysis and data extraction tool supporting audit processes. IDEA integrates with various solutions to make obtaining and exporting data easy, such as SAP solutions, accounting packages, CRM systems and other enterprise solutions for a single version of the truth.
N/A
Google Sheets
Score8.9 out of 10
N/A
Google Sheets is the spreadsheet app available on Google Workspace, or standalone, with a free plan for personal use and accessible via mobile apps for iOS and Android.
One example of specific scenario in [CaseWare] IDEA is the ability to run samples separately and then based off of the results, compare and contrast the values recorded and easily discern if there are any variables or discrepancies within the data itself. Also, we can test journal entries with certain parameters to check the audit for any issues that may arise pertaining to the criteria. By testing, we are able to make sure the data is accurate and sufficient.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Google Sheets is well suited in two main areas: is free to use and you don't need to buy a license to use it, comparing to the most direct competitors ; collaboration is in my opinion the best advantage, with multiple people working together and seeing others working in real time. It's less appropriate in low connectivity environments (offline capabilities)
Can use on large quantities of data and quickly analyze them.
Uses logic that can be followed if one is an auditor. I, for example, could understand the logic in a number of samples, i.e how the number of samples thrown changes when risk changes from low to moderate in proportion taking in consideration the materiality.
Other audit firms are using 2 software for the process that IDEA alone can do. So IDEA has a definite advantage here.
Collaborative planning : In the initial phase of project, Team leads and architects create a permission matrix along with the naming convention simultaneously, seeing who is editing / adding the details in real-time.
Cost tracking : We use this tool to track cloud resource usage monthly costs, so that we can analyse it and send out comms for high cost based resources. By storing cost data here, it's easy for use to store data of last couple of years.
Flexible documentation : For change logging of different scenarios we would need different / ad-hoc columns to be added on the fly, which makes using this tool much simpler then reputed third party tools.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
I am not involved in the purchase/selection process, but my organization is a Google shop, and Sheets meets most of our spreadsheet needs and works seamlessly with our other tools. I don't anticipate our switching anytime soon.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
It can easily handle most uses and functions. It is only for very large datasets or advanced analysis that it either lacks the proper functions or performance begins to slow. Most employees who continue to use competitors' products do so out of preference, familiarity with the user interface, or other surface-level reasons.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Like most Google products, Google Sheets rarely has outages or slowness, and when it does, connection is always momentarily restored. I can't recall a time when I've been unable to access Google Sheets but able to access other sites just fine. That said, errors aren't uncommon when handling large data volume. You know what they say about using spreadsheets as databases, but sometimes it's just the most convenient option, especially for smaller or one-off projects, and not being able to store large amounts of data hampers our ability to move quickly with scrappy prototypes or full solutions. It would be great if we could better integrate our data manipulation (Apps Script) with big data in the sheet.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Again, Google Sheets is no exception to Google's general high speed and reliability, but load times can be slow for larger amounts of data. I've used Sheets with Zapier and have used the Python API, and speed has never been an issue.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
I have never contacted Google Sheets support, but Google Sheets makes it very easy to report an issue or suggest a feature from Sheets itself (Help > Help Sheets improve), and I've had mostly good experiences with support for other Google products.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
I have used Microstart and would definitely vote for IDEA because IDEA combines what Microstart does with the help of one/more softwares. Where Microstart just gives a number of samples, IDEA selects the number of samples based on materiality, risk, and other factors. It selects those samples from the population leaving out line items that are invalid/ zero. I would prefer using IDEA any day.
I have found that I can do almost everything I could have done in Microsoft Excel faster and easier in Google Sheets. We recommend Google Sheets in 99.9% of our use cases and feel it meets the needs of our workers very well. I am sure there are other spreadsheet creation programs out there, but because we are already in the Google environment, adopting Google Sheets in very easy.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
I'm not involved with the purchase, but I assume everything goes smoothly and that the pricing structure is predictable and reasonable. We do not get surprise fees.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Google Sheets works very well with multiple users. It's convenient to see in real-time who is collaborating in a sheet, down to the specific cell that they're viewing/editing. Linking Sheets across departments is convenient with the IMPORTRANGE function.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Don't need to pay for windows 365 license as it is free
Has a positive impact since I am not cursing excel for annoying problems(I don't want the new Pivot table format, I want to use Classic and I don't want to expand/collapse arrows. "x$#%")
[Haven't] looked at return on investment on work, but has "simplified" for basic and medium spreadsheets.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
