Skip to content
Posts Tagged ‘Worksheet’
How To Create Clean, Lean Monthly Financial Reports
Here’s how to turn a lengthy financial report into an executive financial summary
Finance (Photo credit: Tax Credits)
In my last blog I discussed the importance of lean month-to-month financial reporting. Now, I’ll tell you how to generate a lean and clean financial report.
Many CEOs wade through a lot of unnecessary financial detail that clutters their thinking and eats up time.
What the CEO really needs to see are sales figures and gross margins. They tell him or her the amount left over to cover the overhead and produce a profit for the owner.
Overhead Metrics
The first metric a CEO needs to know is the average monthly overhead cost. The second is the percentage of that average monthly overhead compared to sales.
If the average monthly overhead-to-sales percentage is moving up, the company better be generating more sales to cover overhead, or know the reason why it‘s not. In short, if the numbers are moving in ways unfavorable to the company, the CEO can begin to identify the problem and take steps to address that issue.
The worksheet design can be tailored to the company using the spreadsheet’s capabilities. When working with a company, my discussions with its CEO and my analysis of current financial statements will help me shape this monthly financial report into a format easily understood by the CEO.
Moreover, I can walk him through the way I designed the worksheet and how I interpret its numbers. That will allow the company to create the same kind of worksheet, month by month and year by year. That CEO will sleep better at night, because he understands what he’s looking for when reviewing those month-to-month and year-to-year worksheets.
If you would like help replacing one-inch financial reports with easy-to-peruse month-to-month worksheets, please contact me. I offer a 100 percent guarantee on my work. I take on only clients I can help. Call me and let’s talk about your business. My phone number is 630-269-7646.
A Time-saving Financial Tool for Better Financial Reporting
How to generate a financial report that provides better financial insights
I was invited to breakfast one morning by a CEO of a food service company. She came to the table armed with an inch-thick sheath of papers, and told me the stack represented her controller’s financial statement.
“This is too much to deal with,” said the successful businesswoman. “I can’t make heads or tails of it. And you know what? I receive a financial report like this every month!”
I told her I’d take the stack back with me, and return with a financial tool presenting the data in an easier-to-absorb format. At our next meeting I handed her the month-to-month worksheet I’d designed and said, “Rather than going through a dozen of those inch-thick stacks every year, let’s take the critical top-side income statements and line them up month-by-month on this one sheet of paper.”
Before delivering it to her, I’d dropped in the April numbers to serve as a guide, with the other columns remaining blank. I told her to give that worksheet to her controller, and have him complete it month by month.
Saving Time for the CEO
I only wanted her looking at the top-side numbers, not all the other detailed figures. I just wanted her to deal with total revenues month-to-month, the gross margin month-to-month, and the total overhead month-to-month. The top-side numbers were what she needed to gain key financial insights.
The worksheet was designed to display the actual numbers reported and the numbers that had been budgeted for the month. She had 25 different operating units, all of them captured in columns on her spreadsheet. She could skim across those 25 columns and quickly see how her company was doing.
As part of this financial tool, I had also calculated a few financial ratios and percentages. She could compare one operating unit versus another, and examine the gross margin percentage. That would tell her how one operation was performing versus the next. The same thing was done with operating costs as a percentage of sales. That told her how each operating unit was managing costs, and whether each one was performing as projected.
Using this important financial tool made the CEO more productive. First, she saved time, because she no longer had to wade through inch-thick monthly reports. Second, she had crisp financial reporting that indicated specific, targeted issues to discuss with management.
Deeply appreciative, she said, “Y’know, after all these years of being in the food service business, I finally understand what my numbers are telling me.”
In my next blog, I’ll explain how this time and labor-saving financial tool can be created for your own company.
