This functionality is not restricted to the financial accounting packages, but is available across the entire Macola ES suite. This link allows you to generate your own overviews in Microsoft Excel using Macola ES data. You can make your own calculations using the data in the Macola ES database without having to type or export it. After adding transactions in Macola ES you just refresh your worksheet, giving you immediate, up-to-date, dynamic reporting capabilities.
E-Excel Add-in lets you build your own reports using a wizard or standard formulas. These formulas let you determine which information you want to retrieve, such as a customer's outstanding items. In doing so you can add your own variables, such as customer number, financial year or date. These functions assist you in dynamic reporting
Integrated Menu Options in Excel
E-Excel Add-in gives you several extra menu options in Excel so that you can work with the information directly from Macola ES. These let you exchange information with Macola ES to retrieve your own or standard reports. With these menu options, working in Excel with information from Macola ES is user friendly and fast.
Administration Information
Using the information button lets you retrieve information like standard financial year, lowest and highest financial year from any one of your com- panies. This lets you easily select the right company for retrieving standard reports or for setting up your own report. You can also open multiple com- panies at the same time.
Search Function
Using the information button lets you retrieve information like standard financial year, lowest and highest financial year from any one of your com- panies. This lets you easily select the right company for retrieving standard reports or for setting up your own report. You can also open multiple com- panies at the same time.
Download a factsheet on Excel Add-In
Have a question reguarding the above information please feel free to contact us: info@msmpc.com