Skip to main content
R
regalkit
June 14, 2021
Solved

How can I sort the Bill numbers numerically within each vendor in "Pay Bills"?

  • June 14, 2021
  • 1 reply
  • 0 views
Currently, I can sort By Payee, Daye, Number, Etc. I would like to sort by Vendor, but within each vendor, I would like to pay the bills in the numeric order as that is how they match the vendor's statement.
Best answer by Kristine Mae

Let me share some information, Regalkit.

 

You're right. The bills are listed in the order that they're created per vendor. 

 

You'll want to filter it to show the transactions of the specific vendor. This way, you can easily select the first $20,000 worth of bills. Here's how:

  1. Click Filter on the Pay Bills page.
  2. Under Payee, select the vendor.
  3. Click Apply. 

Feel free to check the articles provided by my colleague at the top to guide you.

 

If there's anything else that you need, don't hesitate to let us know. We'll reply as soon as we can. Take care!

1 reply

AlexV
AlexV
June 14, 2021

Hi regalkit!

 

There's a better way to see the list of bills by the vendor and sort them by bill numbers. Let me help you.

 

Please follow these steps:

  1. Go to the Expenses tab and select Vendors.
  2. Select the vendor's name. From the Filter drop-down, choose Open bills under Type and All dates under Date.
  3. Tap Apply. You'll see a list of the open bills. Simply click the No. column header to sort them by bill number.

 

In addition, you can pay the bills by vendor. Here's how:

  1. On the Pay bills page, click the Filter button.
  2. Select the vendor under the Payee drop-down.
  3. Tap Apply. 

 

Then, by default, the result is filtered based on when they are created. You can also click the Ref No. column header to sort them by bill number.

 

Here are some of the articles you can check. These will help you in managing your bills in QuickBooks Online:

 

Also, visit our expenses and vendors page for more tips and references on how to enter expenses, pay bills, write checks, and manage suppliers.

 

Need anything else? Leave a comment below and we'll assist you. Take care!

R
regalkitAuthor
June 14, 2021

Hi,

Thank you for your response, but I am aware of that. It's just that when I go to "pay bills" and I have 50 bills from one vendor I would that are not listed in bill numerical order. I assume they're listed in the order that they were entered. So if I wanted to pay $20,000.00 towards the first twenty thousand dollar bills of the said vendor, I'm not able to do it. When I click on top of the columns I either get vendor order or numerical order disregarding the vendor and it's one big mess. I hope I explained my issue clearly. Thank you!

Kristine Mae
Kristine MaeAnswer
June 14, 2021

Let me share some information, Regalkit.

 

You're right. The bills are listed in the order that they're created per vendor. 

 

You'll want to filter it to show the transactions of the specific vendor. This way, you can easily select the first $20,000 worth of bills. Here's how:

  1. Click Filter on the Pay Bills page.
  2. Under Payee, select the vendor.
  3. Click Apply. 

Feel free to check the articles provided by my colleague at the top to guide you.

 

If there's anything else that you need, don't hesitate to let us know. We'll reply as soon as we can. Take care!

Terms & ConditionsAccessibility statement