Bank Feeds not Locating Paid Invoices

[CharmaineG]

I have serveral deposits (paid invoices) apperaing under bank feeds but no transaction matches appear or when selecting the find button transactions don't appear also.

I have checked the payment transaction details for all bank statement entries and can confirm that the receive payment amount entered and date entered of all paid invoices are the same details as to what appears on the bank feeds but still with no match?

Prior to this issue all paid invoices would automatically match under bank feeds.

Any suggestions/thoughts anyone?

[Steven_M]

Hi @CharmaineG

Basically to make a transaction appear so it can be matched in AccountRight  there are 3 requirements that needs to be meet:

• The transaction needs to be going to the bank account that you have setup as your bank feeds account. You can check this via going into the transaction and taking a look at the account number at the top of the screen. This account number needs to be the same as the one listed in the Banking>>Bank Feeds>>Account.
• The transaction needs to have a similar date range and amount for that bank feed transaction. I would recommend find the transaction via the Banking>>Bank register window to check that particular transaction has been entered correctly.
• Finally the transaction must not be reconciled or marked as cleared in the Banking>>Reconcile Accounts window. For example if you open up the Banking>>Reconcile Accounts window and there is a tick next to the transaction it has been marked as cleared. This would make the transaction not be able to be matched.

So provided that the invoice payment impacts the bank account, is on a suitable day, has a suitable amount and not reconciled or marked as cleared you should be able to match that transaction.

If you are sure that those requirements are meet with that invoice payment I would love to see the following so we can investigate it further for you:

• The payment transaction i.e. the receive payments transaction
• The bank feed you are trying to match it to*
• The find window for that bank feed with suitable dates and amounts
• The Bank register showing that transaction*
• The Banking>>Reconcile accounts window showing the payment transaction.*
  
  *Please make a note of the account that is showing at the top of these windows.

[CharmaineG]

Hello @Steven_M

Thank you for your detailed response.

To confirm I have checked that the transaction is going to the bank account that I have setup as my bank feed account and that the transaction has not been reconciled.

As suggested I searched for the transaction via the Banking >>Banking register window and noticed that the deposit amount entered was for the TOTAL of x4 paid invoices and not each individual invoice amount (when the payment was received I enetered the payment via the Sales>>Receive Payments and  Receive All).

This explains why I can not find the x4 transactions under bank feeds.  Any suggestions on how I can now match the transaction?

Your assistance is most appreciated.

Kindest Regards

Charmaine G

[CarenH-J]

Hi Charmaine

I would also be checking to see if it hasn't already accidently been ticked in the manual Bank Reconciliation, if it is ticked there is will not appear on the Bank Feeds, I have had this happen with several clients.

regards

CarenK

[Neil_M · Accepted solution]

Hi Charmaine ( @CharmaineG )

If you wanted to have all of the transactions match up to the bank feeds, then each individual transaction would need to appear in your bank account inside AccountRight. This will mean that you will have to delete the existing deposit transaction and then re-enter the transactions as they appear on the bank feeds screen, so in this case 4 separate transactions.

Alternatively, you could right click on the transactions inside the Bank Feeds Window and choose to hide the transactions. This will stop the transactions appearing in the bank feeds window. Once hidden you can then go into the Reconcile Accounts window and tick the corresponding transaction. This will have the same result as if the transactions had matched up with the bank feeds window.

Do let us know how you get on with this,

[CharmaineG]

Hello @Neil_M

What a simple solution! All I had to do was hide the transcation.

Thank you

Kindest Regards

Charmaine

[Neil_M]

Hi Charmaine ( @CharmaineG )

Happy to help you find an easy solution for this.

Going forward if possible you would want to mimic the real world as much as possible to ensure that you have the best possible chance of your bank feeds matching up to the transactions inside your AccountRight. Occasionally you might encounter the same situation, particularly if the bank loads multiple transactions as a single amount or splits one amount into several component payments. You can use the method I mentioned to overcome these situations

Please don’t hesitate to post any other questions that you may have.