Accounting Ideas

Adding Sales Invoice Number to bank transactions that are imported and matched

We have a number of customers who are invoiced the same amount each month. When the bank transactions are imported they identify a transaction for the customer with the date and amount but not the sales invoice number. However, the remittances we receive from our customers often only show the invoice number and the amount, not the date of the invoice. On a number of occasions Sage has not allocated the receipt to the oldest outstanding invoice. I match this transaction, assuming it is correct as it's for the right amount but then have had queries from customers (2 recently) as they say they've paid a different invoice. When I've checked the customer account I can see that the receipt is allocated to one of their invoices, but there is an older invoice for the same amount outstanding. It would be helpful to show the invoice number as well when Sage identifies a transaction that it thinks is a match to avoid errors of this type.

  • Guest
  • Feb 1 2023
  • One For The Future
  • Attach files
  • Guest commented
    September 08, 2023 18:53

    Totally agree, it's only a really small change to show the invoice number as well as date and customer name where there's a match found, but it would make life so much easier!