Benefits of Excel Automation:
- Uses up-to-date data
- Customised report templates
- Increased security
- Save time generating and preparing reports
How does it work?
Simply build your own custom report templates in Excel (or use existing ones). With a live link to Evolution Mx, any data stored within the system can be pulled directly into Excel, meaning that your reports will never be out of date.
Changing criteria, such as periods, on the spreadsheet will automatically update and refresh the data accordingly, meaning you don't need to create a new report every month.
Excel Automation also eliminates the need to manually export data over from Evolution Mx.
Some examples of common uses of our Excel Automation module include:
- Reports on contract information (e.g. summary cost, budget and sales balances)
- Management reports including Profit & Loss & Balance Sheets