Discussion:
Need help with Quickbooks inventory question
(too old to reply)
Keith
2003-12-13 04:24:53 UTC
Permalink
*This is a re-post as my original question probably looked like spam.

I have a small business and use QuickBooks to manage the finances and could
use your help with the following situation.

I would like to be able to:
a) buy motorcycles and track my inventory counts
b) track what I have invested into each bike (purchase, parts added etc.)
c) see how much profit I make on each bike when sold.

I currently receive bikes as "Items" and give each one a unique "Customer:
Job" in the Vendor Invoice Entry. When selling them, I use an invoice and
again pick the same Customer name for the sale.

The Inventory Valuation Detail reports works fine, but I can't run a report
that shows my profit / loss per bike or what I have invested in any
particular bike prior to the sale (including its purchase price). The
reports show incorrect COGs information

Can anyone help?
Guru
2003-12-17 16:48:31 UTC
Permalink
If you want to see profit on the item, then you will need to run a
Profit and Loss statement to do so. In orer to see all the costs and
income and the Net Income they need to appear under the same listing.
This can be done 2 ways: by Customer or Item.

If you choose to see by Customer, then if they make other purchases
they would be combined unless you make the date range small enough to
just include the one sale. However this would still be a problem if
they made other purchases the same day.

The better method requires having a Premier version of QuickBooks. You
would create a new item of the type Assembly Item. This allows you to
specify all the parts that go into the final product (specific
motorcycle and all components). Then if you run a Profit and Loss and
set the columns to Item Detail then each Assembly Item appears by
itself and its related income and costs for all of its components.
This solution would probably be too much to try and do for the past
but could be used on future transactions if you have or acquire any of
the Premier versions of QB. A great way to get started on tracking
your profit for the new year
Post by Keith
*This is a re-post as my original question probably looked like spam.
I have a small business and use QuickBooks to manage the finances and could
use your help with the following situation.
a) buy motorcycles and track my inventory counts
b) track what I have invested into each bike (purchase, parts added etc.)
c) see how much profit I make on each bike when sold.
Job" in the Vendor Invoice Entry. When selling them, I use an invoice and
again pick the same Customer name for the sale.
The Inventory Valuation Detail reports works fine, but I can't run a report
that shows my profit / loss per bike or what I have invested in any
particular bike prior to the sale (including its purchase price). The
reports show incorrect COGs information
Can anyone help?
Loading...