Accounting information systems

Cover
Accounting Information Systems
About the Authors
Preface
Main Features
Acknowledgments
Dedications
Brief Contents
Contents
Part One: AIS and the Business
	Chapter 1: Accounting Information Systems and Firm Value
		Introduction
		Accountants as Business Analysts
		Definition of Accounting Information Systems
			A Simple Information System
			Attributes of Useful Information
			Data versus Information
			Discretionary versus Mandatory Information
		Role of Accountants in Accounting Information Systems
			Specific Accounting Roles
			Certifications in Accounting Information Systems
		The Value Chain and Accounting Information Systems
		Ais and Internal Business Processes
		AIS and External Business Processes
			The Supply Chain
			Customer Relationship Management
		Ais, Firm Profitability, and Stock Prices
			AIS and Firm Profitability
			AIS and Stock Prices
		Summary
		Key Words
		Answers to Progress Checks
		Multiple Choice Questions
		Discussion Questions
		Problems
	Chapter 2: Accountants as Business Analysts
		Changing Roles of Accountants in Business
			IMA Competency Framework
			CGMA Competency Framework
			IFAC Accountant Roles
		Business Process Documentation
			Definitions
			Purposes of Documentation
			Value of Business Models
		Types of Business Models
		Activity Models
			Business Process Modeling Notation
			Basic Building Blocks for BPMN Diagrams
			Example of a Business Process Diagram
			Identifying Participants in Business Process Diagrams
			Messages in BPMN
			Extended Building Blocks for BPMN Diagrams and Modeling Concepts
			Subprocesses and Repeating Activities
			Data Objects, Datastores, and Associations
			Rules for Connecting Symbols with Sequence Flows and Message Flows
			Best Practices in Preparing BPMN Diagrams
		Summary
		Key Words
		Appendix A: Flowcharting
		Appendix B: Data Flow Diagrams
		Answers to Progress Checks
		Multiple Choice Questions
		Discussion Questions
		Problems
	Chapter 3: Data Modeling
		Structure Models
			Unified Modeling Language Class Diagrams
			Building Blocks for UML Class Diagrams
			Best Practices in Preparing Class Diagrams
		Uml Class Models for Relational Database Design
		Decision Requirements and Business Rules
			Business Rules and Decision Tables
		Summary
		Key Words
		Appendix A: Entity-Relationship Diagrams
		Answers to Progress Checks
		Multiple Choice Questions
		Discussion Questions
		Problems
	Chapter 4: Relational Databases and Enterprise Systems
		Introduction
			Definitions for Databases
		Fundamentals of Relational Databases
			Entities and Attributes
			Keys and Relationships
			Basic Requirements of Tables
		Using Microsoft Access to Implement a Relational Database
			Introduction to Microsoft Access
			Steve’s Stylin’ Sunglasses
			A Data Model and Attributes for Steve’s Stylin’ Sunglasses’ Sales Process
			Multiplicities in Steve’s Stylin’ Sunglasses’ Data Model
			Using Access to Implement a Simple Database for Steve’s Stylin’ Sunglasses
		Structured Query Language (SQL)
		Enterprise Systems
			Challenges of Enterprise System Implementation
			Enterprise Systems Computing in the Cloud
		Summary
		Key Words
		Answers to Progress Checks
		Appendix A: Creating a Form for Data Entry and Display
		Multiple Choice Questions
		Discussion Questions
		Problems
