The Invoice Items Breakdown Report contains a full list of client and carrier Invoice data allowing for a consignment level breakdown of true profit margin information.

Note that this report will show every line on the invoice so it will show multiple lines when a reconciliation charge has occurred. 

How to generate the Invoice Item Breakdown

1. Click the Reports drop-down, and select Finance Trading Report.

2. Select a date period - The report will be generated for all invoices which have an invoice date within the selected time period

4. Set Invoice Item Breakdown to Yes:

4. Enter in the Company that you wish to run the invoice detail. If you want to run for a whole organisation or company tree then select the Parent Company and the option Include Children

5. Select Get Trading Report

6. The report will be run and will appear in the bottom left-hand corner of the screen:

How to read the Invoice Item Breakdown Report

The Invoice Item Breakdown Report will contain one tab which is broken down as the below:

Client Invoice Number - This will be the client Invoice Number in MachShip

Invoice Date - This will be the invoice date set in the platform

Client Name - This will be the company name 

Client Account Code - This will be the company account code

Carrier Name - The name of the carrier that the carrier invoice is linked to

Carrier Account Code - The account code the consignments were booked on

Created Date - Date that the consignment was created in MachShip

Consignment Number - The MachShip internal reference of the consignment

Carrier Consignment Reference - The carrier reference or Consignment Number

From Name - Sending location name of the consignment

From Suburb - Sending suburb of the consignment

From Postcode - Sending postcode of the consignment

To Name - Delivery location name of the consignment

To Suburb - Delivery suburb of the consignment

To Postcode - Delivery postcode of the consignment

Total Volume - Total Volume of the consignment

Total Weight - Total Weight of the consignment

Total Qty - Total number of Items on the consignment

Cost Base Price - cost price of the route and (non fuel) surcharges for the invoice line

Cost Fuel Price - cost of the fuel component for the invoice line

Cost Tax - cost of the tax component for the invoice line

Cost Ex Tax - total of the cost amounts exclusive of tax for the invoice line. 

Cost Total- total of the cost amounts inclusive of tax for the invoice line

Sell Base Price - invoiced sell amount for the route and (non fuel) surcharge for the invoice line

Sell Fuel Price - invoiced sell amount of the fuel componet for the invoice line

Sell Tax - invoiced sell amount of the tax component for the invoice line. 

Sell Ex Tax - total of the sell amounts exclusive of tax that for the invoice line

Sell Total - total of the sell amounts inclusive of tax for that invoice line

Margin Ex - The profit margin generated on the Ex tax figures for that invoice line

Margin Inc -The profit margin generated on the inclusive of tax figures for that invoice line

Sales Portfolio - This is the sales portfolio that has been set on the Company page

Account Management Portfolio - This is the Account Management portfolio that has been set on the Company page

Referral Portfolio - This is the Referral portfolio that has been set on the Company page

Trading Start Date - This is the start date that is set on the company page

Company Tier Name - This will be the Tier name assigned to the company. 

Company Tier Abbreviation - This will be the company tier abbreviation