Australian Multi-Site Utility Bill PDF to Excel

To convert Australian multi-site utility bill PDFs to Excel, extract one row per site and billing period, using NMI for electricity, MIRN for gas, and the water authority's property reference for water. Keep supply charge, usage charge, peak / off-peak / shoulder kWh, demand, controlled load, GST, retailer or authority name, and billing period in separate columns so the spreadsheet supports cost reporting, tenant recharge, BAS work, and Scope 2 inputs.

The Australian multi-site utility bill PDF to Excel workflow rests on three structural facts. First, every electricity bill in Australia carries a National Metering Identifier (NMI) tied to the connection point, not the retailer — so when a site moves from AGL to Origin, the NMI stays the same and remains the per-site join key across the portfolio. Second, every gas bill carries a Meter Installation Reference Number (MIRN) that does the same job for gas. Third, water bills carry a property reference number issued by the water authority, which plays the same role for water. These three identifiers are how a portfolio's bills consolidate cleanly across providers, periods, and historic retailer switches.

The destination is a single per-site, per-period row with the bill's tariff structure broken out into columns the spreadsheet actually needs: supply charge separated from usage charge, peak / off-peak / shoulder kWh on their own columns where time-of-use applies, demand kVA as a separate column for medium-business sites, controlled-load kWh for separately metered loads like off-peak hot water, GST on its own line, and the retailer or authority name retained so cross-vendor comparison is direct. One row per site per billing period, ready for a pivot on site code, year-on-year comparison, tenant recharge calculation, or kWh-to-tCO2-e conversion for Scope 2 reporting.

This article is the Australian regional companion to the generic utility bill PDF to Excel workflow — the multi-provider AU reality with vendor and tariff specifics that a one-size-fits-all approach cannot carry. The Big 5 retailers each lay their bills out differently, the metro water utilities sit invisibly in most utility-bill writing despite being a monthly reality for property managers, and the AU tariff vocabulary (demand tariff, controlled load, regulated versus market offer, embedded networks) is what the spreadsheet columns are built from.

---

The Big 5 Retailers and What Their Bills Look Like for Extraction

AGL, Origin Energy, and EnergyAustralia are the Big 3 retailers a portfolio will encounter most often, with Red Energy (Snowy Hydro-owned) and Alinta Energy completing the practical Big 5 for commercial bills. Most portfolios carry several retailer layouts at once, so the extraction should be field-led rather than template-led.

AGL usually prints the NMI in the account summary block near the supply address and tariff plan. Time-of-use bills split peak / off-peak / shoulder usage in a usage table, while medium-business sites show demand kVA or kW as a separate line. AGL's NEM 12 portal export is useful for usage analytics, but the bill is still the source for supply charge, GST, tariff name, and dollar totals.

Origin Energy often places the NMI in the supply details panel rather than the header. Supply charge, usage charge, and controlled-load lines are usually cleanly separated, so the field list is the same as AGL's even though the layout positions move.

EnergyAustralia puts the NMI alongside the supply address and states time-of-use windows on the bill. Multi-site business arrangements may share a cover account, but each connection point still has its own NMI; the output row count should follow the connection points, not the account number.

Red Energy bills in NSW and Victoria tend to be extraction-friendly: NMI near the connection address, usage charges itemised by period, and supply charge on its own line. Alinta Energy appears most often in WA and SA gas, where the MIRN plays the NMI role; its eastern-state electricity bills use the same field list with a different layout.

Gas bills follow the same structure with three substitutions: MIRN replaces NMI, consumption is in megajoules rather than kWh, and meter read dates plus daily standing charge sit where electricity's supply charge sits. A fixed-template tool would need one layout per retailer and fuel. A field-led prompt names the data instead — NMI or MIRN, supply address, billing period, supply charge, usage quantity, peak kWh, demand kVA, GST — and lets the AI map each bill into the same row shape.

---

The Water Utility Layer: State-by-State, Property Reference as the Per-Site Key

Water in Australia is not deregulated. There is no choice of retailer, and a property manager does not switch water providers the way they might switch from EnergyAustralia to Red Energy. Each region has a single water authority, and the bill for any given supply address comes from whichever authority covers that postcode. The corollary for extraction: the water layer of a portfolio's monthly bills is multi-authority by virtue of geographic spread, not multi-retailer by virtue of choice — but the consolidation problem is the same shape.

The metro and state authorities a multi-site portfolio actually encounters:

