Creating Item Records in QuickBooks

STE Corporation is a CPA firm that provides accounting services in Chicago, Illinois

SCHEDULE A CONSULTATION
Home » Creating Item Records in QuickBooks

Creating Item Records in QuickBooks

Whether you’re selling one-of-a-kind 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 that your customers receive correct descriptions and pricing,
  • Provide the information you must know about your inventory levels, and,
  • Help you make smart decisions about reordering.

You’ll start this process by making sure that your QuickBooks file is set up to track inventory. 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.

To create your first 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 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.

Talk to one of our Accountants Today

OUR SERVICES

stecorporation - accounting icon

Accounting

  • Statuary Accounts
  • Management Accounts
  • Bookkeeping
  • Business Plan
stecorporation - tax icon

Tax

  • Tax Investigation
  • Capitol Gains Tax
  • Tax Advisory
  • Corporation Tax

STECorporation consultation

Consulting

  • Registered Office Address
  • Company Formation
  • Company Secretarial
  • Legal Helpline

QuickBooks/ Bookkeeping Services

All of the financial information and data for your business should be organized and in one place so it is easy to access.  With our bookkeeping services, we will organize and manage your financial information within the QuickBooks software so you can easily access it at any time.  While we manage your financial matters on a daily and monthly basis, you will be in control as we will keep you updated and ensure you can access and monitor your finances.  If you are applying for a loan, doing your taxes, or budgeting, having quick access to your financial information is important.  We can assist large businesses and provide small business bookkeeping.

Advisory Services

Our accountants can take on an advisory role with your company through our business consulting services.  We will work with you to understand your financial goals and help you make the right decisions to reach your goals and help your business grow and become more profitable.  Our business advisory services include advisement for investments, taxes, payroll, bookkeeping, administration, and more.

Estate Planning

It is important to manage your estate to help protect its value and ensure that your assets are distributed properly between your beneficiaries.  Our accountants can assist with your estate planning, including managing the taxes to preserve its value and ensuring that your assets are distributed according to your wishes.  Our estate accountants will identify ways to protect your estate from inflation and taxes and minimize what you are paying in taxes to maximize its value.

Sales Tax / Nexus

Sales tax rates and laws are decided locally and differ between states and cities.  This can make sales and use tax difficult to manage for businesses, especially those that operate in multiple cities and states.  Our certified public accountants can help manage your sales and use taxes by ensuring that you are in compliance with applicable sales tax laws and identifying opportunities for refunds and exemptions.  We have a thorough knowledge of sales tax laws and we can even help businesses that operate in multiple states with filing their taxes.  Using Nexus tax analysis, we can help multi-state businesses stay in compliance with all applicable tax laws.

Payroll Services

We provide payroll services to small businesses and international businesses that operate in the U.S.  Our accountants will streamline your payroll process and manage the tax withholdings and benefit deductions from employee paychecks.  We can also file the tax returns for your business that account for the tax withholdings.

Call the CPAs of STE Corporation

Contact our CPA firm if you want to work with our accountants to help manage the finances for your business in Park Ridge, IL.  You can call STE Corporation at (815) 836-0100 to talk to our professionals or schedule a free consultation.

FREQUENTLY ASKED QUESTIONS

For tax years 2018 through 2025 interest on home equity loans is only deductible when the loan is used to buy, build or substantially improve the taxpayer’s home that secures the loan. Prior to 2018, many homeowners took out home equity loans. Unlike other consumer-related interest expenses (e.g., car loans and credit cards) interest on a home equity loan was deductible on your tax return.
You may be able to take an immediate Section 179 expense deduction of up to $1,040,000 for 2020 ($1,020,000 in 2019), for equipment purchased for use in your business, instead of writing it off over many years. There is a phaseout limit of $2,590,000 in 2020 ($2,550,000 in 2019). Additionally, self-employed individuals can deduct 100 percent of their health insurance premiums. You may also be able to establish a Keogh, SEP or SIMPLE IRA plan and deduct your contributions (investments).
In 2020 (as in 2019), medical and dental expenses are deductible to the extent they exceed 10 percent of your adjusted gross income or AGI. If your employer offers a Flexible Spending Account (FSA), Health Savings Account or cafeteria plan, these plans permit you to redirect a portion of your salary to pay these types of expenses with pre-tax dollars.
If you’re planning to make a charitable gift, it generally makes more sense to give appreciated long-term capital assets to the charity, instead of selling the assets and giving the charity the after-tax proceeds. Donating the assets instead of the cash avoids capital gains tax on the sale, and you can obtain a tax deduction for the full fair-market value of the property.

