Moving Beyond Spreadsheets

Spreadsheets, originally designed for financial modelling and budgeting, have been increasingly used for data analytics within auditing. However, best practices of internal auditing and fraud detection have matured and therefore reliance on spreadsheets has decreased in favour of more reliable and sophisticated tools. Investment required for spreadsheets is low, however this can be deceptive; errors, record input limitations and slow speed of analysis can represent hidden costs.

Alternatives to spreadsheeets should be considered for data analysis because of the below:

The lack of data integrity that spreadsheets offer

Data can be altered easily once it is entered into the spreadsheet, sometimes accidently and other times maliciously. formulas across the spreadsheet in addition can lead to data errors.

Slow data analysis

The record limitations in spreadsheets mean that analysing billions of columns of data is a lengthy process. Data comes in many forms and merging data across spreadsheets is not a simple process. Manual errors may also be encountered.

No security, non-compliance

There is no proper way to track the modifications and changes to spreadsheets, As they get emailed along, duplicate copies can be made, each with their own modification.

Audit purpose solutions have built in tools to ensure the audit process runs more smoothly. These include:

Reliable and accurate data

Access data from any source, while the source data remains protected and therefore unchanged.

Quick analysis

Algorithms exist to readily perform tasks such as Pivot Tables, Benford’s Law, join and relate data bases and many more.

Security and Compliance

A trail of all audit functions performed can be logged, making it easier to share processes with the audit team.

CaseWare Analytics Inc Copyright © 2014


Data Analytics Technology

Big data analytics has the power to predict the weather forecast, manage your workforce and even battle Parkinson’s disease.

Data advances are everywhere. It can help your organisation increase revenue and find out more about what your customers really want.  When data is analysed by the right people using the right technology it can be a powerful tool and it can even motivate your employees. Almost a third of workers admit that they would be happy for employers to access personal data, such as their social media profiles, to be better motivated at work. This will in turn increase employee performance and retention. Employers can further use this data to spot retention and performance issues and over half of HR professionals said that they were preparing for this shift.

An increase in data is not only changing the workplace, it is also changing the accuracy of information available, like weather forecasts. Years ago, the weather was calculated by monitoring cloud patterns and astrology. Now, thanks to massive amounts of data and advanced computers it is significantly more accurate. But it is about to become more accurate still – hyper-local real time weather forecasting is just around the corner. Part of the reason weather forecasts are becoming more accurate is the data and variables that can be entered into the predictions.

Big data analytics can even be used to treat Parkinson’s disease. Data collected from hundreds of patients will be used to analyse symptoms of the illness such as sleep quality, slowness of movement and tremor. The findings will be used for drug development, diagnosis and treatment.

While big data analytics is a powerful tool, the right people and technology are still needed to unlock it’s full potential. High volumes of data make accessing results and information in real time a challenge, which is where data analytics software can benefit any organisation. By eliminating the lengthy time process of drawing up the different data and conducting further analysis, computer assisted audit tools (CAATs) allow you to focus on the import part of data analysis – reviewing and reporting the results.

Visit our website for more information




Continuous Monitoring

In the current economic climate, the efficient monitoring of internal controls is essential to provide correct, timely financial information and minimise losses.

The benefits of continuous monitoring:
for audit:
  • reduce costs
  • monitor controls centrally
  • increase effectiveness and efficiency
  • detect early signs of fraud
for finance:
  • identify event before it’s too late
  • reduce loss of revenue
  • increase compliance
for IT:
  • monitor multiple systems centrally
  • early notification of system breaches
  • unlock information in system logs
CaseWare Monitor is our continuous monitoring software solution that provides security, reliability, flexibility and early detection to prevent fraud, enhance efficiency and improve compliance.
Take a more detailed look at CaseWare Monitor and how it can help you achieve better internal controls
Audit Technology

SAP® and data analysis

SAP® is used by roughly 92,000 companies worldwide. However, users of the software face a number of special challenges when attempting to analyse SAP® data outside the SAP® environment.

SAP® data can be tricky to work with and can be only compatible with certified software. Alike any data, SAP® data is still full of its errors and mistakes and needs preparing before data analysis.

Some of the challenges that our clients face getting access to their SAP® data include: it is a time consuming data extraction processes, dependant on IT, has complicated data structures and processes, using SAP® features requires in depth technical knowledge, users do not have direct access to SAP®, users do not have the necessary access privileges, having 50 000+ tables makes it difficult to know what to extract, access to SAP® transactions such as SE16 are restricted and you have great dependency on SAP® or IT administrators and their workload.

What would be the solution? In need of a smart and effective way to export SAP® data? The answer… SmartExporter

SmartExporter makes your work easy: Using complex and time-consuming SAP® features a thing of the past. Once the RFC module is installed and user privileges are set up, exporting the required data is extremely easy. In little time, the SAP® data you actually need for your analysis is available in any specified directory.

With SmartExporter you can download what you want, when you need it, it is a simple PC based Windows® application, that is approved by SAP® administrators and certified by SAP®. A benefit of SmartExporter is that you can perform direct and independent extraction of SAP® data and users do not have to be SAP® experts due to its simplicity. Data requests are created on the user’s PC in a familiar environment, the user can connect directly to the SAP® system or work offline all whilst tasking advantage of its simple workflow system which optimises the selection of SAP® data and its security, transparency and traceability.

If you would like to find out more about SmartExporter, the new version, request a demonstration or find out how it can benefit your business, please get in contact with us.

Audit Technology

First ever online marketplace for audit tests

Smart Analyzer Marketplace

The Marketplace, created by our partner Audicon, provides audit apps and other solutions for Smart Analyzer ready for use within IDEA.

These apps can be loaded directly from the Marketplace into IDEA and have been designed to help satisfy your audit objectives. Apps are the perfect supplement to help convert your IDEA software into a more comprehensive business tool.

You can browse through the Marketplace any time you may want to optimise your daily work with IDEA. With our clients providing valuable feedback as to their changing business issues, Audicon’s development team are continuously developing a range or public and private apps to help satisfy a broad range of data analysis needs.

There are numerous Apps which are currently available on the Marketplace. These Apps offer complete solutions orientated around business process, business and management topics and standard Import Routines for numerous ERP systems. These import routines are helping our clients to import and prepare data in a single step and to create meaningful reports.

When visiting the Marketplace from within Smart Analyzer, you will see an overview of all new apps, top sellers and a news feed containing latest developments. When searching you can use filters or the search feature to look for an app that suits your analysis needs.

Each App has information on its overall content which can be found in the Details pages. You can find a description of the app as well as specific items contained, such as each audit test it can perform.

For more information on Smart Analyzer feel free to view its brochure. For any further information on The Marketplace function or if you would like to purchase any Apps off the Marketplace then please contact us.

You can also view a promotional video for the marketplace here: http://www.auditware.co.uk/news/24/The-Marketplace-for-audit-tests