Downloading to Microsoft Excel

Downloadable Areas of Mamut Validis

The following reports are downloadable to Microsoft® Excel®;

• The four main analysis reports, Accounting Rules, Trend Rules, Unusual Combinations and Exceptional Values.

• The Statement Summary

• Variance and Ratio Analysis. Read more here.

How to download your Analysis Reports to Microsoft Excel

1. Click on the Export to Excel button at the top-right of the screen.

2. In the File Download window that appears select Open or Save to view the file. The information is then displayed as a spreadsheet.
   
   You will see the summary worksheet containing the analysis results of your current view. Accompanying the summary worksheets are separate worksheets for each unresolved issue found, enabling you to drill-down to the underlying transactions.
   
   To drill-down to the underlying transactions you can either click directly on the issue you wish to review, or you can select the relevant issue worksheet at the base of the spreadsheet.

3. To save this spreadsheet, select the File - Save As menu option and save the file, with an XLS extension, in the appropriate place on your computer’s hard disk.

Your Analysis Reports have now been downloaded to Microsoft Excel and saved locally.

Downloading your Statement Summary

You are able to initiate a download at the summary level, which will export both the Balance Sheet and the Profit and Loss statements. Alternatively, you can download specific categories of either the Profit and Loss or the Balance Sheet, where issues have been highlighted.

Balance Sheet / Profit Loss Download

1. Click on the Export to Excel button at the top-right of the screen.

2. In the File Download window that appears select Open or Save to view the file. The information is then displayed in Microsoft Excel. You will see the summary worksheet.

3. Click directly on the statement you wish to review or select the relevant statement worksheet at the base of the spreadsheet.
   
   You will only be able to drill-down on issues that have been reported within each of the statement categories, these will be highlighted and underlined. To review these issues, click directly on any of the available categories.

4. To save your exported spreadsheet, select the File - Save As menu option and save the file, with an XLS extension, in the appropriate place on your computer’s hard disk.

Your statement has now been downloaded to Microsoft Excel and saved locally.

Read more about:

The statement summary

The summary analysis dashboard