ED-BM-107 Professional Bookkeeping Specialist

Price: 
$3,250.00
Category: 
Business Management
Combined Hours: 
585
Course Type: 
Mentor Supported
Bundled Courses:
Professional Bookkeeping
QuickBooks® Pro
Microsoft® Office (MOS) 2019
  • Description
  • Objectives
  • Outline
  • Materials
  • Certification
  • System Requirements
  • Watch a Demo

Are you well organized? Do you like working with official papers and enjoy seeing a set of figures add up properly? If so, Our Professional Bookkeeping Specialist program could be the just what you are looking for!  Our program teaches you QuickBooks, bookkeeping, and the most recent Microsoft Office products. 

Professional Bookkeeping

After completing this course, you should be able to:

  • Identify the daily tasks and procedures involved with bookkeeping
  • Define inventory systems and the steps needed to issue financial statements
  • Recall the methods for managing credits and collections
  • List the steps involved in accounts payable and recordkeeping
  • Describe the fundamentals of mastering internal controls and fraud prevention

QuickBooks® Pro

After completing this course, you should be able to:

  • List the basics for getting started with QuickBooks
  • Define the steps for completing daily entry tasks
  • Recognize the steps to print checks, process taxes, process payroll and track expenses
  • Identify the steps for creating and printing reports, invoicing, file management, and backing up information
  • Describe steps for creating charts for tracking actual spending, income, inventory, assets, and liabilities

Microsoft® Office (MOS) 2019

After completing this course, you should be able to:

  • Recall ways to create, edit, and print documents in Word
  • Recognize how to create and manage worksheets in Excel
  • Identify the steps to develop presentations in PowerPoint
  • List how to create and manage databases in Access
  • Identify the steps to manage email and calendars in Outlook
  • Describe ways to create professional publications with Publisher

Professional Bookkeeping

Professional Bookkeeping Module 1
Setting Up Your Accounting System

  • Bookkeeping and Accounting Basics
  • Chart of Accounts
  • Debits vs. Credits
  • Double-Entry Accounting
  • Using Journal Entries and Ledgers
  • Choosing an Accounting Method
  • Cash and Accrual Basis

Professional Bookkeeping Module 2
Recording Accounting Transactions

  • Business Transactions
  • Managing Bookkeeping and Accounting System
  • End-of-Period Procedures
  • Tracking Purchases
  • Tracking Inventory
  • Collecting on Cash Sales
  • Processing Employee Payroll and Benefits
  • Taxing Payrolls

Professional Bookkeeping Module 3
Adjusting and Closing Entries

  • Depreciating Your Assets
  • Paying and Collecting Interest
  • Proving Out the Cash
  • Closing Cash Journals
  • Reconciling Accounts and Closing Journal Entries
  • Checking Your Accuracy
  • Working with Trial Balance
  • Developing a Financial Statement Worksheet
  • Adjusting the Books

Professional Bookkeeping Module 4
Preparing Income Statements and Balance Sheets

  • Origins of Accounting Standards
  • Understanding the Nature of Profit
  • Preparing Income Statements Related to Profit
  • Assessing the Balance Sheet’s Asset Section
  • Accounting for Liabilities
  • Keeping Current Liabilities Under Control
  • Capital Stock
  • Coupling the Income Statement and Balance Sheet

Professional Bookkeeping Module 5
Reporting on Financial Statements

  • Clarifying the Values of Assets in Balance Sheets
  • Introducing Business Valuation
  • Cash Flows and Changes in Equity
  • Difference Between Cash and Profit
  • Analyzing Financial Statements
  • Explanatory Notes and Disclosures
  • Reports to Shareholders

Professional Bookkeeping Module 6
Planning and Budgeting for Business

  • Incorporating Your Business
  • Choosing a Legal Structure for a Business
  • Outlining a Basic Business Plan
  • Budgeting Basics
  • Budgeting with Cash or Accrual Accounting
  • Long-Term Obligations

Professional Bookkeeping Module 7
Business Decisions

  • Estimating Costs with Job Costing
  • Performing Activity-Based Costing
  • Examining Contribution Margins
  • Accounting for Change with Variance Analysis
  • Smart Pricing Decisions
  • Financial Formulas

