GRAP | How to use the Excel Cash Flow Worksheet linked to the Cash Flow Statement in the Financial Statements

  Instructions:

From the 2023.10.01 release, a pioneering feature is being piloted, offering users the option to seamlessly link the Cashflow statement to an excel version of the Cashflow worksheet, either utilizing the default version or their personalized iteration. 

Users in the Cashflow statement will be able to select the below options: 

• Default Cashflow Statement - This is the original Cashflow statement included previously. Users can continue using this version like in the previous versions. 

• Cashflow Statement linked to Excel - On selecting this version of the Cashflow, the values in the Cashflow statement are linked to a Cashflow worksheet in the Document manager: 

•  Any changes in the Cashflow worksheet needs to be saved in Excel and to update the Cashflow statement in Caseview, a “Tools | Recalculate” needs to be done.  

• To perform this function in the GRAP AFS, click on Tools and then Recalculate. 

• Users can “Unlink” and “Link” cells in the Cashflow statement to their own Cashflow worksheet by double click on the cell and it will launch the link dialog. Ensure the excel document is saved in the document manager of your Caseware file. 
   

• Note that when users choses to link the Cashflow statement to excel this is done at own risk. 

   Related Articles