 |
Inventory Management, Part 2: Receiving Items
 Purchase orders, partial deliveries, overages receiving vendor shipments into inventory can be a complicated task. But don't fret; we've got it covered in QuickBooks Manufacturing & Wholesale Edition 2006. First you'll create purchase orders to request merchandise. Then you receive the shipment and record the bill.
The Process
Follow the simple process below to receive vendor shipments into inventory:
Receiving: Bill arrives with shipment
Receiving: Bill arrives separately
What if there's no PO?
An example: Pool supplies
As an example, consider Johnson Brothers Poolside Ventures LLC. As a wholesaler Johnson Brothers orders and receives dozens of parts each day. Each morning the owner, Jerry Johnson, checks the Inventory Reorder Report by Vendor (Mfg & Whsle menu > Manufacturing & Wholesale Reports). Today Jerry sees he needs to reorder 11 aqua pool covers and 111 clear track tops from Lipps Pool Supplies to replenish inventory.
To order from Lipps Pool Supplies, Jerry creates and sends a purchase order. When the shipment arrives, Jerry checks the packaging list against his purchase order. He then uses Receive Items to receive the items into inventory. When Jerry receives the bill from Lipps a few days later, he enters the bill into QuickBooks.
Purchase Orders Keep It Tidy
When ordering inventory from vendors we suggest you create purchase orders. Purchase orders keep your inventory records in ship shape. They also let you see what you've ordered by running the Open Purchase Orders report.
Quick Tip: Tips for setting up inventory items Before creating purchase orders you must turn it on in preferences. From the Edit menu select Preferences > Purchases and Vendors. From the Company Preferences tab, select the "Inventory and purchase orders are active" checkbox.
To create a purchase order, follow these steps:
- Go to the Vendors menu and click Create Purchase Orders.
- Click the Vendor drop-down list and choose an existing vendor or enter a new vendor.
- (Optional) Change the entries in the Vendor (address), Date, P.O. No, Ship To, Expected, or FOB fields.
- Fill in the line item area by entering the items you're ordering, just like line items on an invoice.
- Save the purchase order.
Now, when your order arrives, you'll have a record to compare against the packing list.
Option 1: Bill Arrives with Shipment
How you receive vendor items into inventory varies slightly whether you received the bill with the shipment, or if it will arrive separately (more typical; see below). Follow these four steps if your shipment includes a bill from the vendor:
Step 1: Open a new item receipt with bill
- From the Vendors menu select Receive Items and Enter Bill. The Enter Bills window opens with the Bill Received box checked.
Step 2: Select the vendor and purchase order
- Select the vendor's name.
-QuickBooks displays a list of the vendor's open purchase orders.
- QuickBooks lets you know the vendor has open purchase orders. Select yes.
-QuickBooks displays a list of the vendor's open purchase orders.
- Select the purchase order matching the shipment and select OK.
-QuickBooks transfers the PO's contents to the Bill.
Step 3: Verify the PO against the packing list
- Check the packing list against the items from the PO.
-If necessary, access the original PO by selecting Show PO on the Enter Bill window.
Step 4: Record the shipment's items into QuickBooks
- Record the shipment's items into the Qty column on the Enter Bill window. Make sure to receive the exact items listed on the packing list.
- If this is a partial shipment, enter only those items you received. For example, if the PO lists a quantity of 10 but you receive only 5, change the quantity to 5.
- If you receive more items than originally ordered an overage determine whether to keep or return the goods. If you decide to keep the overage, change the quantity accordingly. If you don't want the overage, return them to the vendor.
Quick Tip: Display a list of open POs To quickly see your open purchase orders follow these steps:
- Select Vendors Center from the Vendors menu.
- Select the Transactions tab.
- Select Purchase Orders.
- Click the Filter By drop-down list and choose Open Purchase Orders.
-See more detail by double clicking on any purchase order in the list.
Option 2: Bill Arrives Separately
Typically the bill will arrive separately from the shipment. In that situation follow these five steps:
Step 1: Open a new item receipt only
- From the Vendors menu select Receive Items.
- The Create Item Receipts window opens with the Bill Received box unchecked.
- Notice that the Receipt displays "Item Receipt Only" indicating you are not now entering a bill, as seen in Figure 6 below.
Step 2: Select the vendor and purchase order
- Select the vendor's name.
- QuickBooks lets you know the vendor has open purchase orders. Select yes.
- QuickBooks displays a list of the vendor's open purchase orders.
- Select the purchase order matching the shipment and select OK.
-QuickBooks transfers the PO's contents to the Receipt.
Step 3: Verify the PO against the packing list
- Check the packing list against the items from the PO
-If necessary, access the original PO by selecting Show PO on the Create Item Receipts window.
Step 4: Record the shipment's items on the Receipt
- Record the shipment's items into the Qty column on the Receipt window. Make sure to receive the exact items listed on the packing list.
- If this is a partial shipment, enter only those items you received. For example, if the PO lists a quantity of 10 but you receive only 5, change the quantity to 5.
- If you receive more items than originally ordered an overage determine whether to keep or return the goods. If you decide to keep the overage, change the quantity accordingly. If you don't want the overage, return them to the vendor.
Step 5: Record the bill when it arrives
When the bill arrives from the vendor QuickBooks will turn the receipt into a bill.
- Select Enter Bill for Received Items from the Vendors menu.
- Select the vendor from the list.
-QuickBooks lists the vendor's outstanding item receipts.
- Choose the receipt you entered when the order arrived.
-When you click OK, QuickBooks turns the receipt into a bill. Make any changes or edits, then click Save & Close.
Quick Tip: What happens in QuickBooks? After you save the bill or receipt, QuickBooks:
- Increases your accounts payable by the amount shown on the item receipt.
- For each inventory item on the receipt, adjusts the quantity in stock (thereby increasing your inventory asset account), lowers your quantity on order, and recalculates your average cost for each item.
What If There's No PO?
Sometimes you receive inventory without a purchase order. When that happens, follow these steps:
- Select Receive Items from the Vendors menu.
- Choose the vendor (or <add new>) from whom you received the items.
- Include a Ref No and Memo to help you identify the item receipt later.
- Click the Items tab and enter the relevant information as needed.
- Save the receipt.
If you received a bill with the order, make sure to check the Bill Received box. If not, leave it unchecked and record the bill when it arrives (Step 5 above).
Go Forth and Order Inventory
That's all there is to it. As a next step, try running the reports under Purchases from the Reports Center (accessed from the Reports menu). It's a good way to anticipate orders. Speaking of reports, we'll examine inventory-based reporting next time in Part 3.
Back to Top
|