How to create allocation rules from the general ledger

Summary:

The following journals needs to be created.

1. Add up the balances of the income accounts (4xxx)
2. That balance should be multiplied by x%.
3. The balance obtained in point 3 should be entered to the account 7xxx.

Is it possible to do this?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

General Ledger Cloud

Code Snippet (add any code snippets that support your topic, if applicable):