We integrate with FIS OMNI. We need to display daily investment returns into our QLIK Sense Reporting in order to achieve a Daily Closing Balance which will match the Daily Closing Balance in FIS OMNI.
Right now, the closing balance only shows in our QLIK report as of the last date there was a transaction.
For example, let's say the monthly opening balance on 5/1/25 was $1000. There were a series of debits and credits during the month and the last debit was on 5/20. The balance through 5/20 was $800. There were no more transactions between 5/20 and 5/31. The only thing between 5/20 and 5/31 were stock market gains and losses.
My question is: how do we determine the daily and monthly end 5/31 balance with only gains or losses based on investment returns ?
We integrate with FIS OMNI and are pulling data from that system.
