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 does each column in the document list show?

Column

What it shows

Records

How many rows Avarni extracted from the document

Completeness

Extracted spend against the invoice total, and the difference

Activity statuses

A ring showing how many rows are Confirmed, Excluded, Flagged, Pending and Unmapped. Hover for the counts.

Document status

Pending, Flagged or Confirmed

Notes

Whether the document has notes. Hover to read them.

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

No invoice total

Avarni found no total on the invoice, so there is nothing to compare against.

Open it and set the total

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 help icon on the difference chip 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 extra. Look for sub-totals and totals read as line items.

How do I correct a wrong invoice total?

The invoice total is the figure after the slash, next to Sum of Spend Extracted. How you change it depends on whether Avarni found a total.

Avarni found no total. The header shows Set invoice total after the slash.

  1. Select Set invoice total.

  2. Type the total from the invoice.

  3. Press Enter.

Avarni found a total, but it is wrong. There is no button or icon. The total itself is the control.

  1. Select the total figure after the slash. When you hover over it, it shows Click to override.

  2. Type the correct total.

  3. Press Enter, or select anywhere else on the page.

To cancel, press Esc.

After you override a total Avarni extracted, Reset to extracted appears next to the chip. Select it to go back to the extracted figure.

The invoice total only drives the completeness check. Changing it does not change any row, and it does not change your emissions.

If you cannot select the total, your role cannot edit documents. Viewers see the figures only.

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. Key in the values by hand, as below. If a vendor's invoices consistently return nothing, upload the consumption with Spreadsheet instead. See Invoices: what Avarni can read.

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, override the total as above, or confirm the document as it is. Either way, write down why.

Use the Document Notes tab.

Finish the document

Before you confirm, check these against the invoice image:

  1. The consumption on each row, and its unit.

  2. The spend on each row.

  3. The billing period: Date and End Date.

  4. The facility each row is assigned to.

If all four are right, set Document status to Confirmed. That records that a person checked it. If you are not sure, set it to Flagged and write what needs a second look in Document Notes.

The document status is separate from the status of each row. Setting a document to Confirmed does not change the status of the rows inside it.

Status

Meaning

Pending

Not reviewed

Flagged

Reviewed, something is unresolved

Confirmed

Reviewed and accepted

Does Avarni detect duplicate invoices?

No. Check for duplicates yourself 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. See Fix data: re-uploading, duplicates and deleting.

Did this answer your question?