TOPCAATS

Advanced computer auditing made easy

WHAT IS TOPCAATS?

A collection of over 130 powerful data analysis tools

Specifically designed for Auditors and Accountants.

Runs on top of the familiar Excel environment

Designed with ease of use at it’s core

Suitable for Auditors of all IT skill levels

Minimal training requirements

The TopCAATs ribbon bar in Excel 2007

BENEFITS

TopCAATs brings many benefits to Auditors and accountants including:

Creating opportunities to provide new services

Adding value to the work you do

Saving time by increasing efficiency and effectiveness

Reducing risk exposure

SAVE TIME

TopCAATs saves time by increasing the efficiency and effectiveness of your audit teams

Replace manual audit procedures with automated ones

Reduce time spent on repetitive tasks

Allow Auditors more time to focus on risky and subjective areas

Reduce audit duration and costs

Increase auditor morale through more fulfilling work

REDUCE RISK

TopCAATs reduces risk exposure

In many cases you can test 100% of a population, rather than a small sample

This eliminates the associated sampling risk

Where sampling is unavoidable, you can use TopCAATs statistical sampling routines (MUS)

– Extract more appropriate samples

– Evaluate the effect of any differences on the rest of the population

Likelihood of user error is also significantly reduced

ADD VALUE

TopCAATs adds value to the work you do

Obtain much deeper insights into the records audited

Potentially identify every error and controls weakness

Use your findings to recover cash paid or not reclaimed in error

Address controls weaknesses to prevent future loss through fraud or error

CREATE OPPORTUNITIES

TopCAATs creates opportunities

Tools available allow you to perform new services for your clients or organisation, e.g. a detailed payables review

Using the tools enables you to identify new issues that may need to be resolved

You are able to demonstrate your deep knowledge about the records reviewed and issues found

This enables you to offer additional support to close controls weaknesses or correct issues

WHY TOPCAATS IS DIFFERENT

Put simply, ease of use

Ease of use is a core principle of TopCAATs

Designed from the ground up to be as intuitive as possible

Designed to be used by every Auditor, not just specialists

Works within the familiar Excel interface

This means your team is up and running much more quickly

They need much less training, so implementation costs are lower

Most users find our free self-study course to be sufficient

TopCAATs is always available in Excel so it gets used constantly

Users remember their training better due to regular practice

TOPCAATS vs. IDEA & ACL

TopCAATs IDEA / ACL

Designed for Everyday audit Specialists

Data analysis functionality High High

Ease of use Easy Difficult

Training requirements Minimal Extensive

Daily productivity tools Included Not included

Data types Excel / CSV / TXT / TSV / DBASE Various

Data restrictions Excel 2007 1.1m rowsExcel 2003 65k rows Unlimited

TOOLS AND FEATURES

TopCAATs includes over 130 tools, split into the following broad groups:

Data analysis

The core TopCAATs tools that allow you to test in many different ways, including Benford’s testing, summarisation, gaps, duplicates, outliers and many more…

Sampling

4 sampling routines including Monetary Unit Sampling (MUS) and random sampling

Section modules

Revolutionary account-area focussed modules that allow you to perform up to 17 tests at once on a single report

The TopCAATs toolbar

Data cleansing and excel productivity tools to make day-to-day working in excel easier and more efficient

Engagement setup

Store engagement details for recall and produce lead schedules

Plus, context-sensitive help, a comprehensive user manual and forum access

THE TOPCAATS TOOLBAR

Convert Formulas to Values

Remove Spaces, Letters, Numbers, Symbols, Etc.

Formatting Cells

Inserting Ticks & Crosses

Merge, Wrap & Autofit

Combine/Split Debit/Credit Columns

Fill Cells

Fix Unrecognised Dates

Global Find & Replace

Reverse Polarity

Swap Delimiters(for European Reports)

Move Minus to Front

Extract Visible Cells

Insert Headers and Footers

Check Worksheet for Common Errors

The TopCAATs Toolbar includes a variety of tools to make day-to-day life in Excel easier and assist with importing and cleaning data

ENGAGEMENT DETAILS

Store common information about the projects and

engagements you’re working on

No need to keep entering the same info again and again

Colour coded inputs throughout TopCAATs help guide the user Red fields are required Orange fields are optional Green fields contain valid data

LEAD SCHEDULER

Create a set of Lead Schedules for the front of each file section from a Trial BalanceComplete with year on year comparison

SAMPLING TOOLSTopCAATs includes a wide variety of sampling tools including Stratified Sampling Monetary Unit Sampling Random Sampling Systematic Sampling

SECTION MODULESPerform up to 17 different tests on a single data file in seconds!

7 separate modules Trade payables (×2) Trade receivables (×2) Inventory Non-current assets Journals / GL postings

Analysis includes: Duplicate items Missing items Week day analysis Specific date analysis Comment analyisis Time analysis Summarisation Number analysis …and many more

JOIN WORKSHEETS TOGETHER

1000s of uses, for example: Join an Inventory Listing with Sales

records for NRV Testing Identify fraudulent vendors by

joining Employee and Vendor master-files

Import data from different sources/reports

Compare data from different systems

Identify new or missing accounts compared to a prior period

DATA SUMMARISATION

Produce detailed and complex summaries of your data quickly and easily from a few simple input options

HIGHLIGHT CHANGES

Compare two versions of a report and instantly see the changes highlighted and cells annotated with details of the difference

BENFORD’S TESTING

Test the 1st, 2nd, 3rd and 1st two digits, and carry out significance analysis. Results are presented both in a table and graphically

