Requirement to load YTD balances only for a set of accounts but move balances to asset or liability

Summary:

We have certain offset accounts in ERP and their periodic balance may be either negative or positive. Requirement is to update YTD balance based on the periodic load to two different accounts. If balance is positive, we need to update it to Asset account and if negative update it to Liability account. Please let me know if any one has come through the requirement and achieved it.

All other accounts loading from ERP are still periodic balances, however for only these accounts we need to update YTD balances. Thanks in advance.

Content (please ensure you mask any confidential information):