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

How to customize an expenses by vendor detail report in new QuickBooks Online?

Run built-in standard Profit and Loss Detail Report and customize it get expenses by vendor.
To Profit and Loss Detail Report:
From the home page screen
Select blue navigation bar on the left
Select “Reports”
Select Go to report (small magnifying gals icon) and type “Profit and Loss Detail”
Select Profit and Loss Detail from the drop-down list
This report will include both income and expense accounts
Select desired transaction date and click run report
Select Customize button (upper left corner)
Go to Distribution Account under Lists heading
Select Multiples (move cursor up to find Select Multiple..)
Select all Expense and COGS accounts from the list (hold Shift key on keyboard and select accounts)
Select Add button (now you have all the accounts under Account Filter List)
Click OK button
Default for this report is sorted by date
If you want this report sorted by Vendor (it will say NAME), Go to Sort By filter and change from “Default” to “Name”
Optional: Go to Header/Footer section and change the Report Title from Profit and Loss Detail to Expenses by Vendor Detail Report
Click “Run Report” button at the bottom

Customize the report more if needed.
Select “Save Customizations” blue button if you need to make this a standard report.

Now, you can even download to Excel spreadsheet and use available Pivot Table to filter more. And, be a star in your company.

Accounts to include in report

customize profit and loss detail

expenses by vendor detail

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 September 12, 2014By admin
Categorized as Reports Tagged distribution account, vendor detail report

Post navigation

Previous post

How do I transfer Opening Balance of Balance Sheet Accounts? What would be the other side of accounting entry?

Next post

My opening balance is incorrect? How do I edit it in new QuickBooks Online?




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 do you put your QuickBooks Online onto a flash drive?

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: