Get Rid Of Booby Traps In Your QuickBooks Accounting System

| 4 min read

Get Rid Of Booby Traps In Your QuickBooks Accounting System

QuickBooks Bookkeeping Traps and MistakesWhen it comes to QuickBooks, you can eliminate the odds that you and/or your staff will make the same stupid mistakes over and over again.

Booby Trap defined: noun - a thing designed to catch the unwary, in particular.
Etymology: The Spanish word bobo translates to stupid, daft, naïve, simple, fool, idiot, one who is easily tricked.

Your QuickBooks accounting system may be set up to make a fool or a booby out of you and/or your staff. Get it organized to get you the information (financial reports) that you can need and can depend on.

Remember Kiss (Keep it simple stupid).

The first place to look for booby-traps that will create input errors over and over is in the QuickBooks Chart of Accounts. Go to your Chart of Accounts and sort it first by type.

The accounts will list out logically as if you were looking at a Balance Sheet followed by accounts found on the Profit & Loss Statement.

These are the types, and the order in which they will sort: Current assets (Banks, Receivables, etc.) fixed assets, liabilities (current and long-term), Equity, Revenue, Cost of Goods Sold (or Cost of Sales), Expenses.

1000   Current Assets          

     1001 Checking

     1010 Savings                      

     1020 Credit Card

     1090 Petty Cash                 

1100   Other Current Assets

     1100 Accounts Receivable

     1200 Undeposited Funds

     1300 Inventory

     1400 Pre-Paid Expenses     

     1500 Employee Receivables (advances)    

1500 Fixed Assets

     Equipment

     Furnishings

     Accumulated Depreciation

2000 Liabilities

     2000 Accounts Payable

     2010 Credit Line

     2030 Loans (principal)

     2050 Automobile Leases (principal)

     2060 Customer Deposits (Unearned Revenues)

     2400Payroll Liabilities

3000   Equity                                    

     Opening balances

     Owners Equity

     Owners Draw

4000   Revenue

     1 Main Revenue

     2 Minor Revenue Stream

     3 Other Revenue

5000 Cost of Goods Sold (or Cost of Sales)

     COGS inventory

     COGS packaging

     COGS shipping

 6000 Expenses

     6100 Facilities

         Rent

         Utilities

         Phone

         Electricity

         Gas

         Internet services

         Janitorial services

    

 

6200  Payroll

     Gross wages/salaries

     Paid Time Off

     Health Insurance

     Employer Contributions
     to Fica/Medicare

     Unemployment Insurance

     Workers Comp

     Payroll service fees

6400 Business Insurance

     Property

     Liability

6500 Auto Exp

     Maintenance

     Registration/taxes

     Insurance

6600 Marketing & Advertising

     Meals & Entertainment

     Client Gift Cards

     Conference Registration

     Booths

     Printed Materials

6700 Travel

     Airfare

     Lodging/hotel

     Per Diems

     Ground transport

6800 Office

     Supplies

     Postage

     Dues and Subscriptions

6900 Professional Fees

     Accountant

     Bookkeeper

     Consultants

 

7000 Financial

     Interest Expense

     Bank fees

     Late fees

     Depreciation

8000 Taxes

     Income

     Sales

9000 Ask My Accountant

Note that the accounts within the account type categories in bold can appear in any order you want, but if you do not set it up to list out logically, then it is hard to find the correct account over and over again. The list above if sorted alphabetically will not make any sense.

To direct QuickBooks sorting of these accounts into a more useable list you can add numbers. Entering bills, writing checks, creating journal entries all gets easier if we can memorize the account numbers. The more complex your business, the more you need numbers.

A person can remember that a transaction involving income will be directed to the 4000’s; that costs related to sales are in the 5000’s; that most expenses are in the 6000’s; that the 7000’s relate to banking and financial transactions; that when you just don’t know you put in the 9000 bucket and send it to your accountant and let them decide.

