How to Set Sales Goals for a Small Business (Worksheet + Examples)

Updated 2026-10-31 · AI Agent Starter Kit

Most small business sales goals are a round number picked in January: "Let's do 20% more this year." Nobody knows where the extra 20% comes from, there's no weekly version of it, and by March it's forgotten.

A useful sales goal works backward. It starts with what you actually sold last year, turns a revenue target into jobs, jobs into quotes, and quotes into leads, then gives you a small number to watch every week. This guide walks through that math, a copy-paste worksheet for Google Sheets, and a monthly check so the goal adjusts instead of quietly dying.

Why most sales goals don't work

The fix is to separate the result you want (revenue) from the activity that produces it (leads, quotes, follow-ups). You can't decide how much a customer spends. You can decide how many quotes go out and how fast you follow up.

Step 1: Pull last year's real numbers

Before setting anything, gather five numbers from the last 12 months. Use your invoices, accounting tool or bank deposits for revenue, and your lead sheet or inbox for the rest.

1. Revenue (total invoiced or collected, pick one and stay consistent).
2. Number of jobs or sales.
3. Average job value (revenue divided by jobs).
4. Quotes or proposals sent.
5. Leads (inquiries from any source).

From those you get two rates:

• Close rate = jobs won ÷ quotes sent. See how to calculate close rate or use the free close rate calculator.
• Quote rate = quotes sent ÷ leads (how many inquiries turn into a real quote).

If you didn't track leads or quotes, estimate from your Sent folder for one recent month, write "estimate" next to the number, and start tracking now with a lead tracking spreadsheet. A rough real number beats a precise guess.

Remove one-offs: a single huge job, a month you were closed, or a client who won't return. You want the normal shape of your year.

Step 2: Pick the revenue target (three versions)

Set three numbers instead of one:

"Realistic change you can name" matters. Good reasons: a price increase you've already announced, a new service, a second crew, more referrals from a program you're starting. "Working harder" is not a lever.

Step 3: Work backward from revenue to leads

This is the core of the method. For each version:

1. Jobs needed = revenue target ÷ average job value
2. Quotes needed = jobs needed ÷ close rate
3. Leads needed = quotes needed ÷ quote rate
4. Per month = divide each by 12 (or weight by your busy season)
5. Per week = monthly ÷ 4.3

Now you have numbers you can act on this week: "We need about 6 new leads and 3 quotes a week."

If the lead number looks impossible, you have three other dials: raise the average job (pricing, packages, add-ons), raise the close rate (faster replies and steady follow-up, see how to follow up on a quote), or raise repeat and referral work (see how to get repeat customers and how to ask for referrals). Small improvements in each multiply.

Step 4: Split by month, not evenly

Most small businesses are seasonal. Look at last year's revenue by month and give each month its share of the target. If March was 6% of last year's revenue, March gets about 6% of this year's target.

Then mark the slow months. Those are when you plan marketing, ask past clients for referrals and fix systems, not when you panic.

Step 5: Add 2 or 3 activity goals

Revenue lags. Activity goals tell you this week whether you're on track:

• Leads per week (from Step 3).
• Quotes sent per week.
• First reply time (for example, "every new lead gets a reply within one business hour"). Faster replies tend to raise close rates; see the lead response calculator.
• Follow-ups done (every open quote gets a follow-up on schedule).

Pick two or three. More than that and nobody watches them. For turning these into a short weekly list, see how to set weekly goals.

Copy-paste sales goal worksheet (Google Sheets)

Create a tab called Goals. Put labels in column A and values in column B:

Add a second tab called Monthly with columns: Month, Target revenue, Actual revenue, Leads, Quotes, Jobs won, Close rate (=IFERROR(F2/E2,"")), Notes. Fill in actuals at month end.

Copy the Goals tab twice (Floor, Stretch) and change only row 8 to compare all three versions side by side.

The 20-minute monthly check

On the first workday of each month, fill in last month's row and answer five questions:

