Product overview

Help and User Guide maintained for Cash Flow v18.0.0.0 and upwards


Sicon Cash Flow is designed specifically as an enhancement for Sage 200. Fully integrated with the Sage 200 financial ledgers and order processing modules, this is a simple module to setup and use.

You can design a structure to pull cash movements from standard Sage modules and Sicon add on modules. The cash flow structure pulls information from bank accounts, sales ledger, purchase ledger, sales and purchase orders, nominal budgets and manual ad-hoc income and expenditure entries, VAT due/to claim, Contracts from Sicon Contracts and Applications and Retentions from Sicon Construction.

Use the drag and drop feature to adjust the transactions in the cash flow interface to reflect expected cash impact without amending the due dates and promised dates manually.


1. Overview

The Sicon Cash Flow has been created to provide a real time summary of the Sage 200 data in a drag and drop spreadsheet style view of the selected company’s data. Incorporating every transaction type from Sage 200 that is likely to affect the cash position to create a day by day summary balance.

With the ability to view and add memos to all transaction types, amend forecast dates that don’t affect the original document due dates, drill into invoices and orders to see more information, attached documents etc. this module provides a very functional and productive interface for the user.

Using a new nominal cash budget that defines the projected cash impact of any type of revenue or cost nominal we are able to project the likely movement in cash (rather than a spread of costs or revenue that may usually be seen on a nominal budget) in both the short term as well as over several years.


2. Installation

The Sicon Cash Flow installs into the Sage 200 system as an Add-On product.

Step 1: Download the Cash Flow module and the latest Sicon Common Components (Sicon API) from the Sicon business partner portal.  NB: You will need a Sicon Business Partner login to be able to do this. If you are a Sage 200 end user please speak to your Sage Business Partner).
Step 2: Using the Sage 200 System Administration module select the Add-Ons menu.

Sicon Cash Flow Help and User Guide - - Sage 200 SA

If there are no add-ons installed right click in the right hand pane and select Add New Add-On option. Choose the Sicon common components first and once completed repeat the process and choose Sicon Cash Flow.

If there are Add-ons already installed then Common Components should be removed and re-installed, but Cash Flow should be upgraded as shown below.

Once both of these Add-ons are successfully installed select the Companies menu option on the left. In the right hand pane all the configured Sage 200 companies will be displayed. You can update a single company but we recommend that you ‘Update All Companies’ using the right click option as shown below to create the new fields and structures into each.

This process will create new fields and tables into each company, it will not change any Sage 200 data.

Once the companies have been updated you will need to add the new features to a role that is linked to the user that will access the new Cash Flow module.

From within the System Administration choose roles, select the role that you wish to add Cash Flow to and right click. Choose the features option and scroll down to the Cash Flow section. Choose the features that the user will require by ticking the boxes. If the user is currently logged in they will need to log out of Sage 200 and back in to see the new menu options.


3. Settings

Once installed you will need to setup your Cash Flow settings.

Choose the settings menu option from within the Cash Flow Forecast menu section and select the settings tab once the screen is open.

Your Sage 200 DL number will be displayed on the screen. You will need this in order to register this module with Sicon and receive an enable string to allow you to continue to use it. The product will run for 30 days from installation without an enable string.

Sicon Cash Flow Help and User Guide - Cash Flow Settings

 


3.1. Settings: detailed explanations

Number Format: This is the way in which you wish to display the information in the cash flow forecast itself. ‘£{0:n2}’ displays numbers over one thousand with comma’s and two decimal places. Other options are available on the Microsoft Web Site for standard numeric format strings https://msdn.microsoft.com/en-us/library/dwhawy9k(v=vs.110).aspx

Default View: This controls the default view in the cash flow between Month, Week and Day. This can be amended within the cash flow screen once open.

Width Of Value Columns: Sets the default width for the columns within cash flow.

Default Level of Detail: Select between Summary, Account, Document and Item. The default level of detail can be amended within the cash flow but the more detail that is shown the slower the cash flow will run. If you are reviewing high level weekly or monthly trends then the lowest level of detail will provide enough information. However if you are managing detailed daily cash projections from Sales Order and Purchase Order lines with the ability to amend any line date, then you will need this at the highest level.

