Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowGood afternoon, We purchase puppies and raise/train them as service dogs. Each puppy is entered in as a unique piece of inventory that is for sales. I would like to allocate the pups food expense and other vet bills to that specific pup so when we sell it I can see the profit margin for that specific pup. How can I add expense to an item already set up in inventory.
For example
Luke is an inventory item, he is entered in at the purchase price we paid for him.
HIs food and vet bills I was previously posting to COGS but I would like his portion of the food to be added to his cost monthly. How can I do this?
I've got just the steps you need with your inventory, @Loyalcompanions.
I have here two options to add the additional cost in your QuickBooks Online. This way, we can ensure that your inventory data is up-to-date and accurate.
The first one is we can create a clearing account to record all the costs. I'll guide you on how.
Once done, post the extra cost to the account (food expenses and other vet bills).
The other option is by creating an expense transaction in QuickBooks Online. Then, enter two lines. One is the purchase cost of the item which is positive and the other line is the same quantity as the positive but with the additional cost.
I'd also recommend consulting your accountant to ensure your inventory reports are accurate. In case you don't have any, please visit our Find an accountant website to locate one.
Additionally, access inventory reports to instantly see your best sellers, what’s on hand, cost of goods, and more. For the complete instructions, check out this page: Use reports to see your sales and inventory status.
Lastly, feel easy to visit these links below about restocking inventory and to know more about First In, First Out (FIFO).
Drop a comment below if you have additional questions about tracking your inventory. Always here to lend a helping hand. Keep safe.
Thank you so much for the quick reply. I do like the clearing account as I will be feeding these guys for 12 months :). but now, once I post it to an expense clearing account - how to I get those fee's allocated to the inventory (each service pup)?
It's my pleasure and thanks for the quick response too, @Loyalcompanions.
Good to hear that you have a clearing account in QuickBooks Online. I have here the easy steps on how to allocate your inventory fees.
First, you can either create an Invoice or Sales receipts in your account. Then add a negative amount in the second line for your fees. Let me show you how.
Once done, you can receive the payments and deposit the funds if you're using an Invoice. Please follow the steps below.
After that, you can always visit your clearing register to track all the funds you've deposited to. See the sample screenshot below for your reference.
Additionally, I'd still recommend consulting your accountant to ensure your inventory reports are accurate.
Furthermore, feel easy to visit any customer and inventory reports to track all the transactions you've entered into the system. Then customize it to show specific details. For the complete instructions, check out this page: Run reports in QuickBooks Online.
Lastly, visit these articles below about how to calculate COGS and adjust inventory value.
Leave a comment below if you have further questions about your inventory. I'll be here to keep helping. Take care.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here