cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
rao-sudarshan
Level 1
posted
‎December 29, 2021 04:46 AM
last updated ‎December 29, 2021 4:46 AM

How can I report on all Payment Records that do not have an Online Banking Match?

When we receive cash payments - that's directed to an account called Cash on hand. Online payments are always directed to Bank Account. In some occasions, we may have erroneously marked a cash transaction to be directed to Bank Account. I need to find such transactions. As I have integrated bank account with QB, all online transactions will necessarily have an online banking match. Cash transactions should not have this match. So, I'm looking for a way to find all Payment records where it does not have a corresponding online match. Is there a way to do this?
Reply
1 Comment 1
MaryLandT
Moderator
Moderator
‎December 29, 2021 05:36 AM

How can I report on all Payment Records that do not have an Online Banking Match?

I'm glad to provide the steps on how to pull up all payments posted to the Cash on hand account, rao-sudarshan.

 

You can run the Transaction Detail by Account or Transactions List by Customer report. Then, customize the payment method by Cash and the account to Cash on hand to get the data that you need.

 

Let me guide you through the steps on how to accomplish this.

 

  1. Go to Reports from the left menu.
  2. Open the Transaction Detail by Account or Transactions List by Customer report.
  3. Click Customise.
  4. Go to Filter.
  5. Mark Transaction Type, then select the payment transaction.
  6. Mark Account, then select Cash on hand.
  7. Mark Payment Method, then select Cash.
  8. Click Run report.

 

If you need to save this report, you can memorise it. That way, you don't have to go through the same customization.

 

Here's an article to help you with the process: Memorise reports in QuickBooks Online. It includes exporting the report to an Excel file.

 

Let me know if there's anything else you need about pulling up all payments. I'm always right here to help you.

Reply