Course

Computer Applications for Accounting

Faculty
Commerce & Business Administration
Department
Accounting
Course Code
ACCT 1222
Credits
3.00
Semester Length
15 Weeks X 4 Hours Per Week = 60 Hours
Max Class Size
30
Method(s) Of Instruction
Lecture
Seminar
Online
Hybrid
Typically Offered
Fall
Summer
Winter

Overview

Course Description
This course will introduce the student to the concepts and practices of computerized accounting using QuickBooks and Sage 50 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 Sage 50 Accounting along with use of security options.
2.2  Create a new company or use predefined templates.
2.3  Set up the General Ledger, entering Budgets 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 Reports 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.

7. Activate and use of Departments.

Learning Activities

Lecture and practical applications, conducted exclusively in a computer lab and/or on-line.

Means of Assessment
QuickBooks    
Assignment(s) and Quiz(zes)  8%  
Comprehensive QuickBooks Examination 15%  
 Total QuickBooks    23%
Sage 50 Accounting    
Assignment(s) and Quiz(zes)   07-10%  
Tests  32-35%  
Comprehensive Sage 50 Accounting Examination       35%  
       Total Sage 50 Accounting    77%
     100%

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

To pass this course, students must obtain a minimum of 50% on invigilated assessments, with the 50% calculated on a weighted average basis.

 

Invigilated assessments include, in-class quizzes, in-class tests, midterm exam(s) and the final exam.

 

Students may conduct research as part of their coursework in this class. Instructors for the course are responsible for ensuring that student research projects comply with College policies on ethical conduct for research involving humans, which can require obtaining Informed Consent from participants and getting the approval of the Douglas College Research Ethics Board prior to conducting the research.

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 Sage 50 Accounting General Ledger module to produce financial reports and prepare a bank reconciliation.
  3. Set up and use the Sage 50 Accounting Accounts Receivable module.
  4. Set up and use the sage 50 Accounting Accounts Payable module.
  5. Set up and use the Sage 50 Accounting Payroll module.
  6. Set up and use Sage 50 Accounting Project module.
  7. Set up and use Departments, Security and Budgets.
Textbook Materials

Textbooks and Materials to be Purchased by Students

 Christine Heaney, Using Intuit QuickBooks Premier 20XX for Windows, latest edition, Pearson Educational, as approved by the Accounting Department.

Freedman, H. and Smith, C.,  Learning Sage 50 Accounting by Sage Premium 20XX, latest edition, Thomson Nelson, as approved by the Accounting Department.

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

ACCT 1110 or ACCT 1235 text or equivalent.

Requisites

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).

Corequisites

Courses listed here must be completed either prior to or simultaneously with this course:

  • No corequisite courses

Equivalencies

Courses listed here are equivalent to this course and cannot be taken for further credit:

  • No equivalency courses

Course Guidelines

Course Guidelines for previous years are viewable by selecting the version desired. If you took this course and do not see a listing for the starting semester / year of the course, consider the previous version as the applicable version.

Course Transfers

These are for current course guidelines only. For a full list of archived courses please see https://www.bctransferguide.ca

Institution Transfer Details for ACCT 1222
Acsenda School of Management (ASM) No credit
Camosun College (CAMO) CAMO ACCT 250 (3)
Capilano University (CAPU) CAPU BFIN 1XX (3)
Kwantlen Polytechnic University (KPU) No credit
Langara College (LANG) LANG FMGT 2308 (3)
North Island College (NIC) NIC BUS 1XX (3)
Okanagan College (OC) No credit
Simon Fraser University (SFU) No credit
Thompson Rivers University (TRU) TRU ACCT 2280 (3)
Trinity Western University (TWU) No credit
University Canada West (UCW) UCW ACCT 210 (3) or UCW ACCT 220 (3)
University of British Columbia - Okanagan (UBCO) No credit
University of British Columbia - Vancouver (UBCV) No credit
University of Northern BC (UNBC) UNBC COMM 2XX (3)
University of the Fraser Valley (UFV) UFV BUS 1XX (3)
University of Victoria (UVIC) No credit
Vancouver Island University (VIU) VIU ACCT 1st (3)

Course Offerings

Summer 2024

CRN
Days
Dates
Start Date
End Date
Instructor
Status
CRN
22312
Thu
Start Date
-
End Date
Start Date
End Date
Instructor Last Name
Formosa
Instructor First Name
Kurtis
Course Status
Waitlist
Max
Enrolled
Remaining
Waitlist
Max Seats Count
30
Actual Seats Count
30
0
Actual Wait Count
18
Days
Building
Room
Time
Thu
Building
New Westminster - North Bldg.
Room
N6109
Start Time
9:30
-
End Time
12:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
CRN
22695
Wed
Start Date
-
End Date
Start Date
End Date
Instructor Last Name
Formosa
Instructor First Name
Kurtis
Course Status
Waitlist
Section Notes

ACCT 1222 050 - This course will include some synchronous online activities. Students should plan to be available on-line at scheduled course times.

Max
Enrolled
Remaining
Waitlist
Max Seats Count
30
Actual Seats Count
30
0
Actual Wait Count
15
Days
Building
Room
Time
Wed
Building
Anvil Office Tower
Room
808
Start Time
18:30
-
End Time
21:20