Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Cash Flow Statement: Creating The Proper Time Rollups For Beginning Cash

Question

How do I create proper Time Rollups for Beginning Cash in my Cash Flow Statement?

Answer

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.

 

  • Was this article helpful?