Transactions in the cash flow frog forecast can be divided into two main groups:
- "Real" transactions - this group includes actual transactions such as bills, invoices and estimates. These transactions are placed in the forecast based on their expected payment dates.
- Projections - this group includes "expected" transactions. In this article we will dive into the details of the different type of projections.
There are three types of projections:
- User created projections - projections that are created manually by the user. You can find more details on how to create projections later on in this article.
- Auto-generated projections - when you connect your company for the first time, Cash Flow Frog analyzes its accounting data and automatically generates projections based on its AI-powered forecast prediction algorithm. Whenever the accounting data is updated, Cash Flow Frog analyzes the updates, but as opposed to the initial connection, new projections are not automatically added to the forecast but instead they are presented as suggestions and only become projections if you choose to apply them.
- Imported recurring transactions - recurring transactions such as bills, invoices, expenses, sales receipts, and journal entries that are imported directly from the accounting data.
Reviewing Your Projections
On the right part of the cash flow status bar on the home screen you can see the total number of projections in the forecast. Click on it to open the full list of projections:
Use the projections table to:
- Review your projections - go over the details of your projections such as amounts, dates, account types, customers and vendors.
- Edit amounts - if you see any amounts that you would like to change click them and edit their values.
- Exclude projections from the forecast - you the switch on the right end of each row to exclude or include it in the forecast.
- View upcoming forecast transactions - click the table icon to open a list of upcoming forecast transactions.
- Edit projections - click the pencil icon of a projection to edit all of its fields (please note that this option is not available for imported recurring transactions).
- Click the three dots to the right of the include/exclude switch for additional actions such as deleting and duplicating projections (please note that these options are not available for imported recurring transactions).
- Review the suggestions tab to apply or discard projection suggestions.
To create projections, click the Add Projections button on the top right part of the projections or home screen to open the projection creation screen:
Here you can add as many projections as you want.
For each projection:
- Enter an amount.
- Select a related customer, vendor or account,
- Select a type - the type will be used for classification in the forecast.
- It is recommend to enter an informative description in the details field.
- For recurring projections use the repeat column to select a the frequency, enter a start date, and optionally set and end date and an amount trend for increasing or decreasing projections.
- For one time projections enter a date.
- Add more projections by clicking + Add another projection.
- Save the projections by clicking the Add Projections button on the bottom of the page.
Projections In The Forecast
Projection based transactions in the forecast can be recognized based on the source column in the transaction table:
Click More settings on the top right part of the projection list to view all projection related settings:
Available settings are:
- Include projections in the forecast - use this setting to exclude projections completely from the forecast.
- When a projection reaches its expected date - use this setting to push projections forward into the future automatically until you decide to remove them.
- When a projection conflicts with a bill/invoice - use this setting to determine what to do when a projection conflicts with an actual bill or invoice on a specific date.
- Include recurring transactions - use this setting to include or exclude imported recurring transactions as projections.