Professional Bookkeeping Module 8
Cash and Purchasing

  • Identifying Costs and Matching Costs with Revenue
  • Satisfying the Matching Principle
  • Inventory Cost Flow Assumptions
  • Inventory Types
  • Incremental and Opportunity Costs
  • Interpreting Financial Results
  • Reviewing Profit and Earnings
  • Maximizing Business Value

Professional Bookkeeping Module 9
Auditing and Detecting Financial Fraud

  • Sarbanes-Oxley Regulation
  • Preventing Cash Losses from Embezzlement and Fraud
  • Assessing Audit Risk
  • Collecting and Documenting Audit Evidence
  • Auditing a Client’s Internal Controls
  • Five Components of Internal Controls
  • Common Fraud Schemes
  • Financial Statement Fraud

**Outlines are subject to change, as courses and materials are updated.**

QuickBooks® Pro

QuickBooks Pro Module 1
An Accounting Primer

  • Principles of Accounting
  • Double-Entry Bookkeeping
  • Accounts Receivable
  • Inventory Accounting
  • Recording Accounts Payable Transactions
  • Accounting for Fixed Assets
  • Recognizing Liabilities
  • Closing Out Revenue and Expense Accounts

QuickBooks Pro Module 2
Setting Up QuickBooks

  • Planning Your New System
  • Installing QuickBooks
  • QuickBooks Setup Wizard
  • Identifying the Starting Trial Balance
  • Loading the Master File Lists
  • Setting Up QuickBooks Preferences
  • Specifying Reports and Graphs

QuickBooks Pro Module 3
Bookkeeping Basics

  • Invoicing Customers
  • Recording Sales Receipts and Credit Memos
  • Paying Vendors
  • Paying Bills
  • Tracking Inventory and Items
  • Managing Cash and Bank Accounts
  • Reconciling Bank Accounts
  • Setting Up Payroll
  • Paying Employees

QuickBooks Pro Module 4
Accounting Chores

  • Working with QuickBooks Journal Entries
  • Reviewing the Accountant and Tax Reports
  • Preparing Financial Statements and Reports
  • Preparing a Budget
  • Using Activity-Based Costing
  • Setting Up Project and Job Costing Systems

QuickBooks Pro Module 5
Financial Management

  • Ratio Analysis
  • Liquidity and Leverage Ratios
  • Activity and Profitability Ratios
  • Economic Value-Added Analysis
  • Capital Budgeting
  • Measuring Liquidity
  • Thinking About Risk

QuickBooks Pro Module 6
Business Plans

  • Profit-Volume-Cost Analysis
  • Calculating Break-Event Points
  • Creating a Business Forecast
  • Reviewing Financial Statements and Ratios
  • Using the Business Plan Workbook
  • Writing a Business Plan
  • Strategic Plans

QuickBooks Pro Module 7
Administering QuickBooks and Protecting Data

  • Keeping Data Confidential
  • Using Audit Trails
  • Simultaneous Multiuser Access
  • Backing Up the QuickBooks Data File
  • Restoring a QuickBooks Data File
  • Condensing the QuickBooks Company Files
  • Troubleshooting

**Outlines are subject to change, as courses and materials are updated.**

Microsoft® Office (MOS) 2019

Microsoft Office 2019 Module 1
Common Office Tasks

  • All About Office 365
  • Office Interface
  • Saving Your Files
  • Manipulating the Text
  • Handling Case or Capitalization
  • Entering Symbols and Foreign Characters
  • Undoing and Repeating Commands
  • Correcting Typos
  • AutoCorrect Command

Microsoft Office 2019 Module 2
Working With Word Part 1

  • Speed Techniques
  • Creating a New Document
  • Selecting Text
  • Laying Out Text and Pages
  • Numbering
  • Headers and Footers
  • Hyphenating Text
  • Word Styles
  • Constructing the Perfect Table
  • Neat Table Tricks

Microsoft Office 2019 Module 3
Working With Word Part 2

  • Spelling and Grammatical Errors
  • Finding and Replacing Text
  • Desktop Publishing with Word
  • Experimenting with Themes
  • Highlighting Parts of a Document
  • Track Changes
  • Reports and Scholarly Papers
  • Generating a Table of Contents
  • Compiling a Bibliography

Microsoft Office 2019 Module 4
Working With Excel

  • New Excel Workbook
  • Entering Data in a Workbook
  • Refining Your Worksheet
  • Selecting Cells
  • Deleting, Copying and Moving Data
  • Formulas and Functions
  • Laying Out a Worksheet
  • Analyzing Data
  • Managing Information Lists

