I will order the creation of a program that organizes the statement in excel

Good day,

I am aiming to introduce automation in the company.

I manually download a bank statement (csv format) from mbank every week, which the assistant modifies for management accounting in the same way:

1. removes the top 26 rows (period summaries, unnecessary),

2. removes columns C and D (information which account, category - unnecessary)

3. multiplies all amounts *-1 to change characters,

4. sorts by transaction date A->Z

5. manually sorts file names, e.g. instead of

Allegro PURCHASE BY CARD - INTERNET -> Allegro.

BLIK WITHDRAWAL ATM WSK. SANTANDER PL NETWORK -> BLIK

LEROY MERLIN POZNAN ZLO BLIK PURCHASE -> Leroy Merlin

etc.

These names are quite repetitive every statement, there are about 50 different ones.

This process takes about 30 - 60 minutes every week and it would be extra if someone could help me automate it.

The final result should be a tidy excel file.