Sales & CRM

How to run a weekly sales pipeline review as Small Law and Accounting Practices

Sales & CRMFor Small Law and Accounting Practices2 apps12 steps~24 min to set up

At a six-attorney firm or four-CPA practice, the weekly pipeline review is a 45-minute scramble before Monday morning standup. Someone pulls the Clio matter list, someone else opens QuickBooks to check outstanding invoices, a third person reads their Outlook drafts folder to reconstruct which clients got an update last week. There's no single view of 'active matters × billing status × last client contact.' The partners who close business track prospects in their personal inboxes or a shared Google Sheet that's three weeks stale. By the time you've synthesized it all, half the meeting is over and you still don't know which open matters are at risk of going dark.

Build this on Starch → See the apps used

Sales & CRMFor Small Law and Accounting Practices2 apps12 steps~24 min to set up

Outcome

What you'll set up

A live pipeline dashboard that shows every active matter or engagement alongside its billing status, last client contact date, and next deadline — pulled from Outlook, QuickBooks, and your practice management tool, refreshed automatically

A weekly digest that surfaces which matters haven't had client contact in 14+ days, which invoices are 30+ days outstanding, and which prospects in your intake queue have gone cold — delivered to your inbox before Monday standup

A CRM tailored to how your firm actually tracks business development — by referral source, practice area, originating partner, or matter type — instead of a generic sales pipeline built for SaaS companies

The Starch recipe

Apps, data, and prompts

The combination of Starch apps, the data sources they pull from, and the prompts you use to drive them.

Apps used

CRM Sales Agent CRM

Data sources & config

Starch syncs your QuickBooks data on a schedule (invoices, payments, outstanding balances by client) and syncs your Outlook messages on a schedule so contact history is always current. Your CRM lives natively in Starch — no separate tool to connect. For practice management tools like Clio or MyCase that don't have a scheduled-sync connection, Starch automates them through your browser — no API needed — or you connect them from Starch's integration catalog of 3,000+ apps. Slack is connected from Starch's integration catalog for digest delivery.

Prompts to copy

Build me a CRM for a small law firm that tracks prospective clients by practice area (litigation, transactional, estate planning), referral source, intake date, conflict-check status, and originating partner. Add a pipeline stage field with these stages: Inquiry, Conflict Check, Engagement Letter Sent, Active Matter, Closed Won, Declined. I want to be able to ask 'which prospects have been in Conflict Check for more than 5 days?' and get a real answer.

Every Monday at 7am, pull my active CRM deals where last_contact_date is more than 14 days ago, cross-reference with QuickBooks to flag any that have an outstanding invoice over $5,000, and send me a Slack message listing them with the partner responsible for each matter.

Build me a weekly pipeline summary that shows: (1) new inquiries this week by practice area, (2) matters that moved to Active this week, (3) outstanding invoices by matter grouped by partner, (4) any matter where we haven't logged a client touch in 21+ days. Pull billing data from QuickBooks and contact history from Outlook.

Run these in Starch → or paste them into your favorite agent

Walkthrough

Step-by-step

1 Connect QuickBooks as a scheduled-sync provider. Starch pulls your invoices, payments, and outstanding balances by client on a recurring schedule — so billing status is always current without any manual export.

2 Connect Outlook as a scheduled-sync provider. Starch reads your sent and received messages so it can calculate last-contact-date for any client or prospect automatically.

3 Start with the Starch CRM app and describe your firm's actual pipeline. Tell Starch your practice areas, the stages a prospect moves through (Inquiry → Conflict Check → Engagement Letter → Active → Closed), and the fields that matter to your partners (referral source, originating attorney, matter type).

4 Import your existing prospect list — whether it's a spreadsheet, an Outlook contacts export, or a Clio matter list. Starch cleans the data and maps it into your custom schema.

5 Wire the conflict-check step. If your conflict check lives in a shared spreadsheet or a browser-accessible system, Starch automates the lookup through your browser — no API needed — and logs the result back into the CRM record.

6 Set up the weekly pipeline automation. Describe the digest you want: which matters are stale, which invoices are outstanding, which prospects have gone cold, which new inquiries came in. Starch assembles it from your connected data and sends it on a schedule you pick — Monday at 7am works well.

7 Add a 'last client contact' calculated field to every active matter. Starch cross-references Outlook message history with your CRM contacts and populates it automatically — no manual logging required.

8 Build the partner accountability view. Ask Starch for a dashboard that groups open matters and outstanding receivables by originating partner, so your Monday standup has a single screen everyone is looking at.

9 Set up the intake triage automation. When a new inquiry comes into your Outlook inbox, Starch identifies it, creates a CRM record, assigns it to the right practice area queue, and sends a draft acknowledgment email for the responsible attorney to review and send.

10 Run your first pipeline review using the Starch dashboard instead of pulling five tabs. The meeting agenda becomes: review the stale matters list, review outstanding invoices, review the new inquiry queue. Each section is a saved view in Starch that refreshes before the meeting.

