Cash Forecasts

Cash Forecasts calculate cash flow based on both generated data and manual entries. The generated data is based on:

• Open AR Invoices
• Payment Plan Steps
• Open AP Vouchers

You can calculate manual entries based on a selected frequency called Cash Forecast Entries. Forecast Summary is calculated based on the totals of cash in and out and the initial balance.

Create a Cash Forecast Template

1. Click the Cash Forecasts link from the Main Menu. The Cash Forecasts screen opens.
2. Click the Add button. The Add Cash Forecast screen opens.
3. Enter the necessary information:
   • Status - You can only generate cash forecasts for templates set to Active.
   • Description - Name for the cash forecast template. 
   • Beg Balance - Beginning balance for the cash or bank account.
   • Start Date - Start date for the forecast calculations.
   • End Date - End date for the forecast calculations.
   • Open Invoices - If checked, open accounts receivable invoices are included by due date.
   • Payment Plans - If checked, payment plan steps are included by due date.
   • Vouchers - If checked, accounts payable vouchers are included by due date.
4. Select the Cash Forecast Entries tab. This allows you to include other amounts in the forecast results, such as payroll paid out or gratuities received, during the date range.
5. Click the Add button. The Add Cash Forecast Entries screen opens.
6. Enter the necessary information:
   • Description - Name for the cash forecast entry.
   • Start Date - Date to begin the entry calculation.
   • Amount - Amount for the cash forecast entry. Outgoing cash is a negative value and incoming cash is a positive value.
   • Frequency - How often this cash forecast entry occurs.
   • Currency - Currency for the cash forecast entry.
7. Click OK.
8. Repeat steps 5 - 7 for any additional cash forecast entries.
9. Click OK on the Edit Cash Forecasts screen.

Generate the Cash Forecast 

To generate the cash forecast:

1. Click the Cash Forecasts link from the Main Menu. The Cash Forecasts screen opens.
2. Select the cash forecast to generate.
3. Right-click and select Generate.

To view the results:

1. Click the Cash Forecasts link from the Main Menu. The Cash Forecasts screen opens.
2. Select the cash forecast you generated in step 3 above.
3. Right-click and select Edit. The Edit Cash Forecasts screen opens.
4. Select the Cash Forecast History tab.
5. Select the cash forecast.
6. Right-click and select Edit. The Edit Cash Forecast History screen opens. 

The results are summarized in the Forecast Summary section. The results are summarized by Incoming Cash and Outgoing Cash. The Total Net Cash calculates the total of all the results and the Beginning Balance.

The Cash Forecast Results tab displays the details for the cash forecast. You can show additional columns on this tab for additional information about the source and source transaction, show more columns.