5 Common QuickBooks mistakes


These are the five most common QuickBooks mistakes I find, when review a new client’s accounting records. Although they’re in no particular order, they are all important because each mistake can mislead the business owner in terms of profitability, debt levels or operational decision making.

1.       Instead of posting business credit card transactions in a credit card type account, the monthly charges, as taken from the credit card statement, are summarized by expense type (e.g. meals, gas, office supplies), and then entered as either a vendor bill or bank check. This makes it hard to audit for mistakes and hard to manage credit card due dates.

2.       True costs associated with performing a service or selling a product are listed as an (overhead) expense rather than as cost of goods sold (COGS). Although fixing this will not change the net profit, it will make the income tax return more accurate, and help diagnose operational issues such as breakeven point.

3.       Customer down payments are received as a temporary overpayment. This causes accounts receivable to become negative, which should never be. The remedy is to create a Customer Downpayment liability account, and post the payment there. When the actual invoice is created, this down payment is removed and posted against the invoice.

4.       Too many expense or income accounts. Technically this won’t lead to an inaccurate financial statement, but it will make it very hard to understand how well or poorly the business is doing. QuickBooks has excellent reporting capabilities, so simplify and condense your chart of accounts.

5.       Fixed assets and depreciation aren’t up to date or accurate. Every time you purchase an asset worth more than $500, or dispose of an asset, you should update the appropriate fixed asset account. If you just started a business, any equipment or furnishings you brought into the business should be listed as a fixed asset. Likewise, every year the depreciation listed on the business tax return should also be posted in QuickBooks. This will reduce the book value of the assets, keeping the balance sheet more honest.

Although these are five common accounting mistakes, there are many other little (and major) mistakes I find when examining a set of accounting records. I can’t stress enough how important it is to seek regular professional advice from a CPA or accountant, to make sure you’re on the right track. You work too hard in your business, not to have accurate financial feedback.


5 QuickBooks mistakes

Posted in: Blog

Leave a Comment (0) →

Starting a business; an informal list of things to consider.

  1. Don’t quit your day job. Wait until you’ve built enough business to support you full time, with full pay. This can easily take up to a year. Most new business owners are overly optimistic about how quickly business will grow.

    2.       Start with your passion. That should far and away be your greatest motivation. If you’re getting into a line of work because of the tremendous opportunity (e.g. my buddy is making a killing at this), you’re doing it for the wrong reason.

    3.       Don’t take on debt, become self-supporting. This is quite debatable, but too often I see a mind-set that assumes or expects the new business will be financed on credit cards, perhaps because they read about a successful entrepreneur that built her business that way. This is playing with fire, so learn to live frugally.

    4.       Expect long hours and lots of hard work. You’ve heard this before, but let me give a few example of how this really manifests itself:

    a.       New to the marketplace, you will need spend 3-4 times more time getting a new customer than if you were established, simply because you have no reputation.

    b.      Because you have no reputation, everyone will be testing you. Vendors may not expect you to be demanding, customers may not believe you’re as skilled as you say you are. You will need to be extremely detailed about every bit of your work (return calls immediately, confirm appointments, etc).

    c.       If you own a retail store, you will need to be the cleaning lady since you probably can’t afford one – extra hours. If you own a professional business, you’re the one that needs to return calls over your lunch break since you can’t afford a secretary… get the idea?

    5.       Learn to live in the present. You’re going to make mistakes or miss opportunities; get over it and don’t dwell in the past. You also need to concentrate on what’s in front of you right now, rather than thinking about how you’re going to open new markets and hire new employees. Do what your need to do today, perfectly.

    6.       Pay yourself as soon as you get sales. Too many new business owners will only pull money from the business when the cash flow can support it. This is both admirable and misguided at the same time. You need to reward yourself through a steady paycheck for two basic reasons. First, the business operation needs to accommodate for your payroll. Pulling money infrequently will make it difficult to predict cash flow. Secondly, you will have a bad day sooner or later. When the chips are down, you can at least console yourself in the fact that you got a paycheck. This doesn’t have to be a huge or even modest salary, just make it consistent and affordable.

Posted in: Blog

Leave a Comment (0) →

QuickBooks 2011 newest release has problems

If upon opening your QuickBooks 2011 program you’ve been notified that Release 8 is available and ready to download, DON’T. Among other fixes, Release 8 was supposed to repair some deficiencies in Release 7. This newest release will cause problems such as:

  • Error 1603, forcing you to reinstall QuickBooks
  • QuickBooks won’t open or stops working
  • Rebuild function doesn’t work correctly
  • Incorrect quantities of inventory items when using Quick Reports

Wait until Release 9 comes out. Call me if you’re suspicious that something isn’t right with your QuickBooks software. I have a few simple tests or fixes that will determine and resolve this.

Posted in: Blog, Uncategorized

Leave a Comment (0) →

Groupon should only be used this way

