Multiple reporting units FInancial consolidation with script
Hello I am Alessandro, Italian , 48 yo. Degree in Economy and Master in Management. I have been always fond of IT tools, especially spreadsheets, with skill extended to VBA (Excel) and JavaScript (GSheets). I am a Divisional controller in a medium size multinational company. We had the need to built up a tool to gather and consolidate financial statements of our companies (located in different countries with different currencies), as well as other non-financial reports. But it might be used also within a single company with different branches, being the tool very flexible. I have built up a structured Gsheet reporting. Every company/branch can upload the forecast data in his own file. This upload can be both manual, or retrieve the data pushed from their own ERP and then pulled trought Drive File stream and other add-on directly into files. Consolidation comes in real time at every single input and Currency exchange are update every 20 minutes. Elimination tool for Intercompany sales i
About Me
Hello I am Alessandro, Italian , 48 yo. Degree in Economy and Master in Management. I have been always fond of IT tools, especially spreadsheets, with skill extended to VBA (Excel) and JavaScript (GSheets). I am a Divisional controller in a medium size multinational company. We had the need to built up a tool to gather and consolidate financial statements of our companies (located in different countries with different currencies), as well as other non-financial reports. But it might be used also within a single company with different branches, being the tool very flexible. I have built up a structured Gsheet reporting. Every company/branch can upload the forecast data in his own file. This upload can be both manual, or retrieve the data pushed from their own ERP and then pulled trought Drive File stream and other add-on directly into files. Consolidation comes in real time at every single input and Currency exchange are update every 20 minutes. Elimination tool for Intercompany sales is in place. So, a very flexible and user friendly tool for quick reporting, both for actual and forecast, for many kind of reports.
$ 200 USD/hr
NEW FREELANCER!
