General

Select the appropriate data to include in the cash flow calculation.

Direct

View entered amounts and the actual cash flow calculation totals.

Calculate

Calculate the cash flow with the selected data.

Transactions

Open the transactions form.

Forecast

Open a forecast form.

Export to Microsoft Office Excel

Export the calculated cash flow data to an Excel PivotTable.

Included project types

Select the check boxes of the project types you want to include in the calculation of cash flow.

Included transaction Types

Select the check boxes of the transaction types you want to include in the calculation of cash flow.

Project date

From date/ To date

Enter the start date and the end date in which transactions were posted to a project.

• From date- Enter a start date if you want to delimit the cash flow calculation.

• To date- Enter an end date if you want to delimit the cash flow calculation.

Payment date

From date/ To date

Enter the time frame in which payments were made.

• From date- Enter a start date if you want to delimit the cash flow calculation.

• To date- Enter an end date if you want to delimit the cash flow calculation.

Actual vs. Budget

Select the type of cash flow you want to display in the calculation.

• Actual- Display the actual cash flow amount.

• Budget- Display the budgeted cash flow amount.

• Deviation- Display the difference of the actual and budgeted cash flow amount.

• Sum- Display the actual cash flow from the From dateto the Break dateand the budget cash flow from the Break dateto the To date.

Include paid payment

Select this check box to include actual payments you have already received in the calculation of cash flow.

Include expected payment

Select this check box to include actual payments you expect to receive in the calculation of cash flow.

Expected sales payment date

Add days to due payment

Enter the number of days to add to the sales payment when the expected payment date has already been posted, but no payment has been received.

Expected sales payment date

Minimum payment date

Enter the expected payment date. You can change the expected payment date for sales payments when the original date has passed and you have not received the payment.

Expected cost payment date

Add days to due payment

Enter the number of days to add to the cost payment when the expected payment date has already been posted, but no payment has been received.

Expected cost payment date

Minimum payment date

Enter what the expected payment date should be overwritten to for cost payments where the expected payment date has already been posted, but no payment has been received.

Cash Inflows

View the cash flow of the invoiced revenue.

Cash Outflows

View the cash flow of the consumed cost of the calculated data.

Net Cash Flows

View the net amount of cash inflow and outflow.

Cash inflows received from sale of goods

View the cash flow of the invoiced revenue.

Invoiced revenue

View the cash inflow of invoiced revenue for Hour, Expense, Item, and Fee.

Invoiced - on account

View the cash inflow of invoice revenue for on-account transactions.

Close

View the cash outflow of the consumed hour cost.

Cash paid for - expense

View the cash outflow of the consumed expense cost.

Cash paid for - item

View the cash outflow of the consumed item cost.