Complete Bookkeepers QuickBooks Certificate Program

ProTrain now offer this great new self-paced QuickBooks training programs, in partnership Real World Training.  If you want to learn QuickBooks, our training programs are the right solution!  Our self-paced QuickBooks courses are designed for all users from novice to expert.  You'll learn the techniques and tricks needed to fully utilize QuickBooks for your business.  An officially-endorsed training partners for Intuit, Real World has taught more than 500,000 students how to master QuickBooks. We have an amazing 99% approval rating from our students! And, we offer the only self-paced QuickBooks training classes endorsed by Intuit...the maker of QuickBooks. 

This five course programs includes:

·         Mastering QuickBooks Level 1

·         Mastering QuickBooks Level 2

·         Mastering Accounting Basics for QuickBooks

·         Mastering Microsoft Excel for QuickBooks Users

·         Mastering Microsoft Word for QuickBooks Users

Contains five CD-ROMs, full video of live seminars, three manuals and over 40 interactive hands-on practice exercises.

Mastering QuickBooks 2007 Level 1

·         Introduction to QuickBooks

·         Creating a new company file

·         Customize your Home page

·         Working with lists (adding, deleting, merging, sorting, printing, etc.)

·         Work with your chart of accounts (adding accounts/subaccounts, and account numbers)

·         Prepare and interpret important financial statements, including class tracking

·         Setting up what you sell and buy (items)

·         Tracking customers and sales (customers, estimating, invoicing, sales receipts, retail sales, credit memos, and statements)

·         Tracking vendors and expenses (vendors, bills, bill payment stubs, checks, and credit memos)

·         Reconciling your bank account, and what to do if they don't

·         Job costing

·         Purchasing and managing inventory

·         Tracking sales taxes

·         Handle petty cash

·         Voiding checks vs. deleting checks

·         Tips and tricks for saving time

·         Security and multi-user, and restricting user access

·         Setting up and using payroll

·         Paying payroll liabilities and taxes, including preparing W2, and 941 tax forms

·         Time tracking for employees and subcontractors

·         Reporting: create, modify, and memorize reports, and using Microsoft Excel for added reporting power

·         Using credit cards for purchases

·         Create form letters using Microsoft Word

·         Closing the books

·         Backing up and restoring data files, and using portable company files

·         Customizing QuickBooks

·         Handling tricky situations like NSF checks, and automatic bank transactions

·         Record and track customer down payments/deposits

·         Finding and saving time

·         Keyboard shortcuts

Includes 22 Interactive Hands-on Practice Exercises

Mastering QuickBooks 2007 Level 2

Advanced Sales

• Customer under- and over-payments, statement charges, classifying transactions, and multiple A/R accounts
• Customer deposits, billing for expenses, markups, writing off bad debts, complex sales tax situations, and clearing accounts
• Sales orders/backorders, transferring customer credits, price levels, and retail sales

Advanced Purchases

• Vendor deposits, pre-paid expenses, and purchasing and selling fixed assets
• Entering beginning balances, tracking loans, owner and employee purchases, and many more!
• Lines of credit, 1099's, and vendor refunds

Handling More Complex Situations

• Choosing items vs. expenses
• Inventory limitations, group items vs. assemblies, units of measure
• Fixing errors in all areas of QuickBooks... there are so many we can't list them all!

Advanced Reports

• Importing and exporting reports
• Use special fields to improve reporting
• Troubleshooting filters, memorizing reports, and report groups
• Powerful techniques for modifying reports in Excel
• Generating custom summary and transaction reports
• Graphing QuickBooks data in Excel
• Using classes to expand your reporting capabilities
• Budgets and forecasts, cash flow projection tool
• Combining financial statements using QB Enterprise Solutions

Unlocking the Power of QuickBooks

• Remote access
• Importing and exporting lists and form templates
• What you REALLY need to know to become an advanced user!
• Little known power features in all areas of QuickBooks
• Tricks to make QuickBooks run faster and more efficiently

Advanced Payroll Techniques

• Correcting the setup of payroll items
• Using payroll effectively for job costing
• Voiding/Reprinting paychecks
• Adjusting W-2s
• Employee loans
• Workers compensation
• Net to Gross paycheck calculations

Secrets Your Accountant Should Know

• Common client mistakes and their fixes
• Closing the books
• Getting information to and from your accountant
• Finding changes made to closed periods
• Understanding and using retained earnings
• Discovering quirks of QuickBooks journal entries
• Using reversing journal entries
• Understanding year-end procedures
• Using the Audit Trail and other reports to find errors
• Voiding checks from prior periods

Includes 14 Interactive Hands-on Practice Exercises

Mastering Accounting Basics for QuickBooks

• Definition of Accounting from a small business perspective
• Explanation of why you need accounting
• Detailed explanation of financial statements
• Double entry accounting and how it applies to QuickBooks
• Common transactions in terms of debits and credits
• 6 key principles of accounting-defined and explained
• 6 key principles of accounting-demonstrated in QuickBooks
• Setting up chart of accounts for management reports vs. financial reports
• Techniques to review numbers for accuracy
• How to find accounting errors
• Supporting accuracy of data-using internal support (QB Reports)and external support
• Analyzing trends
• Interpreting variable expenses
• Financial ratios
• Expert Analysis
• Explanation of accounting cycles (daily, monthly, quarterly, annual)
• Tasks associated with each accounting cycle
• Key tasks within each cycle demonstrated in QuickBooks
• "Language" of accounting-accounting terms defined
• QuickBooks reports for accountants
• Account numbers and class tracking
• Budgeting and planning in QuickBooks
• Cash vs. accrual accounting
• Understanding and using retained earnings
• Finding prior year changes

