Tag Archive for: ERP systems

Cashforce and smart cash forecasting

| 03-04-2018 | treasuryXL | Cashforce |

As stated in our last blog, on Tuesday 27th March 2018, treasuryXL attended a seminar in Amsterdam organised by TIS about optimizing cash flow. The last speaker at this event was Nicolas Christiaen, mananging partner at Cashforce. They are a fintech leader in Cash forecasting & Treasury solutions for corporates. They took the opportunity to explain to all the attendees what their product is and how it works. In this article we shall attempt to provide an insight into what we learnt.

Cashforce focuses on automation and integration within cash forecasting and treasury management systems. They connect the Treasury department with other departments within a business – offering full transparency into the cash flow drivers, resulting in accurate and efficient cash flow forecasting. They also offer a flexible forecasting method which we shall explain later.

Forecasting is a subject that can cause irritation within a company. It requires different departments to collaborate on a regular basis and provide consistent information which needs to grouped together to present a complete overview of the expected cash movements for the agreed time period. This input encompasses accounts payable, accounts receivable, procurement, projects, HR, treasury etc. All this information needs to be presented in a consistent format so that everything can be aggregated. Problems arise when data is not delivered, or delivered too late, or inaccurate.

The solution would appear to be a single method to extract all the relevant data from all the relevant databases and systems and to have this incorporated together with the correct running opening bank balances.

Cashforce have developed a platform that links into all the aforementioned databases and uses the agreed metrics within the different departments to arrive at a forecast. This leads to an integrated platform driven by your own systems. As the data parameters have been mapped and agreed beforehand, this means that it is possible to drill down to a very granular level to predetermined transaction details. This means you can go from the comprehensive level to overview per account, per client, per accounting group as the original chart of accounts has been embedded into the platform.

Included with the platform is a special functionality that takes into account the actual dispersal from a particular client and allows you to see how they actually performed as opposed to their agreed performance. These metrics can then also be used to adjust the forecast to the past behaviour of all component parts from the chart of accounts, enabling a forecast to be presented that reflects the actual results from the past.

It becomes possible to drill down on every single aspect with the forecast and interrogate an individual item. Furthermore, it is possible to make adjustments to the forecast and see the results, whilst also giving a data trail showing what changes were made and by whom. The ability to review different scenarios, whilst still retaining the original data, makes this solution unique from the standard cash forecasting systems.

This can lead to greater understanding of the drivers within a company’s cash, good visibility of the behaviour of an individual counterparty, more accurate ability to determine when additional funds are needed, together with the potential to map the effects of changing individual items and seeing their outcome to the complete forecast.

In conclusion, this is an original solution to an age old problem for cash management.

treasuryXL would like to thank Cashforce for illustrating their solution at this seminar. If you have any questions, please feel free to contact us.

