Accounting and Bookkeeping


Accounting and bookkeeping training is available in Victoria BC, and provides people with versatile skill-sets which are in high demand. People who are trained in these fields can work for businesses across all industries. All businesses need to keep track of their finances, and just about any sizeable business needs to hire an accountant or bookkeeper. Sometimes one person will handle both of these tasks, and in other cases there will be people handling each one separately.

Accounting and bookkeeping are the primary practices that concern the tracking and reporting of a business’s finances. These are ideal fields to work in for people who enjoy paying attention to detail, and working with math.

Bookkeeping involves the recording of financial transactions, and the preparation of summarized reports. In this field, the individual will mainly be focused on working with single and double entry systems on paper, or with a computerized system. Bookkeepers will find themselves working with things like daybooks, petty cash, ledgers and journals.

Accounting focuses on the processing, measurement and communication regarding all financial aspects of a business. Accounting practices can include financial and management accounting, working with different information systems, auditing and tax accounting.

We offer courses in Basic Bookkeeping – Foundations, Basic Accounting – Foundation, Sage 50, QuickBooks, and Custom courses. Courses can be delivered in 3-hour blocks, flexible scheduling.

Basic Bookkeeping - Foundation

Who should attend?       This course is intended for anyone without any prior knowledge or experience in Bookkeeping.
Prerequisites:                  Basic computer skills and comfortable working with Windows Explorer.

Duration:                            24 Hours

Course Objectives
Upon completion of the course, participants will be able to accomplish the following:

  • Understand both bookkeeping and accounting principles.
  • Apply knowledge and skills learned to complete the bookkeeping cycle.
  • Work with manual ledgers and journals.
  • Learn a computerized accounting program and applying the knowledge to spreadsheets.
  • Gain an understanding of payroll administration.

Course Content

Manual Bookkeeping:

  • Understanding the basics
  • Bookkeeping terminology and principles
  • “The Accounting Equation”
  • Assets verses expenses

Balance Sheet:

  • Debits and credits, the basic rules
  • Double-entry system
  • Analyzing transactions
  • Create a General Ledger

Ledger:

  • Ledger accounts and Chart of Accounts
  • Posting and the Trial Balance
  • Locating entry errors
  • Correcting error entries
  • Reversing entries

Canadian Taxes:

  • PST and GST/HST on sales and purchases
  • Recording sales and other expenses with PST
  • Calculating and remitting taxes

Additional Journals and Entry Information:

  • Discounts, credit notes, and refunds on sales and purchases
  • Purchase, cash payments, and receipts journals
  • Freight and delivery expenses information

Basic Accounting - Foundation

Who should attend?        This course is intended for anyone without any prior knowledge or experience in Accounting.
Prerequisites:                    Basic computer skills and comfortable working with Windows Explorer.

Duration:                            24 Hours

Course Objectives
Upon completion of the course, participants will be able to accomplish the following:

  • Understand both bookkeeping and accounting principles.
  • Apply knowledge and skills learned to complete the accounting cycle.
  • Understand the accounting equation and double-entry bookkeeping.
  • Record transactions in the appropriate ledger accounts.
  • Prepare a trial balance, balance sheet and a profit and loss account.
  • Learn a computerized accounting program and applying the knowledge to spreadsheets.

Course Content

Manual Accounting:

  • Understanding the basics
  • Accounting terminology and principles
  • “The Accounting Equation”
  • Apply the accounting principles

Trial Balance:

  • Prepare a Trial Balance
  • Prepare entries for various expenses, revenues, depreciation, and accrued revenues and expenses
  • Create financial statements from an adjusted Trial Balance
  • Post closing entries and a post-closing Trial Balance

Inventory:

  • Understand costing and valuation
  • Compute ending inventory and cost of goods sold
  • Apply methods to estimate inventory

Transactions:

  • Prepare a bank reconciliation
  • Record petty cash transactions
  • Creation of financial statements for sole proprietorship

Payroll:

  • Prepare a payroll register
  • Prepare entries to record and pay payroll
  • Optimize content for PDF documents

Microsoft Excel - Level 3 Datasheet Management

Who should attend?         This course is intended for participants who are familiar with Microsoft Excel.
Prerequisites:                     Microsoft Excel  – Level 2 or Equivalent.

Duration:                             6 Hours

Course Objectives
Upon completion of the course, participants will be able to accomplish the following:

  • Create and use Excel tables, as well as add, edit, search for, and delete records in a data list using a form, as well as look up data.
  • Sort records in a data list using a variety of methods.
  • Filter data in a list using a variety of methods, as well as work with filtered data.
  • Create and work with subtotalled lists, as well as use various database functions to summarize data.
  • Create, modify, and work with PivotTables, PivotCharts, and Slicers.
  • Import external data from a variety of sources into Excel.

