- 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