Skip to main content
A
arkvalleyinfo
October 16, 2018
Question

What report will show a what invoices you paid a vendor with what check.

  • October 16, 2018
  • 6 replies
  • 0 views

I need a report that will show what a check is paying, so i paid a vendor i want to be able to see what invoices were associated with that check.  

6 replies

PreciousB
PreciousB
October 16, 2018

Hello accounting,

QuickBooks has lots of reports you can customize to show you the information you need.

You can run the Transaction List by Vendor report to show the bills and bill payments for each vendor. Let me show you how:

  1. Click Reports on the left pane.
  2. Enter Transaction List by Vendor in the Go to report search field.
  3. Click the Customize button, then set the date range under Report period.
  4. Click the arrow beside Rows/Columns, then click Change columns link.
  5. Select A/P (depending on the information you need to show on the report), then click the arrow beside Filter.
  6. Under Transaction Type, select Check, Bill, Bill Payment (Check) and Bill Payment (Credit Card).
  7. Click Run report.

Always drop by here in the Community if you need a hand.

    Q
    Q68
    October 16, 2018
    This does not appear to do what the OP asked. I cannot find a way to view a completed bill payment with the details of what bills were paid under that payment. When I bring up the details of a completed bill payment, all I get is a dollar amount and a list of outstanding bills, not the list of individual bills paid by the completed payment.
    H
    HeatherD
    November 5, 2018

    This seemed to work for me.  It will give you the amounts of the payment, etc and what it applied it to.  It will even specify the amount paid for each line item on the bill(s) paid:

     

    -From the menu bar, go to Reports > Banking > Check Detail
    - Click on Modify Report button in upper left

    - Specify Date Range desired
    - Click on the Filters tab
    - Click down arrow next to Account box, choose All Accounts
    - Click on Amount, change to All
    - Click on Transaction Type, choose Payment (or specify multiple transactions and select the ones you want)
    - Click on Detail Level, choose All except summary

    - Click OK

      E
      EtherealCat
      June 11, 2019

      These instructions are for Desktop. The question is related to Online. Neither the transaction by Vendor, nor the Check Detail report show the check detail. It would be nice if QuickBooks would fix this issue.

        M
        MirriamM
        June 11, 2019

        Thanks for joining the thread, EtherealCat,

         

        I can share a report in QuickBooks Online which will show the check details of your Vendor.

         

        Here's how:

        1. Go to Reports in the left navigation menu.
        2. Type in Purchases by Vendor Detail in the search bar.
        3. Click Customize button for any necessary filters.
        4. Click Run report.

        From there, you'd able to see the purchases by your vendor with the full details of the transaction.

         

        I've attached some articles for additional reference:

        I'm always at your back if you need further assistance in running reports. Have a great day!

        Y
        Yankeegyrl
        November 4, 2019

        I found a report that does that and printed it.  It's called a Vendor - Payment Check Detail report.   My only problem is that I can't find to run it again.  Anyone know where I might have found this report?  I am using a desktop version of Quickbooks.

         

        Thanks!

        AlexV
        AlexV
        November 4, 2019

        I can help you to locate and run that report again, Yankeegyrl.

         

        I'm unable to see a Vendor - Payment Check Detail report. We can pull up Check Detail and create your own customized report.

        1. From Reports menu, go to Banking and select Check Detail.
        2. Click on Customize Report button.
        3. Go to Filters tab. Search and select Transaction Type.
        4. Select all applicable transaction types. Click OK.

        Also, it could be that this is a memorized report. If so, we can go directly on your Memorized Report List. You can follow these steps:

        1. Go to the Reports menu.
        2. Hover your cursor to the Memorized Reports and select Memorized Report List.
        3. On the pop-up, check if it's on the list.
        4. Double-click to open it.

        Here are some of the articles you can read for reference:

        Comment again if you have more questions.

        F
        FourForTwo
        August 31, 2020

        This report is missing one critical feature, it doesn't itemize any vendor credit memos used within the check payment.

         

        For example, Acme, Inc has three open payables invoices ($100/each) along with two available credit memos ($50/each).  You owe Acme a net of $200.  Each invoice and each credit memo has a reference number.  When you "pay bills" you elect to pay all three invoices but only utilize one of the available credit memos - sending a check for $250.  The bill payment stub reflects the correct reference numbers (invoice and credit) but the check detail report fails to fully document the use of the credit - it simply changes the "paid amount" on the report, which doesn't quite meet my definition of "detail".  

         

        Anyone in the retail/resell business likely has merchandise returns (overstock, damages, etc) so a report that includes ALL of the detail would be appreciated.

        E
        EmRK
        August 7, 2020

        I had the same question and found the perfect report in QBO: Bills and Applied Payments

          P
          pdsarizona
          May 28, 2021

          I use QB desktop and I am trying to find a way to show what bills and bill credits were used when I pay a bill.   I have tried check detail report and transaction by vendor and I can't get the bill credits to show up even though in the filter I have it selected for the type.  

          MaryLandT
          MaryLandT
          May 28, 2021

          Let me provide the steps on how to view credits applied to bills, pdsarizona.

           

          You can run the bill transaction history to get the data that you need. Let me show you how:

           

          Here are the steps:

           

          1. Click the Vendors tab at the top menu bar.
          2. Click Vendor Center.
          3. Go to the Vendors tab.
          4. Select a vendor.
          5. Go to the vendor's Transactions tab.
          6. Double-click to open the bill.
          7. Press and hold the Ctrl + H key.


          You can also pull up the Transaction List by Vendor report to see the vendor's payment, bill, and the credit's applied. Simply customize the transaction type.

           

          Here's how:

          1. Click Reports.
          2. Click Vendors & Payables, and then Transaction List by Vendor.
          3. You can also click on the Customize Report button at the top to filter the report.
          4. Go to Filters, then manage Transaction Type.
          5. Select Multiple Transaction Types.
          6. Mark Bill, Bill Credit, and Bill Payment, then click OK.


          Additionally, you can find these transactions in the vendor's profile. The credit is posted in the Balance Total column.

           

          I've also added these articles for future reference: 

           

          You can always get back to me if you need more help vendor credits in QuickBooks Desktop. I'm always glad to help you.

          P
          pdsarizona
          June 1, 2021

          The second option for the report is what I need and have done,  and the Bill Credits DO NOT come up.   What I get is the Paid Amount column and the Original Amount column are different because of the application of the Bill Credit but it never shows the bill credit which would have a memo/explaination.  Would it make a difference whether you were cash or accrual?  

          A
          adfasedfasdfasd
          June 9, 2023

          There is a lot of information in this post, but nothing that solves the problem. I'm using QBO and I have too many invoices being paid to have all of them show up on the bottom of the check. I need a report that will list all of the bills and vendor credits that are being paid with a bill payment. I can't figure out how to get this done! I have ran so many reports that will give me the check number and the bill payment amount, but nothing with the actual breakdown. I cannot run a transaction detail for every single check written, so that is not an option. 

          Adrian_A
          Adrian_A
          June 9, 2023

          I appreciate you for running some reports to achieve your desired report, adfasedfasdfasd. I'm here to help you out.

           

          We can open the Bills and Applied Payment report to display the bills together with the check number and their payment. I'll guide you with these steps:

           

          1. Click the Reports tab.
          2. Enter and select Bills and Applied Payments.
          3. Click the Customize button.
          4. Filter the Report period.
          5. Click the Rows/Column drop-down.
          6. Tick the Transaction Type, Num, and Amount fields.
          7. Click Run report.

           

          Feel free to pin these articles as your guide in customizing reports:

           

           

          You can always mention my name whenever you have concerns about customizing reports.

          S
          Shawn51
          July 12, 2023

          The QB Online report is sound, but does not give the correct amount paid for the bills. Under the amount column it only provides the total amount of the bill not the amount being paid. Is there a way to get the amount paid displayed on the report?

          Terms & ConditionsAccessibility statement