Skip to main content
B
BroT
July 21, 2022
Question

Vendor posting detail

  • July 21, 2022
  • 1 reply
  • 0 views

I need to pull a report for a time period that shows all vendor expenses with posting detail. My client does not use Purchase Orders, so all expenses are entered either as Bills or Expenses. I can't find a report that will show the line item detail of each bill. If there is more than one distribution account in the bill it simply shows as 'Split.'

 

Ultimately, I need a report for every line item on an expense/bill with the following columns:

 

Date, Vendor, Transaction Type, Number, Memo/Description, Account, Amount

 

Thank you

1 reply

AlcaeusF
AlcaeusF
July 21, 2022

Hello, @BroT.

 

I'm here to help pull up the report you need in QuickBooks Online (QBO).

 

Based on the information you've shared, you can run the Purchases by Vendor Detail report. This will show all the line items entered on the bill, check, or any expense transactions created in QBO. Then, customize it to add all the columns you've mentioned above.

 

Here's how to do it:

 

  1. In QBO, go to the Reports menu at the left pane.
  2. In the search field, type Purchases by Vendor Detail, then select it on the drop-down to open.
  3. Choose your preferred date in the Report period section.
  4. Tick the Settings or Gear icon next to Export.
  5. Place a checkmark on Date, Vendor, Transaction Type, Number, Memo/Description, Account, Amount.
  6. Click anywhere to refresh the report.

 

If you wish to memorize or customize this report, you can refer to this article for further guidance on how to do it:

 

 

For more tips and other resources, I recommend visiting our website for future reference: Self-help articles.

 

Let me know if you have follow-up questions above vendor reports or anything else QuickBooks. I'll be more than willing to assist. Keep safe.

B
BroTAuthor
July 21, 2022

Thank you for your reply. 

 

I have tried this already but the report pulls no data. I was wondering if this report is only intended if using purchase orders?

Terms & ConditionsAccessibility statement