Default duration: When the cash flow forecast opens, this will set the default number of days/weeks/months ahead to display. This can be amended within the cash flow screen once open.

Week View Column Heading: Allows the selection of Week Number, Week Start Date or Week End Date. This controls the week column headings in the cash flow, if a week view is being used.

Enable Forecast From Date: This setting is really useful for demonstration or training purposes. Because the Cash Flow runs in real time any training data will be out of date very quickly. By setting a date in this field Sicon Cash Flow will assume that this is todays date and display the cash flow accordingly. It should never be set in a live system.

Automatic Refresh: When unticked the cash flow will not automatically update when changes are made.

Enable Currency Filtering: Allows the cash flow to be filtered by a specific currency, so that the cash flow can be run for a specific currency.

Prompt To Adjust Cash Budgets After Processing Invoices/Payments: With this setting ticked when a purchase invoice/credit or nominal payment/receipt is put to a nominal with a cash budget set, the system will prompt whether the budget should be amended and the cash flow rebuilt.

Sicon Cash Flow Help and User Guide - Default Forecast

When a purchase invoice is put on to a nominal code with a budget assigned, the system will pop up a window so that the cash flow forecast can be amended.

The cash budget is then amended.

Sicon Cash Flow Help and User Guide - Cash Flow Budget Adjustments

Use Customer Average Time To Pay for Expected Forecast Dates: This setting will use the customer details to calculate the average time taken to pay work out the forecast date as opposed to the payment terms set against the account.

Automatically update Purchase Invoice due dates when Forecast Date Changed: In addition to the purchase invoice due date, the Cash Flow stores a ‘Forecast’ date that allows the invoice to be moved in the cash flow to view its impact. This option can be enabled to change the due date of the invoice at the same time as it is moved in the cash flow. You may do this so that it does not need to be amended manually should you wish to move the payment of this invoice to a future month and exclude it from the current month suggested payment routine.

Bank Clearing Days For Supplier Payments: This setting will add on a numbers of days to the expected cash flow based on the number of clearing days. For example, with the bank clearing days set as 10, a PL payment put on with a date of 10/10/2018, will appear on the cash flow on the 20/10/2018.

Sicon Cash Flow Help and User Guide - Supplier Transaction Enquiry

Automatically Clear the Forecast Date When Invoice Due Date Changed: When amending a SL/PL invoice due date, with a forecast date populated, the system will clear the forecast date out.

Sicon Cash Flow Help and User Guide - Amend Supplier Transaction Details

Number of Days to Add After Month is Added to The Tax Period End Date: Enter the number of days to add to when then VAT liability needs to paid/received. This is normally set as 7 per HMRC guidelines.

Stored Procedure Timeout: Enter number of seconds after which the stored procedure will time out.

Initialise Default Data: For a new system, or where a system needs to be reset to system default as installed then this option should be used. This will destroy all changes to the default structure so if you have used this structure you should be very careful.

Clear All Data: This option will clear out all Cash Flow structures from the system and all information from the SQL tables.

Clean Up Database: When lines are deleted from the cash flow structures they are initially soft deleted. In order to run a tidy up of the database this menu option can be selected to clear out all unwanted lines and related data entries in the SQL tables.

Colours: You can amend the colours of information displayed in the cash flow forecast. Simply click on the colour block you wish to change and choose a new colour.


4. Creating a Cash Flow Structure

You now need to setup your Cash Flow Structure.

Choose the settings menu option from within the Cash Flow Forecast menu section. Click the drop down selection to choose the cash flow set you wish to amend. At installation there will be a single ‘default forecast’ option.

Sicon Cash Flow Help and User Guide - Creating a Cash Flow Structure


4.1. Default Cash Flow Structure

Opening balance: At the top of every cash flow forecast column will be the opening balance brought forward from the previous day’s (weeks/months) closing position.

Banks: You can select which bank accounts to include in the cash flow forecast. They will appear in the first column only (Overdue and balances) and feed/create the initial opening figure for the cash flow. The figure shown will be in the base currency of the Sage 200 Company and any foreign currency bank accounts that are included will be converted to that currency.

