When Avarni reads an invoice it pulls out two things: the line items, and the invoice total. It then adds up the spend on the line items and compares that sum against the total.
Your emissions are calculated from consumption, not from spend. The spend comparison is a check. If the line-item spend adds up to the invoice total, Avarni captured every line, which means it captured every line that carries consumption.
That comparison is the Completeness column, and it is the only thing you need to read to know which documents to open.
Where to start
Go to Imported Data.
On the Imports tab, select View on the batch you want.
You now have a list of documents, one per invoice.
What the Completeness column tells you
Each document shows the extracted spend against the invoice's current charges, and a chip with the difference.
Chip | Meaning | Do |
Green, 5% or less | Everything material was captured. The gap is late fees or network charges, which carry no consumption. | Confirm it |
GST basis | The line items are GST-exclusive and the invoice total is not. | Confirm it |
Amber, 5% to 10% | Worth a look, usually minor. | Open it |
Red, over 10% | Something was missed or something extra was picked up. | Open it |
Avarni compares against current charges, which is the amount due less any balance brought forward. A balance carried over from last month does not count against you.
Confirm the clean documents first
Do not open them one by one.
Tick the checkbox on each green document.
Use Set status to and choose Confirmed.
Select Apply.
You can update 500 documents at a time.
When several documents show the same difference
If a run of documents all show the same percentage, that is one fault repeated, not many faults. Fix it once across the batch instead of opening each document.
Select View in emissions hub from the document list. You now have every extracted row across every document in the batch, and you can filter and act on all of them together.
Read the working before you change anything
Open a document. The header shows Sum of Spend Extracted, with the extracted figure against the target.
Hover the difference to see the working: line items extracted, amount due, balance brought forward, current charges.
Underneath it, Avarni tells you which way to look:
Short means the extraction missed something. Look for line items, credits, payments or tax.
Over means the extraction picked up something twice. Look for sub-totals and totals read as line items.
The extraction picked up too much
The usual culprits, all of which look like a line item but are not:
the invoice total
the account balance, or balance brought forward plus new charges
a previous balance
an average daily usage figure printed for the customer's interest
Select the row in the Activities list and select Delete. You can also select a highlighted region on the invoice image to jump to the row it produced.
To fix it across a batch: select View in emissions hub, open Filters, go to Description, select the description that is being duplicated, and apply. Select the rows and use the bulk delete button in the table footer. You will be asked to type DELETE.
The extraction missed a line
Select a row of the same kind, select Clone, then edit the copy to match the line that was missed.
If there is nothing to clone, select Add activity and fill it in.
Charges that are not consumption
Supply and connection charges arrive as line items, usually described as other charges and priced per day. They are real spend, so they belong in the completeness check, but they carry no consumption.
Depending on how Avarni read a charge, the charge can get a unit and an emission factor, and then it adds emissions. Exclude them instead of deleting them, so the completeness check still reconciles.
Use the Exclude button on the status bar at the foot of the activity.
To exclude them across a batch: in the Emissions Hub, use the group button and group by Activity Class, then exclude the whole group in one action.
Nothing was extracted at all
There are two reasons, and they need opposite responses.
The document is not a utility invoice. If your invoices arrive through an integration, everything in the account comes through, not only the ones that matter. Delete the document.
The layout was not recognised. If a vendor's invoices consistently return nothing, that is ours to fix. Tell us. Do not key in a batch by hand.
For one or two awkward invoices, key them in.
Key in a line by hand
Select the activity, then complete:
Activity Class
Activity Amount, the consumption figure
Input Unit
Spend Amount
Currency
Date and End Date, the billing period
Check the period against the invoice. The dates Avarni prefills are not always the period the invoice covers.
Select Save. You do not need to complete any other field.
Why a line is missing from a graph
Four causes, and none of them is a failed extraction. Check them before you report a problem.
The line was dated into the wrong month. Open the document and check the dates on every activity. A line dated into the wrong period disappears from the month you expected and appears in another.
A filter is hiding it. A supplier filter with no supplier on the records hides everything.
The graph is grouping it away. A graph caps how many items it shows before rolling the rest into an other group.
The status is still Pending. Pending is the normal state before review. It is not an error.
Two invoices in one month is not double counting
When a billing period straddles a month, Avarni prorates. Two invoices covering parts of August produce two rows, and each contributes only its share of August. The graph shows the prorated figure, not the sum.
The invoice itself is wrong
Retailer bills sometimes do not add up. If the line items are right and the printed total is wrong, confirm the document as it is and write down why.
Use the Document Notes tab.
Finish the document
Set Document status to Confirmed. That records that a person checked it.
Status | Meaning |
Pending | Not reviewed |
Flagged | Reviewed, something is unresolved |
Confirmed | Reviewed and accepted |
What to tell us rather than fix yourself
A vendor whose invoices consistently extract nothing.
Duplicate invoices. Avarni does not detect them yet. Ask us to run a duplicate check once you have finished uploading, rather than during. The same invoice can arrive under two file names, so the invoice number is what identifies it, not the file name.