Course Content

Maintaining Data:

  • Data List and Excel Table Concepts
  • Using Data Forms
  • Using Lookup Tables

Sorting Lists:

  • Sorting Concepts
  • Sorting Lists
  • Custom Sort Orders

Filtering Lists:

  • Filtering Concepts
  • Using AutoFilter
  • Using Advanced Filter
  • Working with Filtered Data

Summarizing Data:

  • Automatic Subtotals
  • Working with Subtotalled Lists
  • Using Functions to Summarize Data

Working with PivotTables:

  • PivotTable Concepts
  • Creating PivotTables
  • Modifying PivotTable Layouts
  • Working with PivotTables
  • PivotCharts
  • Slicers

Working with External Data:

  • External Data Concepts
  • Importing Query Data from Access
  • Importing Query Data from Web Pages
  • Importing Query Data from Text Files

Microsoft Excel - Level 3 Spreadsheet Analysis

Who should attend?         This course is intended for participants who are familiar with Microsoft Excel.
Prerequisites                      Microsoft Excel – Level 2.

Duration:                             6 Hours

Course Objectives
Upon completion of the course, participants will be able to accomplish the following:

  • Use absolute and mixed references in a formula, as well as using financial functions.
  • Use the Goal Seek feature and Data Tables.
  • Create and manage scenarios, as well as create scenario reports.
  • Define and solve problems with Solver, as well as create reports.
  • Understand and utilize the various tools used to audit workbooks.

Course Content

Using Functions:

  • Function Concepts
  • Absolute and Mixed References
  • Financial Functions

Projecting Figures:

  • Goal Seek
  • Data Tables

Performing What-If Scenarios:

  • Scenario Concepts
  • Creating Scenarios
  • Managing Scenarios
  • Scenario Reports

Using Solver:

  • Solver Concepts
  • Defining the Problem
  • Solving the Problem
  • Solver Reports
  • Solver Options

Auditing Workbooks:

  • Auditing Concepts
  • Tracing a Worksheet
  • Evaluating Formulas
  • Locating and Correcting Errors in Formulas
  • Tracking Cells in a Workbook

Microsoft Excel - Level 4 VBA Macros

Who should attend?         This course is intended for participants who are familiar with Microsoft Excel.
Prerequisites                      Microsoft Excel – Level 3.

Duration:                             6 Hours

Course Objectives
Upon completion of the course, participants will be able to accomplish the following:

  • Understand key concepts that will be used to build custom solutions using Microsoft Excel VBA Macros.
  • Become familiar with basic macro techniques for recording, writing, running, and maintaining macros.
  • Understand how Visual Basic for Applications is incorporated, used, and modified in Microsoft Excel.
  • Learn how to design and layout a user form and controls to create a customized dialog box to simplify data entry.
  • Understand how to prepare an Excel Workbook containing macros and toolbars for deployment to other users and machines.
  • Learn to customize macros with VBA source code to automate data entry tasks and enable source code protection.
  • Learn to enhance source code with variables, constants, and logical operators.
  • Learn to handle the three types of errors that can be generated when working with source code.
  • Learn to access external data by using ActiveX Data Objects.
  • Learn how to use Excel as an automation server to control Excel objects externally outside of the application.

Course Content

Building Solutions:

  • Course Overview
  • Solution Concepts
  • Data Entry Concepts
  • Macro Concepts
  • Programming Concepts

Macro Basics:

  • Planning Macros
  • Recording Macros
  • Executing Macros
  • Maintaining Macros

VBA Programming Basics:

  • Understanding Objects
  • Using the Visual Basic Editor
  • Understanding VBA Code
  • Executing VBA Code
  • VBA Help Reference

VBA User Form Basics:

  • Planning User Forms
  • Designing User Forms

Deployment Basics:

  • Preparing for Deployment
  • Code Security
  • Adding Macros to the Quick Access Toolbar
  • Modifying Quick Access Toolbar Buttons

Customizing Macros:

  • Prompting for User Input
  • Automating Data Entry
  • Recording Absolute vs. Relative References
  • Protecting VBA Source Code

Enhancing VBA Code:

  • Writing Source Code
  • Variables and Constants
  • Writing Tips
  • Logical Operators
  • Flow Control

Handling Errors:

  • Handling Errors
  • Syntax Errors
  • Logical Errors
  • Run-Time Errors

Accessing External Data:

  • External References
  • ActiveX Data Objects Concepts
  • Connecting to a Database
  • Retrieving Records from a Database

Excel Automation:

  • Automation Concepts
  • Working with Object Models
  • Excel’s Object Model
  • Automating Excel with VBScript