Keen On Klean Solutions
COMMERCIAL SERVICES

Dashboard

Welcome back! Here's what's happening with your projects.

📊
Active Projects
-
Loading...
🏆
Won This Month
-
Loading...
⚠️
Due This Week
-
Loading...

Recent Projects

View All →
Loading projects...

Urgent Bids

Loading...

Pipeline by Stage

Loading...
Last updated: --
Keen On Klean Solutions
COMMERCIAL SERVICES

Pipeline

Manage your projects through each stage of the sales process.

Keen On Klean Solutions
COMMERCIAL SERVICES

All Projects

Loading projects...

Loading all projects...
Keen On Klean Solutions
COMMERCIAL SERVICES

Data Cleanup

Review and fix data quality issues

⚠️
Overdue Bids
0
Needs attention
📍
Missing Data
0
Incomplete records
🔍
Potential Duplicates
0
Review needed
💰
In Progress - Missing Value
0
No estimated value

Issues to Review

Showing all issues
Loading data cleanup issues...
Keen On Klean Solutions
COMMERCIAL SERVICES

👤 My Leads Dashboard

Your sales performance

Won Value 💰

$0

0 projects won

In Progress 📈

$0

0 active leads

Win Rate 🎯

0%

0 of 0 closed

Not Won

$0

0 projects lost

🏆 Top 5 Projects Won

This Month
Loading...

📋 My Pending Projects

Loading your leads...
Keen On Klean Solutions
COMMERCIAL SERVICES

📍 Assigned to Me

Projects assigned to you for action

📋
Assigned to Me
0
Total tasks
Due Soon
0
Next 7 days
Overdue
0
Needs attention

Assigned Projects

Loading assigned projects...
Keen On Klean Solutions
COMMERCIAL SERVICES

@ My Mentions

Projects where you've been mentioned in comments

@
Total Mentions
0
All time
🔔
Unread
0
New mentions

Recent Mentions

Loading mentions...

Create New Lead

Add a new project to your pipeline. Required fields are marked with *

📋 Project Info

👤 Contact Info

📍 Specifications

📅 Timeline & Assignment

📍 Additional Info

Keen On Klean Solutions
COMMERCIAL SERVICES

💰 Finance Dashboard

Invoices & Collections Overview

Open Invoices

Track and collect outstanding invoices

$0
Total Outstanding
0
Open Invoices
0
Over 60 Days
0
GCs with Balance
Loading invoices...
Aging Summary
0-30 days$0
31-60 days$0
61-90 days$0
90+ days$0
Keen On Klean Solutions
PAYROLL CALCULATOR

💰 Payroll Calculator

Upload ClockShark CSV to calculate weekly payroll

Upload ClockShark Export

Select your CSV file to calculate payroll automatically

Keen On Klean Solutions
LABOR & FINANCIAL ANALYSIS 2025

📊 Labor & Financial Analysis

Complete report from QuickBooks, Payroll & ClockShark - 2025

📊 Total Labor Cost
$2.29M
QuickBooks
💵 Direct Payroll
$1.29M
Payroll Excel
⏱️ Hours Tracked
85,528
ClockShark
🔧 Subcontractors
$1.28M
Top 10 Subs

🧹 Janitorial

$1,036,743
45.2% of total labor

🎨 Painting

$696,592
30.4% of total labor

🏗️ Construction

$516,412
22.5% of total labor

👥 Workforce Distribution

Direct Employees $1,534,656 (67%)
Subcontractors $757,201 (33%)
Total $2,291,857

📅 Monthly Labor Cost (2025)

Jan
$156K
Feb
$191K
Mar
$146K
Apr
$114K
May
$140K
Jun
$164K
Jul
$162K
Aug
$260K
Sep
$234K
Oct
$260K
Nov
$279K
Dec
$185K
Monthly Average: $190,988

🔧 Top 10 Subcontractors

Rank Subcontractor Type Total Paid % of Subs
1CADENA CARDONA CLEANING SERVICES, LLC🧹 Janitorial$549,13844.6%
2OSMAN (Ospina / Antunez / Sevilla)🎨 Painting$507,95439.6%
3Meta-Drywall Services LLC🏗️ Construction$45,0823.7%
4Patricio Corona$42,5473.5%
5LAMB JK LLC$36,7633.0%
6Zavala Cleaning Services🧹 Janitorial$28,4792.3%
7Nolbert Insulation LLC🏗️ Construction$24,0001.9%
8Total Value Service LLC$17,2181.4%
9Criscamar Services LLC🧹 Janitorial$15,1031.2%
10Procleaning🧹 Janitorial$15,0191.2%
TOTAL TOP 10 $1,281,303 100%

