Tag Archives: Statement of Cash Flow

Planning, Budgeting, & Forecasting: Why Tradition May be Dangerous – Part 2

Be open minded and explore opportunities for change

In the first part of this blog article we looked at the traditional approach to planning and budgeting and recognized a number of flaws, regardless of how sophisticated some of the modeling capabilities of several of the leading solutions were.

This raises a fundamental question:

Is having an infinitely complex model with unlimited reporting capabilities but with high maintenance costs and dependence on outside consultants and with no ability to really gain insight into the future financial health of the organization superior to having a somewhat less capable modeling solution but one that is user maintained and with no modeling formulas, functions and links, one that automatically provides management with a Balance Sheet and Statement of Cash Flows that are always  synchronized in real time to the P&L and its underlying budget?

This is a very long question but in reality it is a very simple one.

  • What are management’s priorities?  
  • What is really important (or should be) to them?  

As the title of this article implies, relying on older, traditional methods can actually be dangerous to the company and its management since it can mislead them to make incorrect decisions when there is no real visibility into the company’s financial future.

Furthermore, the few applications that claim a forecasted Balance Sheet can be programmed may mislead users who desire such a report and perhaps even rely on it. As has already been discussed in this blog, in order to be able to deliver a complete and accurate Balance Sheet for all budgeted periods, the planning and budgeting software must have a built-in GL, just like its accounting software counterpart, Why have a General Ledger in a Budgeting Software?  To this date, I have not seen a planning / budgeting software solution that has such a GL by design, except for one application, Budget Maestro  from Centage Corporation.

System Generated Balance Sheets & Statement of Cash Flow

I cover a lot of my experiences with Budget Maestro in this blog. I feel very fortunate to have found a solution that is 100% user maintained, free from the worry of programming and managing endless sets of formulas and links, yet a solution able to reasonably model any type of business with very few exceptions. The real bonus I get with this software is the system generated Balance Sheet and Statement of Cash Flows that are automatically updated in real time with every change in the budget. With these capabilities come many additional noteworthy benefits as you can read in this blog, such as:

Forecast and Monitor your Key Financial RatiosForecast and Monitor your Loan Covenants ComplianceHow much of your credit line can you tap? and Generate Accurate Forecasted Financial Statements

Budget Maestro may not be the best fit for a Fortune 100 company, but it is certainly perfect for the many SMBs (small and medium businesses) in search for a way to better manage their organizations with greater insight into their financial future. I urge you to be open-minded and see how a traditional budget and analytics process can be transformed with this unique solution.

The Dreaded Statement of Cash Flows

How you can automatically generate an actual Statement of Cash Flows regardless of what ERP software you use

Those who have experienced the manual preparation of a Statement of Cash Flows using beginning and period end Balance Sheets plus a periodic Income Statement know that this can be a chore and can cause a little confusion along the way with figuring out how to place the different numbers in the designated sections of this statement.

Fundamentally, the preparation of a Statement of Cash Flows is not that complicated and you would expect all accounting and ERP software vendors to provide a working template with each installation. Many of the software solutions targeted at the small to medium size companies not only do not provide such a template but are not capable of programing this statement and as such, a Statement of Cash Flows is not available to users of these software packages. The result is that a Statement of Cash Flows is not produced in many small and even medium size organizations.

Many companies that are required to submit a periodic Statement of Cash Flows, either because they are SEC filers or their lender asks for it, must produce this statement manually for each required period.

I’ve talked to several ERP software vendors and their typical response was that their GL software was not designed to automatically produce a Statement of Cash Flows because there is no way to tag each GL account with the proper treatment for this statement (i.e., how to use each specific GL account activity or changing balance in the compilation of this statement). This confirms that users of these vendors’ software have to perform this chore manually; that is, if they care to do it at all.

I’ve devised a way to automatically produce an accurate and complete Statement of Cash Flows, in each required period, regardless of what ERP software is used and whether or not its GL can accommodate this statement. To do that I use Budget Maestro from Centage Corporation which is a planning, budgeting and analysis software, primarily designed for small and medium companies in a variety of industries, where actual and budgeted financial statements and various reports can be generated in almost real time from available actual accounting and operations data and existing budget and forecasting data.

Budget Maestro was designed to produce all three major financial statements: An Income Statement, a Balance Sheet and a Statement of Cash Flows for every period included in every version of the budget implemented at the company and consolidated across all business entities that make up the organization.

As such, these financial statements are also available in a special version of the data known as Actual Plan. Here, actual accounting data (e.g., period-end Trial Balance) populate this Actual Plan through an export from the ERP GL or via a direct link available for several of the more popular SMB ERP software.

If you transfer your closed period (e.g., month) GL account balances into the Actual Plan in Budget Maestro (something you really need to do to be able to perform analysis of Budget vs. Actual), you will automatically gain access to all three financial statements (plus many other reports you can set up in the system). The actual Statement of Cash Flows will automatically be generated and available to publish. It will be complete and accurate and you will have the choice between using the Direct Method or the Indirect Method.

The secret to accomplishing this in Budget Maestro is careful planning of the chart of accounts and reporting format. This should closely match the setup of your actual GL and its reporting hierarchy. From that point on it is only a matter of periodically performing the data transfer and updating Budget Maestro with any changes to the chart of accounts as they occur in the ERP GL.

Existing and new users of Budget Maestro now have a viable and practical option to generate an actual period Statement of  Cash Flows. This should no longer be a mystery to many accounting and finance managers and depriving company executives of vital information about the financial performance of their organizations should no longer exist.  Furthermore, by using Budget Maestro as an all-encompassing budget solution, The Benefits of an All-Encompassing Budget, company managements can finally gain real insight into the future financial health of their organizations.