Match or rules?

SUGGESTED

Hi, I am new to sage.

I am helping run a storage rental business, there are lots of smallish payments each month mostly from standing orders from the tenants. We have set up reoccurring monthly invoices for each customer. On the bank feeds sometimes sage offers a match for payments but most of the transactions are not matched and you have to search for each invoice manually which is time consuming when there are hundreds each month.

Why is sage not matching these transactions?

I looked at rules, which seems to be the function to automatically deal with the transactions but it seems the rules don’t match to an invoice that has been created. None of the customers have their bank details added to sage, will this help sage match the invoices?

Any tips or pointers on what I need to do here? Do I need to help sage match the transactions better or set up the rules differently?

Thanks

Parents
  • Hi James - I've struggled with similar & from my experiences, I can share the following:

    The bank feed will only match if there is something in the payment reference that it can easily identify as being unique & link it to the invoice. So reference of 'storage' or the same amount recurring often won't do it. 

    If it's an unusual amount then that's probably when it is finding matches for you - but even that isn't 100% guaranteed to be correct & always best to check before pressing the button.

    As it's an invoice, you can't set up a rule in the same way that you could for just a money in or out transaction.

    If it was one-off payments you could 'encourage' your customers to use the invoice number as the PAYEE reference (so what YOU see) but as it's a standing order & recurring monthly against different invoices then that won't work either.

    Suggestion - haven't tested myself - what if you give customers a customer reference number on the customer record & they use THAT as the payee reference? That might help the automation identify at least a selection of invoices to pick from?

    I just did the GoCardless x Sage Accounting beta programme & LOVE it! I have MANY recurring invoices for the same amount every month for the Sage subscriptions that I charge clients for & once I set this up (whcih did take effort & time I will admit) it just runs itself. You manage it from the recurring invoices screen.

    Perhaps try it with new clients? Thre will be a cost for you on GC fees but I find that the low cost of that massively outweighs the time spent manually matching. 

    Other than that, sadly it is a manual match but if it's any consolation none of the other accounts systems would manage it any better.

  • 0 in reply to Tracey Robertson

    thanks, this is helpful. I'll look into how I can get a reference on the transactions.

Reply Children
No Data