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.
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.
Methods of Instruction
Lecture and practical applications, conducted exclusively in a computer lab and/or on-line.
Means of Assessment
|Assignment(s) and Quiz(zes)
|Comprehensive QuickBooks Examination
| Total QuickBooks
|Sage 50 Accounting
|Assignment(s) and Quiz(zes)
|Comprehensive Sage 50 Accounting Examination
| Total Sage 50 Accounting
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.
At the end of the course, the successful student should be able to:
- Use QuickBooks to record: journal entries, cash, accounts receivable, accounts payable and produce financial statements.
- Set up and use the Sage 50 Accounting General Ledger module to produce financial reports and prepare a bank reconciliation.
- Set up and use the Sage 50 Accounting Accounts Receivable module.
- Set up and use the sage 50 Accounting Accounts Payable module.
- Set up and use the Sage 50 Accounting Payroll module.
- Set up and use Sage 50 Accounting Project module.
- Set up and use Departments, Security and Budgets.
(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).
Courses listed here must be completed either prior to or simultaneously with this course:
Courses listed here are equivalent to this course and cannot be taken for further credit:
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.
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.
If your course prerequisites indicate that you need an assessment, please see our Assessment page for more information.