Automates downloading bank transactions, updating master Excel files, and loading them into a web system.
The script uses Selenium to log into the bank and download the latest Excel with all transactions.
It compares NΒ° Secuencia
values to avoid duplicates and inserts new rows with formatting
preserved.
The script searches for each client and automatically registers the payment with the right method.
It sends an email to all users with the payment's receipt attached to it