Question

Report to show P&L Detail from Product/Service entered as Billable Expense

Forum|Forum|5 years ago
August 10, 2020
1 reply
7 views

I cannot figure out how to run a report showing the P&L for a specific Product/Service that is entered as a billable expense. I want to run a report on the Product/Service that will show me both the Vendor Bill(s) related to this product and the Client Invoice related to this product. I want to see all transactions related to this Product.

The Sales by Product/Service Detail Report only shows me the Client side of the transaction. Purchases by Product/Service Detail Report only shows me the Vendor side of the transaction. How do I see both in one report, or do I have to export both reports and manually make them one?

The Profit and Loss Detail Report does not allow me to filter by Product. I was able to make this report work for now by filtering it by Vendor, as the Vendor is only providing this one Product and this one Product is only provided by one Vendor. But, in the future, if this Vendor provides more than just this product or we use multiple vendors providing this product, this report will not work if we cannot filter it by Product.

The Profit and Loss Client Report does allow the report to be filtered by Product, but there is no option to show detail, so we cannot see the Vendor(s) names, invoice dates, invoice numbers, vendor bill dates, vendor bill numbers, etc.. This report will work for a snapshot per Client, but not really what we are looking for.

I thought Fathom reports was going to help with these types of special reports, but from what I see, Fathom is only for broad KPIs. Maybe I missed something??

Thank you for any assistance you can provide - Justine

QuickBooks Online

MaryLurleenM

Level 6

Hello there, Justine,

Your first suggestion is brilliant. Yes, you can export each report and combine them manually. This way you can see both sales and purchases transaction for the specific item.

Here's how to export the report:

From the left menu, select Reports.
Locate the report you want to export.
Click the Export icon, then select Export to Excel.

Combine both Sales by Product/Service Detail Report and Sales by Product/Service Detail Report manually.

As for Fathom, you might want to get in touch with their support. They might be able to provide an option to run this report.

Check out these articles for customizing reports:

Let me know if you have other questions. I'd be more than happy to help.

L

Laraine2

If some or all expenses are coded to both a class (for one purpose) and a Product & Service (for a secondary purpose), then running the reports separately and combining them risks duplication of expenses, and the de-duping process is tedious and contains a high-risk of error. Is there another solution to this issue?

Z

ZackE_

Moderator

Thanks for becoming a part of the Community, Laraine2.

I can certainly see how an ability to combine reports could be a useful feature and have submitted a suggestion about it to our developers.

Currently, the workaround recommended by MaryLurleenM is going to be the best method for combining each report. You can also check out the applications available in our QuickBooks App Store. There might be some that can help you accomplish what you're looking to do.

If you'd like to submit your own feature requests, you can do so while signed in.

Here's how:

Use your Gear (⚙️) icon.
Click Feedback.
Enter your suggestions and/or comments.
Hit Next.
Choose Skip and send message.
The available drop-down menu can be used to pick an appropriate category.
Select Send message.

Your feedback's definitely valuable to Intuit. It will be reviewed by our Product Development Team and considered in future updates. Feature requests can be tracked through the Customer Feedback website.

If there's anything else I can assist with, please feel more than welcome to reach out anytime. Have a lovely day!

Sign up

Login with SSO

Let's get you signed in

Login with SSO