cancel
Showing results for 
Search instead for 
Did you mean: 
mikeshick
Level 3

How can I confirm where a bill was paid

If I have a vendor stating he wasn't paid, and my bill shows paid, how can I confirm that it was and by what check?

 

If there was an error, and the bill erroneously states paid, how do I fix this?

Solved
Best answer February 19, 2021

Best Answers
BigRedConsulting
Community Champion

How can I confirm where a bill was paid

To see what check paid a bill, open the bill and then press Ctrl-H.  Then click Go To to open the check.

View solution in original post

11 Comments 11
ChristieAnn
QuickBooks Team

How can I confirm where a bill was paid

Hi there, mikeshick.

 

To confirm if the vendor's bill was paid and by what check, you can go to the Vendor information under Vendor Center. From there, you'll have the option to see all vendor's transactions.

 

Here's how:

 

  1. Click the Vendors menu at the top. 
  2. Choose Vendor Center.
  3. Select the Vendors tab. Then, go to the Transactions section.
  4. Locate the bill and the payment. Then, you'll see the date and the type of transaction associated with the specific vendor.

 

Then, if the bill shows up paid from the payment entered, I suggest going to the Bank statement. From there, you can verify if there's a payment associated with the specific bill. This way, you can confirm if the bill certainly paid from a vendor or wasn't. Please follow the steps below.

 

  1. Click the Banking menu at the top.
  2. Choose Use Register.
  3. Select the particular account from the drop-down list.
  4. Click the OK button.
  5. Find the Payment and the bill associated with that entry.

 

However, if the bill is not supposed to be paid, you can delete the payment that connected to a particular bill. With this, the entry will now show as open and have the option to link this to payment. Follow these steps on how you can delete the payment.

 

  1. Go to the Vendors menu and choose Vendor Center.
  2. Select the Vendors tab. Locate the vendor's name and go to the Transactions section.
  3. Find the bill payment and click it to expand the page.
  4. Click the Delete icon and choose Delete.
  5. Hit OK.

 

Then, if there's an error and the bill erroneously states paid after deleting the payment, I suggest running the Verify and Rebuild data utility tool. Verify Data self-identifies the most commonly known data issues within a company file while Rebuild Data self-resolves most data integrity issues that the Verify Data finds. To see the additional information and how to perform the process, you can click this article: Verify and Rebuild Data in QuickBooks Desktop.

 

Please refer to this article to see details on how QuickBooks Desktop offers a wide variety of ready-made vendor reports that tell you where your company stands, in terms of expenses and accounts payable: Customize vendor reports.

 

Please let me know how it goes. I'll be here should you need further assistance. Wishing you all the best!

BigRedConsulting
Community Champion

How can I confirm where a bill was paid

To see what check paid a bill, open the bill and then press Ctrl-H.  Then click Go To to open the check.

mikeshick
Level 3

How can I confirm where a bill was paid

Thank you, Ctrl+H and goto was helpful.  Is there a way to have report show multiple bills an their associated payments at one time?

Catherine_B
QuickBooks Team

How can I confirm where a bill was paid

You can use the Transaction List by Vendor report, mikeshick.

 

The report will give all the transactions you created for the vendor including the Bill and Bill Payment. You'll just have to look into the amounts to match the bill to its payment. 

 

Let me show you how: 

 

  1. Go to the Reports menu and choose Vendors & Payables.
  2. Select Transaction List by Vendor.
  3. You'll see all the list each vendor have. Just click the Customize report to select the preferred transaction type and vendor.
  4. Click OK to refresh.

Allow me to attach the Customize reports in QuickBooks Desktop link again for your reference in adding and removing filters or columns. 

 

If there's anything else that you need help with, just post there here. Take care!

mikeshick
Level 3

How can I confirm where a bill was paid

Thanks.  Difficulty is that I pay several bills from vendor in one payment.  It's hard to match over time.  Payments don't always follow order of bills...so it seems that only ctrl+H is what I can use.

 

Seems easy enough that transaction by vedor report could have a column for bills that also has column for check number used to pay, or a quick link to payment instead of ctrl h for each transaction.

Jessicah177
Level 1

How can I confirm where a bill was paid

Did you ever find a way to run a report like this ... a vendor report that shows a column for bills paid and the check number used to pay them?

Jessicah177
Level 1

How can I confirm where a bill was paid

Did you ever find a way to run this report ...?

A listing of bills paid with the check number used to pay them?

AileneA
Moderator

How can I confirm where a bill was paid

Hello, Jessicah177. 

 

Allow me to chime in for a moment and help make sure you'll get the report that you need in QuickBooks Desktop (QBDT). 

 

You can run the Transaction List by Vendor report to run a list of vendors. Then, customize the Display option to show the list of vendor payments paid on you and the check number. 

 

For more details, you can follow the steps below:

 

  1. Click Reports on the top menu.
  2. Choose Vendors and Payables.
  3. Tick Transaction List by Vendor.
  4. Hit Customize Report
  5. Select the Display tab and go to the COLUMNS section.
  6. Type Paid and check number you want to appear on the report. 
  7. Press OK once done. 

 

 

 

Another option you can consider in when filtering is the Billing Status. It should default to Any, meaning it'll show whether it's been billed or not. If that's not quite doing it for you, you can try other filter options such as Paid Status or Posting Status. Here's that article I gave you on your other thread about customizing reports: Customize reports in QuickBooks Desktop

 

To learn more about how QuickBooks generates the reports, you can check out this article: Understand reports

 

Don't hesitate to tag my name in the comment section below if you have other concerns or questions. I'm always ready to help.

Jessicah177
Level 1

How can I confirm where a bill was paid

thank you AlainaA!

That is helpful but is missing one thing ...

I'm hoping to see a list of bills with their numbers along with the check number used to pay them. This lists the bills entered in a given period and checks used to pay in a given period but does not list the detail of an individual bill along with what check number was used to pay it.

Jessicah177
Level 1

How can I confirm where a bill was paid

thanks AlainaA

What that's missing is the individual bill and what check was used to pay it

AileneA
Moderator

How can I confirm where a bill was paid

Hello, Jessicah177. 

 

The Transaction List by Vendor report also includes their bill number and bill payment number. However, the check number will not be shown in the check number column. It will be under the NUM column.  

   

 

 

  

 

 

Let me know if you still have questions. I'm always here to answer them for you. Have a wonderful day!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us