How to Add Inventory in QuickBooks Desktop & Online?

We fine tune your business practices by organizing inventories properly. Download Dancing Numbers and add inventory in QuickBooks desktop and online. Once it is done, you may create checks, bills or expenses for updating the item quantity.

Voiced by Amazon Polly

Do you know what an inventory is? Let’s understand. Inventory is an indispensable asset for any company. Inventory is the component part and the raw part utilized by the company for production of goods or selling it. Company use different methods to manage inventory as it plays important role to ensure that there is an enough stock or not in company for production and selling. Learn how to add inventory in QuickBooks Desktop & Online.

Save Time, Reduce Errors, and Improve Accuracy

Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Desktop. Utilize import, export, and delete services of Dancing Numbers software.

To put it simply, inventory is the counting or listing of items. By keeping stock, both the retailers and manufacturer can work smoothly i.e if they have proper record they can easily produce/manufacture or sell products. Inventory describe any goods which are ready to purchase, it directly affects organization financial health. Inventory has many types that are:

  • Raw Materials
  • Components
  • Work in Progress
  • Finished Goods
  • Maintenance, Repair, Operations Goods
  • Packing of items and Packaging Materials for the items
  • Safety Stock of item and Anticipation Stock for the item
  • Decoupling Inventory
  • Cycle Inventory
  • Service Inventory
  • Transit Inventory
  • Theoretical Inventory
  • Excess Inventory

Inventory plays a vital/important role in company financial power, so it is very important to record it in accounts aptly. Inventory turnover helps organizations in decision making. Also, it enables them to take strategic decision for marketing, manufacturing and pricing of the goods.

QuickBooks Desktop have inbuilt feature of inventory. It helps in managing inventory. It also helps in keep a track of the inventory that is in stock. With this Feature of QuickBooks Desktop, you can easily keep a tab on inventory value after every sale and purchase of the goods. This feature helps in meeting the needs of the company by keeping proper check on the items/goods which are in warehouse. There are two conditions in this i.e

  • If there are too many items in the warehouse they are the head on charges for the company.
  • If there is low number of items in the warehouse the customers might look for it from somewhere else.

So, QuickBooks inventory Desktop helps in keeping stock up to date, so that company never encounter problem of high or low number of items in stock. QuickBooks inventory Desktop also has feature of Set the reminder. Setting of reminder helps in reminding you to know when the inventory is low after a certain point.

Why You Should Enter Items into QuickBooks Online Inventory?

Every business needs inventory since it allows you to keep track of your product stocks, sales, and when to reorder them. It also enables you to calculate whether you are making a profit on each product, whether you are losing money on it, and whether you should keep selling it or stop. The following list includes some advantages of uploading inventory to QuickBooks Online:

  • QuickBooks might keep track of the total cost per item sold over the course of a month.
  • It can help you in monitoring the sales of every product that is sold on your online store and identifying which products are not selling well enough to permit restocking.
  • With the help of this application, you may access all of the information about the products in your inventory and contact your supplier in advance to request a quote for the things that are selling quickly.

Adding of Inventory in QuickBooks Desktop

Once you turn on the feature of Inventory in QuickBooks Desktop. Steps to add inventory items in QuickBooks Desktop. The following are the Steps:

  • Select the services icon on the home page of QuickBooks.
  • After selecting it select items.
  • From the item dropdown menu select item and the click on New.
  • Click on type and from the type dropdown click on the Inventory Part. The number of options are displayed which is to be filled. The options are:
    • First enter item identifier in Item name/number field. In this one has to give the name of the items or serial number of the item. It helps in tracking, searching and identify item in future as per company need.
    • If you are using QuickBooks premier or above version then only fill the unit of measure field otherwise leave it blank.
    • Fill the purchase information in purchase field.
    • Fill the sale information in sales field.
    • After filling purchase and sales information QuickBooks automatically detect COGS account i.e Cost of Goods Sold Account.
    • In Income Account section fill the income account of the inventory. This will help in tracking income from this inventory.
    • After filling all the required information click on OK.