• NSW metro: Sydney Water for greater Sydney, the Illawarra, and the Blue Mountains; Hunter Water for Newcastle and the Lower Hunter.
• VIC metro: Yarra Valley Water for north and east Melbourne; South East Water for the south-east; Greater Western Water (formed from the merger of City West Water and Western Water) for the north and west.
• QLD metro: Urban Utilities for Brisbane and surrounds; Unitywater for the Sunshine Coast, Moreton Bay, and Noosa.
• SA: SA Water statewide.
• WA: Water Corporation statewide.
• TAS: TasWater statewide.
• NT: Power and Water Corporation.
• ACT: Icon Water.

The per-site join key on a water bill is the property reference number — each authority calls it slightly differently (property number, account number, supply address ID), but the function is identical to the role the NMI plays for electricity and the MIRN plays for gas. It is stable across billing periods, tied to the supply address rather than the customer, and printed on every bill. For a portfolio covering both Sydney Water and Yarra Valley Water bills, use each authority's property reference as the per-site key and let the vendor-type column distinguish the authority.

A commercial water bill carries components that have to land as separate columns rather than a single bill total. Water usage charge is per kilolitre (kL) and is sometimes tiered, with a higher rate above a threshold of consumption. The water service charge is the fixed daily or quarterly component covering the supply itself. Sewerage and wastewater service charges sit on their own lines, with the sewerage usage component sometimes calculated as a percentage of water usage rather than directly metered. Trade waste charges apply to commercial sites that discharge waste exceeding domestic-equivalent standards (food service, manufacturing, healthcare) and need preserving as their own line. Drainage charges appear on bills covering certain stormwater catchments. GST on water bills is line-by-line: water for residential use is GST-free in many cases, while commercial sites typically have GST applied on specific components rather than the bill total. Extraction has to preserve the line-level GST flag rather than collapse to a single total, or the GST column on the unified row will be wrong for water.

Water authorities issue bills quarterly more often than monthly, which is the structural difference that matters most for the unified spreadsheet. A site that has monthly electricity bills, monthly gas bills, and quarterly water bills lands four water rows per year against twelve electricity rows, and the period boundaries for water do not align with calendar months. The per-site, per-period row carries explicit billing-period-start and billing-period-end columns rather than assuming a calendar month, so cross-vendor analysis aligns by date range rather than by month name. A pivot on quarter, not on month, is the right view for any cross-utility comparison that includes water.

---

NMI, MIRN, and Supply Address: The Join Keys That Survive Multi-Provider Reality

The reason address strings fail as a join key across a multi-provider portfolio is that retailers store the same physical site differently. "Suite 4, 12 Smith Street" on the AGL bill becomes "12 Smith St, Suite 4" on Origin and "12 Smith Street Unit 4" on EnergyAustralia. A spreadsheet joined on address produces three rows where there should be one, and any cross-period comparison falls apart when the same site switches retailer mid-year. The per-site join key has to be something the retailer cannot change.

For electricity, that key is the NMI. According to the AEMO MSATS National Metering Identifier procedure v7.3, an NMI is generally an all-numeric ten-character identifier and is the unique identifier for each connection point. It is tied to the connection point, not the retail account — a site that switches from AGL to Origin keeps the same NMI on every bill before and after the switch, which is exactly the property a portfolio's join key needs. It is unique per electricity supply point, printed on every electricity bill in Australia regardless of retailer, and not subject to reassignment the way a customer number or phone-style account ID might be. A property manager whose 12 sites move between retailers across a five-year horizon ends up with 12 stable NMIs, even as the retailer column on the spreadsheet churns.

For gas, the parallel key is the MIRN — a per-site identifier issued by the gas distributor rather than the retailer, printed on every gas bill, stable across retailer switches in the same way the NMI is. Gas distribution in Australia is regional: Australian Gas Networks (AGN) covers parts of SA, VIC, the NT, and Queensland; Jemena Gas covers parts of NSW; AusNet Services and Multinet cover parts of VIC; ATCO Gas covers WA. The MIRN format is set by the distributor and is shorter than an NMI, but it functions identically as the join key. A portfolio with electricity NMIs and gas MIRNs maintains both as separate columns on the unified row, with a vendor-type column flagging which one the row applies to.

