Cookies on NWTC's Website

NWTC logo

Accounting-Automated Applications

Credits: 3
Course Number: 10-101-156

Home » Academics And Training » Courses » Accounting Automated Applications » 10101156 2242 21925

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.