Course curriculum

  • 01

    Introduction

    • 110 Job Cost System Objectives

  • 02

    Job Costing Process # 1 Overview & Objectives

    • 2-Job-Costing-Process-1-Overview-Objectives

    • Excel File to Download

    • 120 Excel Problem Tracking WIP

    • QuickBooks Backup Files

    • 125 Restore QuickBooks Backup File 125

    • 130 Review Job Cost System 1

    • Accounting Comic Break

  • 03

    Job Costing Process #s 2, 3, & 4 Overview & Objectives

    • Job Costing Process #s 2, 3, & 4 Overview & Objectives

    • Download Backup Files

    • Excel Download

    • 135 Excel Problem Tracking COGS

    • 140 Restore Backup File 140

    • 145 Review Job Cost System 2

    • 150 Restore QuickBooks File 150

    • 155 Review Job Cost System 3

    • 160 Restore Backup File 160

    • 165 Review Practice Problem 4

    • Accounting Comic Break

  • 04

    Job Costing Process # 1 Tracking Work in Progress

    • 4 Job Costing Process # 1 Tracking Work in Progress

    • Download Backup Files

    • Download Excel Practice file

    • 310 Create QuickBooks File

    • 320 Set Up Jobs

    • 325 Set Up Job Costing Items

    • 327 Set Up Estimates For Jobs

    • 330 Set Up WIP Beginning Balances

    • 335 Enter Beginning Balances

    • 340 Purchase Raw Materials On Account

    • 345 Direct Materials Used in Job

    • 350 Direct Labor Applied to Jobs

    • 355 Factory Overhead Applied to Job

    • 360 Factory Overhead Incurred

    • 365 Job Completed & Not Billed

    • 365 Job Completed & Not Billed

    • 370 Job Closed & Invoiced

    • 375 Close Balance In Factory Overhead

    • Accounting Comic Break

  • 05

    Job Costing Process # 2 Tracking COGS with Fewer Accounts

    • 5 Job Costing Process # 2 Tracking COGS with Fewer Accounts

    • Download Backup Files

    • Download Excel Worksheet

    • 410 Create QuickBooks File

    • 415 Factory Overhead

    • 420 Enter Beginning Balances for Jobs & Accounts

    • 425 Purchase Raw Materials On Account

    • 430 Raw Materials Used & Applied to Job

    • 435 Enter Job Estimates

    • 440 Apply Direct Labor Cost to Jobs

    • 445 Apply Overhead to Jobs

    • 450 Record Job Completion & Invoicing

    • 455 Adjusting Entry

    • Accounting Comic Break

  • 06

    Job Costing Process # 3 Tracking COGS with More Accounts

    • 6 Job Costing Process # 3 Tracking COGS with More Accounts

    • Download Backup Files

    • Download Excel Practice file

    • 510 Create QuickBooks File

    • 515 Set Up Jobs, Items, & Accounts

    • 517 Enter Job Estimates

    • 520 Enter Beginning Balances For Jobs & Accounts

    • 525 Purchase Raw Materials On Account

    • 530 Raw Materials Used & Applied to Job

    • 540 Apply Direct Labor Cost to Jobs

    • 545 Apply Overhead to Jobs

    • 550 Record Completion of Job & Invoicing

    • Accounting Comic Break

  • 07

    Job Costing Process # 4 Using Classes to Track Jobs

    • 7 Job Costing Process # 4 Using Classes to Track Jobs

    • Download Backup Files

    • Download Excel Practice file

    • 610 Create QuickBooks File

    • 613 Turn On Class Tracking

    • 615 Set Up Jobs & Classes

    • 617 Set Up Accounts

    • 620 Enter Beginning Balances For Jobs & Accounts

    • 625 Purchase Raw Materials On Account

    • 640 Apply Direct Labor Cost to Jobs

    • 645 Apply Overhead to Jobs

    • 660 Selling & Administrative Expenses

    • Accounting Comic Break

Pricing options

Explain how different pricing options might be valuable to different segments of your audience.

Description

This QuickBooks Desktop Job Costing course will provide the resources for learners to develop a solid understanding of job costing concepts and the tools QuickBooks provides to create an effective job costing system.

The course will include four example problems demonstrating different job costing systems and methods that can be used.

