APPL70070
Computerized Accounting Processes
 
  I: Administrative Information   II: Course Details   III: Topical Outline(s)  Printable Version
 
Section I: Administrative Information
  Credit Value: 3.0
Credit Value Notes: N/A
Effective: Fall 2013
Prerequisites: (ACCG70016)
Corequisites: N/A
Equivalents:
N/A
Pre/Co/Equiv Notes: N/A

Program(s): Accounting
Program Coordinator(s): Multiple Coordinators
Course Leader or Contact: Multiple Course Leaders
Version:
1.0
Status: Approved - Under Rev (AREV)

Typical Instructional Format

Distance Education
42.0
Total hours: 42.0

Courses may be offered in other formats.

Section I Notes: All Students: This course is delivered using Sheridan's web-based learning management system SLATE. SAGE, the software vendor, has licensed the use of a student version of Simply Accounting Premium 2011, for 14 months. This course is offered both in a classroom version and an online version Continuing Education: In the classroom version students attend regularly scheduled traditional classes (3 hours face-to- face), in a lab classroom, using Sheridan's computers. OPTIONAL; it is advantageous for student's to have access to their own computer for the completion of assignments, however, 'open access' labs are available on campus. In the on-line version students complete the course, off-campus, submitting all assigned work electronically. Students are required to have access to a computer and reliable internet service, as well as basic knowledge using a PC with a Microsoft Operating System, a Web Browser and MS Word/Excel. To be successful in an on-line environment, students require self- discipline to work independently.

 
 
Section II: Course Details

Detailed Description
Students complete computerized accounting cycles for a variety of organizations using SAGE, Simply Accounting. Exposure to components in this accounting suite include; General Ledger, Accounts Payable, Accounts Receivable, Payroll and Inventory. Functionality related to System Set-up, Sales Taxes, Banking, Periodic Processing and Financial Reporting are also explored. Students are introduced to the tools and administrative functions within a Simply Accounting database. Using simulated source documents and a step-by-step approach, students record business transactions, generate periodic processes and produce financial reports essential to decision makers. This hands-on perspective allows students to conceptualize the processes of an accounting system and its inherent internal controls that maintain data integrity for audit purposes. Through interactive discussions, case studies and targeted deliverables, a key stroke approach develops the student¿s ability to apply computerized accounting techniques to each step of the accounting cycle.

Program Context

 
Accounting Program Coordinator: Multiple
This is a core course in the Accounting, Bookkeeping and Tax Certificate(s) offered through the Faculty of Continuing and Professional Studies.


Course Critical Performance and Learning Outcomes

 
 
By the end of this course, students will have demonstrated the 
ability to generate reliable financial information in a computerized 
environment, by accurately converting accounting data from manual 
records. 

Learning Outcomes:

To achieve the critical performance, students will have demonstrated 
the ability to;

1. Complete the accounting cycle of various business entities using 
Simply Accounting, including a complete set of financial statements 
that accurately reflect the financial position of the business in 
accordance with Canadian generally accepted accounting principles 
(GAAP).

2. Utilize a reliable database by performing administrative functions 
to ensure the routine maintenance of data stability, such as backups 
and adhering to internal controls, in order to secure data integrity 
for audit trails.

3. Set up structural elements of a company, including a chart of 
accounts, vendors, customers, employees, inventory items and process 
adjustments, reversing and recurring entries, account reconciliations 
and tax summaries.

4. Record a multitude of business transactions to progressively build 
appropriate accounting records within the concepts and principles of 
accrual accounting.

5. Review sub-ledger's to distinguish how business activity is 
tracked, specifically by vendor and customer, in the automation of 
both payment processes (cash disbursements) and billing processes 
(cash receipts).

6. Formulate methods by which errors can be located and corrected, 
accounts can be reconciled and high level information can be drilled 
down to locate detailed source transactions.

7. Distinguish sales taxes (specifically HST) and manage the 
requirements and obligations of businesses to account for and remit 
appropriate taxes generated from operational activities.

8. Maintain the payroll function to ensure the accurate and timely 
processing of employee pay and compliance with regulatory 
requirements for statutory source deductions.

9. Produce management reports after conducting period-end functions 
and prepare them in spread sheet and/or word processing applications, 
to facilitate problem solving and decision making. 

10. Present financial statements in order to satisfy both internal 
and external stakeholders, including owners, managers, auditors, 
governments, banks and investors.

