​

Small businesses · Workflow guide

How small businesses can move from spreadsheets to a clear sales process

Small businesses often keep customers in a spreadsheet and quotes in personal inboxes. Import the sheet, build one pipeline from new lead to won, give each quote an owner and a next step, and let the owner review open work on a dashboard.

Explore the workflowBook a demo

Two small business owners talking at a counter in a bright local shop
Industry
Small businesses
Primary challenge
Spreadsheet contacts without owners
Arches CRM focus
Customer inquiries, contact management, sales follow-ups and task organization

Business goals

  • Keep every customer in one shared record
  • Give each quote an owner and next step
  • Let the owner see open sales work

Challenge and proposed solution

When the spreadsheet stops keeping up

Many equipment and installation businesses start by tracking requests in email and a spreadsheet. Once more people join, customers contact several employees and nobody is sure who owns the quote.

Challenge

Spreadsheet contacts have unclear ownership

Arches CRM setup

Import the sheet into shared contact and organization records, each with an owner and a next action.

Someone cleans the spreadsheet columns before the import.

Challenge

Quotes get lost in individual mailboxes

Arches CRM setup

Track each quote as an Opportunity with stages and a linked task, so the next step is on the record.

The quote itself is still prepared in the business's own tool.

Challenge

The owner cannot see pending sales work

Arches CRM setup

Use Opportunities and the Dashboard to review open work and tasks that are due.

The owner decides which items to chase first.

CRM configuration and daily workflow

What the team configures

  1. 1New lead
  2. 2Contacted
  3. 3Requirements confirmed
  4. 4Quote sent
  5. 5Negotiation
  6. 6Won or lost
  1. Import the existing spreadsheet

    Past leads and customers come in from a CSV file, so the CRM starts with real contacts rather than an empty list.

  2. Keep contacts and companies together

    Leads, contacts, companies and activities sit in one workspace instead of separate files.

  3. Build the sales pipeline

    Stages run from new lead to won or lost, with lost reasons so the owner can see why work was not booked.

  4. Assign owners and record next steps

    A workflow assigns each new lead to an owner and creates a task. Quotes and agreed next steps are noted on the record.

  5. Watch active work on a dashboard

    The default dashboard shows the pipeline by stage, replacing the separate spreadsheets that circulate by email.

Workflow recipe

Build it in Workflows

When a customer submits your request form, this workflow gives the inquiry an owner and a first task so no quote request waits in an inbox.

When

A form is submitted

Only if
  • The form is your website request form
Then
  1. Assign an owner
  2. Create a task to reply and prepare the quote
  3. Send an internal notification to the owner

Lucy participation

Where Lucy helps

  1. TriggerA quote has sat in the Quote sent stage with no open task for several days.
  2. ContextLucy reads the contact, the Opportunity notes and the activity the user is allowed to open.
  3. ProposalLucy suggests a follow-up task and drafts a short reminder message for the quote.
  4. ReviewA person reads the draft, edits it and approves it. Anything Lucy drafts for a customer waits for a person to approve it before it leaves.
  5. LoggedThe approved message and the follow-up task are logged on the record's activity, so the next person sees what was sent.

Before and after

How the process changes

Without the suggested setup

  • Customers live in a spreadsheet nobody owns
  • Quotes sit in personal mailboxes
  • Next steps depend on memory
  • The owner asks around to learn what is open

With the suggested setup

  • Customers sit in shared records with owners
  • Each quote is an Opportunity with a stage
  • Every open quote carries a next task
  • The owner reviews open work on one dashboard

A comparison of typical processes, not measured results.

How to configure

Set it up in five steps

  1. Add your first records

    In Sales > Contacts and Sales > Organization, add a few customers, or bring in a cleaned spreadsheet through Sales > Lead Finder > Import Leads.

  2. Configure the lead source

    In Sales > Lead Finder > Import Leads, import the spreadsheet, or use Sales > Lead Finder > Form Builder for a website request form.

  3. Set the Opportunity pipeline

    In Sales > Opportunities, open the pipeline settings and add the stages: New lead, Contacted, Requirements confirmed, Quote sent, Negotiation, Won or lost. Add lost reasons for work that is not won.

  4. Set tasks, workflows and the approval policy

    In Automation > Workflows, create a workflow on the stage changed or form submitted trigger that creates a task and assigns the owner. Lucy drafts stay as drafts until a person approves them. A plain Send email step in a workflow sends on its own, so use it only for messages you are happy to go out automatically.

  5. Check it with a test run

    Open the Dashboard to see the new records, check Communication > Notifications for the task alert, and open an Opportunity to confirm the quote task and owner appear.

Intended benefits

What this setup is designed to improve

Scope. Arches CRM is not accounting, inventory or installation scheduling software. It covers the sales process up to the won customer.

  • Designed to let employees work from shared records
  • Designed to give the owner a consistent view of the pipeline
  • Designed to keep quotes and next steps easy to find
  • Designed to improve process visibility, not to promise more sales

Screens

What the team sees in Arches

Opportunities board for Equipment Sales, stages New lead, Contacted, Requirements confirmed, Quote sent, Negotiation, Won
The opportunity pipeline: every open opportunity by stage, with its owner and value.
Contact record with calls, messages, tasks and Opportunities
The contact record: conversations, tasks and opportunities for one customer.

Questions about this workflow

Does Arches CRM replace an accounting system?

No. It organizes contacts, quotes and sales follow-up. Accounting stays in your current tool.

Can different employees work on the same account?

Yes. Shared records have an owner, and other users see them according to their role and permissions.

Can Lucy find neglected follow-ups?

Lucy can answer questions about records a user is allowed to see, such as open items with no next task. Any message it drafts needs a person's approval.

Business story: Moving from scattered notes to a sales process everyone can understandRead the story

Explore Arches CRM for Small Businesses.

Or book a demo and we will walk through this workflow with your own team.Explore Arches CRM for Small Businesses Book a demo
​