Northgate Supply Co.·KPI Vitals Sample data SEP 2025 – AUG 2026 · 1,871 ROWS Get this template →
1M3M6M12M YTD
Revenue$58,200▲ 16.9% vs Jul
Gross margin59.8%▲ 0.8 pts vs Jul
Orders182▲ 15.2% vs Jul
Outstanding$36,800$18,400 past due
Twelve months
Revenue and cost, month by month
Sep’25Oct’25Nov’25Dec’25Jan’26Feb’26Mar’26Apr’26May’26Jun’26Jul’26Aug’26
RevenueCost of salesCurrent month
Gross margin
Sep’25Oct’25Nov’25Dec’25Jan’26Feb’26Mar’26Apr’26May’26Jun’26Jul’26Aug’26
Where the money came from
Channel mix no line filter
$559.9KIN THE WINDOW
Direct / repeat$233,774Referral$123,139Marketplace$92,355Paid search$71,190Social$39,442
Lines of business no channel filter
LineRevenueMargin
Installation service
$181,82358%
Maintenance plan
$128,91271%
Parts & consumables
$112,55734%
Consulting hours
$82,73566%
Training
$53,87362%
Revenue$559,900all lines
Best month$58,200Aug’26 · 182 orders
Average order$3161,771 orders
Gross profit$328,60058.7% margin
Month by month
Every month
MonthRevenueMarginOrdersAverage
Sep’25
$38,40058.1%122$315
Oct’25
$41,20058.0%131$315
Nov’25
$46,80058.5%148$316
Dec’25
$52,10058.2%164$318
Jan’26
$35,90057.1%118$304
Feb’26
$39,60058.1%127$312
Mar’26
$44,30058.7%139$319
Apr’26
$47,80059.0%151$317
May’26
$51,20059.2%160$320
Jun’26
$54,60059.5%171$319
Jul’26
$49,80059.0%158$315
Aug’26
$58,20059.8%182$320
Month over month
Sep’25Oct’25Nov’25Dec’25Jan’26Feb’26Mar’26Apr’26May’26Jun’26Jul’26Aug’26
Who and where it comes from
Top customers no line or channel filter
CustomerRevenueOrdersSince
Harbourline Ltd
$84,60041Feb 2025
Kestrel Group
$61,30033Apr 2025
Ashford & Co
$47,90026Sep 2024
Pinewood Estates
$34,20019Jun 2025
Marlow Services
$28,70024Nov 2024
Deacon Retail
$19,40012Mar 2026
Channel mix no line filter
ChannelRevenue
Direct / repeat
$233,773
Referral
$123,140
Marketplace
$92,355
Paid search
$71,190
Social
$39,443
Customers164118 came back
Repeat share72%118 of 164
Revenue per customer$355164 customers
Lifetime value$1,840all time
Do they come back
Retention by cohort
First bought+1+2+3+4+5
Sep’256854474441
Oct’257158514643
Nov’256652454239
Dec’257361555047
Jan’2664494340·
Feb’26705750··
Mar’26695548··
Apr’267259···
May’266754···
Jun’267462···
Jul’2671····
Average at month +170%Best cohort at +2Jun’26 · 62%Weakest at +1Jan’26 · 64%
Month by month, who is still buying
-14-7-3-3
+2+3+4+5
Buying at +168%Buying at +541%Biggest drop14 pts
Who is new
New customers, month by month
313439452629333639423746
Sep’25Oct’25Nov’25Dec’25Jan’26Feb’26Mar’26Apr’26May’26Jun’26Jul’26Aug’26
First order to second all time
GapShare
Within 30 days
46%
31–60 days
28%
61–90 days
14%
Over 90 days
12%
Balances on the last date in your file — the period buttons do not move them
Outstanding$36,80047 open invoices
Past due$18,40050% of the total
Days sales outstanding24as of Aug’26
Over 90 days$2,6004 invoices
How old the money is
Ageing one date, not a period
BucketOwed
Current
$18,400
1–30 days
$9,700
31–60 days
$4,200
61–90 days
$1,900
90+ days
$2,600
Cash owed, month by month
Sep’25Oct’25Nov’25Dec’25Jan’26Feb’26Mar’26Apr’26May’26Jun’26Jul’26Aug’26
The oldest first
Oldest open invoices one date, not a period
CustomerInvoiceAmountDays open
Harbourline LtdINV-2841$4,820147chase
Deacon RetailINV-2903$3,150118chase
Marlow ServicesINV-2955$2,94096chase
Pinewood EstatesINV-3012$2,61074watch
Kestrel GroupINV-3044$2,18061watch
Ashford & CoINV-3098$1,76044watch
Rows read1,871from one sheet
Columns matched9 of 112 ignored
Date range12 monthsSep’25 to Aug’26
Cells filled94.3%412 blanks
What we read from your file
Columns we matched
Your columnRead asFilled
Invoice dateDate100%
CustomerCustomer100%
Net amountRevenue100%
CostCost of sales96%
ChannelChannel88%
LineLine of business100%
Paid onPayment date73%
Invoice no.Order id100%
Notesignored
What we could not compute
Customer acquisition costno ad spend column
Refund rateno refund flag
Stock on handnot in this file
Channel for 12% of ordersblank cells