cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about connecting your bank and credit cards in QuickBooks Online
Lynne--Latham
Level 1

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

 
1 REPLY 1
jenop2
QuickBooks Team

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

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.

 

unmathced.png

 

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

 

unmathced 2.png

 

Let me know if you need anything else.

Need to get in touch?

Contact us