Veterinary Cash Flow Template

Move to the 13-Week Cash Flow sheet and fill in projected revenue inflows week by week. Over-the-counter collections are the most predictable — use your average daily revenue and appointment schedule to estimate week-by-week inflows, adjusting for any known slow periods or scheduled high-volume weeks. Pet insurance reimbursements take 7–21 days after claim submission depending on the insurer; for most general practices these represent 5–15% of revenue but that share is growing. CareCredit and ScratchPay remittances typically arrive within 2–3 business days of the transaction, so they behave more like cash sales than insurance claims. Enter bi-weekly payroll amounts on the specific calendar dates they fall — for DVM associates especially, payroll is the most significant fixed outflow and the weeks it lands during lower-revenue periods are where cash shortfalls occur. Add external lab invoice due dates and any equipment financing payments.

The metrics that matter most in veterinary practice cash flow are COGS as a percentage of revenue, staff payroll as a percentage of revenue, and average client transaction. COGS should stay in the 22–28% range for most general practices; rising ratios indicate shrinkage, waste, pricing problems on dispensed medications, or a product mix shift toward lower-margin items. Staff payroll at 40–50% of revenue is the target; the combined COGS and payroll percentage is the most important number in the practice because the two together represent 65–78% of revenue and there is very limited room for operating expenses before profitability disappears. Average client transaction — total collections divided by total patient visits — is the output metric that synthesizes everything: a practice with strong case acceptance, appropriate pharmacy pricing, and efficient appointment utilization will consistently generate $250–$350 per visit; one with compliance problems or underpriced services will run $150–$175 and find it nearly impossible to cover DVM compensation and overhead. External diagnostic lab fees deserve separate tracking because they arrive as invoices 30 days after the test is run — easy to lose track of against total COGS unless they're broken out.