Healthcare Cash Flow Template

Download the .xlsx file and open it in Excel or Google Sheets. Start with the 13-Week Cash Flow sheet — this is the most immediately useful view for day-to-day practice management. Review the payer categories in the revenue rows and rename them to match your actual payer mix. Most practices keep Medicare, Medicaid, and commercial insurance as separate rows, with self-pay as a fourth. Enter your expected collections for the coming 13 weeks, using your current AR aging report and average collection timelines by payer as your guide. Then fill in your weekly expense estimates for payroll, supplies, and fixed costs.

Once the short-term view is set up, move to the Monthly Cash Flow and AR Aging sheets. The AR Aging Tracker is the most important diagnostic tool in the file: enter your outstanding claims by payer bucket each month and watch the days-in-AR metric. For most practices, days in AR should stay below 40 — if it climbs above 50 for a specific payer, that's a signal to follow up on outstanding claims or review your billing workflow for that payer category. The Monthly Cash Flow sheet is where you record what actually happened, building an auditable 12-month record that flows into the Annual Summary automatically.

Use the Dashboard each month to review your payer mix and cash trend charts with your office manager or billing team. The most common use case is catching a gradual rise in AR over 90 days before it turns into a cash flow problem — practices that review this monthly rarely face the surprise cash crunches that come from letting aging claims pile up. If you have a bank line of credit, the cash runway metric on the Annual Summary tells you how much buffer you actually have relative to your draw-down pace.

Healthcare practices face a cash flow problem that almost no other industry deals with: the work is done on Tuesday, but the cash might not arrive until six or eight weeks later — and only if the claim was filed correctly, the payer processed it on schedule, and no authorization issue caused a denial. For a busy primary care practice or specialty clinic, that lag between service and payment is constant, and managing it requires a different set of tools than a typical small business cash flow statement.

The two metrics that matter most in healthcare cash flow are days in accounts receivable and net collection rate. Days in AR tells you how long it takes to turn a billed claim into cash — the industry benchmark is under 40 days for commercial payers, though many practices run 45–60. Net collection rate, which is cash collected divided by net charges after contractual adjustments, tells you whether your billing team is capturing everything you're owed. A practice with 95%+ net collection rate is leaving almost nothing on the table; anything below 90% usually signals claim denial issues, aging write-offs, or gaps in self-pay follow-up. Tracking both numbers consistently is the foundation of sustainable cash flow management.

The practical workflow is this: pull your AR aging report from your EMR or billing software each month and enter the totals into the AR Aging Tracker. Note which payers are aging the most. File a 13-week cash projection based on what's already in the pipeline and your expected new billing volume. Then reconcile actual collections against projections at month-end. Practices that follow this cycle consistently find they can predict cash crunches 4–6 weeks out and take action — drawing on a line of credit, deferring a discretionary purchase, or prioritizing follow-up on a specific payer's aging claims — instead of reacting after the fact.