Inventory and Purchase Orders

1. Inventory and Purchase Orders

2. Objectives • Activate the Inventory function • Set up Inventory Items in the Item list • Use QuickBooks to calculate the average cost of inventory • Record sales of Inventory using sales forms • View the accounting entries behind the scenes of inventory sales using the Transaction Journal report • Use purchase orders to order inventory • Receive against purchase orders • Adjust your inventory • Create Inventory Assembly Items and Build Assemblies • Create reports about inventory

3. QuickBooks Tools for Tracking Inventory The Vendor Navigator shows a graphical representation of the steps involved in managing inventory

4. Summary of Inventory Transactions

5. Tracking Inventory with QuickBooks • When you use Inventory Part Items to track your inventory, QuickBooks handles all the accounting for you automatically • QuickBooks keeps a perpetualinventory, meaning that every purchase and every sale of inventory immediately updates all your account balances and reports • When QuickBooks calculates the cost of inventory, it uses the average cost method and does not support the first-in, first-out (FIFO) or last-in, first-out (LIFO) methods

6. Objective Activate the Inventory function

7. Activating the Inventory Function • The first step in using QuickBooks for inventory is to activate Inventory in your company Preferences • Select the Edit menu and then select Preferences • Scroll down in the Preferences window and click on Purchases & Vendors • Click the Company Preferences tab • Make sure that the box next to Inventory and purchase orders are active is checked

8. Accounts for Tracking Inventory

9. Objective Set up Inventory Items in the Item list

10. Setting up Inventory Items Parts • Select the Lists menu and then select Item List. • Select the Item menu at the bottom of the list and then select New • Select Inventory Part from the Type drop-down list

11. Setting up Group Items • Group Items allow you to bundle products and/or services on sales forms • While setting up a new item, Select Group from the Type drop-down list • List each item that is included with this group and indicate the quantities of each item

12. Objective Use QuickBooks to calculate the average cost of inventory

13. Calculating Average Cost of Inventory • When you use an inventory Item on a purchase form (e.g., a Bill) • QuickBooks increases (Debits) the Inventory Asset account for the actual cost of the inventory purchase and recalculates the average cost of all Items in inventory • When you use an inventory Item on a sales form (e.g., an Invoice) • QuickBooks increases (debits) Cost of Goods Sold and decreases (credits) Inventory Asset for the average cost of the items • Each time you sell inventory Items • The average cost per unit is multiplied by the number of units sold • Then this amount is deducted from the Inventory Asset account and added to the Cost of Goods Sold account

14. Example of Average Cost of Inventory

15. Objective Record sales of Inventory using sales forms

16. Selling Inventory Items Using an Invoice Form When you sell inventory, always use an Invoice or a Sales Receipt to record the sale

17. Objective View the accounting entries behind the scenes of inventory sales using the Transaction Journal report

18. Creating a Transaction Journal Report To see how this Invoice affects the General Ledger, use a Transaction Journal report • Select the Reports menu and then select Transaction Journal (or press CTRL+Y)

19. Objective Use purchase orders to order inventory

20. Purchase Orders • Use Purchase Orders to track inventory purchases, and to easily determine which items you have on order • If you use purchase orders, you’ll be able to create reports that show what is on order and when it is due to arrive • Purchase orders do not post to the Chart of Accounts, however, QuickBooks tracks Purchase Orders in a non-posting account called Purchase Orders (at the bottom of your Chart of Accounts) • Select the Vendors menu and then select Create Purchase Orders

21. Objective Receive against purchase orders

22. Options for Receiving Inventory • You have two options for receiving inventory: • You could pay for items at the time you receive them • In this case, you’ll use Write Checks or Enter Credit Card Charges to record your receipt of inventory • Alternatively, you could issue a purchase order and later receive part or all of the order • If the bill doesn’t accompany the shipment, use the Receive Items function • When the bill comes, use the Enter Bill for Received Items function • If you receive the bill when you receive the order, use the Receive Items with Bill function

