How to Reconcile Your New Dental Practice Bank Account Every Month
Learn the step-by-step process to reconcile your dental practice bank account monthly, including tools, common pitfalls, and a free template.
Reconciling your dental practice bank account every month is a non-negotiable task for accurate financial management. It ensures your books match your actual bank balance, catches errors or fraud early, and gives you a clear picture of your cash flow. Here’s a practical, step-by-step guide to do it efficiently, even if you’re new to the business side.
Why Monthly Reconciliation Matters
Skipping reconciliation can lead to overdrafts, missed payments, or undetected embezzlement. For a new practice, cash flow is tight, and a $500 error can hurt. Monthly reconciliation also simplifies tax preparation and helps you spot trends like rising supply costs or delayed insurance payments.
What You Need Before You Start
Gather these items:
- Your bank statement for the month (PDF or paper)
- Your accounting software (QuickBooks, Xero, or a dental-specific tool like Dentrix or Eaglesoft with accounting integration)
- Your practice’s chart of accounts (list of categories like supplies, lab fees, payroll)
- A record of all transactions you’ve entered in your software for that month
If you don’t use accounting software yet, consider starting with QuickBooks Online ($30-$50/month) or Xero ($30-$45/month). Many dental practices also use Dentrix or Eaglesoft, which can export transaction data to these tools.
Step-by-Step Reconciliation Process
Step 1: Compare Beginning Balances
Check that the beginning balance on your bank statement matches the beginning balance in your accounting software. If they don’t match, you may have missed a prior month’s reconciliation or entered an opening balance incorrectly.
Step 2: Match Deposits
Go through each deposit on your bank statement and match it to a deposit in your software. For dental practices, deposits often come from:
- Patient payments (cash, check, credit card)
- Insurance reimbursements (e.g., Delta Dental, Cigna)
- Transfers from savings
If a deposit doesn’t match, check if it’s a patient payment you forgot to record or an insurance payment that came in without a claim link. Use a spreadsheet or your software’s reconciliation tool to tick off each item.
Step 3: Match Withdrawals and Checks
Match every withdrawal, check, and debit card transaction on your statement to your software. Common dental practice expenses include:
- Lab fees (e.g., crowns, dentures)
- Dental supplies (e.g., gloves, anesthetics)
- Payroll (if you run payroll through your bank)
- Software subscriptions (e.g., practice management, marketing)
- Utilities and rent
For checks, verify the check number and amount. If a check hasn’t cleared yet, it will appear as an outstanding check on your reconciliation.
Step 4: Account for Bank Fees and Interest
Bank statements often include monthly maintenance fees ($10-$20/month) or interest earned (usually pennies). Add these to your software as separate transactions, categorized as “Bank Fees” or “Interest Income.”
Step 5: Identify and Investigate Discrepancies
After matching, calculate the difference between your bank balance and your software balance. If they don’t match, look for:
- Duplicate entries (e.g., entering the same patient payment twice)
- Missing transactions (e.g., a debit card purchase you forgot to record)
- Transposition errors (e.g., entering $1,250 as $1,520)
Use your reconciliation report to list unmatched items. Investigate each one until the difference is zero.
Step 6: Adjust Your Books
Make any necessary journal entries to correct errors. For example, if you missed a $50 supply purchase, record it. If a check bounced, reverse the original entry and record the bank fee.
Step 7: Document and File
Once reconciled, print or save the reconciliation report and bank statement. Store them in a folder (physical or cloud) labeled by month. This documentation is crucial for tax audits and for tracking your practice’s financial health.
Tools to Simplify Reconciliation
| Tool | Type | Price Range | Best For |
|---|---|---|---|
| QuickBooks Online | Accounting software | $30-$50/month | Small to medium practices |
| Xero | Accounting software | $30-$45/month | Practices with multiple users |
| Dentrix | Practice management with built-in accounting | $200-$400/month (full suite) | Dental-specific workflows |
| Eaglesoft | Practice management with accounting | $200-$350/month | Dental practices with integrated billing |
| Bank reconciliation spreadsheet | Manual template | Free | Very small practices or startups |
Using your practice management software’s built-in reconciliation feature can save time, but it’s still wise to review monthly.
Common Mistakes to Avoid
- Skipping months: Reconcile every month, even if you’re busy. A 3-month gap makes errors harder to find.
- Ignoring small discrepancies: A $5 difference might seem minor, but it could indicate a larger issue.
- Not categorizing transactions properly: Misclassified expenses (e.g., putting lab fees under supplies) skew your profit and loss statement.
- Forgetting outstanding checks: Always track checks that haven’t cleared; they’ll show up next month.
FAQ
How long does reconciliation take for a new dental practice?
For a small practice with 50-100 transactions per month, expect 1-2 hours. As you get familiar, it can drop to 30-45 minutes.
What if my bank statement doesn’t match my software after two attempts?
Contact your bank to verify all transactions, and review your software’s audit trail. If you still can’t find the issue, consider hiring a part-time bookkeeper ($50-$75/hour) for a one-time cleanup.
Do I need to reconcile if I use a dental practice management system?
Yes. Even if your system tracks patient payments, it doesn’t automatically sync with your bank. You still need to verify that all deposits and withdrawals are recorded.
Can I automate reconciliation?
Some tools like QuickBooks can auto-match transactions if you link your bank feed. However, you still need to review and approve matches, so it’s not fully hands-off.
The Bottom Line
Monthly bank reconciliation is a simple but vital habit for your dental practice’s financial health. By following these steps, you’ll catch errors early, avoid cash flow surprises, and keep your books accurate for taxes and decision-making. Start this month: set aside 90 minutes, gather your statements, and reconcile. Your future self will thank you.