Treasury Controlling

The task of treasury controlling is to monitor, analyze and control treasury-relevant information

Treasury processes take place in every company, whether it has 100,000 or 100,000,000 turnover or balance sheet numbers. Depending on the size of the company, these treasury processes are managed in specialized treasury departments with dozens of highly specialized specialists - these may have several subgroups, such as their own treasury controlling department - or in small companies by a one-man team consisting of the accountant. However, all companies, regardless of size, have one thing in common: they need to have their financial processes under control and this includes treasury issues such as financing, foreign currency risks, interest rate risks, working capital management, banks, financial planning, etc.

Treasury systems

Controlling can quickly become confusing and inefficient, which is why it is particularly important which tool the treasury controller is provided with for his work. Specialized treasury software is the best choice. The market for specialized and useful treasury software is clear. And the number of integrated treasury system solutions is extremely small. Literally a handful of providers share the global market. In addition, there are a few providers that combine the often one-sided banking solutions with a kind of umbrella solution. However, these systems tend to be limited to payment transactions and the immediate cash situation. It is more difficult to find a suitable solution that transforms the tasks of treasury processes from Excel to a standard database, especially for medium-sized companies, at a reasonable price.

We have designed an in-house development for this purpose, which comes very close to a holistic solution!

However, an Excel solution is often used, which we have also often successfully developed specifically for companies:

Excel solutions

Excel is the tool that controllers and treasurers use for most of their work. Be it a quick ad-hoc evaluation from a large system (ERP), a standardized controlling software (e.g. Hyperion) or treasury software (see above). The decisive advantage of Excel is that it is very flexible, can be integrated into any IT infrastructure and can be used by anyone. Operating it is one thing, but developing a secure solution is another.

Advantages

• Interfaces to upstream and downstream systems allow your new planning and reporting tools to be seamlessly embedded in the existing system landscape.
• Modular structure of the treasury planning and reporting application according to subject areas. For example, FX risk, interest exposure, financial status, global exposure. All this per currency, per instrument, per entity, per reporting interval and, of course, all consolidated.
• Specific sub-topics, reports or data collection masks are assigned to each topic area.

With our practical experience and successful implementation of comprehensive solutions for our customers, we realize an audit-proof, consistent treasury planning and reporting structure - flexible, simple, close to the department. Information can be processed into definable standard reports or individually compiled in ad hoc reports. The clear structure increases user acceptance and makes planning and reporting processes even easier. This allows you to make optimum use of the potential of straight-through processing and continuously develop it further in order to realize sustainable efficiency and time gains.