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

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

This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.

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?