Core Business Metrics
Connecting to your data…
Unit Economics
Cash & Runway
Recent Sales
| Date | Product | Revenue | Status |
|---|---|---|---|
| Loading… | |||
Low Stock Alerts
Loading…
Daily Revenue — Last 30 Days
🏦
Investor-Ready Dashboard — All key metrics an investor or accelerator will ask about.
Revenue & Profitability
Unit Economics
Customer Metrics
Cost Structure
Cash, Working Capital & Runway
Discount Impact
Cap Table & Funding
Daily Revenue — Last 30 Days
📖 KPI Glossary
New Sale Entry
e.g. 10 means 10% off the total order
Discount Given
—
Sale Price/Unit
—
Total Revenue
—
Gross Profit
—
Gross Margin
—
🩸 BLEEDING ALERT — Selling at a loss!
All Sales
—
| Date | Customer | Product | Qty | Orig Price | Discount | Sale Price | Revenue | Gross Profit | Status |
|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||
Add / Update Raw Material
Raw Material Stock
—
| Material | Unit | Stock | Reorder At | Cost/Unit | Total Value | Supplier | Status |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Log Expense
Expense Ledger
—
| Date | Category | Description | Amount | Vendor | Type | Marketing? |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Log Funding Round
Funding History & Cap Table
| Date | Round | Investor | Amount | Equity % | Valuation | Notes |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Financial Reports & PDF Export
ℹ️ PDFs are generated from your live Google Sheets data and downloaded instantly.
Expense Breakdown — Selected Period
Select a date range above and click "Update View"
💎 Company Valuation Calculator
4 real-world methods used by investors. Enter your numbers and see your estimated valuation range instantly.
Enter Your Numbers
Estimated Valuation Range
PKR — to PKR —
Based on 4 methods ·
Midpoint Estimate
PKR —
Method 1: Revenue Multiple
Most common for consumer brands
PKR —
—
Method 2: Earnings Multiple
For profitable businesses
PKR —
—
Method 3: DCF
Discounted Cash Flow (5yr)
PKR —
—
Method 4: Asset-Based
Floor valuation
PKR —
—
📝 Investor Pitch Narrative
Copy this into your deck
—
⚙️ Settings & Data Safety
Configure courier shipping rates and review your data safety checklist.
🚚 Courier Shipping Rates
Enter the rate each courier charges you per shipment (PKR)
ℹ️ These rates are saved to your account and used as defaults when calculating net revenue on orders. You can override the rate on any individual order.
Loading rates…
✅ 5-Minute Data Safety Checklist
1️⃣ Enable Google 2FA
myaccount.google.com → Security → 2-Step Verification
2️⃣ Bookmark Your Sheet
Direct URL so you can access data even if app goes down
3️⃣ Monthly Excel Export
Sheets → File → Download → Excel (.xlsx) once a month
4️⃣ Protect Header Rows
Right-click row 1 → Protect Range in Google Sheets
5️⃣ Share with Backup Email
Share Sheet as Viewer with a second Google account you own
Loading pipeline…
All
⏳ Pending
🔧 Processing
📦 Packed
🚚 In Transit
✅ Delivered
💰 Pmt Pending
✓ Received
↩ Returned
✕ Cancelled
New Order
Order Pipeline
—
| Order ID | Date | Customer | Product | Revenue | Net Rev | Payment | Courier | Tracking | Status | Update Status |
|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||||
Customer Lookup
All Customers
—
| Name | Phone | First Order | Last Order | Orders | Total Spend | Returns | Returned Products | |
|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||
Loading stats…
Process a Return
Amount charged for shipping on original order
📦 Select items to restore back to inventory
⚗️ Ingredients / raw materials are always restored automatically.
Returns History
—
| Return ID | Date | Customer | Product | Qty | Reason | Condition | Refund | Restored | Not Restored | Status |
|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||||