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