Signature view · Funding river → Mill 19 project floor NetSuite GL · Excel project forecasts
How the money flows: sources → programs → 36 active projects, colored by burn health
On plan (90–110% of budget)
Watch (110–120%)
Over (>120%)
Under-spending (<90%)
Cell height = FY budget · bar inside = spend vs budget · hover any cell
Trend · 12 months, Oct 2025 – Sep 2026 NetSuite GL actuals vs Excel budget
Monthly spend: GL actual vs budget
NetSuite actualExcel budgetSelected period
What this board answers
Three questions the finance team asked
Breakdown · Budget vs actual NetSuite GL · Excel budget
By program
ActualBudgetOverrun beyond budget
People & payroll · Labor by department Rippling payroll register → NetSuite
Labor cost charged to projects vs indirect
Direct (charged to projects)Indirect / G&A
Obligation risk · FYTD run-rate projection NetSuite cumulative actuals · Excel PoP dates
Projects that exhaust obligation before period of performance ends
Invoicing & receivables · Members and sponsors NetSuite AR
Billed vs collected by funding source
CollectedOutstandingBudgeted billing
Ask the data · Private AI over the finance model
Natural-language questions, answered from governed NetSuite + Rippling data
Mock-up: the answer above is generated from the same illustrative dataset as this board, with every figure traceable to a source table. In production the model answers only from your Power BI semantic layer, inside your tenant.
Integration · Centralized reporting model
Three systems, one semantic layer
NS
NetSuiteGL actuals by project & account, AP, AR invoices and collections, cumulative obligation spend.
RP
RipplingHeadcount by department, payroll register, timesheet allocation of FTEs to projects vs indirect pools.
XL
ExcelApproved budgets, project forecasts, period-of-performance dates, provisional indirect rate.