Sicon Cash Flow Help and User Guide - New Bank Section

Click New Section (or right click on then Banks line) and click on New Bank Section, then Bank to specify the bank from the available Sage 200 bank account list.

Within this section you also have the facility to add a Cash Sales Forecast. Click New Bank Section, then Cash Sales Forecast. (This feature is used to forecast cash takings for business who deal directly with the public in shops or other cash based service industries).

Sales / Sales Invoices: Sales Invoices are read directly from the Sage 200 sales ledger in real time and displayed in the cash flow. They are placed in the cash flow on the invoice due date or the forecast date when added. These transactions can be amended within the cash flow forecast screen.

Sales / Sales Orders: Sales Orders are read directly from the Sage 200 sales order processing module in real time and displayed in the cash flow. They are placed in the cash flow on the date that is calculated as the sales order promised date plus the customer terms in days. Where the setting to use average customer time to pay is set, then this value will be added to the promised date to come up with the expected cash inflow date. These transactions can be amended within the cash flow forecast screen.

Purchase / Purchase Invoices: Purchase Invoices are read directly from the Sage 200 purchase ledger in real time and displayed in the cash flow. They are placed in the cash flow on the invoice due date or the forecast date when added. These transactions can be amended within the cash flow forecast screen.

Purchase / Purchase Orders: Purchase Orders are read directly from the Sage 200 purchase order processing module in real time and displayed in the cash flow. They are placed in the cash flow on the date that is calculated as the purchase order requested date plus the supplier terms in days. These transactions can be amended within the cash flow forecast screen.

Applications/Customer: The Customer Applications are read directly from the Sicon Customer Applications Module and are displayed in real time. These transactions can be amended within the cash flow forecast screen. (Only shown when Sicon Construction is installed).

Sicon Cash Flow Help and User Guide - Cash Flow Section Editor

Applications/Supplier: The Supplier Applications are read directly from the Supplier Application Module and are displayed in real time. These transactions can be amended within the cash flow forecast screen. (Only shown when Sicon Construction is installed).

Retentions/Sales: When the Valuation Invoice is paid, the Retention amount will immediately be displayed in real time. These transactions can be amended within the cash flow forecast screen and can also be released using the link (right mouse click) to the Retentions Ledger. (Only shown when Sicon Construction is installed).

Sicon Cash Flow Help and User Guide - Retentions / Sales

Retentions/Purchases: Purchase Invoices with Retentions are read directly from the Sage 200 purchase ledger in real time and displayed in the cash flow. They are placed in the cash flow on the retention due date. These transactions can be amended within the cash flow forecast screen and can also be released using the link (right mouse click) to the Retentions Ledger. (Only shown when Sicon Construction is installed).

Contracts: Contracts created within the Sicon Contract Management module are read directly into cash flow.

Nominal Cash Movements: These are divided into 2 sub sections to either pull information from cash budgets set against a nominal or ad hoc manually entered nominal values. A new section needs to be added to the structure using the new section button, this section can then be renamed.

Sicon Cash Flow Help and User Guide - Default Cash Flow 1

Within this section, sub sections can then be created for either manual nominal entries or nominal cash budgets.

  1. Manual Nominal Sub Section:Use this feature to insert Ad-hoc costs and revenue elements to the cash flow that are not covered by standard Sage 200 nominal budgets.

 

Having added the Manual Nominal sub section, you can then rename the sub-section and give it a description. You can then a select nominal code, a value and a date that this cash items should appear in the cash flow. In the example above we have forecast to spend £2000 on professional fees on 13/09/2018

Nominal Cash Budget Sub Section: Use this feature to insert Sage 200 nominal codes that have been configured to use the Sicon Cash Budget column maintained within the nominal ledger account maintenance screen, see section 5. Nominal Ledger Cash Budgets below. This allows you to represent the cash impact of the nominal budget rather than the P&L or balance sheets impact that may be used for the monthly spread of annual costs and income. This feature is ideal for recur.

The cash budget column set against the nominal can be pulled into the cash flow forecast.

