This function is used to create relational databases on key fields. An example would be sorting a file on social security number to see if any blank or "999999999" numbers exist.Ĭombines specified fields from two different files into a single file using key fields. Sorts a file in ascending or descending order. For example, identify any gaps in check sequence.
Identifies gaps within a specified field in a file. Examples include extracting all balances over a predefined limit. An example would be to export customer address information to Word for "Mail Merge"ing to customer confirmation letters.Įxtracts specified items from one file and copies them to another file, normally using an "if" or "where" statement. For example, this report could be used to identify duplicate billings if invoices within the sales file.Ĭreates a file in another software format (e.g., Excel, Word) for testing. Identifies duplicate items within a specified field in a file. By cross-tabulating character fields, you can produce various summaries, explore areas of interest, and accumulate numeric fields.Ĭompletes digital analysis tests (i.e., Benford’s Law). For example, the net payroll pay to an employee could be recalculated using the gross pay field and deducting any withholding/taxes.Ĭross Tabulate lets you analyze character fields by setting them in rows and columns. Maintains a documentation log of all procedures performed on a data file.Ĭreated a calculated field (which can use a function such as ABS for the absolute value of the field) using data within the file. An example would be to merge two years worth of accounts payable history into one file. for an even more powerful CAATs software.ĪctiveData For Excel CAATs software vs ACL and IDEA Analysis TypeĬombines two files with identical fields into a single file. Need more power ? Check out ActiveData for Office / SQL. DOWNLOADyour fully functional 30 day copy today. Kepczyk, CPA, The CPA Technology AdvisorĪctiveData for Excel is built right into Excel so your can get up and running quickly.ĪctiveData for Excel contains all of the important features of ACL and IDEA at less than 15% of their price so you can get your whole team on board. making this an attractive competitive product that firms will actually use."
tools such as ACL and CaseWare IDEA have long been utilized, but an application called ActiveData brings many of their high-end capabilities to an Excel platform for a fraction of the cost. Want to try and see what CAATs software can do for you?įREE DOWNLOAD- Fraud Detection with ActiveData for Excel Caats software E-Book and Sample data a $99.00 Value.įREE DOWNLOADfully functional 30 day copy of ActiveData for Excel
#ACL AUDIT SOFTWARE DOWNLOAD LICENSE#
You can likely outfit your entire audit department with CAATs software for less than the cost of a single license for ACL and IDEA.ĪctiveData For Excel adds over 100 time savings analysis and worksheet manipulation features to Microsoft Excel to improve your CAATs software capablities. ActiveData for Excel, the original Excel based CAATs software provides the best value for money of any CAATs tool on the market. Over the last 7 years ActiveData for Excel has been implemented by thousands of users around the world.
0 kommentar(er)
