Imagine this: You’ve had a really good year so far, after the mess of the last couple years. Top line revenue looks much better than expected. New business is up, returning customers are buying again, and your sales team are feeling great about the prospects for the balance of the year. Only one problem: Net Income is  a lot less than you would have expected, and you don’t know why. But the urgency created by the surge in revenue puts the question aside – it will work itself out as long as the sales success continues.

Not so fast…

Maybe that’s exactly the time you need to stop and ask yourself: Am I missing something? Just because there isn’t an easy and comfortable explanation, do I push past it and hope it all works out in the end? Alternatively, How do I pour over the mass of information in the accounting records to isolate the reasons income isn’t matching sales?

The answer could be the difference between a foundational year that lays the groundwork for years of outsized profits or the start of a ‘work harder just to keep even’ approach that sooner or later burns you out. This may be the perfect time to make that choice.

Here’s my suggested method for isolating all that data into pockets that provide answers instead of just questions. We’re using this technique with clients across the country today, and the results are reassuring, encouraging and most importantly, informative:

1. Ask your accounting team to put your P&L trial balance into a spreadsheet with 5 columns:
   1. Column 1 – actual amounts recorded to each account so far this year
   2. Column 2 – what you expected to see in that account at this point (obviously much easier when you’ve developed a budget or profit plan at the beginning of the year, but lacking that use your best estimate of what you expected to earn or spend)
   3. Column 3 – the difference between the two, the variance if you will
   4. Column 4 – Your part: enter here the question you want answered based on what’s in Column 3
2. Have your accounting team go back and research the most impactful answers to those questions. Have them ignore all variances that are less than 10% out of line with expectations. This is not a laundry list of small differences but the 1 or 2 reasons they see that account for most of each line item variance, whether positive or negative (because you want to know both, no?). Ask them to record their summarized responses in Column 5.
3. Now, sit down with your team – this should ideally be your accounting team and your key management team who will often be able to shed light on aspects of the responses that are beyond the knowledge of your accounting team. Having that all happen in the same room at the same time makes everyone instantly smarter.
4. Now, decide if any of that valuable information guides you to make any changes in how business is conducted for the balance of the year. You will either see an increase in net profit margins or a clear vision of the changes that need to be made for next year. Maybe even a more formalized process for developing and implementing a 2023 profit plan (“Budget”).

Would that be such a bad idea? Ask our clients who’ve tried it and (sort of) love it.

We are Your CFO for Rent.