Learning Center
How to Create Product Records in QuickBooks Online
If you sell one-of-a-kind products and can see all of them at a glance, tracking your inventory isn’t such a big issue. But not many people run businesses like that. Even if you do, you’d want to keep track of what you have and what you’ve sold for accounting purposes.
Most businesses sell multiple types of products and stock numerous units of them. These companies need to be able to easily add them to invoices and sales receipts. They need to know what’s selling and what’s not, and they need to know when it’s time to reorder.
QuickBooks Online’s recording and tracking tools meet all of these requirements by allowing you to create records for services. Here’s how it works.
Getting Ready
Before you can start working with QuickBooks Online’s product records, you should make sure that the site is set up for this purpose. Click the gear icon in the upper right, then Your Company | Account and settings. Click the Sales tab to get to the Products and services section, as pictured below.
QuickBooks Online’s Account and Settings has a section devoted to Products and services.
Click on Products and services to open your options here. To turn any entry from On to Off, or vice versa, click in the box at the beginning of the line to check or uncheck it. To see an explanation of each, click on the small circled question mark. When you’re done here, click Save. Then click the X in the upper right to close this window.
Creating Records
To start entering product and service data in records, click the gear icon in the upper right, then select Products and services. Since you haven’t entered anything yet, the table will be blank. Eventually, it will contain data for each record you’ve created. You’ll also notice two colored circles at the top of the screen, one marked Low Stock and the other, Out of Stock. When there is a number next to either of them, you’ll be able to click on either circle to see a list of what’s low or what’s out.
Click New in the upper right. A vertical panel will slide out asking what kind of record you want to create. You can choose from:
- Inventory - Physical items you sell whose quantity you want to track
- Non-inventory - Products you buy or sell but whose quantities you don’t need to track
- Service - Services you sell, like legal representation or landscaping
- Bundle - A group of products and/or services that are sold together, like computer training and accompanying software
QuickBooks Online helps prevent product shortages.
In the next section, you’ll enter the Initial quantity on hand. How many do you have as of (current) date? And where do you want to set your Reorder point? What number of items remaining should trigger the Low Stock alert so you can replenish your supply?
Inventory asset account should already be set at Inventory Asset. Enter a brief Description and then the product’s Sales price/rate (the price you’ll charge customers) and leave Income account set at Sales of Product Income. Then select a Sales tax category. If you haven’t set up sales taxes in QuickBooks Online and believe you’re required to pay them on at least some sales, please let us help.
In the Purchasing information field, enter the description that should appear on purchase forms, then Cost (the price you paid to buy the product, if any). The Expense account should be Cost of Goods Sold. Select a Preferred Vendor if you’d like and Save the record.
Not all fields are required in your product and service records, but we strongly recommend you complete each record as thoroughly as is possible.
NEVER MISS A STORY.
Sign up for our newsletters and get our articles delivered right to your inbox.
Rose Tax & Financial
Cedar Crest, New Mexico 87008
Sat: 10:00am to 2:00pm
Check the background of your financial professional on FINRA's BrokerCheck
Avantax affiliated Financial Professionals may only conduct business with residents of the states for which they are properly registered. Please note that not all of the investments and services mentioned are available in every state. Securities offered through Avantax Investment Services℠, Member FINRA, SIPC, Investment Advisory services offered through Avantax Advisory ServicesSM, Insurance services offered through an Avantax affiliated insurance agency. 3200 Olympus Blvd., Suite 100, Dallas, TX 75019. 972-870-6000.
The Avantax family of companies exclusively provide financial products and services through its financial representatives. Although Avantax Wealth Management® does not provide or supervise tax or accounting services, Avantax representatives may offer these services through their independent outside business. Content, links, and some material within this website may have been created by a third party for use by an Avantax affiliated representative. This content is for educational and informational purposes only and does not represent the views and opinions of Avantax Wealth Management® or its subsidiaries. Avantax Wealth Management® is not responsible for and does not control, adopt, or endorse any content contained on any third party website.
This information is not intended as tax or legal advice. Please consult legal or tax professionals for specific information regarding your individual situation.
The information being provided is strictly as a courtesy. When you link to any of the web sites provided here, you are leaving this web site. We make no representation as to the completeness or accuracy of information provided at these web sites. Nor is the company liable for any direct or indirect technical or system issues or any consequences.
For Important Information and Form CRS please visit https://www.avantax.com/disclosures.