Loading YTD balance sheet movements and closing balance

Summary:

I currently have a client that is loading data from HFM. I have split my integration so that one data load rule loads the movements and a second loads the closing balance. I have default movements turned on and set up. The first data load rule includes movements in the balance sheet to help populate the cashflow.

I have an instance where in one month in FCC, there was a closing balance in an account and a YTD movement. The mapping from HFM was then changed for that account and so in the next month, there was not a closing balance or YTD movement for that account in the data load file. As a result, FCC assumed that the YTD movement was 0 and overwrote the closing balance.