Skip to content
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, developing accounting software skills using QuickBooks accounting software, company setup, and use of the QuickBooks program to enter a 12-month, project-based transactions using common business source documents to generate information necessary to prepare WI/Fed sales and payroll 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.