Professional Bookkeeping Specialist

360 Hours/12 Months/Instructor Supported

Course Overview:

This Professional Bookkeeping course will show you the essentials of record keeping for a small business and will show why it's necessary to track information. The course will give you a greater understanding of the purpose and process of record keeping. Professional Bookkeeping teaches you how to sort through the masses of information and paperwork, how to record what is important for a business, and how to use that information to grow a business for success. This course helps prepare you to take the NACPB Bookkeeping Certification exam. Professional Bookkeeping also assists you in setting up and running a thriving home-based bookkeeping business. This course includes 50 lessons on DVD.

To succeed in small business, you need great ideas, an entrepreneurial spirit, and competitive products or services. And one other thing: a good accounting system like QuickBooks. This QuickBooks for Small Business course shows you how to use this popular business finance program to gain a clear view of your finances and keep your business in the black.

Starting out right — discover what you need to do to be ready for QuickBooks, then install and set up the software
Satisfy the IRS — use QuickBooks to maintain your accounting records to comply with tax laws
Get right to business — quickly learn to enter data, create invoices, and record and print sales receipts
Count your money — keep track of your checkbook, credit card accounts, inventory, payroll, and budgets, all in one place
See what's what — get a company snapshot that tells who needs to get paid, who owes money, and what needs to get done
Stay on track — produce common financial reports and track every dollar coming in and going out
Prepare taxes — Organize your data and simplify tax preparation
Go online — securely download bank and credit card transactions directly into QuickBooks

NOTE: This course does NOT include the QuickBooks program itself. Students will need to have QuickBooks 2010 &/or 2011 already installed on their computers.

If you're looking for a way to get up to speed quickly on the newest version of Microsoft® Office, this course offers step-by-step instructions to make it easy. Office 2010 has new features and tools to master, and whether you're upgrading from an earlier version or encountering the Office applications for the first time, you'll appreciate this simplified approach.

This course covers:

MS Word 2010
MS Excel 2010
MS PowerPoint 2010
MS Outlook 2010
MS Access 2010
MS Publisher 2010

Microsoft® Office holds more than 90 percent of the market for Windows-based productivity suites. Our MS Office 2010 course makes this technology easy to understand, even for those who are new to computers.

As an added bonus the training software that you will receive covers both MS Office 2010 & 2007.

NOTE: This course does NOT include the MS Office programs themselves. Students will need to have Office 2010 &/or 2007 already installed on their computers.

The Professional Bookkeeping Specialist program includes 3 courses:

Professional Bookkeeping
QuickBooks Pro
MS Office 2010

Course Outline:

Professional Bookkeeping

Professional Bookkeeping Module 1
Bookkeeping Basics

Getting Started
The Origins of Bookkeeping
Generally Accepted Accounting Principles (GAAP)
Accrual Accounting
Debits and Credits
Accountants versus Bookkeepers
Accounting Jargon
Setting Up the Record Keeping System
The Balance Sheet
Assets and Liabilities
The Income Statement
The Cash Flow Statement

Professional Bookkeeping Module 2
Intermediate Bookkeeping

Recording the Sales Cycle
Recording the Purchases Cycle
Inventory Tracking Systems
Capital Assets
Understanding Depreciation
Leases and Loans
Transactions between the Company & Its Owners
Remittances to the Government
Maintaining a Petty Cash System
Reconciling the Bank
Backward Posting
Organizing Messy Books

Professional Bookkeeping Module 3
Advanced Bookkeeping

The Role of the External Accountant
Creating Financial Statements
Corporate Income Tax Returns
Budgeting for a Business
Setting up a 12-Month Budget
Monitoring Cash Flow
Understanding Bartering
Foreign Currency Transactions
Reconciling the Foreign Currency Bank Account
Tax Planning
Minimizing Taxes versus Avoiding Taxes
Owner / Manager Remuneration

