Selah & Co/Portfolio/Financial Intelligence Suite
Financial Intelligence · Agribusiness, Victoria, Australia

Financial Intelligence Suite
P&L, Cash Flow & Balance Sheet

A complete financial reporting suite in Power BI, connected directly to the client's ERP system, built to give the CFO and senior leadership on-demand access to the numbers that previously required a request and a wait.

Client
Agribusiness (Victoria, Australia) — confidential
Role
Finance BI Consultant
Stack
Power BI · DAX · Dataflows · ERP integration
Status
In production
Context

The situation

The finance team's standard process for producing P&L, cash flow and balance sheet reporting was manual: the CFO would request a report, and the finance team would compile it from source. There was no single, governed model behind the three statements — each was built fresh, on request, from raw ERP exports.

This created two problems. First, latency — the CFO's access to financial position was only as current as the last manual compile. Second, consistency risk — without a shared data model, there was no guarantee that figures in the P&L, cash flow and balance sheet reconciled against a single source of truth.

The Shift

Before & after

Before

Financial reporting was produced manually by the finance team, on request from the CFO. Each report was a fresh compile from ERP exports, with no shared underlying data model across the three statements.

After

The CFO has on-demand access to P&L, cash flow and balance sheet through a single Power BI suite, refreshed daily and connected directly to the ERP system — available whenever it's needed, not just when requested.

Approach

What was built

01
Income statement (P&L) dashboard with actual vs budget vs prior year variance analysis, drill-down by department and cost centre, and trend forecasting.
02
Cash flow dashboard providing real-time actual cash movements alongside a forward-looking forecast, replacing the CFO's manual cash flow process.
03
Balance sheet dashboard with correctly modelled assets, liabilities and equity, integrated with P&L and cash flow into one navigable suite.
04
Shared financial data model — chart of accounts hierarchy, date intelligence, and documented KPI definitions underpinning all three statements, so every number ties back to a single source of truth.
05
Dataflows architecture automatically refreshed from the ERP system daily, removing manual export and compile steps entirely.
Outcome

Where it stands

3
Financial statements unified in one Power BI suite
Daily
Automated refresh, replacing on-request manual compiles
1
Shared data model as single source of truth
Power BI DAX Financial Modelling P&L Reporting Cash Flow Balance Sheet Dataflows ERP Systems

Facing something similar?

Engagements start with a scoping call, then a time & materials quote based on what's actually needed.

Get in Touch View All Work
Other case studies
Operations Intelligence
Farm Operational Dashboard — Crops, Harvest & Yield
Operations Intelligence
Sales, Packhouse & Warehouse Operational Dashboard
Strategic Measure
Major Giver Trend & Strategic Measures Dashboard