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