One important thing to consider when selecting a business management or ERP system is how well it works with Microsoft Excel so you can work, report, analyze, and improve processes in the Excel environment you and your team are already familiar with. If the system natively integrates with Excel, you gain both tactical and strategic benefits. If it doesn’t, or if the only ways to connect require some extra add-on software or programming, it’s a big disadvantage.
Microsoft Dynamics 365 Business Central delivers two-way Excel integration, enabling you to export to Excel, make changes, and then publishes back to Business Central. Here are the top 3 benefits of two-way Excel integration:
Exporting Financial Data to Excel
Inside Business Central, you can easily get to a list of Excel reports that include a Balance Sheet, Income Statement, Cash Flow Statement, Retained Earnings, Trial Balance, Aged Accounts Payable, and Aged Accounts Receivable. A pre-formatted report launches and loads the appropriate data from Business Central. You can also copy and paste data from Business Central into Excel.
Working with Customer or Vendor Records in Excel
Another example is the ability to open or edit data in a vendor or customer window in Excel. When you select “Edit in Excel” all the information is populated in a pre-formatted Excel worksheet. This is handy if you have lots of data you need to update and you want to do it in bulk rather than having to go into each individual Dynamics 365 Business Central record and do it. Once you add new data to the fields you need updated in the Excel file, you can “publish the worksheet” and it will automatically fill in the appropriate fields in the ERP system.
Use Excel to Report on Data in Business Central
You can also use Excel to report on data that comes from your ERP system. Once there is a data connection between Dynamics 365 Business Central and Excel, you can use Excel’s reporting and charting capability to configure the data the way you want. For example, you can create a Pivot Table, choose fields to add to the report, and more. Data can be refreshed to ensure the reports and charts you create in Excel are always up-to-date with the data in Business Central.
To see how these two examples work first hand, watch this mini-demo: Business Central’s Integration with Excel (11:02).
There are many other examples of the power of integration within Dynamics 365, for example, Business Central’s Integration with Outlook. To see all of the possibilities, click here to tour Dynamics 365 Business Central.
This content was originally published here.