Freight not on P&L

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Marsh3216
4 Posts
Cover User
Australia
Cover User

4Posts

0Kudos

0Solutions

Solved: Go to Solution

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?

5 REPLIES 5
Celia_B
MYOB Moderator
2,108 Posts
MYOB Moderator
MYOB Moderator

2,108Posts

61Kudos

141Solutions

Re: Freight not on P&L

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

 

MYOB Community Forum

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Accept it as a Solution
Leave a to tell others

Marsh3216
4 Posts
Cover User
Australia
Cover User

4Posts

0Kudos

0Solutions

Re: Freight not on P&L

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
Ultimate Partner
5,861 Posts
Ultimate Partner
New Zealand
Ultimate Partner

5,861Posts

1,026Kudos

756Solutions

Accepted Solution Solved

Re: Freight not on P&L

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


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)

Bulk download of attachments (more details...)

Marsh3216
4 Posts
Cover User
Australia
Cover User

4Posts

0Kudos

0Solutions

Re: Freight not on P&L

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
4 Posts
Cover User
Australia
Cover User

4Posts

0Kudos

0Solutions

Re: Freight not on P&L

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!

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post