ACTG 64A: COMPUTERIZED ACCOUNTING PRACTICE USING QUICKBOOKS
Foothill College Course Outline of Record
|Effective Term:||Summer 2021|
|Hours:||4 lecture per week (48 total per quarter)|
|Corequisite:||Completion of or concurrent enrollment in ACTG 1A or 60.|
|Advisory:||Not open to students with credit in CIS 64A.|
|Degree & Credit Status:||Degree-Applicable Credit Course|
|Grade Type:||Letter Grade (Request for Pass/No Pass)|
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.
The student will be able to:
A. work independently and comply with written instructions on handling accounting information.
B. establish and meet a time schedule.
C. increase comprehension of accounting concepts.
D. develop orderly habits for handling business papers and processing accounting transactions on the computer, using QuickBooks.
E. print out financial statements.
F. conduct research on the internet.
A. Set up a business accounting system
1. Set up chart of accounts
2. Set up company preferences
3. Set up customers, vendors and accounts
4. Set up payroll and employees
B. Interpret and enter cash oriented financing, investing and operating business activities in order to evaluating a business's performance and financial position
C. Interpret and enter non-cash investing and financing activities
D. Interpret and enter adjusting entries
1. Accrued expenses
2. Accrued revenues
3. Unearned revenues
4. Deferred expenses
E. Prepare a bank reconciliation and record related adjustments
F. Prepare the following budget related activities
1. Budget revenues and expenses
2. Budget balance sheets
3. Prepare a budget versus actual report
G. From data interpreted and entered, report on various business activities
1. Create and memorize standardized and customized income statements
2. Create and memorize standardized and customized balance sheets
3. Create and memorize statements of cash flows
4. Create graphs to illustrate financial information
5. Create and 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
H. From data interpreted and entered, create and produce a trial balance
I. From data interpreted and entered, create and produce a general ledger
J. Print out information obtained from internet research
Special Facilities and/or Equipment
B. When taught as an online distance learning section, students and faculty need ongoing and continuous internet and email access.
Method(s) of Evaluation
Midterm and final exams
Computerized assignments using Excel spreadsheets to enter business transactions and prepare financial statements
Computerized assignment using Excel spreadsheets to create general ledger, receivables and payable, payroll transactions, and bank reconciliation statement
Computerized assignments using Excel spreadsheets to create various budgets
Method(s) of Instruction
Representative Text(s) and Other Materials
Horne, Janet. QuickBooks Online Plus 2017. 2017.
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.
A. Reading the required QuickBooks text
B. Reading of various accounting texts related to accounting terms, regulations, standards and procedures
C. Visiting accounting websites to read on accounting theories and practices
D. Internet research regarding best practices in QuickBooks
E. Reading of Wall Street Journal, Business Week, Fortune