Part Two Business Processes
	Chapter 5: Sales and Collections Business Process
		Sales and Collection Process
		Sunset Graphics Example
			Company Overview
			Sunset Graphics’ Sales and Collection Process Description
		Sunset Graphics’ Activity Models
			Basic Sales Activity Model
			Refining the Model to Show Collaboration
			Refining the Model to Consider Exceptions
			Basic Internet Sales Activity Model
		Business Rules and Sunset Graphics’ Sales and Collection Process Controls
			Application Controls
		Sunset Graphics’ Structure Models
			UML Class Model for Quotes
			UML Class Model for Adding Orders
			UML Class Model for Adding Cash Receipts
			UML Class Model for Adding Categorical Information
			UML Class Model for Supporting Relational Database Planning
		Sunset Graphics’ Relational Database
			Relational Database Planning for Attributes
			Create the Database and Define Tables
			Set Relationships
		Comprehensive Exercise: Baer Belly Bikinis’ Sales to Retailers
		Summary
		Key Words
		Appendix A: Generic REA Model with Multiplicities for the Sales and Collection Process
		Answers to Progress Checks
		Multiple Choice Questions
		Discussion Questions
		Problems
	Chapter 6: Purchases and Payments Business Process
		Purchases and Payments Process
		Sunset Graphics Example
			Company Overview
			Sunset Graphics’ Purchases and Payments Process Description
		Sunset Graphics’ Activity Models
			Basic Purchases Activity Model
			Refining the Model to Show Collaboration
			Refining the Model for Credit Card Payments
		Business Rules and Sunset Graphics’ Purchases and Payments Process Controls
		Sunset Graphics’ Structure Models
			Basic UML Class Diagram for Purchases and Payments
			Refining the UML Class Diagram for Purchases and Payments
		Sunset Graphics’ Relational Database
			Relational Database Planning for Attributes
			Creating the Database and Defining the Tables
		Comprehensive Exercise: Baer Belly Bikinis’ Purchases of Fabric
		Summary
		Key Words
		Appendix A: Generic REA Model with Multiplicities for the Purchases and Payments Process
		Answers to Progress Checks
		Multiple Choice Questions
		Discussion Questions
		Problems
	Chapter 7: Conversion Business Process
		Conversion Process
		Sunset Graphics Example
			Company Overview
			Sunset Graphics’ Conversion Process Description
		Sunset Graphics’ Activity Models
			Basic Conversion Activity Model
			Refining the Model
		Business Rules and Sunset Graphics’ Conversion Process Controls
		Sunset Graphics’ Structure Models
			Basic UML Class Diagram for Conversion
			Refining the UML Class Diagram for Sunset’s Conversion Process
		Sunset Graphics’ Relational Database
			Relational Database Planning for Attributes
			Creating the Database and Defining the Tables
		Summary
		Key Words
		Answers to Progress Checks
		Multiple Choice Questions
		Discussion Questions
		Problems
	Chapter 8: Integrated Project
		Project Planning
			Define Business Requirements
			Prepare Activity Models Using BPMN
			Prepare Structure Diagram
			Import Data into Access, Create Efficient Tables, and Set Relationships
			Prepare Queries
			Using Queries to Develop Financial Statement Information
		Summary
	Chapter 9: Reporting Processes and eXtensible Business Reporting Language (XBRL)
		Introduction
		Data Warehouses and Data Marts
		Business Intelligence
		Digital Dashboards
		Financial Reporting and Xbrl
			History and Development of XBRL
			How XBRL Works
			XBRL Assurance
			XBRL GL
		Summary
		Key Words
		Answers to Progress Checks
		Multiple Choice Questions
		Discussion Questions
		Problems
Part Three: Data Analytics and Emerging Technologies in AIS
	Chapter 10: Data Analytics in Accounting: Concepts and the AMPS Model
		Big Data and Data Analytics
		The Benefits and Costs of the Use of Data Analytics on Business and Accounting
		The Impact of Data Analytics on Business
		The Impact of Data Analytics on Accounting
			Financial Reporting
			Auditing
		The Data Analytics Process: The Amps Model
			The Cyclical, Recursive Nature of the AMPS Model
			The AMPS Model: Ask the Question
			The AMPS Model: Master the Data
			The AMPS Model: Perform the Analysis
			The AMPS Model: Share the Story
		Demonstrating Data Analysis with Excel Following the Amps Model
			Demonstrating Descriptive Data Analysis: Accounts Receivable Aging (Lab 1)
			Demonstrating Diagnostic Data Analysis: Segregation of Duties (Lab 2)
			Demonstrating Predictive Data Analysis: Predicting Bankruptcy (Lab 3)
			Demonstrating Prescriptive Data Analysis: Estimating the Breakeven Point (Lab 4)
		Summary
		Key Words
		Answers to Progress Checks
		Multiple Choice Questions
		Discussion Questions
		Problems
	Chapter 11: Data Analytics in Accounting: Tools and Practice
		Data Visualization Concepts
		Common Elements of Performing and Sharing Data Analysis
		Using Excel for Data Analysis
			Preparing the Excel Data
			Get Data
			Set Relationships among Tables
			Select Attributes for Visualizations
			Select and Modify the Visualization
		Using Tableau for Data Analysis
			Get Data
			Set Relationships among Tables
			Select Attributes for Visualizations
			Select Modify the Visualization
		Using Power Bi for Data Analysis
			Get Data
			Set Relationships among Tables
			Select Attributes for Visualizations
			Select and Modify the Visualization
		Summary
		Key Words
		Appendix A: Sample Charts and Their Uses
		Answers to Progress Checks
		Multiple Choice Questions
		Discussion Questions
		Problems
	Chapter 12: Emerging Technologies: Blockchain and AI Automation
		Blockchain
			A Brief History of Blockchain
			What Is Blockchain?
			When Is Blockchain Useful?
			How Does Blockchain Work?
			Popular Cryptocurrency Applications
			Types of Blockchain
			Platforms Using Blockchain Technology
		Blockchain Applications
			Blockchain Use Cases
			Current Challenges with Adopting Blockchain Technology
			The Impact of Blockchain on Audit and Assurance
			Getting Started with Blockchain
		Artificial Intelligence
			Introduction to Artificial Intelligence
			Assessing Performance
		Ai Applications Important to Accounting
			Natural Language Processing
			Robotic Process Automation
		Summary
		Key Words
		Answers to Progress Checks
		Multiple Choice Questions
		Discussion Questions
