When data arrives, Avarni tries to work out which site it belongs to. It does this by comparing identifiers in your data against the identifiers you recorded on each facility.
A row that matches is tagged to that facility. A row that does not match stays untagged until you assign it.
What Avarni matches on
Three things in your data:
Utility Meter Number
Utility Account Number
Location
Map these columns when you upload. If none of them is mapped, no matching happens.
When Avarni reads an invoice, it fills the meter number and account number from the invoice itself. You do not map anything.
How the match is decided
Avarni works through three tiers and stops at the first one that finds a facility.
Tier | Compares | Against |
1 | Utility Meter Number | The NMI and MIRN identifiers on your facilities |
2 | Utility Account Number | The Account number identifiers on your facilities |
3 | Location | The address on your facilities |
A tier 1 match is never overruled by a weaker tier.
The address tier works in two steps. Avarni first looks for a facility whose address is within 300 metres of the location in your data. If none is found, it compares the two addresses as text.
An address match is weaker than an identifier match. Check the rows that matched this way before you rely on them.
When a tier finds more than one facility
Avarni marks the row ambiguous and leaves it untagged. It does not guess.
This usually means two facilities hold the same identifier. Open both and check which one is right for the period.
Which identifiers route data
Only NMI, MIRN and Account number.
Vehicle rego, cost centre and any type you create yourself are stored on the facility and are visible there, but nothing in an upload feeds them. They do not decide where data lands.
Meter numbers and the checksum digit
An NMI or MIRN is 10 or 11 characters. The eleventh is a checksum.
Avarni ignores it. A facility recorded with the 11-character form still matches data that arrives with 10, and the reverse.
Account numbers must be written the same way
An account number is compared exactly, after Avarni trims the spaces at each end and puts it in capitals.
Spaces inside the number are not removed. If your invoice shows the account number in three groups with spaces between them, record it on the facility with those spaces. If your file shows it as one block, record it as one block.
Matching follows your dates
Identifiers are recorded against dates, so a meter that moved from one site to another is handled correctly. Avarni compares each row's date against the period each identifier was valid for.
If a meter moved mid-year and both sites hold it for overlapping periods, the row is ambiguous. Open the old facility and record the change on the date the meter left.
Why a row was not matched to a facility
Work through these in order.
The identifier is not on the facility. Open the facility and add it.
The column was not mapped. Check that Utility Meter Number, Utility Account Number or Location was mapped in the upload.
The identifier is written differently. Compare the value on the facility against the value in your file, character by character.
Two facilities hold the same identifier. Fix the one that is wrong, or record the date the identifier moved.
The site has no identifier and the address did not match. Add the identifier. Do not rely on the address.
Data you already loaded
Adding an identifier to a facility does not reach back to data that is already in Avarni.
To tag existing rows:
Go to Emissions Hub.
Filter to the rows you want.
Select them and choose Bulk Edit.
Set the combined Entity / Facility field.
Add your identifiers before you load a large history, and the matching does the work for you.
Set the facility in your file
If your file has a column naming the site, map it to Facility Name. A named facility overrides whatever the identifiers would have matched.
Use this when your data already carries a site name you trust.
How many facilities to create
A separate meter is a separate site. If a location has two NMIs, create two facilities.
This keeps your consumption, your factors and your floor area lined up with something real, and it means a meter that moves later can be handled without splitting history.
Embedded networks
A site inside an embedded network has no NMI of its own. Use the retailer's account number as the identifier instead, recorded as an Account number.