Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
December 6, 2018
Solved

Inventory Tracking without cost or sales

  • December 6, 2018
  • 11 replies
  • 58 views

Is there a way to track inventory without having it affect the accounting side of things? I just want to keep track of my on-hand inventory but not have it go through payables/receivables

 

Best answer by Charies_M

Welcome to the Intuit Community, dal1cas2.

 

At the moment, there isn't a way we can track inventory without affecting cost and sales. Inventory tracking is designed to track quantity, sales revenue, and cost of goods sold. 

 

If you wish to have this feature included in the next update, I encourage you sending this great suggestion to our product developers the the feedback feature in QBO. I'll do the same thing on my end.

Here's how:

  1. Click on the Gear icon.
  2. Click Feedback.
  3. Type in your feedback or feature request.
  4. Click Send Message.

We're always working on providing our customer the best product and service they deserve. We'll keep your suggestion in mind for future development plans.

 

If there's anything else I can do for you, or questions about inventory tracking in QBO, feel free to let me know. I'd be glad to help.

11 replies

Regina_Lend_A_Hand_Accounting
Level 2
December 6, 2018

When you purchase inventory it becomes an Asset of the business. When you make a sale from your purchased inventory it becomes a cost of goods sold expense for your business. Your inventory is tracked with "accounting", thus your inventory needs to be part of your accounting.

Charies_MAnswer
Level 9
December 6, 2018

Welcome to the Intuit Community, dal1cas2.

 

At the moment, there isn't a way we can track inventory without affecting cost and sales. Inventory tracking is designed to track quantity, sales revenue, and cost of goods sold. 

 

If you wish to have this feature included in the next update, I encourage you sending this great suggestion to our product developers the the feedback feature in QBO. I'll do the same thing on my end.

Here's how:

  1. Click on the Gear icon.
  2. Click Feedback.
  3. Type in your feedback or feature request.
  4. Click Send Message.

We're always working on providing our customer the best product and service they deserve. We'll keep your suggestion in mind for future development plans.

 

If there's anything else I can do for you, or questions about inventory tracking in QBO, feel free to let me know. I'd be glad to help.

qbteachmt
Level 11
December 6, 2018

Of course you can track inventory without running it through AP or AR, and it doesn't have to affect costs or sales.

 

Let's take these separately: AP is only Enter Bill for something I did not yet pay for. You can list Inventory on the purchase as Check Expense or Credit Card Charge. This is how you show you bought something, with Quantity and Cost.

 

AR is part of Unpaid Sales. Inventory is not by definition Sales; it is by definition Stuff on hand. So, for instance, a machine shop or fabrication shop might need to track tool bits, saw blades and materials as Inventory for inhouse management, which is never what is sold. Perhaps you sell Trailers, and build them Custom.

 

So, you list Bar stock, square tubing, cut off blades, etc as inventory on Purchases. When you then Build that trailer to sell, you "Adjust inventory" to remove the Tubing and Bar Stock from on hand. You also Adjust inventory for removing new saw blades as they get placed in the machines.

 

And you would sell that trailer, as your revenue item. You would never sell inventory, in this type of operation.

 

I have a client that builds and tests rocket engines. They manage a lot of inventory, all for In House purposes. They sell Engineering Services.

 

dal1cas2Author
December 6, 2018

How would I go about entering it so that it is just inventory and not sales? I tried to mark it as "Tracking" only but it would not allow it without giving it another identity as well.

December 7, 2018

Greetings, dal1cas2,

 

Thanks for looping in with the conversation.

 

To correctly track your inventory in QBO without affecting sales, you may refer to what Qbteachmt and Reginamarie have discussed above. The items you add will not be treated as sales unless you add them to your sales transactions.

 

In your case, you can create a custom income account for the products you're adding that should not be part of your company's revenue. To get help setting up the sales account for your non-sale inventory items, I'd recommend consulting an accounting professional. They can provide you with the best legal and accounting advice for your inventory management in QuickBooks Online.

 

Please feel free to reach out to me if you have any more questions with QuickBooks. I'm always here to help you whenever you needed me.