TASBooks - Cash flow forecasting

A cash flow forecast is an estimation of how much cash the business will have, or need at any point during a chosen period. It acts as a guide, allowing you to plan ahead and prepare for the future.

How a cash flow forecast calculates?

To help you determine when an invoice will be paid, you can use the default payment days entry on your customer and supplier records. Using this information, you can forecast the money coming into, and out of your business for any given period and the difference between the two.

If you want to, you can also include the money in your bank accounts, repeating transactions, quotations or pro formas in the forecast to give you an overall picture of the cash available to your business.

When running a cash flow forecast, you might also want to include additional information which isn't currently held in TASBooks. For example, because you are expecting a bill to arrive in a specific period, or a bank loan to be approved. Even though you may not be ready to enter the actual transactions into TASBooks, you can include the expected values in your projected forecast, to give you a realistic picture of the cash available to your business for the specified period.

The following steps contain everything you need to run a cashflow forcast and enter any adjustments in TASBooks.

To run a cash flow forecast

  1. From the main toolbar, click the Cash Flow icon.

  2. Enter the start date and end date for the forecast.
  3. To change or view the type of entries included in the forecast > Options.

    4. You can include or exclude the following options in the forecast:

    • Pro formas.
    • Quotations.
    • Unposted invoices.
    • Repeating transactions.
    • Overdue invoices.
    • Unallocated cash.
    • Overdue manual adjustments.
    • Outstanding purchase orders.

  4. Select or clear the relevant options > OK.
  5. To generate a cash flow forecast > Calculate.
  6. To view a breakdown of the transactions in your forecast > Breakdown tab > check the following information is correct:
    Total Outstanding Total remaining balance of all invoices that have been raised for this supplier or customer.
    Overdue Total remaining balance of all invoices that were due to be paid before the selected period.
    Due Total remaining balance of all invoices and other transactions that are due to be paid during the selected period.
    Due to Date Grand total of the amount overdue and amount due for the selected period.
  7. To see how the values for each customer or supplier are made up > double-click the relevant entry.
  8. To view, enter or edit cash flow adjustments > Adjustments tab.

    9. Tip: Adjustments only affect the cash flow forecast and will not post any transactions in your TASBooks ledgers.

  9. To enter a new adjustment > Add > complete the adjustment details > Save.
  10. To edit an existing adjustment > select the relevant entry > Edit > enter the amended details > Save.
  11. To delete an adjustment > select the relevant entry > Delete.
  12. To close the Cash Flow Forecast window > click the X button at the top right-hand side of the window.

How a cash flow forecast calculates?

To help you determine when an invoice will be paid, you can use the default payment days entry on your customer and supplier records. Using this information, you can forecast the money coming into, and out of your business for any given period and the difference between the two.

If you want to, you can also include the money in your bank accounts, repeating transactions, quotations or pro formas in the forecast to give you an overall picture of the cash available to your business.

When running a cash flow forecast, you might also want to include additional information which isn't currently held in TASBooks. For example, because you are expecting a bill to arrive in a specific period, or a bank loan to be approved. Even though you may not be ready to enter the actual transactions into TASBooks, you can include the expected values in your projected forecast, to give you a realistic picture of the cash available to your business for the specified period.

To run a cash flow forecast

  1. From the main toolbar, click the Cash Flow icon.
  2. Enter the start date and end date for the forecast.
  3. To change or view the type of entries included in the forecast > Options.

    4. You can include or exclude the following options in the forecast:

    • Pro formas.
    • Quotations.
    • Unposted invoices.
    • Repeating transactions.
    • Overdue invoices.
    • Unallocated cash.
    • Overdue manual adjustments.
    • Outstanding purchase orders.

  4. Select or clear the relevant options > OK.
  5. To generate a cash flow forecast > Calculate.
  6. To view a breakdown of the transactions in your forecast > Breakdown tab > check the following information is correct:
    Total Outstanding Total remaining balance of all invoices that have been raised for this supplier or customer.
    Overdue Total remaining balance of all invoices that were due to be paid before the selected period.
    Due Total remaining balance of all invoices and other transactions that are due to be paid during the selected period.
    Due to Date Grand total of the amount overdue and amount due for the selected period.
  7. To see how the values for each customer or supplier are made up > double-click the relevant entry.
  8. To view, enter or edit cash flow adjustments > Adjustments tab.

    9. Tip: Adjustments only affect the cash flow forecast and will not post any transactions in your TASBooks ledgers.

  9. To enter a new adjustment > Add > complete the adjustment details > Save.
  10. To edit an existing adjustment > select the relevant entry > Edit > enter the amended details > Save.
  11. To delete an adjustment > select the relevant entry > Delete.
  12. To close the Cash Flow Forecast window > click the X button at the top right-hand side of the window.