Skip to main content
R
rao-sudarshan
December 29, 2021
Question

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

  • December 29, 2021
  • 1 reply
  • 0 views
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?

1 reply

MaryLandT
MaryLandT
December 29, 2021

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.

Terms & ConditionsAccessibility statement