1. Go to Reports and select All reports.
2. Select Cash Flow Forecast.
3. Use the From* and To* fields to enter your date range.
4. Choose your bank account by selecting .
5. Select Calculate.
   
   TIP:

   Select Detailed Breakdown and then Detailed to view a transactional breakdown. Cash Flow In and Cash Flow Out are split and show transactions dates, amounts, references and contacts.

6. Select Export to download the report as a PDF or CSV file.

The forecast graph displays the bank accounts predicted Balance, Cash Flow In and Cash Flow Out. In the screenshot below, see where you can select and deselect one of these to change the graph view.

The graph is designed to show potential trends throughout the period. Therefore, the specific date of a transaction won't always line up with the graph. You can use a shorter period to see more accurate transaction dates.

Graph breakdown

The forecast will pick up any recurring transaction due plus any adjustments you make to it.

Opening Balance	This is the net value of money in and out less any liability at the date before you’re running the forecast for.
Cash Flow In and Out	This includes the total value of your: Any expected customer receipt from the recurring sales invoices you've set up previously from the Sales tab Any recurring receipts or payments you've set up previously in the Banking tab Any manual adjustments you add directly to this statement   NOTE: The forecast doesn't pick up amounts from quotes or draft invoices.
Closing Balance	The total cash flow in less the total cash flow out.
Liability to offset	The total liability includes all your current tax liabilities from your ledger activity, whatever the dates you selected. This calculation only works for the standard vat scheme.
Net Balance	This will take the figure from the closing balance less any VAT liability for this period. Or If you can reclaim VAT for this period, add it to the closing balance.

Add manual predictions directly from the forecast statement page. This can be for any extra expenses or receipts you consider but you don't want to post yet. You can add and remove these adjustments as you need.

Predicted income and expenses

1. From the Cash flow in or Cash Flow Out section, select the pencil icon beside Manual Adjustments.
2. A window will display showing any existing adjustment already made.
3. To add a new predicted receipt or expense, enter a Date, Amount and Details.
4. To remove a prediction, select the bin icon.
5. Repeat for each new prediction and select Save.

Predicted payroll costs

You can also add any payroll costs you predict for a future period.

1. From the Cash Flow Out section, select the pencil icon beside the Payroll costs for forecast period option.
2. A window will pop up showing any existing adjustment already made.
3. To add a new predicted receipt or expense, enter a Date, Amount and Details.
4. To remove a prediction, select the bin icon.
5. Repeat for each new prediction and click Save.

Have you tried Futrli, our forecasting solution? 

Futrli integrates fully with Sage Accounting to produce automatic predictions based on your historical data and due invoices.

You can create your own detailed forecasts from templates or custom formulas. Also, Futrli allows you to combine different forecasts and budgets and compare as many different scenarios as you need.

Sign up and discover Futrli for free. If you need more information, leave your details and we'll contact you.

You can upgrade your Sage subscription to Sage Accounting Plus to create financial budgets.

This version allows you to build a detailed budget with monthly breakdowns for each ledger category. Once created, you can then compare your actual Profit and Loss against your budget.