How to Reconcile Dental Collections to Bank Deposits

Dental office manager comparing a daily collections report with a bank deposit record

To reconcile dental collections to bank deposits, compare the payments posted in your practice management software for a given day or month with the deposits that actually reached your bank account, accounting for timing differences such as credit card settlements and insurance electronic payments. Any difference that cannot be explained by timing should be investigated right away, because it may signal a posting error, a missed deposit or a control weakness.

This simple routine is one of the most effective financial controls a dental office can have. Ash Dental CPA builds it into the bookkeeping process for the practices we serve.

Why This Reconciliation Matters

Your practice software and your bank are two separate records of the same money. When they agree, you can trust your collections numbers. When they do not, something needs attention. A regular reconciliation helps you:

  • Catch payments posted to the wrong patient or the wrong date.
  • Find deposits that were never made or were made for the wrong amount.
  • Identify insurance payments that reached the bank but were never posted.
  • Reduce the risk of theft by making discrepancies visible quickly.
  • Give your CPA reliable collections figures for tax planning.

The Daily Routine

  1. At the end of each day, run the day’s payment report from your practice software, broken down by payment type.
  2. Count cash and checks and compare them to the report.
  3. Compare the credit card batch total to card payments posted in the software.
  4. Prepare the deposit and record the deposit amount on the daily report.
  5. Have a second person review and initial the daily report when possible.

The Monthly Reconciliation

Step 1: Gather Reports

Pull the month’s collections report from your practice software by payment type, along with the bank statement and the card processor’s monthly statement.

Step 2: Match by Payment Type

Match cash and checks to bank deposits, card payments to processor settlements, and insurance payments to checks or electronic deposits. Matching by type makes differences much easier to find.

Step 3: Account for Timing

Card batches from the last days of the month may settle in the next month. Insurance electronic payments may reach the bank before they are posted. List these timing items so they can be cleared next month.

Step 4: Investigate Differences

Anything left after timing items is a true difference. Look for posting errors, duplicate entries, voided payments and missing deposits, and resolve them before closing the month.

Watch for These Warning Signs

  • Cash collections that are consistently lower than you would expect.
  • Frequent voids, adjustments or “payment corrections” by the same user.
  • Deposits that are regularly made late or combined across several days.
  • Insurance payments in the bank that never appear in the software.

None of these signs proves a problem on its own, but they are worth a closer look. Separating duties, so the person posting payments is not the only person making deposits, is a simple safeguard.

Handling Refunds and Credit Balances

Refunds are a common source of reconciliation problems. When a patient or insurer overpays, the practice software shows a credit balance, and when that credit is refunded the money leaves the bank. To keep both records aligned:

  • Post every refund in the practice software at the same time the check or card refund is issued.
  • Record refunds in your accounting system as a reduction of revenue, not as an expense.
  • Review the credit balance report monthly so overpayments do not sit unresolved.
  • Require approval for refunds above a set amount.

Handling refunds consistently prevents differences that look like missing money but are really unrecorded paybacks.

How This Fits Into Your Books

A reconciliation of collections to deposits works alongside the regular bank reconciliation in your accounting system. Together, they make sure the revenue on your profit and loss statement is real and complete. For a broader look at revenue tracking, see our article on revenue cycle management for dental practices.

Key Takeaways

  • Compare software collections to bank deposits daily and reconcile fully each month.
  • Match by payment type: cash and checks, credit cards and insurance.
  • Track timing differences separately from true discrepancies.
  • Separate posting and depositing duties when you can.

Let Ash Dental CPA Handle the Reconciliation

Our dental bookkeeping services include monthly reconciliations that tie your practice software to your bank, and our management and consulting team can review your office’s internal controls.

Ash Dental CPA has offices at 945 Concord Street #109, Framingham, MA 01701 and 114 Merriam Ave, Leominster, MA 01453, and is open Monday through Friday, 9 a.m. to 4 p.m. Call (617) 462-6651, email info@ashdentalcpa.com, or book a complimentary consultation with our dental CPA team.

Frequently Asked Questions

How often should a dental office reconcile collections to deposits?

A quick check should happen daily when the deposit is prepared, and a full reconciliation should be done monthly. Daily checks catch errors while they are easy to fix.

What causes most differences between collections and deposits?

Timing differences are the most common, especially credit card settlements and insurance electronic payments. Posting errors and missed deposits are next. True unexplained differences should be investigated promptly.

Who should do the reconciliation?

Ideally someone other than the person who posts payments and makes deposits, such as the owner, an office manager or an outside bookkeeper. Separating duties strengthens your controls.

Can my CPA do this reconciliation for me?

Yes. Ash Dental CPA’s bookkeeping services can include monthly reconciliations between your practice management software and bank records.

author avatar
adcpa_george