Disclosure: Some links in this post are affiliate links. If you buy through them, I may earn a commission at no extra cost to you. I only recommend tools I use or am actively testing.
The spreadsheet always dies the same way
Every solo operator starts tracking quotes in a spreadsheet, and every spreadsheet ends the same way: three weeks of tidy rows, then a busy month, then a file nobody trusts. The problem is not discipline. It is double entry — copying form submissions into a sheet by hand is work that quietly stops happening. The fix is to track quotes in a table that fills itself, directly from the form people already submit.
One submission, one row, zero copying
Jotform Tables is the table view attached to the same forms from the quote funnel — the setup this blog walks through on the Operators Toolbelt blog. Every submission arrives as a row, with the customer’s answers already in the columns: name, contact, size, timeline, budget, photos. Nothing to transcribe, nothing to mis-type at 9 PM. The table is not a second system to maintain; it is the form’s own data, wearing a spreadsheet’s face.
The columns that actually run your pipeline
- Status: new, quoted, following up, booked, closed — updated with one click as the job moves.
- Quote sent date: so your follow-up sequence and your own memory agree.
- Next touch: the date the next nudge is due, for anything the automation does not cover.
- Outcome: won, lost, or ghosted — the column that teaches you your real close rate.
Five columns, honestly kept, beat twenty columns abandoned by March. Sort by status each Monday and your whole pipeline is on one screen: who is waiting on you, who you are waiting on, and which quotes have gone cold enough to close out.
Review it like a foreman, not a bookkeeper
The table earns its keep in a five-minute weekly review. Count the new rows. Chase the stale “quoted” rows. Close the dead ones without guilt. Over a few months, the outcome column starts telling you the truth about your pricing, your response time, and your follow-up — the numbers a one-person business actually steers by, gathered without a single evening of data entry.
Next reads: The Quote-Request Funnel and more on the Operators Toolbelt blog · Free Tool Stack for a One-Person Business