💰 Finance Dashboard

Financial Performance & Analytics
🌳 GL Account Structure
Total Revenue
$0.00
↑ 12.5% vs last month
Gross Profit
$0.00
↑ 8.3% vs last month
Net Profit
$0.00
↑ 15.2% vs last month
Profit Margin
0.0%
↑ 2.1% vs last month
Monthly Revenue Trend
📊 Chart loading... (MYOB API integration required)
Revenue by Product/Service
📊 Chart loading... (MYOB API integration required)
📊 Consolidated Profit & Loss Statement
Line Item Consolidated AU - Main AU - Rightshoring NZ India AU - Products US Germany
Revenue $0 $0 $0 $0 $0 $0 $0 $0
Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0
Gross Profit $0 $0 $0 $0 $0 $0 $0 $0
Gross Margin % 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
Operating Expenses
Salaries & Wages $0 $0 $0 $0 $0 $0 $0 $0
Marketing & Sales $0 $0 $0 $0 $0 $0 $0 $0
General & Admin $0 $0 $0 $0 $0 $0 $0 $0
Other Operating Expenses $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $0 $0 $0 $0 $0 $0 $0 $0
EBITDA $0 $0 $0 $0 $0 $0 $0 $0
EBITDA Margin % 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
Depreciation & Amortization $0 $0 $0 $0 $0 $0 $0 $0
Operating Income (EBIT) $0 $0 $0 $0 $0 $0 $0 $0
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0
Tax Expense $0 $0 $0 $0 $0 $0 $0 $0
Net Income $0 $0 $0 $0 $0 $0 $0 $0
Net Margin % 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
💡 Note: This P&L shows nfoldROI Holding Pty Ltd (AU) consolidated financials alongside each operating entity. Historical revenue data is available - operational expense breakdown requires GL account mapping in MYOB.
Cash on Hand
$0.00
↑ 5.2% vs last month
Cash Inflow
$0.00
↑ 18.7% vs last month
Cash Outflow
$0.00
↑ 12.3% vs last month
Net Cash Flow
$0.00
↑ 24.5% vs last month
Cash Flow Forecast
📊 Chart loading... (MYOB API integration required)
Revenue Budget
$1,200,000
105.2% achieved
Expense Budget
$950,000
92.1% utilized
Budget Variance
$175,000
↑ Favorable
YTD Performance
108.3%
↑ Above target
Budget vs Actuals by Department
📊 Chart loading... (MYOB API integration required)
Department Budget Actual Variance % of Budget
Loading data from MYOB...
Current Ratio
2.5:1
↑ Healthy
Quick Ratio
1.8:1
↑ Healthy
Debt-to-Equity
0.45
↓ Low risk
ROI
18.5%
↑ Strong
Days Sales Outstanding (DSO)
32 days
↓ Improving
Days Payable Outstanding (DPO)
45 days
→ Stable
Working Capital
$0.00
↑ 12.3%
EBITDA Margin
24.5%
↑ 3.2%
KPI Trends (Last 12 Months)

Accounts Receivable Aging

Current (0-30 days)
$0.00
Healthy
31-60 Days
$0.00
Monitor
61-90 Days
$0.00
Action Needed
90+ Days
$0.00
Critical
AR Aging Distribution
📊 Chart loading... (MYOB API integration required)

Accounts Payable Aging

