Nov 23, 2024  
2023-2024 Course Catalog 
    
2023-2024 Course Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

ACC 311 - Computer Accounting

Credits: 3
Lecture Hours: 2
Lab Hours: 2
Practicum Hours: 0
Work Experience: 0
Course Type: Voc/Tech
Emphasizes application of computerized financial software used in business. Topics include setting up a company, receivables, payables, inventory control, payroll, time tracking and job estimating.
Prerequisite: Successful completion of ACC 104  or ACC 131  with a grade of “C” or above
Competencies
 

  1. Navigate the tools available in the accounting software packages
    1. Apply menu commands and keyboard shortcuts
    2. Open, copy, back up, and close company files
    3. Access reports and graphs
    4. Apply the use of security available in the software
  2. Complete transactions for sales transactions for a service company
    1. Set up new customers
    2. Create invoices for sales on account
    3. Create cash receipts for sales for cash
    4. Create credit memos/refunds
    5. Enter partial and full payments cash payments
    6. Void a sales transaction
    7. Do job estimation
    8. Trace the audit trail for all sales transactions
    9. Prepare reports including aging of receivable, financial statement, and other related reports
  3. Complete transactions for purchases transactions for a service company
    1. Add new vendors and modify vendor records
    2. View Accounts Payable transaction history
    3. Record transactions
    4. Edit, void, and perform an audit trail
    5. Record Petty Cash entries
    6. Add new general ledger accounts
    7. Print reports including Aged payables Report, a Vendor Ledger Report, Cash Disbursements Journal and a Check Register
  4. Complete the end-of-period procedures for a service business
    1. Change account names, delete accounts, and make accounts inactive
    2. Record adjusting entries applying the accrual system
    3. Record owner’s equity transactions
    4. Reconcile the bank statement, record service charges, and other adjustments
    5. Prepare financial statements
    6. Export to other programs
  5. Complete transactions for sales and receivables for a merchandising business
    1. Enter sales transactions
    2. Prepare invoices that use sales tax
    3. Set up credit limits for customers
    4. Add additional price levels to merchandise inventory items
    5. Prepare credit memos with and without refunds
    6. Record customer payments on account with and without discounts
    7. Prepare reports including inventory lists, aging receivable, and sales tax
  6. Complete transactions for purchases and payables for a merchandising business
    1. Prepare and view purchase orders and checks
    2. Enter purchase invoices, vendor credits, and pay invoices
    3. Adjust inventory based on a physical count
    4. Edit, correct, void, and perform necessary audit trail
    5. Display Sales tax reports, aged payable report and vendor ledger report
  7. Complete the end-of-period procedures for a merchandising business
    1. Enter adjusting entries required for accrual based system
    2. Enter equity transactions for a partnership
    3. Reconcile a bank statement and record related transactions
    4. Print year-end reports
    5. Export reports to other software
    6. Record withdrawal transactions
  8. Complete payroll transactions
    1. Set up employee and related pay scale
    2. Set up employee and employee taxes
    3. Create and preview, payroll checks
    4. Print current earnings report
    5. Prepare tax liability reports and make deposits
    6. Prepare Forms 941 and 940
    7. Discuss W-2 and W-3 forms
    8. Discuss time tracking
  9. Complete a capstone project
    1. Set up a company set of books based on data provided
    2. Create a chart of accounts
    3. Create lists for customers, vendors, inventory items and enter beginning balances
    4. Create payroll defaults and enter employees
    5. Record transactions
    6. Prepare reports associated with the company
    7. Make all adjustment and prepare a bank reconciliation
    8. Prepare all reports associated with the company
  10. Research software used in small business
    1. Interview business in the community
    2. Prepare and/or share finding of accounting software in the community

Competencies Revised Date: AY2023



Add to Portfolio (opens a new window)