Having added the Nominal Cash Budget sub section, it can be renamed and a description added. Nominal codes to include in the sub section can then be added. The date that the cash should appear in the forecast can be set. If the item appears around the last day of each month check the optional box and it will automatically appear on whatever date is the last day of each month (28th, 29th, 30th or 31st).

VAT Liability:

The current VAT liability/repayment can be pulled into the cash flow forecast. The system looks at the VAT return end date to calculate when the VAT amounts are due. In the example below, the VAT return for the 31/12/2018 is due for payment one month and 7 days (based on the cash flow setting), so appears on the cash flow on the 7th Feb 2019.


4.2. Adding / Amending Sections

Sicon Cash Flow Help and User Guide - Adding / Amending Sections

The New Section/Delete section buttons allows sections to be added/removed from the cash flow set. The menu can also be accessed by right clicking on the title.

Sections with a tick in the ‘allow move’ column can be moved up and down in the menu structure. In the example below the ‘sales’ section is being moved up.

Sicon Cash Flow Help and User Guide - Adding / Amending Sections


5. Nominal Ledger Cash Budgets

This feature has been designed to allow the cash flow module to reflect the cash impact of a nominal ledger budget. For example a company may have to pay for Sage Services and Telephone support annually but spread this in their profit and loss reporting by creating monthly budgets and spreading the actual using an accrual or pre-payment.

From a cash impact perspective this cost will be incurred in a single month so the cash flow module will pick up the cash budget to reflect this accurately.

Where the cash budget and nominal budgets are the same we have provided a ‘Copy Nominal to Cash Budget’ button to speed up the process.

When the cash budget has been paid it can be flagged and removed from the cash flow, especially useful if these items are ever paid early. Because the nominal ledger budgets are not linked directly to an invoice or an order it is not possible to automatically mark them as paid.

Sicon Cash Flow Help and User Guide - Nominal Ledger Cash Budgets

When you have completed making amendments to the nominal cash budgets click the save button. If the Cash Flow Forecast is currently open you will get the following message to allow you to update the cash flow with the changes you have made.

There is also an option to include VAT in the forecast, with this ticked, the cash flow forecast values will include VAT.


6. Understanding the Cash Flow Forecast

Select the Cash flow forecast menu option from the cash flow menu.

Sicon Cash Flow Help and User Guide - Cash Flow Forecast Menu

Once opened select the cash flow structure model that you wish to review. You can alter the duration days and the level of detail at any time.

The Cash Flow forecast will take a few seconds to build and display the information reading it in real time from Sage 200. The results are displayed in the exact format of the cash flow model.

In order to keep the cash flow performance optimised it has been defaulted to show sales and purchase orders at header level rather than for every line (for customers who have Construction, Applications and Retentions will also display at header level). The values displayed will be derived from the individual line dates and values (and these can be amended by using the amend order options) but the lines are not shown. If you wish to see all order lines more clearly then change the Level of Detail drop down to either Document of Item as required.


7. Navigating the Cash Flow Screen

The cash flow screen allows you to choose the cash flow structure you wish to review. You can open multiple cash flow screens and structures at the same time. You can also select the duration in days that you wish to display on the cash flow.

The screen below shows the high level options available to navigate around this screen.

Sicon Cash Flow Help and User Guide - Default Forecast Screen

  1. Selected Cash Flow Structure
  2. Selected Duration
  3. Forecast From Date
  4. View – Day, Week, Month
  5. Level of Detail – Summary, Account, Document, Item
  6. Bad Debts – Include, Only, Exclude
  7. Currency- Flter by currnecies
  8. Options Ribbon – Features will enable and disable with each part of cash flow e.g. when Bank is selected the icon is available to click. The Key symbol opens a new Legend window
  9. Use arrows to expand/collapse details
  10. Scroll bar to enable quick movement across days/weeks/months.

Key Icon will show the Legend and explains what each of the coloured symbols means on the various transactions.

Sicon Cash Flow Help and User Guide - Legend List


7.1. Bank

Click the expand icon on the bank to view the banks that have been included. View and add memos to the standard Sage 200 bank memo’s screen directly from the cash flow.

Right click the bank account cell in the forecast sheet (must be expanded to a specific bank) and you will see various options available. In this case you can add/View memo’s or open and view the bank account if the user has permission to do so.

