Standard

ACC 104 – Computerized Accounting

 Course Description:

 

Emphasizes operation of computerized accounting systems from manual input forms.  Topics include:  equipment use, general ledger, accounts receivable and payable, payroll, cash management, and financial reports.  Laboratory work includes theoretical and technical application.

 

Competency Areas:

Hours:

 

 

 

Equipment Use

Class

1

General Ledger

D. Lab

4

Accounts Receivable and Payable

P. Lab/O.B.I.

0

Payroll

Credit

3

Cash Management

 

 

Financial Reports

 

 

 

 

 

Prerequisite/Corequisite:  ACC 102;  SCT 100

 

 

 

Course Guide

 

Competency

After completing this section, the student will:

Hours

Class

D. Lab

P. Lab/

O.B.I.

EQUIPMENT USE

1

2

0

File Management

Explain the procedures for copying and moving computer files.  Also explain the procedures for creating folders and organizing the computer files.

 

 

 

Backup Procedures

Explain the procedures and importance for backing up computer files and restoring files.

 

 

 

GENERAL LEDGER

2

8

0

General ledger setup and operational procedures

Explain the operational procedure for account classifications.

 

 

 

 

Explain procedure for entering the opening balances for existing accounts.

 

 

 

 

Explain the purpose of an opening balance report.

 

 

 

 

Explain the purpose of correct opening balances.

 

 

 

 

Explain the procedure for making adjusting entries including depreciation.

 

 

 

 

Explain the procedure for adding, changing, and deleting accounts.

 

 

 

General ledger accounting cycle

Explain the procedure for making corrections.

 

 

 

 

Identify and explain the purpose of each of the following reports:  trial balance, general ledger report, income statement, balance sheet, and general journal.

 

 

 

 

Explain the result of year-end closing procedures.

 

 

 

 

Explain the purpose of a post-closing trial balance.

 

 

 

ACCOUNTS RECEIVABLE AND PAYABLE

2

8

0

Accounts receivable setup and operational procedures

Identify and explain computerized accounts receivable.

 

 

 

 

Explain the procedures for entering customer information.

 

 

 

 

Explain the procedures for entering customer’s opening balances.

 

 

 

 

Explain the purpose of a printed customer list.

 

 

 

 

Explain the need for updating the customer file.

 

 

 

 

Explain the procedure for creating and editing an invoice or cash receipt.

 

 

 

 

Explain the procedure for recording receipt of cash from customers.

 

 

 

 

Explain the procedure for preparing statements for customers.

 

 

 

 

Identify and explain the purpose of various accounts receivable reports.

 

 

 

Accounts payable setup and operational procedures

Identify and explain computerized accounts payable.

 

 

 

 

Explain the procedures for entering vendor/creditor information.

 

 

 

 

Explain the procedures for entering vendor’s/creditor’s opening balances.

 

 

 

 

Explain the purpose of a printed vendor/creditor list.

 

 

 

 

Explain the need for updating the vendor/creditor file.

 

 

 

 

Explain the procedure for creating and editing a purchase order.

 

 

 

 

Explain the procedure for recording payments of cash to vendors/creditors.

 

 

 

 

Explain the procedure for creating and editing checks for vendors/creditors.

 

 

 

 

Identify and explain the purpose of various accounts payable reports.

 

 

 

PAYROLL

2

8

0

Payroll setup and operational procedures

Explain the primary function of a computerized payroll system.

 

 

 

 

Identify and explain the tasks that must be performed in order to set up a payroll system:  build the employee list, set up taxes and deductions for each employee, and enter quarterly and yearly balances.

 

 

 

 

Explain the importance of the employee list report.

 

 

 

 

Explain the need for updating employee list; demonstrate the procedure of adding, changing, and deleting employees.

 

 

 

 

Explain the purpose of the payroll transactions and demonstrate the procedure for entering the payroll transactions from the payroll records.

 

 

 

 

Identify and explain the purpose of each of the following reports:  payroll register, payroll checks, quarterly report, employee earnings record, and annual W-2 statement.

 

 

 

 

Explain the various monthly, quarterly, and annual reports required.

 

 

 

 

Explain creating and editing payroll checks.

 

 

 

 

Explain the necessary year-end payroll procedures.

 

 

 

CASH MANAGEMENT

1

7

0

Petty Cash

Explain the procedures for creating, maintaining, and replenishing the petty cash account.

 

 

 

Cash

Explain the procedures for deposits, maintenance, and disbursements involving the cash account.

 

 

 

Bank Reconciliation

Explain the procedure for reconciling a bank statement to any cash account.

 

 

 

 

Explain the procedure for making adjustments to the cash account because of the reconciliation.

 

 

 

FINANCIAL REPORTS

2

7

0

Financial statements analysis and operational procedures

Identify and explain the purpose of required, as well as beneficial financial statements and reports.

 

 

 

 

Identify and explain various methods of presenting the data through reports (i.e., horizontal analysis, vertical analysis, and comparative periods).

 

 

 

 

Suggested Resources

 

Books:

 

Computer Accounting with Peachtree Complete for Microsoft Windows.  Release 8.0, Peters, Judith, Robert Peters, and Carol Yacht. (2001) Boston, MA. Houghton Mifflin Publishing Co.

 Computerized Accounting w/Peachtree Complete Accounting. Bigham, (2001). New Jersey: Prentice Hall.

 Computer Accounting with QuickBooks Pro 2000, Donna Ulmer, second edition, McGraw-Hill Irwin, 2001.

 QuickBooks Pro 2001 by Douglas Sleeter.

 Computerized Accounting with Peachtree 8.0. Paradigm, Mazza and Chavez.

 Computerized Accounting w/Peachtree.  2000, Houghton-Mifflin.  Rosa.

 QuickBooks Pro 2000, Villani/Rosa (2001), St. Paul: EMC Paradigm.

 Computerized Accounting With QuickBooks Pro 2000. Horne, J. (2001). New Jersey: Prentice Hall.

 Integrated Accounting for Windows. 3rd edition.  Klooster and Allen.  South-Western Publishing Company.