![]() |
||
|
CTBU 106~QuickBooks |
|
|
|
Course Number: |
CTBU 106 |
||
|
Course Title: |
QuickBooks |
||
|
Area(s) of Study: |
Business |
||
|
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 |
|
|
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. |