Current (0-30 days)
$0.00
On Track
31-60 Days
$0.00
Due Soon
61-90 Days
$0.00
Overdue
90+ Days
$0.00
Critical
Top 10 Overdue Customers
Customer Invoice # Amount Days Overdue Aging Bucket
Loading data from MYOB...
Total Operating Costs
$0.00
↓ 3.2% vs last month
Cost per Revenue Dollar
$0.72
↓ Improving
Labor Costs
$0.00
→ 45% of revenue
Material Costs
$0.00
→ 27% of revenue
Cost Breakdown by Category
📊 Chart loading... (MYOB API integration required)
Cost Trends (Last 12 Months)
Cost Category This Month Last Month Change % of Revenue
Loading data from MYOB...
🔗 Integrated Financial Model
Dynamic three-statement model showing how revenue, balance sheet, and cash flow are interconnected. Change one assumption and see it ripple through all statements automatically.
📋 Model Assumptions & Drivers
Revenue Growth Rate
25.0%
Annual target
Gross Margin
45.0%
Target margin
Operating Expense Ratio
30.0%
% of revenue
Days Sales Outstanding
32 days
Collection period
1️⃣ Income Statement (Profit & Loss)
Line Item Q1 2025 Q2 2025 Q3 2025 Q4 2025 FY 2025
Revenue $0 $0 $0 $0 $0
Cost of Goods Sold $0 $0 $0 $0 $0
Gross Profit $0 $0 $0 $0 $0
Operating Expenses $0 $0 $0 $0 $0
EBITDA $0 $0 $0 $0 $0
Depreciation & Amortization $0 $0 $0 $0 $0
Operating Income (EBIT) $0 $0 $0 $0 $0
Interest & Taxes $0 $0 $0 $0 $0
Net Income $0 $0 $0 $0 $0
💡 Link to Balance Sheet: Net Income flows to Retained Earnings
2️⃣ Balance Sheet (Financial Position)
Line Item Q1 2025 Q2 2025 Q3 2025 Q4 2025 FY 2025
ASSETS
Cash & Equivalents $0 $0 $0 $0 $0
Accounts Receivable $0 $0 $0 $0 $0
Inventory $0 $0 $0 $0 $0
PP&E (Net) $0 $0 $0 $0 $0
Total Assets $0 $0 $0 $0 $0
LIABILITIES
Accounts Payable $0 $0 $0 $0 $0
Accrued Expenses $0 $0 $0 $0 $0
Long-term Debt $0 $0 $0 $0 $0
Total Liabilities $0 $0 $0 $0 $0
EQUITY
Share Capital $0 $0 $0 $0 $0
Retained Earnings $0 $0 $0 $0 $0
Total Equity $0 $0 $0 $0 $0
Total Liabilities + Equity $0 $0 $0 $0 $0
💡 Links: Cash from Cash Flow Statement | Retained Earnings from Net Income | Balance sheet changes drive Cash Flow
3️⃣ Cash Flow Statement
Line Item Q1 2025 Q2 2025 Q3 2025 Q4 2025 FY 2025
OPERATING ACTIVITIES
Net Income $0 $0 $0 $0 $0
Depreciation & Amortization $0 $0 $0 $0 $0
Change in Accounts Receivable $0 $0 $0 $0 $0
Change in Inventory $0 $0 $0 $0 $0
Change in Accounts Payable $0 $0 $0 $0 $0
Cash from Operations $0 $0 $0 $0 $0
INVESTING ACTIVITIES
Capital Expenditures (CapEx) $0 $0 $0 $0 $0
Asset Purchases/Sales $0 $0 $0 $0 $0
Cash from Investing $0 $0 $0 $0 $0
FINANCING ACTIVITIES
Debt Issuance/Repayment $0 $0 $0 $0 $0
Equity Raised $0 $0 $0 $0 $0
Dividends Paid $0 $0 $0 $0 $0
Cash from Financing $0 $0 $0 $0 $0
Net Change in Cash $0 $0 $0 $0 $0
Beginning Cash Balance $0 $0 $0 $0 $0
Ending Cash Balance $0 $0 $0 $0 $0
💡 Link to Balance Sheet: Ending Cash Balance flows to Cash & Equivalents on Balance Sheet
✅ Model Validation & Key Metrics
Balance Check
✓ Balanced
Assets = Liabilities + Equity
Cash Reconciliation
✓ Matched
CF ending = BS cash
Free Cash Flow
$0
CFO - CapEx
Funding Gap
$0
External funding needed
💼 Use Cases for Three-Way Model
🎯 Strategic Planning
Model different growth scenarios and see impact on cash needs
💰 Fundraising
Show investors your path to $31M with detailed financial projections
📊 Valuation
DCF analysis using projected free cash flows
🔍 M&A Analysis
Model acquisition targets and financing structures
⚙️
MYOB Integration Required
This dashboard will be fully populated once the MYOB Advanced API integration is complete and the concurrent session limit is increased. Use the example scripts in myob_examples/ to start extracting data.