The Funeral Home Spreadsheet That Stopped Us From Losing Paperwork Between the Arrangement Room and the Filing Cabinet

Build a funeral home case tracking system in Google Sheets — track death certificates, authorizations, and family documents without the filing cabinet chaos.

Last March, a family came back three days after their mother's service to pick up certified copies of the death certificate. I told them they'd be ready. They were ready — somewhere. I spent forty-five minutes checking the arrangement office, the prep room desk, the "pending" folder in our filing cabinet (which had become the "everything" folder), and finally my own email before I found the scanned copies sitting in a Drive folder labeled "Johnson — March?" with a question mark I apparently typed at midnight. The family waited in our lobby the entire time. That's not the experience you want to deliver to people on the worst week of their lives.

We're a small funeral home — three full-time staff, two part-time — handling around 200 cases a year. We don't need a $400/month funeral home management platform. What we needed was to stop losing documents between the arrangement conference and the filing cabinet. So I built a system in Google Sheets that tracks every case from first call to final paperwork, with every authorization form, death certificate, and insurance assignment attached directly to the row where the case lives. It took a weekend to set up. It's been running for fourteen months. Here's exactly how it works.

Why Funeral Home Paperwork Is Uniquely Brutal

Most industries deal with paperwork. Funeral service deals with paperwork under pressure, on a deadline, with grieving people in the room. A single case can generate fifteen to twenty-five separate documents: the arrangement contract, the authorization for embalming or cremation, the death certificate worksheet, the certified copies, the burial/transit permit, the veterans DD-214, the insurance assignment, the obituary draft, the clergy notes, the florist orders, the casket or urn selection sheet. Some of those are legal documents with real consequences if they go missing.

And unlike, say, a contractor who might have weeks between milestones, we're often managing six to ten active cases simultaneously, each at a different stage, each with a different family, each with documents arriving from different sources — the hospital, the coroner, the insurance company, the family themselves, the cemetery. The VA sends things by mail. The doctor's office faxes the cause-of-death correction. The family texts a photo for the memorial card at 11 p.m.

Our old system was a manila folder per case, a whiteboard in the back hallway, and the vague hope that whoever took the first call wrote everything down. It worked until it didn't. And when it didn't, the failure always happened in front of a family.

The Case Tracker: One Row Per Decedent, Everything Attached

The core of our system is a single tab I call "Case Log." Every case gets one row. The columns cover the essentials: Case Number, Decedent Name, Date of Death, Date of First Call, Next of Kin, NOK Phone, NOK Email, Service Type (burial/cremation/direct cremation/donation), Service Date, Location, Assigned Director, and Status.

Status uses a dropdown with six options: First Call, Arrangement Pending, Arrangement Complete, Services Scheduled, Services Complete, Case Closed. Conditional formatting turns the Status cell yellow for anything pre-arrangement, blue for scheduled, green for complete, and gray for closed. At a glance, I can see exactly where every active case stands without asking anyone.

But the columns that changed everything are the file columns. We have six dedicated attachment columns: Authorization Forms, Death Certificate (worksheet + certified copies), Insurance/Financial Docs, Obituary & Memorial, Service Program, and Misc Documents. Using FileFox, we drag the actual PDF, scan, or photo directly into the cell. The cremation authorization lives in the same row as the decedent's name. No more hunting through Drive folders named with someone's best guess at a filing convention.

The Document Checklist Tab: Because Missing One Form Can Delay a Burial

A case log tells you where things stand. But it doesn't tell you what's still missing. And in funeral service, one missing signature on a cremation authorization means the crematory won't accept the case. One missing certified death certificate means the family can't close a bank account, transfer a title, or file an insurance claim. These aren't inconveniences — they're the things that keep families stuck in grief logistics for months.

So I built a second tab called "Doc Checklist." Each row is a case (linked by Case Number), and the columns are every document that case type requires. For a standard burial, that's roughly fourteen columns: Arrangement Contract, Authorization for Embalming, Death Certificate Worksheet, Certified Copies Ordered, Certified Copies Received, Burial Permit, Cemetery Authorization, Insurance Assignment, Obituary Approved, Service Program Final, Clergy/Officiant Confirmed, Florist Confirmed, Music Selections, and Thank You Cards Ordered.

Each cell is a checkbox. When all fourteen boxes are checked, a formula in the "Complete" column turns green. When fewer than ten are checked and the service date is within 48 hours, it turns red. That red cell has saved us at least a dozen times — usually it's the burial permit or the cemetery authorization that someone assumed someone else had handled.

That formula goes in the "Status" column of the Doc Checklist tab. P2 is the Service Date. Adjust the count based on how many document columns you're tracking. The emoji might seem informal for a funeral home, but trust me — when you're scanning forty rows at 7 a.m. before a 10 a.m. service, a red warning emoji is exactly what you need.

The Financial Tab: Tracking Payments Without Losing Insurance Paperwork

The financial side of funeral service is one of those things nobody outside the industry talks about, but it's where half the administrative headaches live. A single case might have a family payment, a partial insurance assignment, a pre-need trust fund disbursement, and a veterans burial allowance — all arriving at different times, from different sources, in different formats. Tracking what's been paid, what's pending, and what's outstanding is critical, and losing the insurance assignment form means starting the process over.

Our Financial tab has one row per case with columns for: Total Contract Amount, Amount Collected at Arrangement, Insurance Carrier, Policy Number, Assignment Sent (checkbox), Assignment Received (checkbox), Insurance Amount, Pre-Need Fund, VA Benefit, Other Credits, Balance Due, and Payment Status. The Assignment Sent and Assignment Received columns have conditional formatting — yellow if sent but not received after 14 days, red after 30.

