Dustin Wheeler

Dustin Wheeler
Dustin is a technology-driven CPA in Orem, Utah.

Social Media

Follow me on Twitter

Excel's set precision as displayed option

When I was in first grade, I learned that 2 + 2 = 4.  Excel, who I have come to know and trust, thinks the answer is five.  How is this possible?

The truth is told after I increase the decimal places shown for each of these cells.  The twos on the spreadsheet really aren’t twos after all.  They’re 2.43 and 2.35, which both round down to two.  The sum, 4.78, rounds up to five.

To fix this kind of rounding difference in …

Continue reading Excel’s set precision as displayed option

The Two Old Accounting Books on my Shelf

There are two books on my office shelf that mean a great deal to me, but I never read them.  Sure, I might flip through the pages once in a while, but I don’t use them for reference.  They are horribly outdated.

One is titled Accountants’ Handbook, published in 1956.  The other is Principles of Accounting – Advanced, published in July 1955.  My Grandpa signed the inside cover of the latter with the date 8/21/1957.

Inside the books are several bookmarks.  Grandpa …

Continue reading The Two Old Accounting Books on my Shelf

One Idea for Learning QuickBooks Better

Sometimes, business owners, accountants, and bookkeepers have asked me the simple question, “How can I learn QuickBooks better?”  A satisfactory answer to their simple question can be complicated, however.  My response is that it depends on how the person best learns.  I suggest that attending training seminars might work best for some.  For others, reading the manual could be helpful.  The follow-up question I am asked is usually, “well, how did you learn it?”

My interaction with QuickBooks early in my …

Continue reading One Idea for Learning QuickBooks Better