Sounds like you need to develop a plugin or take a look at existing ones (for example effective date [1] might be helpful)

[1] https://github.com/redstreet/beancount_reds_plugins/tree/mas...