Window Overview
Cash Flow Worksheet window

Worksheet view

Window Overview | To use this window | Fields in this window | To find this window


The Cash Flow Worksheet window allows you to estimate your short-term cash needs for a specified period of time. The window uses information you've entered throughout MYOB Accounting Plus to create a forecast for any specified asset account with bank privileges or any specified liability account with credit card privileges.

The information used to forecast cash needs includes:

The information used to forecast cash needs does not include:

The Cash Flow Worksheet window uses two views to display cash flow information:

Worksheet view
Analysis view

The Worksheet view of the Cash Flow Worksheet window provides a list of a number of transactions that are overdue or expected to occur for this account. This view allows you to verify and enter all the transactions that will affect the account during the specified number of days.

The transactions that appear as default entries in this list include:

  • All recurring transactions that are expected to occur for this account within the specified range of days. The frequency that was established in the Save Recurring Template window for each transaction is used to determine the date when the transaction should occur.

  • All recurring transactions that were supposed to occur before the current date. These transactions will appear only if the account was designated a linked bank account in either the Sales Ledger Linked Accounts window or the Purchase Ledger Linked Accounts window, and if the transactions have already been recorded.

    Remember: Recurring Sales and Purchases will only appear if they have been recorded. Recurring Chequebook, Payroll and General Ledger transactions will appear even if they have not yet been recorded.

You can change any of the information that appears in the Worksheet view to better estimate your cash flow needs. For example, if one of the default transactions indicates you'll be spending £1,000 for June's commission payments, but you know you'll spend only £500, you can change that amount. If no commission payment were needed for June, you could delete the amount entirely.

You can also add transactions to the Worksheet view. To do this, scroll to the bottom of the list and add transaction information in the blank line. When you're finished, press TAB to create a new blank line, where you can enter additional transaction information.

Changes, deletions and additions you make in the Worksheet view are used for the purposes of the Cash Flow Worksheet window only. The changes you make here won't be reflected anywhere else in the Accounting Plus system.