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

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 handled by Solver, a knowledgeable VAR or your IT staff.

Implementing BI360 One Stop Reporting and Data Warehouse provides the follows 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

There’s my sales pitch…. So get on with it already and show me the user what I can do with the product is what you’re saying about now. Building a report would make for a pretty big blog enter so I’m just going to provide as screen shot of the Income Statement that I created with the One Stop Reporting add-in for Excel.

In this first screen shot, I’m showing what the designer view looking like in One Stop Reporting. The blue arrow on the left is pointing to the Report Designer area where I would find the fields that I will be dragging to my report. The Black arrow in the middle is the body of the Excel sheet and where I drop my fields to. In this case I would drop Accounts from the Chart of Account on the rows, their Description and the Amount value for that account. I then drag the Period function above the values in columns D and E so when I run the report I can do it for a user definable time frame. I then add Excel formulas for the variances and conditional formatting to column F. Excel Charts where adding for the major Income Statement categories.


The results of all this work looks like this


I’ve had fun with this BI blog series and I hope you did too.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s