| Tools
With over 100 functions, there's something in TopCAATs for everyone. Below is a brief overview of the tools, click on the tool name for a video demonstration of the tool, or see the the user guide for a more detailed description, which can be downloaded from here To view a demonstration of all the TopCAATs tools, please click here TopCAATs ribbon in Excel 2007 In Excel 2007 all the tools appear on the TopCAATs ribbon bar, rather than on the toolbar and menu, as in Excel 2003 
This is a toolbar that provides quick access to a number of tools designed to speed up daily Excel usage Wrap text - Toggles wrap text on/off for the current selection Merge, wrap and autofit - Merges the selected cells, wraps the text and autofits the cells to the appropriate height. When the built in excel function “Merge and Centre” is used, it is unable to auto fit the row height to ensure that all the data is visible, TopCAATs solves this Header and footer - Inserts a standard header and footer into the worksheet. Uses information stored in Engagement Details Comment to header - Many of the tools store details about the options selected, source data, etc. as a comment in cell A1 (an audit trail). This button converts this comment into a document header, incorporating stored information from Engagement Details Extract visible cells - Extracts all the visible cells on the sheet to a new sheet Tick/Cross - Inserts a "tick" or "cross" symbol into a cell using the included tick font (avoids having to use “Insert symbol”) Insert borders - A variety of border options for your cells Number - custom number format can be set in Options Date - custom date format can be set in Options Currency - custom currency format can be set in Options Reverse polarity - Converts positive numbers to negative and vice versa Swap delimiters - Converts numbers in the format “12.345,67” to “12,345.67” so Excel can recognize them as numbers Move minus sign from back to front - This tool moves the minus sign in numbers that are displayed as “9,652.23-” from the back to the front, so Excel can recognise them as numbers (e.g. “-9,652.23”) Convert to values - This converts any formulas in the current selection to their values Engagement setup Engagement Details - Stores information about your current engagement, so you don’t have to keep entering the same information in each tool Lead Scheduler - Produces a set of lead schedules for the audit file Sampling Monetary Unit Sampling - Estimate, Extract and Evaluate a statistically selected sample from a population Stratification - Split data into bands containing ranges of values Random Sampling - Extract a number of randomly sampled items Data analysis tools Join Sheets - Joins two sheets together, based on a common matching column Aging - Re-age a listing based on a variety of aging options, including custom aging bands Quick summary - Quickly and simply summarise your data, based on criteria you specify Ledger split - Splits a report into several worksheets (e.g. split an inventory listing into a separate listing for each warehouse) Column statistics - Get a detailed report of the data in each of your columns Highlight Changes - Highlights any differences between 2 versions of a worksheet or workbook Benford's Analysis - Perform Benford's Digit Analysis testing to identify unusual patterns in data Exception report - Extracts any records that meet the criteria you specify (up to 3 criteria) Outliers - Extract records where the amount significantly deviates from the mean Top and Bottom - Extracts the top and bottom records from a list Gap detection - Look for gaps in a sequence (e.g. missing invoice or journal numbers) Duplicate extraction - Extract duplicate records, based on the fields you specify Same, Same, Different - Extract records where 2 fields are the same and a 3rd is different (e.g. same amount, same date, different vendor) Specific Comments - Searches a worksheet or range for specific comments (e.g. “suspense”, “rainy day”, “unknown”, etc.) Out of mask - Extract records where a field does not match a pre-defined mask (e.g. bank account numbers/sort codes, National Insurance numbers, etc.) Round Number Extraction - Extracts any records which have a rounded amount Options - Allows you to specify global options for TopCAATs Multi Drill Down - Allows you to perform a Drill to Data on multiple cells in a pivot table at the same time (either exporting the results to separate sheets, or to a single sheet) Tick Font - A font consisting of a wide variety of ticks that can be used to mark your data. The font is globally available, so you can use it in other applications too Section modules TopCAATs includes 7 “Section Modules” each specifically targeted to an area of the accounts. Prepare Sheets - This prepares a worksheet for input into the section modules Non Current Asset Section Module
Inventory Listing Section Module
Trade Receivables Ledger Section Module
Trade Receivables Invoice Section Module
Trade Payables Ledger Section Module
Trade Payables Listing Section Module
General Ledger/Journal Listing Section Module
|
| ||||||||||||||||||
|
|
||||||||||||||||||||
