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

Team Reports

Team performance overview

๐Ÿ†•
Leads Created
0
$0 value
๐Ÿ“Š
Leads Worked
0
active in period
๐Ÿ†
Total Won
$0
0 projects
๐Ÿ“ˆ
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

Keen On Klean Solutions
COMMERCIAL SERVICES

๐Ÿ’ฐ 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
๐Ÿ’ฐ
Last Week
Loading...
๐Ÿ“Š
This Month
Loading...
๐Ÿ“…
This Year
Loading...
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...
Pay App
Linked Invoices
Invoice Details

๐Ÿ” Access Management

Manage user access and permissions for CRM modules

๐Ÿ‘ฅ Team Members
Click on a user to manage their module access
Keen On Klean Solutions
PAYROLL CALCULATOR

๐Ÿ’ฐ Process Payroll

Upload ClockShark CSV to calculate biweekly 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

๐Ÿ’ณ 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 Solutions
JANITORIAL ANALYSIS

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 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

$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 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...

โš™๏ธ Operations Dashboard

Active projects across all service lines

๐Ÿ—๏ธ
Awarded
-
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 Margin
$0
0% average
Pending from GC
$0
Outstanding
Loading painting projects...
โœจ Final Cleaning
Field Operations & Daily Reports
Loading Final Cleaning projects...
OPERATIONS

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 Solutions
COMMERCIAL SERVICES

๐Ÿ“‡ Contacts Directory

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

๐Ÿ“‡

Loading contacts...