Track Solar Permits in Zoho CRM, Not a Spreadsheet

11.10.26 12:48 AM

How to Track Solar Permits in Zoho CRM Instead of a Spreadsheet

Short answer: Create one Zoho CRM stage for each step a solar job goes through, from signed contract through permitting, install, inspection, utility interconnection, and permission to operate (PTO). Each job becomes a record that sits in its current stage on a Kanban board, so anyone on the team can see which jobs are stuck without asking.

Why do permit spreadsheets break down?

Example scenario: A 12-person US solar installer has 40 active jobs in one spreadsheet. The ops manager updates it every Friday. Sales keeps asking where a customer’s job is, and nobody can tell which jobs are stuck with the city or the utility without digging through rows.

A spreadsheet shows what someone last typed. It doesn’t show what’s waiting, for how long, or on whom.

That gap gets expensive in solar because so much of the timeline sits outside your control. Permitting offices and utilities each work through their own queues. When a job stalls in one of those queues, the only way to catch it is for someone to notice. A Friday spreadsheet update means a stuck permit can sit for a week before anyone looks at it, and the customer usually notices first.

There’s also the question of who owns the update. When one person maintains the sheet, everyone else has to ask that person. When everyone edits it, columns drift and dates get typed several different ways, and before long nobody trusts it.

Step 1: Map your stages to the real steps

Use the steps your team already follows. A common sequence looks like this, but adjust it to your jurisdictions and utilities:
  1. Contract signed
  2. Site survey
  3. Design complete
  4. Permit submitted
  5. Permit approved
  6. Install scheduled
  7. Installed
  8. Inspection passed
  9. Interconnection submitted
  10. Permission to operate

Write a one-line definition for each stage, like “Permit submitted means the application is in the city’s portal and we have a confirmation number.” Clear exit criteria keep two people from putting the same job in different stages.

If some of your jurisdictions add steps, such as an HOA approval or a structural review, add them only if they happen often. Rare exceptions are better handled with a note or a checkbox than a stage every job has to pass through.

Step 2: Add only the fields each stage needs

Useful fields include the permitting authority, permit number, permit submitted date, utility application ID, and inspection date. Add a field when someone will actually fill it in at that stage.

Use the right field types. Dates should be date fields, so you can filter and build reminders on them. The permitting authority and utility work well as picklists, so you can report on which offices take longest without cleaning up spelling later.

If you want certain fields filled before a job moves forward, a Blueprint can require them at specific stage transitions. Blueprint needs Zoho CRM Professional or higher. Our beginner’s guide to Zoho CRM Blueprints covers how that works.

Step 3: Use a Kanban view

Show jobs as cards in columns by stage. Anyone can see at a glance how many jobs are waiting on permits and which ones have been there longest.

In Zoho CRM, a Kanban view groups records by a picklist field, such as the Deal Stage. Dragging a card into another column updates that field on the record, so the board and the record stay in sync. Creating a Kanban view requires the Module Customization permission, so an admin usually sets it up once for the team.

Put the fields people ask about most on the card, such as the customer name, the permitting authority, and the permit submitted date. That way a salesperson answering a customer call can find the status without opening the record.

Step 4: Decide who moves the cards

A board is only as current as the last person who updated it. Assign each stage to a role. For example, the permit coordinator moves jobs from Permit submitted to Permit approved, and the install lead moves them from Install scheduled to Installed.

When ownership is clear, nobody waits for a Friday update.

Step 5: Add small automations later

Once the board is in use, add a task when a permit is approved so someone schedules the install, and a reminder when a job sits too long in Permit submitted. Add these one at a time.

Zoho CRM workflow rules can create a task when a field changes, and scheduled actions can run a set number of days after a date field. With a Permit submitted date field, you can have the CRM create a follow-up task if the job is still in that stage after the number of days your local offices usually take. Our beginner’s guide to Zoho CRM workflows walks through the setup.

What makes it stick?

The stages match steps the team already uses, and there are no fields nobody fills in. If your crew can’t describe a stage in one sentence, cut it or merge it.

Common mistakes

  • Too many stages. If a stage rarely changes anything about what happens next, it’s noise. Merge it.
  • Building automations before the board is used. Reminders on a board nobody updates just create noise. Get a few weeks of real use first.
  • Tracking every permit type in one stage list. If you also do battery or electrical upgrade jobs with different approval paths, that may call for a separate pipeline or module. Decide that before you build, not after.
  • Leaving the spreadsheet running. If the old sheet stays open, people keep updating it. Pick a cutover date and archive it.

When don’t you need this?

If you’re running a handful of jobs at a time and one person tracks them all, a well-kept spreadsheet may be fine for now. The board pays off when several people need to see job status. If you’re weighing whether Zoho is more than you need right now, we wrote about when Zoho is overkill and when it’s the right move.

Watch the 60-second version

Frequently asked questions

Can Zoho CRM track solar permits?

Yes. Each job can be a record that moves through stages for permitting, install, inspection, and interconnection, shown on a Kanban board.

Should permits be deal stages or their own module?

We’d start with deal stages. If jobs often need several permits tracked separately, a custom module may fit better. Zoho CRM includes custom modules starting with the Standard edition, with higher limits on higher editions.

What does PTO mean in solar?

Permission to operate is the utility’s approval to turn on and connect a solar system to the grid. It’s usually the last step before a job is truly done.

Can I see how long jobs sit in each stage?

Yes, with stage history. For Deals it’s built in. Tracking stage history in other modules requires Zoho CRM Enterprise, Ultimate, or Zoho One. We explain how in Track stage history in any Zoho CRM module.

Can sales see job status without editing anything?

Yes. Profiles in Zoho CRM control what each user can do, so sales can view the board while only ops moves cards.

Next step

Our Solar page walks through the full workflow we set up for installers, signed contract to permission to operate. If you’d rather talk it through, book a 15-minute intro call with TechnoMap.

Schedule a Call
Join Our Newsletter

Jameson writes about how to choose the right tech for your business—not just what’s shiny, but what actually fits. With a focus on sales systems, finance, and business intelligence, he breaks down strategy, systems, and smart data moves that help businesses grow without the chaos.