L Automatically generate a complete history that documents the analysis. L Create pivot tables for multi-dimensional analysis. L Select samples using several sampling techniques. L Perform analyses of data, including calculation of comprehensivestatistics, gap detection, duplicate detection, summaries, and aging. L Create custom views of data and reports. L Import data from a wide range of file types. This versatile tool is useful for any type of fileinterrogation and allows users to: IDEA OverviewIDEA combines considerable analysis power with an extremely user-friendlyWindows environment. Send your documentation-relatedcomments to 2 You may also visit the CaseWareAnalytics website at for additionalinformation such as tips and hints, frequently asked questions (FAQs), andtechnical information.įeedback Your feedback is important to us. In order to view the online help, you requireMicrosoft Internet Explorer 9.0 or higher. There is extensive online help available for all modules, including step-by-step walk-throughs of tasks. In addition, the images used throughout thistutorial may not necessarily reflect what you see on your screen dependingon the edition of IDEA you are using. Throughout the tutorial, the above products are referred to solely as IDEAunless otherwise specified. This tutorial covers the functionality of IDEA and IDEA Server. IDEA extends your reach byproviding unique functions and features not found in generic software. IDEA (originally an acronym for Interactive Data Extraction and Analysis)provides auditors, accountants, and systems and financial professionalswith the ability to display, read, analyze, manipulate, sample, and extractdata from data files from almost any source - mainframe to personalcomputers, including reports printed to a file. IntroductionWelcome to the IDEA Tutorial. Performing a Record Extraction Using an 57 Identifying Gaps in an Invoice Number Sequence 54 Using a Treemap to Visualize your Data 34 The Association Between Desktop and IDEA Server Projects 10Ĭlearing Information in a Field Statistic Panel 33 IDEA is a registered trademark of CaseWare International Inc.
CASEWARE IDEA CHANGE A CHARACTER TO A DATE SOFTWARE
is a subsidiary of CaseWare International Inc.,the world leader in business-intelligence software for auditors, accountants, and systems and financialprofessionals (IDEA is distributed under an exclusive license by:CaseWare IDEA Inc.469 King Street West, 2nd FloorToronto, CANADAM5V 1K4
is a privately held software development and marketing company, with offices inToronto and Ottawa, Canada, related companies in The Netherlands and China, and CaseWare AnalyticsPartners serving over 90 countries. No part of this publication may bereproduced, transmitted, transcribed, stored in any retrieval system or translated into any language in anyform by any means without the permission of CaseWare IDEA Inc.ĬaseWare IDEA Inc. Note: The year end date should bechanged in the Company Profile to the required date prior to the processing of the year end close in the file.Copyright 2015 (v10.0) CaseWare IDEA Inc.
To change the year end date, click File | Company Profile | Dates tab and select the new date. Any entries in that date range are considered to be future transactions and they remain in the file. When a client moves the year end backward, e.g., from January 2010 to December 2009, the period(s) between the new year end and the old year end are excluded from the Company Profile. In this example, January 2009 is no longer the period 1 in the Company Profile, but transactions dated in that month are saved in the file as needed.
Data for any dates that are excluded due to the change will still be in the file. When a client moves the year end forward, e.g., from December 2009 to January 2010, the periods change in the Company Profile. It is possible to change the year end date in the middle of a financial year, if necessary, however the aging on your existing reports will be affected.