Module 12: Computerized Application for a Merchandising Firm (Optional)

This module may be completed in the time allowed with a 1:1 or 2:1 ratio of students to computers.  The guidelines in this module are developed so that the teacher and the school may have the flexibility to choose the software General Ledger or Spreadsheet, and hardware that best suits their needs.

Basic objectives related to learning Accounts Receivable, Accounts Payable and Payroll components are included in this module.  Although Module 5 is not listed as a prerequisite, it may be difficult for students to understand the payroll component of the software package without an understanding of payroll.

If time does not permit instruction on all three components, it is strongly recommended that a minimum of

8 - 10 hours of the module be spent on a project where the student designs an accounting system using a practice set and the learned components of the accounting software.  An exercise employing independent learning and critical and creative thinking skills would be of higher priority than completing all of the software components.

Foundational Objectives

·       To recognize technology as a tool to aid in the accounting process.
·       To become accustomed to and adept at the use of accounting software and understand its strengths and limitations.

Common Essential Learnings Foundational Objectives

·         To provide opportunities for students' active involvement in decision making and problem-solving related to technological developments in accounting.  (TL)
·         To develop students' abilities to access knowledge.  (IL)
·         To promote both intuitive, imaginative thought and the ability to evaluate ideas and processes in accounting.  (CCT)


Module 12A:  Computerized Set Up and Practice

Suggested time:  5-8 hours                                          

Level:  Intermediate

Prerequisites:  Modules  2, and 11

Learning Objectives

Notes

12.1              To review the accounting cycle of a merchandising firm.

Students should review the additional accounts of a merchandising firm (sales, purchases, contra accounts, inventory, etc.)

The extent of this exercise will depend on the time elapsed since Module 2 was covered.

12.2              To demonstrate the proper handling of software and hardware and the ability to load and operate General Ledger accounting software.

 

Students should be made aware of the fact that the general Ledger component cannot handle a large number of Accounts Receivables and Accounts Payable.

12.3              To determine the advantage of integrating an Accounts Receivable module and an Accounts Payable module to the General Ledger accounting software.  (CCT)

The accounts receivable and accounts payable modules are essentially subsidiary ledgers.  Why do we need subsidiary ledgers in a manual system?  Reasons may include that the general ledger and all financial statements would become too lengthy or that it would be impossible to determine individual amounts from one balance in a control account.

What advantages are there to having subsidiary ledgers in General Ledger Accounting Software?  Some advantages of subsidiary ledgers and the accounts receivable and accounts payable computerized modules may include being able to keep track of individual balances owing, dates and amounts of individual invoices, and payment due dates.

12.4              To become familiar with the step by step procedure necessary to process accounts receivable and accounts payable data using integrated accounting software modules.  (IL)

Again this may be accomplished in several ways.  The students may work through a directed example with the help of the teacher, may follow a prepared example from a manual, or may work through a tutorial.  The focus should be on becoming familiar with the software and not acquiring new accounting knowledge.

The procedure may include being able to:

·         enter new dates
·         enter company information
·         delete or add accounts receivable and accounts payable components
·         establish accounts receivable and accounts payable as control accounts in the General Ledger
·         enter "customer" information into the accounts receivable component
·         enter "vendor" information into the accounts payable component
·         print copies of customer and vendor information
·         enter transactions on input forms and have them checked by the teacher before being entered into the computer
·         post to the ledgers
·         print reports
·         make a back up of all files and understand the importance of doing so in a regular, systematic way.

 


Module 12B:  Payroll Integration

Suggested time:  3-5 hours                                          

Level:  Intermediate

Prerequisites:  Modules  2, 11 and 12A

Learning Objectives

Notes

12.5              To determine the advantage of integrating a payroll component to accounting software.

What is the purpose of payroll software?  Some items that may be listed are accumulating data for individual employees, to produce employee pay cheques, to summarize employee deductions, and to generate reports for management.

Students should understand how the payroll component communicates with the general ledger component of accounting software.  At what point is it cost beneficial to buy or use the payroll component?  Students should realize it is not always cost effective to purchase or use a payroll module for a small number of employees.  Businesses can have payroll sent out to an outside agency such as a bank that provides the service.

12.6              To become familiar with the step by step procedure necessary to process payroll data using integrated accounting software modules.  (IL)

The procedure may include being able to:

·         enter payroll software information/defaults necessary to process data
·         enter employee information and back up all files
·         print an employee summary
·         write payroll entries on input forms and then place these in a payroll journal and back up all files
·         post payroll information
·         print payroll reports
·         make a back up of all files.

 

 

Module 12C:  Designing a Computerized Accounting System

Suggested time:  8-10 hours

Level:  Intermediate

Prerequisites:  Modules 2, 11 and 12B

Learning Objectives

Notes

12.7              To design an accounting system for a merchandising firm using General Ledger, Accounts Receivable, Accounts Payable, and Payroll software.  (CCT)

This objective may be accomplished by using a textbook project, a practice set, or a teacher created simulation.  Current source documents should be used.  If the practice set/project used as a student activity is prepared by a publisher, an audit test may be available.

Students will design the system complying with software requirements, analyze transactions, prepare all statements and reports, and follow control procedures.

This exercise should be a higher priority than covering all three additional software components.