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.

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.

Adding 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.

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

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-347-428-6831 or chat with experts.


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.

Book your consultation Book Free Consultation
Call Now+1-347-428-6831
Dancing Number

We value your privacy and are strongly against any kind of phishing, spam, and malware. We collect your information for our legitimate business purpose only. This information is safe with our in-built security.

X



    Top