1. Turning on Advance Inventory Feature in QuickBooks

Advance inventory feature in QuickBooks Enterprise desktop help in using fallowing options. The Options are:

  • FIFO costing (First in First out Costing).
  • Multiple Location inventory.
  • Bar Code Scanning.
  • Bin or Lot Tracking.
  • Serial or Lot Tracking.
  • Sales Order Fulfillment Process.

Following are the steps to Turn On Advance Inventory feature in QuickBooks Enterprise Desktop. Steps are:

  • Choose Preferences option in the Edit menu.
  • Click on Items and Inventory from the left panel.
  • Select Company preferences from Items and Inventory drop down menu.
  • Tick on the inventory and purchase orders. It will bring it to active mode.
  • Click on Advance Inventory Setup.
  • If you are unable to set it then synchronize the license data online so that QuickBooks can recognize it.
  • Select the help menu.
  • Select manage my license in help menu.
  • Click on Synchronize License the data Online.
  • Advance inventory setting is active now. User can use its feature in adding inventory in QuickBooks Desktop.

2. Enable Inventory Management

To enable inventory management one should follow the following steps, They are:

  • Open the main menu then click on Edit from its dropdown.
  • Select Preferences as per company requirement.
  • After selecting preferences, from the left panel click on items and inventory.
  • Then again come to company preferences tab and tick the option of “Inventory and Purchase Orders are Active”.
  • In last click OK.

Inventory tracking is available in many versions of QuickBooks Desktop but the Pro version of QuickBooks Desktop Cannot use the FIFO (First In First Out) and LIFO (Last In First Out) method to track inventory.

3. Setting up Inventory for Tracking in QuickBooks Desktop

Once you created inventory in QuickBooks Desktop now you can easily track inventory in it as per your requirement. Following are the steps to track the inventory:

  • Select items and services from the Dashboard.
  • Click on the item and then select new.
  • Select inventory part.
  • Input all the important details like name of item, serial number of item etc.
  • Click on income account and select the account to track the inventory item.
  • Input all details of the inventory item which is asked.
  • Then click OK.

How to Add Inventory in QuickBooks Online

QuickBooks inventory online is the great solution for the inventory management. It provides both Features and Flexibility to the user. Following are the steps which are to be followed:

1. Enable Inventory Management in QuickBooks Online

In QuickBooks management and tracking are not enable default, you have to enable it. In order to enable these feature your QuickBooks must have subscription plan if it is there then only you can enable these features. To know subscription plan is enable or not just follow the following steps:

  • Select Gear On Icon.
  • Click on Account and Setting.
  • Click on Billing and Subscription.
  • Click on view plan in order to view full plan.
  • If the subscription plan is enable the its good otherwise enable it.

2. Enabling of Inventory Tracking in QuickBooks Online

To enable Inventory tracking you have to follow these following steps:

  • Firstly you have to go to setting on home page.
  • Then Select Account and Setting.
  • Then Choose Sales Option.
  • From sales option you have to go to Product and Service section.
  • Then just click on edit.
  • Now, you have to enable all the following features:-
    • In sales forms, show Product/Services column.
    • Track the inventory quantity in hand.
    • Track the Quantity and price per rate.
  • Click Save and it is done.

3. Input Details of the Items

