Mastering QuickBooks Accountant Essential Curriculum

   Are you an accountant that needs to learn QuickBooks Pro
        or QuickBooks Premier? This curriculum is for you!

  This curriculum includes our Mastering QuickBooks for Accountants Level 1 and Level 2
  classes. First, you learn QuickBooks from your client’s perspective. Where do they
  struggle? What are the common errors they make? Then, you master the QuickBooks
  transactions that your clients face on a regular basis…from the simple daily transactions to
  the difficult workarounds and advanced transactions.

  You’ll become the report expert your clients need by learning advanced reporting
  techniques. You also learn how to best work with clients…how to exchange data, how to fix
  common errors, and how to set them up the right way. If you truly want to Master
  QuickBooks, this is the curriculum for you!

• 21+ hours of comprehensive training (4 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
• 32 hours of CPE

                    Should you enroll in this curriculum?

  ENROLL if:
  You support clients that use QuickBooks Pro or QuickBooks Premier. Also, you have a
  firm grasp of how to apply accounting principles in QuickBooks and have a strong
  knowledge of Microsoft Word & Excel.

  DO NOT ENROLL if:
  You have no experience applying accounting principles in QuickBooks. Instead, we
  strongly recommend the Accountant Ultimate Curriculum. Or, if you support clients in
  multiple editions of QuickBooks (such as QuickBooks Enterprise or QuickBooks Online)
  we recommend the Complete Learning Library.

             The equivalent of 4 days classroom training!

  Note: The Mastering QuickBooks Accountants Essential
  Curriculum represents 4 full days of training. Each day is
  packed full of meaningful topics!

  Day 1

  Getting Started

• Setting up your client’s data files
• Moving around QuickBooks...EFFICIENTLY

  Everyday Client Transactions

• Selling: invoices, sales receipts, payments, deposits, credit memos, statement charges, linking to 3rd 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
• Preparing P&L by month, or as a percent of income

  Financial Statements

• Really understanding the QuickBooks financial statements
• Setting up the chart of accounts
• Changing/fixing the chart of accounts
• Applying Cash vs. Accrual accounting in QuickBooks
• Using general journal entries
• Entering reversing journal entries
• Creating and using subaccounts
• Using the Company Snapshot

  Special Features for Accountants & Bookkeepers

• Supporting and understanding the different versions of QuickBooks
• Introduction to the Accountants version of QuickBooks
• Using the toggle feature to simulate your client’s QuickBooks
• QuickBooks journal entries…understand the unique quirks
• Modifying your client’s chart of accounts
• Creating customized financial statements using the Intuit Statement Writer
• Combining your client’s financial statements
• Using the working trial balance feature

  Day 2

  Payroll

• Setting up your client’spayroll
• 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
• Summarizing payroll data in Excel

  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 your client’s multi-user QuickBooks
• Password protecting QuickBooks
• Updating your clients QuickBooks
• Working with Microsoft Word and Microsoft Excel
• Closing the client’s books
• Finding transactions FAST and other time saving features
• Working with the Accountant's Copy feature
• Protecting your client’s 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
• Setting up automatic transactions (memorizing transactions)
• Using credit cards

  Special Features for Accountants & Bookkeepers

• Finding (and stopping) changes to client financial statements
• Using the Employee Organizer: Adding employees, tracking raises & promotions, entering leaves of absence, and terminating employees
• Running reports from the employee organizer
• Using the Employee regulations guide
• Multi-user QuickBooks in Enterprise Solutions: Assigning the administrator, creating roles, setting access levels, and adding new users
• Working with the audit trail in Enterprise Solutions

  Day 3

  Customizing QuickBooks (make QuickBooks REALLY work for your client!)

• Modifying important preferences
• Customizing your client’s 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 credit
• 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 does your client 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
• Use 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
• 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
• 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 client’s 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
• Verifying and rebuilding 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

  Working with Clients

• Common client mistakes and their fixes
• Closing the books
• Getting information to and from your client
• 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
• Cash basis financial statements (what is QuickBooks doing?)
• Special reports you’ll need as the accountant
• What you REALLY need to know to become an advanced user!
• Little known power features in all areas of QuickBooks

  More Features for Accountants

• Correcting common mistakes with undeposited funds
• Changing account types to correct client financial statements
• Using the Client Data Review feature to review a client’s file
• Converting your clients from Quicken
• Using the Fixed Asset Manager: Setting up for a new client, adding assets, and calculating depreciation

  And much more!

        Real Customers…Real Words…Real World Training’s
     Mastering QuickBooks Accountant Essential Curriculum

  Already a fan of QuickBooks but you get one bonus point for teaching me a few things I   did not know.
  No name

  Great course to refresh and get back into the job market.
  L. Start

  I'm not sure I would change anything. I found this training to be very valuable.
  M. Lupkin