Mock mode only — no live AI, no sending, no deleting, and no outside connections.
Mock response
Mock AI is ready. Ask it to create, find, update, or explain something.
Analyze
See how the business is doing — money in, money out, open balances, and job averages.
Money Overview
Total Billed
$56,645
All invoices sent
Total Paid
$13,956
Cash collected
Money Owed To Us
$42,689
2 open invoices
Total Company Expenses
$24,640
All posted job costs
Gross Profit (Paid Jobs)
$-10,684
After expenses
Gross Margin % (Paid Jobs)
-76.6%
Target: 55%
Collection Rate
24.6%
Paid ÷ invoiced
Avg. Days Past Due
22 days
Open sent invoices
Job Cost vs Estimate
Jobs Over Estimate
0
Cost came in above estimate
Jobs Under Estimate
3
Cost came in at or below estimate
Jobs Below 55% Margin
2
Review sell price on these jobs
Strong Margin Jobs
1
55%+ margin and under budget
Receivables — Money Owed To Us
Billed & Paid
2 jobs
$18,116
Billed & Unpaid
2 jobs
$42,689
Completed — Not Billed
1 job
Work done, invoice not sent
In Progress
4 jobs
Active or awaiting inspection
A/R Aging Buckets
| Bucket | Jobs | Amount Owed |
|---|---|---|
| 0 – 30 Days | 1 | $1,800 |
| 31 – 60 Days | 1 | $10,667 |
| 61+ Days | 0 | $0 |
Unpaid Balances
Dorothy Hayes
Dorothy Hayes — Bathroom Modification · 31-60 Days
$10,667
James Miller
James Miller — Ramp Install · 0-30 Days
$1,800
Billing Health
Completed Not Billed
$10,000
Jobs waiting on invoice work
Disputed Amount
$6,222
Invoices needing review
Follow-Up Workload
3
2 still open
Invoice Status Breakdown
| Status | Count |
|---|---|
| Paid | 1 |
| Partially Paid | 1 |
| Overdue | 1 |
| Needs Approval | 1 |
| Draft | 1 |
| Sent | 1 |
| Disputed | 1 |
Payment Method Breakdown
| Method | Amount |
|---|---|
| Agency Payment | $13,956 |
Project Averages
Based on 2 completed and paid jobs.
Avg. Project Value
$9,058
Paid revenue per job
Avg. Total Expenses
$4,000
Per completed job
Avg. Materials
$2,150
Per job
Avg. Labor
$1,725
Per job
Avg. Travel
$125
Per job
Avg. Profit / Loss
$5,058
Per completed paid job
Expenses by Category
| Category | Total |
|---|---|
| Materials | $5,900 |
| Labor | $3,800 |
| Travel | $200 |
| Fuel | $50 |
Mock data only — no live SharePoint or AI connection.