A cool and needed feature for MYOB is a detailed gross profit report that we can produce at the end of each month; this needs to be able to list invoices one-by-one with fields like customer name (ma...
Hi there,
Would there be a chance to allow a Profit Report to be generated for invoices? So basically if 20 invoices are sent in one month, a Report could be generated to show how much Gross profit was made across each invoice.
It'd be a great Report to be able to show each invoice and how much Profit was made across each invoice.
Thanks,
Hi John_P
This is similar to another post on the Idea Exchange
- http://community.myob.com/t5/AccountRight-Idea-Exchange/Detailed-Gross-Profit-Report/idi-p/351308
Some of the Add-on solutions will be able to help you. See - http://myob.com.au/addons/
As an Example our software Business Intelligence for Cloud (BI4Cloud) will easily produce the above report (see screen shot below). Then simply change the "Analyse by" Dimension to see the same report and Gross Profit by:
- Customer
- Customer Postcode or State
- Customer Ship to adress ( where you Invoice head office but ship to branches)
- Item
- Custom lists ( e.g. Customer buying groups or Product type)
- Sales rep
- Referal Source
- Supplier
- Job
Add Subtotals Pivots and Filters to combine 2 or more of the above together.
If what you are looking for is Invoices below a set margin then you could simply add a filter to report only sales below a set margin say any below 25%, thne only the exceptions will report. You could set this report to auto email to alert you to issues to investigate.
If you would like to try this on your MYOB data we have a 14 day free trial at - http://www.bi4cloud.com/
I hope this helps.
Jennifer Kelly CA
02 8011 1511