Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn QuickBooks Inventory Management
Rating: 4.4 out of 5(136 ratings)
1,113 students
Created byMark Smolen
Last updated 12/2022
English

What you'll learn

  • Perform Any Task Related To Managing Inventory / Merchandise Records
  • Record Any Inventory Related Transacion
  • Interpret Inventory Reports For Optumization
  • Find And Fix Mistakes Related To Inventory
  • Use Different Inventory Item Types In The Right Situation
  • Find The Accounts In The Chart Of Accounts That Change When Inventory Changes
  • Adjust Inventory For Unusual Situations
  • Track Inventory Quantity After Each Purchase, Sale Or Return
  • Make Item Receipts And Enter Related Bills
  • Record Purchase And Sales Returns
  • Use Unit Of Measure Feature Of Inventory
  • Use The Price Levels feature
  • Understand How Quickbooks Desktop Calculates Cost Of Goods Sold
  • Understand The Weighted Average Costing Method
  • Record Purchase And Sales Returns Of Inventory
  • Record Advanced Payments And Prepaid Inventory
  • Use The Periodic Inventory System With Quickbooks
  • Make Inventory Monthly Adjustments
  • Calculate Monthly Cost Of Goods And Gross Profit Periodic Adjustment
  • Record And Track Prepaid Inventory

Course content

3 sections26 lectures4h 7m total length
  • Welcome to QuickBooks Inventory3:28

    This QuickBooks training course will give you everything you need to know about using the inventory module in QuickBooks Accounting desktop versions for windows.

    You will learn in QuickBooks, how to add “non-inventory” parts to the items list and when to use non-inventory parts. It teaches how to activate the QuickBooks inventory module and what inventory activation does to the QuickBooks file. Every possible inventory transaction is covered in this course. This QuickBooks tutorial shows how to record sales both "on account" and for cash as well as purchases of inventory "on account" or for cash. It shows how to use the purchase order documents as well as purchase order reports to track back orders in QuickBooks. Sales orders and related reports are also discussed and demonstrated.

    You will learn how to use inventory reports and how to find and fix inventory mistakes. At the end of the course, you will learn how to adjust inventory for unusual situations. You will also be shown a SPECIAL METHOD created by me to handle PREPAID INVENTORY transactions. The class gives real hands on practice with buying and selling transactions in QuickBooks.

    This QuickBooks instructional series even teaches some basic accounting inventory concepts; specifically, the "Perpetual" inventory method of inventory valuation in QuickBooks. It will be understandable in common sense terms without accounting knowledge.

    There are 'follow along files” for each lecture so you can follow step by step. This makes learning QuickBooks Easy and fun.

    The course is made with QuickBooks desktop for windows. However, the ideas apply to QuickBooks online as well as QuickBooks for Macintosh and Enterprise solutions.

    I'm right here for you if you have any questions or need support. I hope you learn well and enjoy the course!

    -Mark


  • Using "non-inventory" parts ( 2 sided items)10:53

    This lecture will show you what "non-inventory" items types are. It will show how and when they should be used. You will learn what effect these items have on the results of your QuickBooks reports.

  • Activating Inventory in QuickBooks7:27

    You will clearly see the difference between the file before you activate inventory and the file after you activate inventory.

    You will be able to do it yourself in quickbooks and understand what it means.

  • Putting in Inventory Items5:10

    Inventory items must be added to the items list the same way that the service items were. You will see the specific things you need to do this and understand what effect it will have on the transactions and the reports

  • Purchasing Merchandise For Cash6:39

    You will learn how to record merchandise purchases where you pay immediately upon receiving the merchandise. You will understand what accounts in the chart of accounts change when you purchase merchandise and pay immediately. You will be introduced to the most important inventory report.

  • Debits And Credits Of Selling Inventory -Perpetual System In QuickBooks Desktop12:18
  • Recording Merchandise Sales In QuickBooks8:58

    You will see the results of your quickbooks records change when you record a sale of merchandise. This video covers cash and "on acount" merchandise sales

  • Purchasing Merchandise "on account" (for credit)3:54

    Buying inventory "on account" will require that you enter the vendors bill. You will see how it is a little different than entering a bill for a service.

  • Receiving Merchandise Before Receiving The Bill8:49

    If you recive merchandise before the bill for that merchandise, the documnet you enter is called an item reciot. It will match with the bill whe the bill comes later

  • Mix Practice With Inventory Transactions3:12

    This practice set will help you remember and help you understand the inventory transactions that you learned. After recording the transctions, you must compare your results to the results in the video. If you have any difference, you have to use what you learned to find and fix your mistakes

  • Recording Purchase Orders10:09

    Purchase orders are documents tht do NOT represent transactions. You will learn how to record them and what effect they have when you order and when you receive the ordered merchandise

  • Recording Sales Orders7:26

    Sales orders are documents tht do NOT represent transactions. You will learn how to record them and what effect they have when you order and when you receive the ordered merchandise

  • Adjusting Inventory Quantity And Value7:55

    sometimes the quantity or value of innventory changes for an unusual reason. You will learn how to record this issue and understand the effect of this in the quickbooks records


  • Set Up Single Unit Of Measure9:19
  • Multiple Units Of Measure With Pre-Set Units17:40
  • Custome Units Of Measure And Bulk Sales17:07
  • Changing Purchase Costs And Weighted Average Inventory Method14:03
  • Price Levels For Inventory And Service9:11
  • RetroActive Purchase Cost Changes5:28
  • Refunding Cash And Credit Sales Of Merchandise9:57
  • Getting A Vendor Refund For Merchandise Returns11:18
  • QuickBooks Inventory concepts test

