self paced study
Course Overview

QuickBooks is the most widely used small business accounting software in Cambodia.
As more enterprises emerge, the knowledge of bookkeeping and accounting software is becoming mission-critical for the success of organizations. Consequently, there is a growing demand for related specialization. QuickBooks Certified User (QBCU) is a globally recognized Certificate issued by Intuit in association with Pearson Vue’s Certiport, to affirm your expertise in QuickBooks. A Certiport survey of accounting instructors revealed that 84% believe students who are preparing for an accounting career should be conversant in QuickBooks, and the same easily applies to aspiring managers and small business owners. Whether you already are, or espouse to be an expert user, it is wise to pack in the credentials to prove your capability. ISE offers you an affordable learning stream to acquire both the skills and the QBCU Certification.

Course Objective Desktop

Course Objectives

ISE’s QuickBooks User Certification Course is designed to impact you with the underlying technical understanding, user knowledge, as well as the hands-on skills to inde pendently command the software and its features for working with customers, vendors, employees, creating bank transactions, etc. The ISE QuickBooks Certification Course is divided into two learning streams: QuickBooks Desktop and QuickBooks Online. Although both streams require slighly different approaches, successful candidates arrive at the same QBCU certification.

Lesson Content

Lesson 1 - Getting Started

  • Introducing QuickBooks
  • Getting Around in QuickBooks
  • All the Accounting You Need to Know
  • About the Chart of Accounts
  • About Assets, Liabilities and Equity
  • Cash versus Accrual Bookkeeping
  • Measuring Business Profitability
  • General Journal Transactions
  • Getting Help while Using QuickBooks
  • Exiting QuickBooks
  • Moving between Company Files

Lesson 2 - Setting Up QuickBooks

  • Creating a QuickBooks Company
  • Starting the EasyStep Interview
  • Entering Company Information
  • Choosing your Company Industry
  • Selecting how Your Company is Organized
  • Customizing QuickBooks for Your Business
  • Indicating What You Sell
  • Entering Sales Information
  • Entering Sales Tax Information
  • Creating Estimates
  • Creating Sales Orders
  • Choosing Remaining Preferences
  • Choosing a Start Date
  • Reviewing the Chart of Accounts
  • Entering Bank Accounts and Opening Balances
  • Completing Company File Setup
  • Adding Customers
  • Adding a Job
  • Adding Vendors
  • Setting Up Additional Accounts
  • Adding Items
  • Entering Historical Transactions

Lesson 3 - Working with Lists

  • Using QuickBooks Lists
  • Editing the Chart of Accounts
  • Editing an Account
  • Adding a Subaccount
  • Customer, Vendor and Employee Centers
  • Custom Contact Fields
  • Working with the Customer Center and the Customers & Jobs Lis
  • Adding Customers
  • Providing Additional Customer Information
  • Sales Tax Settings
  • Transactions from the Customers & Jobs List
  • Working with the Employee Center
  • Working with the Vendor Center
  • Adding Vendors
  • Transactions from the Vendor List
  • Adding Custom Fields
  • Managing Lists
  • Renaming a list item
  • Printing a List
  • Adding or Editing Multiple Items at One Time
  • Working with the Lead Center
  • Things to note about the Lead Center

Lesson 4 - Working with Bank Accounts

  • Writing a QuickBooks Check
  • Using Bank Account Registers
  • Entering a Handwritten Check
  • Transferring Money between Accounts
  • Reconciling Checking Accounts
  • Marking Cleared Transactions
  • Viewing Cleared Checks in the Register
  • Locating Specific Transactions

Lesson 5 - Using Other Accounts in QuickBooks

  • Other Account Types in QuickBooks
  • Entering Credit Card Charges
  • Reconciling a Credit Card Statement
  • Marking Cleared Transactions
  • Paying a Credit Card Bill
  • Working with Asset Accounts
  • Setting Up Asset Accounts to Track Depreciation
  • Tracking a Loan with a Long Term Liability Account
  • Recording a Payment on a Loan
  • Introduction to Equity Accounts

