Bookkeeping Administration Expert

480 Hours / 12 Months / Self-Paced

Course Overview:

This course will provide an introduction to the concepts and uses of accounting in a business environment. The primary areas of study in this course include analysis of business transactions, recording procedures and the use of ledgers and journals, accounting for sales and purchases, managing cash, payroll, accruals and deferrals, and preparation and analysis of basic financial statements. After completing this course, students will have solid understanding of business and financial accounting and its role in bookkeeping administration.

In this course, you will learn how to use QuickBooks Online plus by completing two monthly accounting cycles. In the first lessons, accounting for selling service items will be covered. In later lessons, both service items and inventory items that are sold will be covered. Preparing payroll and creating a new company will also be included. Prior to taking this course, you should be familiar with the accounting cycle and how it is related to a business. While no prior knowledge of QuickBooks Online is required, it will be beneficial to have an understanding of accounting principles.

The majority of this course will be conducted through drill exercises and related practice activities and quizzes based on the knowledge you have gained through completing each chapter. Be prepared for a thorough, and extensive hands-on experience throughout the journey of completing this QuickBooks course. While the reading requirements are light, each chapter contains a number of drills that you must complete, as well as the practice activities assigned and lesson quiz.

This Microsoft Office Suite 2016 bundle includes: Microsoft Word 2016, Microsoft Excel 2016, Microsoft Outlook 2016, Microsoft PowerPoint 2016, and Microsoft Access 2016.

Students are eligible for a free 365 day copy of Intuit QuickBooks Online Plus from the
Intuit Education Program in order to follow along with the course content.

Upon successful completion of this course bundle, participants will be able to:
  • Recognize accounting transactions and record them in journals using proper formats.
  • Use accounting software and spreadsheets to input, manage, and interpret information.
  • Apply the concepts of accrual accounting to transactions that span fiscal periods.
  • Record accounting transactions for merchandising operations and understand how to cost inventories using a variety of methods.
  • Journalize transactions specific to managing cash and accounts receivable.
  • Record transactions for uncollectible accounts.
  • Prepare financial statements including income statements, statements of retained earnings, balance sheets and statements of cash flow.
  • Create professional and accurate financial documents.
  • Navigate QuickBooks Online Plus program
  • Create and use a company
  • Analyze and record transactions for service and inventory businesses
  • Conduct transactions for both customer and vendor requests
  • Complete transactions and account for two full monthly business cycles
  • Prepare Payroll using QuickBooks Online Payroll
  • Create and print business forms and reports

The Bookkeeping Administration Expert course bundle includes the following courses:

  • Fundamentals of Accounting
  • Intuit QuickBooks Online Plus
  • Microsoft Office Suite 2016

** Students will need a copy of Microsoft Office 2016 to follow along with the Microsoft Office Suite 2016 course.

About ProTrain:

ProTrain is committed to offering world class interactive online courses that provide training and learning support for the student in a number of ways during their experience. The ProTrain course structure has been developed to provide activities to guide students throughout the entire process of learning. Learning activities include hands-on assignments that allow students to use what they are learning to allow better transferable skills within their work environments; and collaborative assignments, like wikis and discussion groups that allow them to share what they have learned with others in the same course.

While a student learns, they are not alone. Each student will receive guidance and support from his or her assigned Training Assessment Manager (TAM) and Student Services Specialist (SSS) representative. In addition, we will offer live monthly webinars and feedback sessions for various subject categories. Throughout the entire course, students are monitored by the SSS representative using progress reporting from the ProTrain Registration System (PRS).

ProTrain will provide Students who successfully complete their online certification programs and pass their industry level certification exams the access to the new ProTrain Education-2-Employment Career Tracker system. The Career Tracker will allow our students who pass exams to load their own resumes at no additional cost, and letting industry employers find their talent through the same database.

This course can help you prepare to take the Intuit QuickBooks Certified User Online and Microsoft Office Suite (MOS) Specialist certification exams.

Course Outline:

Fundamentals of Accounting Curriculum:

Lesson 1: Introduction to Accounting

Lesson 2: Analyzing Business Transactions

Lesson 3: Recording Transactions

Lesson 4: Accounting for Sales and Purchases

Lesson 5: Payroll

Lesson 6: Accruals, Deferrals and the Worksheet

Lesson 7: Financial Statements and Closing Procedures

Intuit QuickBooks Online Plus Curriculum:

Lesson 1: Introduction to QuickBooks Online Plus

Lesson 2: Create a Company

Lesson 3: Sales and Receivables: Service Items

Lesson 4: Payables and Purchases

Lesson 5: General Accounting and End-of-Period Procedures

Lesson 6: Sales and Receivables: Product and Service Items

