Hanna Kim
Budgeting for Manufacturing Companies with Sage 100

This article will discuss budgeting solutions that can expand your Manufacturing planning processes with Sage 100.

It is becoming clear today that Business Intelligence (BI) analytics tools are becoming more important as it is the way to turn important data into dynamic decision-making for the future of the organization. There are various software choices that can assist manufacturing companies using the Sage 100 enterprise resource planning (ERP) system in taking their budgeting to the next level, whether you choose to design your own model in Excel, rely on native Sage functionality, or select an independent software vendor (ISV) tool. This article will focus on the top features and functions in modern budgeting software that will impact the way you manage and analyze data for your manufacturing company.

Continue reading

Hanna Kim
Excel-based Budgeting Tools versus Web-based Budgeting Tools (Budgeting Series)

This article focuses on the difference between Excel-based and Web-based budgeting tools.

Choosing the right budgeting tool is extremely important for a growing company. Many financial companies use homegrown Microsoft Excel models extensively in their budgeting, but there are some limitations that are inherent in the application. I admit Excel is a great tool for modeling and analysis, but it is not the best tool to use for budgeting. Software companies are developing commercial budgeting tools that are Excel-based and Web-based to stay familiar with the features and functionalities that most professionals are accustomed to. In this article, we will explore the advantages and the drawbacks of both Excel-based and Web-based budgeting tools that organizations experience. This article is the third installment of our series on budgeting: Excel-based Budgeting Tools Versus Web-based Budgeting Tools.

Continue reading

Hanna Kim
Best Report Writers for Sage 100

This article focuses on modern features and functionalities for financial reporting, so you have a better understanding of what to look for when seeking a tool to improve your experience with Sage 100.

Trend in Business Intelligence for H2 2015

Photo taken from Shutterstock.

In today’s data-driven world, your organization needs a powerful financial reporting tool to help you stay competitive in your industry.  In this article, I will explore the Business Intelligence (BI) options you have for software, specifically looking at feature and functions, so you can select the best reporting tool to navigate your organization-specific issues in managing and analyzing your data as a Sage 100 user.

Continue reading

Matthew Felzke
Is Forecasting Becoming More Important than Budgeting?

This article will discuss the difference between forecasting and budgeting, specifically in the context of which process might be more important to modern business planning.

Recently, I was talking to a finance professional who oversees accounting processes and helps his organization make decisions about the future in regard to budgeting and forecasting.  He posited that forecasting might be more important to running a business today than traditional budgeting – and it made me think.  I’m always writing about the constantly evolving world of technology and the fast pace of today’s business culture, so shifting away from a traditional way of accomplishing data management and analysis tasks sparked my interest.  Thus, this article will explore the differences between budgeting and forecasting to hopefully arrive at a better understanding of what is more impactful and productive to business today.

Continue reading

Matthew Felzke
Let’s Talk about OLAP Cubes

This article is going to tackle OLAP cubes as a solution concept for Business Intelligence processes, within the context of other BI data store options.

Let’s do it – let’s talk about OLAP cubes.  With the amount of data only growing, exponentially for some, Business Intelligence (BI) data stores are becoming more and more prevalent – and are sensible ways for modern organizations, companies, and corporations to access, store, and organize company data for financial reports, budgets, and dashboards, as well as financial consolidations.  Whether you’re relying on a data mart, data warehouse, or an OLAP cube, your data queries won’t slow down the Enterprise Resource Planning (ERP) system, and you can grab multiple types of data to enrich and broaden your analyses.  But this article will specifically zoom in on OLAP cubes.  Who manages them?  What are they? When do OLAP cubes come into play?  Where are they staged? Why would you choose an OLAP cube over another BI data store?

Continue reading