The file attachment column on this tab is where we drop the actual insurance assignment form, the pre-need contract, and any payment receipts. When an insurance company calls and asks "did you send the assignment?" — which happens constantly — I can pull it up in ten seconds and confirm the date, the amount, and forward them the scanned copy. Before this system, that call would eat twenty minutes and end with me promising to call back.

The Death Certificate Workflow: The Single Biggest Bottleneck We Fixed

If you work in funeral service, you already know: death certificates are the bottleneck. The funeral home completes the demographic information. The attending physician or medical examiner certifies the cause of death. The local registrar files it. The state issues certified copies. Every step involves a different office, a different timeline, and a different way things can stall. And families call about their certified copies more than anything else.

We added a dedicated "DC Tracker" tab with columns for: Case Number, Decedent Name, Worksheet Completed (date), Sent to Physician (date), Physician Name, Physician Signed (date), Filed with Registrar (date), Certified Copies Ordered (quantity), Certified Copies Received (date), Copies Delivered to Family (date), and Notes. The Notes column handles the inevitable complications — "Dr. Martinez on vacation until 3/15, covering physician Dr. Patel contacted" or "Cause of death amended per coroner, refiled 4/2."

A simple formula flags any case where more than seven business days have passed since the worksheet was sent to the physician without a signature date entered. That's our trigger to follow up. Before this system, we followed up when the family called to ask — which meant we were always reactive instead of proactive. Now our administrative assistant checks the DC Tracker every morning and makes follow-up calls before families have to.

Making It Work With Multiple Staff and Inconsistent Schedules

Funeral homes don't run 9-to-5. First calls come at 3 a.m. Arrangements happen on Saturdays. The director who starts a case might not be the one who finishes it. That means the spreadsheet has to be the source of truth that everyone checks, not a tool only one person understands.

Three things made adoption work for our team. First, I put a Dashboard tab at position one in the sheet. It uses QUERY formulas to pull all active cases (anything not "Case Closed") into a summary view with the case number, decedent name, service date, assigned director, and status. Anyone opening the sheet sees the current caseload immediately. Second, I added data validation dropdowns to every column that could be standardized — Service Type, Status, Cemetery Name, Clergy Name. No more "cremation" vs. "Cremation" vs. "crem" vs. "direct crem" breaking our filters. Third, I color-coded the tabs: green for the Dashboard, white for the Case Log, yellow for the Doc Checklist, blue for the Financial tab, and orange for the DC Tracker. Small thing, huge difference when someone is clicking through tabs on a phone at a removal.

We also set up a simple Google Sheets notification rule (Tools → Notification settings → "Any changes are made") filtered to the Doc Checklist tab. When someone checks off a document as received, the other staff see it in their email. It's not fancy, but it means the director on call knows the burial permit came through without anyone having to text them.

What This System Doesn't Replace (And What It Does)

I want to be honest about what this is and isn't. This system doesn't replace your state's electronic death registration system (EDRS). It doesn't replace proper accounting software if you're doing volume that requires it. It doesn't replace your case management software if you're a large firm doing 500+ cases a year and need integrated printing for statements of goods and services.

What it replaces is the gap. The gap between the arrangement conference and the filing cabinet. The gap between "I scanned that form" and "I can find that form." The gap between knowing a case is in progress and knowing exactly what's still missing. For a small to mid-size funeral home doing under 300 cases annually, this system handles the daily operational reality that expensive software either overcomplicates or ignores entirely.

It also gives you something most funeral home software doesn't: the ability to customize on the fly. When our state changed its death certificate filing process last year, I added two columns and updated a dropdown in fifteen minutes. Try getting your software vendor to push a custom update that fast.

If you're going to build this, start with the Case Log and the Doc Checklist. Those two tabs alone will change your mornings. Add the Financial and DC Tracker tabs once the team is comfortable with the rhythm. And for the love of everything, use consistent naming in your file attachments — "LastName_FirstName_CremAuth_2025" will save you at 2 a.m. when nothing else will.

Frequently Asked Questions

What's the best way to track death certificates in a spreadsheet?

Create a dedicated tab with columns for each milestone: worksheet completed, sent to physician, physician signed, filed with registrar, certified copies ordered, and certified copies received. Add date fields for each step and a formula that flags cases stalled longer than 7 business days at any stage. Attach scanned copies directly to the row so you can pull them up instantly when families call.

Can Google Sheets handle funeral home document management?

For small to mid-size funeral homes handling under 300 cases a year, absolutely. The key is structuring your sheet with separate document attachment columns (authorization forms, death certificates, insurance docs) rather than one generic "files" column. With a tool like FileFox, you can drag PDFs and scans directly into cells, so every document lives in the row where the case lives.

How do I organize funeral home paperwork digitally?

Start with a case tracking spreadsheet where each row represents one decedent. Use a companion checklist tab with checkboxes for every required document per case type. Attach scanned originals to the case row so they're findable by case number, not by whoever named the file in Drive. Color-code status columns so you can see at a glance what's complete and what's missing.

What documents should a funeral home track per case?

At minimum: arrangement contract, authorization for embalming or cremation, death certificate worksheet, certified copies, burial or cremation permit, insurance assignment (if applicable), obituary, and service program. Veterans cases add the DD-214 and VA burial allowance application. Pre-need cases add the pre-need contract and trust documentation. Build your checklist tab to match your state's specific requirements.

Is there a free funeral home management template for Google Sheets?

There's no one-click funeral home template, but a project tracker template with file attachment columns gets you 80% of the way there. Add columns for Service Type, Next of Kin, and your document categories, then build a checklist tab with checkboxes for required documents. The setup takes a few hours, but it's fully customizable to your state's requirements and your firm's workflow.