Microsoft Office 2019 Module 5   
Working With PowerPoint

  • Creating a New Presentation
  • Selecting, Moving and Deleting Slides
  • Themes and Slide Backgrounds
  • Choosing Slide Size
  • Footers and Headers on Slides
  • Transitions and Animations
  • Adding Audio
  • Adding Notes
  • Rehearsing and Timing

Microsoft Office 2019 Module 6
Working With Outlook

  • Outlook Folders
  • Categorizing Items
  • Searching for Stray Folder Items
  • Contacts Folder
  • Handling Email
  • Calendar
  • Scheduling Appointments and Events
  • Managing Time and Schedule
  • Tasks, Reminders and Notes

Microsoft Office 2019 Module 7
Working with Access

  • Tables and Queries
  • Forms
  • Creating a Database File
  • Designing a Database
  • Field Properties
  • Entering Data
  • Sorting
  • Querying
  • Filtering for Data

Microsoft Office 2019 Module 8
Working with Publisher

  • Introducing Frames
  • Creating a Publication
  • Redesigning a Publication
  • Formatting Text
  • Text Wraps
  • Placeholder Pictures
  • Frames
  • Decorating the Text
  • Design Checker

Microsoft Office 2019 Module 9
Working with Charts and Graphs

  • Creating a Chart
  • Saving a Chart as a Template
  • Chart Tricks
  • SmartArt Diagram
  • Handling Graphics and Photos
  • Touching Up a Picture
  • Drawing and Manipulating Lines, Shapes and Objects
  • WordArt

Microsoft Office 2019 Module 10
One Step Beyond

  • Customizing the Ribbon
  • Customizing the Quick Access Toolbar
  • Ways of Distributing Your Work
  • Working with Publisher
  • Printing a Publication
  • Filing Sharing and Collaborating
  • OneDrive
  • Sharing Files and Folders with Other
     

All course materials included.

Professional Bookkeeping

Upon successful completion of our Professional Bookkeeping course, students will be prepared, in part, to sit for the American Institute of Professional Bookkeeper's (AIPB) Certified Bookkeeper exam. Candidates must also submit proof of at least two years of full time or 3,000 hours of part-time work experience before or after taking the exam. Candidates have 3 years from the exam date to fulfill this requirement.

Note: This course is not affiliated with, nor has it been endorsed by the American Institute of Professional Bookkeepers. 

Internet Connection

  • Broadband or High-Speed - DSL, Cable, and Wireless Connections

*Dial-Up internet connections will result in a diminished online experience. Classroom pages may load slowly and viewing large audio and video files may not be possible.

Hardware Requirements

  • Processor - 2GHz Processor or Higher
  • Memory - 1 GB RAM Minimum Recommended

 

PC Software Requirements

  • Operating Systems - Windows 7 or higher
  • Microsoft Office 2013 or higher. Also, you could use a general Word Processing application to save and open Microsoft Office formats (.doc, .docx, .xls, .xlsx, .ppt, .pptx)
  • Internet Browsers - Google Chrome is highly recommended
    • Cookies MUST be enabled
    • Pop-ups MUST be allowed (Pop-up Blocker disabled)
  • The Kindle Reader App or VitalSource Bookshelf App are needed for many of our courses (No special equipment needed. This can be downloaded for FREE onto your computer.)
  • PowerPoint Viewer (if you do not have PowerPoint)
  • Adobe PDF Reader
  • QuickTime, Windows Media Player &/or Real Player

 

MAC Software Requirements

  • Operating Systems - Mac OS x 10 or higher with Windows
  • Mac office programs or a Word Processing application to save and open Microsoft Office formats (.doc, .docx, .xls, .xlsx, .ppt, .pptx)
  • Internet Browsers- Google Chrome is highly recommended
    • Cookies MUST be enabled
    • Pop-ups MUST be allowed (Pop-up Blocker disabled)
  • The Kindle Reader App or VitalSource Bookshelf App are needed for many of our courses (No special equipment needed. This can be downloaded for FREE onto your computer.)
  • PowerPoint Viewer (if you do not have PowerPoint)
  • Adobe PDF Reader
  • Apple QuickTime Media Player