📌 Key Insights

• QuickBooks shows $2.29M total labor cost for 2025

• Payroll records $1.29M paid directly to employees (26 pay periods)

• Difference of $1M includes subcontractors, international payments, and other labor costs

• ClockShark tracked 85,528 hours across 673 projects and 137 clients

• Average effective labor rate: $26.80/hr (QuickBooks total ÷ ClockShark hours)

• Top client by hours: Auld & White with 7,821 hours ($130K labor cost)

🌎 International (Colombia)

XOOM Transfers (2025) $53,375
Danam Enterprise (Wire) $11,325
Total International 2025 $64,700

Source: Expenses report (50 XOOM transactions in 2025)

🏢 Overhead Analysis 2025

💰 Total Revenue
$5.47M
Services + Construction
📦 COGS (Direct)
$2.67M
Labor + Materials
🏢 Overhead
$1.62M
29.5% of Revenue
💵 Net Income
$1.19M
21.7% Net Margin

📊 Top Overhead Expenses

1. Payroll (Admin/Salaries) $836,304 (51.8%)
2. Commercial (1099 Contractors) $226,046 (14.0%)
3. Insurance (All) $198,618 (12.3%)
4. Equipment Rental $80,228 (5.0%)
5. Office & Software $69,395 (4.3%)

📈 Key Metrics

29.5%
Overhead Rate
(Overhead / Revenue)
51.2%
Gross Margin
(Gross Profit / Revenue)
$18.89
Overhead/Hour
(÷ 85,528 hours)
21.7%
Net Margin
(Net Income / Revenue)

📋 Complete P&L Breakdown

Category Amount % Revenue
💰 REVENUE$5,471,025100%
Services$4,450,43781.3%
Construction Income$941,19917.2%
Other$79,3891.5%
📦 COGS (Direct Costs)($2,668,352)48.8%
Cost of Labor$2,291,85741.9%
Materials & Supplies$376,4956.9%
💵 GROSS PROFIT$2,802,67351.2%
🏢 OVERHEAD($1,615,780)29.5%
Admin Payroll & Salaries$836,30415.3%
1099 Contractors (Commercial)$226,0464.1%
Insurance (All)$198,6183.6%
Equipment Rental$80,2281.5%
Office & Software$69,3951.3%
Gas & Fuel$31,8150.6%
Rent/Lease$32,8840.6%
Other Overhead$140,4902.6%
💰 NET INCOME$1,186,89321.7%

📊 Project Profitability Analysis

🎨 RISE/DORO - Painting Project (Mayo-Dic 2025)

P&L Summary

💰 Revenue (Invoices) $1,078,530 100%
🎨 OSMAN (Painting Labor) $507,954 47.1%
🪣 Sherwin Williams (Paint) $225,284 20.9%
🧱 Nolbert Insulation $24,000 2.2%
👥 Labor KOK (Supervision) $53,561 5.0%
📦 Total Costs $810,799 75.2%
💵 Gross Profit $267,731 24.8%
- 20% Overhead $215,706 20.0%
💰 Net Profit $52,025 4.8%

Cost Distribution

OSMAN 62.6%
Sherwin 27.8%
KOK 6.6%
Nolbert 3%

Sherwin Williams Monthly

Jun
$15,842
Jul
$66,925
Aug
$33,572
Sep
$26,674
Oct
$27,389
Nov
$34,080
Dec
$20,804
Total
$225,284
Project Status
✅ Profitable (24.8% Gross Margin)
Subcontractor: OSMAN (Ospina/Antunez/Sevilla) • Started: May 2025

🧹 Janitorial Accounts Analysis (December 2025)

🏢 KOK's Janitorial Accounts

$55,826
Invoice Total
48.4%
Gross Margin

Top Performers (Margin >50%)

Eye Clay Orange Park 63.5%
Beachside High School 60.9%
Strategic Sites 56.5%
St. Joseph School 55.9%
Eye Clay Fleming Island 55.1%

⚠️ Low Margin Accounts (<25%)

Crookshank Transportation 8.9% ❌
NF Special Ed Regency 16.3% ❌
Peter Sleiman 23.0% ❌

🔧 Cadena's Janitorial Accounts

$70,961
Invoice Total
~35%
Est. Margin

Top Accounts by Revenue

