Skip to content

NEWQBO.COM

  • Home
  • Our Services
  • Video Tutorials
  • Ask Question
  • Test Drive
  • Advertise With Us
  • Help Questions
  • Donate Few Bucks for QuickBooks Help

I need a report that shows product sales along with product cost so that I can see profit or loss for each product.

See attached screenshot sample report. You can generate this report directly from QuickBooks Online Plus with some customizations.

If this is the type of report, you are looking for, you will need to take the following steps:

From the home page screen > go to blue navigation bar on the left > select reports > go to report search (small magnifying glass) and type “Profit and Loss” (yes, regular profit and loss report)

Run Profit and Loss Report > change transaction date as needed

Choose “Customize” button

Accounting Method = Accrual

Columns under Rows/Columns heading > select Product and Services from the drop down list (default = Total Only)

Under “Add Subcolumns for Comparison” > choose checkbox “% of Row” (optional)

Run Report (blue button)

This will be the first run of Product P&L. You will get raw Profit and Loss by Products in standard P&L format. You will need to do further customizations depending upon your requirements.

Additional Customization Tips: example want report at gross profit level only

Go to “Lists” heading > choose “Distribution Account” > From the drop-down list choose “select multiples” > Add “all income accounts” and “all costs of goods sold accounts” from the list (or choose your preference accounts) > click OK

Optional:

Go to “Lists” heading > choose “Product/Service” > From the drop-down list choose “select multiples” > choose specific products from the list as needed > click OK

Run Report

Sample report is based on the above customizations.

If you are a Cost Accountant or with costing accounting knowledge, you can even take it another level and run the fully blown Product P&L with applied overhead (O/H) burden.

Product P&L

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...

Related

Published October 10, 2014By admin
Categorized as Reports Tagged distribution account, profit loss by class

Post navigation

Previous post

Is there a way to show Customer address information on the Receive Payment Form? We have several customers with names that are close, and I like to verify by address.

Next post

QuickBooks Online Version vs QuickBooks Desktop Version differences (QBO vs QBDT)




Our Top Posts

  • Chart of Accounts - Listing of available Account Types and their associated Detail Types
  • QBO Educational and Instructional blog
  • How to record forgiveness of debt loan by vendor and bank in Quickbooks Online
  • Add Match Transfer in QuickBooks Online Banking
  • How to record Prepaid Unearned Income? How to convert this Prepaid Unearned Income to Revenue Income when it becomes Earned Income?
  • How do I view or print previous bank reconciliation reports in QuickBooks Online QBO
  • QuickBooks Online Projects for Used Car Auto Dealership - Used Car Inventory
  • Test Drive
  • How to make batch inventory stock quantity adjustment after physical count
  • How to record sales tax refund check from Tax Agency in QuickBooks Online

Our Recent Posts

  • We have 3rd party app Revel sync with QBO. We have experienced an anomaly with the deposits duplicating — one in the revenue income account and the other in the Undeposited Funds account. How to resolve this?
  • How to Record Consignment Sales on Consignee’s Books in QuickBooks Online
  • Cash Flow Dashboard Widget in QuickBooks Online
  • I have already set up a class in QBO. How do I assign Payroll to that Class?
  • How do I record fully-owned fixed asset equipment that has been sold for cash?
  • QuickBooks Online: Employees and Payroll Helpful Articles
  • How to cancel the QuickBooks Online QBO subscription
  • How to record forgiveness of debt loan by vendor and bank in Quickbooks Online
  • Intuit Aid Assist Website – Paycheck Protection Program (PPP) and Economic Injury Disaster Loan (EIDL)
  • Tags in QuickBooks Online QBO – Tracking County Sales, Out of State Sales, Sales to Pay Rep Commissions
  • How can I make batch changes to categorized transactions without having to go through and click every single one of them in my register
  • How do I match a batch deposit for payment of an invoice and vendor refund deposit?

Search our website

Popular Questions

  • How do I view sent emails for Invoices in Quickbooks Online asked by Carl
  • How do you record a loan payment for a fixed asset? asked by Anonymous
  • How to run customer sales report by City / State in QBO asked by Anonymous
  • How do I add a new "Detail Type" category to the chart of accounts? asked by Rebecca
  • In QBO, how to you delete a recurring Journal Entry? asked by Anonymous
  • how to change sale receipt number asked by Anonymous
  • How do you delete a Project in QuickBooks Online asked by Fred L.
  • Credit Card with mutiple Sub-Accounts asked by Cynthia Russomanno
  • Missing bank transactions in QuickBooks. asked by Maggie
  • Missing beginning balance data on Statement for Cash Flow by Month or Quarter report asked by Anonymous
  • Home
  • Our Services
  • Video Tutorials
  • Ask Question
  • Test Drive
  • Advertise With Us
  • Help Questions
  • Donate Few Bucks for QuickBooks Help
NEWQBO.COM
Proudly powered by WordPress.
%d bloggers like this: