Skip to main content
All CollectionsTemplates
Why is my client's data not showing up in the Cash Flow Forecast Template from P&L and BS?
Why is my client's data not showing up in the Cash Flow Forecast Template from P&L and BS?

Be sure to select your own accounts in the drop down menus to see your client's data

Lasse Kalkar avatar
Written by Lasse Kalkar
Updated over a year ago

Access the Cash Flow Forecast Template from P&L and BS here

In order to use the Cash Flow Forecast Template from P&L and BS, follow these steps:

  1. Be sure to connect the company you want to see data for in the Profit & Loss tab and Balance Sheet tab (learn how to do that in this article)

  2. Add your opening cash balance in cell B15 (red arrow below)

  3. Select your client's accounts in the drop down menu (boxed in red below)

  4. Add your expected income (Cash Inflow) and expenses (Cash outflow) for each month

  5. Your ending cash balance will automatically update

    1. Ending Cash Balance = Opening Cash Balance + Cash In - Cash out)

Did this answer your question?