256-337-5200 | info@biz-bob.com

Small Business Solutions
Sign up for a free consult button
  • Home
  • QuickBooks Products
    • QuickBooks Products
    • QuickBooks Online
    • QuickBooks Desktop
    • QuickBooks Enterprise Solutions
    • QuickBooks Time
    • Point of Sale
    • Payroll
    • Payments
    • Checks and Supplies
  • Support Services
  • Software Add-Ons
    • Software Add-Ons
    • QuickBooks Time
  • Resources
    • Resources
    • Download your Quickbooks Software
    • Intuit QuickBooks Support Numbers
    • Mobile Accounting Apps
    • Podcasts: Biz-Bob on the Radio
    • QBO Training Videos
    • System Requirements for QuickBooks® Software
  • Blog
  • About Us
    • About Us
    • Meet Our Expert Partners
    • Partner With Us
    • Send Us Your Referrals
    • Testimonials
  • Contact Us
  • Home
  • QuickBooks Products
    • QuickBooks Products
    • QuickBooks Online
    • QuickBooks Desktop
    • QuickBooks Enterprise Solutions
    • QuickBooks Time
    • Point of Sale
    • Payroll
    • Payments
    • Checks and Supplies
  • Support Services
  • Software Add-Ons
    • Software Add-Ons
    • QuickBooks Time
  • Resources
    • Resources
    • Download your Quickbooks Software
    • Intuit QuickBooks Support Numbers
    • Mobile Accounting Apps
    • Podcasts: Biz-Bob on the Radio
    • QBO Training Videos
    • System Requirements for QuickBooks® Software
  • Blog
  • About Us
    • About Us
    • Meet Our Expert Partners
    • Partner With Us
    • Send Us Your Referrals
    • Testimonials
  • Contact Us

Creating Inventory Items in QuickBooks

January 19, 2015 In QBO How To
Tweet
Share
Share
Pin

Whether you’re selling unique items or stocking dozens of the same kinds of products, you need to create records for each. When it comes time to create invoices or sales receipts, your careful work defining each type of item will:

  • Ensure your customers receive correct descriptions and pricing,
  • Provide needed information about inventory levels, and
  • Help you make smart reordering decisions.

Follow these steps to setup your QuickBooks (QB) file to track inventory and to create items. 

Step 1:  QB File Setup – Open the Edit menu and select Preferences, then Items & Inventory. Click the Company Preferences tab and click in the box in front of Inventory and purchase orders are activated if there isn’t a check in the box already. Here, too, you can ask that QuickBooks warn you when there isn’t enough inventory to sell. Click OK when you’re finished.

Figure 1: You need to be sure that QuickBooks knows you’ll be tracking inventory before you start making sales.

 Step 2:  Create item – open the Lists menu and select Item List. Click the down arrow next to Item in the lower left corner of the window that opens and select New. The New Item window opens.

 Warning: You must be very precise when you’re creating item records in order to avoid confusing your customers and creating problems with your accounting down the road. Please call us if you want us to walk you through the first few items.

QuickBooks should display the list of options below TYPE. Since you’re going to be tracking inventory that you buy and sell, select Inventory Part. Enter a name and/or item number in the next field. This is not the text that will appear on transactions; it’s simply for you to be able to recognize each item in your own bookkeeping.

Figure 2: Let us work with you if you have any doubts about the data that needs to be entered in the New Item window. It must be 100 percent accurate.

 

In the example above, the box next to Subitem of has a check mark in it because “Light Pine” is only one of the cabinet types you sell (you can check this box and select <Add New> if you want to create a new “parent” item on the fly). Leave the next field blank if your item doesn’t have a Part Number, and disregard UNIT OF MEASURE unless you’re using QuickBooks Premier or above.

Fill in the PURCHASE INFORMATION and SALES INFORMATION fields (or select from the lists of options). Keep in mind that the descriptive text you enter here will appear on transaction forms, though customers will never see what you’ve actually paid for items, of course (your Cost, as opposed to the Sales Price). 

QuickBooks should have automatically selected the COGS Account (Cost of Goods Sold), but you’ll need to specify an Income Account. Please ask us if you’re not sure, as this is a critical designation. The Preferred Vendor and Tax Code fields will display lists if you’ve already set these up.

QuickBooks should have pre-selected your Asset Account. If you want to be alerted when your inventory level for this item has fallen to a specific number (Min) so you can reorder up to the point you specify in the Max field, enter those numbers there (the Inventory to Reorder option must be turned on in Edit | Preferences | Reminders). 

If you already have this item in stock, enter the number under On Hand. QuickBooks will automatically calculate Average Cost and On P.O. (Purchase Order).

Click OK when you’ve completed all of the fields. This item will now appear in your Item List, and will be available to use in transactions. When you want to create, edit, delete, etc. any of your items, simply open the same menu you opened in the first step here (Lists | Item List | Item).

Figure 3: The Item menu, found in the lower left corner of the Item List
Precisely created Inventory Part records are critical to accurate sales and purchase transactions. So use exceptional care in building them.  If you would like additional training and/or tips, contact us at 256-337-5200.
The “QB Bob” Team
Tweet
Share
Share
Pin
accounting QuickBooks assistance QuickBooks Best Practices QuickBooks company file errors QuickBooks help QuickBooks Items QuickBooks Items and Inventory QuickBooks tips quickbooks training

Monthly Archives

Categories

  • Accounting Software Tips (6)
  • Accounting Tips (22)
  • Backup Services (1)
  • Blog (5)
  • Bookkeeping Tips (8)
  • Business Tips (112)
  • Contractors (1)
  • Inventory Management (1)
  • Merchant Services (1)
  • News (3)
  • Online Banking (3)
  • Payroll Tips (8)
  • Personal Development (11)
  • Profitability Tips (10)
  • QB Desktop How To (17)
  • QB Point of Sale (5)
  • QBO How To (85)
  • QuickBooks (37)
  • QuickBooks Hosting and File-Sharing (1)
  • QuickBooks QuickTips (10)
  • Sales Tax Management (2)
  • Small Business Resource (1)
  • Tax Tips (6)
  • Technology Tips (15)
  • Time-Tracking (6)

Sitemap

  • Home
  • QuickBooks Products
    • QuickBooks Online
    • QuickBooks Desktop
    • QuickBooks Enterprise Solutions
  • Support Services
  • Software Add-Ons
  • Resources
  • Blog
  • Testimonials
  • ABOUT US
  • Contact Us

Contact Us

Small Business Solutions

(256) 337-5200 | info@biz-bob.com


Intuit, QuickBooks, and QuickBooks ProAdvisor are registered trademarks of Intuit Inc. Used with permission under the QuickBooks ProAdvisor Agreement.

Sign up for a free consult Small Business Solutions

Copyright Small Business Solutions 2022 | Professional Site Design by Accelerator Websites | Powered By ThriveFuel