Visit our website at
  05.26.05 Issue #168


Everybody Makes Mistakes

By Susan Gunn

Mistakes happen. Some can be corrected. Especially in QuickBooks™. With QuickBooks™ being the number one recommended software for dental practice accounting, I have seen hundreds of mistakes made in dental practices. Here are just a couple.

Not separating deposits for easier banking account reconciliation.
Because dental practice software manages all the accounts receivables, creating deposits in QuickBooks™ is easy. You will enter the deposits into QuickBooks™ just as they are entered in to your bank. For bank reconciliation purposes, credit cards deposited separately into your banking account, need to be a separate deposit line item (i.e. Mastercard/VISA, Discover, American Express, etc.). This mistake occurs primarily due to other's manuals and training classes not geared towards professional practices. Both guide users to enter one daily deposit, lumping payments from customers into split lines. Since payments are not received through QuickBooks™ but your practice software, follow these suggestions:

  • Create a main income type of “Deposits” and create subaccounts for “Checks & Cash”, “M/C & VISA”, “Discover”, “American Express”, and any others.
  • When entering deposits from the practice software's day sheet, enter each of these deposits separately, with the date from the day sheet or the physical deposit date.

Each piece of information should be verified with your daysheet. The MC/VISA total should match the MC/VISA total from the day sheet. The Checks & Cash total on the physical deposit slip should match the Checks & Cash total from the day sheet. Each one of the deposit totals should be verified with the day sheet. This is accountability. For easy reference, staple the physical check deposit slip & credit card terminal summary to the day sheet. This way, if you have any future questions regarding deposits, the information is all together.

Patient Reimbursements are not expenses.
Because your accounts receivable is maintained in your practice software, when you enter income into QuickBooks™, your accounting becomes cash basis. Long after the patient has written a check and it has been deposited, the insurance company often pays more than what was estimated. When writing a reimbursement check, the account chosen under the expenses tab is actually an income account, “Patient Reimbursements”, not an expense account. This deducts the patient reimbursement from what was previously entered as income, keeping your true income accurate. After all, you really don't want to pay taxes on income you can't spend, right?

Opening balance to reconcile the bank statement is not correct.
When a bank statement is reconciled, a check mark is placed in each reconciled transaction's entry in the check register. For whatever reason, sometimes those transactions are deleted or unreconciled. There is a QuickBooks™ warning that says “Are you sure you want to delete this reconciled transaction?” Or, if voiding, the warning says, “You have changed a transaction that has already cleared…” If you delete or void a transaction after these warnings, it will add the amount of the transaction (a previously reconciled amount) to the opening balance for your next reconciliation. If this has happened to you, beginning with QuickBooks™ 2004 editions, there is a bank reconciliation discrepency tool. This tool creates a report that will show deleted, voided or changed transactions. The QuickBooks In Your Practice Primer has detailed information regarding using this tool when your opening balance is incorrect.

At a recent ADA Meeting, I was talking with a dentist who confirmed a couple of these common mistakes in her QuickBooks™. After reassuring her she was not alone in these mistakes, I showed her where in the Primer workbook I cover these mistakes in detail. After all, a bigger mistake is to believe you already know everything about QuickBooks™.

If you found problems in your QuickBooks™, don't distress! Everyone makes mistakes, they are a part of learning and are easy to fix in QuickBooks™ ! Happy Accounting!

To order Susan's QuickBooks™ 2005 In Your Practice Primergo Here

Forward this article to a friend.

The McKenzie Company Seminar & Exhibit Schedule
2005 Location Sponsor Information Topic Speaker
July 21-24 San Diego, CA
IA of Comprehensive Aesthe 702-341-7978 Peak Performer Sally McKenzie
July 28 La Jolla , CA Southern CA Ortho. Symposium 619-656-4646 Top Issues Sally McKenzie
August 13 Topeka, KS Delta Dental Plan of Kansas 800-733-5623 Breakdown Sally McKenzie
Sept. 9-11 San Francisco, CA California Dental Association* 916-443-0505 TBA Sally McKenzie
Sept. 22 El Paso, TX El Paso Dental Society 877-777-6151 TBA Sally McKenzie
Sept. 23-24 Griffin, GA Endo Magic Root Camp 877-478-9748 Top Issues Sally McKenzie
Oct. 14 Riverside, CA Riverside Implant Study Group 951-279-7847 TBA Sally McKenzie
Nov. 18-19 Griffin, GA Endo Magic Root Camp 877-478-9748 Top Issues Sally McKenzie
Dec. 1 Cincinnati, OH Cincinnati Dental Society 513-984-3443 Breakdown Sally McKenzie
Dec. 9 Minneapolis, MN Minneapolis District Dental 877-777-6151 TBA Sally McKenzie
* The McKenzie Company will be exhibiting at location

The McKenzie Company

3252 Holiday Court, Suite 110

La Jolla , CA 92037

For more information, email
or call 1-877-777-6151

The McKenzie Company Newsletter Information:
To unsubscribe:
To discontinue receiving the Sally McKenzie eManagment newsletter,
click on the link at the very bottom of this page for instant removal,
To report technical problems with this newsletter or to request technical help,
please send a descriptive email to:
To request services, products or general inquires about The McKenzie Company activities
please send a descriptive email to:
If you would like to have any of your dental practice concerns answered personally by Sally McKenzie,
please send a descriptive email to her at:
Copyrights 1980-Present The McKenzie Company - All Rights Reserved.