Skip to main content
May 3, 2024
Question

Validating Vendor Invoices with a Custom Price List

  • May 3, 2024
  • 1 reply
  • 0 views

I have a negotiated price list from a vendor, is there an easy way to ensure the invoice I get from the vendor is right (each line item as the negotiated pricing versus their standard price) when I enter it into QuickBooks?

1 reply

May 3, 2024

Let's ensure you can validate your billed items with the negotiated price list you've had with your vendor, Kevin.

 

In QuickBooks Online (QBO), we have two reports that we can utilize to check the products and services you've had under your vendor and their price lists. First, the Product/Service List report shows a complete list of the products and services in your QBO company. Then, the Purchases by Vendor Detail report shows all your purchases from your vendor. 

 

You can compare the data from both reports and see if all the listed products and services price lists are identical to what you've paid on your purchases.

 

To start, let's pull up the Product/Service List report.

 

  1. Log in to your QBO account and go to the Reports menu.
  2. From the Reports page, enter the Product/Service List on the Find report by name search bar.
  3. Double-check the products and services and their price list.
  4. You may also explore the FilterGeneral options, and Columns selections to handle what data shows up on your report.

 

Next, let's run the Purchases by Vendor Detail report.

 

  1. Kindly go back to the Reports page and enter the Purchases by Vendor Detail on the Find report by name search bar.
  2. Click the Filter option and select Vendor name on the Filter dropdown to sort the data by vendor.
  3. Review the products and services you've purchased on your vendor and their price list.
  4. Compare the data from the Product/Service List report to the Purchases by Vendor Detail report to validate if the price list is the same for both reports.

 

Additionally, you may also check this article: Common custom reports in QuickBooks Online. It provides information on how to run and organize financial reports so you can review your business stability and check for your needed data.

 

We've got your back if you have additional queries about your products/service lists and purchases in QBO. Just comment below, and we'll readily help you out.