Accounting Ideas

Ignore / Auto-Round up 1p when matching invoices in banking

Hi There,


We import all of our sales and purchase invoices to Sage via the API and often when importing the VAT rounding will throw the invoice total out by +/- 1 pence.


When it comes to matching these invoices through the banking we frequently have to search out the invoice and adjust by 1p because Sage will only match against the exact amount. This is time consuming and annoying and it would make our life so much easier if we could have an option just to ignore the penny or automatically adjust the amount to match. I appreciate not everyone would want this so if it was a toggle option you could set somewhere or a button you had to press that would be fine but at the moment the process is:


  • Click to match an invoice, browse/search the list and find the invoice which is 1p out

  • Open a new browser tab and go to Purchase/Sales invoices

  • Search out the invoice which is 1p out

  • Open this and adjust gross amount +/- 1 pence

  • Save the invoice

  • Go back to the original tab and research/browse to refresh invoice list

  • Relocate invoice and you can now match it


Anything which made the above easier would be much appreciated!!

Thanks, and Merry Xmas

  • Guest
  • Dec 21 2023
  • We're Taking A Look At This
  • Attach files