Active Orders
β
In progress
Need Billing
β
Awaiting invoice
YTD Revenue
β
Verified 2026
ABS Balance
β
β
π Finance Snapshot
Revenue
β
Net Profit
β
Your 50%
π· Crew Live Status
β‘ Ismail β Needs Action
| WO# | Issue | Status | Action |
|---|
β‘ Shaheer β Needs Action
| WO# | Issue | Status | Action |
|---|
π DISPATCH BOARD
Click Refresh to load dispatch orders
| WO# | Problem# | State | Issue / Location | Status | Priority | NTE | Assigned | Sched | Quote Status | Actions |
|---|
| WO# | Problem# | State | Issue / Location | Status | NTE | Amount | Quote Date | Invoice Date | Actions |
|---|
| WO# | Problem# | State | Issue / Location | Status | Amount | Completion | Invoice Date | Actions |
|---|
PAYROLL
to
Total Labor
β
Mileage
β
Materials
β
TOTAL PAYROLL
β
| Employee | State | Rate | Hours | OT | Drive Miles | Riding Hrs | Labor $ | Riding $ | Mileage | Material | Total Pay |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Select week dates and click β» Load | |||||||||||
| TOTALS | β | β | β | β | |||||||
Click any cell to edit Β· Changes auto-calculate totals
β
Revenue
β
Expenses
β
Net Profit
β
ISMAIL β 50%
SHAHEER β 50%
ABS BALANCE
β
β
YEAR TO DATE
MONTHLY CALCULATION
Total Billed YTD
β
Total Collected
β
Outstanding
β
π§Ύ Invoice Tracker (90-Day Window)
| Invoice# | WO# | Issue | Amount | Billed | Due Date | Days Left | Paid | Balance | Status | Actions |
|---|
π
Shaheer Tracker β
Total Billed
β
Total Expenses
β
Net Balance
β
Each Share (50%)
π Work Orders
| Invoice # | WO # | Date | Description / Location | Notes | Owed ($) | Done | Paid ($) |
|---|---|---|---|---|---|---|---|
| TOTAL | β | β | |||||
π³ Expenses
| Category | Estimated ($) | Actual ($) | Status | |
|---|---|---|---|---|
| TOTAL | β | β | ||
π¦ Transfers
| Account | Date | Amount ($) | Notes | |
|---|---|---|---|---|
| TOTAL OUT | β | |||
ABS Balance from Previous Month
Payroll Adjustment
π Monthly Summary
YTD Cash Paid
β
Ismail Owes HDM
$21,634.51
Total Transactions
β
π° Payments Ledger β Real Cash Only
| Date | Category | Paid To | Amount | Notes | Action |
|---|
π Quote Builder
β¨
AI SCOPE REWRITER
Paste raw crew notes β get professional Emcor-style scope
Labor Subtotal: $0.00
Mat Subtotal: $0.00
+
% markup
Mat Total: $0.00
Equipment Total: $0.00
Labor + Materials + Equipment + Trip
TOTAL ESTIMATE
$0.00
π Saved Estimates
π‘ Saves to the QUOTES tab in your Google Sheet. Create that tab first if it doesn't exist.
Loading estimatesβ¦