Navigating Financial Year End 💲🏗️📊📚

A Practical Guide for Council Infrastructure Asset Managers

Australian councils operate on a 1 July - 30 June financial year. That means the countdown to 30 June is a very real pressure felt across every department from Roads and Stormwater through to Finance and Governance. This guide is designed to help council asset management teams navigate that pressure with confidence.

Welcome to the Iamdata Solutions Asset Management Newsletter – June 2026

Jill Singleton

Director - Asset Management Specialist & Data Analyst

Why Financial Year End Matters More Than You Think

I know from when I worked at the Council that for us infrastructure asset managers, Financial Year End (FYE) isn't just a Finance department problem. The data your team provides, condition assessments, maintenance costs, renewal expenditure, and new assets constructed, feeds directly into the council's financial statements, asset registers, and long-term financial plans.

Get it right, and your council presents credible, audit-ready financials. Get it wrong, and you're looking at valuation adjustments, write-offs, or worse: qualified audit opinions that erode public trust.

1: Start Early

The single biggest mistake councils make is treating FYE as a June problem. By the time June arrives, it is too late to correct data errors, chase missing inspection records, or reconcile capital works expenditure. A structured four-month lead-up transforms year end from a crisis into a routine.

March	Audit asset register for completeness. Identify assets constructed, acquired, or disposed of during the year. Begin reviewing WIP.
April	Reconcile capital works expenditure. Confirm capitalisation vs. maintenance splits with Finance. Identify projects ready for capitalisation.
May	Finalise condition assessments and unit rates. Validate depreciation parameters. Prepare draft asset additions/disposals schedule.
June	Final data submission to Finance. Review and sign off on asset register. Support external auditors with documentation.

Here is a Real-world example: A regional Queensland council discovered in late May that $2.3 million in stormwater infrastructure completed in February had never been added to the asset register. The scramble to value, inspect, and record those assets in time for the audit created enormous pressure and a near-miss with their external auditors. Starting reconciliation in March would have caught this months earlier.

2: Know What Each Department Needs to Deliver

FYE is a whole-of-council exercise. Each department within your Infrastructure Asset Management function has a specific role to play and Finance and Governance can only do their jobs if departments deliver accurate, complete data on time.

Here is an example summary of what each area is expected to provide:

Department	Key FYE Deliverables
Transportation & Traffic	Status of roadworks, new infrastructure to capitalise, project cost data Condition data, maintenance vs. capital expenditure split Inspection records, condition ratings, renewal works costs Asset additions, renewals completed, performance data Regulatory compliance data, infrastructure renewals, WIP status New assets installed, renewals completed, condition assessments Condition inspections, capital works, depreciation data Vehicle acquisitions, disposals, written-down values
Road Maintenance
Bridge Maintenance
Stormwater Management
Water & Wastewater
Parks & Recreation
Buildings & Structures
Fleet Management
Finance	Consolidate all data into financial statements, ensure compliance
Governance	Authorise expenditure, oversee asset management plans and policy compliance

Get Clear on Capitalisation vs. Maintenance

One of the most common sources of confusion, (and audit findings) at FYE is the misclassification of expenditure. The distinction matters enormously for your financial statements:

Maintenance: Maintenance expenditure keeps an asset functioning at its current standard. It flows to the Profit & Loss as operating expenditure.

Capital: Capital expenditure improves, extends the life of, or creates a new asset. It is recorded on the Balance Sheet and depreciated over time.

Misclassifying capital works as maintenance understates your asset base and overstates operating costs. Misclassifying maintenance as capital inflates your asset register and hides the true cost of running your infrastructure. Either way, the auditors will find it.

Setting out clear distinctions in your Capital / Maintenance Policy will ensure that everyone in your organisation understands the difference and can refer back to the document when in doubt.

https://www.iamdata.solutions/post/how-to-distinguish-between-capital-and-maintenance-projects-in-infrastructure-planning

Keep Records That Tell the Story

Auditors don't just want numbers, they want evidence. Good record-keeping throughout the year is what separates a smooth audit from a painful one. For each asset addition, renewal, or disposal, you should be able to produce:

•       Works completion certificates or project handover documentation

•       Engineer or condition inspection reports

•       Cost data from your financial system

•       Spatial data confirming asset location (GIS)

•       Before-and-after photographs for major renewals

Build a habit of capturing this information at the time of works completion not retrospectively at year end. Many councils now ask project managers (internal and external) to complete a standard asset data collection form as part of the works sign-off process.