Lesson 6 - Entering Sales Information

  • Using Sales Forms for Payment in the Future
  • Using Sales Forms for Payment at the Time of Sale
  • Filling in a Sales Form
  • Filling in the Line Item Area
  • Completing the Sales Form
  • Repeating a Sale
  • Creating Batch Invoices
  • Entering a New Item
  • Creating New Price Levels
  • Associating Price Levels with Customers
  • Assigning Price Levels to Individual Line Items
  • Using the Income Tracker
  • Creating Single Invoice Letters
  • Generating Reminder Statements

Lesson 7 - Receiving Payments and Making Deposits

  • Recording Payment in Full for a Single Job
  • Entering a Partial Payment
  • Applying One Payment to Multiple Jobs
  • Entering Overpayments
  • Handling Down Payments & Prepayments
  • Making Deposits
  • How QuickBooks Handles the Deposit
  • How to Handle a Customer Bounced Check

Lesson 8 - Entering and Paying Bills

  • Using QuickBooks for Accounts Payable
  • Entering Bills
  • Paying Bills
  • How QuickBooks Records Your Bill Payment

Lesson 9 - Analyzing Financial Data

  • Creating QuickReports
  • Zooming in on a QuickReport
  • Customizing QuickReports
  • Using the Report Center
  • Creating a Balance Sheet Previous Year Comparison Report
  • Filtering Reports
  • Saving Reports as a PDF
  • Using QuickZoom in a Report
  • Memorizing Reports
  • Creating Memorized Report Groups
  • Printing Reports
  • Processing Reports in Groups
  • Processing Multiple Miscellaneous Reports
  • Sending a Report to Microsoft Excel®
  • Creating an Income and Expense Graph
  • Using QuickZoom with Graphs
  • Customizing How Graphs Display

Lesson 10 - Setting Up Inventory

  • Turning on the Inventory Feature
  • Entering Products into Inventory
  • Creating Purchase Orders
  • Getting a Report of Purchase Orders
  • Receiving Inventory
  • Entering a Bill for Inventory Received
  • Manually Adjusting Inventory
  • Setting a Default Markup

Lesson 11 - Tracking and Paying Sales Tax

  • Overview of Sales Tax in QuickBooks
  • Setting Up your Tax Rates and Agencies
  • Grouping Single Taxes Together
  • Identifying Your Most Common Tax
  • Indicating Who and What Gets Taxed
  • Applying Tax to Each Sale
  • Determining What You Owe
  • Paying Your Tax Agencies

Lesson 12 - Doing Payroll with QuickBooks

  • Setting Up for Payroll
  • Setting Up Employee Payroll Information
  • Using Employee Defaults to Store Common Information
  • Setting Up Payroll Schedules
  • Adding a New Employee
  • Running a Payroll Schedule
  • Viewing the Paycheck
  • Printing Paychecks after Leaving Pay Employees Window
  • Printing or Emailing Pay Stubs after Leaving Pay Employees Window
  • Paying Payroll Taxes
  • Writing a Check for Payroll Taxes

Lesson 13 - Estimating and Progress Invoicing

  • Turning on Estimates and Progress Invoicing
  • Creating an Estimate
  • Creating Multiple Estimates
  • Creating an Invoice from an Estimate
  • Displaying Reports for Estimates
  • Updating Job Status
  • Making Estimates Inactive

Lesson 14 - Tracking Time

  • Tracking Time and Mileage
  • Entering Time Data
  • Recording Employee Time on Weekly Timesheets
  • Entering Mileage
  • Invoicing a Customer for Billable Expenses
  • Displaying Project Reports for Time Tracking
  • Viewing Time Data in More Detail
  • Creating Service Items for Subcontractors
  • Recording Nonemployee Time Worked
  • Preparing a Check to Pay for Nonemployee Time Worked

Lesson 15 - Customizing Forms and Writing QuickBooks Letter

  • Creating New Templates
  • Customizing Fields on Forms
  • Changing Field Order on Forms
  • Displaying your Customized Form
  • Designing Custom Layouts for Forms
  • Changing the Position of Fields on Forms
  • Changing Field Widths
  • Changing Fonts, Borders and Colors
  • Previewing New Forms
  • Preparing Collection Letters
  • Editing QuickBooks Letters