Requirements

  • Elementary school level math skills
  • Basic computer skills
  • Basic understanding of buying and selling

Description

This QuickBooks training course will give you everything you need to know about using the inventory module in QuickBooks Accounting desktop versions for windows. You will be an absolute expert in everything that relates to buying and selling merchandise when using QuickBooks. These videos will give you the clearest possible explanation for every topic covered.

You will learn in QuickBooks, how to add “non-inventory” parts to the items list and when to use non-inventory parts. It teaches how to activate the QuickBooks inventory module and what inventory activation does to the QuickBooks file. Every possible inventory transaction is covered in this course. This QuickBooks tutorial shows how to record sales both "on account" and for cash as well as purchases of inventory "on account" or for cash. It shows how to use the purchase order documents as well as purchase order reports to track back orders in QuickBooks. Sales orders and related reports are also discussed and demonstrated.

Merchandise returns are transactions that many people have trouble understanding. This course will make procedures for customer returns as well as returns to vendors perfectly clear and simple. You will receive a special demonstration on how to use the ‘units of measure” feature as well as the “price levels” feature so you can maximize the use of your inventory module and manage everything exactly how you choose to buy and sell your merchandise.

You will learn how to use inventory reports and how to find and fix inventory mistakes. At the end of the course, you will learn how to adjust inventory for unusual situations. You will also be shown a SPECIAL METHOD created by me to handle PREPAID INVENTORY transactions. The class gives real hands on practice with buying and selling transactions in QuickBooks.

This QuickBooks instructional series even teaches some basic accounting inventory concepts; specifically, the "Perpetual" inventory method of inventory valuation in QuickBooks. It will be understandable in common sense terms without accounting knowledge. You will also get an overview of other accounting theory that relates to inventory such as how QuickBooks Desktop will calculate changing purchase cost of merchandise using the “weighted average” costing method. You will also get the best explanation and demonstration of the other method of inventory coting, the “periodic” inventory method. These demonstrations will give you the ability to use the periodic inventory method and help you make your cost of goods sold adjustment to find your gross profit.

There are 'follow along files” for each lecture so you can follow step by step. This makes learning QuickBooks Easy and fun.

The course is made with QuickBooks desktop for windows. However, the ideas apply to QuickBooks online as well as QuickBooks for Macintosh and Enterprise solutions.

I'm right here for you if you have any questions or need support. I hope you learn well and enjoy the course!

-Mark


Who this course is for:

  • Anyone who needs to manage inventory in their company
  • Anyone studyng for the certified quickbooks user exam
  • Anyone who needs to track quantity of inventory items
  • Anyone who needs to see cost, sales and profit for each separate inventory items
  • Anyone who needs to adjust inventory records for Theft, Damage or Obsolescence or Disaster
  • Anyone who needs to record purchase or sales returns of merchnadise
  • Anyone who uses "Price levels" for special customers
  • Anyone who needs to understand how Quickbooks Desktop Calculates changing purchase costs of inventory
  • Anyone using "non-inventory parts"
  • Anyone who needs to record purchase and sales returns and refunds
  • Anyone who sells in multiple units of measure for thier merhandise
  • Anyone who needs to predict the cost of goods sold for sales of merchandise
  • Anyone who wants to clearly understand the weighted average costing system
  • Anyone who's company needs to use the periodic inventory system for their company
  • Anyone who needs to do a monthly inventory adjusment to calculate cost of goods sold and gross profit
  • Anyone who prepays for their inventory