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
Most NWTC classes are offered in 8-week sessions. Learn more about how our class schedule can help you succeed.
What will I learn?
- Demonstrate computer file management.
- Develop worksheets using Excel.
- Develop familiarity with QuickBooks.
- Set up an accrual-based landscaping company using QuickBooks software.
- Process accounts receivable and sales of inventory for a landscaping business using QuickBooks software.
- deleted
- Process accounts payable and purchases of inventory for a landscape service business using QuickBooks software.
- Manage cash payments and cash receipts using QuickBooks software.
- Prepare financial statements using QuickBooks software.
- Deleted.
- Deleted.
- Manage payroll using QB software and generate both Federal and WI payroll tax forms.
- Apply QB reports/ratios and use of Excel worksheets to interpret and analyze business operations.
- Orally communicate effectively in a group setting.
Class list
3 classes found
-
Class Number: ACCOUNT 10101156-3 - Accounting-Auto Appl
-
Class Number: ACCOUNT 10101156-1 - Accounting-Auto Appl
-
Class Number: ACCOUNT 10101156-2 - Accounting-Auto Appl