Skip to main content
J
Janfromearth1
December 11, 2018
Solved

Job profitability detail report not showing cost detail

  • December 11, 2018
  • 4 replies
  • 0 views

I am creating a demo of using a customer/Job to report on an annual fashion show but having some trouble with the detail job costing report.

I have created 4 invoices and the income show up but I created 6 bills going to a gl called Special Events, they only show in total at the bottom as "No Items". If I drill down, I get the line item detail but what am I not doing to get this to show on the detail job cost report itself?

Thanks

Best answer by Rustler

Create a non inventory type item for each expense, link it to the special event exp account

edit the bill, delete the g/l account, change to item details, and use the non inventory items.

QB reporting is item-centric.  ROFL, thought I would try a new phrase, QB reports best when using items

in company settings>expenses>bills & expenses turn on the items table and purchase orders. then the item details part is half way down the expense screen, click it and a table opens for items


4 replies

Rustler
RustlerAnswer
December 11, 2018

Create a non inventory type item for each expense, link it to the special event exp account

edit the bill, delete the g/l account, change to item details, and use the non inventory items.

QB reporting is item-centric.  ROFL, thought I would try a new phrase, QB reports best when using items

in company settings>expenses>bills & expenses turn on the items table and purchase orders. then the item details part is half way down the expense screen, click it and a table opens for items


J
Janfromearth1Author
December 11, 2018
Perfect.  Is there any job profitability or P&L by job that shows the memo field?
qbteachmt
qbteachmt
December 11, 2018

The one item that you both buy and sell would be the same item used for purchases and for sales. You don't need an Expense item separate from an Income item, if that same item is what you want to track and see for reporting. Also, you can set up Multiple items that all link to that one account, so that you have items for Event Names, but only the one expense account and income account. That avoids micro-managing the chart of accounts, just for different events, charges, etc.

For "memo", you need to run Detail reports, not Summary reports and it matters if the memo is in the Transaction or the detail rows inside the transaction's body.

I will attach examples for you. This is a construction file, but the concepts are exactly the same: services, inventory, noninventory, other charges, and even a listing at the bottom of No Item, which we fix in my Job Tracking class.

J
Janfromearth1Author
December 11, 2018
I see how to set them up. This is for a non-profit and I am doing a demo on using customer/job for their annual fund raiser. They wrap gifts at the mall for donations. They had asked to be able to see individual items they had purchased like sparkles (their example).  I wanted to create an item called "gift wrap" and then use the memo field to put in as much or little information on the fly. Then, have it show up on the detail job profitability report. No such luck. They either create more items (not a bad thing) or drill down to the level of detail then need. Thanks again.
qbteachmt
qbteachmt
December 11, 2018

"not showing up on any of the detail profitability reports."

Although the title includes "detail," that specific report still is Summarized by Item.

The Memo vs Description Detail that you are seeking is only going to be seen in a Transaction Detail report = each row is the one line item. Job Profitability Summary and Detail both are not "here is every specific thing that happened" = transaction detail report, as individual rows data.

"They will just have to create ITEMS for all the items they wish to purchase and track. "

They should, anyway. You want to avoid manually typing freeform text every time, if these things are "just like the other one" and an Item (or Subitem) does that work for you. Examples:

Fundraising.
Or;
Winter Fundraiser.
Or:
Wreath Sales vs Tree Sales

I have included report images that show how your expectation of "Job Profitability Detail" still is a Summarized by Item Name reporting; no memo is seen here, because there is no Row Detail from transactions being reported here. To see that, you would double-click on any value and zoom in. I showed what the Transaction Detail reports would then look like, for you.
qbteachmt
qbteachmt
December 11, 2018

"This is for a non-profit and I am doing a demo on using customer/job for their annual fund raiser."

That is fine, but that is Name. You use items to control the flow of data to the accounts.

"They wrap gifts at the mall for donations. They had asked to be able to see individual items they had purchased like sparkles (their example).  I wanted to create an item called "gift wrap" and then use the memo field to put in as much or little information on the fly."

Fine. You summarize the "day's take" as Sales Receipt and list the Gift Wrap item, and Sparkles Sold and the Big Bows, with qty, and you might also be listing a regular Donation item here; the customer name top left is this Event Name from the Customer Center.

And they can use the item when they restock on Bows, Sparkles and Glitter, and Job Track those purchases to show they specifically apply as a cost of the Event as Customer Name. Make them Not Billable, of course.

"Then, have it show up on the detail job profitability report. No such luck."

Yes it will. I have shown this and described it.

"They either create more items (not a bad thing) or drill down to the level of detail then need. Thanks again."

Sales by Item Detail, Item Profit, Job Profitability Detail will all show this.


J
Janfromearth1Author
December 11, 2018
Just to be clear. I was talking about the Memo field not showing up on any of the detail profitability reports. They will just have to create ITEMS for all the items they wish to purchase and track. Not a huge lift.  Thank you
Terms & ConditionsAccessibility statement