Home

Contact Vitae

Courses

Office Hours

 CTBU 106~QuickBooks

 

Course Number:

CTBU 106

Course Title:

QuickBooks

Area(s) of Study:

Business

Print

Document

 

Prerequisites:

CTBU 108, CTBU 109

Total Hours:

48  Lecture: 48  Lab: 0  Shop: 0

Credits:

3

Required:

Varies with program of study

Elective:

Yes

Credit by Exam Available?

No

Alternative Learning Opportunities:

Online

Prepared by:

Randy Schmitz

Date:

January 7, 2008

 

  Catalog Course Description 

Studies QuickBooks, an accounting system for small business owners and bookkeepers. Topics of this course include creating a company, setting up company lists, editing a preset chart of accounts, entering opening balances, entering sales and invoices, receiving payments and making deposits, handing expenses and bills, working with bank accounts, analyzing financial data, tracking and paying sales tax, managing inventory, and preparing payroll.

  Course Goals (Expected Outcomes)  

This course is intended for students who want to learn about how accounting information is both used and created with the QuickBooks software. The course of instruction provides the following:

Help students learn or review fundamental accounting concepts and principles through the use of QuickBooks and the analysis of business events

Enable students to view financial statements fro a user perspective

Provide students a means to investigate the underlying source documents that generate most financial accounting information

Provide students a means of exploring some managerial aspects of accounting

Upon completion of this course,

students are expected to know basic QuickBooks terminology, basic file management in QuickBooks, navigation techniques, and other essential skills such as printing and correcting mistakes.

students are expected to be able to create balance sheets for different dates, investigate detail supporting balance sheet items, and print balance sheets for distribution.

students are expected to be able to create income statements for different accounting periods, investigate detail supporting income statement items, and print income statements for distribution.

students are expected to be able to create cash flow statements for different accounting periods, investigate detail supporting cash flow statement items, and print cash flow statements for distribution.

students are expected to know how to create and print reports supporting the financial statements including an accounts receivable aging report, a customer account balance report, an inventory valuation report, an accounts payable aging report, and a vendor balance report.

students are expected to know how to create a new company file and add new customers, vendors, employees, accounts, and items. This effort should reinforce the system’s nature of accounting and, in doing so, help students grasp the various steps involved in setting up a business.

students are expected to record cash-oriented transactions classified as financing, investing, and operating activities.

students are expected to know essential accrual accounting concepts including the concepts of accruing revenues and expenses emphasizing the revenue recognition, matching, and expense recognition.

  Course Objectives Outline (Competencies) 

I.  Startup procedure

A.  Hardware and software review

Describe the location and operation of various classroom hardware

B.  Software installation

Describe the installation and boot procedure for course software; create network folders; backup student files

C.  Restore and open a QuickBooks file

D.  Application window

Explain and describe the software application window including such menus, buttons and controls as:

Menu bar, Toolbar

Command menus

Access keys

Shortcut keys

 Text, list, spin boxes

Drop-down lists

Option buttons

Check boxes

Command buttons

E.  Backup and close a QuickBooks file

F.  Printing, Help, and Homepage features

II.  QuickBooks Balance Sheet

Explain and demonstrate at the computer the following operating activities:

Create a balance sheet

Create a comparative balance sheet

Create a summary balance sheet

Use Quickzoom

Modify the balance sheet report form

Memorize the balance sheet report form

Print the balance sheet

III.  QuickBooks Income Statement

Explain and demonstrate at the computer the following operating activities

Create a income statement

Create a comparative income statement

Create a summary income statement

Modify the income statement report form

Print the income statement

IV.  QuickBooks Statement of Cash Flows

Explain and demonstrate at the computer the following operating activities:

Create a statement of cash flows

Format and print the statement of cash flows

V.  Supporting Reports

Create, print and analyze various other QuickBooks reports such as:

Accounts receivable aging report

Customer account balance summary

Inventory valuation summary

Accounts payable aging report

Vendor account balance summary

