presentation overview
Download
Skip this Video
Download Presentation
Presentation Overview

Loading in 2 Seconds...

play fullscreen
1 / 14

Presentation Overview - PowerPoint PPT Presentation


  • 152 Views
  • Uploaded on

Presentation Overview. Background Accessing Retail Data Warehouse Using ACL Accessing ODBC Accounting Package Using ACL Accessing AS400 Using ACL Accessing Unformatted Retail Receivables Sequential file Using ACL. Audit Software Customers. Store Audit Wholesale Audit Financial Audit

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Presentation Overview' - braith


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
presentation overview
Presentation Overview
  • Background
  • Accessing Retail Data Warehouse Using ACL
  • Accessing ODBC Accounting Package Using ACL
  • Accessing AS400 Using ACL
  • Accessing Unformatted Retail Receivables Sequential file Using ACL
audit software customers
Audit Software Customers
  • Store Audit
  • Wholesale Audit
  • Financial Audit
  • Third Party Audit (Financial Statements, Benefits, Insurance)
  • Government (State Tax, EPA, IRS)
  • Management or Audit Risk Monitoring
audit tests using acl
Audit Tests using ACL
  • Footing
  • Recalculation
  • Sampling
  • Matching
  • Stratification
  • Benford
  • Ageing
audit risk objective
Audit/Risk Objective
  • Error
  • Fraud
  • Misstatement
  • Completeness
  • Accuracy
  • Validity
data source
Data Source
  • Server
  • Midrange
  • GEAC Databases (Payables, Ledger, Assets, Receivables)
  • JDE Databases (Shipments, Receivings, Inventory)
  • Data Warehouse
tools
Tools
  • Browsers
  • Cubes
  • Access Databases
  • Excel Spreadsheets
  • ACL
  • AS400 Query
support
Support
  • Financial and Accounting Systems Analysts
  • Information Systems Staff
  • Accounting Staff
  • ACL Help Desk
data verification
Data Verification
  • Financial Statements
  • Monthly Reports
  • Cycle Reports of Payments and Receipts
  • Edit or Exception Reports
  • Data Verification Report
server data access
Server Data Access
  • Financial Package ODBC Databases
  • Data Warehouse Extracts – Access Database
  • Confidential, Sensitive Files- Access ODBC
  • Retail Data Extracts – Sequential Text
retail sales data warehouse data extracts
Retail Sales Data Warehouse Data Extracts
  • Piggy Back on Retail Cubes
  • Pick Up and Store Data Monthly
  • Used by Store Audit, 3RD Party Audit, Loss Prevention
  • Detail and Header Files can be Merged to Add Register and Employee ID
  • Monthly Statement Reconciliation by Location
  • Store large amounts of data on a monthly basis
accounts payable most popular
Accounts Payable Most Popular
  • Views Developed by IS and used by Audit and AP
  • Security Set Up by IS
  • Used by Store Audit, Wholesale Audit, 3RD Party Audit, IRS, Fraud
  • Cyclical Report Verification
  • Software Executed by Internal Audit
  • Distributed via EXCEL Spreadsheets
  • Classify, Stratify, Age, Benford, Sample, Foot, Recalculate
midrange applications
MidRange Applications
  • JD Edwards AS400 Applications
  • Query Software (World Writers) Developed by Information Systems Analysts
  • Query Executed to Download Data to Server by Internal Audit.
  • Used by Wholesale Audit, 3rd Party Audit
  • Cyclical Report Verification, or Accept by Faith
  • Distributed via Excel Spreadsheets
  • Classify, Stratify, Age, Sample, Foot, Recalculate
extract retail accounts receivable
Extract Retail Accounts Receivable
  • Retail System is Server Application converted from minicomputer.
  • Internal Audit Executes Batch Files and Programs developed by Information Systems
  • Basic Ansi Text files transferred between servers.
  • More formatting of the files is required.
ad