It is important to input all necessary information of the item which is to be created. The information is like Product name, Product number, Product category etc. You can enter additional information of your inventory for better management of the data. You can also import excel sheet on QuickBooks Online if you created data of your inventory on excel sheet. Following are the steps to be performed to input information of the item:

  • Select Sales from the main menu.
  • Select product and services.
  • Select New or Add product and services.
  • Select the inventory.
  • Enter all the necessary information of the item. You can also add HSN no. of the items. By this information you can easily search or track the item easily in future.
  • Enter the unit for the item in Unit drop down menu.
  • Select the appropriate category for the item from the category drop down list.
  • Enter the quantity of the item available in stock in quantity of item block.
  • Select the date for tracking the item from the date field. Automatically tracking of item starts on the selected date.
  • Add low stock alert. It helps in giving you alert or reminder when stock in low in warehouse. It also start automatically when you enable it.
  • Select the appropriate account for your item from the inventory asset account dropdown menu.
  • You can also create new asset account to track item by clicking on inventory assets.
  • Now go on Sale form.
  • Add full detail information of product which you want to be seen on invoice, which is to be sent to the customer.
  • Input the Price/Rate of sale.
  • Click on income account dropdown menu open.
  • Select account to track the item or you can also add new account.
  • Select or check the option of inclusive of tax.
  • Click on Tax dropdown menu opens.
  • Select the appropriate tax rate which is applicable on that inventory item.
  • Now go to the purchase form.
  • Add description of the item which is to be sent to the vendor and this description will be displayed on the bill which is to be send to vendor.
  • Click on Expense Account dropdown menu appears.
  • Select the cost of sales which are used for tracking goods that are sold by the company.
  • Mark the inclusive tax option.
  • Click on purchase tax the drop down menu appears.
  • Select appropriate purchase tax for the item or add new one.
  • Add reverse charge which is related to the item as your wish.
  • If you prefer any item from the supplier you can add it here.
  • The item can be reorder repeatedly by the supplier.
  • After completing all the steps click on save.
  • Now you are done with it.

How to Add Inventory Products in QuickBooks Online

Inventory should be added to QuickBooks for each purchase and sale. Then, so that you don’t have to, let QuickBooks adjust the amount on hand as you work. Once everything is set up, adding items to sales forms and managing inventory in QuickBooks is easy. If you buy and sell products and services but don’t keep track of them as part of your inventory, here’s how to add items to QuickBooks.

Learn About Product and Service Types

  • Inventory: Products that you sell and keep track of quantity. For QuickBooks Online Plus and Advanced, inventory features are offered. Here’s How to turn on use inventory features.
  • Non-inventory: Items that you buy or sell but don’t have to keep track of amounts. For instance, you wouldn’t sell directly the nuts and bolts you use for installation work.
  • Service: Services you offer to customers.
  • Bundle: Several groups of services or products that you sell as a single item such as a basket of gifts.

Step 1: Turn on Inventory Tracking

You add inventory items, and make sure to enable inventory tracking.

Step 2: Add the SKU, Category, and Name of Your Product.

Add your inventory products once settings are in order.

  • Select Products & services under Get paid & pay.
  • Choose New or Add an product or service. Next, you have to choose Inventory.
  • For the thing you are tracking, enter a Name, SKU, or Category. Using categories will help you organize your goods and services so that they are simpler to find.
  • From the Unit* ▼dropdown menu, you have to choose the unit.
  • From the Category ▼ menu, Choose the appropriate category.

Step 3: Add Your Product’s Quantity, Inventory Asset Account, and Reorder Point

  • Include the Initial Quantity on Hand for your product. Then, in the As of date column, enter the date that you first began tracking that amount.
  • To receive notifications when it’s time to reorder, add a Reorder point. That third rectangle that you see is.
  • Inventory Assets should be selected from the ▼ dropdown menu for the Inventory Asset account. This account is used by QuickBooks to track the cost of all the stock you have (or inventory value).

