Skip to main content

Review the data Avarni extracted from your invoices

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...

Written by Misha Cajic

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

  1. Go to Imported Data.

  2. On the Imports tab, select View on the batch you want.

  3. 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.

  1. Tick the checkbox on each green document.

  2. Use Set status to and choose Confirmed.

  3. 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.

  1. 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.

  2. A filter is hiding it. A supplier filter with no supplier on the records hides everything.

  3. The graph is grouping it away. A graph caps how many items it shows before rolling the rest into an other group.

  4. 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.

Did this answer your question?