Lesson 7: Payables, Purchases and Inventory

Lesson 8: General Accounting, End-of-Period Procedures, and Budgets

Lesson 9: Payroll

Lesson 10: Quickbooks Desktop, Mobile and Additional Features

Microsoft Office Access 2016 Curriculum:
Access Beginner                   
  • 1.1 Introduction Part 1
  • 1.2 Introduction Part 2
  • 1.3 Elements Part 1
  • 1.4 Elements Part 2
  • 1.5 Reviewing Data
  • 1.6 Queries Part 1
  • 1.7 Queries Part 2
  • 1.8 Tracking Time Part 1
  • 1.9 Tracking Time Part 2
  • 1.10 Tracking Time Part 3
  • 1.11 Design Work With Forms
Access Intermediate
  • 1.1 Relationships Part 1
  • 1.2 Relationships Part 2
  • 1.3 Changing Information
  • 1.4 Loading Tables
  • 1.5 Relating Invoices Part 1
  • 1.6 Relating Invoices Part 2
  • 1.7 Relating Invoices Part 3
  • 1.8 Relating Invoices Part 4
  • 1.9 Time Entry Form
Access Advanced
  • 1.1 Queries Part 1
  • 1.2 Queries Part 2
  • 1.3 Queries Part 3
  • 1.4 Queries Part 4
  • 1.5 Reports Based On Queries
  • 1.6 Adding Additional Information
  • 1.7 Update Query Part 1
  • 1.8 Update Query Part 1
  • 1.9 Creating A Report From Scratch Part 1
  • 1.10 Creating A Report From Scratch Part 2
  • 1.11 Creating A Report From Scratch Part 3
Microsoft Office Excel 2016 Curriculum:
Excel Beginner
  • 1.1 Tabs And Ribbons Part 1
  • 1.2 Tabs And Ribbons Part 2
  • 1.3 Cells Part 1
  • 1.4 Cells Part 2
  • 1.5 Cells Part 3
  • 1.6 Cells Part 4
  • 1.7 Calculations Part 1
  • 1.8 Calculations Part 2
  • 1.9 Calculations Part 3
  • 1.10 Printing Part 1
  • 1.11 Printing Part 2
Excel Intermediate
  • 1.1 Menus And Keyboard Shortcuts Part 1
  • 1.2 Menus And Keyboard Shortcuts Part 2
  • 1.3 Menus And Keyboard Shortcuts Part 3
  • 1.4 Tabs Part 1
  • 1.5 Tabs Part 2
  • 1.6 Formulas And Calculations Part 1
  • 1.7 Formulas And Calculations Part 2
  • 1.8 Formulas And Calculations Part 3
  • 1.9 Formulas And Calculations Part 4
  • 1.10 Importing Data Part 1
  • 1.11 Importing Data Part 2
  • 1.12 Invoices
Excel Advanced
  • 1.1 Advanced Invoice Part 1
  • 1.2 Advanced Invoice Part 2
  • 1.3 Advanced Invoice Part 3
  • 1.4 Advanced Invoice Part 4
  • 1.5 Number Crunching
  • 1.6 Creating A Pivot Table From Scratch
  • 1.7 Smaller Excel Components Part 1
  • 1.8 Smaller Excel Components Part 2
  • 1.9 Smaller Excel Components Part 3
Microsoft Office Outlook 2016 Curriculum:
Outlook Beginner
  • 1.1 Introduction Part 1
  • 1.2 Introduction Part 2
  • 1.3 Options For Displaying Email Messages
  • 1.4 Create And Send An Email
  • 1.5 Receive An Email
  • 1.6 Calendar Part 1
  • 1.7 Calendar Part 2
  • 1.8 Contacts Part 1
  • 1.9 Contacts Part 2
  • 1.10 Tasks
Outlook Intermediate
  • 1.1 Folder Structure Part 1
  • 1.2 Folder Structure Part 2
  • 1.3 Multiple Email Accounts Part 1
  • 1.4 Multiple Email Accounts Part 2
  • 1.5 Create A New Email Part 1
  • 1.6 Create A New Email Part 2
  • 1.7 Signatures
  • 1.8 Calendars Part 1
  • 1.9 Calendars Part 2
  • 1.10 Contacts
  • 1.11 Outlook Settings Part 1
  • 1.12 Outlook Settings Part 2
Outlook Advanced
  • 1.1 One Note Introduction Part 1
  • 1.2 One Note Introduction Part 2
  • 1.3 One Note And PowerPoint
  • 1.4 One Note And Word
  • 1.5 One Note And Outlook
  • 1.6 Sharing Information
  • 1.7 One Note And Mobile Devices
  • 1.8 Additional Elements Part 1
  • 1.9 Additional Elements Part 2
