Hi all,
I just wanted to see if anyone has any knowledge or previous experience with automating credit card transactions.
Currently over 1500 transactions are manually combed through to add a nominal, job number, department number, purchase order number and then the relevant net and VAT values are calculated.
We have an in house system that the job numbers are stored in online that I was hoping to use a scraping tool, however then using vlookup and if functions on a template sheet seem rather messy.
Would I be better looking at a database function for this and then using that as an export into our financial software?
Many thanks,
I just wanted to see if anyone has any knowledge or previous experience with automating credit card transactions.
Currently over 1500 transactions are manually combed through to add a nominal, job number, department number, purchase order number and then the relevant net and VAT values are calculated.
We have an in house system that the job numbers are stored in online that I was hoping to use a scraping tool, however then using vlookup and if functions on a template sheet seem rather messy.
Would I be better looking at a database function for this and then using that as an export into our financial software?
Many thanks,