Tip: I always produce an End of Year Depreciation Summary Report. This summary report provides details relating to asset cost movements including Asset Values, Depreciation, WDV, Annual Depreciation and Capital Works updates (new / renewal / disposed assets), and where applicable, donated assets as additions to the asset registers. This Summary Report accompanies the End of Year Deprecation financials and often is enough to answer any auditors questions.

5: Communicate Early and Often

• FYE requires cross-department collaboration under time pressure, and I’m sorry to say that this can be a recipe for miscommunication if not managed proactively. I’ve included some communication practices that make a difference:

• Issue a FYE calendar to all departments in February or March, clearly showing data submission deadlines.

• Hold a cross-departmental FYE briefing in April to confirm expectations and answer questions.

• Assign a point of contact in each department to own the data submission process.

• Use a shared tracking tool (see Power BI below) so everyone can see progress in real time.

• Schedule a mid-May checkpoint to identify and resolve issues before the final rush.

Communication is free. Audit findings are not. A 30-minute cross-department meeting in April can prevent weeks of remediation work in June.

6: Harness the Power of Customised Power BI Reports

If there is one investment that pays dividends at every Financial Year End, it is a well-designed, council-specific Power BI reporting suite.

Unlike generic reports generated from your asset management or finance system, a customised Power BI solution connects directly to your corporate data sources, SQL databases, ERP systems, GIS platforms, and works management systems, etc delivering live, decision-ready intelligence without manual exports or stale spreadsheets.

How the connection works

Power BI connects directly to your council's corporate data sources using native connectors, including SQL Server, Oracle, REST APIs, SharePoint, and OData feeds. This means your reports are always drawing from live, authoritative data rather than manually exported spreadsheets.

I have worked with many Councils to develop and build data connections, semantic models, and refresh schedules that enables the Council teams to see their up-to-date information every time they open their Power BI reports, without any manual intervention.

What Power BI Can Do for Your FYE Process

Each of the six example Power BI reports below connects directly to existing corporate systems.

Example 1: Power BI Capital Works Report

Capital Works Power BI Report Tracks WIP expenditure against budget in real time, highlighting projects approaching completion that need to be capitalised before 30 June.
Connects directly to: Power BI pulls live data from your corporate systems no manual exports, no stale spreadsheets.
Data Source / System Type	Common Council Examples	Data Extracted
Finance/ERP System	TechOne, Civica Authority, SAP	Works In Progress (WIP) ledger, capital expenditure transactions, project cost codes, budget allocations
Works Management System	Asset Vision, Conquest, Confirm, Infor	Project status, works orders, completion dates, contractor costs
Project Management Database	MS Project Online, SharePoint Lists	Project milestones, completion percentages, project manager assignments

Example 2: Power BI Asset Register Completeness Report

Power BI Asset Register Completeness Report Identifies gaps in your asset register such as missing condition ratings, unknown acquisition dates, zero-value assets so you can fix them before audit.
Connects directly to: Power BI pulls live data from your corporate systems no manual exports, no stale spreadsheets.
Data Source / System Type	Common Council Examples	Data Extracted
Asset Management System	Asset Vision, Conquest, Assetic, Confirm, TechOne	Asset register, condition ratings, acquisition dates, unit rates, useful lives, asset hierarchy
Finance/ERP System	TechOne, Civica Authority,	Asset valuations, written-down values, depreciation parameters, asset financial data
GIS / Spatial Database	ESRI ArcGIS, MapInfo, GIS SQL databases	Asset locations, spatial attributes, network extents, asset boundaries

Example 3: Depreciation & Valuation Power BI Report

Depreciation & Valuation Report Summarises depreciation charges by asset class, with drill-through capability to individual assets for audit queries.
Connects directly to: Power BI pulls live data from your corporate systems no manual exports, no stale spreadsheets.
Data Source / System Type	Common Council Examples	Data Extracted
Finance/ERP System	Civica Authority, SAP, TechOne,	Depreciation runs, accumulated depreciation, asset written-down values, fair value, residual values
Asset Management System	Asset Vision, Conquest, Confirm, Assetic, TechOne	Asset useful lives, condition-based remaining lives, unit rates, replacement costs, revaluation data e.g. Current replacement cost, fair value assessments, revaluation increments/decrements, depreciation runs, accumulated depreciation, asset written-down values, residual values

https://video.wixstatic.com/video/85e758_fb0337cb78f5409c903db4c837970d65/720p/mp4/file.mp4

Example 4: Maintenance vs. Capital Spend Analysis