Supply address still belongs in the spreadsheet, but as a human-readable column rather than the join. The pattern that holds up: store the join key (NMI, MIRN, or property reference) as one column, and store a normalised supply address — one canonical form decided once for the portfolio, applied consistently regardless of which retailer's string the bill carries — as a separate column. Cross-period and cross-retailer joins run on the join key; the address column exists for the human reading the spreadsheet and for any external system that has not adopted the join key yet.

This is the spine of a portfolio's NMI-keyed electricity spreadsheet, and the spine of utility bill extraction across an Australian property manager's full site list more broadly. A single prompt-driven extraction pass over the portfolio's mixed-vendor PDFs produces the unified per-site row, with the join keys naming each row and the tariff fields broken out per the spreadsheet shape. AI utility bill extraction for Australian portfolios is the same one-job pipeline applied at portfolio scale: upload the month's bill PDFs as one batch, prompt the AI for the field list the spreadsheet needs, download the structured output. The product handles up to 6,000 files per batch and individual PDFs up to 5,000 pages, which matters when a quarter-end bill set is large or when a single retailer aggregates many sites onto one multi-page PDF. A goal-oriented prompt — "I'm extracting monthly utility charges across our sites for cost reporting, one row per site per billing period, with NMI as the join key, supply charge separated from usage charge, peak / off-peak / shoulder kWh broken out, demand kVA where present, controlled-load kWh where present, and GST on its own line" — runs across whichever retailer's layout the bill arrives in, and the AI maps the fields to the same row shape on every output.

---

Reading the AU Tariff Lines: What Each Component Means in Your Spreadsheet

The components on an AU commercial bill follow the vocabulary the AER and the retailers' own bill explainers use, and the unified row carries each component as its own column rather than a single bill total. Practitioners who have read enough bills will recognise most of this; setting it out in one place gives the prompt that drives the extraction a complete field list to work from.

Supply charge (fixed daily charge). Charged per day regardless of consumption, covering the network's standing service to the connection point. The bill multiplies the daily rate by the number of days in the billing period and shows the result as a discrete line. On the unified row, supply charge sits in its own column. Collapsing it into the usage charge breaks any cost-per-site analysis that wants to separate fixed cost from variable, and it breaks tenant recharge calculations where pass-through pricing only applies to one of them.

Usage charge (consumption charge). Per kWh on electricity, per MJ on gas, per kL on water. Where the tariff is flat, this lands as a single usage-total column. Where time-of-use applies, it splits across columns by period.

Peak / off-peak / shoulder. Time-of-use tariffs name three windows, with the time bands and rates differing by retailer and by network. The bill always names them — peak hours might be 2pm to 8pm on weekdays in one region, 7am to 11pm in another, with shoulder around the edges and off-peak overnight and weekend. The unified row carries three usage columns (peak kWh, off-peak kWh, shoulder kWh) and three rate columns where rates need preserving. Rate preservation matters most for tenant recharge, where the recharge agreement may pass peak rates through directly rather than averaging.

Demand tariff. Common on medium-business sites, typically those above approximately 100 MWh per year, though the threshold varies by network and retailer. The charge applies to the maximum demand reached during peak windows, measured in kVA or kW, multiplied by a per-kVA-per-month or per-kVA-per-day rate depending on the network. The demand line sits separately from the usage lines on the bill, and on the unified row it gets a demand column distinct from the usage columns. A site that crosses the demand threshold from one quarter to the next looks the same in usage terms but lands a new column value, which is a useful signal for procurement consultants reviewing tariff fit.

Controlled-load tariff. A separately metered load — most often off-peak hot water, slab heating, or pool pumps — billed at a different (usually lower) rate than the main meter. It lands on its own kWh column with its own rate, distinct from the main meter's usage. Sites with controlled-load arrangements typically have their NMI extended with a sub-identifier on the bill, but the join key for the spreadsheet stays the parent NMI.

Regulated offer versus market offer. In the deregulated states (NSW, VIC, QLD, SA), most commercial sites are on market offers — negotiated plans with rates outside the regulated cap. The Default Market Offer (DMO) is the regulated cap on standing offers in NSW, SA, and SE QLD; the Victorian Default Offer (VDO) is the equivalent in Victoria. The bill names which offer type applies, and on the unified row it sits as a metadata column. For an energy procurement consultant comparing portfolios this matters; for a bookkeeper running cost reporting it sits quietly until tariff renegotiation time.

