Certification

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?

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.