Professional Bookkeeping Module 4
Starting a Bookkeeping Business

Starting a Bookkeeping Business
Being Self-Employed
Balancing Work and Family
Financial Considerations
Start Up Considerations
Writing a Business Plan
Management and Organization
Doing your Accounting
Establish a Business Identity
Business Checking Account
Business Credit Cards
Setting Up Your Home Office

Professional Bookkeeping Module 5
Marketing & Clients

Bookkeeping or Accounting
Bookkeeping Certification
Getting Experience
Marketing Your Business
Your Ideal Client
Targeting a Niche
Cultivating Referrals
Online Marketing and Social Media
Understanding Websites
Writing Blogs or Articles
Financial Considerations
Client Management, Legal, and Ethical Issues

QuickBooks Pro

QuickBooks Module 1
QuickBooks: Getting Started

Why QuickBooks?
How to Succeed with QuickBooks
Doing the Easy Step Interview
Populating QuickBooks Lists
Adding Employees to Your Employee List
Customers Are Your Business
Adding Vendors to Your Vendor List
Making & Organizing Lists
Printing & Exporting Lists & List Items
Dealing with the Chart of Accounts List

QuickBooks Module 2
Daily Entry Tasks

Creating Invoices and Credit Memos
Preparing an Invoice
Fixing Invoice Mistakes
Preparing a Credit Memo
Printing Invoices and Credit Memos
Sending Invoices and Credit memos via Email
Recording a Sales Receipt
Printing a Sales Receipt
Correcting Sales Receipt Mistakes
Making Bank Deposits
Paying the Bills
Setting Up Inventory Items
Keeping Your Checkbook
Tracking Business Credit Cards

QuickBooks Module 3
Additional QuickBooks Features

Printing Checks
Printing Checking Register
Payroll with QuickBooks
Doing Taxes the Right Way
Paying Your Employees
Paying Payroll Liabilities
Preparing Quarterly Payroll Returns
Building a Budget
Using the Business Planner Tools
Online with QuickBooks

QuickBooks Module 4
Additional Accounting Features

Balancing a Bank Account
Creating and Printing a Report
Processing Multiple Reports
Job Estimating, Billing, and Tracking
File Management
Backing Up the Information
Working with Portable Files
Accountants and Audits
Fixed Assets and Vehicle Lists
Setting Up a Fixed Asset List
Tracking Vehicle Mileage

QuickBooks Module 5
Business Owners & QuickBooks

Signing Checks
Reviewing Canceled Checks
Choosing a Bookkeeper
Review Your Financial Statements
Choose an Accounting System
Selling an Asset
Understanding Owner's Equity
Multiple State Accounting
Getting & Repaying a Loan
Having a Successful Business

Microsoft Office 2010

MS Office 2010 Module 1
Common Office Features

Office Basics
Work with the Ribbon
Customize the Quick Access Toolbar
Working with Files
Create & Save a File
Open & Print a File
Cut, Copy, & Paste Data
Office Graphics Tools
Insert Clip Art or a Picture
Resize & Move Objects
Crop & Add Effects to a Picture
Create a WordArt Object
Working with Office Files Online
Create a New Workspace
Share a Workspace Online

MS Office 2010 Module 2
MS Word

Change Word's Views
Type & Edit Text
Insert Quick Parts
Insert Symbols
Change the Font, Size, & Color
Set Tabs & Margins
Create Lists
Copy & Clear Formatting
Apply a Template
Assign a Theme
Add Borders
Insert a Table
Insert an Excel Spreadsheet
Add Headers & Footers
Generate an Index
Create a Bibliography
Find & Replace Text
Work with AutoCorrect
Track & Review Document Changes

MS Office 2010 Module 3
MS Excel

