Dashboard

Monthly goal

Set a revenue goal to track pace.
$
Won revenue
$0
vs previous period
Win rate
–
won / (won + lost)
Open pipeline
$0
weighted forecast
New leads
0
vs previous period
Avg deal size
–
per won deal
Days to close
–
avg open → won

Won revenue by month

By close date · last 12 months

Pipeline by stage

Open deals · weighted 10% / 40% / 70%
StageDealsValueWeighted

Needs attention

Rep scorecard · rolling 90 days

Not affected by the period filter
RepWon (90d)vs prior 90dProjected next 90dProspectingProposedMovementNew leadsWin rateStale
Movement = stage changes in the last 90 days (forward moves in parentheses). Projected = open deals weighted 10% / 40% / 70% by stage. Stale = open deals untouched 14+ days.

Product mix

Won revenue by product

Top clients

Won revenue in period

Recent activity

Stage changes

Lead Management

📄 Template CSV
Loading...
Business ↕ City ↕ Priority ↕ Status ↕ Source ↕ Deal Stage ↕ Value ↕ Owner ↕ Last touch ↕ Actions

Team Management

System email sender

Checking…

CRM emails (password resets and "new website lead assigned to you") go out through the Gmail of the person picked here. Only people who connected Gmail in the CRM app (Settings, Gmail) are listed.

Contact Management

Loading...
Name ↕ Email ↕ Phone ↕ Associated Businesses Notes Created By ↕ Actions

Sales Ledger

Loading...
Business ↕ Opportunity Name ↕ Value ↕ Closed Date ↕ Rep ↕

Reports

Uses the period and rep selected on the Dashboard. Revenue is dated by the day each deal was won; money in is dated by the day the invoice was paid.

Weekly won revenue & new leads

Last 12 weeks

Revenue, deal by deal

Every deal won in this period, newest first, with the day it was won and the day the invoice was paid. Click a business to open its full record.

Won onBusinessWhat soldRepAmountInvoicePaid on

Month by month

Won revenue by sale date, money in by payment date
MonthWon revenueDeals wonAvg dealMoney inLost valueNew leadsChange

Product performance

What was actually sold
ProductQtyRevenueShareLast sold

Top clients

In this period
BusinessDealsRevenueFirstLast

Stale deals

Open deals with no stage change in 14+ days
BusinessDealStageValueDays in stageRep

Data cleanup

Sales that Wave cannot back

A deal only counts as sold when Wave says the client paid its invoice. Anything else listed as sold is shown here, per rep, with the reason. Clearing removes those deals and nothing else: the business, its contacts, its notes and its open pipeline all stay, and each business keeps a note saying what went. Deals whose commission is already paid are never removed.

Won onBusinessDealRepAmountWhy it does not count

Automatically created deals

These deals are named Default Opportunity. Most are real: when deals were added to the CRM, each business got one deal carrying the stage it had at the time, so they hold your early sales history. A few may be copies an old bug recreated after someone deleted a deal on a business with no other deals. The two look the same in the data, so keep every deal you recognize and delete only ones you know are not real. Nothing here is deleted automatically, and the bug is fixed.

BusinessOwnerStageAmountCreatedDetailsActivity

Backups

A JSON copy of every table (passwords and Gmail tokens are left out). Keep it somewhere safe; Hostinger's daily MySQL backups are the main safety net.

Download backup (data only) Download backup with files

Needs review

Things the CRM will not decide on its own. Approve to apply the change, or dismiss to hide an item you have checked.

Sales & commissions

Sold
-
Collected
-
Not billed yet
-
won, no Wave invoice
Commission earned
-
Commission owed
-
confirmed, not paid (all time)

Earnings

Whatever period is picked above, these stay the same
PeriodSoldDealsCollectedCommission earnedPaid out

Commission payouts

Confirmed deliveries not paid yet
Record an ACH you already sent, even if the work behind it is not in the CRM yet.
Rep
Paid on
Amount
Reference

Payment history

Tick each one off against the transaction in Wave
PaidRepAmountHowReferenceItemsMatched in Wave

By rep

RepSoldDealsInvoicedCollectedCommission earnedOwedPaid out

What sold

ProductQtyDealsSold

By month

Sold by sale date, money in by payment date
MonthSoldDealsMoney inCommission

Money in

Invoices paid during this period, dated by the day the payment landed. "Sold" above is dated by the day the deal was won, so a deal sold in March and paid in May shows in both, in different months. Click a business to open its full record.

PaidBusinessInvoiceRepAmount

Commission detail

Items delivered in this period. Click a business to open its record
DeliveredRepBusinessItemSoldRateCommissionStatus

Reconcile

Sold vs billed vs paid vs delivered, all time

Commission rates

Locked in when an item is delivered; changes apply to later deliveries

Wave & billing

Connection

Won deals

BusinessDealWonAmountWave invoice

Customers

Businesses with won deals and their Wave customer
BusinessWonWave customerStatus

Paid invoices with no deal

Money that came in through Wave with nothing in the CRM behind it. Say which business it belongs to and who gets the credit, and the CRM writes a won deal dated by the invoice, carrying the invoice's items. Nothing is sent back to Wave. Shares can be changed afterwards with "Who gets credit" on the won deals table.

ClientInvoicePaidBusinessCredit to

History from Wave

Won deals that carry a Wave invoice but no list of what was sold. Copying the invoice lines makes past sales show up in "What sold" and in each rep's numbers. The deal amounts are not changed.

Products

Reps pick products and prices from the rate sheet (the same Google Sheet as hudpost.com/rate-sheet). Change a price there and the CRM follows within 15 minutes.

ProductRate sheetIn Wave

Feature usage

Features used
-
Not used
-
in this period
Most used
-
FeatureUsesPeopleLast usedWho
Saved