Home › Blog › Deposit reconciliation
Deposit reconciliation: matching bank deposits to posted payments in a small practice
Every practice owner wants to know one simple thing: did the money the payers said they sent actually land in the bank, and did it get posted to the right accounts? Surprisingly often, nobody can answer that with confidence. Electronic payments arrive in the bank one way, remittance files arrive in the billing system another way, and patient payments come in through the front desk, the mail and online. If those streams are never tied together, small gaps can go unnoticed for months.
Deposit reconciliation is the habit of matching what hit the bank to what was posted in the billing system. It is not glamorous. When I ran MedNet of Michigan in the early 1990s, the offices that reconciled every deposit had far fewer surprises at the end of the year. The same is true for small practices in Las Vegas and across Nevada today.
Why the bank and the billing system drift apart
In a small practice, deposits and postings separate for ordinary reasons:
- An electronic payment arrives, but the matching remittance file never loads, so nothing gets posted
- A remittance gets posted, but the money went to an old bank account or was returned
- One payer deposit covers many claims, and part of it was posted to the wrong patient
- A payer takes back money from an earlier claim, so the deposit is smaller than the claims it pays
- Front desk payments are entered in the system but deposited on a different day, or the other way around
- A paper check gets posted twice, or is sitting in a drawer and never posted at all
None of these are rare. They are why reconciliation matters.
Match each payer deposit to its remittance
Most electronic insurance payments carry a trace or reference number. The same number appears on the remittance advice, the ERA or 835 file. That number is the bridge between the bank and the billing system. For every insurance deposit, find the remittance with the same trace number and confirm that the amounts agree. If you are newer to working with 835 files, my post on posting ERA and 835 payments covers the basics.
Keep a simple log with the deposit date, payer, trace number, amount in the bank, amount posted and the date posted. When the two amounts match, mark it done. When they do not, it goes on an exceptions list with a name next to it.
Watch for payments with no remittance, and remittances with no payment
The two most important exceptions are opposites. A deposit with no remittance means money arrived and nothing was posted, so claims still look unpaid. That can lead to follow-up calls on claims that are already paid, or worse, to patient statements for balances already covered. A remittance with no deposit means the system shows claims as paid, but the money may not be in your account. That one deserves a call to the payer and a look at your enrollment details for electronic payments.
When an expected remittance is missing, ask your clearinghouse or the payer portal for it before you post anything by hand from memory.
Account for takebacks and offsets
Payers sometimes recover an earlier overpayment by reducing a later payment. The deposit is then smaller than the total paid on the remittance, and the difference shows up as an adjustment tied to an older claim. If your posting ignores that line, your books will not balance and the old claim will still look correct when it is not. Post the takeback to the claim it belongs to, and check whether it was right. If the payer recovered money in error, you can dispute it. My post on checking whether the payer paid the right amount describes how to review those amounts.
Reconcile patient payments daily
Patient payments come through more doors than insurance payments: cash and card at the front desk, checks in the mail and online payments. At the end of each day, the total collected should equal the total posted and the total going to the bank. A daily closing sheet signed by the person who handled the money, and reviewed by someone else, is a simple control that protects both the practice and the staff. Separating who collects money from who reconciles it, even informally in a small office, is a good habit.
Close the month with a short summary
Once a month, compare total deposits for the month to total payments posted, broken out by payer and by patient payments. Note any differences and whether they have been explained. This short summary belongs alongside the other numbers an owner should see, which I described in a monthly billing report for the practice owner. Your accountant will also appreciate it at tax time.
Keep the exceptions list short and moving
Reconciliation is only useful if the exceptions get worked. Review the list weekly. Each item should have an owner, a next step and a date. Items that sit for weeks are the ones that turn into write-offs or refund requests.
Where automation fits
Matching trace numbers, comparing totals and building a list of mismatches is exactly the kind of repetitive work an AI helper can prepare for a person to review. Our sister team at RemitReady Agents builds those helpers for businesses of all kinds. A person still reviews the exceptions and decides what to post.
Not sure your deposits and postings line up? Request a free billing review or call (702) 775-1163. You can also email support@remitready.us. We will look at how payments move from the bank to your billing system and give you practical next steps whether or not you hire us. Read more posts on the RemitReady blog.