ABC Dashboard

Good morning

Financial Overview

Data last updated:
โ–ผ Configuration Options
Time Period:
โ–ผ ANALYSIS
Revenue
Average
-
Highest
-
Lowest
-
CAGR
-
Gross Profit Margin %
Average
-
Highest
-
Lowest
-
CAGR
-
Operating Profit %
Average
-
Highest
-
Lowest
-
CAGR
-
Cash
*Excludes Schwab account balances
Average
-
Highest
-
Lowest
-
CAGR
-
AR/AP Ratio
Average
-
Highest
-
Lowest
-
CAGR
-
Net Over/(Under) Billing
Average
-
Highest
-
Lowest
-
Current
-

Account Detail

Data last updated:
โ–ผ Configuration Options
Time Period:
Visuals:
Average
$0
Largest
$0
-
Smallest
$0
-
CAGR
0%
Account Activity
Monthly โ€“ 2026
Updated:

Income Statement

Data last updated:
โ–ผ Configuration Options
Time Period:
โ–ผ ANALYSIS

Revenue to Operating Income Waterfall

Flow from revenue through direct costs, indirect costs, and operating expenses to operating income.

ABC General Contractors, Inc.
Income Statement

Balance Sheet

Data last updated:
โ–ผ Configuration Options
Time Period:
โ–ผ ANALYSIS
ABC General Contractors, Inc.
Balance Sheet

Statement of Cash Flows

Data last updated:
โ–ผ Configuration Options
Time Period:
โ–ผ ANALYSIS
ABC General Contractors, Inc.
Statement of Cash Flows
Good morning

Job and PM Overview

Data last updated: -
Project Manager
Loading...
Status:
โ–ผ ANALYSIS

Key Metrics

# of Jobs
-
Contract Value
-
Billed Revenue
-
Earned Revenue
-
Billed Last Month
-
AR Due
-
Backlog
-
Net Over/(Under)
-

Margin Distribution

Budget vs Actual

Monthly Billing Trend

AR Outstanding

Jobs Started vs Closed by Year

Jobs Started Jobs Closed

Revenue by Year

Contract Value (Jobs Started) Billed Revenue (Jobs Closed)

Overbilled Amounts by PM

Underbilled Amounts by PM

Open RFIs by PM

Overdue <7 Days >7 Days No Due Date

Open Submittals by PM

Overdue <7 Days >7 Days No Due Date

Profitability Heat Map

Profit margin by Project Manager and job size. Darker green = higher margin, red = negative margin.

Loss
High Profit
Loading heat map data...

PM Performance Radar

Compare selected PM performance across key metrics vs portfolio average.

Jobs by Type

Contract Value by Project Manager

Contract Value by Client

Key Metrics by Project Manager

# of Jobs
Average
-
Highest
-
Lowest
-
Contract Value
Average
-
Highest
-
Lowest
-
Est. Profit Margin %
Average
-
Highest
-
Lowest
-

Key Metrics by Client

# of Jobs
Average
-
Highest
-
Lowest
-
Contract Value
Average
-
Highest
-
Lowest
-
Est. Profit Margin %
Average
-
Highest
-
Lowest
-

Project Schedules

Job Timeline Gantt Charts
Data from Google Sheets: -
Project Manager
Construction
Procurement & Pre-Mobilization
Design and Permitting
Loading schedule data...

Missing Budgets

Active Jobs Without Budget Data
Data last updated: -
Project Manager
Loading...
Jobs Missing Budgets
-
Total Actual Cost
-
Job #
Description
Client
Type
PM
Actual Cost
Budgeted
Rev
Budgeted
Cost
First Cost
Date
Issue
Loading missing budgets data...
Page 1 of 1

Job Budgets

Data last updated: -
Project Manager
Loading...
Status:
โ–ผ ANALYSIS

Key Metrics

