Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
September 28, 2025
Question

General inventory not showing on P&L by Customer

  • September 28, 2025
  • 1 reply
  • 2 views

This is for a private events venue (weddings and the like). When we purchase general inventory (like wine), we don't know who the customer for that inventory is ultimately going to be. But I want the cost of the inventory to be associated with whichever customer does ultimately purchase it so that it appears on the P&L By Customer report. How can I do this? 

 

If I mark the original inventory purchase as billable, it requires me to select a specific customer to be billed (which, as I said, I don't know yet).  

 

If I don't mark the inventory item as billable when it is purchased, I can add it to a customer invoice and it adjusts the inventory valuation correctly. BUT it doesn't associate the cost of that inventory with the customer when I run the P&L. 

 

Going back to adjust the original bill for the purchased inventory after an event (and before I create the final customer invoice) and adjusting it to reflect what portion of the inventory was purchased for a specific customer is an extremeley tedious step that I need to avoid.

1 reply

September 28, 2025

Ugh! Never mind. I need to run the P&L report on an accrual basis (even though the rest of the accounting is done on a cash basis) to get the inventory expenses to show up for the customer. All resolved.