Certification

Homepage Prior Surveys Training Classes & On-line Classes Learning Products QB Shared Files Map & Directions Certificate Field Service Seminar Dates Telephone Support Annual Support Contact us Who we are Blog Guest Book Other Services

In order to receive a certificate:

1.  Student must finish all review questions at the end of each lesson plan.
2.  Pass the exam with a score of 80% or better.

Review Questions

Lesson 1—Getting started

    1. List the three main ways you enter data in QuickBooks.
    2. List three ways to access features in QuickBooks.
    3. What bookkeeping method does QuickBooks use to create most reports?
Lesson 2—Setting up QuickBooks
    1. The ________________ section of the EasyStep Interview is where you indicate whether you want to use certain QuickBooks features.
    2. Search the onscreen Help index for information on how to turn on the inventory feature in QuickBooks.
Lesson 3—Working with lists
    1. Match the information on the left with the appropriate QuickBooks list on the right.
     
    1. A subcontractor A. Customer:Job list 
    2. Someone who purchases your goods or services B. Chart of accounts 
    3. A new hire C. Vendor list 
    4. Checking account D. Employee list 

    2. Add the following customer using the data below:

    - Customer Name: Alla Rozenvasser
    - Opening Balance: $234.00
    - Company Name: Rozenvasser Advertising
    - Contact: Alla Rozenvasser
    - Bill to: 300 Main Street, Suite #3, Middlefield, CA 94432
    - Phone: 415-555-6767
    - Fax: 415-555-9090
    - Alt. Contact: Shannon Stubo
    - Type: Commercial
    - Credit Limit: $2500
    - Terms: Net 15
    - Tax Item: San Domingo

    3. Add a new vendor using the data below:

    - Vendor: Martin Drywall
    - Contact: Sean D. Martin
    - Address: P.O. Box 76, Middlefield, CA 94432
    - Phone: 415-555-5432
    - Fax: 415-555-6565
    - Account: 082-4343
    - Type: Subcontractors
    - Terms: Net 30
     -Credit Limit: $1,000.00

Lesson 4—Working with bank accounts
    1. Use the checking account register to enter a handwritten check for $76.95. Use the next available check number and make the check payable to Express Delivery Service, for delivery of a new sign. Assign the check to the Freight & Delivery expense account.
    2. Write a QuickBooks check to Bayshore Water for $143.87 to pay this month’s water bill. Assign the check to the Utilities:Water expense account.
Lesson 5—Working with other accounts
    Assume that the owner of Rock Castle Construction has taken out a loan and purchased a computer system for $15,000. He wants to track the accumulated depreciation and cost of the system in two separate fixed asset accounts.
    1. Create a fixed asset account called Computer System and two subaccounts—one for Cost and one for Accumulated Depreciation.
    2. Create a long-term liability account to track the loan. Enter the amount of the loan as an increase in the asset’s Cost account. Assign the transaction to the loan liability account.
Lesson 6—Entering sales and invoices
    1. From which list (or lists) does QuickBooks get the information for A, B, and C in the graphic below?
    2. List the item types used in the line item area of the invoice above.
    3. Create an invoice for Rock Castle Construction that uses the new Repairs:Plumbing line item. Create the invoice for a new customer by adding information to the Customer list “on the fly.”
    4. Filling out a sales receipt is similar to filling out an invoice form. Create a sales receipt for a customer of Rock Castle Construction.
    5. After you create the sales receipt, open the Undeposited Funds account register to see the transaction QuickBooks created.
Lesson 7—Receiving payments and making deposits
    1. Create an invoice for Bryan Ruff’s utility shed job. You may add items to Rock Castle Construction’s Item list as needed.
    2. After you’ve invoiced the customer, record a payment from him in the Receive Payments window.
    3. Record Rock Castle Construction’s deposit of the payment.
Lesson 8—Entering and paying bills
    1. Write a check to a vendor, assigning the amount to more than one expense account.
    2. Record a bill in the Enter Bills window, and then view the bill transaction in the accounts payable register.
    3. View the bill in the A/P register.
    4. Pay the bill using the Pay Bills window.
Lesson 9—Analyzing financial data
    1. Create a QuickReport on an item in one of Rock Castle Construction’s lists.
    2. Rock Castle Construction wants to create a report that shows how much they have spent on lumber for projects during the month of November, 2003. Create an item summary purchase report, covering the date range from 11/01/2003 to 11/30/2003.
    3. Filter the report to show only Rock Castle Construction’s purchases for Lumber.
    4. Batch process the balance sheet, profit and loss statement, and statement of cash flows using the Process Multiple Reports window.
Lesson 10—Setting up inventory
    1. Enter a new inventory item using the following information.
    - Item Name/Number: Kitchen counter
    - Purchase Description: Kitchen counter
    - Cost: $280
    - COGS Account: Cost of Goods Sold
    - Preferred Vendor: Patton Hardware Supplies
    - Sales Description: Same as Purchase Description
    - Sales Price: $340.00
    - Income Account: Construction:materials
    - Asset Account: Inventory Asset
    - Reorder Point: 5
    - Qty on Hand: 6
    2. Create a purchase order for 20 Standard doorknobs.
    3. Receive the 20 Standard doorknobs into inventory and record the bill for the doorknobs.
    4. Process the bill and pay for the 20 Standard doorknobs.
Lesson 11—Tracking and paying sales tax
    1. Create an invoice for Pretell Real Estate’s 155 Wilks Blvd. job, for 10 interior wood doors and 2 exterior wood doors.
    2. After you record the invoice, open the sales tax payable register to see how QuickBooks has recorded the tax due from the invoice.
Lesson 12—Doing payroll with QuickBooks
    1. Add a salaried employee to the employee list. Enter the employee’s personal information, federal and state tax information, and at least one additional paycheck deduction.
    2. Process a paycheck for the new employee. Then, view the check in QuickBooks. Open at least one payroll liability account register to see how the paycheck changes the account’s balance.
    3. Select one of the payroll expense accounts from the chart of accounts. Create a QuickReport for that expense account.
Lesson 13—Estimating and progress invoicing
    1. Create an estimate for the 75 Sunset Rd. job for Pretell Real Estate. The estimate is for 6 hours of installation labor, 18.5 hours of plumbing work, and 4 hours of drywall work.
    2. Create a progress invoice for 50% of the estimate just created for the 75 Sunset Rd. job for Pretell Real Estate.
Lesson 14—Tracking time
    1. Create a single activity timesheet for Gregg Schneider, for eight hours worked on the Anton Teschner Sun Room job.
    2. Transfer the time you just entered for Gregg Schneider onto an invoice for the Teschner Sun Room job.
    3. Display a time by name job report to see how many hours Gregg Schneider has worked for each job.
Lesson 15—Customizing forms and writing QuickBooks Letters
    1. Customize the Sales Receipt form to change the default title on the header from “Sales Receipt” to “Cash Sale.”
    2. Using the Layout Designer, make the columns for QTY and Rate narrower so the Description field is wider.
    3. Customize the P.O. form to include the Terms field.