Step 4: Add the Sales, Tax, and Purchase Information for Your Product

  • On sales forms, add a description of your product. This is visible on any documents you send to customers, including invoices and sales receipts.
  • Then add the Unit price
  • Add the Sales Rate or Price.
  • Find the account you use to track your sales by selecting the Income account ▼ drop-down.
    • Note: Use a QuickBooks income account that has already been set up for you, as a tip. However, if you require a new account, click + Add new at the top of the drop-down list. maybe first read up on the chart of accounts.
  • If applicable, you have to select the Inclusive of tax.
  • Choose the Sales Tax Category ▼ drop-down and indicate the appropriate tax rate for the purchased item. Set up sales tax in QuickBooks if you can’t see this drop-down.
  • On order forms, Include a description of your products. Bills, purchase orders, and other documents you send to vendors will reflect this.
  • Add the Cost of the product. Don’t worry if this changes. When you purchase supplies, you can still enter the most recent pricing.
  • Choose Cost of Goods Sold from the drop-down menu for the Expense Account ▼. QuickBooks uses this account to keep track of the costs associated with the products you sell.
  • If applicable, Click the Include Purchase Tax option.
  • Choose the appropriate Purchase Tax from the ▼ drop-down menu for purchase tax.
  • A Reverse Charge is added.
  • Choose a preferred vendor. You may quickly reorder this product since QuickBooks remembers your preferred provider.
  • Now you have to select Advance options.
  • SKU or category addition for the thing you are tracking. Note: You can categorize your products and services into categories to make them simpler to search.
  • At last, You have to click on Save and then close it.

You can use the same steps to set them up as you start selling new products.

So that’s easy to enter and maintain your inventory in Desktop and Online QuickBooks. It makes your work easier, faster, and correct in compare to other way. Just following these simple steps, you can easily understand how to add inventory in QuickBooks Desktop and QuickBooks Online. Do it once make it easy for future details.

In case you find trouble in working on it, you can connect with Dancing Numbers team via LIVE CHAT. We are usually equipped to solve our customer queries. Contact us we will give you instant solution. We can give you solution in any way you want i.e through chat process or on a call or through screen sharing. We are always ready to help our customer and give our best. So, now leave other way of adding inventory. Just add inventory in QuickBooks desktop and online. It will give you exact value of the inventory of your company in just few seconds. If any problem occurs in this we are here to serve you don’t worry.

Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.


Frequently Asked Questions (Faqs)

Can I Add New Inventory in QuickBooks Desktop?

Yes you can add Just go to menu then open the list, Select the item, Choose new and now add all information for adding inventory in QuickBooks Desktop.

How can I Adjust Inventory in QuickBooks Desktop?

Select the vendors and inventory activities the adjust the quality or value for the item then click on OK, your inventory is adjusted.

Can I Add Images in the Inventory Items, if Yes’ How?

Currently, adding images of each inventory is unavailable in QuickBooks but you can attach image or file type like invoice to the transaction.

What is the Meaning of QBD?

QBD stands for Quality by Design.

How to Add Product and Services QuickBooks online?

Just follow four easy steps in order to add it:

Add new product and services.
Add purchasing information of service and product.
Track all product and services item.
Delete product and services items.

Features of Dancing Numbers for QuickBooks Desktop

Imports

Imports

Exports

Exports

Deletes

Deletes

Customization

Customization

Supported Entities/Lists

Dancing Numbers supports all QuickBooks entities that are mentioned below:-

Customer Transactions

Invoice
Receive Payment
Estimate
Credit Memo/Return Receipt
Sales Receipt
Sales Order
Statement Charge

Vendor Transactions

Bill
Bill Payment
Purchase Order
Item Receipt
Vendor Credit

Banking Transactions

Check
Journal Entry
Deposit
Transfer Funds
Bank Statement
Credit Card Statement
Credit Card Charge
Credit Card Credit

Employee Transaction / List

Time Tracking
Employee Payroll
Wage Items

Others

Inventory Adjustment
Inventory Transfer
Vehicle Mileage

Technical Details

Easy Process

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Error Free

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

On-time Support

We provide round the clock technical assistance with an assurance of resolving any issues within minimum turnaround time.

Pricing

img

Importer, Exporter & Deleter

*See our Pricing for up to 3 Company Files

