INTUIT PROADVISOR PROGRAMQuickBooks Desktop Certification
Getting Started GuideTable of ContentsTABLE OF CONTENTSQuickBooks ProAdvisor Training Objectives .1What’s in the Workbook? .2Chapter 1 - introduction to quickbooks .3Objectives . 3QuickBooks Company Files . 4Open an Existing Company File . 4Updating Quickbooks . 6Automatic Update . 6Update Now . 7QuickBooks Product Information Window . 8Navigating QuickBooks . 10Getting Around Using the Home Page . 10Icon Bar . 11Left Icon Bar . 11Top Icon Bar . 13Chapter 2: how your clients use quickbooks part 1 . 16Objectives . 16Items in QuickBooks. 17Basic Item Types . 17Setting Up Service Items . 18Non-Inventory Parts . 19Setting Up Other Charge Items . 20Group Items . 21Objectives . 23Setting up Customers . 23
Getting Started GuideTable of ContentsAdding Multiple Customers From Excel . 25Creating Invoices . 25The Transaction Ribbon . 26Email Invoices . 27Setup Email . 27Edit Email Templates . 29View Sent Emails . 30Customizing Invoices. 31Basic Customization . 31Additional Customization. 33Layout Designer. 36Receiving Customer Payments . 37Undeposited Funds . 38Making Deposits . 39Sales Receipts in QuickBooks . 41Deposit Summary . 42Creating Credit Memos for Customers. 43Apply Credit Memo to an Invoice . 44Issue a Customer Refund . 45Retain as an Available Credit . 45Customer Statements . 46Collections Centre . 47CHAPTER 3 - HOW YOUR CLIENTS USE QUICKBOOKS PART 2. 48Vendor Centre . 48Entering Expenses . 52Entering Bills . 53
Getting Started GuideTable of ContentsEnter Bills details . 54Bills & Accounts Payable Preferences . 55The A/P Aging Summary Report . 56Unpaid Bills Detail Report. 57Paying Bills . 58Bill Payment Methods . 60Bill Credits . 61Applying Bill Credits . 62Print Bill Payment Stub . 64Credit Cards . 64Credit Card Account . 64Entering Credit Card Charges . 66Credit Card Refunds . 67other expense transactions in quickbooks . 68Write Cheques . 68Debit Card Transactions . 69Automatic Withdrawals & Additional Payment Types . 71Memorized Transactions . 72Transfer Funds . 73Reconciliations and Online Banking . 74Objectives . 74Reconciling a Bank Account . 74Reconciliation Reports . 76Reconciliation Summary Report . 77Reconciliation Detail Report . 78Handling Returns to Vendors workarounds . 87
Getting Started GuideTable of ContentsSetup Petty Cash . 90Reimbursing Employees . 92Employee Expense Report . 92Setup the Employee as a Vendor . 93Enter the Expense Report in QuickBooks . 94Owner’s Purchases . 96Setup a Shareholder Loan Account . 96Setup Owner’s Cash Account . 97Making Purchases Using Owner’s Cash. 98Chapter 4: Setting up client files . 100Create a New Company File. 100Chart of Accounts . 104Setting Up Accounts . 104Setting Up & Depositing a Bank Loan . 107Setup a Loan Account . 107Deposit the Loan Proceeds . 109Editing an Income Account . 110Setting Up Expense Accounts . 111Setting Up Sub Accounts . 112Sales Tax . 112Managing Sales Tax . 112Sales Tax Vendors . 113Sales Tax Items . 114Sales Tax Codes . 116chapter 5 - advanced features in quickbooks . 117Objectives . 117Non Posting Transactions . 117
Getting Started GuideTable of ContentsTurn on Estimates in QuickBooks . 118Entering Estimates Into QuickBooks . 119Reporting on Estimates . 120Closing Estimates. 120Estimate to Invoice . 122chapter 6 - troubleshooting & period end Tasks in QuickBooks . 124Objectives . 124Filing GST/HST . 124QuickBooks at Year-End . 127Journal Entries at Year-End . 128Reviewing Transactions . 129Search for Transactions . 130Editing Transactions . 131Voiding & Deleting Transactions . 132Reports in quickbooks . 134Profit & Loss (Income Statement) . 135Balance Sheet . 138Sales by Customer Summary . 139Sales by Item Summary . 140Company Snapshot . 141Open Invoice Report. 143The A/R Aging Summary Report . 143Profit & Loss Report . 144Profit & Loss by Class Report . 146Expenses by Vendor Detail Report. 147Sales by Customer Detail . 148
Getting Started GuideTable of ContentsCustomizing Reports . 149Memorizing Reports . 153Export Reports to Excel . 155Configuring your Backup . 158chapter 7 - saving time in quickbooks . 159shortcuts . 159Document Centre . 160Add a Document to the Document Centre . 160Attach a Document . 161Managing Lists. 162Deleting List Entries . 163Making List Entries Inactive . 164Making List Entries Active . 165Resorting Lists . 166Merging List Items . 167NSF Cheques . 169Recording Payments on Loans . 171
QuickBooks ProAdvisor Training ObjectivesQUICKBOOKS PROADVISOR TRAININGOBJECTIVESQuickBooks is a powerful accounting program designed to help small businesses manage theirday to day accounting and to find valuable information needed for making good decisions. It isalso critical that QuickBooks ProAdvisors, accountants, bookkeepers and consultants gain a deepunderstanding of QuickBooks to be able to support their clients. At Accounting Cycle ourobjectives for this Learn QuickBooks seminar are the following: Setup your clients QuickBooks files correctly Help your clients manage their day to day accounting data entry Learn the best practices for using QuickBooks Learn how to get information from QuickBooks to help you make good business decisions Answer your tough questions about QuickBooks1
WHAT’S IN THE WORKBOOK?This QuickBooks ProAdvisor Certification training workbook, introduces you to QuickBooks Intuit’s easy to use, powerful accounting software for small businesses. In this workbook, wewant to help you better understand the software that will improve how you manage your clientfiles. Specifically, we want to help you: Setup a QuickBooks file including customers, vendors, accounts, items, etc. Setup QuickBooks to effectively manage your business Create sales transactions including sales receipts, invoices, customer payments etc. Create purchase transactions including bills, cheques and credit card entries Manage your banking information including deposits and bank reconciliations Manage your sales tax including HST, PST and GST Handle special transactions that you might come across in your day to day use of QuickBooks Create the reports you need to track your clients business performanceThe screen captures and step-by-step instructions in this workbook were created withQuickBooks Premier. Your display may differ, and some instructions may vary slightly if you areusing a different edition.
Chapter 1 - introduction to quickbooksCHAPTER 1 - INTRODUCTION TO QUICKBOOKSOBJECTIVESGetting started in QuickBooks requires understanding how to open your QuickBooks files andhow to get around the software. Every business must setup a unique QuickBooks file and workwith that file. After setting up your file you can start to use it to record your day to dayaccounting entries. Understanding how to edit preferences and company information is importantfor every company when getting started using QuickBooks.In this chapter you will learn about: Opening QuickBooks company files Creating a new QuickBooks company file Getting around QuickBooks using the Home Page QuickBooks icon bar Company information in QuickBooks QuickBooks preferences Keyboard Shortcuts Updating QuickBooks QuickBooks Product Information3
Chapter 1 - introduction to quickbooksQUICKBOOKS COMPANY FILESWhen you setup your company for the first time in QuickBooks, QuickBooks creates a file foryou. The file will contain your company name and will have the extension .QBW. This stands forQuickBooks working file. This is the file where your day to day transactions and accountingentries will be saved. As you work in QuickBooks your information is saved in your QuickBooksfile.OPEN AN EXISTING COMPANY FILETo open your QuickBooks file:1. Choose File.2. Choose Open or Restore Company 3. Choose Open a Company File.4. Select Next.4
Chapter 1 - introduction to quickbooks5. Locate the company file on your computer.6. Click Open.7. QuickBooks opens your company file.5
Chapter 1 - introduction to quickbooksUPDATING QUICKBOOKSPeriodically QuickBooks releases updates for various reasons including product fixes, payroll taxtables, and new or improved features. It is important to update QuickBooks to ensure that youhave the most updated version.There are two ways to update QuickBooks. You can update automatically or downloadimmediately.AUTOMATIC UPDATEWith this method, QuickBooks automatically downloads the updates to your computer.QuickBooks periodically checks the Intuit Server for new updates and downloads any updates asthey become available. To setup QuickBooks to automatically update do the following:1. Go to Help and then click Update QuickBooks.2. Click Options.3. Select Yes to Automatic Update.Note: If you are working in multi-user mode you can choose Shared Download. Thisfeature will share the downloads with other computers on your network to ensurethat each computer has the same version and release number.6
Chapter 1 - introduction to quickbooksUPDATE NOWIn addition to QuickBooks automatic update you have the option of updating immediately. Toupdate immediately:1. Go to Help and then click Update QuickBooks.2. Click Update Now.3. Click Get Updates.Note: To complete the update process you must restart QuickBooks. When yourestart QuickBooks you will be prompted to install the updates.7
Chapter 1 - introduction to quickbooksQUICKBOOKS PRODUCT INFORMATION WINDOWTo make sure you have the latest product updates, you can open and review the productinformation window. To open this window:1.Press CTRL 1 or press F2.2.Review the top Product line for the QuickBooks version and release number.8
Chapter 1 - introduction to quickbooksNAVIGATING QUICKBOOKSEvery QuickBooks screen has the Title Bar at the top. The title bar shows the name of thecompany, the version of QuickBooks you’re using and may also show which window you’reviewing.Below the Title Bar is the Menu Bar. When you click on a menu category, a sub-menu opens up.GETTING AROUND USING THE HOME PAGEThe Home page is the default window that displays when you open QuickBooks. The Home pageprovides the big picture of how your essential business tasks fit together and flow to make youraccounting in QuickBooks easy. It makes your work in QuickBooks faster because it organizestasks into groups.It helps you work faster because you can: Click an icon to perform the task or function See the next logical steps by following the arrows between tasksThere are five sections on the Home Page. They represent the major areas of accounting. They areVendors, Customers, Employees, Company and Banking.Note: The Home Page also lets you see important account balances and viewreminders of tasks related to your accounting.10
Chapter 1 - introduction to quickbooksICON BARThe Icon Bar contain
Keyboard Shortcuts Updating QuickBooks QuickBooks Product Information . Chapter 1 - introduction to quickbooks 4 QUICKBOOKS COMPANY FILES When you setup your company for the first time in QuickBooks, QuickBooks creates a file for you. The file will contain your company name and will have the extension .QBW.
New Company Setup 3 3. Click Next. NOTE The checkbox labeled I’ve been using QuickBooks Desktop and want to bring in my data refers to converting data from the QuickBooks Desktop version to QuickBooks Online. This is not relevant for this class. QuickBooks asks you to choose the areas of QuickBooks you’ll use in your company.File Size: 2MBPage Count: 22Explore furtherChecklist of what you'll need to set up a new . - Intuitquickbooks.intuit.comChapter 1 New Company Setup - Intuitwww.intuit.comA Basic Guide to Quickbooks for Beginners: Key Tips for .watermarkeservices.comNew Client Checklist - QuickBooksquickbooks.intuit.comIntuit QuickBooks Certified User Study Guidewww.teknimedia.comRecommended to you b
QuickBooks account, either QuickBooks Online or QuickBooks Desktop version. If you do not have an existing QuickBooks account, please visit the Intuit QuickBooks website to create an account. Note: Intuit QuickBooks Online is a monthly, fee-based subscription service, which is in addition to the Sync for QuickBooks service offered by Authorize.Net.
Topics Step by Step Workflows 1. Product Overview Benefits of using QuickBooks Online Know the features of your QuickBooks Online subscription 2. Importing Data Export QuickBooks Desktop data to QuickBooks Online Become familiar with importing lists into QuickBooks Online 3. Setting Up Your Company Explore how to add users to QuickBooks Online
QuickBooks Enterprise Solutions QuickBooks Premier (2002 or later) QuickBooks Pro (2002 or later) QuickBooks Simple Start (2006 or later) Canadian editions of QuickBooks Pro, Premier, or Enterprise (2003 or later) UK editions of QuickBooks Pro or Accountant Edition (2003 or later) Please note: QuickBooks Web Connector 188.8.131.52 and older .
Version 184.108.40.206 U.S. editions of QuickBooks Financial Software products QuickBooks Enterprise Solutions QuickBooks Premier (2002 or later) QuickBooks Pro (2002 or later) QuickBooks Simple Start (2006 or later) QuickBooks Point of Sale (v.4.0 or later) Canadian editions of QuickBooks (2003 or later)
QuickBooks EasyStart User Guide 4 To start QuickBooks, double-click the QuickBooks icon on your desktop, or click the Windows Start button and then click QuickBooks from the Programs group. Register your copy of QuickBooks Under the Help Menu, select Register QuickBooks. Registration must be made within 30 days of product installation. It only
Intuit QuickBooks Payroll 1 About this guide The illustrations and procedures in this guide are for customers using Simple Start 2009; however, Intuit QuickBooks Payroll works with QuickBooks Pro and Premier 2009, 2008, and
Edexcel IGCSE Accounting Pg 10 1.3 The accounting equation learn a simple Statement oflist examples of Refer to Sec Syllabus assets and Financial Position(horizontal/T The Principles of liabilities style) which explains the basic Double-Entry accounting equationclassification of . items as assets calculate the value of assets, Go For Accounting Pg and liabilities liabilities and capital using .