I have finally got bank feed rules set up and working. I have mostly set up rules to do with customer receipts.
HOWEVER, I have discovered that when a rule picks up a matching transaction, all it does is add this receipt as a payment on account.
It does not try to match it up with an invoice of the same amount or give an opportunity for the user to do it, by say, adding an extra popup where it asks which invoice you would like to match the payment to. This means that if not manually corrected you end up with very messy customer and supplier accounts where invoices and payments are not matched and you have loads of 'payment on account' transactions.
I have spoken to Sage support today to check that I am fully understanding how bank feed rules work, and sadly they have confirmed that Sage does not have the capability to match payments with invoices through bank feed rules, nor do they have a report to pick up any accounts with unmatched payments on account.
In trying to automate a process I have created a more time consuming manual process. What a frustrating waste of time. Sage fail!