[button url=”https://www.treasuryxl.com/contact/” text=”Contact us” size=”small” type=”primary” icon=”” external=”1″]

[separator type=”” size=”” icon=””]

 

Five points to consider when choosing your payment system

| 05-10-2016 | TIS | Sponsored content |

photo-1430417934865-589b63ad5c00

Transparency, reduced risks – and a one million euro saving per year

The payment processes in corporations and internationally active companies are more complex than you might think at first glance – and they are unclear and non-transparent virtually everywhere. This complexity results from the branched company structure and the consequent variety of banking arrangements maintained at central HQ and out in the branch offices and subsidiaries. Various currencies, formats and security keys present an obstacle to unitary, standardized payment processes and an overall view of bank transactions.

Intelligent payment systems in the cloud can remedy this situation: they improve transparency over payment processes, reduce costs and risks and form the basis for better company decision-making. In the typical scenario of an internationally active company they easily contribute annual savings of one million euros.

Download the executive briefing.

 

Do you still rely on spreadsheets in your daily treasury operations?

| 24-08-2016 | Jan Meulendijks |

spreadsheet2Spreadsheets, every treasurer knows how to work them. Spreadsheets are deeply embedded in treasury operations and they seem hard to eliminate. We have read multiple articles on this subject lately and we decided to ask our community: Why do treasurers still rely on spreadsheets? (source: gtnews.com)

[separator type=”” size=”” icon=””]

Jan MeulendijksJan Meulendijks
In many cases the treasurers of companies have started their area of expertise with smaller (SME) companies, where the available ERP-system did not offer treasury features and/or no separate treasury system was in use. So… you build it yourself in a spreadsheet. The big advantage of this is that such a spreadsheet only features what you really need, and can be kept quite simple but effective.

When the treasurer moves up to a larger company, the basic spreadsheet can be expanded with any new features required. Again, simple but effective. The big disadvantage of course, is lack of system documentation and dependance on the original designer to transfer knowledge to others.
I would like to classify this phenomenon under the “80/20”-rule: with a few basic spreadsheet functionalities you can achieve 80% of your treasury requirements, to achieve the remaining 20% you have to undertake large operations and investments. Is that all worth it???

[separator type=”” size=”” icon=””]

Do you still rely on spreadsheets in your daily treasury operations?

How to cope with the interconnectivity trap part II

| 16-08-2016 | Hans de Vries |

Erphansdevries (1)

 

Electronic Banking has been here for more than thirty years now. And it certainly had a big impact on the way the corporates and banks communicate. Nevertheless, ever since the introduction Treasurers have been struggling to incorporate this feature into their IT ERP environment. They get stuck in the middle. You can read more about that in part I of this article. Today I will show you my “way out”.

A bank and ERP (and TMS) system agnostic solution to upgrade the Treasury function

The SaaS solution described in this article is particularly interesting for Treasurers because of the very limited implementation efforts that are needed to set-up the system at the corporate side. All the platform needs, is a connector that takes care of the automatic upload of files from the ERP environment to the platform. The platform takes care of the conversion of transaction files to the file format needed by the specific banks for processing and performs a validation on the contents of the files to ensure Straight Through Processing at the bank.

So there is no need for changing the output at the current ERP system. This is extremely handy in situations where the corporate landscape consists of various ERP systems, or various versions of an ERP system. The same goes for the download of statement files. After collection of the bank statements, the platform takes care of the conversion into the needed file formats and delivers them into the ERP (and TMS) environment for automatic reconciliation purposes. By using the (SaaS) bank agnostic platform the Treasurer is immediately freed from all usual IT concerns with regard to the bank connections. Most systems also provide the Treasurer with a Dashboard Function to monitor the actual total balances at all banks and the cashflows (End of day and Intraday) that enables them to perform bank (automated) independent cash balancing transactions if needed.

Streamlining the authorization processes to get full control

In most multibank situations the treasurer is faced with one bank only authorization schemes that in most cases use unique bank authorization codes tokens and procedures. This wide variety of tokens, passwords etc. makes life for a Treasurer far from easy especially from a compliancy perspective.

Routing all outgoing transaction files via the SaaS platform, provides the Treasurer with the unique opportunity to streamline the authorization process. He now gets the opportunity to fully control and maintain the granted functionalities / authorization levels per user that are applicable on all bank accounts. Especially in the upcoming times of real-time 24/7 processing by the banks, using this sole gateway to the banks will provide the Treasurer with maximum control of all outgoing transactions and therefore avoiding fraude to the max. Since these systems also provide all necessary audit trails, the Treasurer can take full accountability for the banking processes.

Saving substantial money

Depending on the platform and the number of banks that need to get connected, the costs of the implementation and annual subscription fee will vary per provider. However, the benefits of such an investment are not only measured by the upgrading of the internal cash management processes.

Implementing the platform will also directly lower the operational costs:

  • Experts estimate costs of € 15,000 per year per e-banking solution (maintenance, license fees, software updates, system administration, system tests, database configuration etc.)
  • Elimination of expenses for manual liquidity tracking, manual administration of bank accounts and bank master data as well as the bank-specific administration of signatory authorizations.
  • Reduced banking fees as a result of higher transparency, easier comparability as well as the maximized flexibility towards banks: daily choice of transaction bank(s) per currency/ transaction type.
  • Saving operational costs due to the elimination of manual intervention for the collection and upload of bank statements to the ERP system. In the perfect set-up the reconciliation process can be fully automated and finalized in the early hours of the day providing a head start to the credit management department.

In most cases, these savings pay back the investment in the bank agnostic platform within a year. The introduction of this relatively new cash management service will free the treasurer from the interconnectivity trap, upgrade the internal organization, provide a uniform authorization scheme on all banks while at the same time reducing the operational costs. This solution is also future proof due to its capacity to adopt quickly to new standards, formats etc. All in all, a perfect perspective on upgrading the cash management function within the treasury. For more information, check: PowertoPay.com.

 

How to cope with the interconnectivity trap?

| 09-08-2016 | Hans de Vries |

Erphansdevries (1)

 

Electronic Banking has been here for more than thirty years now. And it certainly had a big impact on the way the corporates and banks communicate. Nevertheless, ever since the introduction Treasurers have been struggling to incorporate this feature into their IT ERP environment.

This struggle has proven to be a tough one, due to the ever changing internal ERP environment as a result of various versions of the same ERP system or even various ERP systems within the company due to take-overs/ mergers. And of course there was quite some turmoil in the banking industry itself: the introduction of the Euro, then SEPA with all new transaction formats and regulations, meanwhile a banking crisis etc. Moreover, the ever growing demands on security and compliance pose further pressure on the interconnectivity. As a result, it has become more and more difficult to keep all connections in place and up-to-date. Especially since most corporates are forced to spread their cash management business amongst multiple banks from a risk mitigating perspective. On top of that the Treasurer is facing a radically changed attitude towards data processing operations, from management but also business environment perspective. We now live in an internet world that does not allow for slacking reactions and inefficient procedures. Action is reaction and efficient reconciliation processes are the key for survival.

Treasurer gets stuck in the middle

To optimize this situation, the Treasurer usually finds himself squeezed between the limited IT budgets for optimizing the connections with his back office environment on the one end and his banks on the other with their multiple banking solutions. While SEPA was presented as a unifying power to align all European banks, in practice there still appears to be a great variety in approaches per bank. So therefore in practice, the Treasurers dreams of a flawless interconnectivity often proved to become nightmares and he most of the time winds up somewhere in the middle of an endless implementation process.

Is there a way out?

The answer is negative as long as the Treasurer remains dependent on the internal IT departments and the offered bank solutions. However, if the Treasurer wants to actively take control of this situation there are now options available that will provide the Treasurer with all the connections and security/ compliance checks he needs for his day to day cash management operations. Instead of using the internal systems, the Treasurer can have his back-office systems (ERP and TMS) connect to the banks via a bank independent (SaaS) platform that will take care of conversion and validation of the uploaded files, the authorization according to the internal compliance guidelines and the routing towards all corporate banks. At the same time the electronic bank statements will be collected and forwarded to the back-office systems for automatic reconciliation in the ERP (and TMS) environment. Apart from the authorization of the transactions, no manual intervention is needed.

Next week Hans will introduce you to his ‘way out’: the SaaS platform.

Foreign bank accounts, how to include them in your cash pool

| 21-06-2016 | Jan Meulendijks |

janmeulendijksSignificant balances on your foreign bank accounts which are really of better use in the country where your operation is? Include them in an automated cash pooling scheme so that all your funds are available in The Netherlands and no more unnecessary interest is paid!

There are a number of reasons why you maintain bank accounts in other countries (I will explain the advantages of that in my next paper), but once this is the case, you need to control them in the most efficient way and at minimum costs.

Dutch banks who offer international cash management solutions have several tools to achieve this:

1. International Balance Reporting

The banks where you hold your accounts report them daily automatically into your multi-bank internet banking tool (e.g. Access Online from ABN AMRO); balances as well as transactions. With this tool you can also initiate local or cross border payments from this account.

Most ERP-systems can reconcile this account information automatically into your general ledger.

2. Cross Border Zero Balancing (CBZB)

In case your foreign accounts are held with subsidiaries of your Dutch bank, the balances can be automatically swept (daily) to your central cash pooling account in The Netherlands or be supplied with funds in case of shortage.

3. Multi-Bank Cash Concentration (MBCC)

In case your accounts are held with foreign partner-banks of your Dutch bank the alternate MBCC system can be used to achieve the same effect.

Now, once you have the Balance Reporting part in place plus one or both options CBZB and MBCC, not only all account information is made available to you on a daily basis, but also the balances are swept automatically daily into your central cash pooling account in the Netherlands!

Results:

  • Automated reconciliation of account-information in your General ledger; no more loss of time/personnel processing data
  • Interest optimisation (your use of bank credit is reduced with the balances that otherwise are in your foreign accounts)
  • No manual handling

Setting up such an international cash management scheme involves some paper work and time (most of that at your bank’s side) but once it has been set up it is a major cost and trouble saver which you wish you had had 10 years sooner!

 

Jan Meulendijks

 

Jan Meulendijks

Cash management, transaction banking and trade professional