$199/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Unlimited Export
  • Unlimited Import
  • Unlimited Delete

img

Accountant Basic

*See our Pricing for up to 10 Company Files.

$499/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer,Exporter,Deleter
  • Unlimited Users
  • Unlimited Records
  • Upto 10 companies

img

Accountant Pro

*See our Pricing for up to 20 Company Files.

$899/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 20 companies

img

Accountant Premium

*See our Pricing for up to 50 Company Files.

$1999/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 50 companies

Dancing Numbers: Case Study

Frequently Asked Questions

 
How and What all can I Export in Dancing Numbers?

You need to click "Start" to Export data From QuickBooks Desktop using Dancing Numbers, and In the export process, you need to select the type you want to export, like lists, transactions, etc. After that, apply the filters, select the fields, and then do the export.

You can export a Chart of Accounts, Customers, Items, and all the available transactions from QuickBooks Desktop.


How can I Import in Dancing Numbers?

To use the service, you have to open both the software QuickBooks and Dancing Numbers on your system. To import the data, you have to update the Dancing Numbers file and then map the fields and import it.


How can I Delete in Dancing Numbers?

In the Delete process, select the file, lists, or transactions you want to delete, then apply the filters on the file and then click on the Delete option.


How can I import Credit Card charges into QuickBooks Desktop?

First of all, Click the Import (Start) available on the Home Screen. For selecting the file, click on "select your file," Alternatively, you can also click "Browse file" to browse and choose the desired file. You can also click on the "View sample file" to go to the Dancing Numbers sample file. Then, set up the mapping of the file column related to QuickBooks fields. To review your file data on the preview screen, just click on "next," which shows your file data.


Which file types are supported by Dancing Numbers?

XLS, XLXS, etc., are supported file formats by Dancing Numbers.


What is the pricing range of the Dancing Numbers subscription Plan?

Dancing Numbers offers four varieties of plans. The most popular one is the basic plan and the Accountant basic, the Accountant pro, and Accountant Premium.


How can I contact the customer service of Dancing Numbers if any issue arises after purchasing?

We provide you support through different channels (Email/Chat/Phone) for your issues, doubts, and queries. We are always available to resolve your issues related to Sales, Technical Queries/Issues, and ON boarding questions in real-time. You can even get the benefits of anytime availability of Premium support for all your issues.


How can I Import Price Level List into QuickBooks Desktop through Dancing Numbers?

First, click the import button on the Home Screen. Then click "Select your file" from your system. Next, set up the mapping of the file column related to the QuickBooks field. Dancing Numbers template file does this automatically; you just need to download the Dancing Number Template file.

To review your file data on the preview screen, just click on "next," which shows your file data.


What are some of the features of Dancing Numbers to be used for QuickBooks Desktop?

Dancing Numbers is SaaS-based software that is easy to integrate with any QuickBooks account. With the help of this software, you can import, export, as well as erase lists and transactions from the Company files. Also, you can simplify and automate the process using Dancing Numbers which will help in saving time and increasing efficiency and productivity. Just fill in the data in the relevant fields and apply the appropriate features and it’s done.

Furthermore, using Dancing Numbers saves a lot of your time and money which you can otherwise invest in the growth and expansion of your business. It is free from any human errors, works automatically, and has a brilliant user-friendly interface and a lot more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


Is it possible to use the Direct Connect option to sync bank transactions and other such details between Bank of America and QuickBooks?

Yes, absolutely. You can use the Direct Connect Option by enrolling for the Direct Connect service which will allow you access to the small business online banking option at bankofamerica.com. This feature allows you to share bills, payments, information, and much more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


What are the various kinds of accounts you could access in QuickBooks?

QuickBooks allows you to access almost all types of accounts, including but not limited to savings account, checking account, credit card accounts, and money market accounts.

Get Support

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

Close X
Call Now+1-800-596-0806
Top