Print Version

Effective: Summer 2014
ACTG 64ACOMPUTERIZED ACCOUNTING PRACTICE USING QUICKBOOKS4 Unit(s)

Prerequisites: Prerequisite: ACTG 1A or equivalent experience.
Advisory: Advisory: Not open to students with credit in CIS 64A.
Grade Type: Letter Grade, the student may select Pass/No Pass
Not Repeatable.
FHGE: Non-GE Transferable: CSU
4 hours lecture. (48 hours total per quarter)

Student Learning Outcomes -
  • Apply accounting principles and procedures by data entry of business transactions into a computerized accounting program.
  • Integrate knowledge of accounting principles and a computerized accounting program into various financial statements and reports.
Description -
Focus on using QuickBooks to record financial data. Reviewing the accounting cycle, processing business transactions and preparing financial statements.

Course Objectives -
The student will be able to:
  1. work independently and comply with written instructions on handling accounting information.
  2. establish and meet a time schedule.
  3. increase comprehension of accounting concepts.
  4. develop orderly habits for handling business papers and processing accounting transactions on the computer, using QuickBooks.
  5. print out financial statements.
  6. conduct research on the Internet.
Special Facilities and/or Equipment -
Access to computer lab and QuickBooks software. When taught as an online distance learning section, students and faculty need ongoing and continuous Internet and email access.

Course Content (Body of knowledge) -
  1. Set up a business accounting system
    1. Set up chart of accounts
    2. Set up company preferences
    3. Set up customers, vendors & accounts
    4. Set up payroll & employees
  2. Interpret and enter cash oriented financing, investing and operating business activities in order to evaluating a business's performance & financial position
  3. Interpret and enter non-cash investing & financing activities
  4. Interpret and enter adjusting entries
    1. Accrued expenses
    2. Accrued revenues
    3. Unearned revenues
    4. Deferred expenses
    5. Depreciation
  5. Prepare a bank reconciliation and record related adjustments
  6. Prepare the following budget related activities
    1. Budget revenues & expenses
    2. Budget balance sheets
    3. Prepare a budget versus actual report
  7. From data interpreted and entered, report on various business activities
    1. Create & memorize standardized and customized income statements
    2. Create & memorize standardized and customized balance sheets
    3. Create & memorize statements of cash flows
    4. Create graphs to illustrate financial information
    5. Create & memorize reports from the subsidiary journals such as accounts payable aging reports and accounts receivable aging reports
    6. Create comparative balance sheets
    7. Create comparative income statements
    8. Create comparative balance sheets
    9. Modify financial statements
  8. From data interpreted and entered, create and produce a trial balance
  9. From data interpreted and entered, create and produce a general ledger
  10. Print out information obtained from internet research
Methods of Evaluation -
  1. Midterm and final exams
  2. Computerized assignments using Excel spreadsheets to enter business transactions and prepare financial statements
  3. Computerized assignment using Excel spreadsheets to create general ledger, receivables and payable, payroll transactions, and bank reconciliation statement
  4. Computerized assignments using Excel spreadsheets to create various budgets
  5. Discussion posts
Representative Text(s) -
Glenn, Owen, QuickBooks Pro for Accounting 2013. Ohio: Thomson South-Western, 2013.

Disciplines -
Accounting
Computer Information Systems
 
Method of Instruction -
Lecture, Electronic discussions/chat, hands-on-assignments.
 
Lab Content -
Not applicable.
 
Types and/or Examples of Required Reading, Writing and Outside of Class Assignments -
Assignments will be evaluated based on students' abilities to perform "hands on” operations/transactions on Excel software. Exercises and problems are designed to test students' skills at understanding different functions and tools within Excel, preparing budgets, using Excel formula function to build vertical, horizontal and ratio analysis, preparing budgets and presenting accounting reports and financial statements.
  1. Reading the required QuickBooks text
  2. Reading of various accounting texts related to accounting terms, regulations, standards and procedures
  3. Visiting accounting websites to read on accounting theories and practices
  4. Internet research regarding best practices in QuickBooks
  5. Reading of Wall Street Journal, Business Week, Fortune