Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
October 7, 2025
Question

Is there a way of getting a list of unmatched bill payments

  • October 7, 2025
  • 1 reply
  • 6 views
No text available

1 reply

JenoP
QuickBooks Team
October 8, 2025

Yes, there is, Lynne.

 

The most effective way to get a list of unmatched bill payments in QuickBooks Online is by running a customized Transaction List report. Then, add a column for Cleared or Online Banking.

 

An Uncleared transaction means that it hasn't been matched to a corresponding record downloaded from your bank. You can also confirm its status by seeing a blank entry in the Online Banking column.

 

Here's how to run the report:

 

  1. Go to the Reports menu in the left-hand navigation bar.
  2. Type in Transaction List by Supplier or Transaction Detail by Account in the Search bar.
  3. Click the Columns button, then check both Cleared and Online Banking boxes.
  4. In the Report period field, select All Dates.
  5. Click Filter and apply the following filters:
  • Transaction Type: Select Bill Payment (Cheque) and/or Bill Payment (Credit Card).
  • Cleared: Select Uncleared.

 

 

From there, you'll see a list of all the bill payments that have not yet been matched to a bank transaction.

 

 

Let me know if you need anything else.