ARIA Platform / Finance & Planning
Finance & Planning Suite — Flagship Module

Financial Planning & Master Budget

The complete budgeting and forecasting cycle for the CFO — from sales plan to board pack. Ten integrated sub-modules covering revenue, COGS, OPEX, workforce, CAPEX, working capital, cash flow, projected financial statements, scenario analysis, and covenant monitoring. One connected system replacing dozens of spreadsheets.

aria.cloud/finance/sfp/master-budget
A Financial Planning — Master Budget FY 2027 V3-Appr. Forecast Recalc Revenue budget € 83.2M +12.4% vs FY26 EBITDA € 18.3M 22.0% margin Net income € 10.8M 13.0% net margin Free cash flow € 8.4M Operating CF - CAPEX Net Debt / EBITDA 1.8× Covenant: < 3.0× Scenarios 3 active Projected P&L — waterfall FY 2027 € millions 0 25M 50M 75M 83.2 Revenue -49.9 COGS 33.3 Gross M. 40.0% -15.0 OPEX 18.3 EBITDA 22.0% -4.2 D&A -3.3 Int+Tax 10.8 Net Inc. 13.0% Master budget cycle 1. Sales budget 2. COGS / Purchasing 3. OPEX budget 4. Workforce cost 5. CAPEX & D&A 6. Working capital 7. Cash flow 8. P&L + BS projection 9. What-if scenarios 10. Board pack Version management Budget Forecast Revised Actual Carry-forward between versions · Lock/unlock · Approval workflow
The complete CFO budgeting cycle
From the first sales forecast to the board presentation — every number flows through one connected system. Change the sales plan and watch it ripple through COGS, cash flow, and covenant ratios in real time.
01 · Sales budget

Revenue planning by customer, product, and territory

The starting point of the master budget. Plan sales volumes monthly by branch, customer group, and product — validated against a commercial price map. Automatic revenue calculation, commission computation, transfer pricing with margin target, and GROUPING SETS aggregation for summary views at any level.

  • Configurable dimensions: Branch × Customer × Product × Month
  • Validated commercial price map — no manual price entry errors
  • Transfer price engine with target margin calculation
  • Budget, Forecast, Revised versions with carry-forward
Sales budget — by product line · FY 2027 0 €10M €20M €30M € 18.2M Q1 € 20.8M Q2 € 19.6M Q3 € 24.6M Q4 Machines (52%) Services (30%) Spare parts (18%)
02 · COGS & Purchasing

Cost of goods sold with MRP-driven material requirements

Two modes: simplified (percentage-of-revenue by category) or analytical (BOM explosion via MRP exchange). Either way, the result feeds directly into gross margin. Budget materials, direct labor, and manufacturing overhead. For companies with multi-level BOMs, AERA explodes sales volumes into component purchases automatically.

  • Simple mode: COGS % per product category with variable/fixed split
  • Analytical mode: MRP explosion from sales volumes × BOM
  • Direct labor cost fed from Workforce Budget module
  • Manufacturing overhead allocation rules
COGS breakdown — FY 2027 Materials € 32.8M (66%) Direct labor € 8.8M (18%) Mfg overhead € 8.3M (16%) Total COGS: € 49.9M · Gross margin: € 33.3M (40.0%) MRP exchange — materials requirement Sales volume × BOM Components Purchases 12 product families · 340 BOM components · 84 suppliers · Valorization at latest purchase price
03 · OPEX budget

Operating expenses by cost center with allocation rules

Monthly data entry grid for every cost center and expense category. Supports multiple initialization modes: zero-based, last year actuals, rolling forecast, percentage uplift. Allocation rules distribute shared costs to BUs. Automatic separation of fixed vs variable components for breakeven analysis.

  • Cost center hierarchy with P&L account mapping
  • 5 initialization modes: zero, prior year, rolling, % uplift, manual
  • Fixed vs variable cost tagging for contribution margin analysis
  • Allocation engine for shared services (IT, HR, Facilities)
OPEX budget — by department · FY 2027 Total: € 15.0M € 4.2M Sales & Marketing Travel 1.2M · Advertising 1.8M · Commissions 1.2M € 3.8M G&A Rent 1.4M · Utilities 0.6M · Professional fees 1.8M € 3.2M R&D € 2.4M IT € 1.4M Other OPEX variance: Budget vs Prior Year Budget: € 15.0M · PY: € 14.2M · Variance: +€ 0.8M (+5.6%) · R&D +18% · IT +12% · S&M -3%
04 · Workforce cost

