NWTC logo

Accounting-Automated Applications

Credits: 3
Course Number: 10-101-156

Course Description

10-101-156 ACCOUNTING-AUTOMATED APPLICATIONS ...Excel, worksheet applications, vlookups, if statements, data/ratio analysis. Learners will also be developing accounting software skills using Online QuickBooks software which includes the company setup and using a 12-month, project-based transactions of common business source documents to generate information necessary to prepare WI/Fed payroll tax and WI Sales tax reports and accrual-based monthly/yearly financial reports with year-end adjustments. (Prerequisites: 10-101-120, Accounting 2; 10-101-105, Accounting-Computer Ledger; 10-101-189, Accounting-Applying QuickBooks)

Course Typically Offered

  • Fall
  • Spring

Most NWTC classes are offered in 8-week sessions. Learn more about how our class schedule can help you succeed.

How can I use this course to achieve my career goals?

This course is associated with the following programs:

What will I learn?

  1. Demonstrate computer file management.
  2. Develop worksheets using Excel.
  3. Develop familiarity with QuickBooks.
  4. Set up an accrual-based landscaping company using QuickBooks software.
  5. Process accounts receivable and sales of inventory for a landscaping business using QuickBooks software.
  6. deleted
  7. Process accounts payable and purchases of inventory for a landscape service business using QuickBooks software.
  8. Manage cash payments and cash receipts using QuickBooks software.
  9. Prepare financial statements using QuickBooks software.
  10. Deleted.
  11. Deleted.
  12. Manage payroll using QB software and generate both Federal and WI payroll tax forms.
  13. Apply QB reports/ratios and use of Excel worksheets to interpret and analyze business operations.
  14. Orally communicate effectively in a group setting.

Class Details

Class Number:
22260
Delivery:
Online Live
Term:
Spring 2025
Session:
8W2
Instructors:
Gary Mehre
Date Range:
-
Estimated Cost:
$496.55 *

Class Notes

  • This class is taught through a combination of online-live and online instruction. A portion of the class must be attended live virtually during the scheduled dates and times, and the remaining instruction accessed online by the student any time. For more information regarding this delivery and how to access your class, see www.nwtc.edu/onlinelivefaq.

Meeting Times

Dates Day(s) / Time Location(s)
03/31/25 - 05/20/25 Anytime
Anytime
Online
03/31/25 - 05/19/25 M
5:30 PM - 9:20 PM
Web Conference

* Cost displayed is based on in-state residency. Back to cost

Loading