QuickBooks Inventory offers both standard and advanced features. Standard features include tracking backorders, units of measure, assembly builds, and custom fields. Advanced Inventory includes multiple warehousing, bins, barcoding, and more. Learn how to boost efficiency with QuickBooks Inventory. Feel free to reach out to me if you need help with QuickBooks Inventory in Fort Worth, Texas, or remotely in any location.

Standard QuickBooks Inventory Features

The standard inventory features alone bring many things to the table. View reports on profitability by sales item, automatically create purchase orders based on when specific inventory items get low, automatically increase the sales price on items when a supplier increases their price, add special price levels for customers, add pictures of inventory items…the list is almost endless. Here are some other standard features that can help run your warehouse:

Track Backorders: Easily track inventory backorders on both Purchase Orders and Invoices.

Units of Measure: Need to buy by the gallon and sell by the ounce? Buy by the case and sell each piece individually? QuickBooks can even track raw material usage in a manufacturing process. Your inventory report will show the remaining number of pieces, ounces, etc.

Assembly Process: Do you assemble raw materials into new inventory items? QuickBooks will allow you to input a list of items (Build of Materials) used to manufacture new completed parts. Keep track of how many finished (assembled) products you have on hand and raw materials in stock. Sub-assemblies can also be used.

Custom Fields: Do you have some special information that you need to add to Order Forms, Invoices, Reports, and other forms? QuickBooks Enterprise can create these fields and even include special drop-down options on forms such as invoices. An example of a custom field could be a shelf. This would allow QuickBooks to track inventory by both shelf and bin locations. Another example could be a color or size. If you sell shirts, a column could be added to invoices to indicate the color, size, etc. Custom fields can also be added to purchase forms.

Feel free to reach out to me if you need help with QuickBooks Inventory in Fort Worth, Texas.

Advanced QuickBooks Inventory Features

  • Track inventory by multiple locations, including warehouses and bins. Any location can be tracked as a “warehouse,” including service trucks.
  • Track items by lots or serial numbers.
  • Use FIFO instead of Average Cost for an Inventory Valuation Method
  • Auto-create barcodes with existing part numbers or import your own. Print labels with both number and description.
  • Other Advanced QuickBooks Inventory features include site operations, paperless shipping, and a free warehouse app.

Warehouses and Bins

Receive, sell, and even transfer inventory by location. View reports instantly on the quantity of any item by warehouse or bin location. Each item can be kept at multiple locations.

  • QuickBooks will track inventory by one or more warehouses and bins within each warehouse.
  • Easily transfer inventory from one warehouse to another.

Standard reports are available to show the quantity of inventory in each warehouse location. Reports include:

  • Items by Bin Location
  • Quantity on Hand by Site
  • Inventory Valuation Summary by Site
  • Inventory Stock Status by Site
  • Assembly Shortage By Site

Your inventory can be imported from Excel into QuickBooks with Warehouse and Bin Location. No need to hand enter if you are converting from another software.


Serial or Lot Numbers

  • Transaction List by Lot or Serial Number
  • Lot or Serial Numbers in Stock
  • Lot or Serial Numbers in Stock by Site

We can import your existing inventory with Lot or Serial numbers. This can save hours of input time.

FIFO

Advanced Inventory offers FIFO layers to track inventory and custom reports are included.

Barcoding

QuickBooks can easily create barcode labels using a Barcode Wizard included with Advanced Inventory. The Barcode Wizard will create new numbers for you, use inventory part names, manufacturer part numbers, or even custom fields.

Barcoding can be used when receiving, selling, and even when transferring inventory from one location to another.

Advanced Site Operations finally allows you to run your entire Warehouse without paper! No computer is needed in the Warehouse, just handheld devices!

Site Operations

Receiving

From within QuickBooks, users can send Purchase Orders to be received on handheld devices in the warehouse. Using the free Android Mobile Warehouse App, warehouse workers can receive against the purchase order. Once they indicate how much of each item was received, they send the information back to QuickBooks. Warehouse workers can even make notes on damages and item shortages!

  1. Select the Purchase Order to be received
  2. Choose the Warehouse
  3. Send to a Device
  4. You are prompted to Send the request to a Receiver
  5. The receiver sees the PO on his or her device and enters the quantity received along with any note such as damages or shortages
  6. The receiver sends back the information to QuickBooks. No computer terminal is needed in the warehouse. No paper, no computer! You will now see the purchase order has been received. Click the button at the bottom of the screen, “Create Item Receipt,” and you are done!

Shipping

Site Operations also includes shipping. From within QuickBooks Enterprise and Advanced Inventory, users can send Sales Orders to be Picked or Packed.

Site Operations will even update forms. Sales Orders will be marked as picked or packed.

Mobile Warehouse App

Here is what a receiver in the warehouse can do with a handheld device:

Receive Inventory on Purchase Orders
Pick Inventory for Shipping
Pack Inventory for Shipping
Cycle Counting Inventory
 

The QuickBooks Mobile Warehouse App allows you to run a paperless warehouse. An incredible time savings. No more lost or torn forms!

Cycle Counting

Another way to boost efficiency with QuickBooks inventory is to use the Mobile Warehouse App. Warehouse workers can update inventory counts with their handheld devices. Updated counts are sent back to QuickBooks, and an inventory adjustment can be automatically created by the user in QuickBooks for any variances.

Items to be included in a cycle count can be imported from Excel or easily selected within QuickBooks.

There are many more ways you can boost efficiency with QuickBooks inventory. Feel free to reach out to me if you need help with QuickBooks Inventory in Fort Worth, Texas.

How I can Help You

  • Work with your team to clean-up inventory
  • Organize your warehouse and use cycle counts to maintain inventory accuracy
  • Develop monthly reports to alert you to inventory problems
  • Train your staff
  • Provide on-going support

Tim Plue

I am an Advanced Certified QuickBooks ProAdvisor. I have taught QuickBooks and Bookkeeping classes for over 12 years. I help small business owners run their business with QuickBooks. I can meet you onsite or remotely.