Also Includes These Valuable Resources:

• A glossary of accounting terms so you can finally understand your accountant!
• A QuickBooks keyboard shortcuts list - to save time
• A summary of account types and which financial statements they flow to
• A Debits and Credits "Cheat Sheet" - no need to memorize how they work!
• A list of financial ratios and how they are calculated
• A sample tax calendar so you know when various tax forms and payments are due
• A list of record-keeping requirements as suggested by the IRS
• A periodic activities checklist, so important accounting tasks are not overlooked
• A year-end closing checklist for you and your accountant to discuss
• A step-by-step summary of the techniques used to exchange data with your accountant
• Help creating a client/accountant agreement, and assigning responsibilities
• A backup log you can use to schedule and monitor timely backups

Includes 8 Interactive Hands-on Practice Exercises

Mastering Excel for QuickBooks Users

• The Basics:
  What are spreadsheets and workbooks?
  Navigate in Excel
  Entering/Editing cells
  Adding/deleting rows and columns (adjacent and non adjacent)
  Get help in Excel
  Export tips
  Export to new and existing workbooks
  Align and move worksheets
• Save Time:
  Create Macros so Excel automatically completes a number of steps for you
  Keyboard and mouse shortcuts
  Fill series-tells Excel to complete a list of numbers, days, months etc. automatically
  Printing techniques so you don't waste time trying to print sheets the way you want
• Formatting:
  Create the look you want
  Merge and center cells
  Add borders
  Accounting vs. Currency styles
  Format painter
  Add tab colors
  Add comments
  Freeze panes (so column and row headings don't disappear when you scroll through reports)
  Understand date formats and why dates sometimes appear as numbers
• Real World Applications:
  Create an amortization schedule quickly
  Create expense reimbursement forms and speed up bank reconciliation
  Create your own graphs of QuickBooks data
• Summarizing Data:
  Calculating mean vs. median
  Pivot tables and charts
  Group and sort data
  Count function (to save you time)
• Importing:
  Import lists from Excel into QuickBooks
  Data mapping
  Import IIF files
• Security:
  Set passwords for workbooks
  Protect worksheets
  Lock individual cells from editing
• Analyze Your Data:
  "What If?" analysis
  Goal seek
• Formulas and Calculations:
  Relative vs. absolute references (understand the difference and when to use each!)
  Array and 3-D Formulas...and when to use them
• Customize Excel:
  Create your own toolbar and menu
  Move and add toolbar and menu commands

Mastering Word for QuickBooks Users

• Send Letters from QuickBooks to Word:
  Using the QuickBooks to Word link to prepare letters using QuickBooks information
  Prepare envelopes for mailings automatically
  Convert existing Word form letters into QuickBooks letters
  Create invoice cover letters using Word
• Work With Document Text:
  Entering and formatting text
  Cut/copy/paste text
  Overtyping text
  Selecting text
• Format Word Documents:
  Numbered lists
  Bullet lists
  Using tabs, tab stops, and indents
  Inserting logos, text boxes, tables, Excel spreadsheets, and hyperlinks
  Use clip art, WordArt, watermarks, and AutoShapes
  Character and paragraph formatting
  Line and paragraph spacing
  Highlighting text
  Using borders and shading
  Margins, page breaks, and page numbers
• Manage Documents:
  Save, edit, and delete QuickBooks/Word letters
  Work with different layout views
  Use AutoRecover so you don't lose your work!
  Create documents and templates
  Printing documents
  Password protect documents
  Tracking changes made by multiple users
• Master Powerful Word Tools:
  Spell Checker
  Grammar Checker
  Use Styles for consistent formatting
  Thesaurus
  Use built-in templates for businesses
  Work with Smart Tags
• Customize Word:
  Create Word menus and toolbars
  Create your own menu and toolbar shortcuts
  Enable/disable adaptive menus
• Save Time:
  Keyboard shortcuts
  Find & replace
  AutoCorrect

PC Requirements

• Pentium 100
• 32mb RAM
• 256 color SVGA capable of 1024x768 resolution
• Windows compatible sound card
• 2x CD-ROM drive or a 2x DVD-ROM drive for the DVD
• 200 MB hard drive space
• Windows 2000, XP, Vista or higher operating system
• This training is PC based only. We do offer a Learning QuickBooks product that runs on Macintosh.

FAQs

Which version of the software do you teach?

We teach the most current version of QuickBooks, currently version 2007. If you do not have the latest version, do not worry. The older versions work in the same basic fashion…so the techniques you learn will not be wasted. You may call our office to see if an older version of this product is still available at 1-800-564-2688.

Do you teach QuickBooks Pro or QuickBooks Premier?

We use QuickBooks Premier in the training. This is basically the same software as QuickBooks Pro with a few extra features. The instructor points out the differences.

What's covered in the training?

Our training shows you how to master QuickBooks and make it really work for your company. It's designed for all users from the novice to the experienced. Our training covers all the material of our full two-day seminar! Click the Topics Covered tab for more information.

Are the products QAS certified?

No. However, they are approved by NASBA for CPE credits. Check with your state board to see if they require QAS certification for credit (most don't). Currently, Florida, Minnesota, Oregon, South Carolina, and Tennessee require QAS certification to award credit.

Instructor

David J. O'Brien, CPA

David is founder and President of Real World Training. He is an award-winning speaker and has written more than 10 books on how to best use QuickBooks. He has been teaching QuickBooks since 1994 and has taught over 25,000 students! David continues to be an active member of our instructor team and is featured in several of our learning products. David lives in Dallas, Texas. 

QuickBooks is a registered trademark of Intuit Inc.