ACCT 100 - QuickBooks and Computerized Accounting

Transfer Status

NT

Prerequisite

ACCT 2 or ACCT 20

Unit(s)

3.00

• Lecture: 51.00 Contact hours/102.00 Out of class hours/153.00 Total hours/3.00 Unit(s)
• Total: 51.00 Contact hours/102.00 Out of class hours/153.00 Total hours/3.00 Unit(s)

Course Description: This course provides a transition from a manual accounting system to a typical computerized system. The objective is to collect, summarize and communicate information to decision makers and users via QuickBooks accounting software in comparison to other accounting software programs. Microsoft Excel will be utilized for data summation. Typical documents produced consist of purchase orders, checks, invoices, deposit slips, job cost reports, financial statements, bank reconciliations, payroll tax returns and 1099 forms.

Upon successful completion of this course, the student should be able to:

1. Demonstrate proficiency with QuickBooks software by recording various business transactions using QuickBooks.
2. Set up a new or existing business’ accounting records on QuickBooks.
3. Explain the underlying accounting concepts when recording transactions.
4. Determine and produce the type of report or document needed for a business transaction.
5. Analyze and adjust/correct data so that reports are accurate.
6. Employ organizational skills to aid in the management of a small business.
7. Utilize Microsoft Excel for data summation.
8. Apply skills learned in Quickbooks to other accounting software programs.

Topic Titles / Suggested Time Topic

Lecture/Activity

1. Class Activities
2. Discussion
3. Homework: Students are required to complete two hours of outside-of-class homework for each hour of lecture
4. Instructor Demonstrations
5. Lecture
6. Multimedia Presentations

1. Exams/Tests
2. Quizzes
3. Homework
4. Class participation
5. Lab Projects
6. In-class assignments, Practice sets

Reading Assignments

1. Read the Banking chapter. Be prepared to discuss the need for bank reconciliations and how QuickBooks' bank reconciliation process differs from manually preparing a bank reconciliation.
2. Use QuickBooks' help function to obtain information about backup and portable files. Print and read the information. Be prepared to discuss the differences between backup and portable files.

Writing Assignments

1. Prepare a 2 page memo explaining which payroll service Rock Castle Construction should use (Basic Payroll, Enhanced Payroll, or Assisted Services). Be sure to address the price of each service, the features, and the need in order to give an informed and convincing recommendation.
2. Prepare a 3-page report to summarize the ratio analysis performed on Rock Castle Construction and explain your recommendations based on this analysis.  Be prepared to discuss in class.

Out-of-Class Assignments

1. Prepare paychecks for Larry's Landscaping Co. using Quickbooks. After preparing the paychecks, export the payroll summary to Excel and e-mail it the instructor.
2. Prepare a vertical analysis of Motor Company's balance sheet. Print and bring to class. Be prepared to discuss which items warrant further investigation.

Kay, D. (2023). Computer Accounting with QuickBooks Online. McGraw-Hill, 4th. 978-1266787256.

Accounting (Masters Required)

Office Technologies