Cash Forecasting - Cash Management

 

Cash forecasting is a planning tool that helps you anticipate the cash flow in and out of your business, allowing you to project your cash needs and evaluate your company's liquidity position.

In Oracle R12 you can forecast your cash position on the basis of transactions from subledgers. These transactions can be PO, PR, AP Invoice, AP Payment (Future Dated), AR Invoice, AR Receipt (Future Dated), and many more.

Process for Cash Forecasting in Oracle.

Step 1: Go to Cash Management Responsibility and Click on Cash Forecasting.

Step 2: Go to Forecast Template and click on Create Template

Enter all the details and click on the next

Here add the Source Type as per business requirements

Now as per the above steps add all the other sources as per business requirements.

Click on Next.

Now add the buckets which will tell you the inflow and outflow of cash as per the sources added above.

Click on Finish and then re-query your template.

Step 3: Click on Run Forecast as shown in the above image.

Now add the mandatory details and click on Submit.

 

After submitting, system will trigger 3 concurrent programs.

After completion of these 3 programs click on view forecast.

Now click on the Forecast Name Hyperlink to see the Cash Forecasting.

Here you can see the details of the Inflow and  Outflow of Cash as per sources selected in the forecast template.

#oracler12 #oracleebs #cashmanagement #cashforecasting #inflow #outflow #forecast #forecastcolumns