⚠
Red Flags — Action Required
Monthly Net Profit / Loss
Green = profitable · Red = loss month
Cost Structure
Where every pound goes
ℹ Profitability shown only where revenue is matched to Asana hours. Fix: ensure client names in Asana match accounting system.
| Client | Actual Hrs | Est Hrs | Variance | Revenue | Labour Cost | Gross Profit | Best Margin | Latest Margin | Status |
|---|
Revenue vs Cost
Clients with matched data
Hours by Client
Total actual hours logged
Client Profitability Trend
Revenue vs cost vs margin %
01
Contractor Ranking — Most to Least Expensive
| # | Name | Type | Total Cost | Monthly Avg | Months Active | Note |
|---|
Monthly Spend — Top Contractors
Cash out per person per month
Client vs Overhead Labour
Delivery vs operations spend
02
Total Team Cost by Month
Stacked: Client Labour + Overhead
Month on month total cash going out
Actual vs Estimated by Client
Over or under estimating?
Hours by Assignee
Who carries the workload?
| Assignee | Actual Hours | Estimated Hours | Variance | Verdict |
|---|
Actual vs Estimated Hours by Month
Is output growing?
Revenue vs Total Costs vs Net Profit
Full company view
| Month | Revenue | Client Labour | OH Labour | Software | Banking | Accounting | Consult. | Other | Total Costs | Net Profit | Margin |
|---|
Cost Breakdown
Stacked by category
Net Margin by Month
Profitability trend
🏦
Cash Flow Command Centre — Coming Next
Will connect to your Wise bank account to show exactly when money moves in and out — so you spot cash crunches before they happen. Structure is built. Two things needed: Wise CSV export and payment terms per client.
✓ Revenue data ready
✓ Contractor costs ready
✓ Structure built
⏳ Wise CSV — pending
⏳ Payment terms — pending
Current Bank Balance
••••••
Connects to Wise CSV
Expected In (30 days)
••••••
Outstanding invoices
Committed Out (30 days)
••••••
Known contractor invoices
Projected Net Position
••••••
Balance + In − Out
Avg Days to Get Paid
•• days
Invoice → cash received
Danger Week
Wk ••
Lowest balance point
Daily Cash In vs Cash Out
Money landing in bank vs going out · Wise data needed
📊
Timeline chart will appear here
Daily cash inflows from client payments vs outflows to contractors. Shows the gap between when you pay out and when clients pay in.
→ Export Wise CSV to unlock
Structural Cash Squeeze
Based on contractor invoice patterns already in your data
⚠ Week 1–2 of month
Contractor invoices arrive immediately. Client invoices raised but no payments landed yet. Cash goes out before it comes in.
⚡ Week 2–3 of month
15-day clients start paying. Cash recovers but 30-day clients still outstanding. Balance improving but tight.
✓ Week 4 of month
30-day clients pay. Balance at highest. But next cycle starts in days — needs to fund next month's contractor costs.
90-Day Cash Runway
Projected balance · Wise needed for starting point
📈
Forecast chart will appear here
Week by week projected balance for 90 days using known costs and expected client payments.
→ Add payment terms per client to unlock
1️⃣
Export Wise Statement
Wise → Statements → GBP account → Jan 2025 to today → CSV → Download
2️⃣
Add Payment Terms Tab
New Google Sheet tab: PAYMENT_TERMS. Two columns — Client Name and Days to Pay (15 or 30).
3️⃣
Paste Bank Statement
New tab: BANK_STATEMENT. Paste Wise CSV. Publish as CSV alongside other tabs.
4️⃣
Share URLs
Send the two new CSV URLs and this section goes live with real balance, gap analysis and forecast.