Personnel cost integration from Workforce Budget

Two paths: if the Workforce Budget module is active, costs flow automatically (headcount × RAL + INPS + TFR + benefits). If not, a simplified grid lets the controller enter total personnel cost by department and month. Either way, direct labor feeds into COGS and indirect labor feeds into OPEX — with the formula effective_hourly_cost = tariff / (1 - absenteeism_pct) propagating into production costing.

  • Analytical mode: automatic feed from Workforce Budget module
  • Simplified mode: manual grid by department × month
  • Direct labor → COGS · Indirect labor → OPEX split
  • Absenteeism-adjusted hourly cost for production costing
Workforce cost allocation — FY 2027 Direct labor → COGS € 8.8M 170 FTE · Avg cost: € 51.8K Effective hourly cost: € 28.40/h (incl. 5.2% absenteeism) Indirect labor → OPEX € 5.4M 103 FTE · Avg cost: € 52.4K Mode: Analytical (auto-fed from Workforce Budget module) 273 HC · 258.5 FTE Monthly total: € 1.18M avg/month Jan Feb Dec
05 · CAPEX & depreciation

Capital expenditure phasing with automatic depreciation

Plan investments by category (machinery, IT, vehicles, buildings) with monthly cash-out phasing. AERA calculates straight-line depreciation from the commissioning date, applying useful life by asset category. New CAPEX depreciation adds to the existing asset base. The result feeds D&A in the P&L and cash-out in the investing cash flow section.

  • Investment plan by category with approval status
  • Monthly cash-out phasing (editing grid)
  • Automatic depreciation: straight-line with configurable useful life
  • D&A → P&L · Cash out → Investing activities in CF
CAPEX plan — FY 2027 Total: € 6.2M New CNC machining center € 2.4M · Q2 delivery · 10yr useful life Annual D&A: € 240K (from Jul) ERP upgrade (Infor LN) € 1.8M · Q1-Q3 phased · 5yr useful life Annual D&A: € 360K (from Q4) Fleet renewal (8 vehicles) € 0.6M · Q1 · 4yr useful life Annual D&A: € 150K Warehouse automation € 1.4M · Q3-Q4 · 8yr useful life Annual D&A: € 175K (from Q4) D&A impact on P&L Existing assets D&A: € 3.3M + New CAPEX D&A: € 0.9M (partial year) = Total D&A: € 4.2M Cash flow impact CAPEX cash out: € 6.2M · Q1: € 1.2M · Q2: € 2.8M · Q3: € 1.4M · Q4: € 0.8M
06 · Working capital

DSO / DPO / DIO-driven working capital projection

Working capital doesn't need a separate budget — it's derived. Trade receivables from sales × DSO, trade payables from purchases × DPO, inventory from production × DIO. AERA calculates the net working capital change monthly, feeding directly into the operating cash flow. Seasonal patterns captured automatically.

  • Receivables: Sales × DSO with configurable collection pattern
  • Payables: Purchases × DPO with payment term rules
  • Inventory: Production plan × DIO (raw + WIP + finished)
  • ΔNWC → operating cash flow automatically
Working capital projection — FY 2027 Trade receivables € 12.6M DSO: 55 days Trade payables € 8.4M DPO: 62 days Inventory € 9.2M DIO: 68 days Net working capital: € 13.4M · ΔNWC vs PY: -€ 0.8M (cash release) Cash conversion cycle DSO: 55 days + DIO: 68 days - DPO: 62 days CCC: 61 days
07 · Cash flow planner

Full three-section cash flow statement

Operating, investing, financing — all three sections assembled automatically from the operational budgets. Customer collections from sales × DSO, supplier payments from purchases × DPO, payroll from workforce, tax estimates, CAPEX cash-out, debt service. Monthly granularity with rolling 12-month forward view. Minimum cash balance monitoring.

  • Operating CF: collections, payments, payroll, taxes
  • Investing CF: CAPEX, disposals, acquisition payments
  • Financing CF: debt drawdown, repayment, interest, dividends
  • Minimum cash balance alerts with credit line monitoring
Cash flow statement — FY 2027 Operating activities € 14.6M Net income€ 10.8M + D&A€ 4.2M + ΔNWC (cash release)€ 0.8M - Tax payments(€ 1.2M) Investing activities (€ 6.2M) CAPEX cash-out(€ 6.2M) Financing activities (€ 3.8M) Debt repayment(€ 2.4M) Interest paid(€ 1.4M) Net cash change: +€ 4.6M Closing cash: € 8.2M
08 · Projected P&L & Balance Sheet

