We are currently using VBA for for day to day work & would like to automate this further.
Here's the link to steps we are currently using https://docs.google.com/document/d/1D4OIwpLbT9ja33rujRwF6hslEpdt-1RgvPetJXfHFXk/edit?usp=sharing
It might look long but it's basically parts a) Converting excel to PDF b) Downloading reports from application c) Running macro to i) create pivot of vendor names & account ii) Using bank description to search vendor name & accordingly assigning account name for such transaction iv) Using dropdown to update missing transactions & accounts v) Creating final sheets to be imported
Confirm which tool will be best to run this on so that it's user friendly, flexible & efficient. Also what would be estimated costing & timeline
Advanced AR Headset Development Category: Android, Game Development, IPhone, Matlab And Mathematica, Mobile App Development Budget: ₹500000 - ₹1000000 INR