Evaluation Plan
Students demonstrate their learning in the following ways:

 
In-Class & On-Line Delivery 

Quizzes                    10%
Assignments                20%
Project (Modules 2,3,4)    30%
Comprehensive Final        40% 
                                    
Total                      100%

Notes: Instructor will provide students with written details of the 
evaluation plan, within their class.
Provincial Context
The course meets the following Ministry of Training, Colleges and Universities requirements:

 

Essential Employability Skills
Essential Employability Skills emphasized in the course:

  Communication   Critical Thinking & Problem Solving   Interpersonal
  Numeracy   Information Management   Personal

Notes: N/A

Prior Learning Assessment and Recognition
PLAR Contact: Registrar's Office

Students may apply to receive credit by demonstrating achievement of the course learning outcomes through previous life and work experiences. This course is eligible for challenge through the following method(s):

Challenge Exam Portfolio Interview Other Not Eligible for PLAR
X        

Notes: N/A

 
 
Section III: Topical Outline
Some details of this outline may change as a result of circumstances such as weather cancellations, College and student activities, and class timetabling.
Effective term: Fall 2013
Professor: Multiple Professors
Textbook(s):
Textbook: Using SAGE Simply Accounting Premium 2011, M. Purbhoo 
(Pearson Publishing)
Software: Simply Accounting Premium 2011, Student Edition (Limited 
License)

Applicable student group(s): On-line and In-Class students in the Faculty of Continuing and Professional Studies.
Course Details:
Module 1: Introduction to Simply Accounting (LO's 1,2,7 & 10)
  
Getting Started 

Text Preface - Software Installation
Technical Issues - Recommended Fixes
Content Review - Accounting Cycle & Basic Theory

Chapter 1 - Introduction
 - DVD Data Files
 - Date Formats
 - Data Back Up 
  
Chapter 2 - Sales Taxes
 - Description
 - Administration

Module 2: General Journal & Ledger (LO's 1,3,4,6,7,9 & 10)

Chapter 3 - Muriel's Murals 	
 - General Journal Transactions
 - Adjusting Entries
 - Reporting Functions  

Chapter 4 - Toss for Tots 	
 - General Ledger Set-up
 - Chart of Accounts
 - Linking Control Accounts

Module 3: Accounts Payable & Receivable (LO's 1,3,4,5,6,7,9 & 10)

Chapter 5 - Chai Tea Room
 - A/P (Purchases & Payments)
 - Recurring Entries
 - Adjustments & Discounts 

Chapter 6 - Air Care Services
 - A/R (Sales & Deposits)
 - Recurring Entries
 - Adjustments & Discounts

Chapter 7 - Dorfmann Design
 - Sub-Ledger Set-up
 - Adding/Editing Suppliers & Customers
 - Reporting Functions

Module 4: Payroll (LO's 1,3,4,6,8,9 & 10)

Chapter 8 - Helena's Academy
 - Payroll Journal Transactions
 - Adjusting Entries
 - Reporting Functions

Chapter 9 - Lime Light Laundry
 - Payroll Ledger Set-up
 - Entering Employee Information
 - Tracking Statutory Requirements

Module 5: Inventory & Banking (LO's 1,3,4,6,7,9 & 10)

Chapter 10 - Adrienne Aesthetics
 - Inventory Purchase & Sales 
 - Inventory Adjustments
 - Purchase & Sales Returns

Chapter 15 - Tesses Tresses
 - Bank Reconciliation
 - Period-end Procedures
 - Reporting Functions


Academic Honesty
The principle of academic honesty requires that all work submitted for evaluation and course credit be the original, unassisted work of the student. Cheating or plagiarism including borrowing, copying, purchasing or collaborating on work, except for group projects arranged and approved by the faculty member, or otherwise submitting work that is not the student's own violates this principle and will not be tolerated. Instances of academic dishonesty, including assisting another student to cheat, will be penalized as detailed in the Student Handbook.

Students who have any questions regarding whether or not specific circumstances involve a breach of academic honesty are advised to discuss them with the faculty member prior to submitting the assignment in question.

Discrimination and Harassment
Sheridan is committed to provide a learning environment that respects the dignity, self esteem and fair treatment of every person engaged in the learning process. Behaviour which is inconsistent with this principle will not be tolerated. Details of Sheridan's policy on Harassment and Discrimination are available in the Student Handbook.
 
[ Printable Version ]

Copyright © Sheridan College. All rights reserved.