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

Five QuickBooks Preferences That Could Make Your Life Easier

With one click of a mouse button, I’ve been able to help some clients be more efficient in their use of QuickBooks.  It’s worth taking the time to look through the preferences in QuickBooks and adjust them to your liking.  Below are my top five QuickBooks preferences that you should know about!

Turn off pop-up messages for products and services (under General – My Preferences) – This is new in QuickBooks 2010 R5.  If you’re new to QuickBooks and want to …

Continue reading Five QuickBooks Preferences That Could Make Your Life Easier