Question

Expenses by Vendor Report / Alternate Reports

Forum|Forum|5 years ago
April 22, 2021
7 replies
155 views

Hi! We are a newer company using QBO for the past year and a half, and we're trying to tighten up our accounting/finance practices. I've been running the "Expenses by Vendor" report for my boss each month as a way to show her all company expenses for the prior month.

I realized today that that report doesn't include certain items. For example, over the month we ordered a product that we resell, so COGS. It's not pulling the product purchase price, but is pulling the shipping costs into the Expenses by Vendor Summary Report.

I need to be able to run a report to show all expenses for the month, like literally everything that went through our bank accounts or credit cards, by vendor. It has to include every expense including office supplies, payroll, items that are COGS, literally every dollar. Can anybody recommend a report?

Thank you!

Jen

QuickBooks Online

JenoP

QuickBooks Team

I'd be glad to help with your question about running reports in QBO, Jen.

Take note that COGS only increases once a sale is made through an invoice or sales receipt. On the other hand, bills, bill payments, and checks used when the items were purchased are already included in the Expenses by Vendor Summary report.

Here's an article for more details: Impacts of inventory Tracking on Balance Sheet and Profit & Loss Reports.

You'll want to run the Purchases by Vendor Detail report. It will give you a list of all the purchase transactions that are sorted out per vendor. Then, use the Total Payroll Cost report to see all payroll-related expenses. Just go to the Reports menu and type in the name of the report in the Search bar.

Let me share these articles for additional reference and guidance:

Reply to me or reach out to us again if you need anything else. We're always here to help you.

J

jenuneekorAuthor

Hi JenoP,

So just to be sure I understand. When my boss says, basically, "show me every dollar that was spent last month" by vendor, I:

1) Run 'Purchases by Vendor Detail' report

2) Run 'Total Payroll Cost' report

I just ran these two and I'm missing a huge portion of expenses. Could you please advise? I mean, there has to be a report I can run that will show every dollar spent by vendor in a particular time period, right? When I run "Expenses by Vendor Summary" it's not including everything - ???

R

RCV

QuickBooks Team

Thanks for coming back and performing the steps provided by my colleague, jenuneekor.

We can run the Transaction List by Vendor report and modify it to show all the expenses in a particular time period. Let me show you how:

Go to Reports on the left menu.
Enter Transaction List by Vendor on the search field.
Tap Customize.
Select the date in the Report period field.
Click Filter.
Tap Transaction Type and choose Expenditures. You can also include other vendor transactions.
Tick Account and select the specific accounts wherein expenses are associated with.
Press Run report.

To learn more about modifying reports, proceed to Step 2: Customize a report section in the Customize reports in QuickBooks Online (QBO) article. Visit our Reports page for more insights about running reports in QucikBooks. Also, to keep updated with any upcoming QuickBooks updates and enhancements, feel free to visit these blogs:

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Feel free to reply to this post and I'll get back to you. Take care always.

Sign up

Login with SSO

Let's get you signed in

Login with SSO