OTTAWA | 613.722.7811

Accounting and Payroll Administrator Program Outline

(Please note that programs may be changed or upgraded to meet the demands of industry without notice)

Course Outline

Student Success Strategies  

  • Emphasis is places on thinking about achieving success from day one, and developing the non-technical skills to enhance personal, academic and career success
  • Goal setting; time management and planning; money management
  • Learning styles; memory techniques and note taking; tests and writing techniques

Bookkeeping and Financial Accounting

  • Analyzing and recording business transactions in the general journal
  • Posting to the general ledger accounts
  • Preparing trial balances
  • Recording adjusting and closing entries
  • Using Worksheets
  • Preparing Financial Statements  
  • Using Special Journals and subsidiary ledgers
  • Recording entries for merchandise companies, accounting for cost of goods sold, sales and purchase discounts.
  • Assigning costs to Inventory LIFO, FIFO, Moving Weighted Average, Specific Identification
  • Petty Cash and Bank Reconciliations
  • Payroll accounting

Intermediate Accounting    

  • Accounting for Capital Assets and intangible assets and current liabilities
  • Partnership accounting, admission and withdrawals
  • Preparation of Cash Flow Statements
  • Ratio analysis   

Computerized Accounting with Sage 50

  • Prepare journal entries using Sage 50 Accounting (formerly Simply Accounting)
  • Set-up general ledger accounts, accounts receivables and accounts payables
  • Add employees, inventories and projects to company file
  • Handle month/year end procedures  
  • Advanced accounting procedures using Simply Accounting
  • Set-ups:  payroll; inventory; projects

Computerized Accounting with QuickBooks  

  • Maintaining company accounting records using QuickBooks
  • Set-up general ledger accounts, accounts receivables and accounts payables
  • Recording of transactions; period end procedures
  • Payroll

Payroll Fundamentals  

  • Calculate regular individual net pay including allowances, expenses, and benefits
  • Calculate non-regular individual net pay including bonus and vacation payments
  • Calculate termination payments
  • Calculate commission payments
  • Complete a Record of Employment
  • Communicate all aspects of individual pay requirements to various stakeholders  

Business Communications

  • Focuses on learning writing techniques that ensure effective business communication
  • Achieve an effective style by using precise verbs, concrete nouns and vivid adjectives
  • Write memorandums and email messages that deliver information and make requests
  • Write letters and memorandums that request information concisely and promote goodwill
  • Write letters of appreciation, congratulation, sympathy, recommendation and introduction
  • Write effective formal and informal reports
  • Write a formal report including data, using tables, charts and graphs

Human Resource Management

  • A comprehensive overview of modern day personnel and human resource management
  • Explore the diverse components of human resource functions and its role in the workplace
  • Employee recruitment, development and evaluation
  • Employee rights, benefits, safety in both domestic and global environments
  • Working in a unionized environment  

Microsoft Word Level 1 and 2 ​

  • Enter, edit, and format text to create professional letters, resumes, reports, and research documents
  • Apply advanced features: section breaks, footnotes, page numbering, table of contents
  • Create and format tables
  • Use styles and templates
  • Insert, size, format, and position pictures
  • Use mail merge to generate form letters and mailing labels
  • Create newsletters with pull-quotes and graphics
  • Create online forms, hyperlinks, and macros

Microsoft Excel Level 1 and 2  ​

  • Create, modify, and print workbooks
  • Format worksheet text and values
  • Perform calculations using formulas, functions, data tables, and amortization schedules
  • Create and format charts
  • Work with ranges; sort data
  • Add graphic elements
  • Work with advanced Excel features: Pivot Tables, Data Validation, Solver, and Macros

Microsoft Outlook 

  • Email composition, formatting and inserting attachments
  • Advanced manipulation; customization, filtering mail and creating folders and rules
  • Outlook calendars and task features and using integrated sharing of information between users
  • Monitor activities in a journal, such as messages, files and contacts

Microsoft PowerPoint  

  • Students will develop the necessary skills to create a dynamic business presentation
  • Effectively utilize templates
  • Build and create slide shows
  • Import clipart and pictures for charts and other programs

Project Management

  • Learn how to successfully navigate MS project, create and assign tasks  
  • Create custom reports and exchange project data with other users
  • Manage project budget, timelines and analyze workloads

Career and Employment Strategies     

This module takes the students through the entire job search process including:

  • Where and how to look for a job
  • Effective resume preparation
  • Creating a cover letter tailored to the position
  • Interview preparation
  • Job search management
  • Self-confidence and self-esteem building
  • Mock interviews 
  • Follow up after the interview