Back when I first became an auditor, I learned that there are times when you need a truly random number…no human bias. In this post, I share with you exactly how to do this.
How to make a Random Number Generator in Excel
QuickBooks has a Secret Calculator
It has been a long time since I posted anything, but I’m back in the saddle. Here is the biggest QuickBooks thing I’ve learned over the last 8 months: QuickBooks has a built-in calculator!
How to Print a Clean Report in Excel by clicking one Check Box
Whenever I presented reports, I would warn people about the colors. I’m color blind so I usually pick very contrasting colors.
I always thought of the colors as a help…because they help me. They can also be a distraction or even a nuisance if you are printing in black and white. I recently found a solution for keeping my colors but printing a clean report for the recipients.
Spreadsheet to Adjust for Inflation
If you like data like I do, you can’t ignore inflation. I have spreadsheets with decades of financial data. When you adjust those numbers for inflation, it can be very insightful. In this post, I share with you my Inflation Adjuster spreadsheet.
GMC Clergy Compensation
I’ve been receiving quite a few calls from pastors and church treasurers who are struggling to fill out their clergy compensation form and calculate the cost of benefits. The GMC has some great resources to help.
QBO and issues with recording Credit Card Payments
I really enjoy how easy QuickBooks Online makes it to keep your bank accounts reconciled. The transactions can be imported automatically. QBO helps you code them.
It works pretty much the same with with credit cards…except for one annoying problem.
How to fix the rounding problem with monthly budgets
Accountants and bookkeepers are usually bugged by the littlest things. I know a number of people that will spend hours looking for pennies when reconciling their bank statement. Along those lines, one of the things that bugs me is when you have are creating monthly budgets, and the rounding causes you to be off by pennies. For the longest time I would manually correct this when I had time. Now I have a better soluntion.