Skip to content

Can You Trust Your Financial Reports? Here Are Two Tools To Help

Can You Trust Your Financial Reports? Here Are Two Tools To Help

In the first two days of August I had on-line meetings with four clients all in a panic because gross profit margin for the first six months of the year varied widely – from -55% to +104%.

And they should be panicked – how can you trust your numbers with that kind of variance? You can’t – no way!

Because all four remodelers were following Remodelers Advantage best practice and calculating Over/Under Billings every month, their gross profit margin variances should be small – IF the O/U calculation was correct.

In each case there was a “NON best practice” in play which produced much of the wild swings:

  • Posting backward after the O/U journal entry had been made;
  • Estimated labor costs not equal or even close to actual labor costs;
  • Incorrect WIP at the end of prior year;
  • Numbers used on spreadsheet to calculate O/U not tied to accounting data;
  • Incorrect calculation of estimated cost to complete;
  • Posting of job costs not in the month in which the work was done.

So, how can you determine if you’re doing everything right?

Here’s the test

margin variability tool

In the Margin Variability Chart (above) enter the gross profit margin from the profit/loss from your accounting system January to June. There should be no more than 2% plus or minus variance month to month.

Here’s another test

Golden Triangle Online Tool

In the Golden Triangle Chart (above) enter the gross profit margin from three different places. Again there should be no more than 2% plus or minus variance month to month.

Both tests prove the accuracy of your job cost postings AND over/under calculation.

What should you do if you fail the tests?

The first thing would be to make sure you’re not doing one or more of the “NON best practices” listed above. If you are, fix it. If you’re not, (or you don’t know how to fix it on your own) then you should set up a call with us – right this minute!

Share:

>

Opt Out

I confirm that I am choosing to opt-out of the new Roundtables membership, henceforth referred to simply as Roundtables (“Roundtables”).  

I understand that my current membership will not change and will be henceforth referred to as RT Legacy, Roundtables Legacy, or simply Legacy (“Legacy”). I understand that by opting out I will not receive the additional benefits offered to Roundtables membership and will not receive the bonus PSCs.  I acknowledge that if I choose to upgrade at a later date, I will not receive any bonus PSCs above the standard issue.

By clicking below, you opt out and will be locked into the Legacy program for 2021. You will not receive an increase in dues, other than our standard inflationary annual dues increases. You will have the opportunity to opt in for the 2022 membership year. However, there will be no bonus given to future opt in cycles.

Please note that if you cancel your membership, you forfeit access to Legacy membership in the future. You may rejoin only as a Roundtables member.

Hey there!

Login To Come In

Member Support

Roundtables Application

Let's do this