MISSING OR DUPLICATE DATA

Use the Gaps tool to find missing journals, missing cheques. It can handle any mask and can even increment letters!

Identify duplicate payments or invoices with the TopCAATs Duplicates Tool

AND MANY MORE…

TopCAATs includes a wide variety of other tools, including Aging, Exception Reporting, Analytical Reviews, Identifying Round Numbers, Outlying Amounts, and more.

IN-BUILT AUDIT TRAILS

The TopCAATs tools store an audit trail detailing thetesting that was carried out.

This is either in the form of a summary sheet, or as a comment in cell A1 of theoutput.

The audit trail comments can easily be converted into a printable header at the click of a button

The 7 Section Modules even capture a screenshot of the input form at runtime and embed it in the summary sheet,so you can see exactly what options were specified

COMPREHENSIVE HELP

TopCAATs has been designed to be as simple to use as possible, but if you need a hand there’s plenty of help available.

Each tool has it’s own help within Excel and there’s a comprehensive PDF user guide, complete with screenshots.

There are also video demonstrations available for each tool on the TopCAATs website

TRIALLING TOPCAATS

We offer a 30-day trial so that you can find out for yourself whether TopCAATs is right for you and your team

Completely FREE for the trial period

Absolutely no obligation to buy when trial expires

Fully functional for 30 days, no restrictions on functionality or file size

As many trialists as you would like to involve

Request your trial online and download at:

– Single users: www.topcaats.com/start-my-trial

– Multiple users: www.topcaats.com/start-our-trial

TRAINING

The training requirement for TopCAATs is far lower than other CAATs products due to its intuitiveness and ease-of-use. However we offer various training options:

Introductory self-study training – free to trialists

Self-study training course – free to customers

Other self-study resources – free to customers

Custom training – additional cost, tailored to your needs

– Web-delivered through online webinar tools

– Delivered in person at your location or elsewhere

We recommend you use your free 30-day trial period to determine what training your users are likely to need

CUSTOMISATION

TopCAATs can be customised to meet your needs, for example:

Changing terminology used to fit with your audit approach

Changing calculation methods

Adding new tools

Duplicating tools you already use on another platform

Removing tools or modifying the TopCAATs ribbon

Rebranding TopCAATs for your organisation

We’ll be very happy to discuss your needs and provide a quotation

LICENSING

TopCAATs is licensed on an subscription basis, which has several advantages for you: No large upfront cost – you can match your investment with the benefits it delivers Regular, predictable payments – no guessing when the next upgrade fee will be needed, or how

much it will be No hidden costs for support or upgrades It drives us to keep you happy so that you continue your subscription

To meet the needs of both larger and smaller audit departments, we have two pricing models:

Users Monthly cost per user Annual cost per user

1 User US$ 79 US$ 790

2-9 Users US$ 74 US$ 740

10-24 Users US$ 69 US$ 690

Please contact us if you require more than 25 individual licenses

Individual User Licenses – pay monthly from just $69 / user / month, or pay annually and get 12 months for the price of 10

Site Licenses – paid annually in advance and cost from just $13.33 / user / month

Licenses Annual Cost Per user per month

Up to 20 US $8,000 $33.33

Up to 50 US$16,000 $26.67

Up to 100 US$ 28,000 $23.33

Up to 250 US $60,000 $20.00

Up to 500 US $100,000 $16.67

Up to 1,000 US $160,000 $13.33

Please contact us if you require more than 1,000 licenses

TESTIMONIALSWe have reduced the time the audit team are on-site at the clients offices and the time to

finalise the accounts back in our office by 15%. As an engagement partner, where it used to take a week to review an audit file, it

now takes only 1-2 days

Was TopCAATs a valuable

investment? It paid for itself in the first

test we did!We used to manually agree receipts with the physical documentations which took many hours just to cover the significant

items. Now, we get the files electronically and use the TopCAATs “Join 2 Sheets” tool and we can match 100% of deposits with

the debtor accounts in 20 minutes

TopCAATs is one of the easiest software packages out there and

the video demonstrations are very good. Whenever I’ve needed

help, the service I’ve received has been excellent – always very

helpful

The ability to perform additional testing, such as Gaps and

Duplicates adds value to our audits, and we have found

numerous potential irregularities to report to our clients

All the TopCAATs tools are very easy to apply and use

TopCAATs allows us to recalculate depreciation on

100% of a clients non current assets, regardless of

the number of assets – a task that was previously

impossible

TopCAATs has certainly been a

benefit to our audit department,

and this is backed up by

great customer support

I find TopCAATs an incredibly valuable product. It has

dramatically improved my efficiency, particularly when it comes to data manipulation – often saving 50% of the time I

would usually spend doing a task

The robust testing procedures and easy to read reports improve the quality of my audits

Last year we failed to meet the reporting

deadline, but with the deployment of TopCAATs this year, we have been

able to meet that deadline and I am proud of the quality of our work

Previously I used IDEA, but to become an expert needs much time and training. After 3 years of using IDEA I realized that the

majority of testing is done in spreadsheet applications, and

nowadays all accounting software allows information to be exported to spreadsheets

TopCAATs has also found an inventory error

that turned a client’s profit into a loss

With TopCAATs, our auditors are not

wasting time conducting the

samples and have more time to analyse

the results

…don’t just take our word for it!

CONTACT US

Charlie WalkerManaging Director

Stefan DavisDirector

Richard WardDirector

For more information, visit

www.topcaats.comE-mail us at enquiries@reinventdata.com