We will provide backup files so learners can jump forward in the problems or rework any component of a problem. The use of backup files is not a requirement of the course, however.

If you have an older version of the software and cannot use backup files, you can still work the practice problems from start to finish. We will be creating new files for each practice problem so learners can follow along from start to finish without the need for a backup file.

The course will start out reviewing a job costing system, gaining an understanding of the objectives of a job costing system. Then we will discuss the tools provided by QuickBooks to achieve our objectives in the QuickBooks software.

We will start by reviewing the end products of the four job costing system practice problems we will be creating in later in the course. This review process will allow us to visualize where we are headed in the course. Then we will start working problems from start to finish.

Our first QuickBooks problem will run a job cost system in QuickBooks using a work in process or WIP account to track costs. We will start out using a limited number of accounts and items and walk through each step in detail.

The second QuickBooks problem will run a job cost system in QuickBooks, focusing on the Cost of Goods Sold account. We will use a small number of accounts and items. We will discuss adjusting entries that can be used to adjust the financial statements to the appropriate accounting method required.

The third QuickBooks problem will run a job cost system in QuickBooks with the use of more accounts and items, resulting in a system that provides more detailed reports.

The fourth QuickBooks problem will run a job cost system in QuickBooks with the use of the classes feature. We will discuss the pros and cons of using this option.

Robert (Bob) Steele CPA CGMA CPI MStax

Instructor

Through working with students from many different schools, Mr. Steele has learned best practices for helping people understand accounting fast. Learning new skills and finding the best way to share knowledge with people who can benefit from it is a passion of his.

Mr. Steele has experience working as a practicing Certified Public Accountant (CPA), an accounting and business instructor, and curriculum developer. He has enjoyed putting together quality tools to improve learning and has been teaching, making instructional resources, and building curriculum since 2009. He has been a practicing CPA since 2005. Mr. Steele is a practicing CPA, has a Certified Post-Secondary Instructor (CPI) credential, a Master of Science in taxation from Golden Gate University, a Bachelor’s Degree in Business Economics with an emphasis in accounting from The University of California Santa Barbara, and a Global Management Accounting Designation (CGMA) from The American Institute of CPA (AICPA).

Mr. Steele has also authored five books that can be found on Amazon or in audiobook format on Audible. He has developed bestselling courses in accounting topics including financial accounting and QuickBooks accounting software.

In addition to working as an accountant, teaching, and developing courses Mr. Steele has helped create an accounting website at accountinginstruction, a YouTube channel called Accounting Instruction, Help, and How Too, and has developed supplemental resources including a Facebook Page, Twitter Page, and Podcasts that can be found on I-tunes, Stitcher, or Soundcloud. Mr. Steele’s teaching philosophy is to make content applicable, understandable, and accessible.

Adult learners are looking for application when they learn new skills. In other words, learners want to be able to apply skills in the real world to help their lives. Mr. Steele’s formal accounting education, practical work experience, and substantial teaching experience allow him to create a curriculum that combines traditional accounting education with practical knowledge and application. He accomplishes the goals of making accounting useful and applicable by combining theory with real-world software like Excel and QuickBooks.

Many courses teach QuickBooks data entry or Excel functions but are not providing the real value learners want. Real value is a result of learning technical skills like applications, in conjunction with specific goals, like accounting goals, including being able to interpret the performance of a business.

Mr. Steele makes knowledge understandable by breaking down complex concepts into smaller units with specific objectives and using step by step learning processes to understand each unit. Many accounting textbooks cram way too much information into a course, making it impossible to understand any unit fully. By breaking the content down into digestible chunks, we can move forward much faster.

Mr. Steele also makes use of color association in both presentations and Excel worksheets, a learning tool often overlooked in the accounting field, but one that can vastly improve the speed and comprehension of learning accounting concepts.

The material is also made understandable through the application of concepts learned. Courses will typically demonstrate the accounting concepts and then provide an Excel worksheet or practice problems to work through the concepts covered. The practice problems will be accompanied by an instructional video to work through the problem in step by step format. Excel worksheets will be preformatted, usually including an answer tab that shows the completed problem, and a practice tab where learners can complete the problem along with a step by step presentation video.

Mr. Steele makes learning accounting accessible by making use of technology and partnering with teaching platforms that have a vision of spreading knowledge.