Free Business Permit Tracker Template (Google Sheets)

Why you need a permit tracker

I used a spreadsheet just like this one for two years when I worked in bar management. It saved us at least twice — once when a health permit was 30 days from expiring and nobody else had noticed, and once when we realized our fire inspection certificate had a different renewal date than we thought.

The average bar or restaurant holds 8 to 15 permits and licenses, each with a different renewal date, issuing agency, and penalty for being late. Some renew annually. Some every two years. Some are on a calendar year. Some are on a rolling anniversary from the date you were issued.

If you're tracking all of this in your head, or not tracking it at all, you're going to miss one. And missing one means fines, forced closures, or both.

Below is a free Google Sheets template you can copy and start using today. It's simple, it works, and it's better than a Post-it note on your monitor.

What the template tracks

One row per permit, with columns for everything you need at a glance:

Permit name: What it is. Liquor license, health permit, fire inspection, business license, etc.
Issuing agency: Who issued it. State ABC, county health department, city clerk, fire marshal.
License/permit number: The actual number on the permit. You'll need this when you renew.
Status: Active, expired, applied, or pending. Color-coded so you can see problems immediately.
Issue date: When it was issued or last renewed.
Expiry date: When it expires. This is the column you care about most.
Days until expiry: Auto-calculated. Shows how many days you have left. Goes red when it drops below 30.
Renewal cost: What it cost last time. Helps with budgeting.
Renewal URL: Direct link to the agency's online renewal page. One click, no searching.
Notes: Inspector names, contact numbers, application reference numbers. Anything you might need later.

How to set it up

Step 1: Make a copy

Open the template link and click File > Make a copy to save it to your own Google Drive. Don't request edit access to the original. You need your own copy.

Step 2: Fill in your permits

Start with the permits you already have. Pull out every license, certificate, and permit your business holds. Check the actual documents (not your memory) for the exact expiry dates and permit numbers.

Common permits to include:

General business license (city or county)
State business registration / LLC annual filing
Liquor license (if applicable)
Food service / health department permit
Fire safety inspection certificate
Certificate of Occupancy
Sign permit
Sales tax permit
Workers compensation policy
Music / entertainment license
Outdoor dining / sidewalk cafe permit
Tobacco sales permit (if applicable)

If you aren't sure what permits you need, run the free permit checker first. It will give you a full list based on your business type and location. For example, here's what a bar typically needs and what a restaurant typically needs.

Step 3: Set up calendar reminders

The spreadsheet will show you what's expiring and when, but it won't remind you. You need to set up reminders yourself. Here's one way to do it:

For each permit, create four Google Calendar events: 90 days before expiry, 60 days before, 30 days before, and 7 days before.
Set each event to send you an email notification.
In the event description, include the permit name, the renewal URL, and the cost.

Yes, this is tedious. For 12 permits, that's 48 calendar events. And you have to redo it every time you renew. But it works if you actually do it.

The formulas that make it work

The template includes a few formulas worth understanding in case you want to customize it.

Days until expiry

The "Days Left" column uses this formula:

=IF(F2="", "", DATEDIF(TODAY(), F2, "D"))

Where F2 is the expiry date cell. This returns the number of days between today and the expiry date. If the expiry date is in the past, it returns a negative number, which means you're already late.

Conditional formatting

The template uses conditional formatting on the "Days Left" column:

Red background: 0 or fewer days remaining (expired)
Orange background: 1 to 30 days remaining (expiring soon, act now)
Yellow background: 31 to 60 days remaining (start the renewal process)
Green background: 61 or more days remaining (you're fine for now)

Status dropdown

The Status column uses data validation to limit entries to: Active, Expired, Applied, Pending, Not Started. This keeps the data clean and makes it easier to filter.

Example: what a filled-in tracker looks like

Here's what the template might look like for a bar in Houston, Texas:

Mixed Beverage Permit / TABC. MB-123456. Active. Expires 09/30/2027 / 548 days: $6,281, tabc.texas.gov/renew
Food and Beverage Certificate / TABC. FB-789012. Active. Expires 09/30/2027 / 548 days: $381 / tabc.texas.gov/renew
City of Houston Business License / City Clerk / BL-2026-4455 / Active / Expires 12/31/2026 / 292 days / $150 / houstontx.gov/revenue
Harris County Health Permit / Harris County Public Health / HP-33221 / Active / Expires 06/15/2026 / 93 days / $450 / harriscountytx.gov
Fire Inspection Certificate / Houston Fire Department / FI-2026-088 / Active / Expires 03/01/2027 / 352 days / $100 / houstontx.gov/fire
Sign Permit / City of Houston / SP-8877 / Active / Expires 12/31/2026 / 292 days / $75 / houstontx.gov/planning
Sales Tax Permit / TX Comptroller / 32-1234567-8. Active. No expiry: n/a / Free / comptroller.texas.gov
ASCAP Music License / ASCAP / 555-2026-HOU. Active. Expires 12/31/2026 / 292 days: $400 / ascap.com

Eight permits, four different agencies, three different expiry dates just in the next year. And that's a relatively simple setup.

Limitations of a spreadsheet tracker

The template works. I used one myself for two years. But I should be honest about where it falls short.

It doesn't remind you

The spreadsheet shows you the data, but it doesn't send you an email when a deadline is coming up. You have to remember to open it and check. If you set up the Google Calendar reminders from Step 3, that helps. But it's a manual process, and it breaks the moment you renew a permit and forget to update the calendar events.

It doesn't know what you're missing

A spreadsheet only tracks what you put into it. If you forgot to get a permit (or didn't know you needed one) the spreadsheet won't flag it. You only find out when an inspector shows up. This is especially common with permits vs licenses — people often get the license but miss the permits, or vice versa.

It's easy to neglect

Be honest with yourself: how many spreadsheets have you created with good intentions and then never opened again? A tracker only works if you actually maintain it. Updating dates, adding new permits, removing old ones. It takes discipline.

It doesn't scale

If you have one location with 10 permits, a spreadsheet is fine. If you have three locations with 12 permits each, you're managing 36 rows across multiple sheets, with different jurisdictions and different renewal cycles. It gets messy fast.

When to upgrade from a spreadsheet

The spreadsheet is a good starting point. Use it if you're just getting started, if you have one location, or if you want to get a handle on what you currently have before committing to a tool.

But if you find yourself opening the spreadsheet less and less, or if you have already missed a deadline because you forgot to check, that's your sign you need something that checks for you.

That's why we built PermitDue. It does everything this spreadsheet does, plus:

Automatic reminders at 90, 60, 30, and 7 days before expiry. No Google Calendar hacks.
Permit discovery: it tells you what permits you need based on your business type and location, so you don't track only the ones you remembered.
Direct renewal links to the actual .gov pages where you renew, verified and updated.
Multi-location support with a dashboard that shows all your locations in one view.
Annual billing — $99/year for a single location, $299/year for up to 3. No monthly fees.

If the spreadsheet is working for you, keep using it. Seriously. But when it stops working — and for most people it eventually does — PermitDue is here. Annual plans, year-round reminders, no more forgotten deadlines.