Browse our resources to get the most from CashPhlow

We’ll give you three good reasons. 

1. No mistakes. Excel can be a mousetrap for financial forecasting. One error in a formula and your whole forecast is wrong.
2. Automation. CashPhlow takes your data and automatically organizes it into a weekly view.  From there you can add additional data by week.
3. Flexibility. Change your assumptions on the fly, easily.  No worries about errors as you enter new data, delete items, and change dates.

CashPhlow allows you to enter data that is not in your accounting system. What type of data? Future sales and future expenses. Examples for future sales include proposals that may close, or work that will be billed to a customer at a later date. This “forecast” data is considered “Manual Entries” in CashPhlow.

When you build a new forecast, you have the option of checking the box to retain manual entries from your last forecast. This means all manual entries and associated data descriptions are kept and included in your new forecast. For example, if you enter a future receipt from a new customer, this data will not be lost. It will be included in your new forecast.

Manual entries can be entered for Future Sales, Other Receipts,  Future Expenses, Debt, and Other Payments input areas.

There are two methods to enter manual data. 

1. First click on the edit button.  A grid will open.
2. Click on New and enter your data.  

Or 

1. Click on the Export to CSV button and export the grid to a CSV file.  
2. Open the file and enter your data (or copy and paste data in from another file). 
3. Save the file and then use the Import button to load your data.

The Analyze Forecast button is used to add multiple cells to review data and analyze your forecast.  Click on the button

For example, if your business’ typical monthly expenses run rate is $25,000, you can review your forecast for this total by clicking on the Analyze Forecast button and clicking on all of the expense related cells for 4 weeks.  The total of the cells displays on the top right of the forecast.  Click on Return to Forecast to turn off Analyze Forecast.

Click on the Chart button to generate a visual view of your forecast. This chart view provides a summary of your forecast by week. It can be printed to a pdf to share with your team.

Advisor plans include the ability to add folders to organize client forecasts. Simply add a folder when you create a new forecast.

This input line is used to capture the use of a business line of credit, weekly. The purpose? So you can plan the use and need for your line of credit with the bank. Also, this input line can be used for businesses that use a credit card as their line of credit.

If your file upload fails, first confirm the file is in the proper format.

Proper Format: Your file should only include one header row and data rows (no totals).  Your file should be saved as a .CSV file. 

There should only be one header row in your file. Column Headers should be in the following order; Invoice No.; Customer/Vendor; Invoice date; Due date; Invoice total. No column totals should be included in your invoice total column.

When you are logged into CashPhlow, download and use the file template example found under the section Resources, Data Source Options.

If your file is in Excel format, open Excel and save the file as a CSV formatted file.