Too many small businesses have used Groupon like a drug, hoping that an injection of discounted sales will provide needed cash flow today; worrying about the ramifications of discounted sales later. All this of course is under the guise that exposing your business to hundreds of new customers will benefit the business in the long term, or that these Groupon users will decide to purchase more than what’s being discounted, thus raising your average purchase price. There are generally two kinds of business, and Groupon will only work for one of them.

The first business is one with high variable costs. These are expenses that are inextricably linked to making a sale; things like labor and inventory or product cost. In other words, to make a sale you must be either selling some product or performing a service with labor cost tied to that service. Examples would be a retail store, a massage therapist, a computer repair person. Open your accounting program and check your income statement. If you have considerably high Cost of Goods, or if your labor costs are a disproportionally large percentage of your sales, you fall into this group. For these kinds of businesses, Groupon is a bad idea. Your sales are so horribly discounted that you will never recover enough money to cover both the cost of the sale and your overhead expenses. Taking this one step further, don’t assume that these new customers will return, and that over time you’ll recover the cost of the discount. More often than not, a customer that uses Groupon or other coupons will only shop when there is a sale.

The second kind of business is one with very low variable costs, or no cost of goods; a bowling alley for example. Whether they have one or twenty customers, the doors will remain open and the lights will stay on. Adding more bowlers in this example simply helps cover the cost of fixed overhead. There is a point however where it will become a determent, and that’s when the business needs to add more staff, or the new (discounted) customers begin to displace full price, regular loyal customers. An example of this is when a golf course fills all available Saturday slots with Groupon customers, rather than the regular full-paying golfers.

My fear is that too many businesses are agreeing to use Groupon, or any other discounting marketing strategy, without working through the accounting first to determine the real cost/benefit. Rather than doing the hard work to build a truly loyal customer, they are using this as a crutch to help their business survive another month.

Posted in: Blog

Leave a Comment (0) →

Check your checking

I’m often surprised at how often mistakes are made on checkbook and credit card statements. Interestingly enough, even the most careful business owners will miss these hidden errors, costing them a lot of money every year.

It seems that the mistakes boil down to a few common themes:

  1. Fraud – The waitress received a tip of $4.00 but changed it to $8.00
  2. Double swiping – credit or debit card didn’t seem to go through the first time so the cashier swiped the card again, effectively doubling the charge
  3. Bank (or credit card company) error – overcharging bank fees, depositing money into the wrong account, etc.

Recently I complained to Bank of America because my checking account was assessed a $25 monthly fee. I was told that it was a “known issue”, and was refunded six months of bank charges. Shame on me for not catching it sooner, shame on them for not telling me (or the thousands of other customers affected).

Get into the habit of entering credit and debit card transactions into QuickBooks, directly from the receipt. When your monthly statement comes, the reconciliation process will clear up any mistakes. This sounds awfully basic, but again, you’d be surprised how often I find mistakes on statements coming from institutions you’d otherwise trust.

Posted in: Blog

Leave a Comment (0) →

What did your accounting tell you today?

Sometimes business owners are guilty of over examining accounting records, looking for the answer. Developing a list of key performance indicators (KPI’s) is better, but can still be overdone. Usually five is enough. The importance of measuring to improve gets confusing when you don’t know what you should be measuring.

Instead of trying to answer every possible question or problem in your organization, try breaking this down into a few straightforward questions, with straightforward answers. This evening I went to a Mexican restaurant. Facing me as I entered the building was a whiteboard listing the specials tonight.

At first it didn’t strike me as that interesting. After all, what Mexican restaurant doesn’t have a list of specials? What I did find interesting however was this booklet that was used by the waiters to track how many of each special that was sold. A simple problem (which specials sells the best on Wednesday night), answered with a simple tracking system (spiral bound notebook).

Once I worked with a child care center that had a problem with teachers showing up for their shift 5-15 minutes late. It was a big problem because the state mandated a specific child to teacher ratio. If kids showed up early, or even on time and the teachers were late, fines were imposed. I recommended tracking teacher tardiness on a simple spreadsheet and then posting the weekly results above the time clock for everyone to see. Within two weeks everyone was showing up on time. Nobody wanted to be the offender.

Don’t get too bogged down with esoteric measurement systems. Consider some easily solvable problems and conquer those first.

Posted in: Blog

Leave a Comment (0) →

Using QuickBooks accounting to your disadvantage

As recently as 15 years ago most small business owners relied on an outside accounting firm to manage their accounting tasks and payroll services. For the most part, this privilege was abused by accountants. Although the reams of financial data sent back to the business was accurate, it was mostly useless information.

Along came QuickBooks and the accounting rug was pulled out from under many accounting firms. Finally the small business owner was empowered to take control of his or her bookkeeping and accounting. Unfortunately most small business owners lack the understanding (and time) required to achieve accurate accounting records, and equally importantly, they lack the ability to interpret the results in any meaningful way. Granted, with QuickBooks you can push a button and find out if you made or lost money last month, but this becomes irrelevant if the underlying data is incomplete. Furthermore, profitability is but one financial measure that provides a very narrow view of how the business is actually performing. As I’ve stated before, 9 out of 10 QuickBooks data files I examine have mistakes that are misleading the business owners. This problem is even more pervasive with other, less understood accounting software.