Lesson 16 - Working with Multiple Currencies

  • Setting Up Multiple Currencies
  • Buying and Selling Items in Multiple Currencies
  • Creating a Purchase Order in a Foreign Currency
  • Receiving Inventory and Entering a Bill from a Foreign Vendor
  • Creating an Invoice for a Multicurrency Transaction

QuickBooks Online

QuickBooks Setup And Maintenance

  • What information QuickBooks does and does NOT require when creating a new QuickBooks account
  • What lists can be imported and the basic steps to do so (including what is NOT imported)
  • How to modify/change basic elements after set up (e.g. accounts, company address, etc.)
  • How to setup users including a basic knowledge of the access rights available for different user types.
  • How to navigate or move around QuickBooks. A student should know: 
    •  What info and functionality is found in the 3 key access points – navigation bar,     global create, and company settings     
    • What’s located on the home page and how to control what is or isn’t seen     
    • What each button (e.g. save, more, etc.) does on major forms (e.g. invoice, bill, etc.)

List Management

  • The names of the major lists in QuickBooks and what type of information is tracked on each.
  • How to manage lists (Customers, Chart of Accounts, Products and Services, etc.). This includes:   
    • Who should appear on which names list (e.g. employees or customers) and how to handle situations where the same person/ company should be on more than one list.     
    • Adding new list entries     
    • Removing list entries (including what QuickBooks does if an entry has a balance) Editing list entries     
    • Merging list entries (including the basic rules of what can and can’t be merged)     
    • Which names MUST appear on which forms (i.e. which names are required on specific transactions otherwise QuickBooks will NOT save the transaction)

Sales/Money-In

  • Knowing the advantages of using built in sales forms (e.g. invoice) over other methods (e.g. Bank Deposit or Journal Entry)
  • Completing the Invoicing (A/R) and Sales Receipt (no A/R) workflow from sale to bank deposit.
  • A student should know the differences between these methods and when to use each.
  • How QuickBooks impacts and uses the Undeposited Funds, Accounts Receivable, and the bank accounts in the invoicing cycle.
  • How to invoice for billable expenses (includes how to turn this feature on and record expenses to begin the process)
  • How and why to record a customer credit

Purchases/Money-Out

  • How to set up a Product or Service to be used on purchase Forms and when this is appropriate
  • How this set up allows QuickBooks to perform the appropriate accounting behind the scenes to correctly impact Financial Statements
  • How to set up Vendors When to use the following transactions/workflows.
  • This includes knowing the steps to record them in QuickBooks when the company does NOT have connected bank accounts (online banking). And how each affects the Vendor’s Balance    
    • Purchase Orders     
    • Entering and paying bills (A/P)     
    • Recording Checks (hand written or printed)   
    • Recording Credit and Debit Card transactions     
    • Recording EFT’s, online payments, wire transfers, etc.     
    • Vendor Credits When and how to void vs. delete a check
    • How to use the Vendor page and reports to identify how much your company owes, and when payment is due.

Basic Accounting

  • What the basic financial statements are and have a basic understanding of their sections and what they mean.
  • The difference between cash and accrual reports
  • How and why to set a closing date
  • How to enter a Journal Entry if asked to do so by an accountant (students do not need to understand how to determine which accounts to debit or credit)
  • How to use the Audit Log to determine changes made by specific users.