11 After four weeks, ask Starch a natural-language question against your pipeline history: 'What's our average time from inquiry to engagement letter by practice area?' Use the answer to identify where your intake process is slowing down.

12 Publish your firm's CRM configuration as a private template so new partners or lateral hires can onboard to your pipeline system without the managing partner spending two hours explaining how the shared spreadsheet works.

See this running on Starch

Connect your tools, describe what you want, and the agent builds it. Closed beta is free.

Try it on Starch →

Worked example

Week of April 14, 2026 — Pipeline Review at a Four-Partner Litigation Firm

Sample numbers from a real run

New inquiries this week	7
Matters stuck in Conflict Check >5 days	3
Active matters with no client contact in 21+ days	5
Outstanding invoices >30 days (total)	94,000
Engagement letters sent, not yet signed	4

On Monday at 7:05am, the managing partner opens her Starch digest in Slack. Seven new inquiries came in last week — three employment matters, two commercial disputes, two estate referrals. Three of those are stuck in Conflict Check for more than five days; Starch flags them by name and assigns follow-up to the intake coordinator. Five active matters haven't had a logged client touch in 21 days or more — two of them are being handled by the same associate who's been in trial prep. The digest surfaces $94,000 in invoices that are more than 30 days outstanding, grouped by originating partner, so the billing conversation in the Monday meeting is two minutes instead of fifteen. Four engagement letters went out last week and haven't come back signed; Starch has already drafted follow-up emails queued for the responsible attorneys to review and send. The whole standup takes 22 minutes. Nobody had to build a spreadsheet the night before.

Measurement

How you'll know it's working

Average days from inquiry to engagement letter signed, by practice area

Outstanding receivables by originating partner (30/60/90-day buckets)

Number of active matters with no client contact in 14+ days

Intake-to-close conversion rate by referral source

Conflict check cycle time (days from inquiry to conflict clearance)

Comparison

What this replaces

The other ways teams handle this today, and how the Starch version compares.

Clio Manage

Clio tracks matters and time entries well, but it doesn't generate a weekly pipeline digest, cross-reference billing status against contact recency, or let you describe a custom BD pipeline in plain language — you're still pulling exports and building that view yourself.

HubSpot CRM

HubSpot's pipeline is built for SaaS sales cycles, not legal intake — you'll spend weeks configuring it for conflict-check stages and referral-source tracking, and it still won't connect to QuickBooks billing or Outlook contact history without significant admin work or add-ons.

Karbon or TaxDome (for accounting practices)

Karbon and TaxDome handle workflow and client communication well for accounting firms, but neither produces a cross-partner pipeline view that ties matter status to outstanding invoices and last client contact in one automated weekly report.

Shared Google Sheet or Excel tracker

Free and familiar, but someone has to update it — and they don't, which means the Monday pipeline review is an exercise in reconstructing reality from memory rather than reviewing current data.

On Starch RECOMMENDED

One platform — crm, sales agent crm all running on connected data. Setup in plain English; numbers stay current via scheduled syncs and live agent queries.

Try it on Starch →

FAQ

Frequently asked questions

We use Clio for matter management. Can Starch connect to it?

Clio is web-based, so Starch can automate it through your browser — no API needed. That means Starch can pull matter lists, status updates, and billing data directly from your Clio account and incorporate them into your pipeline dashboard. It's not a scheduled-sync like QuickBooks, but it works reliably for the weekly review use case.

Does Starch store our client data? Is it secure enough for a law firm?

Starch stores the data it syncs (QuickBooks invoices, Outlook messages, your CRM records) in its own database. It is not currently SOC 2 Type II certified, which is an honest limitation worth knowing. If your firm has specific compliance requirements around client data storage, you should evaluate that against your obligations before connecting matter-level data.

We don't really have a 'sales pipeline' — we take referrals and do intake. Does this apply to us?

Yes — the pipeline review for a referral-based practice is just the same concept with different stage names. Instead of 'prospecting,' you have 'inquiry received.' Instead of 'demo scheduled,' you have 'conflict check cleared.' Starch lets you describe those stages in plain language and builds the CRM around how your firm actually works, not a generic B2B sales model.

Can Starch write the client status update emails for us?

Yes. Once your CRM has the matter context — last activity, outstanding items, next steps — you can ask Starch to draft a status update email for a given client. It pulls the relevant context from Outlook thread history and the matter record and produces a draft for the attorney to review and send. The attorney still approves it; Starch just removes the 20 minutes of context-gathering that currently precedes the five-minute write.

Our QuickBooks has report views disabled — will billing data still work?

Yes. QuickBooks report views (like the P&L summary view) are temporarily unavailable due to a connector issue, but Starch still syncs all entity-level data: invoices, payments, bills, and vendor records. For the pipeline review use case — outstanding invoices by client, payment status, receivables by partner — entity-level data is exactly what you need.

How long does it take to set this up?

Most firms get a working pipeline dashboard in under an hour. You connect QuickBooks and Outlook (both guided flows), describe your CRM schema in a few sentences, import your prospect list, and write the automation prompt for your weekly digest. The first real pipeline review using Starch is usually the following Monday.