Caution: if you do not know what the significance of these different accounts are, or why they are important, and how they feed into your monthly, quarterly and annual reports, then you are NOT the person to be setting up QuickBooks in the first place. Call us, we can help.

This way you have roughly 8 buckets to initially choose from instead of a huge list to scroll through over and over.

The numbers make the logic easier to grasp, and will help you identify miss-allocations more easily. And because the numbers list out first, you will be able to make account selections more easily because you can always see the first part of a file name but usually the last word in a long filename is what separates the right from the wrong account.

And because QuickBooks will fill in the right information if you just start the right numbers, all you need to do is give it the 4 or 5 or 6 digits of the account number.

Avoid existential conundrums in your COA

Don’t have ambiguous categories. For example, if you name one expense Shop Supplies and another Tools and Hardware, you might know what the difference is but someone you are paying to enter data for you will not. Other examples:

Meeting Expense and Meals & Entertainment. (Do you really need both? If so make the differences clearer)
Bank Charges and Bank Fees (what’s the difference and do you need to track it separately? Why?)
Maintenance and Auto Repairs (remember this is not a STUMP THE CHUMP game)
Fuel and Oil & Gas (classic)
Office Supplies and Computer Supplies (what the heck?)
Employee Recognition and Uniforms (just pick one and use it only, make the other inactive)
Miscellaneous and Ask My Accountant (no no no! Use just one. Why have a misc. expense? If it is a legit transaction categorize it.)

Loading up your lists with ambiguity will slow down data entry, but it will also muck up your reporting.

When your reports lose their integrity due to nonsense allocations, useless detail, and confused accounts, then you have to pay professionals to clean up the mess.

Adding numbers to Vendor, Customer, Item, Class, Memorized Reports, and Memorized Transaction lists.

Again if you don’t determine the order in which you want things to appear, it is harder to find. You can use QuickBooks’s Add/Edit Multiple List Entries mode (in the LISTS menu) to re-organize these lists.

Otherwise these lists will default to alphabetical sorts. When a list is offered only in alphabetical order you need to know the name used when something was entered in a list.

So you end looking for AAA instead of American Automobile Association, or vice versa. And so many vendor names start with America… or Big, or Blue or The. And individuals? Yes sometimes they are entered so that they will sort by first name, which will get you a lot of Bobs, when you should be looking for Robert or Rob?

But if you first think about what are the important categories for your list, and how can you separate list entries into these categories (by number, letter, and/or combinations).

And clean up your lists once in a while. Hint: if you have more than 50-100 vendors, you are doing it wrong. Put unused entries in any list to bed by marking it inactive. Again KISS: Do you need to create a new vendor for each new gas station you stop at?

Maybe you have a vendor called “Gas Station”. And maybe you have a vendor called “Restaurants and Eateries”. You can put details in the memo if you are going to track it, but usually you do not need to know how much was spent at MacDonald’s vs. Wendy’s. Keeping it simple will keep your file smaller and more efficient all around.

Getting it right at the start is best, and then you make little refinements along the way. Maybe you need help. Call us. Or maybe you inherited a stupid mess and you need help. Call us. Or maybe you just want someone else to take care of this part of your business so you can focus on what you do best. Call us.

Reasons to use outsourced bookkeeping

Photo Credit © Dollar Photo Club / 831days

 

remote-bookkeeping2w

An Affordable Bookkeeping Alternative to a CFO

Outsourcing your bookkeeping is more affordable than you would think. We save you money the moment you hire us by cutting out the expensive cost of hiring an in-house CFO.

Working with a remote bookkeeping service will still provide you with all the value you could get from an in-office bookkeeper but at a fraction of the cost.

Learn more

Learn How We Can Impact Your Business Growth

You’ve got your company’s best interest in mind. Guess what? So do we! You can rest assured that we will work closely with you to create actionable business plans and accurate financial reporting. We offer our toolkit of financial intelligence that will be your greatest asset for business growth.

Contact an Advisor