Part Four: Managing and Evaluating AIS
	Chapter 13: Accounting Information Systems and Internal Controls
		Introduction
		Ethics, the Sarbanes-Oxley Act of 2002, and Corporate Governance
			The Need for a Code of Ethics
			Corporate Governance as Addressed by Sarbanes-Oxley
		Control and Governance Frameworks
			Overview of Control Concepts
			Commonly Used Frameworks
			COSO Internal Control Framework
			COSO ERM Framework
			COBIT Framework
			Information Technology Infrastructure Library
			ISO 27000 Series
		Comparing Control/Governance Frameworks
		Summary
		Key Words
		Answers to Progress Checks
		Appendix: ERP Architecture and Control Issues
		Multiple Choice Questions
		Discussion Questions
		Problems
	Chapter 14: Information Security and Computer Fraud
		Introduction
		Information Security and Systems Integrity
			Information Security Risks and Attacks
			Encryption and Authentication
			Cybersecurity Risk Management Framework by AICPA
		Computer Fraud and Abuse
			Computer Fraud Risk Assessment
			Computer Fraud Schemes
			Computer Fraud Prevention and Detection
			General Data Protection Regulation
		Vulnerability Assessment and Management
			Types of Vulnerabilities
			An Overall Framework for Vulnerability Assessment and Management
		System Availability
		Disaster Recovery Planning and Business Continuity Management
		Summary
		Key Words
		Answers to Progress Checks
		Multiple Choice Questions
		Discussion Questions
		Problems
	Chapter 15: Monitoring and Auditing AIS
		Introduction
		Computer Hardware and Software
			The Operating System
			Database Systems
			LANs and WANs
			Wireless Networks
		Computer-Assisted Audit Techniques
		Continuous Monitoring and Continuous Auditing
		Summary
		Key Words
		Answers to Progress Checks
		Multiple Choice Questions
		Discussion Questions
		Problems
Part Five: Optional AIS Topics
	Chapter 16: The Balanced Scorecard, Business Model Canvas, and Business Value of Information Technology
		Balanced Scorecard Framework
			Learning and Growth Perspective
			Process Perspective
			Customer Perspective
			Financial Perspective
		Framework Integrating Strategy, Operations, And IT Investment
		Role of Ais/IT in a Balanced Scorecard Framework
		Using a Balanced Scorecard Management Process
		Role of Ais/IT in the Balanced Scorecard Management Process
		IT Governance Institute Val it Framework
		Implementing Val it Governance
		Business Model Canvas
			Elements of the Business Model Canvas
			Impact of Information Technology
			Similarities with Strategy Maps
		Summary
		Key Words
		Multiple Choice Questions
		Discussion Questions
		Problems
	Chapter 17: Evaluating AIS Investments
		Large IT Projects Require Economic Justification
		The Business Case for it Initiatives
			Assessing Business Requirements for IT Initiatives
		Estimating Benefits
		Estimating Costs
			Acquisition Costs
			Operating Costs
		Assessing Risks
		Developing the Value Proposition
			Test the Sensitivity of Estimates to Changes in Assumptions
			Prepare the Value Proposition
		Summary
		Key Words
		Answers to Progress Checks
		Multiple Choice Questions
		Discussion Questions
		Problems
	Chapter 18: Systems Development and Project Management for AIS
		Introduction
		Description of the Systems Development Life Cycle
		Effective Information Technology Planning
		Projects, Project Management, and Project Sponsors
		Challenges of it Project Management
		Constraining Factors of it Projects
			Scope
			Cost
			Time
			The 15-15 Rule
		Project Management Tools
		Will the System Be Used, and Will It Be Useful?
			Addressing Perceived Usefulness
			Addressing Perceived Ease of Use
		Summary
		Key Words
		Answers to Progress Checks
		Multiple Choice Questions
		Discussion Questions
		Problems
		GLOSSARY OF MODELS
		Structure Models Using the REA Framework
		Activity Models Using BPMN
Glossary
Index