Mastering QuickBooks Ultimate Curriculum

     Learn QuickBooks, accounting, and Excel & Word in one
           powerful, comprehensive QuickBooks curriculum.

  This curriculum includes our Mastering QuickBooks Level 1, Level 2,
  Learning Accounting Basics, and Learning Excel & Word classes. First, you learn about
  QuickBooks. You start with the basics… like moving around in QuickBooks and entering
  daily transactions. When you finish, you’ll be a confident user that can enter difficult
  transactions, find and fix mistakes, and know that your QuickBooks numbers are correct.

  Next, you get a crash course in accounting…a critical part of your learning. You learn
  accounting principles, how to analyze and review your numbers, what accounting tasks you
  need to perform (and when), and how to work with your accountant.

  You complete your curriculum with training on Microsoft Word and Excel. These powerful
  software programs let you extend the power of QuickBooks even further!

• 32+ hours of comprehensive training (6 full days)
• 3 comprehensive learning manuals
• QuickLearn lets you practice what you learn…while you learn
• QuickSearch lets you learn only what you need to know
• 46 hours of CPE

                     Should you enroll in this curriculum?

  ENROLL if:
  You are the primary person responsible for QuickBooks in your organization and the
  company relies on you for your QuickBooks, accounting, and computer knowledge. You
  also want to utilize all the available software tools to create accurate and meaningful
  financial reports.

  DO NOT ENROLL if:
  You are a consultant or accountant that needs to support different editions of QuickBooks
  …such as QuickBooks Enterprise Solutions, QuickBooks Online Edition, QuickBooks
  Point of Sale, and QuickBooks Macintosh. If you have that need, we strongly recommend
  the Complete Learning Library.

              The equivalent of 6 days classroom training!

  Note: The Mastering QuickBooks Ultimate Curriculum
  represents 6 full days of training. Each day is packed full of
  meaningful topics!

  Day 1

  Getting Started

• Setting up your company
• Moving around QuickBooks...EFFICIENTLY
• Customize your Home page
• Getting help...FAST

  Everyday Transactions

• Selling: invoices, sales receipts, payments, deposits, credit memos, statement charges,
  linking to 3^rd party software, and customer statements
• Buying: bills, bill payments, checks, bills vs. checks, and credit memos
• Inventory: purchase orders, receiving items, adjusting inventory
• Sales Taxes: setting up, adjusting, paying, and reporting sales taxes
• Banking: reconciling bank accounts and locating discrepancies

  Special Transactions

• Giving and receiving refunds
• Voiding vs. deleting a check
• Applying credit memos

  Tips & Tricks

• Special "Window" tricks
• Cleaning up lists (delete, hide and merge)
• Sorting and customizing lists
• "Collapsing" financial statements
• Showing P&L by month, or as a percent of income

  Understanding Accounting

• Really understanding your financial statements
• Setting up the chart of accounts
• Changing and fixing the chart of accounts
• Cash vs. Accrual accounting
• Using general journal entries
• Creating and using subaccounts
• Using the Company Snapshot feature

  Day 2

  Payroll

• Setting up payroll
• Entering year-to-date payroll information
• Setting up employees
• Creating payroll items
• Tracking and invoicing time
• Processing paychecks
• Modifying paychecks
• Making tax deposits
• Preparing tax forms

  Working with Reports

• Adding, deleting, resizing, and reordering columns
• Filtering and formatting reports
• Saving reports and creating memorized report groups

  Advanced Features

• Using petty cash
• Setting up QuickBooks on a network (multi-user)
• Password protecting QuickBooks
• Updating QuickBooks
• Working with Microsoft Word and Microsoft Excel
• Closing the books
• Finding transactions FAST and other time saving features
• Working with the Accountant's Copy feature
• Protecting your QuickBooks data

  Tips & Tricks

• Keyboard shortcuts
• Tailoring company preferences
• Creating custom invoices and other forms
• Adding logos and custom fields to forms

  Tricky Transactions

• Using online banking
• Handling bounced checks...easily
• Entering customer down payments/deposits
• Creating automatic transactions (memorizing transactions)
• Using credit cards

  Day 3

  Customizing QuickBooks (make QuickBooks REALLY work for you!)

• Modifying important preferences
• Customizing your home page
• Modifying the iconbar
• Creating and using custom fields
• Using account numbers
• Using classes (for departments, locations, etc.)

  Sales Transactions, Tricks, and Workarounds

• Setting up price levels
• Sales orders/backorders
• Invoicing for billable costs
• Complex sales tax situations
• Creating and using estimates
• Progress invoicing
• Finding and fixing typical errors in accounts receivable
• 2 methods for handling customer deposits
• Writing off bad debts
• Customer under- and over-payments
• Transferring customer credits
• Working with multiple accounts receivable accounts
• Entering retail sales

  Purchase Transactions, Tricks, and Workarounds