Building Spreadsheets
Enter & Select Cell Data
Use the AutoFill Feature
Turn on Text Wrapping
Format Data
Apply Conditional Formatting
Resize Columns & Rows
Worksheet Basics
Move & Copy Worksheets
Sort Data
Track & Review Worksheet Changes
Understanding Formulas
Apply Absolute & Relative Cell References
Audit a Worksheet for Errors
Working with Charts
Create, Move, or Change a Chart
Add Gridlines

MS Office 2010 Module 4
MS PowerPoint

Creating a Presentation
Create a Photo Album Presentation
Change PowerPoint Views
Change the Slide Layout
Create a Custom Layout
Populating Presentation Slides
Apply a Theme
Add a Text Box, Table or Chart
Add a Picture or Video Clip
Move or Resize a Slide Object
Reorganize Slides
Define Slide Transitions
Add Animation Effects
Create Custom Animation
Record Narration
Rehearse & Run a Slide Show

MS Office 2010 Module 5
MS Access

Database Basics
Create a Database Based on a Template
Create a New Table
Change Table Views
Add or Delete a Field
Hide or Move a Field
Create a Form
Apply a Database Theme
Add a Record to a Table or Form
Navigate Records in a Form
Search & Delete a Record
Sort Records
Filter Records
Apply Conditional Formatting
Create a Report

MS Office 2010 Module 6
MS Outlook

Organizing with Outlook
View Outlook Components
Schedule an Appointment
Schedule an Event
Create a New Contact
Create a New Task
Organize Outlook Items
Perform an Instant Search
Compose & Send a Message
Send a File Attachment
Read an Incoming Message
Reply To or Forward a Message
Add a Sender to Your Outlook Contacts
View, Clean Up or Ignore a Conversation
Screen Junk E-mail
Create a Message Rule

MS Office 2010 Module 7
MS Publisher

Publisher Basics
Create a Publication
Zoom In & Out
Add Text
Add a New Text Box
Add a Picture to a Publication
Fine-Tuning a Publication
Apply a Text Effect
Change Text Alignment
Add a Border
Control Text Wrap
Link TextBoxes
Move & Resize Publication Objects
Edit the Background
Add & Create a Building Block Object

Materials Included:

Bookkeepers' Boot Camp: Get a Grip on Accounting Basics by Angie Mohr, CA, CMA
How to Start a Home-Based Bookkeeping Business by Michelle Long
Bookkeeping 101 & Beyond with Peachtree Accounting (DVDs) by Robert Henry
QuickBooks® 2011 for Dummies by Stephen L. Nelson, MBA, CPA
Professor Teaches QuickBooks® - CD-ROM
Microsoft® Office 2010 Simplified by Kate Shoup
Professor Teaches Office 2010 – 12 Program Tutorials - CD-ROM

Certifications:

This course helps prepare you to take the NACPB Bookkeeping Certification exam. NACPB Bookkeeper Certification assures the public that you have full-charge bookkeeping knowledge and skills. You obtain the Certification by passing the Uniform Certified Public Bookkeeper Examination.

System Requirements:

Internet Access

Broadband or high-speed internet access is required. Broadband includes DSL, cable, and wireless connections.
Dial-Up internet connections will result in a diminished online experience. Moodle pages may load slowly and viewing large audio and video files may not be possible.

Hardware

Windows hardware configurations and processors are acceptable.
Mac computers MUST have Microsoft Window Operating Systems over Bootcamp (Bootcamp is a free download from Apple's website).
1 GB RAM recommended
Software
Operating Systems
Windows XP or Vista and Mac OS X 10 and higher with Windows
Web Browsers
Google Chrome Safari, Internet Explorer & FireFox are not currently recommended as they cannot display certain Moodle editing menus for both students and instructors
Adobe PDF Reader
Media Plug-ins (These may be required depending on your course media-click on the links below to download the latest versions)
Adobe Flash Player
Adobe Acrobat Reader
Apple Quicktime
Windows Media Player
Real Player
PowerPoint Viewer (use this if you don't have PowerPoint)

Professional Bookkeeping Specialist