ERP Software Logo

Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

KTL Solutions

Business Intelligence (BI) Tools and Their Use with Microsoft Dynamics GP


    Email | Print

    Using Solver’s BI360 One Stop Reporting Financial Statements to perform a more automated financial statement variance analysis process

     Part 5 of a 5-part series

    By Barry Crowell, Senior Business Consultant at KTL Solutions, Inc.

    For my final post in this series, I’m going to look at one of my favorite Dynamics GP Business Intelligence and financial reporting tools.  Solver’s BI360 software is an Excel and Web-based Business Intelligence Suite.  BI360 integrates with many major ERPs right out of the box via a real-time connection.

     

    These include the following:

    • Microsoft Dynamics AX, GP, NAV, SL, C5 and MS CRM
    • Sage MAS 500, Sage X3
    • Prophet 21
    • SAP Business One
    • Acumatica
    • Intacct
    • NetSuite
    • Salesforce

     

    BI360 Data Warehouse software has pre-built modules (fact tables) for general ledger, payables, accounts receivable, revenue, fixed assets, projects and human resources.  Plus they have five custom modules that can be configured by business users.  Loading of the data warehouse can be handled by SQL Scripts or SSIS package files and can be managed by Solver, a knowledgeable VAR or your IT staff.

     

    Implementing BI360 One Stop Reporting and Data Warehouse provides the following benefits:

    • One Stop Reporting
      • Drag and drop report design
      • Excel-based reporting with complete excel formula and formatting functionality
      • Live operational connection reporting to all ledgers and sub-ledgers
      • Benchmark, KPI and graphical reporting
      • Drill to general ledger detail and drill across to sub-ledgers
    • Data Warehouse
      • Drag and drop report design
      • Excel-based reporting with complete excel formula and formatting functionality
      • Benchmark, KPI and graphical reporting
      • Consolidation reporting
      • Excel based budgeting and forecasting
      • Modeling and "what if" analysis

     

    I know what you’re thinking – “get on with it already and show me what I can do with the product.” Building a report would be a lot for one blog, so I’m just going to provide a screen shot of the income statement that I created with the One Stop Reporting add-on for Excel.

    The first image shows what the designer view looks like in One Stop Reporting.  The blue arrow on the left is pointing to the report designer area where you would find the fields you will drag to your report.  The black arrow points to where you drop our fields in the spreadsheet.  In this case, you would drop accounts from the chart of account on the rows, their description and the mount value for that account.  You would then drag the period function above the values in columns D and E, so when you run the report, you can do it for a user definable time frame.  Then add Excel formulas for the variances and conditional formatting to column F.  Excel charts where adding for the major Income Statement categories.

     

    ktlblog1

     

    The results should look like this:

     

    ktlblog2

     

    I’ve had fun with this BI blog series and I hope you did too.  If you would like help with implementing Solver’s BI360 or just want to see a demo, please contact [email protected].

    by KTL Solutions

     

    Comments are closed.