• Purchasing and accounting for fixed assets
• Entering company loans with the Loan Manager
• Lines of credi
t
• Typical bill payment errors
• Preparing 1099’s at year-end
• Employee and owner purchases
• Prepaid expenses
• Vendor deposits
• Vendor refunds
• Barter transactions
• Voiding prior period checks
• Using the cash flow projection tool

  Items & Inventory

• Expenses vs. Items…which do you use?
• Inventory limitations
• Inventory adjustments
• Creating group items
• Working with inventory assemblies
• Units of measure

  Advanced Tricks

• When should you start over with a new file?
• The limitations of QuickBooks
• Handling bank reconciliation errors
• Using multiple currencies
• Fixing errors in all areas of QuickBooks... there are so many we can't list them all!

  Completing Set Up

• Completing setup: opening balances, completing lists, special accounts, opening balance equity, and payroll setup
• 2 methods for entering transaction history
• Checking the setup…is it right?

Day 4

  Payroll Transactions, Tricks, and Workarounds

• Correcting the setup of payroll items
• Adding difficult payroll items
• Using payroll effectively for job costing
• Voiding/Reprinting paychecks
• Handling special payroll deductions and payments
• Preparing and adjusting W-2s
• Employee loans
• Setting up and tracking workers compensation insurance
• Net to Gross paycheck calculations

  Mastering QuickBooks Reporting

• Advanced report customization
• Report types in QuickBooks…what you really need to know!
• Importing and exporting reports
• Using special fields to improve reports
• Troubleshooting reports filters
• Memorizing reports and creating report groups
• Adding reports to the iconbar
• Powerful techniques for modifying reports in Excel
• Generating custom summary and transaction reports
• Graphing QuickBooks data in Excel
• Budgets and forecasts
• Combining financial statements
• Extending the QuickBooks database
• Using advanced fields for reports (customer type, vendor type, job
type, custom fields,
and more)

  Unlocking the Power of QuickBooks

• Deleting and archiving old transactions in your file
• Remote access (to access your company file through the internet)
• Automating backups
• Tricks to make QuickBooks run faster and more efficiently
• Corrupt data files…how, why, and what to do
• Verify and rebuild company files

  Importing and Exporting

• Exchanging data between QuickBooks files
• Importing and exporting lists
• Importing and exporting customized forms
• Using reports with multiple company files
• Exchanging data between QuickBooks and other programs
• Working with integrated applications
• Using special Excel import feature

  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
• Year-end procedures
• Using the Audit Trail and other reports to find errors
• Cash basis financial statements (what is QuickBooks doing?)
• Special reports for your accountant
• What you REALLY need to know to become an advanced user!
• Little known power features in all areas of QuickBooks

  Day 5

  Accounting Basics

• Definition of Accounting from a small business perspective
• Explanation of why you need accounting
• Financial statements…what are they?
• What is an account?
• Double entry accounting and how it applies to QuickBooks
• Debits and credits…the essence of accounting

  Accounting Principles

• Intro to accounting principles…the foundation of accounting
• Reporting principle
• Reliability principle
• Comparability principle
• Cost principle
• Revenue principle
• Matching principle
• Applying the principles

  Accounting Basics in QuickBooks

• The balance sheet and profit & loss statement
• Working with account types
• Setting up the chart of accounts
• Management reporting vs. financial reporting
• Working with subaccounts
• Techniques to review account detail
• Understanding debits/credits in common QuickBooks transactions (checks, invoices,
  payments, deposits, bills, bill payments, and journal entries)

  Reviewing Numbers for Accuracy

• Basic review techniques
• Using QuickZoom as an investigative tool
• Reconciling accounts to external documentation
• Verifying numbers on key reports
• Checking balances for accounts receivable, accounts payable, and inventory

  Analyzing and Interpreting Data

• Basic financial interpretations
• Analyzing business trends
• Interpreting variable expenses
• Understanding and using key financial ratios (current ratio, return on equity, gross profit
  margin, and net profit margin)

  The Accounting Cycle (who does what and when?)

• What is the accounting cycle and why is it important?
• Daily accounting tasks
• Weekly accounting tasks
• Pay period accounting tasks
• Monthly accounting tasks
• Quarterly accounting tasks
• Annual accounting tasks
• Key tasks within each cycle demonstrated in QuickBooks
• Closing the books
• Restricting access to closed periods

  Working with Your Accountant

• Speaking the same language as your accountant!
• Creating a client/accountant agreement
• Methods for getting information to your accountant
• Accountant's Copy Process
• Special reports for your accountant (journal report, general ledger, transaction entry
  journal, and trial balance)

  More Accounting

