Quickbooks Inventory

Learn Every Possible Merchandise Inventory Situation In QuickBooks

Last updated 2022-01-10 | 4.5

- Perform Any Task Related To Managing Inventory / Merchandise Records
- Record Any Inventory Related Transacion
- Interpret Inventory Reports For Optumization

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

* Requirements

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

Description

  • 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

2 sections • 26 lectures

Welcome to QuickBooks Inventory Preview 03: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) Preview 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 QuickBooks Preview 07: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 Items Preview 05: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 cash Preview 06:39

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

Debits And Credits Of Selling Inventory -Perpetual System In QuickBooks Desktop Preview 12:18

Recording Merchandise sales in QuickBooks Preview 08: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) Preview 03: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 the receiving the Bill Preview 08: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 transactions Preview 03: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 Orders Preview 10: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 Orders Preview 07: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 value Preview 07: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 Measure Preview 09:19

Multiple Units Of Measure With Pre-Set Units Preview 17:40

Custome Units Of Measure And Bulk Sales Preview 17:07

Changing Purchase Costs And Weighted Average Inventory Method Preview 14:03

Price levels For Inventory And Service Preview 09:11

RetroActive Purchase Cost Changes Preview 05:28

Refunding Cash And Credit Sales Of Merchandise Preview 09:57

Getting A Vendor Refund For Merchandise Returns Preview 11:18

QuickBooks Inventory concepts test

This test will check your understanding and memory of the most important ideas in this course

Prepaid Inventory Preview 11:46

I made this video so that you would have knowledge of every possible inventory situation!!

This is a special method that I, Mark Smolen, created many years ago and it works perfectly!!

If your company pays "IN ADVANCE" for inventory that you mark up and re sell to a customer, this video is perfect for you. Enjoy!!

Bonus video- running balance for pre-paid inventory Preview 10:44

Use this technique if you are using the "pay from prepaid" method by Mark Smolen, for managing your inventory AND YOU ABSOLUTELY NEED TO SEE THE RUNNING BALANCE OF THE VENDOR; the balance at any particular moment in time.  

What Is The "Periodic" Inventory Method/System ? Preview 17:36

Demo Of Periodic Cost Of Goods Sold Adjustment With Amazon Store Example Preview 15:39