Hi,
You can derive parent account name from name of your accounts using Split(). Then get corresponding finance id from parent.
Please see below screenshot for your reference.
I have created calculated field “parent_finance_id” using formula below.
I hope this helps!
Thanks,
Tejal Gohil