Douglas College wordmark
Facebook logo Twitter logo Instagram logo Snapchat logo YouTube logo Wordpress logo

Registration for the Fall 2019 semester begins June 25.  Watch your email for more details.

back to search

Computerized Accounting

Course Code: ACCT 1220
Faculty: Commerce & Business Administration
Department: Accounting
Credits: 3.0
Semester: 15 Weeks X 5 Hours Per Week = 75 Hours
Learning Format: Lecture, Lab
Typically Offered: Fall, Summer, Winter
course overview

This course will introduce the student to the concepts and practices of computerized accounting. This course will build on and apply previously acquired accounting and computer skills. In addition to spreadsheet techniques and applications using Excel, the student will learn SAGE 300: General Ledger and Financial Reporter, Accounts Receivable and Accounts Payable.

Course Content

1.1  Review basic spreadsheet concepts

1.2  Review and apply basic accounting concepts

1.3  Prepare spreadsheets and charts for financial statements, financial analyses, and supporting schedules, including a complete accounting worksheet and financial statement project. Learn appropriate use of spreadsheet formulas and functions as required, such as specialized functions, databases, pivot tables/charts and what if analysis.

2.1  Introduce SAGE 300

2.2  Set up databases and activate the General Ledger

2.3  Set up the General Ledger and Chart of Accounts; process day-to-day and adjusting entries

2.4  Print transaction batches and the Trial Balance

2.5  Generate and modify financial statements using the Financial Reporter feature

2.6  Export and import the Chart of Accounts to and from Excel; export the Trial Balance to Excel

2.7  Perform year-end procedures and print the post-closing Trial Balance

2.8  Activate and set up tax and bank services

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-off batches

3.4  Generate reports, including the Aged Trial Balance

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.

Methods of Instruction

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

Means of Assessment

Excel    
Assignment(s) or Test(s) - At least two in total. 10 to 15%  
Excel examination 20 to 25%  
 Total Excel     30 to 40%

SAGE

   

At least three tests in total

   
General Ledger and Financial Reporter test 10 to 15%  
Accounts Payable test 10 to 15%  
Accounts Receivable test 10 to 15%  
SAGE examination 30 to 40%  
Total SAGE     60 to 70%
    100%

Students must write all 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.

Learning Outcomes

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

  1. Create finance- and accounting-related spreadsheets and charts by enhancing previously acquired finance, accounting and computer skills
  2. Set up and use the SAGE 300 General Ledger module and Financial Reporter
  3. Set up and use the SAGE 300 Accounts Receivable module
  4. Set up and use the SAGE 300 Accounts Payable module

course prerequisites

(ACCT 1110 with a grade of C+ or better OR ACCT 1210 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

curriculum 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 schedule and availability
course transferability

Below shows how this course and its credits transfer within the BC transfer system. 

A course is considered university-transferable (UT) if it transfers to at least one of the five research universities in British Columbia: University of British Columbia; University of British Columbia-Okanagan; Simon Fraser University; University of Victoria; and the University of Northern British Columbia.

For more information on transfer visit the BC Transfer Guide and BCCAT websites.

assessments

If your course prerequisites indicate that you need an assessment, please see our Assessment page for more information.