Cash Flow Worksheet window—Worksheet view

The Cash Flow Worksheet window allows you to estimate your short-term cash needs for a specified period, by using your company file data to create a forecast for a specified bank or credit card account.

The Worksheet view of the Cash Flow Worksheet window lists transactions that are overdue or pending for this account. This view allows you to view the transactions that will affect the account during the specified period. You can then edit the information that appears.

For example, if a default transaction indicates you’ll be spending $1,000 for June’s commission payments, and you know you’ll spend only $500, you can change the amount. If no commission payment is needed for June, you can delete the amount.

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

Field Descriptions

Bank Account

Select the bank or credit card account to review.

Days to Look Ahead

Enter the number of days you want the Cash Flow Worksheet to forecast your cash needs for this account.

For example, enter the days of a credit term, such as 30, 60 or 90 days, then press Tab to display future transactions that are likely to affect this account.

tip :  

If you accept the default number of Days to Look Ahead without making an entry in the field and no transactions appear, press Tab to refresh the contents of the window.

Description column

This column displays a list of the expected or overdue transactions that will affect the account’s balance. You can make changes in this column if you want.

Due Date column

This column displays the date each transaction’s due date. You can make changes in this column, if you want.

Money In column

This column displays the amounts you expect to receive for each deposit transaction in the list. You can make changes in this column, if you want.

Money Out column

This column displays the amounts you expect to pay for each withdrawal transaction in the list. You can make changes in this column, if you want.

Analyze Cash Needs

Click to display the Analysis view of the Cash Flow Worksheet window.

Cancel

Click close the window without saving your changes.

Tips for this window

Related Topics

■	Analyzing your cash flow

■	Financial control