Johann Ortiz-Franco
Johann Ortiz-Franco is the cofounder of VetSim consulting. A former mechanical engineer, Johann applies his analytical discipline to independent practices, uncovering the insights that drive measurable growth.
Read Articles Written by Johann Ortiz-Franco
In the 1980s, American manufacturing faced a crisis. Japanese competitors started to produce higher-quality products at lower cost because they were better at collecting and analyzing operational data. The issue for U.S. manufacturers wasn’t the available technology — it was how the data was being collected, and how reliable and usable that data was. Manufacturers were drowning in measurements they couldn’t use.
Today, many veterinary clinics face a similar challenge. Manufacturing proved that systematic data discipline at the point of collection can transform an entire industry. Here is how these same foundational processes of standardization, real-time validation, documented procedures, and continuous measurement can reduce administrative waste, strengthen patient safety, and unlock more value from existing systems.
1. Collection: Capture What Actually Matters
Most veterinary practice management systems were originally built to ensure accurate billing rather than to capture clinical data effectively. The solution is to practice intentional data capture right at the moment information enters your system using the right tools.
Every clinic should leverage three core data collection tools: digital intake forms to eliminate paper transcription, mandatory software fields to prevent staff from skipping critical clinical data, and integrated payment terminals that automatically log results into the patient chart without human intervention.
- Implement digital intake for new clients: Handwritten forms often lead to inconsistent and incomplete records. Most practice information management systems already include digital intake tools, yet many clinics rely on paper forms. Create a template with dropdown menus. Be sure to make critical fields mandatory.
- Require patient weight before prescribing: Missing weights can lead to medication dosing errors, which are among the most common medical errors in veterinary medicine.1 This can be fixed by making weight a mandatory field in your software before medications can be added.
- Capture charges as services happen: Practices that enter charges during appointments rather than at checkout reduce missed charges significantly. Train your clinical staff to add services directly to the file during the appointment. Turn on automatic charge posting if your software supports it to catch unusual low invoice totals.2
2. Standardization: Make Data Comparable
Inconsistent data limits the usefulness of reporting. Without strict standardization, your system treats entries like “Lab” and “Black Lab” as two entirely separate breeds, ruining your reporting. To implement basic data standardization, audit your existing database to identify duplicates and typos, map those variations to a single accepted term, and lock down your software configuration so that text entry is disabled for these fields.
- Use structured diagnoses for every visit: Only 6% of veterinary visits include a structured diagnosis code.3 This means 94% of visits generate no searchable clinical information. Use preloaded lists like VeNom codes.4 If not available, create a top-20 diagnosis list (e.g., otitis externa, periodontal disease), and require doctors to enter at least one per visit.
- Enforce dropdown menus for breed and species: Turn on dropdown or autocomplete features in your system so staff cannot type free text. Train everyone to always select from the preapproved list. Run a one-time audit to search for common misspellings, then bulk update obvious duplicates to a single standard term.
3. Hygiene: Keep Data from Degrading
Data rots quickly if you do not actively maintain it. Client contact information changes constantly, and every invalid email represents lost revenue. Maintaining basic data hygiene requires a proactive routine: Establish a script for your front desk to verify contact details at every touchpoint, set up automated data validation tools within your system, and dedicate 15 minutes every week to review exception reports before errors compound.
- Verify contact information at checkout: Most practices operate with 30% to 40% invalid phone numbers and email addresses.5 Make confirming contact info a standard part of the checkout procedure. Train the front desk team to ask if the phone number and email address on file are still current.
- Write down your data quality standards: Create a simple reference document that clearly outlines your expectations, such as requiring a weight before medications. Post these standards at eye level and review your data metrics monthly.
- Run weekly communication audits: Every Monday morning, pull a report of all communications that bounced or failed delivery over the previous week. Flag those client records to verify contact info at the next visit. Track your bounce rate monthly and aim to reduce it.
When you collect data correctly and consistently, you can answer critical business questions instantly and improve patient safety. Clean data is built one small habit at a time.
References
- Wallis J, Fletcher D, Bentley A, Ludders J. Medical errors cause harm in veterinary hospitals. Front Vet Sci. 2019;6:12.
- Fielding CL. A delay in entering invoice charges is associated with a decrease in total invoice amount in equine practice. JAVMA. 2024;262(6):785-790.
- Jones-Diette JS, Brennan ML, Cobb M, Doit H, Dean RS. A method for extracting electronic patient record data from practice management software systems used in veterinary practice. BMC Vet Res. 2016;12(1):239.
- VeNom Coding. Updated February 2026. Accessed May 20, 2026. https://venomcoding.org.
- Carter C. The power of data: how it can help your veterinary practice thrive. Ally DVM. February 15, 2023. Accessed May 20, 2026. https://www.allydvm.com/insights/the-power-of-data