๐Ÿ“‹
-
Total Jobs
๐Ÿ’ฐ
-
Contract Value
๐Ÿ“Š
-
Est. Cost
๐Ÿ“ˆ
-
Est. Profit
%
-
Avg Margin
Quick Sort:
Job #
Description
Client
Status
Project Manager
Start
Date
โ–ถ Contract
Value
โ–ถ Projected Cost
Estimated Profit
Profit Margin
Loading job data...
Page 1 of 1

Job Financials

Data last updated: -
Project Manager
Loading...
Status:
โ–ผ ANALYSIS

Key Metrics

# OF JOBS
-
TOTAL CLIENTS
-
BACKLOG
-
NET OVER/(UNDER)
-
UNDERBILLED
-
AVG EST PROFIT %
-
ACTUAL PROFIT %
-
AVG JOB DURATION
-
AVG JOB SIZE
-
AVG % COMPLETE
-
All Jobs โ–ผ
All Clients โ–ผ
Quick Sort:
Job #
Description
Client
Start
Date
End
Date
Status
Project Manager
Contract
Value
Billed
Revenue
Earned
Revenue
Over/(Under)
Budgeted
Cost
Act.
Cost
% Complete
Est.
Profit
Act.
Profit
Est
Margin %
Act.
Margin %
Backlog
Loading job actuals data...
Page 1 of 1

Job List

Job Data from Procore

Loading Procore data...

RFIs & Submittals

Open RFIs and Submittals by Due Date Status
Data last updated: -
View By:
Overdue Next 7 Days > 7 Days

RFIs by Project Manager

Submittals by Project Manager

Job # Description PM RFIs Submittals
Overdue Due <7 Days Due >7 Days Closed No Due Date Overdue Due <7 Days Due >7 Days Closed No Due Date
Loading data...

Change Orders

Prime and Commitment Change Orders by Status
Data last updated: -
Draft Out For Bid Out for Signature Approved Complete Terminated/Void

Prime Contract Change Orders by PM

Commitment Change Orders by PM

Project Manager / Job Prime Contracts Commitments
Draft Out For Bid Out for Sig Approved Complete Term/Void Draft Out For Bid Out for Sig Approved Complete Term/Void
Loading data...

Procore-Foundation Reconciliation

Jobs with status mismatches between Procore and Foundation
Closed in Foundation, Active in Procore Active in Foundation, Inactive/Missing in Procore In Procore Only
Job # Job Name Project Manager Foundation Status Procore Status Issue
Click Refresh Data to load reconciliation.

Client List

Contract Values by Client and Year (based on Job Start Date)
Data last updated: -
Project Manager
Loading...
Year Range:
to
Client
Loading clients data...

Closed Job Analysis

Performance Analysis of Completed Jobs
Data last updated: -
Project Manager
Loading...
โ–ผ ANALYSIS
Key Metrics
# of Jobs
-
# of Clients
-
Avg Duration
-
Avg Job Size
-
Total Billed Revenue
-
Avg Budgeted Margin
-
Avg Actual Margin
-
Job # Description Client PM Start Date End Date Budgeted Revenue Billed Revenue Rev Diff Budgeted Cost Actual Cost Cost Diff Budgeted Profit Actual Profit Profit Diff Budgeted Margin Actual Margin Margin Diff
Totals / Averages - - - - - - - - - - - -
Loading closed job data...
Page 1 of 1

Over/(Under) Billing

Job Billing Status Analysis
Data last updated: -
Project Manager

Summary Commentary

No commentary added yet. Click Edit to add summary notes.

Key Metrics

๐Ÿ“‹
0
Total Jobs
๐Ÿ“„
$0
Contract Value
๐Ÿ’ต
$0
Billed Revenue
๐Ÿ“ˆ
$0
Earned Revenue
๐Ÿ“Š
$0
Overbilled
๐Ÿ“‰
$0
Underbilled
๐Ÿ“‰
$0
Underbilled (excl. T&M)
โš–๏ธ
$0
Net Over/(Under)

Top 10 Overbilled Jobs

Top 10 Underbilled Jobs

All Jobs โ–ผ
All Clients โ–ผ
Job #
Description
Client
PM
Type
Contract
Value
Est. Cost
Act.
Cost
% Complete
Billed
Revenue
Earned
Revenue
Over/(Under)
Status
Loading data...
Totals - - - - - - -
Page 1 of 1