Microsoft Office PowerPoint 2016 Curriculum:
PowerPoint Beginner
  • 1.1 What Is PowerPoint Part 1
  • 1.2 What Is PowerPoint Part 2
  • 1.3 New Presentation
  • 1.4 Viewing Presentation
  • 1.5 Inserting Transitions
  • 1.6 More Visual Designs Part 1
  • 1.7 More Visual Designs Part 2
  • 1.8 More Visual Designs Part 3
  • 1.9 More Visual Designs Part 4
  • 1.10 Notes
PowerPoint Intermediate
  • 1.1 Visual Designs With Logos And Animation Part 1
  • 1.2 Visual Designs With Logos And Animation Part 2
  • 1.3 Visual Designs With Logos And Animation Part 3
  • 1.4 Visual Designs With Logos And Animation Part 4
  • 1.5 Visual Designs With Logos And Animation Part 5
  • 1.6 Exit Animation Part 1
  • 1.7 Exit Animation Part 2
  • 1.8 Exit Animation Part 3
  • 1.9 Navigation Buttons
  • 1.10 Layout Options Part 1
  • 1.11 Layout Options Part 2
PowerPoint Advanced
  • 1.1 Master Pages Part 1
  • 1.2 Master Pages Part 2
  • 1.3 Software Simulation Part 1
  • 1.4 Software Simulation Part 2
  • 1.5 Setting Pictures To Music
  • 1.6 Advanced Animation Techniques
  • 1.7 Triggers
  • 1.8 Motion Path Animation
  • 1.9 Video In Powerpoint
  • 1.10 PowerPoint Review Part 1
  • 1.11 PowerPoint Review Part 2
  • 1.12 Additional Options
Microsoft Office Word 2016 Curriculum:
Word Beginner
  • 1.1 Course Introduction
  • 1.2 Introduction To Word Interface Part 1
  • 1.3 Introduction To Word Interface Part 2
  • 1.4 Introduction To Word Interface Part 3
  • 1.5 View
  • 1.6 Typing Part 1
  • 1.7 Typing Part 2
  • 1.8 Typing Part 3
  • 1.9 Typing Part 4
  • 1.10 Resume Part 1
  • 1.11 Resume Part 2
  • 1.12 Bullet List
Word Intermediate
  • 1.1 Menus And Keyboard Shortcuts Part 1
  • 1.2 Menus And Keyboard Shortcuts Part 2
  • 1.3 Tabs Part 1
  • 1.4 Tables Part 1
  • 1.5 Tables Part 2
  • 1.6 Tables Part 3
  • 1.7 Styles Part 1
  • 1.8 Styles Part 2
  • 1.9 Styles Part 3
  • 1.10 Page Formatting Part 1
  • 1.11 Page Formatting Part 2
  • 1.12 Page Formatting Part 3
Word Advanced
  • 1.1 Creating An Outline
  • 1.2 Inserting Images Part 1
  • 1.3 Inserting Images Part 2
  • 1.4 Tracking Changes
  • 1.5 Mail Merge Part 1
  • 1.6 Mail Merge Part 2
  • 1.7 Large Documents Part 1
  • 1.8 Large Documents Part 2
  • 1.9 Other Word Functions Part 1
  • 1.10 Other Word Functions Part 2
  • 1.11 Document Comparison

All necessary materials are included.

Certification(s):

This course can help you prepare to take the Intuit QuickBooks Certified User Online and Microsoft Office Suite (MOS) Specialist certification exams.


System Requirements:

Internet Connectivity Requirements:
  • Cable and DSL internet connections are recommended.

Hardware Requirements:
  • Minimum Pentium 400 Mhz CPU or G3 Macintosh. 1 GHz or greater CPU recommended.
  • 256MB RAM minimum. 1 GB RAM recommended.
  • 800x600 video resolution minimum. 1025x768 recommended.
  • Speakers/Headphones to listen to Dialogue steaming audio sessions.
  • A microphone to speak in Dialogue streaming audio sessions.
Operating System Requirements:
  • Windows Vista, 7, 8, 8.1, 9, 10
  • Mac OSX 10 or higher.
  • OpenSUSE Linux 9.2 or higher.
Web Browser Requirements:
  • Google Chrome is recommended.
  • Firefox 13.x or greater.
  • Internet Explorer 6.x or greater.
  • Safari 3.2.2 or greater.
Software Requirements:
  • Adobe Flash Player 6 or greater.
  • Oracle Java 7 or greater.
  • Adobe Reader 7 or greater.
Web Browser Settings:
  • Accept Cookies
  • Disable Pop-up Blocker.


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