AccountsMate Feature – Excel Integration
AcocountsMate allowed exporting Sage 50 to Excel (and other sources) from its original design, but the Excel Integration feature is the next step which allows combining Sage 50 data with Excel features (e.g. formatting, formulae, macros, etc.).
Using this, users can create customised Excel reports from live Sage 50 data.
The video link below demonstrates creating a customised Profit and Loss report with live Sage 50 and Excel functionality.