Small business owners need to start give back some of the accounting responsibility to qualified accountants. In house bookkeeping is fine, but someone who knows what they’re doing, and who genuinely cares about the business needs to examine, correct, and provide a useful opinion about the accounting data. Accountants in general need to step up and start taking more ownership of their clients businesses. I am often appalled at how CPA’s and other accounting professionals service their clients. Sadly, most small business owners can’t tell the difference between good and bad work. Only after an obvious mistake is discovered, does an accounting client decide to get a second opinion.

In big business the problem is often labeled as “accounting irregularities”. With small business it just called sloppiness. Call it whatever you want, if you own a small business, you deserve and should demand that you get accurate and timely financial results. Too many small businesses have been handicapped over time, or have gone out of business because nobody was looking out for best interests of that business owner.

Posted in: Blog

Leave a Comment (0) →

Accounting for charitable giving in business

I read a bible verse from Nahum 3:16 this morning, where Nahum judged the business people of Nineveh for exploiting resources with no intent to replenish what they used. Interestingly enough, I’ve know clients that exploit their employees, vendors and customers. Thankfully these companies don’t last forever. I’ve also run into a few clients that actively give back as a normal practice of their business.

One professional service client set up a scholarship fund to his alma mater, and quietly donates money to his church, as well as individuals in desperate need. A retail business I work with donates there facility to nonprofit organizations so that they can hold fundraising events. Finally, a contractor I work with pays his staff to assembly community gardens and pick up litter.

From an accounting perspective it’s had for me to draw a direct line from these examples of charitable giving, over to an amazing bottom line (profit), but I have to admit that each one of these businesses is doing very well indeed. I should also point out that they didn’t wait until they were successful to begin giving money or time to their community. It was part of their business from day one.

I’m certain that generosity, combined with the correct frame of mind, will be rewarding. In other words, if you’re going to give, you need to do so because you want to give and because it makes you feel great.

Sadly these giving organizations are the exception to my client base, and small businesses in general. Do you have a serious plan for giving back within your business? If so, please tell me what you do, and how you’ve been rewarded in the comments section.

Posted in: Blog

Leave a Comment (0) →

7 traits of a successful business

As I’m just wrapping up a whirlwind series of meetings with clients in Milwaukee and Madison Wisconsin, I was struck by the impressive, albeit steady successes these accounting clients are all enjoying. I couldn’t pick a more mixed bag of industries, including specialty retail, B to B service, IT support, supplier to the construction industry, and so on. It doesn’t matter what type of business you own. As evidenced by my list of clients, there is someone in your industry that has the discipline to get it right and they are enjoying sales growth, profit, or both.

I thought it would be a good idea to list what they all have in common. Hopefully you will consider some of these points to help improve your business. Here is a brief list of my opinion of what they’re all doing right.

  1. Every one of these businesses is aggressively pursuing new markets. They are not dissuaded by the bad economic news we hear every day.
  2. Tied very closely to point number one is that they all are exceedingly patient. They are not chasing any new business just to get the sale. They are accountable to a business plan, and don’t seem to have any problem turning down new business if it doesn’t fit their model.
  3. They are all hiring, but cautiously.
  4. Interestingly, their marketing spending is much smaller than their industry average. They rely on pleasing their current customer base.
  5. Hard work, long hours. They put in more time than most small business owners I know. They are tired and energized at the same time. Not stressed.
  6. None of them have significant debt, and all of them have significant money in the bank. As I’ve examined their accounting records and prodded them to bolster their balance sheets, their confidences (and options) have grown. Wouldn’t having tens of thousands in your savings account give you confidence?
  7. We have worked hard to develop reliable KPI’s or financial metrics, unique to their business, so that at a glance we understand what’s really going on in their business. In other words, they care, but don’t obsess over financial results.

Posted in: Blog

Leave a Comment (0) →

The most overlooked accounting measurement

One of the least understood financial measures, at least by the business owners I work with, is their working capital requirement. When examining accounting records, it is simply the business recievables plus inventory, subtracted from payables and payroll liabilities (with some minor exceptions). It’s called working capital requirement because many businesses are required to use internal money to support this spread. In other words, money is tied up waiting for customers to pay up(receivables), and also tied up in inventory. This is subtracted from the fact that you owe your vendors money, which effectively becomes your bank.

In some rare cases, such as some retail businesses, working capital is a negative number. This means that the working capital cycle produces cash; products are sold to customers before they’re paid for. Several years ago Home Depot insisted that all vendors get paid when the product is rung up at the cash register. This brilliant move essentially removed all inventory from the operation, giving Home Depot a tremendous advantage.

How you finance this lack (or difference) in cash is debatable, but knowing and tracking your working capital requirement is important because it can help resolve cash flow issues. Like many topics related to small business financial excellence, it goes back to a decent accounting system and an eye for details.

Posted in: Blog

Leave a Comment (0) →
Page 3 of 6 12345...»