Invoice Line Items Report

Modified on Fri, 22 Aug at 11:27 AM

Introduction

The Invoice Line Items Export Report provides a detailed breakdown of all invoice components within AgriChain.
It is primarily used for accounting, reconciliation, and reporting purposes, particularly when uploading invoice data into external accounting systems.

This report captures each invoice line item separately (e.g., Freight, Title Transfer, Blending Fee, EPR, Grain Levy, Carry, Custom Line Items) ensuring that all costs and levies associated with commodity movements are itemized clearly.


Where to Access

The Commodity Contract Invoice Report is available in the following module:

  • Invoice

Steps to Download

From the Invoice Module:

  1. Navigate to the Invoice section using the sidebar.

  2. Click the CSV icon in the top-right corner of the screen.

  3. Select Download Commodity Contract Invoice Report from the dropdown.

  4. Select checkbox for custom csv download (Custom header columns).

  5. Apply the necessary filters:

    • Invoice Type: Commodity Contract

    • **Invoice Line Item Type: Freight Movement/ Title Transfer, Blending Fee, Application, EPR, Grain Levy, Carry, Custom (Select any one)

    • Invoice Creation Date Range: Define the start and end dates for the receival period.

    • Payer: The entity responsible for paying the invoice.

    • Payee: The entity issuing and receiving payment for the invoice.

    • Status: Overpaid / Paid, Action Pending/ Awaiting Confirmation, Payment Pending Confirmation/ Awaiting Payment Confirmation, Pending Payment/ Awaiting payment, Rejected, Void.

  6. Click on "Download".



**Invoice Line Item Type (Screenshot) 



Invoice Type and Invoice Item type is mandatory to select. If no filter option is selected, the report will include all available data.

The report will only generate filtered results if you apply a filter.

If the "Include planned (i.e., unconfirmed) invoices" box is unchecked, invoices linked to movements but not yet generated will be excluded.

If the box is checked, those planned/unconfirmed invoices will also be included in the report.


Included Fields

HeaderFreight / Title TransferBlending FeeApplicationEPRGrain LevyCarryCustom
Invoice No / Type / Status / Dates
Seller & Buyer Details (ABN, NGR, Address, Bank, etc.)
Commodity / Grade / Variety / Season / Sustainable
Invoiced Quantity
Price Point
Contract Price / Adjustments (LD, Spread, Oil, Admixture, Shrinkage, Receival Fees)
Blending Fee Rate (per MT)
Total Blending Fee (ex / inc GST)
Carry Rate (per MT per period)
Carry Period / No. of Periods
Total Carry (ex / inc GST)
EPR Rate
Total EPR (ex / inc GST)
Royalty Manager / EPR Deducted
Grain Levy Rate (per MT)
Total Grain Levy (ex / inc GST)
Transfer Method / TT Sub Type
Transferred Load Type / Identifier
Pickup / Delivery (Date, Company, Site, Docket No)
SP1–SP6 (Custom Parameters)
GST / Currency / Total (ex / inc GST)


For both EPR and Grain Levy report, a 'Summary' checkbox option is available. If you want the summary included in the report, simply check the box; if not required, you can leave it unchecked.



Only Company Admin and Office admin can download the Contract Invoice Report from Web view. 


FAQs


What should I do if the report only shows headers and no data? 


This might be due to no invoices being created within the selected date filter.


What dates are used for filtering in the report?


The filter was previously based on the invoice creation date, but it will be updated to use the Invoice Item Date.


Related Articles

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article