GST line. GST is shown as a discrete line on the bill total, applied at 10% to taxable components. The unified row carries GST as its own column. The connection to BAS is direct: every utility bill flows GST into the activity statement, and a per-site, per-period row with GST broken out is exactly what a bookkeeper needs for preparing BAS in Xero for GST on utility expenses without further reshaping. Water bills handle GST line by line — usage and service charges may be GST-free or GST-applicable depending on the customer type, and the extraction has to preserve the line-level treatment rather than apply GST to the bill total only. A water row whose GST is calculated as 10% of the total when half the lines were GST-free overstates the input tax credit.

Embedded networks. Where a landlord, building owner, or shopping centre operator buys energy in bulk from a retailer and on-sells to occupants, the bill an embedded-network customer receives looks different from a retailer bill. Tariff labels resemble the retailer bill, but the supplier name is the embedded-network operator (often through a third-party billing service), and the tariff structure may not map exactly to a retailer plan because it reflects the on-sell margin and the metering arrangement. The extraction prompt handles embedded-network bills as a separate vendor type column value, with the same supply-charge / usage-charge / GST shape applied where the line items support it.

The extraction implication of all of this is that the prompt names every one of these fields explicitly. The prompt is the contract between the bill and the spreadsheet — supply charge, usage charge total, peak kWh, off-peak kWh, shoulder kWh, demand kVA, controlled-load kWh, GST line, plan name, retailer name. The AI finds each field in whichever retailer's layout the bill arrives in, and the unified row carries each component as a distinct column rather than a single total. That is what separates accounting-grade extraction — the kind that reconciles to the bank, flows GST cleanly, and supports tenant recharge — from the usage analytics a meter-data download provides.

---

NEM 12 Versus the Bill: When Each One Is the Right Answer

Anyone who has worked with an energy procurement consultant or used an AGL business portal will have heard the suggestion: "just download NEM 12". NEM 12 is the Australian Energy Market Operator's standard CSV format for interval meter data, typically thirty-minute reads for a single NMI. It carries usage in kWh per interval, the NMI, the meter identifier, and read quality flags.

That makes NEM 12 the right input for load-shape analysis, tariff modelling, and demand optimisation. It is not the right input for accounting, cost-per-site reporting, tenant recharge, or BAS preparation because it does not carry supply charge, demand charge, controlled-load rate, GST, network charges, bill totals, retailer name, plan name, or billing period in the accounting sense.

Most bookkeepers and property managers also cannot rely on NEM 12 for the whole portfolio. Even where download is available, it is generally electricity-only and tied to portal access, while gas and water still arrive as bills. A portfolio that needs both cost reporting and load-shape analysis may run bill extraction and NEM 12 in parallel, but they are complementary inputs, not substitutes.

---

The Unified Per-Site Row, in Two Variants

Every bill, regardless of retailer, vendor type (electricity, gas, water), or layout, lands in the same row shape so cross-vendor and cross-period analysis is direct rather than requiring per-vendor pivots. The two variants below cover the two jobs a portfolio is most often doing — analytical cost reporting and tenant cost allocation — and most portfolios maintain the analytical row as the master and derive the recharge view from it rather than running two separate extractions.

Cost-per-site analytical column shape. The full column list, each on its own line in the spreadsheet:

• Site code (internal identifier)
• Supply address (normalised)
• NMI / MIRN / property reference (the join key)
• Vendor type (electricity, gas, water)
• Retailer or authority name
• Plan or tariff name
• Billing period start
• Billing period end
• Days
• Supply charge
• Usage charge total
• Peak kWh
• Off-peak kWh
• Shoulder kWh
• Demand kVA
• Controlled-load kWh
• Network charges (where itemised separately)
• GST
• Total inc GST

A pivot on site code with billing period as the column dimension produces a cross-site, cross-period view directly. A pivot on vendor type compares electricity, gas, and water usage at the portfolio level. A pivot on retailer surfaces concentration risk, retailer-specific rate drift, and renegotiation candidates. The shape supports each of those without further reshaping.

Tenant recharge column shape. Tenant utility cost allocation Australia covers a spectrum — from full pass-through, where the entire bill flows to one tenant, to sub-metered arrangements where only the tenant's metered share applies, to percentage-allocated layouts where common-area costs are split by lettable area. The recharge view carries pass-through components broken out at the level the recharge agreement specifies:

