Open topic with navigation

Short Term Cash Projection

The Short Term Cash Projection enquiry helps you to forecast the amount of cash you will have in your bank accounts on a particular day after your outstanding transactions have been paid.

You specify a date range and the forecast bank balance for the end of that period is displayed in the Summary section. A list of the outstanding transactions within the specified date range is displayed in the Transactions section.

To create accurate forecasts, you can choose which bank accounts and transactions are included in the forecast totals. You can also add transactions that you are expecting but which have not yet been entered into Sage 200.

To use the short term cash projection

Open: Cash Book> Cash Book Enquiries > Short Term Cash Projection.

1. Choose the required Date Range from the drop-down list.

   You can use the pre-defined date ranges or select Custom to define your own date range.

2. Click Refresh. This updates the displayed transactions and Summary totals.

   The forecast totals are displayed in the Summary section and all outstanding transactions within this date range are displayed in the Transactions section. Overdue direct debits and standing orders are highlighted in yellow.

3. To choose the bank accounts that you want to include in your forecast, select the Include check box next to the bank account(s) in the Accounts section.

   The displayed Balance for each bank account is the total of all transactions that have been processed for that bank account.

4. Choose the transactions that you want to include in your forecast. All transactions are included by default, apart from those transactions that have a Query flag.

   You can filter the list of transactions using the Type drop-down list.

   See which transactions are displayed

   SI OI	Sales Invoices Opening Balance Invoices	When the Due Date of the invoice falls in the Date Range specified
   SC OC	Sales Credit Notes Opening Balance Credit Notes	When the transaction date of the credit note falls in the Date Range specified.
   PI OI	Purchase Invoices Opening Balance Invoices	When the Due Date of the invoice falls in the Date Range specified.
   PC OC	Purchase Credit Notes Opening Balance Credit Notes	When the transaction date of the credit note falls in the Date Range specified.
   BRSO BRDD BPSO BPDD	Standing orders and direct debits	When the direct debit or standing order is due to be processed in the Date Range specified. Outstanding direct debits or standing orders are always displayed regardless of the date range specified. These are highlighted yellow to indicate that they are overdue.

   1. If you are not expecting to process a payment or receipt within the time period specified, you can clear the Include check box to remove that transaction's value from the projected total.

   2. If you are expecting to receive a payment or receipt that has not yet been entered into Sage 200, you can include this value in your forecast by entering a temporary manual transaction.

      To enter a manual transaction:

      1. Click Add or click in the grid to add a new line.
      2. Enter the details of the expected transaction.

      3. Select or clear the Include checkbox as required.

      4. To remove a manual transaction click Delete.
   3. To remove all manual changes, such as manual transactions and changes to forecast dates, click Reset Manual Changes.

   All changes made to the cash projection screen are saved when they are entered. Therefore, when you change the Date Range and Refresh the list, the transactions that are displayed will retain their previous status. For example, if you have cleared the Include check box, the checkbox will remain cleared after the list is refreshed.

   Note: The Balance for Day is not shown when you have filtered the transactions that are displayed in the list. The Balance for Day is the total of all selected transactions for a single day. If you have entered manual transactions, you must refresh the list to update the Balance for Day.

5. The Summary section displays the forecast totals for the selected bank accounts.

   See how the summary totals are calculated

   Book Balance for Bank Account(s)	This is the total of all transactions that have been processed for all the bank accounts that you have chosen to Include.
   Regular Payments.	This is the total of the direct debit and standing order payments, that you have chosen to Include. Outstanding direct debits or standing orders are always displayed regardless of the date range specified. These are highlighted yellow to indicate that they are overdue.
   Forecast Payments.	This is the total of the outstanding purchase invoices and sales credit notes that you have chosen to Include.
   Regular Receipts.	This is the total of the direct debit and standing order receipts that you have chosen to Include. Outstanding direct debits or standing orders are always displayed regardless of the date range specified. These are highlighted yellow to indicate that they are overdue.
   Forecast Receipts.	This is the total of the outstanding sales invoices and purchase credit notes that you have chosen to Include.
   Forecast Book Balance for the Period.	This is the total Book Balance for the bank accounts you have chosen to Include, plus or minus the total payments and receipts that you have chosen to Include, Note: This total is highlighted in yellow when the bank account selection has changed and the transaction list has not been refreshed.

You can print the Cash Projection report or export the Cash Projection to an Excel spreadsheet.

Note: If Excel is not installed on your PC, then you cannot use the Send to Excel button.

Go to top