Description:

Upon successful completion of this course, a student will be able to use the microcomputer to create a chart of accounts, accounts receivable and payable subsidiary ledgers, transaction journals, general ledgers, financial statements, reports and forecasts. 3 hrs./wk.

Supplies: Refer to the instructor’s course syllabus for details about any supplies that may be required.

Textbook(s): For information see - http://bookstore.jccc.net

Course Fees: NONE

Course Objectives:

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

1. Design and create a chart of accounts, balance sheet, income statement and supporting reports for a service and a merchandising company.
2. Load subaccount information including accounts receivable customer amounts, accounts payable vendor amounts, detailed inventory records and year-to-date payroll information.
3. Process purchases, sales and all normal daily transactions for service and merchandising companies.
4. Calculate, prepare and enter adjusting journal entries at the end of an accounting period.
5. Prepare end of period financial statements and supporting reports.
6. Perform closing procedures and prepare the accounting records for the succeeding accounting period.

Content Outline & Competencies:

I. Computer Operations
   A. Describe differences between manual and computerized accounting
methods.
   B. Respond to the computer using the proper keyboard keys, system rules
and standards.
   C. Use the DOS, DIR, DEL and copy commands.
   D. Install and define files.
   E. Work within the constraints placed on file capacities.
   F. Successfully enter the printer parameters for the printer being
used.
   G. Back up files.

II. General Ledger
   A. Identify the components and procedures for general ledger set-up.
   B. Set up chart of accounts.
   C. Determine levels of the accounts.
   D. Set control accounts.
   E. Classify accounts.
   F. Enter opening balances.
   G. Make corrections to opening balances.
   H. Perform simple file maintenance on chart of accounts.
   I. Determine the purpose of the G/L Interface Table.
   J. Print a chart of accounts.

III. Accounts Receivable
   A. Process pertinent information to be entered in the fields on the
accounts receivable customer file maintenance screen.
   B. Set up a customer using the customer file maintenance screen.
   C. Define the difference between an open invoice customer file and a
balance forward customer file.
   D. Delete a customer file.

IV. Accounts Payable
   A. Process pertinent information to be entered in the fields on the
accounts payable vendor file maintenance screen.
   B. Process data in the customer file maintenance screen and the vendor
file maintenance screen.
   C. Set up a vendor using the vendor file maintenance routine.
   D. Enter purchase and vendor data in the fields of the accounts payable
transaction entry screen.
   E. Enter an accounts payable invoice.
   F. Print the accounts payable journal.

V. Transaction Journals
   A. Code accounts payable invoices before entering them into the
computer.
   B. Enter accounts payable transactions that are automatically posted to
the general ledger.
   C. Enter payable to a vendor.
   D. Process payments made to vendors whose invoices have been recorded
in the accounts payable files and pay vendors for items not recorded in
the accounts payable files.
   E. Perform the procedures necessary to display a payment already
entered.
   F. Use the transaction number as a control for entries made.
   G. Print the payments journal.
   H. Enter a sale to a customer.
   I. Perform procedures necessary to display a sale already entered.
   J. Use the transaction number as a control for sales entries made.
   K. Process receipts from customers whose invoices have been recorded in
the accounts receivable files and for items not recorded in the accounts
receivable files.
   L. Enter a receipt for a customer.
   M. Perform procedures necessary to display a receipt already entered.
   N. Print the receipts journal.
   O. Enter general journal entries.
   P. Analyze the significance of the “D” journal differences account.
   Q. Print general ledger transaction journals.

VI. Posting
   A. Post each journal type used.
   B. Back up accounting data files before journals.
   C. Print the G/L account activity report.

VII. Accounting Reports
   A. Print the trial balance, income statement, balance sheet and age
reports of accounts receivable and payable.
   B. Use the reporting capabilities of the software package.

VIII. Inventory
   A. Print the Billing/P.O. Codes Table.
   B. Create and print purchase orders for product inventory items.
   C. Enter and print receipts for merchandise ordered with purchase
order.
   D. Prepare transfer and adjustment entries regarding inventory.

IX. Financial Statements
   A. Create and print an elementary financial report.
   B. Prepare all financial reports, subsidiary reports and custom reports
contained within the accounting software package.
   C. Accomplish end-of-year processing or accounts receivable, accounts
payable, inventory and the general ledger.
   D. Create and print a statement of cash flow.
   E. Create and print a comparative income statement.
   F. Create and print a comparative balance sheet.

X. Advanced Topics
   A. Create and print computerized amortization schedules.
   B. Create and print computerized depreciation schedules.
   C. Perform the procedures for payroll set-up.
   D. Perform the procedures required to generate payroll reports.

Methods of Evaluation of Competencies:

Evaluation of student mastery of course competencies will be accomplished using the following methods:

Minimum of one examination
Daily practice sets
Evaluation of homework assignments
Evaluation of participation in classroom discussions
Optional projects

Grade Criteria:
 A = 90 - 100%
 B = 80 -  89%
 C = 70 -  79%
 D = 60 -  69%
 F = below 60%

Caveats: NONE

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.