Sivukartta

Edellinen sivu	Seuraava sivu	Päävalikko


Sisäinen valvonta & riskienhallinta
Sisäinen valvonta
	Yleistä: Määritelmiä; riskienhallinta: COSO-ERM;
	"Tehtävänä valvonta": Lataus (versiot 4 ja 3); Mitä uutta versiossa 4
	Yleistä sisäisen valvonnan arviointi- ja vahvistuslausumasta; Lausumat 2005: Kokoaminen ja käsittely analyysia varten; Analyysi; Johtopäätökset;
Sisäinen tarkastus
	Yleistä: Määritelmä; Sisäisen tarkastuksen ohjesääntö; Sisäisen tarkastuksen toimintasuunnittelma; Sisäisen tarkastustyön luonne; Tarkastusprojektin suunnittelu; Tarkastustyö; Raportointi; Jälkiseuranta;
	Erityiskysymyksiä: Tarkastuksen työpaperit ja Esimerkki niistä; Tarkastusraportti; Suositusten seuranta;

Internal control
The ECAR Model
	Description of the Model: Concepts; The Model: Objectives and Elements of Internal Control: Objectives and Opportunities; Compliance [with norms]; Right Information; Control Environment; Controls; Accounting systems; Determination of risks Design of Internal Control; Tips; An Example - A Procurement Process; Detailed Control Objectives; Realization Of Internal Control Structure; Special Issues; Differences With The COSO Models; Internal Control Vs. Risk Management;
	The ECAR document download: Download; Downloaders Nov/09/2007; Downloaders May/09/2008; Downloaders Nov/09/2008
ECAR Tools
	Internal Control Questionaire #1: Introduction; Control environment; Controls; Accounting systems; Determination of risks; Control objectives; Background information
	Internal Control Questionaire #2: Introduction; Control Objectives and Elements: Control Environment; Controls; Accounting Systems; Determination of Risks; Background information
	Audit Findings Analysis: Findings Classification Scheme; Findings Classification; Pivot Table of Audit Findings;
	Internal Control in Audit Process of Financial Statements: Audit's Strategic Planning; Audit's Operative Planning;

CAATsScripts
IDEA
	Brief introduction
	Good to remember in use of IDEA: Determine what needs to be audited; Determine whether IDEA is appropriate in achieving audit objectives; Determine what data to request; Request the data; Save and check the file(s) delivered; Create a file management policy; Import data; Check the integrity of the data; Fix improper data files; Plan how to use Commands and Functions; Use IDEA commands, functions and tools; Review the results; Don't forget house-keeping;
	Miscellaneous Macros: Cromm macro: Its history; How it works; Its versions; Running it; Examples on its use; Its download; Problems in running it; Buying it; File/Field Selection Macros: File Selection Macro; Field Selection Macro; Field Examining Macro; Text search macros: Text Search Macro; Text Search Macro, 2:nd version; Text search macro 'SEM3': Functionality; Running it; Importing [SEM3] csv file; Demo download; File renaming macros: File renaming macro; File renaming macro, 2nd version; File renaming macro, 3rd version; [Raw] Data Manipulaton Macros: Macro for uppercase / lowercase change; Macro removing lines from a (raw) text file; Macro removing/keeping certain lines of a (raw) text file;
	Miscellaneous tips: CAATs in Inquires; Comparing fields in successive records; Time recording system; File Examination Tips; Conversion tables; Risk based Sampling; Entry Analysis; Entry Analysis Example; Joining fields with same body but different lenghts; Print files: Copy and Paste Files; Print File Import; Regexpr; A File for Analysis; File Integrity Check; An Analysis;
	CCAS: Planning: What is a Continuous Auditing System; Purpose, Objectives and Approach; The plan; Naming Conventions; Scripting Approach; Tools: Virtues of IDEA in Building a CCAS; Functions, sub routines etc.: The Log (1); The Log (2); File Existence Check; A macro that calls other macros;
Excel
	Macros: Making a macro; Footer & Header Macro: Key strokes & Variables; Input Form; Code #1; Code #2; Code #3;
	Set of Macros for Audit: ExcAud: [containing] Text File Import Macros: Macro #1; Macro #2; Macro #3 (FixImp1); Macro #4 (ImpAny1); String Pivot Table Macro (StrPiv1): Running the Macro; Download; Text Editing Macros: #1 (TexEdi1): Examine a Text File; Change Text Lines to same [Fixed] Length; Remove empty Lines; Replace Character(s); Remove Carrige Return (CR); Append lower Line(s) to upper One; Add CR to a Text File (lacking it); Remove Thousands Separator from Numbers; Change to Uppercase or to Lowercase; Table Join Macros: Join Tables Macro #1 (JoiTab1); Join Tables Macro #2 (JoiTab2); Gap and Dupligate Detection Macros: Macro #1 (GapDup1); Summarization in Excel: Summarization Formulas and Functions; Subtotals and Totals; Pivot Tables;
	Excel file edit macros: Macro copying/appending Tables (AppTab1); Macro removing spaces (RemSpa1); Macro copying and pasting equations (RemSpa1);
	Miscalleneous macros: File Name Macros: Macro listing File Names (FilNam1); File renaming macro (ReNam1); Macro listing File Names also in Subfolders version 1 (FilLis1); version 2 (FilLis2); version 3 (FilLis3);
Suomeksi
	Tietokoneavusteiset tarkastustekniikat: Yleistä; Tekniikat; Tarkastusohjelmistot: hyödyt;
	IDEA 2004 esittely: Tuonti; Tiedostojen ja asiakkaiden hallinta; Tiedostojen tilastotiedot; Historia; Poiminta; @Funktiot; Yhdistäminen; Peräkkäisyhdistäminen; Vertailu; Kaksoiskappaleet; Sarja-aukot; Lajittelu; Kaaviot; Osittaminen; Summaus; Ikäanalyysi; Otanta; Kenttien lisääminen; Pivot-taulukot; Benfordin lakiin perustuva analyysi; Tehtävälista; Erityisajo-mahdollisuudet); Vienti; IDEAScript

For sale / Myytävänä
	Macros (Excel); The ECAR Document; Tehtävänä valvonta

Info, haku, linkit
	Legal notice
	Näistä sivuista: Ylläpitäjä; Sivujen päivitys; Site map (Sivukartta) = This page (Tämä sivu); Erityisosio;
	Google;

Pääsivulle (Return to Main Page)