Not displaying correctly? View in Browser

Hi Guest,

Hello again!

In this edition:
  • Special Event: CaseWare IDEA Webinar 22 October 2019
  • Special Public Training Offer
  • Import General Ledger data from over 55 accounting packages
  • ValidateABN Custom Function
New Subscribers: 
If you've got colleagues that might want to receive this bi-monthly newsletter, get them to subscribe here:

Pauline Laidlaw
Manager, Analytics

Customer Support Service

Give our customer service team a call if you're confused or unsure about any CaseWare IDEA function or feature!

+61 3 9660 4688

Want the Global version of CaseWare IDEA News? 

Did you know that the Global IDEA team has a newsletter which shares the latest insights into IDEA? All you need to do is subscribe at this link.
[You will need to scroll to the very end of the page.]

Special Public Training Offer (valid until 30 November 2019)

Book 2 or more attendees on any remaining IDEA public online training course in 2019 and you will receive one hard copy of the NEW Analytics Guide for External Audit (RRP $375)**. Please see terms and conditions below. 



This publication not only provides the IDEA techniques needed to perform the suggested audit Analytics, but also detailed information of the relevance of each of the Data Analytics reports it refers to, and best practice advice on how to interpret the resultsWant to see a preview of this publication? Click here.

**Terms and Conditions: Two or more attendees must be registered on the same course. Only applies to IDEA Public online training courses in October and November 2019.

Our next public online CaseWare IDEA Level 1 course is coming up on 23 & 24 October - register NOW! We deliver our public courses online using GoToTraining as our online training platform. Please contact us on (03) 9660 4680 or via to discuss your training needs if you need training sooner!

To view all our current course dates and to register, click this link.

Webinar Special Event:

CaseWare IDEA: Software with Analytic Intelligence that thinks like an auditor 

Finding the real risks in your audit client's data can sometimes feel like trying to find a needle in a haystack. Discover how CaseWare IDEA’s Analytic Intelligence can reveal deeper insights automatically so you are better prepared to attack your audit in a more focused and strategic way. 

Join Pauline Laidlaw, our Manager - Analytics as she demonstrates how to:
  • Use the powerful Discover feature to identify trends and outliers
  • Generate graphs and dashboards with Visualisation
  • Instantly access new Insights with powerful statistics
  • Unlock more Visualizations
  • Connect to applications such as Power BI to interpret and reveal more insights
When: 22 October 2019
Time: 12:00pm - 1:00pm (AEDT)

This webinar is ideal if you haven't yet caught up with all the new features and functions of the last few updates to IDEA. 


Did you know that you can import General Ledger data from over 55 accounting packages into IDEA?

The latest update of IDEA 10.4.1 includes the CaseWare Accounting Package (CAP). This tool transforms the performance of your audit team by allowing you to obtain data from just about any accounting package and imports the General Ledger and Trial Balance tables directly into IDEA. Managing your client's data from multiple systems is quick, and the data is standardised. 

This means increased capacity to drive a better audit. 

Please note: This add-on is only compatible with IDEA 10.4.1
If you haven’t upgraded, please follow the instructions in Section 2 of the Installation Guide

Need assistance? Please contact our Customer Support team on (03) 9660 4688 or You will need to download the CaseWare Accounting Package optional component and the Cloud Import Utility. Both are available for download through Passport. Log in to Passport > Downloads > IDEA Import Components.

Have you used ValidateABN Custom Function?

Custom Functions are user defined functions that can be created by the user or there are some available to download from the Passport. One of these custom functions is #ValidateABN which verifies an Australian Business Number (ABN). If the ABN is valid, 1 (True) is returned. If the ABN is invalid, 0 (False) is returned. 

Syntax #ValidateABN(ABN )

Parameters ABN - The name of the Numeric field that contains the Australian Business Numbers

How to download Custom Functions from Passport

Custom Functions are available within CaseWare Passport. Passport can be accessed within IDEA or via your browser. You will need to Log In > Downloads Tab >IDEA Custom Functions. 

  1. Download the desired custom function from the Passport.
  2. From your Downloads folder, move the file (*.ideafunc) to the Custom Functions.ILB folder in the desired IDEA project. For example: C:Users[User Name]DocumentsMy IDEA DocumentsIDEA Projects[Project Name]Custom Functions.ILB (Alternatively, you can move this file to your Custom Functions folder within your Local Library.)