Sicon Cash Flow Help and User Guide - Bank

View Bank: Opens the standard Sage 200 View Bank Account screen.

NB: Standing Orders and Direct Debits have been deliberately excluded from the cash flow summary as these values will be duplicated in the nominal budget and/or represented in the nominal cash budgets.

NB: All values in the cash flow summary screen are shown in base currency.


7.2. Sales

Expand the Sales section to see Sales Invoice and Sales Order values. Anything due before today will be displayed in the overdue column.


7.3. Sales Invoices

Expand out the Sales invoices section to show sales ledger accounts and again to show individual invoices.

The diagram below explains what can be seen and what can be actioned from this screen.

Sicon Cash Flow Help and User Guide - Sales Invoices

  1. Account Number
  2. Invoice Number
  3. Second Reference
  4. Legend Flag e.g. unallocated receipts
  5. Icon indicates a forecast date has been applied to move the income to an alternative date
  6. Memo Flag – Use Memo’s within Sage 200 Sales Ledger and the Cash Flow to create a simple but effective credit control tool
  7. Mark as Bad Debt (right click to view this option)

Note: The values in Sicon Cash Flow are inclusive of VAT as we are dealing with cash.

ToolTips

When you hover the cursor over a transaction, the system displays information about the transaction, namely the transaction number, description, forecast date (where set), and value, if there is no forecast date, then the column heading sate will be displayed.


7.4. Options available for Sales Invoices

Sicon Cash Flow Help and User Guide - Options available for Sales Invoices

Add View Memos: Click the Add/View Memos to add or edit sales invoice notes.

Sicon Cash Flow Help and User Guide - Memos

Using the Cash Flow for Credit Control: Sicon Cash Flow displays all existing Sales Invoice transaction memos and allows the user to add and edit these memos from the cash flow screen in the normal way, so memos added here will also be visible in the sales ledger transaction enquiry screen too.

By using Sicon Cash Flow in this way, it can become a simple but very effective credit control tool with overdue invoices being displayed in the overdue column of the cash flow screen.

Change Forecast Date: You can drag and drop the selected invoice to the desired date but if this date is off the screen it may be simpler to enter it manually. Use this feature to change the expected cash receipt date of invoices when you need to select multiple invoices.

From the sales ledger enquiry screen you can also see the forecast date and change it here too. This will update the cash flow if it is currently open or at next refresh.

The Forecast Date has been added to the sales ledger transaction as we do not want to change the invoice due date that reflects the invoices original due date. The forecast date allows us to record the date we expect the cash to arrive.

Sicon Cash Flow Help and User Guide - Supplier Transaction Enquiry

Toggle Bad Debt: Change between marking invoice as bad debt or taking flag off.

View Sales Invoice: This opens the sales ledger enquiry screen filtered with this single invoice, allowing you to see all the details relating to any scanned documents that have been attached via the Sicon DMS or Draycir document capture add-ons.

View Customer: Allows the user to access the Sales Ledger account enquiry screen for the selected account.

Amend Customer: Where the user has the amend account feature enabled in their user role they will also be able to amend the Sales Ledger account from the cash flow screen.


7.5. Sales Orders

Expand out the Sales Orders section to show sales ledger accounts and again to show Sales Orders. For visibility of individual sales order lines in the cash flow increase the detail by changing the Level of Detail to Item. You can still edit the sales order due dates by amending the sales order and its lines from the cash flow menu options.

The diagram below explains what can be seen on the screen and the options available.

Sicon Cash Flow Help and User Guide - Sales Orders

  1. Date of transaction reflects the sales order promised date plus the customer payment terms (or if switched on, the average time to pay)
  2. Account Number
  3. Order Number
  4. Customer Order Number
  5. The value on the Cash Flow will include VAT but will also deduct any settlement discounts and exclude items that have been invoiced from the sales
  6. Menu options reflects relevant features for Sales Orders

Sales Order Forecast Dates: The date and value displayed on the cash flow will be calculated for each sales order line.

The cash flow date is calculated as the promised date from the sales order line plus the customer account terms (if switched on in settings, this will use the customer average time to pay).

