Skip to main content
All CollectionsForecastingForecasting FAQs
Unpaid invoices and bills in a forecast
Unpaid invoices and bills in a forecast

How to deal with your unpaid invoices and bills within a 3 year cash flow with due invoices forecast.

Updated over a week ago

When you create a 3 year cash flow with due invoices forecast, you can see all unpaid invoices and bill payments in the Invoices tab. These pull through directly from your data source (Sage Accounting, Xero or QuickBooks Online).

All overdue invoices are highlighted in green and all overdue bills in red.

On this page, you can use the following options to customise which invoice will affect the forecast.


Period

Under Cash increase/decrease from due invoices and bills, you can amend the period you want to look at.

For example, do you want to see overdue invoices and bills as of today, or do you want to see all invoices and bills that are due this quarter?


Exclude/Include

If you don't want to include an invoice or bill in your forecast, click Exclude.

After a few moments, this updates the cash flow figures.

To undo this, click Include.


Change payment date

If you want to edit the date of payment for an invoice or bill, click the calendar icon next to it.

You can select the new payment date and even split the payments if it's going to be paid in instalments instead. Click the ➕ to add an additional payment period.

Any changes you make will update your cash flow moving forwards.


Bulk update

You can click Bulk update to change multiple invoices and bills at the same time. This makes it easier to:

  • Exclude multiple invoices/bills from cashflow

  • Include selected multiple invoices/bills from cashflow

  • Change payment dates for multiple invoices/bills

You have the following options:

  • Custom selection - Tick the boxes to manually select which invoices and bills you want to bulk update



  • Period filter - Use the Cash increase/decrease from due invoices and bills filter to automatically select all invoices/bills listed depending on the option selected.




Once you have made the changes you can see the impact in your forecast in the Cash flow statement tab or under the Cash flow view.

Did this answer your question?