[Cathy Huggett]

Hello all.

We are moving to the cloud and will not be using Management Reporter for financial reporting.
Our two options we are looking at are Jet and Power BI.

I’m looking for pros and cons between the two for financial reports.

Thanks and have a great day.

Cathy

——————————
Cathy Huggett
Accounting Manager
Persolvent/Simek’s
St. Paul Park, MN
——————————

[Steve Erbach]

Hi, ,

Well, for financial reporting amongst your two options, Jet Reports is Hobson’s Choice!?

That is, Power BI is an analysis tool and not suitable for the detail involved in a financial statement. Jet Reports is an Excel add-on that allows all the report formatting capabilities of Excel.

Power BI, though very powerful, isn’t meant to present data in a formatted report format.

Here’s an interesting explanation of the differences on the web site of JetGlobal, the makers of Jet Reports.

Sincerely,

——————————
“Sparkly” Steve Erbach – Green Bay, WI
Co-Chair, GPUG WI (Green Bay) Chapter
Blog: https://www.gpug.com/blogs/steve-erbach
Twitter: twitter.com/serbach

—————
Excel Webinar List as of 22-Mar-2019
——————————
——————————————-

[Jo deRuiter]

Is right on, the general rule of thumb is Jet is needed for financial statements because it is an Excel INTEGRATED tool, meaning you can consolidate easily on one line.

You can also get great dashboarding from Jet.

However Power BI is prime for all other analysis with awesome interactive KPI’s.

To play the devil’s advocate, here is a post by on using PowerBI for Financials…I enjoyed it!

https://www.njevity.com/2018/11/07/not-your-daddys-financials-webinar-series/ 

.??

——————————
Jo deRuiter, MCP, DCP
“That GP Red Head”
AISLING DYNAMICS CONSULTING, LLC
WEBSITE: https://aislingdynamics.com/
BLOG: https://community.dynamics.com/gp/b/gplife
770-906-4504 (Cell)

——————————
——————————————-

[Steve Erbach]

,

Excellent. I’m going to watch that webinar later??. I’ve done some stuff with Management Reporter linking to Excel for Cash Flow statements, but I’m curious to see how Power BI would represent it. It might be just the thing to push our Executive Team into considering Power BI more seriously as an analysis tool.

Sincerely,

——————————
“Sparkly” Steve Erbach – Green Bay, WI
Co-Chair, GPUG WI (Green Bay) Chapter
Blog: https://www.gpug.com/blogs/steve-erbach
Twitter: twitter.com/serbach

—————
Excel Webinar List as of 22-Mar-2019
——————————
——————————————-

[Belinda Allen]

Hi Cathy,
It’s true Power BI is more of an Analysis Tool and not a “traditional” Financial Statement tool.  For statements for Financial Institutions and CPA’s, etc. you’re going to want to use Jet Reports.  Jet will enable you the ability to have the same old financial formats that have been around since Abacus.  But I digress.  I love the use of Power BI for what I call “Operational Financials”.  It allows consumers the ability to quickly identify where they need to spend their time, e.g. problem areas, undiagnosed trends, etc.    I’ve been on my own “speaking tour” trying to share this concept with people.  Check out my webinars at https://www.njevity.com/dynamics-gp-training/  – On Demand – Better Reporting.

Let me know what you think.  B-

——————————
Belinda Allen
Business Intelligence Program Manager
Microsoft MVP – GPUG All-Star
PowerGP Online – Njevity, Inc.
——————————
——————————————-

[George Kuntz, MSc]

Hello Cathy,

As others have mentioned, Power BI is more of an analytical tool.  I would definitely go with jet reports for creating financial statements.  However, I did manage to create an income statement out of Power BI, not exactly the most straightforward exercise.

George

——————————
George Kuntz, MSc
Calgary AB
——————————
——————————————-