Cash flow

We understand how important it is for you to know the financial position of your company. To help you with this and to monitor the cash coming into and going out of your business, you can use the cash flow statement.

You can also use the cash flow forecast to estimate how much money your business will have, or need, at any point in the future, helping you to plan ahead. The forecast shows your expected cash flow in and cash flow out based on when invoices are due to be paid, credit notes due to be refunded and any recurring income or expenses due in the period you specify.

When running a forecast, you can also add manual adjustments to include values that might not already be accounted for. For example, you may want to apply for a loan, but first want to see how your predicted cash flow will change if you add this value to your accounts. If you add a manual adjustment, this is only used for the cash flow forecast and the values aren’t added to your ledgers.

What the cash flow statement and forecast show

The values calculated for the cash flow statement are from payments and receipts already paid or received. The values on the forecast, are based on when payments and receipts are due to be paid or received.

Opening Balance This is the net value of money in and out less any liability at the date before you’re running the cash flow statement or forecast for.
Cash Flow In This includes the total value of your:

* Customer receipts
* Vendor refunds
* Other income
* Bank transfers and deposits
Cash Flow Out This includes the total value of your:

* Vendor payments
* Customer refunds
* Other expenses
* Bank transfers
Closing Balance The total cash flow in less the total cash flow out.
NET Balance The closing balance for this period.

To produce a cash flow statement

  • 1. Click the Reporting tab.
  • 2. Click Cash Flow Statement.

You can also view the cash flow statement from Summary > Cash Flow Statement > Cash Flow Statement Report.

  • 3. Enter the dates you want to view the cash flow statement from and to.
  • 4. Click the Bank account finder button to select the bank accounts you want to include in the statement.

The balance, cash flow in, and cash flow out appear on the chart. You can choose which of these appear on the chart by clicking the relevant option from the bottom of the chart. To zoom in on a particular date range, highlight the relevant period on the chart.

  • 5. Open the Export drop-down menu to save or print the report.
  • 6. Choose one of the following:
  • CSV – Depending on your browser, the file automatically downloads to your Downloads folder or you’re prompted to save the file > browse to where you want to save the file > Save.
  • PDF – The PDF opens in a new window or tab. Open your browser File menu then choose to print or save the report.
  • 7. To view a more detailed cash flow statement > View Detailed Breakdown.

The detailed report shows the individual transactions that make up the values on the report. You can also print or save this report by repeating the step above.

  • 8. To return to the Cash Flow Statement Report, click back on your browser menu.

To produce a cash flow forecast

  • 1. Click the Reporting tab.
  • 2. Click Cash Flow Forecast.

You can also view the cash flow forecast from Summary > Cash Flow Forecast > Cash Flow Forecast Report.

  • 3. Enter the dates you want to view the cash flow forecast from and to.
  • 4. Click the Bank account finder button to select the bank accounts you want to include in the statement.

The balance, cash flow in, and cash flow out appear on the chart. You can choose which of these appear on the chart by clicking the relevant option. To zoom in on a particular date range, highlight the relevant period on the chart.

  • 5. If required, click Manual Adjustments for the relevant option, enter the information, and click Save.

Adjustments are only used for the purpose of the forecast, they don’t update your ledgers. Any adjustments entered prior to the from date are included in your opening balance.

  • 6. Open the Export drop-down menu to save or print the report.
  • 7. Choose one of the following:
  • CSV – Depending on your browser, the file automatically downloads to your Downloads folder or you’re prompted to save the file > browse to where you want to save the file > Save.
  • PDF – The PDF opens in a new window or tab. Open your browser File menu and then choose to print or save the report.
  • 8. To view a more detailed cash flow statement, open the Detailed Breakdown menu and click View Detailed Breakdown.

The detailed report shows the individual transactions that make up the values on the report. If required, you can print or save this report by repeating the step above. To return to the report, click back from your browser menu bar.

  • 9. To return to the Cash Flow Forecast Report, click back on your browser menu.
  • 10. To view outstanding transactions prior to the date you’re running the cash flow forecast for, open the Detailed Breakdown menu and click View Prior Transactions.

This report shows outstanding invoices that need to be paid or credit notes that need to be refunded. You can print or save this report by repeating step 5.

  • 11. To return to the Cash Flow Forecast Report, click back on your browser menu.