Beaver Toyota St Aug $10,234
Coggin Chevrolet $7,173
Beaver Toyota DIA $5,852
Compass Surgical $5,214
Power Home Remodeling $4,500
St Pauls Catholic School $4,217
Del Webb Wildlight $4,014
Subcontractor: Cadena Cardona
100% of work done by Cadena. KOK manages billing & client relationship.

📊 Janitorial December 2025 Summary

$126,787
Total Revenue
KOK + Cadena
~$75K
Est. Total Costs
Contractors + Supplies
~$52K
Est. Gross Profit
Before overhead
~41%
Avg. Margin
Healthy ✅

👷 Janitorial Subcontractors

Contractor Contact Accounts Est. Monthly
Cadena Cardona Primary Janitorial Sub Beaver Toyota, Coggin, Del Webb, Compass ~$46,000
LAMB JK LLC Juan Cordero (904) 303-1136 Historic Church, Cody Center, St Joseph ~$1,900
Pro Cleaning JAX Darlen Ocampo (904) 572-5513 North FL Special Education (all locations) ~$4,650
Miriam Patricio (904) 930-8526 Eye Clay (Fleming, Orange Park) ~$3,500
MA Luxury Cleaning Karlen Medina (904) 649-3796 Eye Clay San Jose ~$1,200
Wilder Restrepo (904) 728-8841 Strategic Sites, Intracoastal ~$1,360
Maria Vazquez (904) 805-5032 Weaver Realty ~$200
Daisy Maldonado (904) 554-9528 GEM Products ~$1,000
Juan F. Castillo (904) 316-3189 Peter Sleiman Development ~$2,645

🎯 Business Model Summary

🎨

Painting & Construction

How it works:

  • KOK employees OR subcontractors do work
  • Hours tracked in ClockShark
  • Materials purchased (Sherwin Williams, etc.)

Main Subs:

  • OSMAN - Painting ($508K/yr)
  • Meta-Drywall - Drywall ($45K/yr)
  • Nolbert - Insulation ($24K/yr)
25-35%
Typical Margin
🏢

Janitorial (KOK Managed)

How it works:

  • KOK invoices client directly
  • Various small contractors do work
  • KOK manages relationship & supplies

Accounts:

  • Eye Clay locations
  • Schools (St Johns, NF Special Ed)
  • Churches, Cody Center
45-55%
Typical Margin
🔧

Janitorial (Cadena)

How it works:

  • KOK invoices client
  • Cadena Cardona does 100% of work
  • No ClockShark hours

Accounts:

  • Beaver Toyota (all locations)
  • Coggin Chevrolet
  • Del Webb communities
  • Compass Surgical
30-40%
Typical Margin

💡 Key Insights & Recommendations

✅ Strengths

  • Janitorial has excellent margins (41-48%)
  • Diversified contractor network reduces risk
  • Strong relationships with GCs (Rise, Auld & White, etc.)
  • Good tracking with ClockShark for direct work
  • Net income of $1.19M (21.7% margin)

⚠️ Watch Items

  • Overhead is 29.5% (not 20% as used in quotes)
  • 82% of sub spend in 2 contractors (Cadena + OSMAN)
  • Some janitorial accounts under 25% margin
  • 44.8% of ClockShark hours are internal/non-billable
  • Review pricing on Crookshank, Peter Sleiman

Data Sources: QuickBooks P&L Detail • Expenses Report • Payroll Excel • ClockShark • Bank of America • Sherwin Williams • Janitorial Invoices

Report Period: January - December 2025 • Generated from KOK Financial Analysis

Keen On Klean Solutions
JANITORIAL ANALYSIS

🧹 Janitorial Accounts Analysis

Monthly profitability and aging analysis for all janitorial accounts

Total Invoiced
$117,200
41 accounts
Total Collected
$66,726
56.9%
Gross Profit
$50,474
43.1% margin
Pending
$50,474
43.1%
Overdue >30d
$0
0%

🏢 KOK Managed Accounts

20 accounts
Client Invoice Cost Profit Margin
St. Joseph Catholic School$12,029$5,300$6,72955.9%
Beachside High School$6,600$2,578$4,02260.9%
Eye Clay - Fleming Island$5,562$2,500$3,06255.1%
NF Special Ed - Lower$4,915$2,645$2,27046.2%
Peter Sleiman Development$3,539$2,725$81423.0%
Strategic Sites$2,780$1,210$1,57056.5%
Eye Clay - Orange Park$2,738$1,000$1,73863.5%
Eye Clay - San Jose$2,075$1,200$87542.2%
GEM Products$2,074$1,000$1,07451.8%
NF Special Ed - Upper$1,950$1,170$78040.0%
TOTAL KOK $55,826 $28,820 $27,006 48.4%

