Cash Flow Forecast

Interactive Chart

CashFlowTool’s interactive chart gives you the ability to select one or more months directly on the chart and see a total of your net cash plus all of the specific transactions for the selected months. Use the chart to view transactions for one or more months by simply selecting the month on the chart and select multiple months by togging individual months on and off.

See total transaction amount for a specific customer or vendor

Using the search box, search for a specific customer or vendor. Select specific time periods in the graph to see total amount for the customer or vendor for the selected period.

See largest transaction for a specific time period

Unselect Cash out, select specific time periods in the graph and select to sort the table by amount. The largest cash in transactions will be shown first.

Compare total sales and expense for same period last year

Select the first time period in the chart and note the total shown. Select the second time period and compare the total shown.

See impact of adding a new customer or vendor

Select Add Cash In and create a new recurring transaction. New recurring transactions will be added to and the forecast immediately updated.

See impact of losing a customer or vendor

Uncheck one or more transactions to exclude from the cash flow forecast. Compare the before an after amounts by hovering over future months.

See projected cash balance for any time period

Hover over any chart segment to view forecasted transaction, open invoice and cash-in or cash-out amounts.

Cash Flow Calendar

Learn how to use the Cash Flow Calendar feature so you can make informed, educated decisions about today and can also anticipate tomorrow.

What-if Scenarios

Learn how to use the What-if capability of CashFlowtool.com which is powerful feature enabling you to perform a variety of scenarios to understand the impact to your cash flow today and tomorrow.

Invoice & bill payment rules

CashFlowTool uses CashLearn to automatically predict when future invoices will be paid and their amount based on analyzing past transactions. Depending on the nature of your business there maybe times where you want to override the forecasted payment date for an invoice.

Invoice Payment Date Rules are helpful when:

  • You want to always exclude a customer or vendor from the cash flow calendar.
  • You have setup a recurring payment with your bank and know the exact day the invoice will be paid each time.
  • Your customer has a contractual agreement to pay by a specific day.
  • You want to view your cash flow forecast assuming the invoice is paid a fixed number of days after the invoice date or on the invoice due date.
  • The actual payment date is erratic and you want to view you cash flow calendar assuming the customer pays on-time.

Unpaid Invoice Payment Date Rules allows you to specify how unpaid invoices payment dates should be forecasted. You should use these settings when you want to always exclude a customer or vendor from your cash flow forecast or you have specific knowledge about a customer or vendor and want to override the CashLearn’s predictions.

From the Cash Flow Calendar view, two new tabs are available, Customers or Vendors you will be able to:

  1. See lists of known customers or vendors based on looking at the last 12 months of transactions.
  2. Indicates if the customer or vendor should be included in the forecast.
  3. Set unpaid invoice payment forecasting rule
  4. View next recurrence date and amount
Customer / Vendor Checkbox

When checked, the customer or vendor will be included in the cash flow forecast. Uncheck customers or vendors that you want to exclude from the forecast.

Forecast mode

Auto (default)

Manual

Uses CashLearn to automatically predict the payment date

Predicts using rules setting

Setting unpaid invoice payment date rules

Fixed days


Average days to pay

Invoice due date

Uses the fixed days after the invoice date. If selected, you can specify the number of days.

Uses the average number of days to pay based on invoiced date.

Uses the actual invoice due date.

The customer and vendor list are generated from the last 12 months of transactions vs. reading the customer and vendor list from QuickBooks. This ensures that all customers or vendors are listed even if the customer or vendor is no longer listed in QuickBooks.

After you save your changes, the rules are automatically applied to the cash flow calendar and used every time you update your finances.

Manual Recurring Transactions

See how you can quickly add manual recurring transactions for your customers and vendors which will give you a fine degree of control over your future forecast.

About CashFlowTool.com

CashFlowTool is a product developed by Finagraph. We're a technology company that's passionate about helping small business owners, accountants, and lenders deeply understand the financial health of companies. Finagraph’s trusted technology helps power services provided by companies including Moody’s Analytics, Jack Henry & Associates and leading banks. Learn more


(206) 922-4502

15500 SE 30th Pl #101, Bellevue, WA 98007

© Finagraph. All Rights Reserved.