Skip to main content
T
Tombloke
August 3, 2021
Question

How do I search for received payments which don't have a matching bank transaction?

  • August 3, 2021
  • 1 reply
  • 0 views

As per the title of the email - I've got some entries which have been made manually and entered as 'payments' but they haven't necessarily been received because they don't have matching bank transfers.

I'd like to search for any and all payments which have been entered this way so I can tidy them up.

 

I can find a list of all payments - but I have to go into each individually to see which have a matching bank transaction.  Or I can go into each customer and do the same - but I'm hoping there's a report or something which would save me 2million mouse clicks.

 

Thanks, Tom

1 reply

G
GeorgiaC
August 3, 2021

Hi Tom, you can check this by going to the bank account that the payments were posted to and filtering this to show only transactions that have not been cleared (as adding or matching a transaction from the bank will automatically mark this as cleared, and you'll see a green icon within the 'tick' column of the Chart of Account register signifying this).

 

To do this, select Accounting from the left-navigation menu > click Account history beside the bank account > Click the filter to the left > Set 'Reconcile status' to 'Not cleared' > Apply.

 

Hope this helps!

Terms & ConditionsAccessibility statement