Customization/Saving Time

  • How to set up QuickBooks to track income and expenses for multiple locations, or to separate transactions by class (e.g. department, profit center, etc.)
  • How to create custom fields on invoices.
  • How and why to make transactions recurring, including which transactions can be made recurring.
  • Which forms can be customized and the steps to customize a sales form
  • How to use a keyboard shortcut to find a list of keyboard shortcuts.
  • The time saving benefits of using QuickBooks online. These include:
    • Using QuickBooks on phones and tablets (IOS and Android). Students just need to be familiar with basic functionality and understand that QuickBooks mobile can use a mobile device’s camera, phone, and GPS to save time.
    • Connecting Apps to expand what QuickBooks does. Students should know where to find apps and know that apps expand what QuickBooks does and automatically synch data with QuickBooks.
    • Theabilitytohaveusers/employeeswith different operating systems (e.g. Mac vs. P.C.) and web browsers (e.g. Chrome vs. Safari) still access the same data.
    • Not needing to backup, and no IT issues (e.g. reinstalling software in cases of crashes or new computer purchases) usually associated with desktop software.

Payroll

  • The differences between the Payroll Services available from QuickBooks
  • How to set up Payroll (including employees, Federal and State taxes and basic Payroll deductions) using the Payroll Setup Wizard.
  • How to set up an employee’s earnings and sick or vacation time
  • How to track sick or vacation time (accruing hours and using “banked” hours)
  • How and why to setup Payroll Schedules
  • How to run Payroll
  • How and why to pay Payroll Liabilities
  • How to prepare payroll forms (941, W2) in QuickBooks
  • Track time and use it for payroll or for invoicing customers

Reports

  • Why and how to use the Report Center
  • How to customize reports (report modifications, collapsing subaccounts, etc.)
  • The basic question that each report answers (basic understanding of each report)
  • How and why to process multiple reports
  • How and why to send reports to Excel (understand and use the basic and advanced tab)
  • How and why to process multiple reports
  • How to memorize reports

Basic accounting

  • What the basic financial statements are and have a basic understanding of what they mean.
  • The difference between cash and accrual reports
  • How and why to set a closing date
  • How to enter a Journal Entry if asked to do so by an accountant (they do not need to fully understand what accounts to debit or credit)

Customization/Saveing Time and Shortcuts

  • How and why to memorize transactions (automatically enter)
  • How to set up multiple users and what level of access can be granted or denied
  • How and why to create custom fields (customers, vendors, and employees)
  • How to customize an invoice

In addition to fundamental knowledge in accounting and bookkeeping, you are expected to have some basic proficiency in the use of Windows PC and online browsing . For those without an Accounting background, we recommend to first go through a course to understand best practices in accounting. For those with accounting knowledge but no PC skills, please consider our other courses with Microsoft Excel and learning to work with worksheets

Course Prerequisites

QuickBooks Certified User badges

Digital badges are web-enabled versions of a credential, certification or learning outcome.
Representing your credential as a badge gives you the ability to share your skills online in a way that is simple, trusted and can be easily verified in real time.
QuickBooks certifications are some of the most requested skills in online job postings. Your digital badge makes it easy for you to validate abilities with potential employers on social media sites such as LinkedIn, Facebook and Twitter, as well as email and online portfolios.
When you earn one of the QBCU certifications you will be notified of the corresponding digital badge. Accept and use your digital badges to tell potential employers, academic institutions, colleagues and peers about your QuickBooks credentials.

There are currently digital badges available:




 

Flash your badge

Acclaim is the digital badging platform used by Certiport. It helps students move forward professionally by quickly establishing credibility for opportunities in higher education and the job market. Each badge contains verifiable data that tells employers and admission committees what you did, who says you did it, and why it matters. What does this mean for you? Watch the video to find out.



Course Fee

Self-paced QuickBooks Study

$45.00
GMetrix Practice Tests for one of the following certification exam

This product includes a single user license for GMetrix Practice Tests for one of the following certification exams: Intuit QuickBooks Desktop Certified User, Intuit QuickBooks Desktop 2017 Certified User, or Intuit QuickBooks Online Certified User.

Learn more
$156.00
QuickBooks Certified User Exam Voucher+Retake+GMetrix Practice Tests

This product includes one Intuit® QuickBooks Certified Exam voucher with a retake + GMetrix Practice Tests.

Learn more
$225.00
Self paced QuickBooks Study

This online, video-based course prepares candidates to take the QuickBooks Online or the QuickBooks Desktop Certified User exam. Includes 12-16 hours of training including videos, online workbook, and quizzes.

Learn more