Forum Discussion

Marsh3216's avatar
Marsh3216
Contributing Cover User
3 years ago
Solved

Freight not on P&L

When I run a Profit and loss statement the freight income is only showing the freight entered as a line item on a sales invoice.  Where do I find the total freight income derived from freight entered at the bottom of the invoice?

  • Hi Marsh3216 , the freight income from that box should be credited to the linked sales account for freight collected.

5 Replies

Replies have been turned off for this discussion
  • Hi Marsh3216 

     

    Thanks for your post. Welcome to the MYOB Community Forum, I hope you find plenty of useful information.

     

    You can follow this steps to to show on freight on the report. 

     

    • Run Sales (item detail) report
    • Click Insert/Modify tab (to have the freight on the report)
    • Click Show/Hide
    • Highlight freight
    • click show
    • Click OK
    • Click on order
    • Highlight freight
    • Click blue arrows on the right side of the box to arrang

     

     

    Let me know if you need further assistance with this. I'm happy to assist. 

     

    If my response has answered your inquiry please click "Accept as Solution" to assist other users find this information.

     

    Best Regards 

    Cel

     

  • Marsh3216's avatar
    Marsh3216
    Contributing Cover User
    3 years ago

    The report gives me each customer and the freight on each sale.  I can only get a total if I convert the report to Excel which is tedious.  I am looking for a total for the freight income for the whole financial year, and, preferably to be shown on the P&L statement.  The only freight on the the P&L is the freight entered as a line item which is then included as part of the customer's sales.

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    3 years ago

    Hi Marsh3216 , the freight income from that box should be credited to the linked sales account for freight collected.

  • Marsh3216's avatar
    Marsh3216
    Contributing Cover User
    3 years ago

    Hi Mike

    In Setup ->linked accounts -> I charge freight on sales has been selected and linked to Freight Out income account.

    The P&L is only picking up freight entered as a line item, not in the entry in the totals area.

     

    Thanks

     

  • Marsh3216's avatar
    Marsh3216
    Contributing Cover User
    3 years ago

    Hi again Mike

    I can see now that we have 2 different freight income accounts, one as a cost of sales and the other as freight income.  So I will change the linked account so that they are both the same.

    Thank you!