cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Is there a report that shows how much you have actually paid against a PO? That adds up the total of the bills paid and compares it to what the PO total states?

 
1 Comment
Highlighted
QuickBooks Team

Is there a report that shows how much you have actually paid against a PO? That adds up the total of the bills paid and compares it to what the PO total states?

I can show you the reports that will help you in comparing the purchase order with bills, @lhatch.

 

We can use the Transaction List by Vendor report. This will let you view the actual amount paid for each purchase order. However, the option to customize this report to indicate the actual bill payments that are linked to each PO is unavailable.

 

Although, you can use the MEMO/DESCRIPTION as a link for each purchase order. You can simply input the purchase order number to your bill and bill payment to easily identify these transactions. Let me show you how:

 

  1. Go to Reports and search for Transaction List by Vendor report.
  2. Click Customize, then select the Filter drop-down.
  3. In the Transaction Type drop-down, check the boxes for BillBill Payment, and Purchase Order.
  4. In the Vendor drop-down, check the name of the vendors you wanted to view in this report.
  5. Click Run report.
  6. Take note of the Purchase order number. Then, open the bill and bill payment transactions to add the its details in the Memo or Description box.

 

You can also open the Bills and Applied Payments report to see each payment made to each bill for vendors. Here's how:

 

  1. Go to the Reports menu.
  2. Search for Bills and Applied Payments Report.

 

I've also added an article that you can use in saving your customized report in QuickBooks: Memorize reports in QBO.

 

In case you need to check for a specific transaction, you can customize this report to easily locate it. Once done, you can also save its customization settings by memorizing it.

 

If there's anything else I can do for you, please let me know. I'll be around to help you.

Need to get in touch?

Contact us