Using Excel with your company's accounting software is an economical way to create reports and dashboards, which will allow instant visibility for users who may need to run periodic reports. Linking Excel to your accounting software is not for the faint of heart. However, with the aid of MS SQL Server as your primary database, it will work seamlessly. Out of the box, MS SQL Server comes with countless Excel based reports, in addition to an Excel Report Builder option which will let you create your own reports.

 For more information on using MS Excel with MS Dynamics GP, Accolade offers two options: Excel Report Builder and Creating Reports with SSRS for MS Dynamics GP.