Red card for Excel

Easy-going international consolidation for sports industry provider

Success story Polytan

Thanks to its rapid growth on the global stage, Polytan urgently needed sophisticated financial software for the preparation of consolidated financial statements and controlling analyses, as well as for planning on a group basis. With the LucaNet software, the company headquarters in Burgheim now take care of consolidation, planning and reporting – quickly, easily and for the entire holding.

LucaNet is extremely flexible and allows us to adapt to any new requirements at short notice. From individual companies to the level of the group, we now have detailed information for finance and controlling in just a few clicks. The server hosting also facilitates access to the database from around the world.

Mathias Schwägerl
Head of Controlling and Accounting Standard

Polytan uses LucaNet software for

  • Data import despite individual reporting packages
  • Detailed planning of all corporate divisions
  • Multilevel consolidation in accordance with the German Commercial Code (HGB)

About the company

Polytan is synonymous for quality when it comes to outdoor sports surfaces. In Olympic and soccer stadiums from Munich to Melbourne, Polytan is the company that makes game time (and all the emotion at the game) possible.

Use cases

logo polytan

Industry :

Production / Industry

Core Business :

Sports flooring and surfaces

Headquarter city :

Burgheim (Germany)

Employees :


Website :

Polytan homepage

The challenge

Currency translation with Excel

When Polytan's self-programmed Access database with their linked Excel reports could no longer guarantee efficient accounting, the search for a solution began. Software that included integrated currency translation according to international accounting standards was what was needed. This is because Polytan has to translate foreign subgroups from Australian and New Zealand dollars via US dollars into euros. Also expected: The possibility for budget planning including multi-year planning and forecasting, administration and planning of loans and intercompany business transactions, as well as data export to MS Excel.

The solution

A secure solution for international requirements

It was not long before LucaNet was chosen. Decisive advantages include the integration of planning and consolidation into one module and the taking into account of complex currency translation requirements. LucaNet was implemented in no time and Polytan employees were trained up on the software. The data import also ran smoothly, even though the entire group works exclusively with individual reporting packages. The entire balance sheet, P&L, as well as the fixed asset and provision schedule with all relevant controlling data on product groups, sales and material data, countries and sales regions were quickly imported. And thus previous entries were brought up to date.

Learn more about our software for consolidated financial statements and download our brochure.

Download flyer

At Polytan, planning for the individual companies is decentralised. However, planning for the entire group is organised in a centralised fashion via the controlling department. And all this is carried out in an entirely seamless manner with the detailed plans of all company divisions. LucaNet is now also used for multilevel consolidation in accordance with the German Commercial Code (HGB) across subgroups to the main group. The software’s consolidation wizards are able to provide the required support, be it for elimination of intercompany debt or the elimination of intercompany income and expense. Double currency translation now occurs at just the “press of a button”. This is because a fictitious company was created for this purpose, in which the aggregated figures (in dollars) are combined and translated into euros. Smart solutions for clear figures on an international scale.

How LucaNet software benefits Polytan

  • Detailed financial and controlling information at the press of a button
  • Worldwide access to the database at any time
  • Simple consolidation with double currency translation