Keen On Klean
Keen On Klean
COMMERCIAL SERVICES

Dashboard

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

πŸ“Š
Active Projects
-
Loading...
πŸ’°
Pipeline Value
-
Loading...
πŸ†
-
Loading...
⚠️
Due This Week
-
Loading...

Recent Projects

View All β†’
Loading projects...

Urgent Bids

Loading...

Pipeline by Stage

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

Pipeline

Manage your projects through each stage of the sales process.

Keen On Klean
COMMERCIAL SERVICES

All Projects

Loading projects...

Loading all projects...
Keen On Klean
COMMERCIAL SERVICES

Data Cleanup

Review and fix data quality issues

⚠️
Overdue Bids
0
Needs attention
πŸ“€
Stale Proposals
0
No update 10+ days
πŸ“Β
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
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
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
COMMERCIAL SERVICES

@ My Mentions

Projects where you've been mentioned in comments

@
Total Mentions
0
All time
πŸ””
Unread
0
New mentions
πŸ’¬
This Week
0
Recent activity

Recent Mentions

Loading mentions...
Keen On Klean
COMMERCIAL SERVICES

Team Reports

Team performance overview

πŸ†•
Leads Created
0
$0 value
πŸ“Š
Leads Worked
0
active in period
πŸ†
Total Won
$0
0 projects
🎯
Win Rate
0%
across team
πŸ“ˆ
Active Pipeline
$0
0 active leads

Team Members

Leaderboard

Create New Lead

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

πŸ“‹ Project Info

πŸ‘€ Contact Info

πŸ“Β Specifications

πŸ“… Timeline & Assignment

πŸ“Β Additional Info

πŸ’° Finance Dashboard

Invoices & Collections Overview

Billing Dashboard

Dual Engine β€” Weekly T&M + Monthly Pay App

Missing Invoices

--

Active projects without invoice

Awaiting Billing

--

Within billing window

Pay App Status

--

Loading...

Blockers

--

Unmatched + NOT IN CRM

NEW DAILY REPORT ClockShark Β· QB Β· CRM Integration
Loading billing data...
Whale Projects β€” Monthly Billing + Pay App
Loading billing data...
Final Billing β€” Completed Without Invoice
Loading billing data...
Operational Costs OPS & ADMIN hours without KOK#
Loading operational data...

Collections Dashboard

Priority-based invoice collections

Current $0
0 invoices
* NEW
1-30 Days $0
0 invoices
* Pay App Window
31-60 Days $0
0 invoices
61-90 Days $0
0 invoices
* Expecting Payment
90+ Days $0
0 invoices
* Action Required
Total Outstanding
$0
0 invoices
Loading collections...
Loading collections data...
0
Invoices
$0
Total Billed
$0
Collected
$0
Open Balance
Select a period to view invoices
βœ“ Verified as Paid in QuickBooks
Loading paid invoices...
βœ… Paid Summary
$0
Total Collected
0
Invoices Paid
⚠️ Marked as paid in CRM but NOT yet verified in QuickBooks
No invoices pending QB verification
⚠️ Pending Verification

These invoices have been marked as paid in the CRM but the Finance API has not verified them as paid in QuickBooks yet.

Once verified in QB, they will automatically move to "Paid Invoices".

Team Activity
0
New Invoices
$0
0
Follow-Ups
$0
0
Total Actions
$0
Loading follow-ups...

Add New Invoice

Add Invoice - Pending QB Verification

Use this form for invoices that are already paid but need to be added to QuickBooks.

✏️ Edit Invoice
πŸ’¬ Notes
#
Note History
Quick Templates:
Schedule Follow-Up
Add Pay App
πŸ“
Drop file here or click to select
PDF, Excel, Word, Images (max 25MB)
Uploading...
Link to Invoices
Pay App
Linked Invoices
Invoice Details

πŸ“‹ Activity Log

User activity across the CRM Β· 31-day retention

πŸ” Access Management

Manage user access and permissions for CRM modules