There is a forecast date provided on the sales order header which can set the forecast date on all the sales order lines or each line can be updated individually to reflect the forecast cash income date.

If these fields are blank it means that no change has been made from the default calculation of dates on the cash flow.

Sales Order Header Forecast Date:

Sicon Cash Flow Help and User Guide - Sales Order Header Forecast Date

Sales Order line forecast date:


7.6. Purchase

Expand the Purchase section to see Purchase Invoice and Purchase Order values. Anything due before today will be displayed in the overdue column.

Sicon Cash Flow Help and User Guide - Purchase


7.7. Purchase Invoice

Expand out the Purchase invoices section to show Purchase ledger accounts and again to show individual purchase invoices.

The screen shot below explains what can be seen:

Sicon Cash Flow Help and User Guide - Purchase Invoice

  1. Account Number
  2. Invoice Number
  3. Second Reference (if used)
  4. Indicates the date has been changed in the Cash Flow from the original invoice due date
  5. The value on the cash flow will include VAT as we are dealing with cash movements
  6. Menu options reflect features available within Purchase Invoices.

7.8. Options available for Purchase Invoices

Add View Memos: Click the Add/View Memos to add or edit purchase invoice notes.

Sicon Cash Flow Manager - Cash Flow Forecast Purchase Ledger Memo Detail

Change Forecast Date: You can drag and drop the selected invoice to the desired date but if this date is off the screen it may be simpler to enter it manually. Use this feature to change the expected cash receipt date of invoices when you need to select multiple invoices.

From the purchase ledger enquiry screen you can also see the forecast date and change it here too. This will update the cash flow if it is currently open or at next refresh.

The Forecast Date has been added to the purchase ledger transaction as we do not always want to change the purchase invoice due date that reflects the invoices original due date. The forecast date allows us to record the date we expect to pay this invoice.

NB: it is possible to change the cash flow setting to allow the purchase invoice due date to be updated based on the forecast date chosen. This could help with the payment of invoices as any moved into the following payment period would be excluded from the current suggested payment routine run and would fall into the correct period for payment processing based on the change of forecast and due date.

View Purchase Invoice: This allows you to open the purchase ledger enquiry screen filtered with this single invoice, allowing you to see all the details relating to is and any scanned documents relating to it attached via the Sicon DMS or Draycir document capture add-ons.

View Supplier: Allows the user to access the Purchase Ledger account enquiry screen for the selected account.

Amend Supplier: Where the user has the amend account feature enabled in their user role they will also be able to amend the Purchase Ledger account from the cash flow screen.


7.9. Purchase Orders

Expand out the Purchase Orders section to show purchase ledger accounts and again to show Purchase Orders. For visibility of individual purchase order lines in the cash flow increase the detail by changing the View and Level Of Detail.

You can still edit the purchase order due dates by amending the purchase order and its lines by selecting the Amend Purchase Order option from the options available from the cash flow menu.

The screen shot below explains what can be seen on this screen and the options available.

Sicon Cash Flow Help and User Guide - Purchase Orders

  1. The date of this transaction reflects the purchase order requested date plus the supplier terms
  2. Account Number
  3. Purchase Order Number
  4. The value of the cash flow will include VAT and will also include any settlement discount and exclude any purchase order lines
  5. Menu options reflect features available within Purchase Invoices

Purchase Order Forecast Dates: The date and value displayed on the cash flow will be calculated for each purchase order line.

The cash flow date is calculated as the requested date from the purchase order line plus the customer account terms.

There is a forecast date provided on the purchase order header which can set the forecast date on all the purchase order lines or each line can be updated individually to reflect the forecast cash income date.

If these fields are blank it means that no change has been made from the default calculation of dates on the cash flow.

Purchase Order Header Forecast Date:

Purchase Order Line Forecast Date:


7.10. Applications

NB: this Option will appear when you have purchased the Sicon Construction.

Expand the Applications section to see Customer Applications and Supplier Applications. Anything due before today will be displayed in the overdue column.

Sicon Cash Flow Help and User Guide - Applications


7.11. Customer Applications

NB: this Option will appear when you have purchased the Sicon Construction.