Maintenance vs. Capital Spend Analysis Visualises the split between maintenance and capital expenditure, flagging potential misclassifications for Finance review.
Connects directly to: Power BI pulls live data from your corporate systems no manual exports, no stale spreadsheets.
Data Source / System Type	Common Council Examples	Extracted Data
Finance/ERP System	Civica Authority, SAP, TechOne,	General ledger transactions, cost codes, expenditure classifications, purchase orders, invoices
Works Management System	Asset Vision, Conquest, Confirm, Infor, Assetic	Works orders, job types (maintenance vs. capital), crew costs, materials, contractor spend
Procurement System	Vendor portal, Council procurement module	Contract values, purchase order lines, supplier invoices by cost category

https://video.wixstatic.com/video/85e758_c79bb05a12f743a7a2cdc0aec95dfc89/1080p/mp4/file.mp4

Example 5: Condition Profile Report

Condition Profile Report Shows the condition distribution of your asset portfolio, supporting long-term financial planning and renewal forecasting.
Connects directly to: Power BI pulls live data from your corporate systems no manual exports, no stale spreadsheets.
Data Source / System Type	Common Council Examples	Data Extracted
Asset Management System	Asset Vision, Conquest, Assetic, Confirm, TechOne	Condition inspection results, inspection dates, inspector details, next inspection due. Renewal forecasts, condition-based triggers, intervention thresholds, funding scenarios.
Field Inspection / Mobile App Data	Asset Vision, Conquest Mobile, Confirm, Assetic Mobile, Collector for ArcGIS, Fulcrum, Reflect	Field-collected condition observations, photos, GPS coordinates, defect records

Example 6: Year End Checklist Tracker

Year End Checklist Tracker A live progress report showing which departments have submitted their FYE data, and what is still outstanding.
Connects directly to: Power BI pulls live data from your corporate systems no manual exports, no stale spreadsheets.
Data Source / System Type	Common Council Examples	Data Extracted
SharePoint / MS Lists Microsoft Project	Microsoft 365 SharePoint, Teams Lists, Microsoft Project	Department submission status, checklist item completion, due dates, responsible officers
Finance/ERP System	Civica Authority, TechOne	Journal posting status, period-end flags, asset addition/disposal batches lodged
Asset Management System	Asset Vision, Conquest, Assetic, Confirm, TechOne	Data submission timestamps, condition update completeness, asset additions/disposals logged

Use Year End as a Springboard for Improvement

Financial Year End can also offer up improvement opportunities. When it’s all done and dusted, it’s good to step back and ask: how well is our asset management function working?

As you work through the FYE process, take note of:

•       Data gaps that caused delays or required manual workarounds

•       Processes that relied on a single person's knowledge or effort

•       Expenditure that was difficult to classify or verify

•       Assets that could not be located, valued, or substantiated

•       Reporting requests that your current tools couldn't easily answer

Each of these is a signal and an opportunity to improve your data quality, your systems, or your processes before next year's FYE arrives.

The councils that continuously improve their asset data quality are the ones that can answer their auditors' questions in minutes, not days. That confidence comes from year-round discipline and the right tools to support it.

Beyond Year End - Power BI for Year-Round Asset Intelligence

The councils that sail through FYE are the ones that use Power BI throughout the year, not just at year end. When your reports are live and your data is current, year end becomes a validation exercise rather than a data collection exercise.

Every council is different. The most effective Power BI solutions are built around your data structures, your workflows, and your reporting obligations, not a generic template.

Financial Year End does not have to be a stressful scramble.

With the right planning, clear communication, good record-keeping, and the right technology tools in place, your council can close the year with confidence and set a stronger foundation for the year ahead.

I have worked on many different projects with my Local Government clients, from designing and developing Power BI Reports, to building SQL Server databases for spatial data, to managing and maintaining GIS and the Asset Management systems. If you'd like to discuss how we might work together, then please email Jill at ➡️ jill.singleton@iamdata.solutions

If you would like to receive the latest Newsletter Blog straight to your inbox, please subscribe here: ➡️ https://www.iamdata.solutions/subscribe

You can read all our Newsletters and Blogs here:➡️ https://www.iamdata.solutions/blog

You may also be interested in our Projects Page:➡️ https://www.iamdata.solutions/past-projects

Check out what our clients say about us here:➡️ https://www.iamdata.solutions/reviews

If you would like to see a particular topic covered in these newsletters, then please let me know about it. The chances are other people will be interested and would like to hear about it too! Please email me at: ➡️ jill.singleton@iamdata.solutions with your suggestions.  

er BI Report                                      What It Helps You Do