← All case studies
Superannuation & Wealth

Superannuation Fund Reporting

Member, contribution and investment reporting on one reconciled model — regulatory packs and member statements produced from a single, defensible source.

Power BIData ModellingReconciliationAPRA Reporting
Superannuation Fund Reporting — illustrative photography

The challenge

Fund reporting was assembled by hand each period — administration, custodian and investment data stitched together in spreadsheets. Member statements, board packs and regulatory submissions each drew on slightly different cuts, so reconciling them consumed days and left room for error in numbers that have to be exactly right.

The process

End to end — how data moves from source to decision.

Admin & Custodian
Members, unit prices, holdings
Reconciled
Daily control totals
Reporting Model
One conformed layer
Packs & Statements
Member · board · regulator

Our approach

How we structured the work.

01
Brought administration, custodian and investment feeds into one reconciled model with daily control totals, so every downstream report ties back to the same figures.
02
Built the reporting layer around the fund's real structures — options, member segments, unit prices — rather than a generic template.
03
Automated the recurring packs: member statement inputs, board reporting and regulatory tables generated from the single source instead of re-keyed.
04
Kept a clear reconciliation and lineage trail so any number in a regulatory pack can be traced back to source.

What the reporting looks like

An illustrative view of the dashboards this engagement produces. All figures are sample data for illustration only — not client results.

Superannuation Fund — Member & Investment Reporting
Sample data · illustrative
Reconciled
Daily unit price
+8.4%
1-yr crediting rate*
Members
Segmented view
APRA
Reg. pack ready

Net member contributions by quarter

Q1Q2Q3Q4Q1Q2

Investment option mix

Australian equitiesIntl equitiesFixed incomeProperty & altCash

Outcome

What changed
Member statements, board reporting and regulatory packs are now produced from one reconciled model. The period close is faster and the figures agree by construction, because everything traces back to the same reconciled source.

Related work

Other engagements with a similar shape.

Process × Intelligence

Have a similar problem?

Start with a conversation. We'll map the process, pressure-test the goal, and come back with a plan.

Get a Quote →