Connecting to Data Lake...

Aggregating SQLite schemas

Dashboard

Pipeline —
Notification

💚 QuickBooks Live Data — Expenses, Invoice Sales & Reports

Loading QuickBooks data from Excel exports…

🏗️ BuilderTrend Live Data — Projects, Labor, POs & Bills

Syncing BuilderTrend data from exports…

🏗️ BuilderTrend Live Data — Projects, Labor, POs & Bills

Syncing BuilderTrend data from exports…

Revenue vs. Cost by Dept

Project Status Breakdown

🏆 Top 5 Healthy Projects

Calculating...

⚠️ Top 5 At-Risk Projects

Calculating...

⏱️ Recent System Activity

Fetching recent activity...

Active Projects Ledger

Showing all projects

Financial Analytics & Department Insights

Monthly Revenue vs. Outlay (Run-Rates)

Cost Breakdown by Department

Project Profitability Matrix

Top 5 Vendor Expenditures

Recurring & Billing Data (RBN Hours & Meters)

Recurring Job Details & Budget
Job / BuildingPortfolioRead Type Total Mtrs Monthly Rev Manual Hrs BdgManual Hrs Act Remote Hrs BdgRemote Hrs Act Total Hrs Bdg Contract EndAlerts
Employee Utilization & Costs
Employee NamePrimary RoleTotal HrsBillable HrsUtilizationAllocated Cost
Recent Vendor Bills (Accounts Payable)
DateJob / ProjectVendorOverhead / IS CategoryAmountStatus
Accounts Receivable Ledger
Invoice #Customer / ClientRevenue CategoryTotal BilledOutstandingStatus
Purchase Order Commitments
PO NumberJob NameVendorCreatedTotal CostPaidRemainingStatus

🔬 Full Client-File Analysis — Every Row, Every Column

➕ New Entries, What-If Scenarios & Capacity Planner

New Overhead Entry
Overhead Entries
DescriptionCategoryFrequencyAmount