I did a similar thing for Volksbank (a German bank) statements using awk:

https://github.com/airblade/volksbanker-awk/blob/main/vba