Bookkeeping Specialty
Bookkeepers are vital contributors to the success of a business. Responsible for recording the day-to-day financial transactions, it is important for a bookkeeper to have an appreciation for details and enjoy working with numbers . If this sounds like you, you may want to consider the Office Administration Bookkeeping Specialty.
Program Overview
The Bookkeeping Specialty introduces you to both manual and computerized bookkeeping systems while also developing your spreadsheet, database, and file management skills. You can expect to produce ‘real-world’ business documents and become familiar with a full year business cycle while also gaining the skills you need to work in offices requiring a variety of functions.
To receive a Bookkeeping Specialty Certificate, students must complete all courses listed in the Office Administration Certificate and the Bookkeeping Specialty.
To complete the Bookkeeping Specialty, you should be prepared to use Microsoft Office software extensively.
Program Duration:
- Bookkeeping Specialty Certificate – 15 weeks
Note: You have up to 5 years to complete the Bookkeeping Specialty certificate.
Program Start Dates:
You can start the program in September or January or on the first Monday of any month from September to April, provided spaces are available.
Classes:
Online Classes:
- Office Administration online courses are accessible from September to early June. Online instructional support is available during scheduled hours Monday through Friday. Course web sites are accessible 24/7 except during scheduled breaks.
Bookkeeping Specialty Certificate Requirements:
Course | Title | Hours | Weeks | Credits |
---|---|---|---|---|
OFAD 172 | Bookkeeping 2 | 45 | 3 | 1.5 |
OFAD 275 | Bookkeeping 3 | 105 | 7 | 3 |
OFAD 178 | Computerized Bookkeeping | 150 | 10 | 3.5 |
OFAD 182 | MS Access 1 | 45 | 3 | 1.5 |
OFAD 281 | MS Excel 2 | 45 | 3 | 1.5 |
OFAD 285 | MS Excel 3 | 60 | 3 | 1.5 |
435 | 29 | 12.5 | ||
14.5 Weeks | Full time |
Course Descriptions
The Bookkeeping Specialty covers a working knowledge of both manual and computerized bookkeeping systems as well as the development of skills in spreadsheet, database, and file management. Students are expected to establish employable skills for working in offices where they may perform a variety of functions.
To receive a Bookkeeping Specialty Certificate, students must complete all courses listed in the Office Administration Certificate, and the Bookkeeping Specialty as follows:
Bookkeeping Specialty Certificate Courses
OFAD-172 – Bookkeeping 2
OFAD 172 Bookkeeping 2 is an introduction to processing a company’s payroll. It covers calculating employees’ earnings and deductions, calculating employer payroll expenses, journalizing and posting the payroll, and disbursing payroll liabilities.
- Minimum Credits: 1.5
- Length: 45 hours
- Prerequisites: OFAD 158, OFAD 170 with a minimum B+ grade (86%)
- Delivery Method: ? Online
- Cost: $182.64
- Course Outline
OFAD-275 – Bookkeeping 3
OFAD 275 Bookkeeping 3 covers bookkeeping activities for service and merchandising businesses, how to analyze and record purchases and sales, handle cash receipts and cash payments, maintain and reconcile subsidiary ledgers, record taxes in special journals, and prepare formal financial statements.
- Minimum Credits: 3
- Length: 105 hours
- Prerequisites: OFAD 158, OFAD 170
- Delivery Method: ? Online
- Cost: $365.28
- Course Outline
OFAD-178 – Computerized Bookkeeping
OFAD 178 provides training opportunities using Sage 50 for Windows. The course includes study of the General Ledger, Accounts Payable, Accounts Receivable, and Payroll and Inventory. Company setup and account linking are included.
- Minimum Credits: 3.5
- Length: 150 hours
- Prerequisites: OFAD 155 or keyboarding assessment, OFAD 158, OFAD 170, OFAD 172, OFAD 180, OFAD 275
- Delivery Method: ? Online
- Cost: $365.28
- Course Outline
OFAD-182 – MS Access 1
The Microsoft Access OFAD 182 course covers introductory database functions to create and process data in a Windows environment. The student creates and modifies useful databases using tables and forms. The student creates and modifies professional quality reports and queries for the databases.
- Minimum Credits: 1.5
- Length: 45 hours
- Prerequisites: OFAD 155 or current typing speed of 25 gwam, OFAD 158 and OFAD 180
- Delivery Method: ? Online
- Cost: $182.64
- Course Outline
OFAD-281 – MS Excel 2
This course covers advanced applications in using financial functions, data tables, amortization schedules, and hyperlinks; creating, sorting and querying a worksheet database; and creating templates and working with multiple worksheets and workbooks.
- Minimum Credits: 1.5
- Length: 45 hours
- Prerequisites: OFAD 180, OFAD 155 or current typing speed of 25 gwam, OFAD 158
- Delivery Method: ? Online
- Cost: $182.64
- Course Outline
OFAD-285 – MS Excel 3
This course covers advanced applications for working with large amounts of data through analyzing, validating, formula auditing, complex problem solving, automating and collaborating. PivotTables and PivotCharts are covered, as are trendlines, Solver, Scenario Manager, Visual Basic for Applications code, macros, controls, and the Compare and Merge Workbooks feature.
- Minimum Credits: 1.5
- Length: 45 hours
- Prerequisites: OFAD 155 or keyboarding placement assessment, OFAD 158, OFAD 180, OFAD 281
- Delivery Method: ? Online
- Cost: $182.64
- Course Outline
Admission Requirements
Academic Requirements:
- Successful completion of the Office Administration certificate within the last 5 years.
- Transfer credit for an Office Administration certificate program taken at other institutions may be available.
Your Costs
Tuition and Fees for Domestic Students:
For the 2024/25 academic year (2024/SU, 2024/FA, 2025/WI, 2025/SP)
Tuition: | $3,652.80 |
Application Fee: | $30.00 |
Student Association Fee: | $103.50 |
Total | $3,786.30 |
*These prices are for domestic students and may not be 100% accurate. However, these estimates will give you an adequate idea of tuition and fees for our programs. These prices do not include textbook costs. All prices are subject to change. Tuition fees include an alumni fee, student activity fees, and a student technology fee. In certain cases a materials and supply fee may also be included. For more information, visit: Tuition and Fees.
Textbooks and Supplies
Textbooks and supplies are available at the College Bookstore.
Online students must have a PC with Microsoft Office 2016 or Office 365 and Windows 10 for all OFAD courses. Registered students are eligible to acquire MS Office 365 for free. Details are provided after registration.
Note: Mac computers are not supported in the OFAD program.
Career Info and Pathways
As a Bookkeeper you can choose to work in the public or private sector. A few examples of career options include:
Program Details
Delivery Method:?
Online
Credential:
Certificate
Categories:
Administrative & Accounting, Business, Finance & Accounting
Interests:
Get in, Get out, Get a Job, Office, Start or Run Your Own Business
Contact Details
Cranbrook
2700 College Way,
Box 8500, Cranbrook, BC, V1C 5L7
Phone: 250-489-2751
Toll-free: 1-877-489-2687
Email: info@cotr.bc.ca