Using Three-Way Cashflow Forecasting

Create efficiency in your practice through automation. ProfitSee's Three-Way Cashflow tool allows you to generate three year cashflow forecasts based on historical performance with the click of a button!

For more about the Balance Sheet and how it affects you, read our blog post "Balance Sheet Projections and You". 

Creating the Baseline Projection

  1. Log into your ProfitSee account and open the company file you want to work with.

  2. Click "Forecasting" on the left-hand navigation panel.

  3. Select the "3-Way Cashflow Forecast" tab. ProfitSee will automatically begin calculating your baseline projection if the file has sufficient historical AR/AP data.*

Screen Shot 2019-05-28 at 10.27.46

**NOTE: If you do not have enough historical data (at least 12 months), you will receive the following prompt to upload a spreadsheet containing this information. If you do not have access to the historical AR/AP data, we suggest making your best guess, but beware that the corresponding baseline projection will not be as accurate.


4. Select the 'Setup Wizard' Button to configure the 3-way cashflow forecast in a way that truly reflects the reality of the business and ensure all considerations are taken into account when projecting future growth and risk.

Screen Shot 2019-06-10 at 4.17.37 PM

Here you will be able to make key decisions on important factors that invariably have an impact on the immediate and long term future of the business.

Screen Shot 2019-06-10 at 4.19.43 PM

This includes how the business recognizes and reconciles Owners Compensation, whether they track taxes on an accrual or cash basis, and if there are any accounts or long-term liabilities such as loans or depreciation that do not have an effect on cash movement.

Screen Shot 2019-06-10 at 4.19.13 PM

Building Strategies

After generating a baseline three-way cashflow projection, ProfitSee allows you to build strategies and create an updated projection. These strategies provide the opportunity to address any upcoming periods in which you notice poor performance. 

  1. Click on "Build a Strategy" to bring up pre-built templates in the following categories: Add a Loan, Add additional Monthly Expenses, AR/AP Assumptions, Sales Tax Assumptions, Add Scenarios

2 3way

2. Select the category you'd like to adjust and fill in all fields of the template then click "Save" to add the strategy to your projection. Strategies with a checkmark in the box labeled "Active" will be added to the new projection, while those with no check in the box will not be included.

3 3way

3. Repeat Step 2 until all desired strategies have been added. 

4. A new projection will automatically be created beneath the strategy section each time you add or update a strategy. This allows you to compare the business' cash on hand with and without strategies to aid in planning for the future.