Expand the Customer Applications section to show Customer accounts and again to show Application lines, increase the detail by changing the View and Level Of Detail.

Sicon Cash Flow Help and User Guide - Customer Applications

  1. Account Number
  2. Job/Application Number
  3. Outstanding Application value. This will update in real time as Valuations are raised against the application
  4. Menu options reflect features available within Customer Applications

The Outstanding Application Amount cash flow date is calculated as the application date plus the customer account terms.

Change Forecast Date: You can drag and drop the selected application to the desired date but if this date is off the screen it may be simpler to enter it manually. Use this feature to change the expected date of applications.


7.12. Supplier Applications

NB: this Option will appear when you have purchased the Sicon Construction.

Expand the Supplier Applications section to show Supplier accounts and again to show Application lines, increase the detail by changing the View and Level Of Detail.

Sicon Cash Flow Help and User Guide - Supplier Applications

  1. Transaction Date which is the date of the application plus supplier terms
  2. Account Number
  3. Job/Application Number
  4. Outstanding Application value. This will update in real time as Valuations are raised against the application
  5. Forecast date changed

Change Forecast Date: You can drag and drop the selected application to the desired date but if this date is off the screen it may be simpler to enter it manually. Use this feature to change the expected date of applications.


7.13. Retentions

NB: this Option will appear when you have purchased the Sicon Construction.

Expand the Retentions section to see Sales Retentions and Purchase Retentions. Anything that should have been released before today will be displayed in the overdue column.

Sicon Cash Flow Help and User Guide - Retentions

  1. Transaction Date which is the date of the retention release
  2. Account number
  3. Account Name
  4. Customer Reference
  5. Retention amount
  6. Menu options reflect features available within Purchase Retentions
  1. Transaction Date which is the date of the retention release
  2. Account number
  3. Application number
  4. Job Number
  5. Retention amount
  6. Forecast date changed
  7. Menu options reflect features available within Sales Retentions


8. Ad-Hoc / Manual Nominal Ledger Enteries

Where one-off costs need to be added to the cash flow this is the feature that can be used to achieve this.

These cost items are still related to a nominal ledger to help understand where future projected costs/revenues might have become actual purchase/sales invoices.

Each entry can have a specific date that it should be displayed within the cash flow.

Sicon Cash Flow Help and User Guide - Ad-Hoc / Manual Nominal Ledger Entries

Maintain Manual Nominals allows the entry to amended from the cashflow screen.

Sicon Cash Flow Help and User Guide - Ad-Hoc / Manual Nominal Ledger Entries 2

Sicon Cash Flow Help and User Guide - Ad-Hoc / Manual Nominal Ledger Entries

Add/View Memos: Allows memos to be added or viewed.

Change forecast date: Allows the manual amendment of this specific value to an alternative date.

Mark as paid: when selected this will remove the item from the cash flow.

Amend nominal account: This option will open the Sage 200 ‘amend nominal account’ screen and allow you to edit the details. In addition to this you will see the Sicon cash budget and paid information displayed on these screens.

View nominal account: This option will open the Sage 200 ‘View nominal account’ screen and allow you to view all nominal ledger details.


9. Nominal Cash Budget Entries

Where budgets costs need to be added to the cash flow this is the feature that can be used to achieve this. Providing an additional field to display the Cash impact of the budget (especially useful when the nominal shows a spread of cost or revenue).

These cost items are still related to a nominal ledger to help understand where future projected costs/revenues might have become actual purchase/sales invoices.

Each entry can have a specific date that it should be displayed within the cash flow.

Amend/View Nominal Account: Opens the nominal account, that can then be amended or viewed.


9.1. Menu Options Available

Change forecast date: Allows the manual amendment of this specific value to an alternative date.

Mark as paid: when selected this will remove the cost from the cash flow. This will usually be carried out when this item is processed as an invoice, order or cash book payment. If selected by accident simply select the ‘amend the nominal’ account and unselect the ‘paid’ check box for that item.

Amend nominal account: This option will open the Sage 200 ‘Amend nominal account’ screen and allow you to edit the details. In addition to this you will see the new Sicon cash budget and paid information displayed on these screens.

