Ultimate Accountants QuickBooks Certificate Program

Your Clients want a QuickBooks expert!
ProTrain now offer this great new self-paced QuickBooks training programs, in partnership Real World Training.  Support your clients, fix disasters, and unlock the power of QuickBooks Premier Accountant Edition. 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 for Accountants Level 1

·         Mastering QuickBooks for Accountants 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 for Accountants Level 1

• Understand basic workflows in QuickBooks
• Recommend the RIGHT QuickBooks solution (what you REALLY need to know)
• Support different "editions" of QuickBooks (Pro vs. Premier vs. Contractor Edition, etc)
• Use the Toggle Edition feature to quickly support different clients
• 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)
• Learn how to change an account type
• Prepare and interpret important financial statements, including class tracking
• Use the Financial Statement Designer and Financial Statement Editor to customize the presentation of financial statements
• Combine financial statements from multiple company files using QuickBooks Enterprise Solutions
• Learn the QuickBooks rules for Journal Entries, and how to reverse GJE's
• Use the Working Trial Balance
• Remote access and other ways to work with clients
• 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)
• Find and fix common bank reconciliation errors
• 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 - create user profiles to improve internal controls
• Use the Audit Trail to find and fix client errors
• Learn about the payroll service options for you and your clients
• Setting up and using payroll
• Paying payroll liabilities and taxes, including preparing W2, and 941 tax forms
• Time tracking for employees and subcontractors
• Learn how to manage employees with QuickBooks Enterprise Solutions
• Use the Employee Organizer and Employment Regulations Guide available with QuickBooks Enterprise Solutions
• 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, and restricting user access
• Protect your client's QuickBooks data, and using portable company files
• Customizing QuickBooks, and duplicating custom forms
• Handling tricky situations like NSF checks, and automatic bank transactions
• Record and track customer downpayments/deposits
• Finding and saving time
• Keyboard shortcuts

Includes 26 Interactive Hands-on Practice Exercises.  Get 19 Hours CPE Credit.

Mastering QuickBooks for Accountants Level 2

Get Clients Set Up Correctly

• Understand how and why QuickBooks is different from other accounting software
• Converting from Quicken
• Setting up opening account balances
• Checking your work
• Customize QuickBooks preferences, home page, Icon Bar, and custom fields

Become a QuickBooks Report Expert

• Creating custom summary and transaction detail reports
• Troubleshooting reports and report filters
• Creating report groups to save time
• Using custom fields for expanded reporting power
• Using Excel to report and graph QuickBooks data, as well as combining multiple reports using Excel
• Understand unexpected report results (cash basis balance sheet, subsidiary ledgers not tying to financial statements, etc.)
• Retained Earnings - Understand and fix one of the biggest problems in QuickBooks
• Produce a general ledger for just one account, a transaction journal, and an entry journal
• Budgeting and Forecasting
• Analyzing cash flow

Support Your Clients

• Support clients on different "versions" of QuickBooks (2004 vs. 2005 vs. 2006, 2007, etc.)
• Using Remote Access to support your clients
• Identify and resolve corrupt data files
• Fix bank account reconciliation problems
• Fix bills paid incorrectly, and get a check detail report
• Finding prior year changes
• Learn about the QuickBooks journal entry rules and how to reverse GJE's
• Closing the books and using the accountant's review process
• Learn a better way of working with Retained Earnings
• Quickly locate missing invoices
• Improve QuickBooks performance
• Predict if your client will outgrow an older version of QuickBooks and what to do if this happens
• Improve accounting controls in QuickBooks

Importing and Exporting Information

• Importing and exporting lists, forms, and report templates between QuickBooks files
• Importing lists from Excel
• Importing and exporting between QB and other programs, and using integrated applications

Learn Advanced Sales

• Price levels
• Sales orders
• Statement charges
• Invoicing billable costs
• Fixing aging errors on statements
• Handling customer downpayments/deposits
• Writing off bad debts
• Customer under- and over-payments
• Fixing undeposited funds
• Using multiple A/R accounts
• Handling retail sales

Learn Advanced Purchasing

• Purchasing fixed assets and using the Fixed Asset Manager
• Use the Loan Manager and lines of credit
• Prepaid expenses
• Vendor deposits and support schedules
• Vendor refunds
• Employee/owner purchases
• Trading A/R and A/P balances
• Voiding prior period checks

Master Advanced Payroll and Tax Situations

• Choosing the best payroll service for you
• Fixing payroll item mapping problems, applying benefits and taxes to job costs, job costing salary, voiding paychecks, employee loans, paying company and employee liabilities, and manually adjusting W2's
• Learn Enhanced Payroll service features such as Workers Compensation tracking, and Net to Gross paycheck calculation
• Setting up 1099's and producing 1099's and the 1096

Learn Advanced Inventory

• Learn about inventory limitations in QuickBooks
• Process inventory quantity and value adjustments
• Learn about Groups vs. Inventory assemblies
• Building inventory assemblies and understanding the accounting in QB
• Work with Units of Measure

Master Sales Taxes

• Use multiple sales tax rates on a single invoice
• Fixing sales taxes paid incorrectly

Includes 15 Interactive Hands-on Practice Exercises.  Get 13.5 Hours CPE Credit

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.