Facebook Twitter LinkedIn Google+

The Sneakiest, Most Ingenious Way to Steal From Your Company

Originally published: 05.01.17 by Ruth King

Putting systems in place keeps the honest people honest. I discovered this really sneaky and ingenious way to steal from your company when a contractor called me and asked if I would help him make sure his pricing was correct.

I said yes and asked him to send me his year-end Profit and Loss Statement and Balance Sheet for the past two years.

When I got his financial statements, I put his expenses in my overhead calculation sheet to calculate his overhead cost per hour. The expense totals didn’t match what was shown on his profit and loss statement.

At first I didn’t believe it, even though it was Excel — and Excel never makes an addition mistake. So, I added up the numbers on an old fashioned adding machine. Numbers didn’t match.

I realized that this was the most, unfortunately, creative way to steal I had seen in more than 30 years. No one, including me, thinks to put the numbers you see on your profit and loss statement into an Excel spread sheet to ensure the numbers match. Until now.

Fig. 1 shows the numbers from the company’s profit and loss statement in comparison to the numbers that I calculated.

You can see

the differences.

There are some categories, such as auto expenses, where the spreadsheet matched the numbers on the contractor’s profit and loss statement. There were many more, however, that didn’t add up.

Fig. 1 (click to enlarge)

When you total the numbers, my calculation was $51,765 less than what was stated on the company profit and loss statement.

Long story short — the contractor’s P&L said expenses were $637,510. The Excel spread sheet added to $585,745. There was more than $51,000 missing!

But, you say, how do they get away with it? It’s easy to create journal entries to change the numbers on your financial statements because journal entries never appear on your financial statements.

Decrease the expense. Decrease the cash. Or, create a business checking account with a legitimate sounding name and write checks to that account. Or, if you have petty cash and don’t reconcile it, that is an easy way for the embezzler to steal.

Remember this is only a few hundred dollars taken from many different accounts over a year’s time period. The busy contractor who doesn’t pay attention never catches it.

This is a great way to steal from you. You almost never add up the numbers on the P&L. You assume that they are right … $51,000 out the door is easy to hide because of your assumption. A few dollars here. A few dollars there. No one will ever catch it!

Keep the honest people honest by entering your expenses stated on your P&L into an Excel spread sheet. You don’t have to do it every month. You should do it a few times a year.



About Ruth King

Ruth King

Ruth King has over 25 years of experience in the hvacr industry and has worked with contractors, distributors, and manufacturers to help grow their companies and become more profitable. She is president of HVAC Channel TV and holds a Class II (unrestricted) contractors license in Georgia. Ruth has written two books: The Ugly Truth About Small Business and The Ugly Truth About Managing People. Contact Ruth at ruthking@hvacchannel.tv or 770.729.0258.

Articles by Ruth King

‘I Made a Profit — Where’s the Cash?’

There are times your company shows a profit, yet you have problems scraping enough cash together for payroll.
View article.


Try a New Pricing Level, Improve Your Bottom Line

Add your overhead cost per hour and your direct cost per hour. This is the absolute minimum price you must charge your customers.
View article.


Build Your Pricing Around Net Profit Per Hour

The key to pricing using net profit per hour is that you must estimate labor hours correctly.
View article.


Vanity Metrics vs. Clarity Metrics

There are many metrics to track, however, none are as important to profitability than current ratio, acid test, productivity ratio and net profit per hour.
View article.


Five Activities that will Make a Difference in 2018

Profitability is the key to survival. Here’s five things you can do to ensure profitability in the New Year.
View article.