Frequently-Asked-Questions-min

WHAT OUR CLIENTS SAY ABOUT US

“Everyone at STE has been amazing. As a small business owner it is essential to have people on your team that are experts in all areas. When it comes to finance and taxes Jim and the team at STE fill that need. Thanks for being great at what you do and always be there!”

“STE has been handling our personal, business accounting, and payroll for years. They are knowledgeable, easy to reach, and very welcoming. Would definitely recommend them.”

“I have had nothing but pleasant experiences at STE. They are knowledgeable and provide great service.”

“We have used STE Corporation for our payroll and tax service needs over the past 3+ years and extremely pleased with the partnership we have created.”

“My husband has operated his painting business since 2004, first as a sole proprietorship and later as an S corporation. STE has been instrumental in helping him grow his business and remain in compliance. I cannot thank Mike, Marybeth, Jim, and Lisa enough for helping him get organized and stay that way. They have truly been the business office he needed in order to focus on the part of his business he enjoys – painting and customer service Their professional staff literally have never let him down – payroll, state taxes, federal taxes, consultation, ledger reconciliation, profit and loss sheets, and probably lots of things I do not even know about! Hiring this firm was the best decision he could have made. He looks forward to visiting the office, everyone makes him feel like family. I appreciate their professionalism and efficiency. Thank you STE!”

OUR SERVICES

stecorporation - accounting icon

Accounting

  • Statuary Accounts
  • Management Accounts
  • Bookkeeping
  • Business Plan
stecorporation - tax icon

Tax

  • Tax Investigation
  • Capitol Gains Tax
  • Tax Advisory
  • Corporation Tax

STECorporation consultation

Consulting

  • Registered Office Address
  • Company Formation
  • Company Secretarial
  • Legal Helpline

QuickBooks/ Bookkeeping Services

All of the financial information and data for your business should be organized and in one place so it is easy to access.  With our bookkeeping services, we will organize and manage your financial information within the QuickBooks software so you can easily access it at any time.  While we manage your financial matters on a daily and monthly basis, you will be in control as we will keep you updated and ensure you can access and monitor your finances.  If you are applying for a loan, doing your taxes, or budgeting, having quick access to your financial information is important.  We can assist large businesses and provide small business bookkeeping.

Advisory Services

Our accountants can take on an advisory role with your company through our business consulting services.  We will work with you to understand your financial goals and help you make the right decisions to reach your goals and help your business grow and become more profitable.  Our business advisory services include advisement for investments, taxes, payroll, bookkeeping, administration, and more.

Estate Planning

It is important to manage your estate to help protect its value and ensure that your assets are distributed properly between your beneficiaries.  Our accountants can assist with your estate planning, including managing the taxes to preserve its value and ensuring that your assets are distributed according to your wishes.  Our estate accountants will identify ways to protect your estate from inflation and taxes and minimize what you are paying in taxes to maximize its value.

Sales Tax / Nexus

Sales tax rates and laws are decided locally and differ between states and cities.  This can make sales and use tax difficult to manage for businesses, especially those that operate in multiple cities and states.  Our certified public accountants can help manage your sales and use taxes by ensuring that you are in compliance with applicable sales tax laws and identifying opportunities for refunds and exemptions.  We have a thorough knowledge of sales tax laws and we can even help businesses that operate in multiple states with filing their taxes.  Using Nexus tax analysis, we can help multi-state businesses stay in compliance with all applicable tax laws.

Payroll Services

We provide payroll services to small businesses and international businesses that operate in the U.S.  Our accountants will streamline your payroll process and manage the tax withholdings and benefit deductions from employee paychecks.  We can also file the tax returns for your business that account for the tax withholdings.

Call the CPAs of STE Corporation

Contact our CPA firm if you want to work with our accountants to help manage the finances for your business in Park Ridge, IL.  You can call STE Corporation at (815) 836-0100 to talk to our professionals or schedule a free consultation.