How do I create proper Time Rollups for Beginning Cash in my Cash Flow Statement?
1. Create a new Assumption or Custom Account called Beginning Cash Weight Acct and add this to the Assumptions sheet or another plan-independent sheet.
2. In the Assumptions sheet or Formulas Tab (if you created a Custom account in step 1), create a formula that populates 1,000,000,000,000 for January and 1 for April, July, and October. The formula will look something like this:
if(month(this)=1, 1000000000000, if(month(this)=4,1, if(month(this)=7,1, if(month(this)=10,1,0))))
3. In the Beginning Cash account, set the Time rollup to Weighted average of rolled-up values and weight on the Assumption we created in the step above.