Sicon Cash Flow Manager - Cash Flow Forecast Amend Nominal Account Cash Budget Entries

View nominal account: This option will open the Sage 200 ‘View nominal account’ screen and allow you to view all nominal ledger details.


9.2. Menu Options Available

Sicon Cash Flow Help and User Guide - Menu Options Available

Add/View Memos: Allows memos to be added or viewed.

Change forecast date: Allows the manual amendment of this specific value to an alternative date.

Mark as paid: when selected this will remove the item from the cash flow.

Adjust Nominal Cash Budget: The nominal cash budget for the month can be amended.

Amend nominal account: This option will open the Sage 200 ‘Amend nominal account’ screen and allow you to edit the details. In addition to this you will see the new Sicon cash budget and paid information displayed on these screens.

Sicon Cash Flow Help and User Guide - Menu Options Available

View nominal account: This option will open the Sage 200 ‘View nominal account’ screen and allow you to view all nominal ledger details.


Notes on cash flow values displayed:

  1. Sales & Purchase Order Values include settlement discount as we need to represent the worst case scenario in the cash flow.
  2. Sales & Purchase Order values will only include un-invoiced lines. Once an invoice is created from a sales order or matched to a purchase order the value in the cash flow will automatically be reduced.

10. Enable Module

Each year your Cash Flow module will require a new enable string to continue working.  When you have been issued with your new key, select this option and enter the code into the new enable string field (copy and paste is the easiest way).

 


11. Release Notes

The Release Notes document below shows which release of the Cash Flow system includes which new features and for which version of Sage these will work. The version number indicated in the Cash Flow Release Notes includes a full release number and a sub version number; e.g. ’6.1′ indicates the full release version number of the software.  Pre-release version builds of the software are available to certain clients requiring new or enhanced features being developed from the wish list.  If these versions are installed on your system, you will see an additional number e.g. 39.113 making up a specific database version and interim build number of 6.1.39.113. It is unlikely that these features will be documented in this help and user guide until the end of the development phase.

Cash Flow Release Notes


13. Sicon V18 New Features & Important Information

New Features

  • Added an option to update Cash Budgets as supplier invoices and payments are processed
  • Added a new setting to determine the number of days to add after one month for the VAT Payment Due Date
  • Changed the settings screen to group settings logically
  • Added the ability to adjust a nominal cash budget from the forecast screen
  • Added VAT Liability to new Forecasts and the ability to add Vat Liability to existing forecasts
  • Extended the Nominal Cash Budget Import to allow setting the Add Vat option on the nominal
  • Added a new Setting for Bank Clearing Days (the number of days to add to supplier payments)
  • Added right click options to the structure builder in settings to add / remove sections.
  • Combined all new section buttons into a single context menu in settings
  • Scripted the Nominal Account screens to specify whether a nominal account should have VAT applied to the cash budget
  • Added the ability to add in Sales, Purchase, Applications, Retentions and Contracts into an existing cashflow set.
  • Added a new column to the section editor in settings to show if a section can be moved
  • Added the exchange rate into the currency selection control on the Forecast Form
  • Replaced all ‘Sicon Icons’ with the Sicon2018 Icon
  • Changed the Date Picker on the Change Forecast Date screen to a Month Calendar
  • Scripted the AmendCustomerTransactions form to allow setting the forecast date
  • Scripted the AmendSupplierTransactons form to allow setting the forecast date
  • Added tooltips for the overdue / value columns on the forecast screen
  • Added a new setting to determine whether the forecast date is cleared when amending sales and purchase transaction due dates
  • Added Tooltips to the flags column on the forecast screen
  • Added a new section to the status bar on the forecast screen to show the current setting for whether week view column headings are Week Start Date, end Date etc.

Important Information

  • The package GUID has been updated to work around an issue in Sage 200 System Administrator where add-on package SQL script version numbers are limited to a maximum of 255. The SQL script version number is per GUID so changing to a new GUID is the only way to continue database updates after the 255th change. Please install the new packages prior to removing the old package in order to maintain feature allocations. [v17.0.11]

[Last Important Info applied May 8, 2017. V17.0.11]

Sicon Cash Flow v18 New Features & Important Information

Sicon Main Menu