Software & Integrations

Why Your PMS Revenue Report Doesn’t Match Your Books (and How to Reconcile It)

You pull a revenue report from your practice management system. Then you open your financial statements.

The numbers do not match.

That does not automatically mean something is wrong. The two systems measure different things at different times. But a gap you cannot explain is a problem, and it is one of the most common reasons veterinary owners stop trusting their reports.

This guide covers the five usual causes of the gap and a simple monthly routine to reconcile it. For the bigger picture of how your systems fit together, see our veterinary accounting software guide.

We Know The Difference

See what veterinary-specific bookkeeping looks like in practice.

Book A Demo

The Short Answer

Your practice management system records activity: services performed, invoices created, and payments taken.

Your books record the financial result: revenue earned, cash received, and money owed.

Those are related, but they are not identical. The goal is not to make them match perfectly. The goal is to explain every difference.

Five Common Reasons the Numbers Differ

1. Timing

Timing differences include:

  • Invoiced in the practice management system today, deposited in the bank days later
  • Card batches that settle after month-end
  • Month-end cutoffs that differ between the two systems

Whether you report on a cash or accrual basis changes which of these show up. Our article on accrual vs. cash accounting for veterinary hospitals explains the difference.

2. Refunds, Voids, and Adjustments

Common problems:

  • A refund recorded in one system but not the other
  • An invoice edited after the month was closed
  • A void that reverses revenue in the practice management system but never reaches the books

3. Deposits and Prepayments

When a client pays a deposit, you have not earned that money yet.

In your books, deposits and prepayments usually sit as liabilities until the service is delivered. In the practice management system, they may look like revenue as soon as they are taken. That alone can create a gap that grows and shrinks from month to month.

4. Payment Processing

Watch for:

  • Card payments deposited in batches rather than one at a time
  • Processor fees taken out before the deposit reaches your bank
  • Financing or payment-plan payouts that arrive net of fees

Your bank deposit is almost never equal to what clients paid.

5. Discounts, Sales Tax, and Write-Offs

Each system may record these differently. A discount might reduce revenue in one report and appear as an expense in another. Sales tax collected may be included in one total and excluded from the other. If nobody has defined how each is handled, the gap will not close.

A Monthly Reconciliation Routine

The fix is a routine, not a one-time cleanup. Here is a simple version.

Each month, after close:

  • Pull the practice management system payment total for the month
  • Subtract refunds and processor fees
  • Adjust for batches that settled across month-end
  • Compare the result to bank deposits
  • Explain every remaining difference in writing

Here is an illustrative example. These are not real client numbers.

Illustrative month:

  • Payments collected in the practice management system: $100,000
  • Less card processor fees: $2,900
  • Less refunds issued: $1,400
  • Less card batch that settles next month: $3,500
  • Plus card batch from last month that settled this month: $3,200
  • Expected bank deposits: $95,400
  • Actual bank deposits: $95,400
  • Unexplained difference: $0

A zero difference is the goal. A small, explained difference is fine. An unexplained one needs attention before you close the month.

Red Flags That Point to a Bigger Problem

Look closer if you see:

  • A gap that grows month after month
  • Unexplained round-number differences
  • Revenue booked to one catch-all account
  • Deposits that never tie out to anything
  • Reports that change after the month has closed

These are often symptoms of a structural issue, not a one-time error. Our article on red flags in veterinary financial statements covers what else to watch for, and why a P&L can look great while your practice struggles explains how timing gaps hide behind good-looking reports.

Who Should Own This

Your bookkeeper should reconcile the two systems every month.

You should review the one-page summary. It should show the gap and explain it. If you cannot find that explanation, ask for it.

Once the numbers tie out, our article on the monthly financial reports veterinary owners actually need shows what to review next.

If you would like help building this routine, you can book a free veterinary bookkeeping demo or download the free guide for owners.

Veterinary-specific bookkeeping to help you achieve clean books and predictable cash flow.