Live view of money owed in and money owed out · Updated weekly by Amanda
Last updated: June 14, 2026
Snapshot — As of Today
Two independent ledgers — AR from Jobber, AP from vendor statements. Source-of-truth separated.
Owed to Us (Open AR)
$257,884
Gross from 11 open Jobber invoices
We Owe (Open AP)
$57,542
From 5 vendor statements with active balances
AR minus AP
+$200,342
Cash position once AR collects, AP pays
One-line read: Williams Landscaping is owed ~$258K from customers and owes ~$58K to vendors — comfortable net position. Two things drive the picture: Kanata Woods Inc owes $159K (62% of AR) and Ritchie Feed is owed $26K (45% of AP). Those two relationships are the whole story right now.
Separate note — Customer Deposit Liability: Jobber also shows $187,086 sitting as advance deposits from 23 customers on jobs not yet completed (e.g., Jona Marquis $46K, Cooperators $32K, Steve & Kathryn Clay $12K). This is NOT a reduction in AR — it's a liability the business holds, separate from receivables. Treated separately per proper accounting.
Most Urgent — Pay or Chase This Week
Ranked by aging × value, not alphabetical or by size alone
Pay This Week (past due — oldest first)
Vendor
Balance
Aging
Why now
Robertson Rent-All
$14,707
61-90 day items in aging
Oldest aged exposure. $5K already paid down between Jun 1-12, keep going.
Stinson Fuels
$3,176
~30 days past May 15 due
Net after the $5K paid May 5. Net 10 terms means high interest charges accruing.
Sterling Ford
$1,051
31-60 days aged
All 5 April parts invoices now aged. Small balance, easy to clear.
Waste Connections
$986
~30 days past May 15 due
"Paid online May 11" but no debit found in any WL account — confirm with Calvin or pay again.
Coming Due Within 30 Days
Vendor
Balance
Aging
Why watch
Ritchie Feed & Seed
$26,051
Currently bucket on Jun 2 stmt
Largest AP balance. Growing fast: $3K → $26K in 30 days. Will age to 31-60 by July if not paid.
S&R Flooring Concepts
$5,667
Due Jul 8
Karlson/Glebe Ave invoice. Net 30 terms.
Chase This Week (AR)
Customer
Invoice
Balance
Status
Kanata Woods Inc
#2666
$159,184
Due May 31, 14 days overdue — biggest cash lever in the business
Revel Construction
#2720
$55,330
Past due — note customer also holds $19,857 credit balance separately
Revel Construction
#2670
$75,000
Due today (Jun 14)
Caroline Risi
#2658
$944
20 days past due — small, quick to chase
Monthly View
Pick a month to see what came in and went out
AR — Invoices Issued
$22,967
8 invoices (Jobber)
AR — Payments Received
$22,203
From Apr-issued invoices paid in Apr
AP — Bills Received
$1,051
Sterling Ford parts only
AP — Payments Made
$1,071
Capital Hydraulics paid Apr 29
April: Season ramping up. Light AP activity. Capital City Hydraulics settled.
AR — Invoices Issued
$496,480
36 invoices — peak month
AR — Payments Received
$142,957
From May-issued invoices paid in May
AP — Bills Received
~$30,500
Ritchie + Robertson + Stinson + SiteOne
AP — Payments Made
~$22,400
Stinson $5K, SiteOne $14.7K, Delta $886, etc.
May: Biggest month of the year — half a million invoiced. Kanata Woods Inc #2666 ($289K) issued. Ritchie balance grew from $3K to $26K. SiteOne paid $14.7K Visa at sale. Stinson partial $5K. Delta paid May 21.
AR — Invoices Issued
$112,726
20 invoices through Jun 14
AR — Payments Received
$78,888
From Jun-issued invoices paid Jun
AP — Bills Received
~$26,000+
Ritchie more invoices + S&R + Robertson recent
AP — Payments Made
~$5,000
Robertson $5K credit applied
June so far (through Jun 14): AR pace continuing. Robertson Rent-All paid down by $5K (Jun 1→12). Ritchie balance keeps climbing — now $26K. S&R Flooring invoice received Jun 8 ($5.7K).
AR Overview
Job-by-job view of everything Apr 1 forward · Source: Jobber (sole source of truth)
Total Open AR (gross)
$257,884
11 invoices outstanding
Apr–Jun Invoiced
$632,173
64 invoices total
Apr–Jun Collected
$374,289
Cash received in period
Past Due Count
17
Invoices, $383K total open
Concentration risk: Kanata Woods Inc invoice #2666 = $159,184 (62% of all open AR). Once that one pays, AR drops to ~$98K. Whole AR story is really Kanata's collection cycle.
Customer Deposit Liability: Separate from AR — $187,086 sits as customer prepayments on 23 client accounts (jobs not yet completed). Treated as a liability, NOT netted against AR. Means: even though Jobber's net customer-balance summary shows $202K, the true AR (what's billed and unpaid) is $258K.
Jobs by Status
Every active job since April, categorized by where it sits in the revenue cycle
A · Completed & Paid in Full24 jobs · ~$152K already collected
Job #
Customer
Closed
Invoiced
Paid
17
Amanda and Ali Balcaran
Jun 8
$20,933
$20,933
58
Aimee Huckriede
Jun 9
$13,854
$13,854
24
Heather Marasse
Jun 1
$13,487
$13,487
27
Marc Ouellette
May 5
$13,063
$13,063
33
Roy Renaud
May 27
$11,424
$11,424
78
Saunya Dover
Jun 9
$11,195
$11,195
68
Anton Lebar
Jun 1
$9,311
$9,311
10
Lorraine Gareau
Jun 1
$8,407
$8,407
76
Tyler Tribble
Jun 8
$6,814
$6,814
72
Ben Clermont
Jun 8
$6,317
$6,317
67
Muna Osman
Jun 12
$6,121
$6,121
+ 13 more smaller jobs ($31K combined)
B · Completed & Still Owing11 jobs · $32,184 outstanding
Job #
Customer
Balance
2681
Condo Mgmt Group (no job # linked)
$9,009
50
Condo Mgmt Group (recurring)
$6,749
38
Condo Mgmt Group (recurring)
$3,065
52
Condo Mgmt Group (recurring)
$3,034
80
Condo Mgmt Group
$2,486
55
Long Holdings (recurring)
$1,993
47
Condo Mgmt Group (recurring)
$1,813
41
Condo Mgmt Group (recurring)
$1,718
39
Condo Mgmt Group (recurring)
$1,483
49
Sentinel Management Inc (recurring)
$1,292
63
Condo Mgmt Group
$486
C · Ongoing with Deposit Received16 jobs · $215K open balance
Job #
Customer
Invoiced
Paid
Balance
25
Kanata Woods INC
$299,426
$140,242
$159,184
14
Revel Construction
$55,330
$0
$55,330
82
Simon Fuller
$19,173
$19,173
$0.02
8
Jeff and Tammy Jerome
$36,500
$36,500
$0
11
Steve and Kathryn Clay
$23,994
$23,994
$0
5
Joe Tomassini
$12,705
$12,705
$0
62
Shan Gu
$5,700
$5,700
$0
+ 8 deposit-only ongoing jobs (Mireille Paul, Katherine Langdon, Josh Morganty, Muhamad Adatia, Lisa Gregoire, Brenda Kinsella, Robert Proulx, Laura Sewell) — visits not yet scheduled
D · Ongoing, No Deposit Yet13 jobs · $9,242 invoiced and open
Job #
Customer
Invoiced
Balance
94
Kanata Woods INC (sub-job)
$3,562
$3,562
75
Condo Mgmt Group
$3,239
$3,239
93
Kanata Woods INC (sub-job)
$1,380
$1,380
92
Kanata Woods INC (sub-job)
$1,119
$1,119
20
Caroline Risi
$944
$944
+ 8 ongoing jobs with no invoicing or deposit (Pathway Hyundai, Melinda Karlsson, Dominique Jolicoeur, Long Holdings, snow/maintenance buckets)
Pipeline — Quotes Awaiting Action
$1.06M in pending quotes · 50 quotes total · Ranked by staleness × value
Awaiting Response
43 quotes
$932K total
Approved, Not Yet a Job
7 quotes
$132K (mostly Kanata)
Stale (30+ days, no reply)
10 quotes
$445K — follow up first
Conversion Rate
43%
Apr–Jun
Stale (30+ days, no response — follow up FIRST)10 quotes · $445K · sorted oldest first
Quote
Customer
Sent
Days
Amount
Note
1032
Long Holdings
Apr 5
70
$12,261
Oldest open quote
1035
Brock Beaulne
Apr 14
61
$181,405
Largest single opportunity
1036
Brock Beaulne
Apr 14
61
$42,172
Same client — bundle the chase
1037
Shirley Vida
Apr 15
60
$40,412
1044
Shirley Vida
Apr 22
53
$13,891
Same client as 1037
1046
Alisha Nash
Apr 28
47
$18,470
1063
Jen Nodder
Apr 30
45
$16,379
Front estimate
1068
CMG
May 1
44
$2,826
Pesticide app
1069
CMG
May 1
44
$2,158
Pesticide app
1049
Arvin Jain
May 5
40
$36,217
Cooling (15-29 days)14 quotes · $317K · check in soon
Quote
Customer
Sent
Days
Amount
1059
Cathleen De Groot
May 5
40
$21,940
1060
Siobhan Pedersen
May 5
40
$21,210
1078
Muhamad Adatia
May 7
38
$39,952
1082
Dj Robertson
May 11
34
$62,927
1088
Vik Kumar
May 13
32
$16,961
1099
HB Pools
May 22
23
$73,163
1098
Yumna Skhan
May 22
23
$37,081
1102
Josh Padolsky
May 25
20
$10,532
1104
Will Chan
May 26
19
$41,276
1105
Erica Mccarthney
May 27
18
$34,380
+ 4 more in cooling range
Recent (under 14 days) + Approved-but-not-converted26 quotes — give time / convert soon
Quote
Customer
Status
Amount
Note
1113
Kanata Woods INC
Approved
$36,735
Turf install — approved 6/12, not yet scheduled as job
1116
Kanata Woods INC
Approved
$25,049
Rooftop terrace
1112
Kanata Woods INC
Approved
$24,315
Pool deck
1114
Kanata Woods INC
Approved
$21,951
Stone work revisions
1080
Kanata Woods INC
Approved
$10,656
Lift and relay — approved May 21
1115
Kanata Woods INC
Approved
$9,203
Softscaping extras
1108
Nysia Singh
Approved
$3,819
Approved 6/10
+ 19 more recent awaiting-response quotes (sent in last 14 days)
Quick conversion win: 7 Kanata Woods quotes already approved = $131K. Schedule them as jobs and they roll into the existing Kanata workflow.
AP Overview
Vendor-by-vendor from statements (sole source of truth)
Total Open AP
$57,542
5 vendors with active balances
Past Due Now
$2,953
Stinson + Sterling Ford + Waste
Coming Due 30 Days
$54,588
Ritchie + Robertson + Stinson balance
Fully Settled
3 vendors
Capital, SiteOne, Delta
Vendor Detail (sorted by urgency)
Most past-due first, then biggest active balance, then coming-due
Latest statement Jun 12, 2026. Aging buckets show items in 61-90 day range — oldest aged exposure across all vendors. Paying down — was $18.5K Jun 1, now $14.7K after $5K credit applied. Action: keep paying down on schedule.
Stinson & Son Ltd. (Fuels) $3,176.40 — ~30 days past due
Account 61936 · 4728 Bank St · 613-822-7400 · NET 10 days, 2%/month interest
Statement said $8,176 due May 15. $5K paid May 5 against earlier balance, net $3,176 still owing. NET 10 terms — penalties accruing. Action: pay this week to avoid further interest.
5 April parts invoices totaling $1,051. All now aged 31-60 per Jun 2 stmt. No payments since April. Action: clear this small balance to reset the account.
Waste Connections of Canada $985.97 — unresolved
Account 7140-098828-0000 · 1152 Kenaston St · 613-749-8000
Invoice 7140-0001152503 Apr 30, due May 15. May 11 online payment confirmation received (status SCHEDULED, conf 13144291380), but $985.97 doesn't appear as a debit in ANY WL bank or CC account. Action: ask Calvin if he paid from a personal account. If not, the May 11 transaction may have failed and the bill is still outstanding.
Ritchie Feed & Seed Inc. $26,051.13 — biggest exposure
Latest statement Jun 2, 2026. Currently in "current" bucket — but growing fast: $3.3K (May 4) → $8.5K (May 15) → $26K (Jun 2). Will age to 31-60 in July. Noemi sent past-due reminder May 27 for $14K. Action: cut a payment this month to keep it from aging.
S&R Flooring Concepts Ottawa $5,666.67 — due Jul 8
Invoice INV-00001086 dated Jun 8, due Jul 8 (Net 30). Subcontractor invoice for Karlson Glebe project. Action: enter as Bill in QBO; pay before due date.
Delta Power Equip. Paid May 21 ($885.65)
Customer WILLI264 · 479 O'Brien Road, Renfrew
Invoice R19868 paid via Visa 3319. $17.71 late fee written off. Bookkeeping note: Visa charge exists in QBO but Vendor field is blank — needs Bill Payment link.
Capital City Hydraulics Inc. Paid Apr 29 ($1,070.86)
808 Ventnor Road, Spencerville
Invoices 18821 + 18954 (snow shoot motor + hydraulic hoses). Paid Visa 3319. Settled.
SiteOne Landscape Supply Paid at time of sale ($15,392.82)