Veterinary practices are largely point-of-service paid, which makes it easy to assume the revenue cycle takes care of itself. It doesn't. CareCredit declines, pet-insurance reimbursements, payment plans, and goodwill discounts all create a gap between what's charged and what's collected — and an aging AR balance that quietly grows. This dashboard makes the whole pipeline visible: what was billed, what came in, what's stuck, and what's being written off and why.
What this report answers
The collections page answers the cash-flow questions: how much did we collect, what share of charges did we actually realize, how many invoices did we bill, and how much recurring wellness-plan revenue is on the books? The AR page answers the risk questions: how much is outstanding, how is it spread across aging buckets, and what reasons are driving write-offs — bad debt, goodwill, or insurance adjustments?
The metrics that matter
Collection rate — payments collected over charges invoiced — is the headline, because gross charges flatter the picture; what lands in the bank is what counts. Outstanding AR balance by aging bucket is the early-warning line: the further a balance drifts past current, the less likely it ever pays. Write-off rate, broken out by reason, separates discretionary goodwill from genuine bad debt and points to where a policy fix belongs. Wellness-plan recurring revenue is worth watching on its own, because predictable monthly membership revenue smooths the lumpy point-of-service mix.
Why the data is trapped across the systems
The charge lives on the invoice, the payment lives on a separate transaction, the open balance is computed on the fly, and the write-off reason is buried in an adjustment code. Cornerstone, AVImark, ezyVet, and the rest can each show pieces of this, but the combined view — collection rate next to AR aging next to write-off reason — requires joining invoice, payment, and adjustment exports that the canned reports never put side by side.
How to read it
Read collection rate first as the headline, then look at the AR aging buckets to see whether a low rate is a collection problem or a timing one. A growing 61–90 and 90+ bucket is the signal to act before those balances become write-offs. Read write-off reason next: a spike in goodwill points to discounting discipline, while rising bad debt points to payment policy at check-out.
The sample on this page uses fully synthetic data — anonymized ids and made-up dollars, no real financials.
Metrics it tracks
| Metric | What it means |
|---|---|
| Total Collected | Sum of payments received in the period across all clients. |
| Collection Rate | Payments collected ÷ charges invoiced — a SUM/SUM ratio, the truest measure of revenue-cycle health. |
| Outstanding AR Balance | Sum of unpaid invoice balances still open at period end. |
| Write-Off Rate | Write-off dollars ÷ charges invoiced — the share of billed revenue given up. |
| Invoices Billed | Count of invoice rows generated in the period. |
| Wellness Plan Recurring Revenue | Sum of wellness-plan membership charges billed in the period — predictable monthly revenue. |
Used by: Hospital administrators and practice owners managing cash flow, accounts receivable, and payment collection
Frequently asked questions
What is a good collection rate for a veterinary practice?
Collection rate is payments collected divided by charges invoiced. Because most veterinary care is paid at point of service, healthy practices collect a high share of charges; a rate dragging well below that points to declined cards, unfunded payment plans, goodwill discounts, or growing AR. It's a better health measure than gross charges because it reflects what actually lands in the bank.
Why does AR aging matter if vets are mostly paid at checkout?
Even mostly point-of-service practices accumulate AR through payment plans, pet-insurance reimbursements, and balances left at discharge. Once a balance drifts past 60 or 90 days it's far less likely to be collected, so watching the aging buckets lets the team work at-risk balances before they become write-offs.
Can I build this on my own billing data?
Yes. Export your invoice, payment, and adjustment data from your PIMS and use this as a template — we model it into a Power BI report. The sample here uses synthetic data, so there are no real financials in the version on this page.
Build this report on your own data
Clone this Vet clinics template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →