Healthcare Invoice Template

Setup takes about 20 minutes. Download the .xlsx file and open it in Excel or Google Sheets. Start with the Patient List sheet — add your active patients with their insurance carrier, policy number, and copay amount. Then go to the Service Codes sheet and enter the CPT codes your practice bills most frequently along with your standard charges. Once those two lookup tables are populated, creating invoices is mostly dropdown selection rather than manual entry, which cuts both the time and the error rate significantly.

To create a patient invoice, go to the Patient Invoice sheet, enter the invoice number and date, and select the patient from the dropdown — their insurance and billing details populate automatically. In the service table, select each CPT code from the dropdown, enter the date of service and units, and record the insurance payment applied and any copay collected at the visit. The balance due calculates automatically. For patients with secondary insurance, add that payment in the second insurance column before finalizing the patient balance. Print or export to PDF to send.

The ongoing value is in the Invoice Log and AR Aging Report. After sending each invoice, log it in the Invoice Log with the billed amount and payment status. Update the status when insurance payments post and when patient payments clear. Once a month, run through the AR Aging Report to see how much is outstanding in each aging bucket — anything creeping into the 61–90 day range needs a follow-up call, and anything over 90 days needs a decision: write it off, send to collections, or escalate. Practices that review AR aging monthly collect significantly more than those that only look when cash gets tight.

Healthcare billing is slower and more complex than most industries because every invoice passes through at least two parties before you collect — the insurance company first, then the patient for their remaining balance. The average practice waits 25–45 days for insurance reimbursement, then waits again for the patient to pay their portion. Without a structured system to track where each claim stands, balances fall through the cracks: insurance pays but the patient balance never gets billed, or a claim denies and nobody follows up. The industry benchmark for days in accounts receivable is under 30 — most practices that don't actively manage their billing cycle run closer to 50.

A healthcare invoice needs to capture information that a generic invoice template doesn't have room for: your NPI and Tax ID (required on every billable claim), the patient's insurance carrier and member ID, CPT codes for each service rendered, and the separate amounts for insurance payment and patient responsibility. The split between what insurance covered and what the patient owes isn't something you can calculate at the end — it has to be tracked per service line, because different services may have different cost-sharing rules under the same plan. A template built for healthcare keeps those fields in the right places so the math works out correctly.

The AR aging report is the operational tool that separates practices with healthy cash flow from those that are always behind. The standard practice is to review it monthly: anything under 30 days is normal, 31–60 days needs to be verified that the claim was submitted and accepted, 61–90 days needs a follow-up call to the payer, and anything over 90 days should have a decision attached to it. Industry benchmarks say less than 15% of your AR should be over 90 days — if that number climbs above 20%, you have a systemic billing problem, not just a few slow payers. This template gives you that report pre-built so you can run the review without spending an hour reformatting data.