Cash Flow Worksheet window

Worksheet view



Bank Account

Select the bank account whose future cash needs you want to review.

The accounts in this list are accounts that have a bank or credit card account type.

Days to Look Ahead

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

We recommend you enter a number of days that falls within your normal credit terms, such as 30, 60 or 90, since it's difficult for a business to accurately predict cash flow activity beyond those time frames.

After you enter a number in this field, press TAB to display future transactions that are likely to affect this account.

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 wish.

Due Date column

This column displays the date each transaction is due -- or was due, if the date has already occurred. You can make changes in this column, if you wish.

Money In column

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

Money Out column

This column displays the amounts you expect to pay for each "cash out" transaction in the list. You can make changes in this column, if you wish.

Analyze Cash Needs button

Click this button to display the Analysis view, where the information in the Worksheet view is used to calculate the balance of the account throughout the specified time period.

Cancel button

Click this button to clear the entries you've made in this window and close the window.