Integrated financial statements that tie automatically

Everything rolls up into projected financial statements. The P&L assembles from the operational budgets. The balance sheet derives from working capital, CAPEX, debt, and retained earnings. If the balance sheet doesn't balance, there's a data error — AERA shows the discrepancy. Two P&L formats: cost-of-sales and value-added (Italian Codice Civile format).

  • P&L: cost-of-sales format and value-added (Valore Aggiunto) format
  • Balance sheet: assets = liabilities + equity (auto-verified)
  • Monthly, quarterly, and annual views
  • Budget vs Actual vs Forecast vs Prior Year comparison
Projected P&L — FY 2027 (cost-of-sales format) € thousands Budget PY Actual Variance % Revenue 83,200 74,000 +9,200 +12.4% Cost of goods sold (49,900) (44,400) -5,500 +12.4% Gross margin 33,300 29,600 +3,700 40.0% Operating expenses (15,000) (14,200) EBITDA 18,300 15,400 +2,900 22.0% Depreciation & amort. (4,200) Interest expense (1,400) Tax (1,900) Net income 10,800 8,600 +2,200 13.0% Balance sheet: Assets € 62.4M = Liabilities € 28.8M + Equity € 33.6M ✓ Balanced
09 · Scenario what-if engine

Multi-scenario analysis with instant P&L recalculation

What if revenue drops 10%? What if raw material prices increase 15%? What if we delay the CNC investment to next year? AERA lets you create unlimited scenarios by overriding any assumption — and recalculates the entire master budget in seconds. Compare scenarios side-by-side to support board decision-making.

  • Override any assumption: revenue growth, COGS %, FX rates, headcount
  • Full recalculation of P&L, BS, CF, and covenant ratios
  • Side-by-side scenario comparison dashboard
  • Sensitivity analysis: which variable impacts EBITDA the most?
Scenario comparison — FY 2027 Base case Revenue€ 83.2M EBITDA€ 18.3M Net income€ 10.8M FCF€ 8.4M ND/EBITDA1.8× Headcount282 Approved Downside (-10%) Revenue€ 74.9M EBITDA€ 13.8M Net income€ 7.2M FCF€ 5.6M ND/EBITDA2.4× Headcount275 Upside (+15%) Revenue€ 95.7M EBITDA€ 23.4M Net income€ 14.8M FCF€ 12.2M ND/EBITDA1.4× Headcount295 Key sensitivity: ±1pp revenue growth = ±€ 1.2M EBITDA Most sensitive variables: Revenue volume (€ 1.2M/pp) · Raw material prices (€ 0.8M/pp) · FX EUR/USD (€ 0.4M/1%)
10 · Covenant monitoring & Board Pack

Financial covenant tracking with automated board reporting

The final output. Monitor bank covenant ratios (Net Debt/EBITDA, Interest Coverage, Debt Service, Current Ratio) against thresholds — projected monthly to detect future breaches before they happen. Generate board-ready financial packages: P&L, BS, CF, variance analysis, KPIs, covenant status, and scenario summary in one export.

  • Covenant dashboard: projected ratios vs bank thresholds
  • Early warning: breach prediction 6-12 months ahead
  • Board Pack export: PDF/PowerPoint with all financial statements
  • Variance bridge: Budget vs Actual with P/V/Mix decomposition
Covenant monitoring — FY 2027 Board Pack ND / EBITDA 1.8× Limit: 3.0× 60% headroom Interest cover 10.1× Min: 4.0× Comfortable DSCR 1.4× Min: 1.2× Close to limit Current ratio 1.6× Min: 1.0× Healthy ND/EBITDA — 12-month forward projection Limit: 3.0× Min: 1.6× (Oct) Board Pack — ready for export P&L · Balance Sheet · Cash Flow · Covenant ratios · Variance analysis · Scenario comparison · KPI summary Export
See it in action
A walkthrough of the Financial Planning module — from sales budget entry through the entire cycle to board pack generation.
Video coming soon
10
Integrated sub-modules
€ 83M
Revenue planned
P&L+BS+CF
Full statements
Real-time
Scenario recalc
Ready to replace your budget spreadsheets?

No forms, no sales funnel. Just a conversation about what ARIA can do for your financial planning.