Common QuickBooks Bookkeeping Problems & How to Find Them

Sometimes people know their books are wrong but they aren’t sure what is wrong. Other times, people have no idea there is a problem because they don’t know what they don’t know.

If you know for sure your books have problems, then use the chart below to see what kind of problem(s) you are having and what the solution is likely to be.

If you already know your books have some issues, or even if you think your books are rock solid, I still suggest printing out the reports discussed and going through the accounts to make sure. As I’ve said other places, 98% of the books we see have at least one problem, so the chances are yours do, too. Maybe not, but it doesn’t hurt to check so if you are doing clean up you can make sure you get everything at once.

If you aren’t sure what your problem is, but you think you might have one, then the best way to spot it is to go to the reports menu, select the Profit and Loss Standard report and select a time range that covers the last twelve months by month (or as long as you’ve been in business if less), and print it out.

Then print out a Balance Sheet report, with an ending date of the last day of the most recent month that has passed.

Then, in a nutshell- look for stuff that looks wrong:

On the P&L, look for:

• Negative income amounts (aside from refund or discount accounts)
• Negative expense amounts
• Amounts that are way higher or lower than you think they should be
• Accounts with contents you aren’t sure of
• Amounts that are loan payments
• Amounts that are sales tax payments
• Amounts that are credit card payments
• Amounts that are payments to the owners or investors
• Anything that says payroll that wasn’t an actual paycheck

These are all red flags that things have gone wrong.

On the Balance Sheet, check if you see:

• A bank balance that is negative or way off what it should be
• Accounts receivable balances that are more than you are actually owed
• An inventory amount that isn’t really the value of your inventory
• Asset accounts that don’t match the value of your actual assets
• Depreciation or Amortization that is MORE than the value of your assets
• Loan balances that are wrong (or missing)
• Accounts payable balances that are more than you really owe
• An opening balance equity account
• Any other number that looks wrong – you don’t know what it is, or a negative number

If you spot one or more of these, there is a very good chance you are making one or several of the mistakes outlined below. Time to get busy working through these!

Go down the list. If you are doing it correctly, you don’t need to worry about it. If there is an issue, mark it so you can come back to it. When you come back to it, make sure you understand how to correct it, and go as far back in your books as needed to fix it. It is easy to keep the books in order once they are organized, but until they are fixed, they are never going to give you usable or accurate information.

Problem	Symptom	Fix
Not Reconciling Your Accounts	Your balances don’t match reality and are way off	Get a good starting balance and then match entries to statement
Not Doing Sales Tax Correctly	Over or under balance owed compared to your POS report	Use built-in sales tax tracking correctly
Bad Chart of Accounts	Identical expenses going in different places each month	Clean up Chart of Accounts to make it easy to use right
Doing Loans Wrong	Only payments showing, no split for interest expense, no loan balance	Use loan accounts and reconcile with statements to split into two parts
Missing Credit Card Expenses	Overstated profit, payments to credit card but no detail	Set up credit card account, reconcile expenses and payments
Screwed up Invoicing	Customer balances not right, income overstated	Learn to receive payments and deposit funds correctly
Forgetting 1099s	1099s not filed because 1099 vendors not tracked	Get a W-9 from each eligible vendor and track in QB from start
Asset Accounts Wrong	Missing assets, missing deductions for expenses treated as assets	Understand how to use asset accounts and what goes in them
Equity Accounts Wrong	No equity or equity treated as expense	Understand how to use equity accounts and who they are for
Getting Behind, Doing it all Yourself	Books not started or way behind or way wrong	Get help, get them caught up and fixed, delegate!

If you find problems and you can’t figure out how to fix them, or you would rather hand off the task or you just want to make sure it is done right, then give us a call– we’d be happy to give you a fixed price quote on what it will cost to get it all cleaned up for you.