Job description
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.