Labor Hours

Employee Hours by Job
Data last updated: -
Project Manager
Loading...
Status:

Hours by Pay Period

Hours by Job

Hours by Employee per Month

Hours by Trade per Month

Hours by Job per Month

All Jobs
All Employees
All Trades
Job #
Job Description
Employee Name
Trade
Regular Hours
OT Hours
DT Hours
Other Hours
Total Hours
Subtotal 0 0 0 0 0
Page 1 of 1

Job Costs

Job Cost Breakdown by Category
Data last updated: -
Project Manager
Loading...
Status:

Top Spend Categories as a % of Revenue

Shows which cost categories consume the largest share of earned revenue
Job #
Job Description
Project Manager
Cost Code
Description
Total Cost
% of Total Cost
% of Revenue
Loading cost code data...
Totals - 100.00% -
Page 1 of 1

Workforce Dashboard

Employee Metrics & Composition Analysis
Data last updated: -
Active Headcount
-
Hires YTD
-
Terminations YTD
-
Attrition Rate
-
Avg Tenure
-
New Hire Retention
-

Headcount Trend

Hires vs Terminations

Retention Rate Over Time

Retention by Trade

Employees by Trade

Tenure by Trade

Employee Directory

Name Hire Date Term Date Type Trade
Loading employees...

Vendor Payment Status

Data last updated: -

Top 10 Vendors by Spend

2015 to 2026
Vendor
# Inv Invoice #
Invoice Date
Job #
Job Desc.
Project Manager
Non-Retention
Retention
Invoice Amount
Paid-to-Date
Remaining
Status
Loading invoice data...
Page 1 of 1

Accounts Payable Aging

Data last updated: -
Project Manager:
Loading...
Total Due
excl. retainage
$0.00
Total Retainage
$0.00
Current (0-30 Days)
$0.00
31-60 Days
$0.00
61-90 Days
$0.00
90+ Days
$0.00

AP Aging

as of: -
All Vendors โ–ผ
All Jobs โ–ผ
Vendor
Total Due
0-30 Days
31-60 Days
61-90 Days
90+ Days
Retainage
Loading AP aging data...

Accounts Receivable Aging

Data last updated: -
Project Manager:
Loading...

Key Metrics

Total Due
excl. retainage
$0.00
Total Retainage
$0.00
Current (0-30 Days)
$0.00
31-60 Days
$0.00
61-90 Days
$0.00
90+ Days
$0.00

AR Aging

as of: -
All Customers โ–ผ
All Jobs โ–ผ
Customer
Total Due
Total Incl. Ret. 0-30 Days
31-60 Days
61-90 Days
90+ Days
Retainage
Loading AR aging data...

Income Statement Forecast

Jan 2025 - Dec 2027 | All values in $000s (thousands) | Actuals through last complete month, then forecast
Actual Forecast Has Comment

AI Insights

Ask questions about your financial data
โ„น๏ธ
Demo Mode โ€” AI Not Connected
This demo uses sample data to showcase the AI Insights interface. In a live production environment, the AI engine connects to your real-time financial, job cost, and project data to answer natural language questions and deliver comprehensive business intelligence analysis. All responses shown here are illustrative examples of the feature's capabilities.

Welcome to AI Insights

Ask any question about your jobs, AR/AP, project managers, vendors, or financial data. Try one of the sample questions below to see how it works.

Cash Balance & Transactions

Data last updated: -
Loading...

Daily Cash Balances

Average
-
Highest
-
-
Lowest
-
-
Growth
-
Calculating daily balances...
Loading transactions...

2026 Goal Tracking

Track progress against ABC General Contractors' 2026 strategic objectives

2026 Company Objective

ABC General Contractors will achieve sustainable, profitable growth โ€” reaching $70M in revenue and $70M in backlog by 2026 โ€” by leading with care for our clients, people, and community. Through collaboration, safety, and accountability, we will deliver exceptional projects, strengthen trust, and build lasting resilience.

