Using the Cash Flow Forecast Report in QuickBooks

 In Add-ons / Apps for QuickBooks, Post, Profit Improvement Tips, QuickBooks Desktop, QuickBooks Enterprise, QuickBooks for Mfg + Distributors, QuickBooks for Service Businesses, QuickBooks Reports, QuickBooks Tips and Training

Looking for a way to see a cash flow forecast in QuickBooks?

If so, the Pro, Premier, and Enterprise versions offer you a Cash Flow Forecast report option. This option is not yet available in QBO.

THE CASH FLOW FORECAST REPORT IN QUICKBOOKS

You can access this report by clicking Reports > Company and Financial > Cash Flow Forecast.

Here’s an example of what you will see:

Cash Flow Forecast Report in QuickBooks

The Cash Flow Forecast Report offers you the following customization options:

  1. Date range – choose from: Next 4 weeks, Next month, Next Fiscal Qtr, Next Fiscal Year or Custom date range
  2. Period visibility – select a period, ranging from week to year
  3. Delay receipts – the ability to see how your receipts look if they are slow in arriving

You can double click on any of the entries within the report to see a more detailed breakdown.

As with most QuickBooks reports, you can export this to Excel for further analysis too.

Note that this report takes the data directly out of your AR, AP and bank accounts in QuickBooks. It does not provide you the ability to do any “what if” type of planning other than the global “delay receipts” option.

NEED BETTER CASH FLOW FORECASTING FOR QUICKBOOKS?

While the QuickBooks cash flow forecast report may be satisfactory for some, others will want the ability to a lot more when it comes to “what if” and Excel analyses.

If your business needs more than QuickBooks provides, take a closer look at the CashFlowTool for QuickBooks.

CashFlowTool works with all versions of QuickBooks (Pro, Premier, Enterprise and QBO). It provides you with a number of features not found in QuickBooks, including: the cash flow calendar, cash flow cards (key metrics on your cash flow), and a robust set of “what if” scenarios and full exporting to Excel.

See it in action here:

You can get a free trial of CashFlowTool right now if you like.

RELATED INFORMATION

Recent Posts

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Contact Scott

We're not around right now. But you can send us an email and we'll get back to you, asap.