Active work
29
29 total, 1 past due
Overdue
1
past their target date
Owed to you
$1,154,604
$0 over 60 days
Spend
$1,265,587
1,544 transactions
What it gives you every morning
Worked out from your own numbers, not typed in.
Total contract amount
$24,853,400
218 rows in jobs
Total estimated value
$74,115,000
706 rows in leads
Total amount · purchase orders
$6,577,025
442 rows in purchase_orders
Total amount · invoices ar
$22,332,972
570 rows in invoices_ar
Where the work is
A summary to orient you — the Jobs tab has the full map, the list, and a page for every job.
| Job | Where | State | Value |
|---|---|---|---|
| Tenant upfit, 2nd floor | Clayton | In production | $336,300 |
| Whole-house remodel | Micro | In production | $93,500 |
| Home addition | Wendell | In production | $56,200 |
| Smoke damage, whole house | Archer Lodge | In production | $57,900 |
| Outdoor kitchen + patio | Archer Lodge | In production | $199,900 |
| Fire, garage + attic | Princeton | In production | $110,200 |
| Whole-house remodel | Clayton | In production | $85,000 |
| Warehouse slab + dock | Angier | In production | $204,200 |
| Fire rebuild, partial interior | Dunn | In production | $83,500 |
| Hail / siding + roof | Dunn | In production | $159,700 |
| Warehouse slab + dock | Archer Lodge | In production | $172,900 |
| Fire rebuild, partial interior | Pine Level | In production | $23,100 |
| Home addition | Wilson's Mills | In production | $28,800 |
| Master suite addition | Princeton | In production | $88,800 |
| Whole-house remodel | Benson | In production | $95,400 |
| Retail buildout | Pine level | In production | $142,000 |
| Fire rebuild, partial interior | Smithfield | In production | $172,400 |
| Storm / tree impact | Pine Level | In production | $49,500 |
| Tenant upfit, 2nd floor | Wendell | Signed, mobilising | $237,600 |
| Basement finish | Kenly | In production | $164,700 |
| Pipe burst, finished basement | Kenly | In production | $66,200 |
| Storm / tree impact | Kenly | In production | $51,100 |
| Fire rebuild, partial interior | Zebulon | In production | $103,500 |
| Smoke damage, whole house | Micro | In production | $100,300 |
| Deck, patio + retaining wall | Wilson's Mills | In production · overdue | $19,300 |
| Storm / tree impact | Pine Level | In production | $123,400 |
| Fire rebuild, partial interior | Zebulon | In production | $129,900 |
| Tenant upfit, 2nd floor | Clayton | Signed, mobilising | $184,200 |
| Deck, patio + retaining wall | Archer Lodge | Signed, mobilising | $8,500 |
What stands out
Ranked by what would change a decision, not by size.
Millwork averages 3.1x the rest on line total
In po_lines, rows where category = 'Millwork' (125 rows) average 9,258 against 2,949 for the other 9 groups.
| Category | mean line_total |
|---|---|
| Millwork | 9,258 |
| Paint & Sundries | 5,767 |
| Roofing | 5,585 |
| Electrical | 4,749 |
| Concrete & Masonry | 4,486 |
| Flooring | 3,204 |
| Plumbing | 2,527 |
| Lumber | 1,499 |
| Drywall | 1,000 |
| Tools & Safety | 897.05 |
Selma averages 3.0x the rest on unpaid amount
In invoices_ar, rows where branch = 'Selma' (182 rows) average 5,071 against 1,676 for the other 3 groups.
| Category | mean unpaid_amount |
|---|---|
| Selma | 5,071 |
| Smithfield | 2,267 |
| Clayton | 1,827 |
| Four Oaks | 1,179 |
Restaurant kitchen remodel averages 3.7x the rest on unpaid amount
In invoices_ar, rows where job_name = 'Restaurant kitchen remodel' (20 rows) average 8,893 against 2,391 for the other 19 groups.
| Category | mean unpaid_amount |
|---|---|
| Restaurant kitchen remodel | 8,893 |
| Warehouse slab + dock | 8,840 |
| Retail buildout | 7,836 |
| Water loss, main level | 5,193 |
| Hail / siding + roof | 4,719 |
| Fire, garage + attic | 4,101 |
| Bathroom remodel, 2 baths | 3,175 |
| Tenant upfit, 2nd floor | 2,933 |
| Water loss, kitchen + bath | 2,819 |
| Smoke damage, whole house | 2,804 |
Ridgeview Mutual is 27% of unpaid amount
Of $1,573,292 total unpaid amount in invoices_ar, $426,824 (27.1%) sits with a single payer name: Ridgeview Mutual. The top three are 50% combined, across 28 in total.
| Category | unpaid_amount |
|---|---|
| Ridgeview Mutual | 427K |
| Ferrand Optical | 230K |
| Marbury Retail Partners | 135K |
| Blue Ridge Casualty | 89K |
| Neuse Valley Insurance | 79K |
| Nora Thigpen | 78K |
| Tarheel Indemnity | 61K |
| Halcyon Property Group | 56K |
| Sandhills Property & Casualty | 53K |
| Cardinal Peak Mutual | 52K |
Worth knowing. Unsettled balances lag: recent rows may simply not have settled yet. Compare like-aged rows before acting.
Average amount for Water loss, main level rose 131%
Splitting job_costs at 2025-08-13, mean amount rose from 1,130 (265 rows) to 2,613 (168 rows) for Water loss, main level.
| Category | amount |
|---|---|
| to 2025-08-13 | 1,130 |
| after 2025-08-13 | 2,613 |
Total Cost by month, split by county
crew_hours, top 5 of 5
JohnstonWakeHarnettOther (2)
| Category | Johnston | Wake | Harnett | Other (2) |
|---|---|---|---|---|
| 2024-08 | 1,066 | 1,044 | 0 | 999.50 |
| 2024-09 | 27K | 8,416 | 6,266 | 7,616 |
| 2024-10 | 72K | 6,366 | 12K | 13K |
| 2024-11 | 95K | 7,654 | 16K | 9,456 |
| 2024-12 | 115K | 19K | 18K | 13K |
| 2025-01 | 118K | 20K | 12K | 15K |
| 2025-02 | 120K | 23K | 16K | 13K |
| 2025-03 | 115K | 27K | 17K | 14K |
| 2025-04 | 139K | 15K | 8,978 | 21K |
| 2025-05 | 126K | 12K | 10K | 31K |
| 2025-06 | 108K | 3,186 | 13K | 26K |
| 2025-07 | 127K | 10K | 15K | 23K |
| 2025-08 | 103K | 14K | 11K | 18K |
| 2025-09 | 105K | 17K | 12K | 13K |
| 2025-10 | 126K | 18K | 13K | 16K |
| 2025-11 | 139K | 21K | 7,751 | 15K |
| 2025-12 | 163K | 34K | 9,591 | 24K |
| 2026-01 | 152K | 22K | 9,810 | 19K |
| 2026-02 | 140K | 24K | 10K | 18K |
| 2026-03 | 147K | 19K | 9,757 | 22K |
| 2026-04 | 138K | 9,423 | 7,922 | 17K |
| 2026-05 | 119K | 1,642 | 7,320 | 18K |
| 2026-06 | 121K | 1,684 | 12K | 15K |
| 2026-07 | 158K | 8,064 | 20K | 8,605 |
Estimated Value by month, split by county
leads, top 5 of 5
JohnstonHarnettWakeOther (2)
| Category | Johnston | Harnett | Wake | Other (2) |
|---|---|---|---|---|
| 2024-08 | 1.5M | 316K | 470K | 74K |
| 2024-09 | 2.7M | 812K | 624K | 357K |
| 2024-10 | 2.2M | 238K | 0 | 92K |
| 2024-11 | 1.5M | 434K | 528K | 420K |
| 2024-12 | 1.6M | 193K | 191K | 0 |
| 2025-01 | 2.1M | 636K | 55K | 271K |
| 2025-02 | 3.3M | 366K | 31K | 489K |
| 2025-03 | 2.0M | 232K | 74K | 111K |
| 2025-04 | 1.8M | 409K | 637K | 531K |
| 2025-05 | 2.6M | 89K | 0 | 225K |
| 2025-06 | 2.2M | 418K | 381K | 179K |
| 2025-07 | 2.0M | 279K | 99K | 890K |
| 2025-08 | 2.3M | 670K | 417K | 179K |
| 2025-09 | 3.5M | 708K | 644K | 351K |
| 2025-10 | 2.2M | 0 | 339K | 175K |
| 2025-11 | 2.1M | 152K | 340K | 243K |
| 2025-12 | 1.5M | 79K | 54K | 0 |
| 2026-01 | 1.8M | 332K | 181K | 37K |
| 2026-02 | 1.2M | 119K | 231K | 482K |
| 2026-03 | 3.5M | 331K | 524K | 1.1M |
| 2026-04 | 2.3M | 0 | 349K | 414K |
| 2026-05 | 1.9M | 567K | 158K | 153K |
| 2026-06 | 2.1M | 310K | 365K | 169K |
| 2026-07 | 1.6M | 594K | 342K | 252K |
Amount by month, split by payer type
invoices_ar, top 3 of 3
HomeownerCarrierCommercial client
| Category | Homeowner | Carrier | Commercial client |
|---|---|---|---|
| 2024-09 | 46K | 48K | 0 |
| 2024-10 | 93K | 158K | 0 |
| 2024-11 | 370K | 213K | 174K |
| 2024-12 | 256K | 345K | 142K |
| 2025-01 | 653K | 308K | 54K |
| 2025-02 | 487K | 224K | 233K |
| 2025-03 | 379K | 307K | 108K |
| 2025-04 | 417K | 252K | 278K |
| 2025-05 | 768K | 426K | 93K |
| 2025-06 | 493K | 452K | 226K |
| 2025-07 | 329K | 313K | 175K |
| 2025-08 | 500K | 441K | 370K |
| 2025-09 | 178K | 386K | 317K |
| 2025-10 | 525K | 197K | 162K |
| 2025-11 | 464K | 360K | 320K |
| 2025-12 | 549K | 279K | 289K |
| 2026-01 | 571K | 281K | 243K |
| 2026-02 | 311K | 415K | 355K |
| 2026-03 | 568K | 163K | 559K |
| 2026-04 | 457K | 290K | 389K |
| 2026-05 | 410K | 390K | 562K |
| 2026-06 | 438K | 339K | 210K |
| 2026-07 | 341K | 392K | 489K |
Amount by month, split by vendor
purchase_orders, top 6 of 6
Tri-County HardwareCarolina Tile DepotCoastal Lumber & MillworkOther (3)
| Category | Tri-County Hardware | Carolina Tile Depot | Coastal Lumber & Millwork | Other (3) |
|---|---|---|---|---|
| 2024-09 | 6,321 | 5,764 | 0 | 39K |
| 2024-10 | 57K | 25K | 39K | 80K |
| 2024-11 | 125K | 111K | 59K | 60K |
| 2024-12 | 85K | 50K | 37K | 157K |
| 2025-01 | 41K | 41K | 74K | 120K |
| 2025-02 | 48K | 47K | 51K | 76K |
| 2025-03 | 59K | 95K | 56K | 180K |
| 2025-04 | 80K | 105K | 47K | 88K |
| 2025-05 | 65K | 0 | 47K | 105K |
| 2025-06 | 27K | 40K | 67K | 226K |
| 2025-07 | 37K | 39K | 112K | 82K |
| 2025-08 | 0 | 32K | 7,381 | 183K |
| 2025-09 | 55K | 82K | 36K | 86K |
| 2025-10 | 167K | 62K | 44K | 59K |
| 2025-11 | 72K | 85K | 56K | 100K |
| 2025-12 | 27K | 78K | 79K | 209K |
| 2026-01 | 32K | 50K | 35K | 199K |
| 2026-02 | 47K | 21K | 77K | 121K |
| 2026-03 | 72K | 123K | 1,986 | 242K |
| 2026-04 | 59K | 29K | 3,434 | 178K |
| 2026-05 | 24K | 981.91 | 40K | 79K |
| 2026-06 | 30K | 41K | 9,089 | 139K |
| 2026-07 | 50K | 7,953 | 135K | 217K |
Amount by month, split by status
change_orders, top 3 of 3
ApprovedVerbalRejected
| Category | Approved | Verbal | Rejected |
|---|---|---|---|
| 2024-09 | 50K | 6,976 | 4,737 |
| 2024-10 | 25K | 25K | 5,926 |
| 2024-11 | 30K | 17K | 0 |
| 2024-12 | 25K | 31K | 0 |
| 2025-01 | 36K | 20K | 0 |
| 2025-02 | 40K | 29K | 0 |
| 2025-03 | 4,989 | 0 | 0 |
| 2025-04 | 23K | 16K | 0 |
| 2025-05 | 44K | 23K | 0 |
| 2025-06 | 37K | 3,876 | 0 |
| 2025-07 | 36K | 4,169 | 0 |
| 2025-08 | 43K | 5,739 | 0 |
| 2025-09 | 23K | 17K | 8,238 |
| 2025-10 | 58K | 23K | 0 |
| 2025-11 | 31K | 896.46 | 15K |
| 2025-12 | 12K | 23K | 0 |
| 2026-01 | 27K | 16K | 0 |
| 2026-02 | 30K | 12K | 0 |
| 2026-03 | 46K | 33K | 8,184 |
| 2026-04 | 75K | 7,150 | 0 |
| 2026-05 | 76K | 33K | 0 |
| 2026-06 | 26K | 0 | 0 |
| 2026-07 | 27K | 20K | 0 |
Worth knowing. status: 44 of 221 rows (19.9%) are blank with no pattern explaining which ones.
Contract Amount by month, split by county
jobs, top 5 of 5
JohnstonWakeHarnettOther (2)
| Category | Johnston | Wake | Harnett | Other (2) |
|---|---|---|---|---|
| 2024-08 | 47K | 342K | 0 | 37K |
| 2024-09 | 1.5M | 0 | 194K | 200K |
| 2024-10 | 812K | 0 | 160K | 249K |
| 2024-11 | 1.1M | 111K | 0 | 0 |
| 2024-12 | 554K | 291K | 303K | 107K |
| 2025-01 | 288K | 0 | 63K | 0 |
| 2025-02 | 834K | 0 | 0 | 0 |
| 2025-03 | 505K | 0 | 181K | 123K |
| 2025-04 | 788K | 0 | 0 | 280K |
| 2025-05 | 510K | 0 | 0 | 248K |
| 2025-06 | 680K | 40K | 31K | 0 |
| 2025-07 | 792K | 382K | 0 | 239K |
| 2025-08 | 390K | 0 | 212K | 0 |
| 2025-09 | 1.3M | 148K | 230K | 0 |
| 2025-10 | 1.4M | 166K | 0 | 130K |
| 2025-11 | 630K | 318K | 0 | 223K |
| 2025-12 | 727K | 0 | 0 | 0 |
| 2026-01 | 770K | 27K | 0 | 0 |
| 2026-02 | 452K | 18K | 0 | 220K |
| 2026-03 | 642K | 0 | 64K | 222K |
| 2026-04 | 761K | 0 | 89K | 0 |
| 2026-05 | 880K | 0 | 0 | 0 |
| 2026-06 | 649K | 56K | 447K | 0 |
| 2026-07 | 1.3M | 471K | 0 | 0 |
Unit Cost by month, split by branch
inventory, top 4 of 4
Four OaksSmithfieldClaytonOther (1)
| Category | Four Oaks | Smithfield | Clayton | Other (1) |
|---|---|---|---|---|
| 2025-07 | 27.10 | 0 | 0 | 12.30 |
| 2025-08 | 0 | 13.90 | 0 | 366 |
| 2025-09 | 28.95 | 9.85 | 0 | 0 |
| 2025-10 | 0 | 0 | 0 | 110.40 |
| 2025-11 | 185.60 | 0 | 0 | 0 |
| 2025-12 | 0 | 60.45 | 0 | 138 |
| 2026-04 | 23 | 0 | 0 | 13.20 |
| 2026-05 | 1,046 | 70.53 | 584.25 | 186.40 |
| 2026-06 | 415.33 | 1,132 | 498.65 | 142.45 |
| 2026-07 | 134.35 | 482.05 | 604 | 404.43 |
What was read
Every figure above traces back to these tables.
Read:acme_corporation_export_branch_stock_summary · 45 rowsacme_corporation_export_vendor_scorecard · 6 rowschange_orders · 221 rowscrew_hours · 13,727 rowsestimate_lines · 4,256 rowsinventory · 118 rowsinvoices_ar · 570 rowsjob_activity · 1,912 rowsjob_costs · 8,383 rowsjobs · 218 rowsleads · 706 rowspo_lines · 1,963 rowspurchase_orders · 442 rowssubcontractors · 14 rowsvendor_price_list · 416 rows
14 relationships found between these tables. 22 data-quality issues noted, attached to the tiles they affect. The full data picture →