Short answer

Your collections report and your bank deposits measure different things, so they rarely match to the dollar. The report counts payments by the date they were posted to patient accounts; the bank counts money by the date it arrived. In between sit card processing fees, payer recoupments netted out of electronic payments, and payments that have arrived but haven't been applied to an account yet.

Reconcile by deposit, not by month. Match each bank deposit to the payments posted from it, and the gap resolves into a short list of named causes instead of a mystery.

Why the two numbers disagree

Most of the gap comes from a handful of causes, and each has a recognisable signature.

  • Posting date vs. deposit date. A payment that arrives on the 31st and is posted on the 2nd lands in different months on each side. Electronic remittances and the funds they describe also travel separately, so a payer’s remittance can post a day or more before the money reaches the account, or after.
  • Card processing fees. Card payments are usually deposited net of fees, often in batches that combine more than one day. The report shows what the patient paid; the bank shows what the processor sent.
  • Payer offsets and recoupments. When a payer takes back an overpayment on an old claim, it usually does so by reducing a current payment. The remittance shows the full payment and the takeback separately; the bank sees only the net amount.
  • Unapplied and unposted payments. Checks waiting to be keyed, payments that arrived without enough information to match a patient, and credit balances all sit in the bank before they appear in collections.
  • Refunds, returned checks and chargebacks. Money that leaves the account may be recorded on a different date, or in a different report, from the payment it reverses.
  • Deposits that aren’t patient collections. Interest, retail sales from an optical shop, and anything billed in a separate system show up at the bank but not in the practice management report.

None of these means money is missing. They mean the two numbers answer different questions.

Reconcile by deposit, not by month

Comparing a monthly collections total to a monthly bank total mixes every cause above into one unexplained number. Work at the level of the individual deposit instead.

  1. Pick one bank account and one short period. A week is enough to learn the pattern.
  2. List each deposit with its date and amount.
  3. Identify what each deposit should contain: a payer’s remittance, a card processor batch, or a batch of checks.
  4. Find the matching payments posted in your practice management system from that same source.
  5. Write down the difference for each deposit and name its cause: fee, offset, timing, or not yet posted.
  6. What’s left unexplained is the real problem. It is usually small, and by now it has a name.

The card processor’s statement and the payer’s remittance advice are the bridges between the two sides. Keep both for the period you’re reconciling.

Write the definition down

A collections number is only comparable if everyone knows what it counts. Put the answers at the top of the report you circulate:

  • Which date it runs on: posting date, deposit date, or date of service.
  • Gross or net: whether refunds and reversals are subtracted.
  • Which payments: insurance and patient together, or separately.
  • Which accounts and locations it covers.

Most arguments about whether collections are “right” turn out to be two people using two definitions.

When the gap is real

Definition gaps stay roughly stable. A problem shows itself differently:

  • The unexplained difference grows month over month.
  • One payer’s deposits consistently differ from the payments posted for that payer.
  • Unapplied cash keeps rising.
  • A deposit arrives with no remittance you can match it to.

Any of these deserves a closer look with your billing team, and with your accountant if money may be going somewhere it shouldn’t.

Where PremNET fits

Matching the bank is a bookkeeping job, and it belongs with whoever keeps your books. PremNET Analytics doesn’t read your bank account. What it does is make the posting side easy to open: its net applied payments report runs by month, splits insurance from patient, and opens any month to the individual payments behind it. That’s the half of the reconciliation that usually takes longest to assemble.

Related