🔧 Cadena's Accounts

24 accounts
Client Invoice Est. Cost Est. Profit Margin
Beaver Toyota St Augustine$10,234$6,652$3,58235.0%
Coggin Chevrolet Avenues$7,173$4,662$2,51135.0%
Beaver Toyota DIA$5,852$3,804$2,04835.0%
Compass Surgical Partners$5,214$3,389$1,82535.0%
Power Home Remodeling$4,500$2,925$1,57535.0%
St Pauls Catholic School$4,217$2,741$1,47635.0%
Del Webb Wildlight$4,014$2,609$1,40535.0%
NineOaks Development$2,894$1,881$1,01335.0%
Del Webb eTown$2,759$1,793$96635.0%
Advanced Urology (AUI)$2,649$1,722$92735.0%
TOTAL CADENA $70,961 $46,125 $24,836 35.0%

👷 Contractor Performance Analysis

Contractor Contact Accounts Invoice Total Cost Profit Margin Rating
Miriam Patricio (904) 930-8526 2 $8,300 $3,500 $4,800 57.8% ⭐⭐⭐
Wilder Restrepo (904) 728-8841 2 $3,070 $1,360 $1,710 55.7% ⭐⭐⭐
LAMB JK (Juan Cordero) (904) 303-1136 4 $15,739 $7,252 $8,487 53.9% ⭐⭐⭐
Daisy Maldonado (904) 554-9528 1 $2,074 $1,000 $1,074 51.8% ⭐⭐⭐
KOK Crew Internal 4 $12,525 $6,750 $5,775 46.1% ⭐⭐
MA Luxury (Karlen Medina) (904) 649-3796 1 $2,075 $1,200 $875 42.2% ⭐⭐
Pro Cleaning JAX (904) 572-5513 4 $8,227 $4,830 $3,397 41.3% ⭐⭐
Cadena Cardona Primary Janitorial Sub 24 $70,964 $46,124 $24,840 35.0% ⭐⭐
Juan F. Castillo (904) 316-3189 1 $3,539 $2,725 $814 23.0% ⚠️
Maria Vazquez (904) 805-5032 1 $277 $200 $77 27.8% ⚠️

💰 Price Increase Recommendations

Action Required
Account Current Price Cost Current Margin Target Price (35%) Increase Action
St Johns - Crookshank (2nd) $875 $797 8.9% $1,226 +$351 🚨 URGENT
NF Special Ed - Regency $890 $745 16.3% $1,146 +$256 🚨 URGENT
St Johns - Beachside HS (2nd) $3,300 $2,578 21.9% $3,966 +$666 ⚠️ Review
Peter Sleiman Development $3,539 $2,725 23.0% $4,192 +$653 ⚠️ Review
Historic Church $455 $334 26.5% $514 +$59 📋 Monitor
Weaver Realty $277 $200 27.8% $308 +$31 📋 Monitor
TOTAL POTENTIAL MONTHLY INCREASE +$2,016 = $24,192/yr

Data Source: Janitorial_Invoices.xlsx • QuickBooks Invoice List

Report Period: December 2025 • Last Updated: January 27, 2026

Keen On Klean Solutions
CADENA CARDONA - JANITORIAL SUPPLIES

Cadena Cardona - Client Billing

Manage janitorial supply orders for recurring clients

Clients

Select a client to create an order

Keen On Klean Solutions
COMMERCIAL SERVICES

📦 Inventory Stock

Current inventory levels and availability

📦
Total Products
-
Active SKUs
⚠️
Low Stock
-
Need attention
💰
Inventory Value
-
At landed cost

Loading Paper Supplies...

Connecting to inventory system

Keen On Klean Solutions
COMMERCIAL SERVICES

🛒 New Order

Request supplies for a client or project

Order Information

Fill in the details for this order

Select Products

Choose items and quantities

Loading products...

Keen On Klean Solutions
COMMERCIAL SERVICES

📋 Order History

View all inventory orders

Recent Orders

Order ID Date Requested By Client/Project Item Qty Status
Loading orders...
Keen On Klean Solutions
COMMERCIAL SERVICES

💰 Inventory Financial

Cost breakdown and profit margins

🔍’ Admin Only
💵
Total FOB Cost
-
Before duties & shipping
📈
Expected Revenue
-
At suggested prices
🎯
Expected Profit
-
40% target margin

Loading financial data...