Standard |
ACC 104 - Computerized Accounting
Emphasizes operation of computerized accounting systems from manual input forms. Topics include: equipment use, general ledger, accounts receivable and payable, advanced payroll, and financial reports. Laboratory work includes theoretical and technical application.
|
Competency Areas |
Hours
|
|
|
|
Equipment Use |
Class |
1 |
|
|
General Ledger |
D. Lab |
2 |
|
|
Accounts Receivable and Payable |
P. Lab/O.B.I. |
3 |
|
|
Advanced Payroll |
Credit |
3 |
|
|
Financial Reports |
|
|
|
|
|
|
|
|
|
Prerequisite: |
ACC 102; BUS 101 or CIS 101 |
||
|
Corequisite: |
|
||
Course Guide |
|
Competency |
After completing this
section, the student will: |
Hours |
||
|
Class |
D.Lab |
P.Lab/ O.B.I. |
||
|
EQUIPMENT USE |
2 |
0 |
6 |
|
|
Setup procedures |
Identify the itemized list of the care and handling directions for diskettes. |
|
|
|
|
|
Demonstrate each key's functions as described in the keyboard operation section of text. |
|
|
|
|
|
|
|
|
|
|
|
Identify difference among menu modes, decision modes, and data entry modes. |
|
|
|
|
|
Explain computer software design to load the selected program and its corresponding data into memory. |
|
|
|
|
|
Describe the procedure to follow if the computer session must be interrupted prior to completing a problem. |
|
|
|
|
|
Demonstrate the proper start-up procedure for the microcomputer being used. |
|
|
|
|
|
Identify the purpose of each option of the system selection menu. |
|
|
|
GENERAL LEDGER
|
2 |
12 |
0 |
|
|
General ledger setup and operational procedures |
Identify the two files for storing the general ledger information. |
|
|
|
|
|
Complete each data field on the chart of accounts file maintenance input form and the journal entries input form. |
|
|
|
|
|
Identify the three tasks that must be completed before the general ledger system can be selected and before the input forms can be key-entered into the computer. |
|
|
|
|
|
List the operational procedure for key-entering the accounts into the computer from the chart of accounts file maintenance input forms. |
|
|
|
|
|
Explain the purpose of the control accounts. |
|
|
|
|
|
Demonstrate the operational procedure for account classifications. |
|
|
|
|
|
List the operational procedure for key-entering the opening balances into the computer from the journal entries input form. |
|
|
|
|
|
Explain the purpose of an opening balance report. |
|
|
|
|
|
Explain the purpose of correct opening balances and the procedure for correcting journal entries. |
|
|
|
|
|
List the procedure for printed reports after all transactions have been processed and posted. |
|
|
|
|
|
Demonstrate the procedure for making adjusting entries. |
|
|
|
|
|
Demonstrate the procedure for adding, changing, and deleting accounts. |
|
|
|
|
|
Identify the purpose of the set run data and batch number option. |
|
|
|
|
General ledger accounting cycle |
Explain the purpose of the journal entries option and demonstrate the procedure for key-entering the transactions from the journal entries input system. |
|
|
|
|
|
Explain journal entries report use. |
|
|
|
|
|
Explain the procedure for making corrections to journal entries. |
|
|
|
|
|
Identify and explain the purpose of each of the following reports: trial balance, general ledger report, income statement, and balance sheet. |
|
|
|
|
|
Explain the result of computerized year-end closing upon files. |
|
|
|
|
|
Explain the purpose of a post-closing trial balance. |
|
|
|
ACCOUNTS RECEIVABLE AND PAYABLE
|
2 |
0 |
16 |
|
|
Accounts receivable setup and operational procedures |
Identify and explain the two approaches to computerized accounts receivable. |
|
|
|
|
|
Identify the two files used in the accounts receivable system. |
|
|
|
|
|
Complete each data field on the customer file maintenance input form and the accounts receivable transactions input forms. |
|
|
|
|
|
Identify and demonstrate the five tasks that must be completed before the accounts receivable system can be set up. |
|
|
|
|
|
Demonstrate the operational procedure for key-entering the customer data into the computer from the customer file maintenance input form. |
|
|
|
|
|
Explain the purpose of a printed customer list. |
|
|
|
|
|
Explain and demonstrate set control accounts use and describe the purpose of each of the account numbers entered. |
|
|
|
|
|
Explain the purpose of the enter/correct opening balances option. |
|
|
|
|
|
Identify the control account numbers used in the set control accounts option and explain the integration process. |
|
|
|
|
|
Discuss the need for updating the customer file. |
|
|
|
|
|
Explain the purpose of the sales and cash receipts option and demonstrate the procedure for key-entering the accounts receivable transactions from the accounts receivable transactions input forms. |
|
|
|
|
|
Identify and explain the purpose of each of the following reports: sales on account, cash receipts, general ledger posting summary accounts receivable ledger, accounts receivable ledger, and customer statements. |
|
|
|
|
Accounts payable setup and operational procedures |
Identify the four general tasks that must be performed to establish an accounts payable system. |
|
|
|
|
|
Identify and review the two files used in accounts payable system. |
|
|
|
|
|
Complete each data field on the vendor file maintenance input form and the accounts payable transactions input form. |
|
|
|
|
|
Identify and demonstrate the five tasks that must be completed before the accounts payable system can be set up. |
|
|
|
|
|
Explain and demonstrate the set control accounts option and describe the purpose of the account numbers entered. |
|
|
|
|
|
Describe the procedure used to establish the beginning check number. |
|
|
|
|
|
Explain the purpose of the enter/correct opening balances option. |
|
|
|
|
|
Identify the control account numbers used in the set control accounts tasks option and explain the integration process. |
|
|
|
|
|
Discuss the need for updating the vendor master file. |
|
|
|
|
|
Explain the purpose of the vouchers and cash payments option and demonstrate the procedure for key-entering the accounts payable transactions from the accounts payable transaction input form. |
|
|
|
|
|
Identify and explain the purpose of each of the following reports: voucher register, cash payment report, general ledger posting summary, accounts payable ledger report, and check register and checks. |
|
|
|
ADVANCED PAYROLL
|
2 |
0 |
8 |
|
|
Payroll setup and operational procedures |
Discuss the primary function of a computerized payroll system. |
|
|
|
|
|
Identify and demonstrate the tasks that must be performed in order to set up a payroll system: build the employee master file, set the beginning check number, and enter quarterly and yearly balances. |
|
|
|
|
|
Identify the two files used in the payroll system. |
|
|
|
|
|
Complete each data field on the employee file maintenance input form and the payroll quarter-to-date/year-to-date input form. |
|
|
|
|
|
Identify the four tasks that must be completed before the payroll system can be set up. |
|
|
|
|
|
Explain the importance of the employee list report. |
|
|
|
|
|
Describe the procedure used to establish the beginning check number. |
|
|
|