How to Run the Finance Trading Report
The Finance Trading Report contains a full list of client and carrier Invoice data allowing for a full breakdown of true profit margin information. The report will run data for all companies in your company tree.
How to generate the Finance Trading Report
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
Note: This can be a maximum period of one calendar year
3. Select Get Trading Report
4. The report will be run and will appear in the bottom left-hand corner of the screen:
How to read the Finance Trading Report
The Finance Trading Report will contain three tabs which are broken down as:
All: This will be a breakdown of data split by invoice, client, carrier account and carrier invoice
Grouped By Client: This will be a breakdown of data split by client
Grouped By Month: This will be a breakdown of client split by month
Contents of the tab ALL
Invoice Id- 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
Carrier Invoice Date - Date of the carrier invoice
Carrier Invoice Id - Carrier Invoice number
Total Cost Ex - A summed total of the cost amounts exclusive of tax that was linked to that client on that carrier invoice
Total Cost Inc- A summed total of the cost amounts inclusive of tax that was linked to that client on that carrier invoice
Total Invoiced Ex -A summed total of the sell amounts exclusive of tax that was linked to that client on that carrier invoice
Total Invoiced Inc -A summed total of the sell amounts inclusive of tax that was linked to that client on that carrier invoice
Margin Ex - The profit margin generated on the Ex tax figures
Margin Inc -The profit margin generated on the inclusive of tax figures
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
Contents of the tab Grouped By Client
Client Name - This will be the company name
Client Account Code - This will be the company account code
Total Cost Ex - A summed total of the cost amounts exclusive of tax that was linked to that client on that carrier invoice
Total Cost Inc- A summed total of the cost amounts exclusive of tax that was linked to that client on that carrier invoice
Total Invoiced Ex -A summed total of the sell amounts inclusive of tax that was linked to that client on that carrier invoice
Total Invoiced Inc -A summed total of the sell amounts inclusive of tax that was linked to that client on that carrier invoice
Margin Ex - The profit margin generated on the Ex tax figures
Margin Inc -The profit margin generated on the inclusive of tax figures
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
Contents of the tab Grouped By Month
Month And Year - This will be the month and year for the invoiced consignments in that data set.
Client Name - This will be the company name
Client Account Code - This will be the company account code
Total Cost Ex - A summed total of the cost amounts exclusive of tax that was linked to that client on that carrier invoice
Total Cost Inc- A summed total of the cost amounts inclusive of tax that was linked to that client on that carrier invoice
Total Invoiced Ex -A summed total of the sell amounts exclusive of tax that was linked to that client on that carrier invoice
Total Invoiced Inc -A summed total of the sell amounts inclusive of tax that was linked to that client on that carrier invoice
Margin Ex - The profit margin generated on the Ex tax figures
Margin Inc -The profit margin generated on the inclusive of tax figures
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
Related Articles
How to run the Invoice Item Breakdown Report
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 ...How to Generate Invoices and Add Manual Charge on the Invoice
The MachShip system provides users with an efficient way for freight re-sellers too generate multiple invoices for the transport they have managed for their clients. How to Generate Invoices Click on the Finance drop-down and select Generate ...How to Invoice out Billing Charges
Billing Charges are the mechanism by which non-consignment related costs can be accounted for and charged on a client invoice. These Billing Charges will include: · Dangerous Goods Consignment fees · Reciever Pays Consignment fees · SMS consignment ...How to Resend, Regenerate, Re-Open and Download Invoice File from a Posted Invoice
Financial invoices generated and posted out of MachShip will be accompanied by either a data file in csv format or a PDF copy of the invoice or both. If you require a copy of these files from the system, they can be downloaded by following the below. ...How to Post Invoices
Navigate to Open Invoices Click on the Finance drop-down and select Open Invoices. Editing an Open Invoice From this screen, you can edit the Invoice and Due Dates, if you are unsure what consignments are in these invoices you can click on the Cog to ...