1. Revenue vs target: ahead, on track or behind?
2. Leads vs plan: was it a lead problem?
3. Quotes and close rate vs plan: was it a follow-up or pricing problem?
4. Average job value: did it drift?
5. One change for next month (only one).

If you're behind three months running, adjust the target or the plan in writing. A goal you quietly ignore teaches you to ignore goals. For a fuller monthly routine, see the monthly business review template.

Example: a one-person carpet cleaning business (illustrative)

These numbers are made up to show the math.

• Last year: $96,000 revenue, 480 jobs, 600 quotes, 750 leads.
• Average job $200, close rate 80% (most quotes are by phone and small), quote rate 80%.
• Target: $108,000, with a price increase planned that should lift the average job to about $215.
• Jobs needed: 108,000 ÷ 215 ≈ 503. Quotes: 503 ÷ 0.8 ≈ 629. Leads: 629 ÷ 0.8 ≈ 787.
• Per week: about 15 leads and 12 quotes, close to last year's pace. The growth comes from price and a small lift in jobs, not from doubling marketing.
• Activity goals: reply to every lead the same business day, follow up on every open quote within 2 days, ask every repeat client for a referral.

The goal feels doable because it is built from what the business already does.

Common mistakes

• Picking the number first, then the plan. Work backward from your real rates.
• Ignoring seasonality. An even monthly split makes slow months look like failures.
• Only tracking revenue. By the time revenue is low, the lead problem is two months old.
• Too many goals. One revenue target and two or three activity goals is enough.
• Never writing down the change. If you lower or raise the target, note why.
• Counting leads inconsistently. Decide what counts (form, call, email, DM) and keep it.

Using AI here (numbers come from you)

AI is useful for turning a monthly check into a short summary or brainstorming levers ("ways a carpet cleaner could raise the average job"). Keep it honest:

• Your numbers only. Paste in your real figures; never let it invent industry close rates or "typical growth."
• Formulas do the math. Use the sheet, not a chat answer, for the calculations.
• You decide the target. AI can list options; the goal is your call.

Get the weekly numbers counted for you

The hardest part of any sales goal is getting last week's leads, replies and won jobs without digging. The Weekly CEO Report Kit is an n8n workflow that runs every Monday at 7 AM. It reads your lead sheet and Gmail (and, if you connect it, Google Calendar), counts new leads, first replies, won and lost leads, stuck leads and overdue emails with code rather than AI, has AI write a short plain-English summary, strips out any number the AI made up, saves a one-page report to your Gmail Drafts and logs a row to a Weekly tab you can compare against your weekly targets. To be clear about what it doesn't do: it doesn't set your goals, read your invoices, bank or accounting tool, track revenue, or send anything to anyone but you. Get the kit

Want the leads and inbox side handled too? The Solo Ops Command Center bundle includes the Weekly CEO Report Kit plus Speed-to-Lead, which logs every new inquiry to a Google Sheet and drafts first replies and follow-ups that stop when the lead answers, and Inbox Chief of Staff, which sorts your Gmail and drafts replies in your voice, plus a dashboard sheet that charts the weekly trend. Every reply waits in Gmail Drafts. Nothing sends without you. Get the bundle

Related: Monday morning checklist for small business owners, a 30-minute start to the week that includes checking these numbers.

More guides

• Small Business Budget Template for Next Year (Simple Google Sheets Version)
• n8n Cloud vs Self-Hosted: Which Should a Small Business Choose?
• Lead Source Tracking for Small Businesses: How to Know Where Your Customers Come From
• How to Write a Cancellation Policy for a Small Business (Template + Examples)
• How to Set Weekly Goals as a Small Business Owner (With a Simple Template)
• How to Respond to an Introduction Email: 7 Templates for Small Business Owners
• How to Fire a Client Politely (Email Templates for Ending a Client Relationship)
• How to Calculate Automation ROI for a Small Business (Simple Formula and Worksheet)
• Follow-Up Email After a Networking Event: 7 Templates and a 48-Hour Plan for Small Business Owners
• Customer Communication Plan for a Small Business (Free Template)