• Site code
• Supply address
• NMI / MIRN / property reference
• Tenant code (recharge target)
• Recharge basis (full pass-through, sub-metered, percentage allocation)
• Billing period start
• Billing period end
• Days in period
• Supply charge (pass-through portion)
• Peak kWh and rate (where pass-through pricing applies)
• Off-peak kWh and rate
• Shoulder kWh and rate
• Demand kVA and rate
• Controlled-load kWh and rate
• GST on recharge components
• Total recharge amount

Where the recharge basis is full pass-through, the supply charge and usage charge components flow directly from the analytical row. Where it is sub-metered, the per-tenant kWh comes from the sub-meter reading and the rate columns supply the pricing applied. Where it is percentage-allocated, the unified row's supply and usage components multiply through an allocation percentage to land per-tenant amounts. Holding the rate columns alongside the kWh columns means the recharge calculation runs from the row itself rather than requiring a separate rates table.

The two variants are not exclusive — a portfolio that does both cost reporting and tenant recharge maintains the analytical row as the master, and the recharge view is a derived projection of it. Address normalisation belongs in either layout: the supply address column carries the canonical form (decided once for the portfolio — for example, unit-then-street with no abbreviations), and the join key column carries NMI, MIRN, or property reference so cross-period and cross-retailer joins remain reliable when the retailer's address string drifts.

The prompt names every column on the list, the AI extracts each field from whichever vendor's PDF arrives, and the output is the unified row in either of the two shapes.

---

From Extraction to Outputs: Cost Reporting, Tenant Recharge, and ESG Disclosure

The unified per-site row exists to feed downstream jobs, and the value of holding the row in the shape just specified is that those jobs become near-mechanical rather than a quarterly reshaping exercise.

Cost-per-site and cost-per-period reporting. The analytical row is already in the shape a portfolio review or board report wants. A pivot on site code with billing period as the column dimension produces the cross-site, cross-period view directly. Year-on-year comparison runs as a second pivot — same period last year against current period, with variance flagged where the difference exceeds a threshold. Procurement consultants use the same data to identify sites where tariff renegotiation would pay off: sites where demand kVA has crept up over the year and a demand-tariff renegotiation might be due, sites where peak / off-peak / shoulder usage has shifted such that a different time-of-use plan would be cheaper, sites where supply charge has drifted relative to usage and a flat-rate plan might fit better.

Tenant recharge. For commercial property and franchise networks, the recharge view feeds the tenant invoicing workflow each cycle. Where the recharge basis is full pass-through, the supply charge and usage charge components flow directly from the unified row to the tenant invoice. Where the basis is sub-metered, the per-tenant kWh from the sub-meter combines with the rate columns on the unified row to produce the tenant's amount. Where the basis is percentage-allocated, the unified row's per-site components multiply through the allocation percentage. The recharge calculation runs from the row, the GST treatment carries through correctly because GST sat as its own column, and the tenant invoice ties back to the source bill via the join key column.

Scope 2 emissions reporting. The kWh data on the unified row — peak, off-peak, and shoulder kWh combined into total kWh per site per period — is the input for Scope 2 emissions calculation under the GHG Protocol's location-based and market-based methods. The Australian Government's National Greenhouse Accounts Factors 2025 provide the emission factors and methods used to estimate greenhouse gas emissions, with the factors revised annually. SMBs facing supply-chain disclosure pressure from larger customers — the kind that increasingly require Scope 2 numbers from suppliers as a condition of contract — find the per-site, per-period kWh column is already the right shape for the Scope 2 input. The methodology choice (location-based versus market-based, which factor set to apply, whether to include Scope 2 alongside Scope 1) is a separate subject; the data shape this article produces is the input. UK portfolios operate under a parallel regime — the ESOS Phase 4 evidence pack, due 5 December 2027, is built from twelve months of supplier energy invoices keyed by MPAN/MPRN rather than NMI, and the UK approach to compiling kWh totals and intensity ratios from energy invoices follows the same per-site, per-period row shape with a jurisdiction-specific join key swap.

Where vendor portals already produce structured exports — NEM 12 from AGL, account-summary CSVs from various retailers, online-portal usage histories where they exist — the answer is to use those exports and skip the extraction step. The extraction workflow is the path when those exports do not suit the job at hand: multi-vendor portfolios where retailers differ across sites and there is no single export that covers them all, bill-level data rather than meter-data-level (which excludes NEM 12 and similar usage exports), and the only-PDF-by-email reality for the many bookkeepers and property managers servicing portfolio clients without portal access. The workflow answers that reality. It is not a replacement for vendor exports where they exist and fit.