Overview of Transaction Processing and Enterprise Resource Planning Systems

Overview of Transaction Processing and Enterprise Resource Planning Systems

Introduction

This chapter introduces the fundamental concepts of transaction processing in accounting information systems and explores how enterprise resource planning (ERP) systems integrate and streamline organizational activities. Understanding these systems is essential for effective financial accounting and management.

Data Processing Cycle

Stages of the Data Processing Cycle

The data processing cycle describes how accounting information systems handle transactions from initial input to final output. The main stages are:

• Data Input: Capturing transaction data triggered by business events.

• Data Storage: Organizing and storing data for future use.

• Data Processing: Manipulating data to create, read, update, or delete records.

• Information Output: Presenting processed data as useful information.

Data Input

Steps in Processing Input

• Capture transaction data: Initiated by a business activity (event), such as a sale or purchase.

• Ensure accuracy and completeness: Data must be correct and fully recorded.

• Follow company policies: For example, transactions may require approval before processing.

Data Capture

Information Collected for Activities

• Activity of interest: The specific event, e.g., a sale.

• Resources affected: Items such as inventory and cash.

• Participants: People involved, such as customers and employees.

• Source documents: The origin of information, such as invoices or receipts.

Source Documents

Types of Source Documents

• Paper source documents: Physical forms like invoices and receipts.

• Turnaround documents: Documents sent to external parties and returned with data, e.g., utility bills with payment stubs.

• Source data automation: Data captured directly by machines, such as Point of Sale (POS) scanners.

Data Storage

Organization of Data

• Chart of accounts: A structured list of all accounts used by an organization, designed to meet management needs efficiently.

• Transaction journals: Chronological records of transactions, e.g., sales journal.

• Subsidiary ledgers: Detailed records supporting control accounts, e.g., accounts receivable ledger.

• General ledger: The central repository for all financial transactions.

Audit trail: The path that allows tracing a transaction from its origin to its final impact on financial statements.

Coding Techniques

Methods of Coding Data

• Sequence codes: Items are numbered consecutively to ensure completeness (e.g., prenumbered checks).

• Block codes: Blocks of numbers are reserved for specific categories (e.g., product numbers starting with '2' for refrigerators).

• Group codes: Multiple subgroups of digits are used to code items (e.g., vehicle identification numbers).

• Mnemonic codes: Letters and numbers are combined to identify items (e.g., Dry300W05 for a specific dryer model).

Audit Trail Example

Tracing a Transaction

An audit trail allows users to follow the path of a transaction, such as Invoice #156 for $1,876.50 sold to KDR Builders, through the sales journal, general ledger, subsidiary ledger, and accounts receivable records.

Computer-Based Storage

Master Files and Transaction Files

• Master files: Permanent records containing cumulative data about entities (e.g., customer accounts).

• Transaction files: Temporary records of individual transactions (e.g., sales for a day).

Data is organized into fields (individual pieces of information), records (collections of related fields), and files (collections of records).

Data Processing

CRUD Operations

There are four main types of data processing operations, often referred to as CRUD:

• Creating: Adding new records (e.g., new customer).

• Reading: Accessing existing data.

• Updating: Modifying existing records.

• Deleting: Removing records.

Data processing can be performed in batch mode (processing groups of transactions at scheduled times) or real-time (processing transactions as they occur).

Information Output

Forms of Output

• Online (soft copy): Data viewed electronically.

• Printed (hard copy): Physical documents, such as:

  • Documents: Sales invoices.

  • Reports: Monthly sales reports.

  • Queries: Specific questions answered by the database (e.g., "Which division had the most sales for the month?").

Enterprise Resource Planning (ERP) Systems

Integration of Organizational Activities

ERP systems integrate various business processes across the organization, including:

• Revenue Cycle

• Expenditure Cycle

• Production Cycle

• H/R Payroll Cycle

• General Ledger and Reporting System

Advantages of ERP Systems

Benefits

• Integrated view: Single, enterprise-wide perspective of data.

• Data captured once: Reduces duplication and errors.

• Visibility and monitoring: Enhanced management oversight.

• Access control: Improved security through permissions.

• Standardization: Uniform procedures and reports.

• Customer service: Improved responsiveness.

• Productivity: Increased efficiency through automation.

Disadvantages of ERP Systems

Challenges

• Cost: High initial investment.

• Implementation time: Significant time required to deploy.

• Customization: Adapting or standardizing business processes can be difficult.

• Complexity: Systems can be complicated to manage.

• User resistance: Employees may be reluctant to learn new systems.

Key Terms

Essential Vocabulary

• Data processing cycle

• Source documents

• Turnaround documents

• Source data automation

• General ledger

• Subsidiary ledger

• Control account

• Coding

• Sequence code

• Block code

• Group code

• Mnemonic code

• Chart of accounts

• Specialized journal

• Audit trail

• Entity

• Attributes

• Field

• Record

• Data value

• File

• Master file

• Transaction file

• Database

• Batch processing

• Online, real-time processing

• Document

• Report

• Query

• Enterprise resource planning (ERP) system

Table: Coding Techniques Comparison

Technique	Description	Example
Sequence Code	Consecutive numbering for completeness	Check #1001, #1002, #1003
Block Code	Blocks of numbers for categories	Product #2001 (Refrigerator)
Group Code	Subgroups of digits for item attributes	VIN: 1HGCM82633A123456
Mnemonic Code	Letters/numbers for identification	Dry300W05 (Dryer, 300 series, White, Sears)

Example: Audit Trail

Tracing Invoice #156 for $1,876.50 sold to KDR Builders through the sales journal, general ledger, subsidiary ledger, and accounts receivable subsidiary ledger demonstrates how transactions can be followed for verification and control.

Example: CRUD Operations

• Creating: Adding a new customer record to the database.

• Reading: Viewing a customer's account balance.

• Updating: Changing a customer's address.

• Deleting: Removing a customer who is no longer active.

Formula: Data Processing Cycle

The data processing cycle can be represented as:

$ext{Data Input} ightarrow ext{Data Storage} ightarrow ext{Data Processing} ightarrow ext{Information Output}$

Additional info:

• ERP systems are increasingly used in financial accounting to ensure data integrity and streamline reporting.

• Understanding coding techniques is essential for organizing financial data and ensuring accurate reporting.