How to Audit Utility Expenses<\/h2>\n
Following is a step-by-step explanation of how to perform an audit of a property’s utility expenses.<\/p>\n
- \n
- Download all bills from the utility company’s web site (which looks like it was created in 1997).<\/li>\n
- There are three utility accounts, so download all three.<\/li>\n
- Open them as spreadsheets. (It will look like this.<\/a>)<\/li>\n
- Be confused for a while, then realize they’re all the same file. (I downloaded the same file three times!)<\/li>\n
- Swear at computer, then delete two of the files.<\/li>\n
- Sort by date.<\/li>\n
- Highlight in yellow the months in which there are three payments (because we expected there would only be two).<\/li>\n
- Sort by account number and date.<\/li>\n
- See that only one account number is completely highlighted, meaning it is a newer account.<\/li>\n
- Sum the total paid, then calculate the average.
\n![\"businesswoman](\"https:\/\/www.biggerpockets.com\/blog\/wp-content\/uploads\/2019\/02\/calculator.jpg\" "\\"\\"")
<\/li>\n- Think to yourself that you paid much<\/em> more than you should have.<\/li>\n
- Look at bills again, especially if you think a few are really high.<\/li>\n
- Realize the bills indicate a cumulative<\/em> total. That is, if we missed a bill, the next month’s bill was for the total\u2014not just the amount in that month.
\n(We missed some payments because our former property manager did not pay them for a few months. We did not discover this until after we fired her for other reasons.)<\/li>\n- Curse at the electric company for having such a terrible system.<\/li>\n
- Now compare the totals from your bookkeeping (i.e., QuickBooks) to see how the downloaded total compares with the actual payments.<\/li>\n
- Calculate monthly consolidated payments. (In ours, see that Dec. 28 is much higher than other months.)<\/li>\n
- Check statements from months with higher than normal balances (for us, this meant statements from December).<\/li>\n
- Dig deep. (When we did, we found that our books matched the statements, and there were no unreasonable charges.)<\/li>\n
- Note any discrepancies. Were you due any credits that were never awarded to you? (It turns out the local housing assistance authority had not been paying us the cost-of-living adjustment they agreed to for one of our tenants.)<\/li>\n
- Start the process of calling this to the attention of the appropriate party to be resolved.<\/li>\n<\/ol>\n
Glamour level: 1,000!<\/p>\n
Related: <\/em><\/strong>6 Ways to Save Energy (and Money) on Your Vacation Home Rental<\/a><\/em><\/p>\n
![\"Close](\"https:\/\/www.biggerpockets.com\/blog\/wp-content\/uploads\/2019\/04\/loan-calc.jpg\" "\\"\\"")
<\/p>\nThe Bottom Line<\/h2>\n
Okay, I’ll admit asset management is roughly as glamorous as a root canal. No one will ever mistake me for Chris Hemsworth.<\/p>\n
But one thing I can guarantee you is that behind every glamorous asset\u2014be it real estate or a multimillion dollar career\u2014there is someone whose job it is to make sure they’re not getting ripped off. Even glamorous movie stars and pro athletes make catastrophic financial mistakes, and the simple reason behind it is they are not managing their assets well.<\/p>\n
Details matter. I spent two hours on this problem, but it will end up saving us approximately $250 per month! Over the course of a year, that’s $3,000 on the bottom line. If I sell this property at an 8 percent cap rate<\/a>, we’re talking about $37,500 in additional equity value.<\/p>\n
So maybe asset management isn’t the most glamorous thing in the world, but who needs red carpets? Unless it means extra zeros in the bank account, Netflix and chill is all the glamour I need.<\/p>\n
![\"\"](\"https:\/\/www.biggerpockets.com\/blog\/wp-content\/uploads\/2017\/08\/blog_ads-02.jpg\" "\\"\\"")
<\/a><\/p>\n