How to Set Up a Roofing Follow-Up Spreadsheet

A spreadsheet works if you keep it current

You do not need another platform to keep roofing follow-up clear. You need a place where every request has an owner and a next step, kept current. A spreadsheet does that fine, as long as it has the right columns and someone actually updates it.

Here is a simple template you can copy today, the reason each column exists, and the short daily habit that makes it work. If you'd rather not build it yourself, we have a ready-made version linked at the end.

The columns your follow-up sheet needs

The free tracker uses eight columns. Keep them limited to the details the next person needs to act. A sheet you keep current beats a detailed one you abandon.

Keep the sheet lean

For Status, keep the options to four: Needs Action, In Progress, Booked, and Not Booked. The four status values make it easier to distinguish work that still needs attention from a recorded outcome.

That's the whole sheet. Everything else, like estimating, photos, and job costing, belongs in another tool. This sheet has one job: give the team a place to see what is still owed after a request arrives.

How to set up the sheet

You don't need a fancy build, and no formulas are required. The value isn't in the spreadsheet being clever. It's in every request having an owner and a next step in one place everyone can see. Set it up like this:

• Open one blank sheet and name the first tab something plain, like "Follow-up."
• Put the eight column headers across the top row.
• Add one row per open request. One request, one row, no exceptions.
• Freeze the top row so the headers stay visible as the list grows.
• Optional: sort or filter by Status so "Needs Action" floats to the top.

The daily habit that makes it work

A template is not a system. The habit is.

Once a day, go down the sheet and answer one question: which rows need action today? Work the "Needs Action" rows and anything whose Next action date has arrived. After each touch, update Last action and Next action, and move the Status. Use only channels the homeowner has agreed to, and honor any do-not-contact request. Then close the sheet and get back to work.

That short daily pass is the entire discipline. If you want the fuller version, with how to assign owners and run a weekly pass on the requests that went quiet, our simple roofing follow-up process for small teams walks through it.

What to keep out of the sheet

The fastest way to kill a follow-up sheet is to turn it into a database. Every extra column is one more thing to keep current, and the first thing that slips when the week gets busy is the maintenance nobody strictly needs.

So keep estimating, measurements, material lists, and photos somewhere else. This sheet answers who owns each request and what happens next. Those details can become difficult to act on when they are missing, and a plain sheet can keep them visible.

When to reassess the spreadsheet

A spreadsheet may still work for more than one person. The question is whether the team can keep one current version, see who owns every open request, and update it without ambiguity. When that becomes difficult, assess whether a focused tool would help.

If that's where you are, the question isn't "which spreadsheet," it's whether a tool would earn its place. We walk through that decision, without pushing you toward software you don't need, in how to track roofing leads without another CRM.

Skip the build if you want

If you prefer a ready-made workbook, download the free roofing follow-up tracker. It uses the fields above and includes fictional sample rows. It is not a CRM or an estimating tool; it gives the team a prepared place to keep ownership, recorded activity, and next actions visible.

Frequently asked questions