23. Receiving Inventory Following situations may arise when you are receiving inventory • Purchasing Inventory at a Retail Store with Check or Credit Card • Receiving Shipments against Purchase Orders • Creating Open Purchase Orders Reports • Checking Purchase Order Status • Entering the Final Shipment • Entering Bills for Received Inventory • Handling Over shipments • Handling Vendor Overcharges

24. Purchasing Inventory at a Retail Store with Check or Credit Card • If you buy inventory at a retail store, use the Write Checks or Enter Credit Card Charges functions to record the purchase • Record the purchased items using the Items tab at the bottom of the check or credit card charge window

25. Receiving Shipments against Purchase Orders • Select the Vendors menu and then select Receive Items • If you select to use the open purchase order, QuickBooks fills in the Item Receipt with the information from the Purchase Order • When you record an Item Receipt, • QuickBooks increases (credits) Accounts Payable for the total amount of the Item Receipt • It also increases (debits) Inventory for the same amount

26. Creating Open Purchase Orders Reports Select the Reports menu, select Purchases, and then select Open Purchase Orders

27. Checking Purchase Order Status • You can see what’s been received already on this PO • The whole PO remains “open” until all items are received

28. Entering the Final Shipment When the final shipment arrives, enter another Item Receipt

29. Entering Bills for Received Inventory • Select the Vendors menu and then select Enter Bill for Received Items • Enter the vendor name and press TAB to see a list of shipments received from this vendor • Select one shipment at a time to record the amount of the bill for each • QuickBooks displays the Item Receipt and automatically checks the Bill Received box

30. Keep Over shipments • Override the number In the Qty column on the Item Receipt • This increases the Inventory Asset and Accounts Payable accounts for the total amount of the shipment, including the over shipment • When the bill arrives from the vendor, match it with the Item Receipt and pay the amount actually due

31. Send Back Over shipments • Override the number in the Qty column on the Item Receipt so that it exceeds the quantity on your Purchase Order • This increases the Inventory Asset and Accounts Payable accounts for the total amount of the shipment, including the over shipment • When you return the excess items, create a Bill Credit for the vendor • On the Bill Credit, enter the quantity returned and the cost for each item • If you receive a refund from the vendor, record the refund • To apply the Bill Credit to an unpaid bill for that vendor, use the Pay Bills window

32. Handling Vendor Overcharges • If the vendor refunds your money, • add the refund directly onto your next deposit • Code the deposit to the account and class you used when you recorded the overcharge on the bill • If the vendor sends you a credit memo • Enter a Bill Credit • Code the Bill Credit to the account and class you used when you recorded the overcharge on the bill

33. Objective Adjust your inventory

34. Adjusting Inventory • Inventory can be manually adjust in case of • An increase or decrease in the value of your inventory on hand • Change quantity of inventory items • Select the Vendorsmenu, select Inventory Activities, and then select Adjust Quantity/Value on Hand

35. Adjusting the Quantity of Inventory on Hand

36. Adjusting the Value of Inventory Click on the Value Adjustment box to change inventory value

37. Objective Create Inventory Assembly Items and Build Assemblies

38. Inventory Assemblies (only available in QuickBooks Premier) • If you build or assemble items from raw materials, you can create an Inventory Assembly Item in QuickBooks to track your assembled inventory • An Inventory Assembly is defined by specifying which components (must be inventory items) are needed to produce it • Essentially, you define the Bill of Materials for each Inventory Assembly Item when you set up the item. • When you “build assemblies” from Inventory Items into Assembly Items, QuickBooks automatically adjusts the quantities and values on hand of the inventory items (components) and the assemblies (finished goods)

39. Objective Create reports about inventory

40. Inventory Reports • Inventory Item QuickReport • Inventory Stock Status by Item Report • Inventory Stock Status by Vendor Report • Inventory Valuation Summary Report • Inventory Valuation Detail Report

41. Summary of Key Points • Activate the Inventory function • Set up Inventory Items in the Item list • Use QuickBooks to calculate the average cost of inventory • Record sales of Inventory using sales forms • View the accounting entries behind the scenes of inventory sales using the Transaction Journal report • Use purchase orders to order inventory • Receive against purchase orders • Adjust your inventory • Create Inventory Assembly Items and Build Assemblies • Create reports about inventory