I have a client that operates a business with about 6 entities that need to be consolidated (different currencies and will report in US$). A key element is also forecasting into the future at least 3 years. They also want to undertake revenue analysis such as top 10 customers each month, revenue by project etc. All the data is currently exported to Excel and we are alooking for software we can upload the data to and undertake the consoilidation, forecasting and revenue analaysis.
I have looked at Fathom and Spotlight, but I believe these are limited in the revenue analaysis department and require more input than may be necessary for inter-company eliminations with foreign currency balances.
Does anyone have any recommendations for software that can do all we arer looking for? If not, any advice on what could be used for the revenue analaysis tools would be most helpful.
If it helps, they use various software across the companies and export to Excel but may look to move to a single package in future (Xero possibly).