Client Revenue Breakdown
-- clients| Client | Service | Supplies | Cost | Profit | Margin | Balance | Status |
|---|---|---|---|---|---|---|---|
| Loading QuickBooks data... | |||||||
Aging Breakdown (Service Revenue)
Revenue: QuickBooks API (real-time) | Costs: editable (click any cost cell) | Saved locally
CRM Portal
Sign in with your company account to continue
Only @keenonklean.com accounts
For supervisors, team leads & subcontractors
Welcome back,
ยฉ 2025 Keen On Klean Solutions
Set up your field team access
Welcome back! Here's what's happening with your projects.
Manage your projects through each stage of the sales process.
Loading projects...
Review and fix data quality issues
Your sales performance
$0
0 projects won
$0
0 active leads
0%
0 of 0 closed
$0
0 projects lost
Projects assigned to you for action
Projects where you've been mentioned in comments
Team performance overview
Active leads requiring follow-up
Add a new project to your pipeline. Required fields are marked with *
Invoices & Collections Overview
Export invoice data for: This Year
0 invoices will be exported
You don't have permission to view the Finance Dashboard.
Contact your administrator if you need access.
$0
Loading...
0%
Loading...
--
Days Sales Outstanding
$0
This week deposits
$0
This week outflows
Current
$0
0%
* NEW
1-30 Days
$0
0%
* Pay App Window
31-60 Days
$0
0%
61-90 Days
$0
0%
* Expecting Payment
90+ Days
$0
0%
* Action Required
| Invoice # | Client / GC | Invoice Date | Amount | Status | Days Out | Link |
|---|---|---|---|---|---|---|
| Loading invoices... | ||||||
Dual Engine โ Weekly T&M + Monthly Pay App
--
Active projects without invoice
--
Within billing window
--
Loading...
--
Unmatched + NOT IN CRM
Priority-based invoice collections
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".
Use this form for invoices that are already paid but need to be added to QuickBooks.
Manage user access and permissions for CRM modules
Select a user from the list to grant CRM access:
Upload ClockShark CSV to calculate biweekly payroll
Select your CSV file to calculate payroll automatically
| Employee | Type | Hours Worked | Period Pay |
|---|---|---|---|
| Subtotal Salary | $0 | ||
| # | Employee | Hours | Rate | Pay |
|---|---|---|---|---|
| Subtotal Hourly | 0 | $0 | ||
Manage salary employees and hourly rates
Previously saved payroll periods
Complete report from QuickBooks, Payroll & ClockShark - 2025
| Rank | Subcontractor | Type | Total Paid | % of Subs |
|---|---|---|---|---|
| 1 | CADENA CARDONA CLEANING SERVICES, LLC | ๐งน Janitorial | $549,138 | 44.6% |
| 2 | OSMAN (Ospina / Antunez / Sevilla) | ๐๏ธ Painting | $507,954 | 39.6% |
| 3 | Meta-Drywall Services LLC | ๐๏ธ Construction | $45,082 | 3.7% |
| 4 | Patricio Corona | $42,547 | 3.5% | |
| 5 | LAMB JK LLC | $36,763 | 3.0% | |
| 6 | Zavala Cleaning Services | ๐งน Janitorial | $28,479 | 2.3% |
| 7 | Nolbert Insulation LLC | ๐๏ธ Construction | $24,000 | 1.9% |
| 8 | Total Value Service LLC | $17,218 | 1.4% | |
| 9 | Criscamar Services LLC | ๐งน Janitorial | $15,103 | 1.2% |
| 10 | Procleaning | ๐งน Janitorial | $15,019 | 1.2% |
| TOTAL TOP 10 | $1,281,303 | 100% | ||
โข 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)
Source: Expenses report (50 XOOM transactions in 2025)
| Category | Amount | % Revenue |
|---|---|---|
| ๐ฐ REVENUE | $5,471,025 | 100% |
| Services | $4,450,437 | 81.3% |
| Construction Income | $941,199 | 17.2% |
| Other | $79,389 | 1.5% |
| ๐ฆ COGS (Direct Costs) | ($2,668,352) | 48.8% |
| Cost of Labor | $2,291,857 | 41.9% |
| Materials & Supplies | $376,495 | 6.9% |
| ๐ต GROSS PROFIT | $2,802,673 | 51.2% |
| ๐ข OVERHEAD | ($1,615,780) | 29.5% |
| Admin Payroll & Salaries | $836,304 | 15.3% |
| 1099 Contractors (Commercial) | $226,046 | 4.1% |
| Insurance (All) | $198,618 | 3.6% |
| Equipment Rental | $80,228 | 1.5% |
| Office & Software | $69,395 | 1.3% |
| Gas & Fuel | $31,815 | 0.6% |
| Rent/Lease | $32,884 | 0.6% |
| Other Overhead | $140,490 | 2.6% |
| ๐ฐ NET INCOME | $1,186,893 | 21.7% |
| ๐ฐ 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% |
| 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 |
How it works:
Main Subs:
How it works:
Accounts:
How it works:
Accounts:
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
Register check payments and match to invoices
Upload check documents for AR to process later
Revenue and collection data from QuickBooks
| Client | Service | Supplies | Cost | Profit | Margin | Balance | Status |
|---|---|---|---|---|---|---|---|
| Loading QuickBooks data... | |||||||
Revenue: QuickBooks API (real-time) | Costs: editable (click any cost cell) | Saved locally
Manage janitorial supply orders for recurring clients
Select a client to create an order
| Product | Stock | Price | Qty | Total |
|---|
| Product | Price |
|---|
| Order # | Date | Client | Month | Items | Total | Status |
|---|
Current inventory levels and availability
Loading Paper Supplies...
Connecting to inventory system
Request supplies for a client or project
Fill in the details for this order
Choose items and quantities
Loading products...
View all inventory orders
| Order ID | Date | Requested By | Client/Project | Items | Total | Status |
|---|---|---|---|---|---|---|
| Loading orders... | ||||||
Cost breakdown and profit margins
Loading financial data...
Active projects across all service lines
Track painting contracts, SOV progress, and subcontractor payments
Loading painting data...
The system will automatically extract project info and SOV lines
Or fill in the form manually below
Upload the SOV / Pay Application PDF from the GC
* GC Base Contract will be auto-calculated from SOV total
Upload a PDF or paste from GCPay to preview SOV lines
Loading labor data...
Manage contacts for GC/Clients โ PMs, Estimators, Superintendents & more
Loading contacts...
Loading your projects...
Add to your home screen in 2 steps:
All registered payments with audit trail
Are you sure you want to void this payment?