Menu Path: Cash Management Cash Flow Management Analysis
Analyze cash flow.
Use Cash Flow Management Analysis to analyze your incoming and outgoing cash flow for specific time intervals. You can view cash flow data summarized or in detail, and you can graph the cash flow data as a bar or line graph. For information on set up required before performing analysis, see Setting Up Cash Flow Analysis.
To analyze cash flow:
Select the time interval and end date for which you want to display cash flow data.
Select filter options for your cash flow data.
Select whether you want to display a summary or detailed analysis.
Select whether you want to display data as a bar or line graph on the Graph tab.
Click the Trend Sensitivity tab and specify the increasing and decreasing percentages for cash flow categories that you want to highlight and the colors you want to use. You can also set a highlight color to use if cash accounts are below the minimum account balance, or above the maximum account balance.
If you want to change the currency exchange rates used for cash flow data, click the Exchange Rates tab, select the appropriate check boxes in the Use Override Rate column, and enter exchange rates in the Override Rate column.
Click the Show Data button in the ribbon. The Results tab displays data based on your selections in steps 1-6.
Click the Graph tab to display a graphical representation of your data.
Button |
Description |
Exit |
Click this button to close the Cash Flow Management Analysis window. |
Show Data |
Click this button to display data on the Results tab based on your selections on the Select and Trend Sensitivity tabs. |
Save Settings |
Click this button to save settings on the Trend Sensitivity tab. |
Field or Button |
Description |
Select this check box to display cash flow data for all company codes. This check box is selected by default. |
|
Enter a company code for which to display cash flow data, or click the Lookup button to select a company code. This field is only enabled if you clear the All check box to the left of it. |
|
Enter a company name for which to display cash flow data, or click the Lookup button to select a company name. This field is only enabled if you clear the All check box to the left of it. |
|
Select this check box to display cash flow data for all cash accounts. This check box is selected by default. |
|
Enter a cash general ledger account for which to display cash flow data, or click the Lookup button to select a cash general ledger account. This field is only enabled if you clear the All check box to the left of it. |
|
Enter a cash general ledger account description for which to display cash flow data, or click the Lookup button to select a cash general ledger account description. This field is only enabled if you clear the All check box to the left of it. |
|
Select this check box to display cash flow data for all cash flow account groups. This check box is selected by default. |
|
Enter a cash flow account group code for which to display cash flow data, or click the Lookup button to select a cash flow account group code. This field is only enabled if you clear the All check box to the left of it. For information on setting up cash flow account groups, see Cash Flow Account Group Maintenance. |
|
Enter a cash flow account group name for which to display cash flow data, or click the Lookup button to select a cash flow account group name. This field is only enabled if you clear the All check box to the left of it. For information on setting up cash flow account groups, see Cash Flow Account Group Maintenance. |
|
Click the Lookup button to select one of the following time intervals by which to summarize cash flow data:
|
|
Enter the last date for which to display cash flow data, or click the drop-down arrow to select a date. |
|
Select this check box to include sales order transactions in the cash flow analysis. |
|
Select this check box to include sales orders transactions on credit hold in the cash flow analysis. This check box is only enabled if the Include Sales Orders check box is selected. |
|
Select this check box to include remaining sales forecast amounts in the cash flow analysis. Example If $10000 is forecast for a specific month, and $7500 is on open orders, the remaining sales forecast amount is $2500. If this check box is selected, this amount is included in the cash flow analysis. |
|
Select this check box to include inflow cash flow manual adjustments in the cash flow analysis. These are adjustments entered in Cash Flow Manual Adjustment Maintenance or imported in Cash Flow Manual Adjustment Import. |
|
Select this check box to include on-hold transactions in the cash flow analysis. |
|
Select this check box to include purchase order transactions in the cash flow analysis. |
|
Select this check box to include purchase forecast transactions in the cash flow analysis. |
|
Select this check box to include outflow cash flow manual adjustments in the cash flow analysis. These are adjustments entered in Cash Flow Manual Adjustment Maintenance or imported in Cash Flow Manual Adjustment Import. |
|
Click the Lookup button to select the currency for displayed amounts in the cash flow analysis. If you are displaying cash flow data for a single cash account or cash flow account group, this defaults to the currency for the account or cash flow account group. If you are displaying cash flow data for a single cash flow account group for which a default display currency is not set up, or you are not displaying cash flow data for a single account or cash flow account group, this defaults to the currency for the functional ledger. |
|
Select whether to view a summarized or detail view of cash flow data. If you select the Detail radio button, data is displayed for cash flow categories and cash flow subcategories. If you select the Summary radio button, only data for cash flow categories is displayed. |
|
Select whether to display data on the Graph tab as a bar or line graph. |
|
Select whether to display net cash flow. |
|
Select the check box for each cash flow category you want to graph on the Graph tab. For information on setting up cash flow categories, see Cash Flow Category Maintenance. |
Field or Button |
Description |
Enter a color to use to highlight the ending cash amount on the Results tab if the ending balance for an account is below the minimum account balance set up for the account. |
|
Enter a color to use to highlight the ending cash amount on the Results tab if the ending balance for an account is above the maximum account balance set up for the account. |
|
This grid displays cash flow categories and subcategories and allows you to configure how trends are highlighted on the Results tab. You can set data to display in a color for both increasing and decreasing percentages to draw attention to important trends. |
Field or Button |
Description |
This grid displays cash flow information for the time interval selected on the Select tab. The grid includes rows for all cash flow categories, and also the following three rows:
Note Cash flow dates are calculated based on supplier and customer rules set up in Cash Flow Customer Group Maintenance and Cash Flow Supplier Group Maintenance. You can change cash flow dates manually in Cash Flow Detail Inquiry. Double-click data in a row other than the Ending Cash row to display Cash Flow Detail Inquiry, which allows you to view specific cash flow transaction information. Double-click data in the Ending Cash row to display Cash Flow Ending Cash Detail, which allows you to view the ending cash amounts for each cash account. Note If you double-click data for the Beginning Cash category, Cash Flow Category Maintenance appears, and allows you to see the general ledger accounts that are included in the Beginning Cash category. |
Field or Button |
Description |
This graph displays a visual representation of data displayed on the Results tab. |
Field or Button |
Description |
This grid displays current currency exchange rates. If you want to change an exchange rate for cash flow analysis (for example, if you expect an exchange rate to change in the near future), select the check box for the rate in the Use Override Rate column, and then enter the rate in the Override Rate column. If you do not override exchange rates, cash flow data is based on the exchange rate for each transaction. |