2026 Strategic Goals

๐Ÿค

Clients First

Achieve โ‰ฅ90% Client Retention

Deliver consistent quality and proactive communication that strengthens trust, retention, and long-term partnerships.

๐Ÿ‘ฅ

Our People

Build, Engage, and Develop Our Teams

Keep voluntary turnover below 10%, raise engagement by 10%, and expand leadership and career development opportunities.

๐Ÿ”—

Unity & Collaboration

Strengthen Fieldโ€“Office Alignment

Foster teamwork, accountability, and shared problem-solving across field and office teams to drive alignment on goals and outcomes.

๐Ÿ›ก๏ธ

Care & Safety

TRIR <1.0, Zero LTIR, 100% Protocol Adherence

Maintain safety excellence with 100% adherence to safety protocolsโ€”fostering a culture where well-being and transparency drive performance.

๐ŸŒ

Community Impact

Deepen Engagement & Industry Leadership

Continue investing in community partnerships and workforce development initiatives that reflect ABC's values and reputation.

โš™๏ธ

Operational Excellence

Strengthen Execution & Continuous Improvement

Enhance consistency and accountability through standardized processes, proactive planning, and data-driven decision-making.

Financial Performance Tracking

๐Ÿ’ฐ Revenue --
Goal: $70M
YTD Actual: --
--
๐Ÿ“Š Backlog --
Goal: $70M
Current: --
--
๐Ÿ“ˆ Job Margin --
Goal: 25%
Current Avg: --
--
๐Ÿ‘ฅ Attrition Rate --
Goal: <10%
TTM Rate: --
Overall attrition (voluntary data N/A)
โญ Client Retention --
Goal: โ‰ฅ90%
Current: --
Survey data pending
๐Ÿ›ก๏ธ Safety (TRIR) --
Goal: <1.0
Current: --
Safety data pending
On Track A Little Behind Far Behind Click status to change

Weekly Cash Report

ABC General Contractors cash position and activity - trailing 10 weeks

Summary
Click "Run Analysis" to generate an AI-powered cash summary.

Weekly Cash Balance

ABC General Contractors Combined
Current Balance
--
Morning balance
Deposits
--
Past 7 days (excl. transfers)
Withdrawals
--
Past 7 days (excl. transfers)
Net Change
--
vs. prior week balance

Cash Balance Safety Check

Cash Balance -- Excludes Schwab and other entities
+
Receivables (AR) -- Excludes retention
โˆ’
Payables (AP) -- Excludes retention
โˆ’
Net Over/Under Billing -- Subtracts net over/(under) bill
โˆ’
Operating Reserve (3-mo SG&A) --
=
Safety Check --

Top 5 Deposits

Prior day (excl. transfers)
Loading...

Top 5 Withdrawals

Prior day (excl. transfers)
Loading...

Month End Report

Data last updated: -

Financial summary for the selected month with YTD comparisons.

Summary
Click "Run Analysis" to generate an AI-powered month end summary.
--
Monthly Grade
Calculating...
Details
๐Ÿ’ฐ
$0.0M
Net Revenue
-
๐Ÿ“Š
0.0%
Gross Margin
-
๐Ÿ“ˆ
0.0%
Operating Margin
-
๐Ÿฆ
$0.0M
Cash (excl Schwab)
-
๐Ÿ—๏ธ
0
Active Jobs
-
๐Ÿ“‹
$0.0M
Backlog
-
โš–๏ธ
$0.0M
Gross Underbilling
-
๐Ÿงพ
$0.0M
Total Billed
-
๐Ÿ“ฅ
$0.0M
AR Over 90 Days
-
๐Ÿ“ค
$0.0M
AP Over 90 Days
-
๐Ÿ“Š
0%
Avg % Complete
-
๐Ÿ’ต
+$0 / -$0
Cash Activity
Net: $0

User Administration

Manage users, roles, and permissions for the ABC Dashboard.

Name Email Role Status Last Login Actions
Loading users...
Loading roles...
Date/Time Category Severity User Action Details IP Address
Loading audit log...