Cash Flow Projection - Revision history

Siyuan wei: /* Populate Cashflow monthly */

2023-07-31T14:58:04Z

Populate Cashflow monthly

2023-07-31T14:54:59Z

Populate Cashflow monthly

2023-05-25T19:09:00Z

Copy and Paste Rows

2023-03-21T16:36:31Z

Generate Cash Flow Initialization Sheet:

2023-03-03T17:57:31Z

Using A Provided Template

2023-03-03T16:35:53Z

Generate Cash Flow Initialization Sheet:

2023-03-03T16:34:17Z

Using A Provided Template

2023-03-03T16:33:54Z

Using A Provided Template

2023-03-03T16:31:20Z

Using A Provided Template

2023-03-03T16:29:21Z

Generate Cash Flow Initialization Sheet:

@@ Line 32: / Line 32: @@
 * by default, you are expected to forecast on '''Header Lines''', then all forecast has to be done on '''Headers'''.
 * If you decided to do forecast on '''CostLines''', then all forecast has to be done on '''CostLines'''.
 * by default, you only see '''Header Lines''' as the lowest level. the '''CostLines''' are hidden.

@@ Line 27: / Line 27: @@
 == Populate Cashflow monthly ==
 === Manually Changing Cashflow by Month. ===
 With this sheet, you can manually change amount assigned to each month. Once amount entered, you will see the '''Remaining''' field of this line item changed, which shows either a + (under) or - (over). '''The final goal is to have the remaining field be 0.'''

@@ Line 18: / Line 18: @@
 === Copy and Paste Rows ===
 In this template, in case you need more lines under a section, you can copy and paste Rows next to where you copied from. see example below.
 [[File:CashFlow Initialization CopyandInsert.gif|frame|center|Copy and Insert]]

@@ Line 5: / Line 5: @@
 == Generate Cash Flow Initialization Sheet: ==
 # If your project is estimated using Estimate 2.0, follow '''[[Cash Flow Projection#Generate Cashflow Initialization Sheet|Generate Cashflow Initialization Sheet]]'''
-# If your project is existing, and note estimated using Estimate 2.0, follow '''[[Cash Flow Projection#Using A Provided Template|Using A Provided Template]]'''
+# If your project is existing, and not estimated using Estimate 2.0, follow '''[[Cash Flow Projection#Using A Provided Template|Using A Provided Template]]'''
 === Generate Cashflow Initialization Sheet ===
 When Estimate was completed, budgets will get [[Budget Upload|uploaded from Estimate 2.0 to Viewpoint]] through a sheet called Consolidation. Once Consolidation is completed, you can go to the Cash Flow Functions located under Budget/CashFlow Ribbon Tab to access cashflow functions. Click on "CashFlow" Button to generate the cash flow initialization sheet.<br>

@@ Line 14: / Line 14: @@
 <span class="plainlinks clickbutton">[https://www.synwiki.org/download/est2/BlankCashFlowTemplate.xlsx<span class="mw-ui-button mw-ui-progressive mw-ui-big" style="font-size: 1.5em;" title="">Download</span>]</span>
-Follow instructions at '''[[Using Provided Template to Set Up Cash Flow Projection]]'''
+In this blank template, you are able to change descriptions, change total amount, copy and paste rows as needed. The default start date is set to January 04, 2021. If your project started before that time and still struggles with cash flow projection, you are in trouble.
 === Change line item name and line total ===

@@ Line 12: / Line 12: @@
 === Using A Provided Template ===
 If your project was note estimated using Estimate2.0, use the provided template to initialize the cash flow set up for your project. the template can be downloaded here. <br>
-<span class="plainlinks clickbutton">[https://www.synwiki.org/download/est2/Blank CashFlow Template.xlsx<span class="mw-ui-button mw-ui-progressive mw-ui-big" style="font-size: 1.5em;" title="">Download</span>]</span>
+<span class="plainlinks clickbutton">[https://www.synwiki.org/download/est2/BlankCashFlowTemplate.xlsx<span class="mw-ui-button mw-ui-progressive mw-ui-big" style="font-size: 1.5em;" title="">Download</span>]</span>
 Follow instructions at '''[[Using Provided Template to Set Up Cash Flow Projection]]'''

@@ Line 11: / Line 11: @@
 === Using A Provided Template ===
-If your project was note estimated using Estimate2.0, use the provided template to initialize the cash flow set up for your project. the template can be downloaded here. Follow instructions at [[Using Provided Template to Set Up Cash Flow Projection]]
+If your project was note estimated using Estimate2.0, use the provided template to initialize the cash flow set up for your project. the template can be downloaded here. Follow instructions at '''[[Using Provided Template to Set Up Cash Flow Projection]]'''
 === Change line item name and line total ===

@@ Line 4: / Line 4: @@
 == Generate Cash Flow Initialization Sheet: ==
-# If your project is estimated using Estimate 2.0, follow [[Cash Flow Projection#Generate Cashflow Initialization Sheet]]
+# If your project is estimated using Estimate 2.0, follow [[Cash Flow Projection#Generate Cashflow Initialization Sheet|Generate Cashflow Initialization Sheet]]
-# If your project is existing, and note estimated using Estimate 2.0, follow [[Cash Flow Projection#Using A Provided Template]]
+# If your project is existing, and note estimated using Estimate 2.0, follow [[Cash Flow Projection#Using A Provided Template|Using A Provided Template]]
 === Generate Cashflow Initialization Sheet ===
 When Estimate was completed, budgets will get [[Budget Upload|uploaded from Estimate 2.0 to Viewpoint]] through a sheet called Consolidation. Once Consolidation is completed, you can go to the Cash Flow Functions located under Budget/CashFlow Ribbon Tab to access cashflow functions. Click on "CashFlow" Button to generate the cash flow initialization sheet.<br>