Computer Applications for Accounting

Curriculum Guideline

Effective Date:
Course
Discontinued
No
Course Code
ACCT 1222
Descriptive
Computer Applications for Accounting
Department
Accounting
Faculty
Commerce & Business Administration
Credits
3.00
Start Date
End Term
201610
PLAR
No
Semester Length
15 Weeks X 4 Hours Per Week = 60 Hours
Max Class Size
30
Contact Hours
Lecture 2 hours/week Seminar 2 hours/week
Method(s) Of Instruction
Lecture
Seminar
Learning Activities

Lecture and practical applications, conducted exclusively in a computer lab.

Course Description
This course will introduce the student to the concepts and practices of computerized accounting using QuickBooks and Simply Accounting software. Students will obtain a working knowledge of Financial Statements, General Ledger, Accounts Receivable, Accounts Payable, Bank Reconcilation, Payroll and Projects for both a service and merchandise company in a computerized environment.
Course Content

1.1  Introduce QuickBooks.
1.2  Set up general ledger accounts, customer and vendor profiles.
1.3  Record day-to-day transactions and adjusting entries in the vendor, customer and company module.
1.4  Process payments for both manual and computer generated cheques.
1.5 Print journals, general ledger reports, aged analysis, trial balance and financial statements.

2.1  Introduce Simply Accounting.
2.2  Create a new company or use predefined templates.
2.3  Set up the General Ledger and Chart of Accounts; process day-to-day and adjusting entries.
2.4  Print journals, general ledger reports and trial balance.
2.5  Generate financial statements.
2.6  Export and import the Chart of Accounts to and from Excel; export the Trial Balance to Excel.
2.7  Perform month-end and year-end procedures. Print post-closing Trial Balance.
2.8  Prepare Bank Reconciliation.


3.1  Activate and set up the Accounts Receivable module.
3.2  Process day-to-day transactions, including invoices, cash receipts and adjustments.
3.3  Perform period-end processing, including interest and write-offs.
3.4  Generate reports, including the aged receivable report.

4.1  Activate and set up the Accounts Payable module.
4.2  Process day-to-day transactions, including invoices and adjustments.
4.3  Process payments, both manual and computer generated cheques.
4.4  Generate reports, including the aged payables report.

5.1  Activate and set up the Payroll module.
5.2  Process day-to-day transactions, including adding employees and deductions.
5.3  Process payroll with correcting entries.
5.4  Generate reports.

6.1 Activate and set up the Project module.

6.2 Process day-to-day transactions using project tracking from journal entry, accounts receivable, accounts payable and payroll module.

6.3 Generate reports.

Learning Outcomes

At the end of the course, the successful student should be able to:

  1. Use QuickBooks to record: journal entries, cash, accounts receivable, accounts payable and produce financial statements.
  2. Set up and use the Simply Accounting General Ledger module to produce financial reports and prepare a bank reconciliation.
  3. Set up and use the Simply Accounting Accounts Receivable module.
  4. Set up and use the Simply Accounting Accounts Payable module.
  5. Set up and use the Simply Accounting Payroll module.
  6. Set up and use Simply Accounting Project module.
Means of Assessment
QuickBooks    
Assignment(s) and Quiz(zes)-minimum one of each       10%  
Comprehensive QuickBooks Examination 20%  
 Total QuickBooks    30%
Simply Accounting    
Assignment(s) and Quiz(zes) - Minimum one of each  05-10%  
Tests - Minimum of two  30-35%  
Comprehensive Simply Accounting Examination      30%  
       Total Simply Accounting    70%
     100%
     
     
     
     

 Students must write both examinations in order to obtain credit for the course.

Textbook Materials

Textbooks and Materials to be Purchased by Students

 Christine Heaney, Using Intuit QuickBooks premier 2012 for Windows, latest edition, Pearson Educational.

Freedman, H. and Smith, C.  Learning Simply Accounting by Sage Premium 2012, latest edition, Thomson Nelson.

 Or other textbook(s) approved by the Accounting Department.

ACCT 1110 or ACCT 1235 text or equivalent.

Prerequisites

(ACCT 1110 with a grade of C or better OR ACCT 1235 with a grade of C or better) AND (CSIS 1190 with a grade of C or better OR CSIS 2200 with a grade of C or better).

Which Prerequisite