Create cash flow reports

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 are 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. Go to Reporting.
  2. Click Cash Flow Statement.
  3. Enter the range of dates for which you want to view the cash flow statement.
  4. Use the Bank Accounts menu to select the bank accounts you want to include in the statement.
  5. Click Calculate.
  6. Use the Export menu to save or print the report to a PDF or CSV file.
  7. To view a more detailed cash flow statement, click the Detailed button.

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

  8. To return to the Cash Flow Statement Report, click Back in your browser.

To produce a cash flow forecast

  1. Go to Reporting.
  2. Click Cash Flow Forecast.
  3. Enter the range of dates for which you want to view the cash flow forecast .
  4. Use the Bank Accounts menu to select the bank accounts you want to include in the statement.
  5. Click Calculate.
  6. If required, click the Manual Adjustments icon for the relevant option, enter the information, and click Save.

    Note: Adjustments are only used for the purpose of the forecast and do not affect your ledgers. Any adjustments entered prior to the From date are included in your opening balance.

  7. Use the Export menu to save or print the report to a PDF or CSV file.
  8. To view a more detailed cash flow statement, on the Detailed Breakdown menu, click Detailed.

    The detailed report shows the individual transactions that make up the values on the report. If required, you can print or save this report.

  9. To return to the Cash Flow Forecast Report, click Back in your browser.
  10. To view outstanding transactions prior to the date for which you are running the cash flow forecast, on the Detailed Breakdown menu, 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.

  11. To return to the Cash Flow Forecast report, click Back in your browser.