• Using account numbers
• Setting up classes to segment financial statements
• Budgeting and planning in QuickBooks
• Cash vs. accrual accounting
• Understanding and using retained earnings
• Year-end closing entries
• 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 IRS)
• A periodic activities checklist (so important accounting tasks are not overlooked)
• A year-end closing checklist
• 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

  Day 6

  Excel

  The Basics

• What are spreadsheets and workbooks?
• Moving around in Excel
• Understanding the Excel interface
• Getting Help
• Tips for exporting to QuickBooks

  Working with Excel & QuickBooks Together

• Sending reports to a new workbook
• Transferring reports to an existing workbook
• Moving and naming worksheets
• Aligning, deleting, and inserting worksheets
• Changing report headings
• Selecting, moving, merging, and editing cells
• Deleting columns, non-adjacent columns, and rows

  Formatting in Excel

• Creating the look you want
• Adding borders
• Accounting vs. Currency styles
• Using the Format painter
• Adding tab colors and comments
• Freezing panes (so column and row headings don't disappear when you scroll through reports)
• Understanding date formats and why dates sometimes appear as numbers

  Calculations and Formulas

• Relative vs. absolute references (understanding the difference and when to use each!)
• Creating and copying formulas
• Array formulas (what is it and when to use)
• 3-D formulas…a powerful Excel trick!
• Using the formula checker (a very powerful Excel feature)

  Summarizing and Analyzing Data in Excel

• How to analyze numbers in Excel
• Using the count, average, and mean functions
• Collapsing Excel reports (to hide and show relevant data)
• Using the Auto Outline feature
• Filtering reports in Excel
• Grouping and sorting data
• Pivot tables…what are they and how do you use them?
• Using What If analysis

  Real World Applications

• Creating an amortization schedule
• Building an expense reimbursement form
• Speeding up bank reconciliations
• Creating graphs of QuickBooks data (in Excel!)
• Importing lists from Excel into QuickBooks
• Importing IIF files into QuickBooks

  Customizing Excel

• Creating personalized toolbars
• Building your own menus
• Changing the screen layout
• Password protecting Excel files
• Setting the default format

  Shortcuts and Saving Time

• Creating macros to automate Excel steps
• Shortcuts using the mouse
• Shortcuts using the keyboard
• Printing tricks and tips

  Word

  The Basics

• What are files and templates?
• Moving around in Word
• Understanding the Word interface
• Using different layout views
• Getting Help

  Working with Word and QuickBooks Together

• Using the QuickBooks to Word link
• Creating a letter from scratch
• Converting an existing Word document
• Modifying the Word letters
• Creating invoice cover letters
• Fixing “missing information” errors

  Word Techniques

• Working with Word documents
• Understanding document compatibility issues
• Setting the Auto Recover options
• Entering, selecting, dragging, dropping, cutting, copying, pasting, and deleting in Word
• Using the built-in spelling and grammar checkers

  Formatting in Word

• Understanding and using the Home tab
• Customizing fonts
• Highlighting fonts
• Using the format painter feature
• Creating and using bulleted and numbered lists
• Setting tabs, tab stops, and indents
• Creating and using styles and style sheets
• Adjusting margins
• Setting page breaks
• Printing word documents

  Working with Document Objects in Word

• Adding company logo to letters
• Re-sizing and re-positioning objects
• Creating watermarks
• Using Word symbols
• Using and modifying clip art and other pictures
• Working with tables
• Importing tables from Excel
• Inserting files
• Adding “Hyperlinks” to documents, web pages, and spreadsheets

  Customizing Word

• Creating smart tags to use Word information in other programs
• Creating personalized toolbars
• Building your own menus
• Changing the screen layout
• Password protecting files
• Setting the default format
• Tracking changes in Word

  Shortcuts and Saving Time

• Using keyboard shortcuts to find information
• Other keyboard shortcuts
• Auto correcting Word documents
• Using different languages
• Creating and using Word templates

  And much more!

       Real Customers…Real Words…Real World Training’s
              Mastering QuickBooks Ultimate Curriculum

  The training software is very easy to use and understand. It is the first learning course
  that I have actually enjoyed using in a long time
  J. Roseberry

  I look forward to future products that you'll be bringing to the market. You should be proud
  of the product.
  RH Benton

  Builds confidence, quick resource for understanding basics, wonderfully presented. Your
  product is excellent as presented.
  J. Anderson

  Bravo - I feel much more confident with having the skills to use or find answers on how to
  do things in QuickBooks now. Thank you very much.
  M. Manion

  I was very impressed with this quick & easy learning method. I like being able to learn at
  my own pace and go back and review when needed. I am looking forward to starting the
  Level 2 as I have purchased many of your software training cd's.
  A Fusselbaugh

  Step by step...good pace.
  B. Rankinugh

  Makes running your company so much faster. Time is money!
  D. Gutierrez

  I never expected it would be this great!
  R. Casimiro