πŸ‘₯ Team Members
Click on a user to manage their module access
🏒 IPs de Oficina
IP exacta o rango CIDR β€” los usuarios "Solo oficina" solo entran desde estas redes
Keen On Klean
COMMERCIAL SERVICES

πŸ’° Process Payroll

Upload ClockShark CSV to calculate biweekly payroll

Upload ClockShark Export

Select your CSV file or load the latest from ClockShark sync

Keen On Klean
COMMERCIAL SERVICES

πŸ“Š 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

πŸ’³ Payment Processing

Register check payments and match to invoices

πŸ“₯
0
Pending in Queue
βœ…
0
Processed Today
πŸ’°
$0.00
Total Today
⚠️
0
Need Attention
πŸ“€ Quick Upload (For Assistants)

Upload check documents for AR to process later

πŸ“·
CHECK *
πŸ“„
PAYSTUB (optional)
πŸ“Έ Register Payment (For AR)
πŸ“‹ Pending Queue
0
πŸ“­
No payments in queue
πŸ• Recent Processed
No recent activity
Keen On Klean
COMMERCIAL SERVICES

Janitorial Management

Revenue and collection data from QuickBooks

Service Revenue
--
-- accounts
Supplies Billed
--
--
Gross Margin
--
--
Pending
--
--
Overdue >30d
--
--

Client Revenue Breakdown

-- clients
Client Service Supplies Cost Profit Margin Balance Status
Loading QuickBooks data...

Aging Breakdown (Service Revenue)

CURRENT
--
1-30 DAYS
--
31-60 DAYS
--
61-90 DAYS
--
90+ DAYS
--

Revenue: QuickBooks API (real-time) | Costs: editable (click any cost cell) | Saved locally

Keen On Klean
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
COMMERCIAL SERVICES

πŸ“¦ Inventory Stock

Current inventory levels and availability

πŸ“¦
Total Products
-
Active SKUs
🏷️
Total Cases
-
In stock
⚠️
Low Stock
-
Need attention
πŸ’°
Inventory Value
-
At landed cost

Loading Paper Supplies...

Connecting to inventory system

Keen On Klean
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
COMMERCIAL SERVICES

πŸ“‹ Order History

View all inventory orders

$0
Total 2026
0
Orders
0
Clients
$0
Avg Order

Recent Orders

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

πŸ’° Inventory Financial

Cost breakdown and profit margins

πŸ”β€™ Admin Only
πŸ’΅
Total FOB Cost
-
Before duties & shipping
🚒
Total Landed Cost
-
All costs included
πŸ“ˆ
Expected Revenue
-
At suggested prices
🎯
Expected Profit
-
40% target margin

Loading financial data...

βš™οΈ Operations Dashboard

Active projects across all service lines

πŸ—οΈ
Awarded
-
Loading...
πŸ”§
In Progress
-
Loading...
βœ…
Completed
-
Loading...
⏸️
On Hold
-
Loading...

Operations Pipeline

Loading operations pipeline...

By Service Line

Loading...

πŸ“… Upcoming Start Dates

Loading...

All Operations Projects

0
Loading...

Painting Projects

Track painting contracts, SOV progress, and subcontractor payments

πŸ”„ Last sync: -
Base Contracts
$0
0 active projects
Change Orders
$0
0 approved COs
Total Contract
$0
Base + COs
Total Margin
$0
0% average
Pending from GC
$0
Outstanding
Loading painting projects...
✨ Final Cleaning
Field Operations & Daily Reports
Loading Final Cleaning projects...

Labor Hours

ClockShark Time Tracking

Upload Calendar

Uploaded Missing Sunday

Upload History

All Projects
0
Total Hours
0
Active Projects
0
Employees
0
Overtime Hours

Projects Summary

Keen On Klean
COMMERCIAL SERVICES

πŸ“‡ Contacts Directory

Manage contacts for GC/Clients β€” PMs, Estimators, Superintendents & more

πŸ“‡

Loading contacts...