VI.  Set up a business using QuickBooks

  1. Create a new company file using the EasyStep interview

  2. Set up company preferences

  3. Set up company items

  4. Set up customers, vendors and accounts

  5. Set up employees and payroll

  6.  Create a backup file

VII.  Record business activities

A.  Cash oriented financing activities

Owner investment

Long-term borrowing

B.  Cash oriented investing activities

Short-term investments

Fixed assets

C. Cash oriented operating activities

Purchase orders

Inventory

Prepaid expenses

Unearned revenue

Cash sales

Cash receipts

Cash payments

Payroll activities

VIII.  Adjusting entries

A.     Explain horizontal and vertical analysis

B.     Identify the transactions included in each of the three classifications of the statement of cash flows

C.     Explain how to interpret each of the financial statement analysis reports

IX.  Departmentalized Accounting

Prepare entries necessary to prepare (improve) periodic financial statements such as:

Accrual of revenue and/or expenses

Deferred expenses

Unearned revenue

Adjustments generated from bank reconciliation

  Specific Instructional Materials, References & Text List  

Using QuickBooks Pro 2007 for Accounting, Glenn Owen, Thomson South-Western Publishing Company, 2008.

  Outcomes Assessment and Grading Procedures  

End of chapter assignments (questions, exercises, problems, cases) are worth a total of one hundred points. Five points will be deducted for any assignment that is missing or incomplete.

Exams are scheduled throughout the course. Each test is worth 100 points and will be given at the scheduled time only.

The final grade will consist of the average of the test scores and the homework grade.

Satisfactory completion of this course requires consistent classroom attendance and active participation. Time outside of class may be necessary, but certainly should not replace classroom time.

  Grading  
92 - 100 A

82 -  91

B
70 -  81 C
60 - 69 D
Below 60 F
 

  Classroom Policy  

If an instructor is absent from class, the class is not cancelled. In this course, continue working on the current chapter assignment or reading. If it happens to be a test day, continue studying for the test or begin reading the next chapter.

There is a policy of no food or drinks in any classroom or lab area in this building.

Only in extreme cases are children allowed in classroom or laboratory facilities, and then only with approval of the instructor prior to class.

Cellular phones, pagers, various media players, and similar devices are prohibited in the classroom and laboratory facilities. Turn them off before entering the classroom. Each use will result in a 20 point deduction from your final point total.

Students with disabilities, whether physical, learning or psychological, who believe that they may need accommodations in this course or classroom are encouraged to contact Disability Support Services as soon as possible to ensure that such accommodations are implemented in a timely fashion. Please contact DSS to verify your eligibility for any classroom accommodations and for academic assistance related to your disability by calling 657-2283. The DSS contact person at the College of Technology is Kelley Williford, Room A071. She is available Monday-Friday, 9 a.m.-2 p.m. Testing arrangements must be made prior to the first exam.

Free tutoring services for students are available in the COT Academic Support Center, Room A035, Monday through Friday, 8 a.m. – 5 p.m. The Academic Support Center on the Poly Drive campus is open from 8 a.m. – 8 p.m. Monday – Thursday, 8 a.m. – 5 p.m. Friday, and 9 a.m. – 12:00 p.m. Saturday.  Tutors specialize in math, writing, anatomy and physiology, and other specialty areas for specific majors. See http://www.msubillings.edu/asc/ for more information or call 247-3022 (COT) or 657-1641 (Poly Drive).

Students’ rights and responsibilities, as well as the Code of Conduct are outlined in the Montana State University- Billings Student Handbook. Students should be familiar with the rights and responsibilities of students in the Academic Community.

MSU-B supports a drug free environment. Any student who demonstrates a pattern of behavior that suggests drug or alcohol abuse will be asked to leave class and must participate in a counseling program prior to continued attendance. Continued abuse may result in reprimand, probation, restriction, suspension or expulsion.

 

Print

Document

 

Home

Contact Vitae

Courses

Office Hours